concreteDbConn状态:Open 2025-11-13 08:04:36 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE ([专兼职_代码表].[CodeName] like '%兼职%') and ([人员归属_领域归属].[OSName] like '%三体系人员%') and ([所在省份_省份].[Province] like '%湖北省%') ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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-11-13 08:04:39 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE ([专兼职_代码表].[CodeName] like '%兼职%') and ([人员归属_领域归属].[OSName] like '%三体系人员%') and ([所在省份_省份].[Province] like '%湖北省%') ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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-11-13 08:05:01 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE ([专兼职_代码表].[CodeName] like '%兼职%') and ([人员归属_领域归属].[OSName] like '%三体系人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%湖北省%') ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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-11-13 08:05:04 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode WHERE ([专兼职_代码表].[CodeName] like '%兼职%') and ([人员归属_领域归属].[OSName] like '%三体系人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%湖北省%') ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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-11-13 08:44:28 执行时长：7.25秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E') delete from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-E-200') delete from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-E-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_InvalidDoc where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM GB_ProjectPlan WHERE ID='511000396' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511000396' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511000396' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511000396' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511000396') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511000396' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511000396') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511000396' 2025-11-13 08:44:35 执行时长：7.01秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q') delete from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-Q-200') delete from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_InvalidDoc where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM GB_ProjectPlan WHERE ID='511000398' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511000398' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511000398' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511000398' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511000398') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511000398' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511000398') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511000398' 2025-11-13 08:44:44 执行时长：7.79秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O') delete from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-O-200') delete from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-O-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_InvalidDoc where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditProblem where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_AuditorContactRecord where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanCombine where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b') delete from GB_ProjectPlanTeam where TaskNo = N'e4e6d1f08ff64a6b9ba2b93e3175748b' DELETE FROM GB_ProjectPlan WHERE ID='511000400' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511000400' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511000400' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511000400' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511000400') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511000400' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511000400') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511000400' 2025-11-13 08:44:44 执行时长：7.15秒 sql:delete from base_bizcolumnattach where AccessPath='GB_PlanDoc' and KeyValue='511007799' and DataColumnID='002202' insert into base_bizcolumnattach (id,bizentityid,keyvalue,DataColumnID,filename,createby,accesspath) values ('200593c4dd57241f877','000020008','511007799','002202','质量手册.doc','鲍阳阳','GB_PlanDoc') 2025-11-13 08:44:53 执行时长：7.81秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O') delete from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-O-100') delete from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-O-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_InvalidDoc where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM GB_ProjectPlan WHERE ID='511000401' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511000401' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511000401' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511000401' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511000401') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511000401' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511000401') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511000401' 2025-11-13 08:45:00 执行时长：7.34秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q') delete from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-Q-100') delete from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-Q-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_InvalidDoc where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM GB_ProjectPlan WHERE ID='511000399' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511000399' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511000399' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511000399' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511000399') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511000399' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511000399') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511000399' 2025-11-13 08:45:08 执行时长：7.56秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E') delete from GB_ProjectPlanCerti where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E') delete from GB_CertiDoc where ProjectNo = N'宁夏瑞康恒盛商贸有限公司-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-E-100') delete from GB_ProjectPlanEnergy where PlanNo = N'宁夏瑞康恒盛商贸有限公司-E-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_InvalidDoc where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditProblem where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_AuditorContactRecord where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanCombine where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256') delete from GB_ProjectPlanTeam where TaskNo = N'bfb1858eddc64ab391cadfd9c1a7b256' DELETE FROM GB_ProjectPlan WHERE ID='511000397' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='511000397' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='511000397' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='511000397' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='511000397') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='511000397' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='511000397') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='511000397'