2025-07-11 16:02:38 执行时长：7.42秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'10634-2024-QEO-O_19099') delete from  GB_ProjectPlanCerti where ProjectNo = N'10634-2024-QEO-O_19099' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'10634-2024-QEO-O_19099') delete from  GB_ProjectPlanCerti where ProjectNo = N'10634-2024-QEO-O_19099' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'10634-2024-QEO-O_19099') delete from  GB_CertiDoc where ProjectNo = N'10634-2024-QEO-O_19099' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'10634-2024-QEO-O_19099-500') delete from  GB_ProjectPlanEnergy where PlanNo = N'10634-2024-QEO-O_19099-500' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_AuditProblem where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_AuditProblem where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_InvalidDoc where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_AuditorContactRecord where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_AuditProblem where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_AuditorContactRecord where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanCombine where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c') delete from  GB_ProjectPlanTeam where TaskNo = N'cc78633594394a658ea576bd38cb389c' DELETE FROM GB_ProjectPlan WHERE ID='507000951' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='507000951' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='507000951' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='507000951' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='507000951') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='507000951' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='507000951') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='507000951'

2025-07-11 16:54:58 执行时长：8.47秒 sql:exec [GB_AuditorSchedule] '','','','','','','','','ISC0001'