|
|
|
|
SQL= SELECT NodeID, Name, Tip, Step, FormType, FormUrl, ICON, NodeWorkType, SubThreadType, FK_Flow, IsGuestNode, CondModel, IsShowReturnNodeInToolbar, TurnToDeal, TurnToDealDoc, BlockModel, BlockExp, IsSendDraftSubFlow, FrmAttr, ReturnRole, FWCSta, RunModel, TodolistModel, StartLimitRole, BatchRole, CHWay, OutTimeDeal, CCWriteTo, DoOutTime, X, Y, DeliveryWay, DeliveryParas, IsAutoLoadEmps, AtPara FROM WF_Node WHERE (1=1) AND WF_Node.NodeID=@NodeID Exception=Unknown column 'SubThreadType' in 'field list'
|
|
|
|
|
SQL= SELECT NodeID, FK_Flow, FlowName, Name, WhoExeIt, CASE WhoExeIt WHEN 0 THEN '<27><><EFBFBD><EFBFBD>Աִ<D4B1><D6B4>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD>ִ<EFBFBD><D6B4>' WHEN 2 THEN '<27><><EFBFBD><EFBFBD>ִ<EFBFBD><D6B4>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>Աִ<D4B1><D6B4>' END "WhoExeItText", ReadReceipts, CASE ReadReceipts WHEN 0 THEN '<27><><EFBFBD><EFBFBD>ִ' WHEN 1 THEN '<27>Զ<EFBFBD><D4B6><EFBFBD>ִ' WHEN 2 THEN '<27><><EFBFBD><EFBFBD>һ<EFBFBD>ڵ<EFBFBD><DAB5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֶξ<D6B6><CEBE><EFBFBD>' WHEN 3 THEN '<27><>SDK<44><4B><EFBFBD><EFBFBD><EFBFBD>߲<EFBFBD><DFB2><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>ִ' END "ReadReceiptsText", CancelRole, CASE CancelRole WHEN 0 THEN '<27><>һ<EFBFBD><D2BB><EFBFBD><EFBFBD><EFBFBD>Գ<EFBFBD><D4B3><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD>ܳ<EFBFBD><DCB3><EFBFBD>' WHEN 2 THEN '<27><>һ<EFBFBD><D2BB><EFBFBD>뿪ʼ<EBBFAA>ڵ<EFBFBD><DAB5><EFBFBD><EFBFBD>Գ<EFBFBD><D4B3><EFBFBD>' WHEN 3 THEN 'ָ<><D6B8><EFBFBD>Ľڵ<C4BD><DAB5><EFBFBD><EFBFBD>Գ<EFBFBD><D4B3><EFBFBD>' WHEN NULL THEN '<27><>һ<EFBFBD><D2BB><EFBFBD><EFBFBD><EFBFBD>Գ<EFBFBD><D4B3><EFBFBD>' END "CancelRoleText", IFNULL( CancelDisWhenRead,0) CancelDisWhenRead, IFNULL( IsOpenOver,0) IsOpenOver, IFNULL( ResetAccepter,0) ResetAccepter, IFNULL( IsSendDraftSubFlow,0) IsSendDraftSubFlow, IFNULL( IsGuestNode,0) IsGuestNode, IFNULL( IsYouLiTai,0) IsYouLiTai, FocusField, FWCSta, FWCAth, DeliveryWay, SelfParas, Step, Tip, RunModel, CASE RunModel WHEN 0 THEN '<27><><EFBFBD><EFBFBD>' WHEN 1 THEN '<27><><EFBFBD><EFBFBD>' WHEN 2 THEN '<27><><EFBFBD><EFBFBD>' WHEN 3 THEN '<27>ֺ<EFBFBD><D6BA><EFBFBD>' WHEN 4 THEN 'ͬ<><CDAC><EFBFBD><EFBFBD>' WHEN 5 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' WHEN NULL THEN '<27><><EFBFBD><EFBFBD>' END "RunModelText", IFNULL( PassRate ,100) PassRate, IFNULL(ThreadIsCanDel,1) ThreadIsCanDel, IFNULL(ThreadIsCanAdd,1) ThreadIsCanAdd, IFNULL( ThreadIsCanShift,0) ThreadIsCanShift, USSWorkIDRole, CASE USSWorkIDRole WHEN 0 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><D2BB>WorkID' WHEN 1 THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>WorkID' WHEN NULL THEN '<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><D2BB>WorkID' END "USSWorkIDRoleText", IFNULL( IsSendBackNode,0) IsSendBackNode, IFNULL( AutoJumpRole0,0) AutoJumpRole0, IFNULL( AutoJumpRole1,0) AutoJumpRole1, IFNULL( AutoJumpRole2,0) AutoJumpRole2, IFNULL( WhenNoWorker,0) WhenNoWorker, AutoJumpExp, SkipTime, CASE SkipTime WHEN 0 THEN '<27><>һ<EFBFBD><D2BB><EFBFBD>ڵ㷢<DAB5><E3B7A2>ʱ' WHEN 1 THEN '<27><>ǰ<EFBFBD>ڵ㹤<DAB5><E3B9A4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ' WHEN NULL THEN '<27><>һ<EFBFBD><D2BB><EFBFBD>ڵ㷢<DAB5><E3B7A2>ʱ' END "SkipTimeText",IFNULL(SendLab, '<27><><EFBFBD><EFBFBD>') SendLab, SendJS,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( FrmDBVerMyView,0) FrmDBVerMyView, IFNULL( FrmDBVerMyCC,0) FrmDBVerMyCC,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 THE
|
|
|
|
|
SQL= SELECT MyPK, RefPKVal, FlowNo, NodeID, EventNo, EventName, PushWayNo, PushWayName, PushWayExp1, PushWayExp2, IFNULL(IsEnableSMS,1) IsEnableSMS, SMSDoc, IFNULL(IsEnableEmail,1) IsEnableEmail, MailTitle, MailDoc, IFNULL(DD,1) DD, IFNULL(WeChat,1) WeChat, IFNULL(Msg,1) Msg, IFNULL(WebServices,1) WebServices, AtPara FROM WF_PushMsg WHERE (1=1) AND ( ( WF_PushMsg.FlowNo =@FlowNo) AND ( WF_PushMsg.RefPKVal =@RefPKVal) ) Exception=Unknown column 'RefPKVal' in 'field list'
|