concreteDbConn状态:Open 2025-09-17 11:03:13 Sql：select count([~ID~]) from ( SELECT DISTINCT 审核组组成.ID as [~ID~] ,审核组组成.[ID] AS [系统主键],审核组组成.[TaskNo] AS [任务编号],[标准代码_认证标准].StandardCode AS [标准代码],[人员编号_人员信息表].AuditorCode AS [人员编号],审核组组成.[AuditorName] AS [姓名],[性别_代码表].CodeName AS [性别],[组内职责_代码表].CodeName AS [组内职责],[审核方式_审核方式].ApproveMode AS [审核方式],[注册级别_人员资质类型].QCName AS [注册级别] FROM GB_ProjectPlanTeam 审核组组成 WITH(NOLOCK) LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核组组成.StandardCode = [标准代码_认证标准].ID LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 审核组组成.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 审核组组成.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 审核组组成.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核组组成.ApproveMode = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 审核组组成.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 审核组组成.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Base_OrgV [人员来源_合同来源] WITH(NOLOCK) ON 审核组组成.Org = [人员来源_合同来源].Org where 1=1 and ([审核组组成].[计划编号] = '[审议问题].[计划编号]') ) as CurrentCount Error：列名 '计划编号' 无效。 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207 2025-09-17 11:28:52 执行时长：9.83秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'11122-2025-Q-Q') delete from GB_CertiDoc where ProjectNo = N'11122-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'11122-2025-Q-Q-100') delete from GB_ProjectPlanEnergy where PlanNo = N'11122-2025-Q-Q-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_AuditProblem where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_AuditProblem where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_InvalidDoc where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_AuditorContactRecord where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_AuditProblem where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_AuditorContactRecord where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanCombine where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c') delete from GB_ProjectPlanTeam where TaskNo = N'd732b6fa4dd6410a8ded98677a3a911c' DELETE FROM GB_ProjectPlan WHERE ID='509000185' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='509000185' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='509000185' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='509000185' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='509000185') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='509000185' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='509000185') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='509000185' 2025-09-17 11:28:54 执行时长：7.45秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[审核类型_审核类型].TypeName AS [审核类型],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].StandardCode AS [标准代码],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],[审核方式_审核方式].ApproveMode AS [审核方式],审核计划.[PlanRemarks] AS [计划备注],审核计划.[CommitDate] AS [审核员交卷日期],(case 审核计划.[IsReform] when 1 then '√' else '' end) AS [已整改],审核计划.[ReformDate] AS [整改完成日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK) LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK) ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='11' AND [审核组组成].[AuditorCode] = 'ISC-244880' AND [评定状态_评定状态].[StatusName] = '问题档' AND [审核计划].[IsReform] =0 AND [审核组组成].[Duty] = '190') AND ([审核计划].BeginDate>='2025-06-17 00:00') ) as CurrentCount 2025-09-17 11:29:02 执行时长：9.75秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q') delete from GB_ProjectPlanCerti where ProjectNo = N'11122-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from GB_CertiDoc where ProjectNo = N'11122-2025-Q-Q') delete from GB_CertiDoc where ProjectNo = N'11122-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from GB_ProjectPlanEnergy where PlanNo = N'11122-2025-Q-Q-200') delete from GB_ProjectPlanEnergy where PlanNo = N'11122-2025-Q-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_AuditProblem where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_AuditProblem where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from GB_InvalidDoc where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_InvalidDoc where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_AuditorContactRecord where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from GB_AuditProblem where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_AuditProblem where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from GB_AuditorContactRecord where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_AuditorContactRecord where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanCombine where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93') delete from GB_ProjectPlanTeam where TaskNo = N'f1bf9135619d49b2b09134bb2ef9db93' DELETE FROM GB_ProjectPlan WHERE ID='509000184' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='509000184' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='509000184' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='509000184' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='509000184') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='509000184' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='509000184') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='509000184' 2025-09-17 11:29:38 执行时长：5.36秒 sql:exec [GB_AuditorSchedule] '2025-09-01','','','','','','','0.5','ISC0601'