concreteDbConn状态:Open 2025-07-23 10:10:51 Sql：select distinct a.id,a.DocFile,'https://oa.china-isc.org.cn/bizattach'+'/approvedoc/83d0196efbca4ed7b27716c1f6f7ef0d/'+a.DocFile as Url 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 ('31') 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-23 10:11:37 Sql：select distinct a.id,a.DocFile,'https://oa.china-isc.org.cn/bizattach'+'/approvedoc/83d0196efbca4ed7b27716c1f6f7ef0d/'+a.DocFile as Url 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 ('31') 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-23 10:14:19 Sql：select distinct a.id,a.DocFile,'https://oa.china-isc.org.cn/bizattach'+'/approvedoc/83d0196efbca4ed7b27716c1f6f7ef0d/'+a.DocFile as Url 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 ('31') 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-23 10:14:29 Sql：select distinct a.id,a.DocFile,'https://oa.china-isc.org.cn/bizattach'+'/approvedoc/83d0196efbca4ed7b27716c1f6f7ef0d/'+a.DocFile as Url 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 ('31') 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 2025-07-23 10:42:10 执行时长：7.42秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-E') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-E') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-E') delete from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-E-201') delete from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-E-201' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM GB_ProjectPlan WHERE ID='506000763' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='506000763' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='506000763' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='506000763' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='506000763') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='506000763' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='506000763') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='506000763' 2025-07-23 10:42:17 执行时长：7.08秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-Q') delete from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-Q-201') delete from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-Q-201' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM GB_ProjectPlan WHERE ID='506000764' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='506000764' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='506000764' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='506000764' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='506000764') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='506000764' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='506000764') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='506000764' 2025-07-23 10:42:24 执行时长：6.56秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-O') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-O') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-O') delete from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-O-201') delete from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-O-201' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM GB_ProjectPlan WHERE ID='506000765' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='506000765' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='506000765' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='506000765' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='506000765') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='506000765' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='506000765') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='506000765' 2025-07-23 10:42:31 执行时长：7.13秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-HSSE') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-HSSE' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-HSSE') delete from GB_ProjectPlanCerti where ProjectNo = N'10708-2025-QEOHSSE-HSSE' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-HSSE') delete from GB_CertiDoc where ProjectNo = N'10708-2025-QEOHSSE-HSSE' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-HSSE-201') delete from GB_ProjectPlanEnergy where PlanNo = N'10708-2025-QEOHSSE-HSSE-201' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_InvalidDoc where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditProblem where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_AuditorContactRecord where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanCombine where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f') delete from GB_ProjectPlanTeam where TaskNo = N'fdc0efc7ab684dadae498446e141a65f' DELETE FROM GB_ProjectPlan WHERE ID='506000766' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='506000766' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='506000766' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='506000766' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='506000766') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='506000766' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='506000766') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='506000766' 2025-07-23 10:58:04 执行时长：5.83秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK) LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount