You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

21 lines
8.7 KiB
Plaintext

11 months ago
2023-04-19 11:56:54.9875|ERROR|
λ<EFBFBD>ã<EFBFBD>BP.DA.DBAccess.RunSQLReturnTable(D:\CCFlowCloud\Components\BP.En30\DA\DBAccess.cs:3126)
SQL= SELECT NodeID, Name,IFNULL(SendLab, '<27><><EFBFBD><EFBFBD>') SendLab, SendJS,IFNULL(DelayedSendLab, '<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD>') DelayedSendLab, IFNULL( DelayedSendEnable,0) DelayedSendEnable,IFNULL(SaveLab, '<27><><EFBFBD><EFBFBD>') SaveLab, IFNULL(SaveEnable,1) SaveEnable,IFNULL(CCLab, '<27><><EFBFBD><EFBFBD>') CCLab, CCRole, CASE CCRole WHEN 0 THEN '<27><><EFBFBD>ܳ<EFBFBD><DCB3><EFBFBD>' WHEN 1 THEN '<27>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>' WHEN 2 THEN '<27>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD>' WHEN 3 THEN '<27>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD>Զ<EFBFBD>' WHEN 4 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>SysCCEmps<70>ֶμ<D6B6><CEBC><EFBFBD>' WHEN 5 THEN '<27>ڷ<EFBFBD><DAB7><EFBFBD>ǰ<EFBFBD>򿪳<EFBFBD><F2BFAAB3>ʹ<EFBFBD><CDB4><EFBFBD>' WHEN NULL THEN '<27><><EFBFBD>ܳ<EFBFBD><DCB3><EFBFBD>' END "CCRoleText",IFNULL(QRCodeLab, '<27><>ά<EFBFBD><CEAC>') QRCodeLab, QRCodeRole, CASE QRCodeRole WHEN 0 THEN '<27><>' WHEN 1 THEN '<27><EFBFBD><E9BFB4><EFBFBD>̱<EFBFBD><CCB1><EFBFBD>-<2D><><EFBFBD><EFBFBD>Ȩ<EFBFBD><C8A8>' WHEN 2 THEN '<27><EFBFBD><E9BFB4><EFBFBD>̱<EFBFBD><CCB1><EFBFBD>-<2D><>Ҫ<EFBFBD><D2AA>¼' WHEN 3 THEN '<27>ⲿ<EFBFBD>˻<EFBFBD>Э<EFBFBD><D0AD>ģʽ<C4A3><CABD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN NULL THEN '<27><>' END "QRCodeRoleText",IFNULL(ShiftLab, '<27>ƽ<EFBFBD>') ShiftLab, IFNULL( ShiftEnable,0) ShiftEnable,IFNULL(DelLab, 'ɾ<><C9BE>') DelLab, DelEnable, CASE DelEnable WHEN 0 THEN '<27><><EFBFBD><EFBFBD>ɾ<EFBFBD><C9BE>' WHEN 1 THEN '<27>߼<EFBFBD>ɾ<EFBFBD><C9BE>' WHEN 2 THEN '<27><>¼<EFBFBD><C2BC>־<EFBFBD><D6BE>ʽɾ<CABD><C9BE>' WHEN 3 THEN '<27><><EFBFBD><EFBFBD>ɾ<EFBFBD><C9BE>' WHEN 4 THEN '<27><><EFBFBD>û<EFBFBD><C3BB><EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><C9BE><EFBFBD><EFBFBD>ʽ' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>ɾ<EFBFBD><C9BE>' END "DelEnableText",IFNULL(EndFlowLab, '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') EndFlowLab, IFNULL( EndFlowEnable,0) EndFlowEnable,IFNULL(ShowParentFormLab, '<27><EFBFBD><E9BFB4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') ShowParentFormLab, IFNULL( ShowParentFormEnable,0) ShowParentFormEnable,IFNULL(OfficeBtnLab, '<27>򿪹<EFBFBD><F2BFAAB9><EFBFBD>') OfficeBtnLab, OfficeBtnEnable, CASE OfficeBtnEnable WHEN 0 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN 1 THEN '<27>ɱ༭' WHEN 2 THEN '<27><><EFBFBD>ɱ༭' WHEN NULL THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' END "OfficeBtnEnableText", OfficeFileType, CASE OfficeFileType WHEN 0 THEN 'word<72>ļ<EFBFBD>' WHEN 1 THEN 'WPS<50>ļ<EFBFBD>' WHEN NULL THEN 'word<72>ļ<EFBFBD>' END "OfficeFileTypeText", OfficeBtnLocal, CASE OfficeBtnLocal WHEN 0 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ǩ(divID=GovDocFile)' WHEN NULL THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' END "OfficeBtnLocalText",IFNULL(TrackLab, '<27>켣') TrackLab, IFNULL(TrackEnable,1) TrackEnable,IFNULL(HungLab, '<27><><EFBFBD><EFBFBD>') HungLab, IFNULL( HungEnable,0) HungEnable,IFNULL(SearchLab, '<27><>ѯ') SearchLab, IFNULL( SearchEnable,0) SearchEnable,IFNULL(TCLab, '<27><>ת<EFBFBD>Զ<EFBFBD><D4B6><EFBFBD>') TCLab, IFNULL( TCEnable,0) TCEnable,IFNULL(FrmDBVerLab, '<27><><EFBFBD>ݰ汾') FrmDBVerLab, IFNULL( FrmDBVerEnable,0) FrmDBVerEnable,IFNULL(FrmDBRemarkLab, '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') FrmDBRemarkLab, FrmDBRemarkEnable, CASE FrmDBRemarkEnable WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27>ɱ༭' WHEN 2 THEN '<27><><EFBFBD>ɱ༭' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "FrmDBRemarkEnableText",IFNULL(PRILab, '<27><>Ҫ<EFBFBD><D2AA>') PRILab, PRIEnable, CASE PRIEnable WHEN 0 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN 1 THEN 'ֻ<><D6BB>' WHEN 2 THEN '<27>༭' WHEN NULL THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' END "PRIEnableText",IFNULL(CHLab, '<27>ڵ<EFBFBD>ʱ<EFBFBD><CAB1>') CHLab, CHRole, CASE CHRole WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD>' WHEN 2 THEN 'ֻ<><D6BB>' WHEN 3 THEN '<27><><EFBFBD>ò<EFBFBD><C3B2><EFBFBD><EFBFBD>Ե<EFBFBD><D4B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ӧ<EFBFBD><D3A6><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "CHRoleText",IFNULL(AllotLab, '<27><><EFBFBD><EFBFBD>') AllotLab, IFNULL( AllotEnable,0) AllotEnable,IFNULL(FocusLab, '<27><>ע') FocusLab, IFNULL( FocusEnable,0) FocusEnable,IFNULL(ConfirmLab, 'ȷ<><C8B7>') ConfirmLab, IFNULL( ConfirmEnable,0) ConfirmEnable,IFNULL(ListLab, '<27>б<EFBFBD>') ListLab, IFNULL(ListEnable,1) ListEnable,IFNULL(BatchLab, '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') BatchLab, IFNULL( BatchEnable,0) BatchEnable,IFNULL(NoteLab, '<27><>ע') NoteLab, NoteEnable, CASE NoteEnable WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD>' WHEN 2 THEN 'ֻ<><D6BB>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "NoteEnableText",IFNULL(HelpLab, '<27><><EFBFBD><EFBFBD>') HelpLab, HelpRole, CASE HelpRole WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD>' WHEN 2 THEN 'ǿ<><C7BF><EFBFBD><EFBFBD>ʾ' WHEN 3 THEN 'ѡ<><D1A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʾ' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "HelpRoleText",IFNULL(ScripLab, 'Сֽ<D0A1><D6BD>') ScripLab, ScripRole, CASE ScripRole WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><>ť<EFBFBD><C5A5><EFBFBD><EFBFBD>' WHEN 2 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "ScripRoleText",IFNULL(FlowBBSLab, '<27><><EFBFBD><EFBFBD>') FlowBBSLab, FlowBBSRole, CASE FlowBBSRole WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD>' WHEN 2 THEN 'ֻ<><D6BB>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "FlowBBSRoleText",IFNULL(IMLab, '<27><>ʱͨѶ') IMLab, IMEnable, CASE IMEnable WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "IMEnableText",IFNULL(NextLab, '<27><>һ<EFBFBD><D2BB>') NextLab, NextRole, CASE NextRole WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><>ͬ<EFBFBD>ڵ<EFBFBD>' WHEN 2 THEN '<27><>ͬ<EFBFBD><CDAC><EFBFBD><EFBFBD>' WHEN 3 THEN '<27><>ͬ<EFBFBD><CDAC><EFBFBD><EFBFBD>' WHEN 4 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "NextRoleText",IFNULL(ThreadLab, '<27><><EFBFBD>߳<EFBFBD>') ThreadLab, IFNULL( ThreadEnable,0) ThreadEnable,
2023-04-19 11:57:09.1523|ERROR|
λ<EFBFBD>ã<EFBFBD>BP.DA.DBAccess.RunSQLReturnTable(D:\CCFlowCloud\Components\BP.En30\DA\DBAccess.cs:3126)
SQL=SELECT CONCAT('Emp_',No) AS No, Name, FK_Dept FROM Port_Emp WHERE FK_Dept='1003' UNION SELECT CONCAT('Emp_',A.No) AS No,A.Name, A.FK_Dept FROM Port_Emp A, Port_DeptEmp B WHERE A.No=B.FK_Emp AND B.FK_Dept='1003' ORDER BY A.Idx Exception=Unknown column 'A.Idx' in 'order clause'
2023-04-19 12:00:54.8589|ERROR|
λ<EFBFBD>ã<EFBFBD>BP.DA.DBAccess.RunSQLReturnTable(D:\CCFlowCloud\Components\BP.En30\DA\DBAccess.cs:3126)
SQL=SELECT CONCAT('Emp_',No) AS No, Name, FK_Dept FROM Port_Emp WHERE FK_Dept='1003' ORDER BY Idx UNION SELECT CONCAT('Emp_',A.No) AS No,A.Name, A.FK_Dept FROM Port_Emp A, Port_DeptEmp B WHERE A.No=B.FK_Emp AND B.FK_Dept='1003' ORDER BY A.Idx Exception=Incorrect usage of UNION and ORDER BY
2023-04-19 12:02:06.2976|ERROR|
λ<EFBFBD>ã<EFBFBD>BP.DA.DBAccess.RunSQLReturnTable(D:\CCFlowCloud\Components\BP.En30\DA\DBAccess.cs:3126)
SQL=SELECT CONCAT('Emp_',No) AS No, Name, FK_Dept FROM Port_Emp WHERE FK_Dept='1003' ORDER BY Idx UNION SELECT CONCAT('Emp_',A.No) AS No,A.Name, A.FK_Dept FROM Port_Emp A, Port_DeptEmp B WHERE A.No=B.FK_Emp AND B.FK_Dept='1003' ORDER BY A.Idx Exception=Incorrect usage of UNION and ORDER BY