2025-07-10 16:05:27 执行时长：8.41秒 sql:exec [GB_AuditorSchedule] '2025-07-01','','','','','','123','0.5','ISC0601'

2025-07-10 16:37:45 执行时长：10.75秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'30074-2025-R19-R19') delete from  GB_ProjectPlanCerti where ProjectNo = N'30074-2025-R19-R19' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'30074-2025-R19-R19') delete from  GB_ProjectPlanCerti where ProjectNo = N'30074-2025-R19-R19' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'30074-2025-R19-R19') delete from  GB_CertiDoc where ProjectNo = N'30074-2025-R19-R19' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'30074-2025-R19-R19-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'30074-2025-R19-R19-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_InvalidDoc where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM GB_ProjectPlan WHERE ID='507000572' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='507000572' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='507000572' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='507000572' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='507000572') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='507000572' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='507000572') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='507000572'

2025-07-10 16:37:55 执行时长：9.81秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'30073-2025-R14-R14') delete from  GB_ProjectPlanCerti where ProjectNo = N'30073-2025-R14-R14' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'30073-2025-R14-R14') delete from  GB_ProjectPlanCerti where ProjectNo = N'30073-2025-R14-R14' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'30073-2025-R14-R14') delete from  GB_CertiDoc where ProjectNo = N'30073-2025-R14-R14' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'30073-2025-R14-R14-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'30073-2025-R14-R14-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_InvalidDoc where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditProblem where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_AuditorContactRecord where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanCombine where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9') delete from  GB_ProjectPlanTeam where TaskNo = N'53f3c5feb8c542608e435e80bcb7e8c9' DELETE FROM GB_ProjectPlan WHERE ID='507000883' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='507000883' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='507000883' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='507000883' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='507000883') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='507000883' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='507000883') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='507000883'
concreteDbConn状态:Open
2025-07-10 16:39:57
Sql：select distinct a.DocFile as id,a.DocFile,'https://oa.china-isc.org.cn/bizattach'+'/approvedoc/9d1a22f880ed4c8b824470bb0188c147/'+a.DocFile as Url,'' as CreationTime  from Pub_ApproveDoc a left join Pub_ApproveDocSystem b on a.DocCode=b.DocCode   left join Pub_ApproveDocType c on a.DocCode = c.DocCode  where b.FieldCode in () and c.ApproveClass in ('20')
Error：“)”附近有语法错误。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207
concreteDbConn状态:Open
2025-07-10 16:41:45
Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类  from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID   left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode   left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode   left join Pub_Province e on a.Province=e.ProvinceCode   left join Base_Org f on a.Org=f.OrgID   left join Pub_Code g on a.WorkType=g.CodeID  left join  GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-10'' and IsEffective=''27''   left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode   left join Pub_ProfessionalCode j on i.professionalcode=j.id   where 1=1  and a.AuditorName like ''%吉洁%'' and a.AuditorCode in (SELECT AuditorCode  FROM GB_AuditorRegister  WHERE StandardCode IN() and IsEffective = ''27''  GROUP BY AuditorCode  HAVING COUNT(DISTINCT StandardCode) >= 0)  and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join   Base_OrgV b on a.OrgID=b.Org where P_orgID=''0001'') or a.ispublic=1 )  group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName,  a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = ''
Error：“)”附近有语法错误。
关键字 'or' 附近有语法错误。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207
concreteDbConn状态:Open
2025-07-10 16:41:45
Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类  from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID   left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode   left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode   left join Pub_Province e on a.Province=e.ProvinceCode   left join Base_Org f on a.Org=f.OrgID   left join Pub_Code g on a.WorkType=g.CodeID  left join  GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-10' and IsEffective='27'   left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode   left join Pub_ProfessionalCode j on i.professionalcode=j.id   where 1=1  and a.AuditorName like '%吉洁%' and a.AuditorCode in (SELECT AuditorCode  FROM GB_AuditorRegister  WHERE StandardCode IN() and IsEffective = '27'  GROUP BY AuditorCode  HAVING COUNT(DISTINCT StandardCode) >= 0)  and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join   Base_OrgV b on a.OrgID=b.Org where P_orgID='0001') or a.ispublic=1 )  group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName,  a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount
Error：“)”附近有语法错误。
关键字 'or' 附近有语法错误。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207

2025-07-10 16:52:06 执行时长：6.39秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''25''  or [审核计划].org =''2501'' )) AND ( [计划状态_计划状态].[StatusName] = ''待安排'') ',@PageSize = 100, @PageCurrent = 3, @FdShow = '',@FdOrder = '[组织名称] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC,[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''25''  or [审核计划].org =''2501'' )) AND ( [计划状态_计划状态].[StatusName] = ''待安排'')'