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

2025-09-02 14:01:10 执行时长：5.73秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN 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 Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >='10'   AND [审核组组成].[AuditorCode] = 'ISC-341354') AND ( 1=1 ) ) as CurrentCount

2025-09-02 14:03:17 执行时长：6.05秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:17 执行时长：9.61秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:24 执行时长：7.12秒 sql:select BizflowActionState from wf_Bizflowinstancedetail a WITH(NOLOCK) left join wf_Bizflowaction b on a.Bizflowactionid=b.id  left join base_user c on a.operatorid=c.userid left join base_user d on a.accredituser=d.userid  where Bizflowinstanceid='10929' order by a.startdate,a.id

2025-09-02 14:03:27 执行时长：9.59秒 sql:SELECT distinct a.ID,	BizflowCode,	IsBottom,	BizFlowName,	a.[Description],	BeginDate,	EndDate,	a.BizEntityID,	a.DataEntityID,	EntityClass,	MessageDesc FROM wf_Bizflow a left join wf_bizflowaction b on a.id=b.bizflowid  WHERE b.bizentityid=@bizEntityID

2025-09-02 14:03:28 执行时长：10.22秒 sql:select BizflowActionState from wf_Bizflowinstancedetail a WITH(NOLOCK) left join wf_Bizflowaction b on a.Bizflowactionid=b.id  left join base_user c on a.operatorid=c.userid left join base_user d on a.accredituser=d.userid  where Bizflowinstanceid='11516' order by a.startdate,a.id

2025-09-02 14:03:28 执行时长：10.82秒 sql:select BizflowActionState from wf_Bizflowinstancedetail a WITH(NOLOCK) left join wf_Bizflowaction b on a.Bizflowactionid=b.id  left join base_user c on a.operatorid=c.userid left join base_user d on a.accredituser=d.userid  where Bizflowinstanceid='11725' order by a.startdate,a.id

2025-09-02 14:03:30 执行时长：13.54秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],(case 审核计划.[SuperNoticeSent] when 1 then ''√'' else '''' end) AS [监审通知],[审核类别_审核类别].ClassName AS [审核类别],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],审核计划.[AuditTeam] AS [审核组],审核计划.[PlanNo] AS [计划编号],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],[省份_省份].Province AS [省份],[审核类型_审核类型].TypeName AS [审核类型],审核计划.[SuperQty] AS [监督周期],审核计划.[ReCertiQty] AS [复评周期],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[TotalDays] AS [现场总人日],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[PlanApproveDate] AS [预计审核日期],(case 审核计划.[ToSchedule] when 1 then ''√'' else '''' end) AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([计划状态_计划状态].[StatusName] in (''待联系'',''退回'') ) AND (审核计划.SuperNoticeSent = ''1'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[监审最后日期] DESC,[组织名称] ASC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[SuperviseEndDate] AS [监审最后日期],[组织名称_组织信息].CorpName 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([计划状态_计划状态].[StatusName] in (''待联系'',''退回'') ) AND (审核计划.SuperNoticeSent = ''1'')'

2025-09-02 14:03:31 执行时长：6.08秒 sql:select BizflowActionState from wf_Bizflowinstancedetail a WITH(NOLOCK) left join wf_Bizflowaction b on a.Bizflowactionid=b.id  left join base_user c on a.operatorid=c.userid left join base_user d on a.accredituser=d.userid  where Bizflowinstanceid='506000276ISC3201' order by a.startdate,a.id

2025-09-02 14:03:31 执行时长：14.22秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:31 执行时长：7.54秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],(case 审核计划.[SuperNoticeSent] when 1 then '√' else '' end) AS [监审通知],[审核类别_审核类别].ClassName AS [审核类别],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],审核计划.[AuditTeam] AS [审核组],审核计划.[PlanNo] AS [计划编号],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],[省份_省份].Province AS [省份],[审核类型_审核类型].TypeName AS [审核类型],审核计划.[SuperQty] AS [监督周期],审核计划.[ReCertiQty] AS [复评周期],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[TotalDays] AS [现场总人日],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[PlanApproveDate] AS [预计审核日期],(case 审核计划.[ToSchedule] when 1 then '√' else '' end) AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([计划状态_计划状态].[StatusName] in ('待联系','退回') ) AND ([组织名称_组织信息].[CorpName] like '%广东世尧茶饮供应链有限公司%') ) as CurrentCount

2025-09-02 14:03:44 执行时长：8.79秒 sql:SELECT distinct a.ID,	BizflowCode,	IsBottom,	BizFlowName,	a.[Description],	BeginDate,	EndDate,	a.BizEntityID,	a.DataEntityID,	EntityClass,	MessageDesc FROM wf_Bizflow a left join wf_bizflowaction b on a.id=b.bizflowid  WHERE b.bizentityid=@bizEntityID

2025-09-02 14:03:44 执行时长：8.4秒 sql:select BizflowActionState from wf_Bizflowinstancedetail a WITH(NOLOCK) left join wf_Bizflowaction b on a.Bizflowactionid=b.id  left join base_user c on a.operatorid=c.userid left join base_user d on a.accredituser=d.userid  where Bizflowinstanceid='13661' order by a.startdate,a.id

2025-09-02 14:03:44 执行时长：8.19秒 sql:SELECT distinct a.ID,	BizflowCode,	IsBottom,	BizFlowName,	a.[Description],	BeginDate,	EndDate,	a.BizEntityID,	a.DataEntityID,	EntityClass,	MessageDesc FROM wf_Bizflow a left join wf_bizflowaction b on a.id=b.bizflowid  WHERE b.bizentityid=@bizEntityID

2025-09-02 14:03:44 执行时长：12.58秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:44 执行时长：12.59秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:47 执行时长：16.15秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],(case 审核计划.[SuperNoticeSent] when 1 then ''√'' else '''' end) AS [监审通知],[审核类别_审核类别].ClassName AS [审核类别],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],审核计划.[AuditTeam] AS [审核组],审核计划.[PlanNo] AS [计划编号],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],[省份_省份].Province AS [省份],[审核类型_审核类型].TypeName AS [审核类型],审核计划.[SuperQty] AS [监督周期],审核计划.[ReCertiQty] AS [复评周期],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[TotalDays] AS [现场总人日],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[PlanApproveDate] AS [预计审核日期],(case 审核计划.[ToSchedule] when 1 then ''√'' else '''' end) AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([计划状态_计划状态].[StatusName] in (''待联系'',''退回'') ) AND ([组织名称_组织信息].[CorpName] like ''%广东世尧茶饮供应链有限公司%'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[监审最后日期] DESC,[组织名称] ASC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[SuperviseEndDate] AS [监审最后日期],[组织名称_组织信息].CorpName 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([计划状态_计划状态].[StatusName] in (''待联系'',''退回'') ) AND ([组织名称_组织信息].[CorpName] like ''%广东世尧茶饮供应链有限公司%'')'

2025-09-02 14:03:50 执行时长：6.88秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:50 执行时长：6.92秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:50 执行时长：32.29秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:50 执行时长：5.85秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:50 执行时长：5.22秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:50 执行时长：6.89秒 sql:select a.id as Bizflowinstanceid,BizflowState from wf_Bizflowinstance a WITH(NOLOCK) left join wf_Bizflow b on a.Bizflowid=b.id  left join wf_bizflowinstancedetail c WITH(NOLOCK) on a.id=c.bizflowinstanceid  where c.bizentityid=@bizEntityID and c.rowid=@keyValue and b.id=@bizflowID order by a.id desc

2025-09-02 14:03:54 执行时长：45.59秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],(case 审核计划.[SuperNoticeSent] when 1 then '√' else '' end) AS [监审通知],[审核类别_审核类别].ClassName AS [审核类别],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],审核计划.[AuditTeam] AS [审核组],审核计划.[PlanNo] AS [计划编号],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],[省份_省份].Province AS [省份],[审核类型_审核类型].TypeName AS [审核类型],审核计划.[SuperQty] AS [监督周期],审核计划.[ReCertiQty] AS [复评周期],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[TotalDays] AS [现场总人日],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[PlanApproveDate] AS [预计审核日期],(case 审核计划.[ToSchedule] when 1 then '√' else '' end) AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [计划状态_计划状态].[StatusName] in ('待联系','退回')  ) as CurrentCount

2025-09-02 14:03:54 执行时长：38.14秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],(case 审核计划.[SuperNoticeSent] when 1 then '√' else '' end) AS [监审通知],[审核类别_审核类别].ClassName AS [审核类别],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],审核计划.[AuditTeam] AS [审核组],审核计划.[PlanNo] AS [计划编号],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],[省份_省份].Province AS [省份],[审核类型_审核类型].TypeName AS [审核类型],审核计划.[SuperQty] AS [监督周期],审核计划.[ReCertiQty] AS [复评周期],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[TotalDays] AS [现场总人日],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[PlanApproveDate] AS [预计审核日期],(case 审核计划.[ToSchedule] when 1 then '√' else '' end) AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [计划状态_计划状态].[StatusName] in ('待联系','退回')  ) as CurrentCount

2025-09-02 14:04:56 执行时长：6.06秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],(case 审核计划.[SuperNoticeSent] when 1 then '√' else '' end) AS [监审通知],[审核类别_审核类别].ClassName AS [审核类别],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],审核计划.[AuditTeam] AS [审核组],审核计划.[PlanNo] AS [计划编号],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],[省份_省份].Province AS [省份],[审核类型_审核类型].TypeName AS [审核类型],审核计划.[SuperQty] AS [监督周期],审核计划.[ReCertiQty] AS [复评周期],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[TotalDays] AS [现场总人日],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[PlanApproveDate] AS [预计审核日期],(case 审核计划.[ToSchedule] when 1 then '√' else '' end) AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] 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_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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 Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([计划状态_计划状态].[StatusName] in ('待联系','退回') ) AND ( 1=1 ) ) as CurrentCount

2025-09-02 14:11:05 执行时长：9.06秒 sql:select top 12  b.ID,b.BizEntityName,b.BizClass,COUNT(b.ID)  from Base_Log a inner join Base_BizEntity b on a.ModuleName=b.BizEntityName  where UserName = @userName and b.EntityClass = 1 and BizEntityName <> '系统'  group by b.ID, b.BizEntityName, b.BizClass  order by COUNT(b.ID) desc 

2025-09-02 14:11:21 执行时长：6.49秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[AcceptDate] AS [受理日期],[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],审核计划.[DispatchBy] AS [审核派遣人],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND ( [计划状态_计划状态].[StatusCode] >= ''10'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[计划状态] asc',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间],[计划状态_计划状态].StatusName AS [计划状态]  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND ( [计划状态_计划状态].[StatusCode] >= ''10'')'

2025-09-02 14:12:06 执行时长：5.62秒 sql:select * from GB_ProjectPlan  WITH(NOLOCK) where PlanNo='11101-2025-FH-H-100'

2025-09-02 14:12:06 执行时长：5.64秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='003002' and datacolumnid='001833'

2025-09-02 14:12:06 执行时长：5.66秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='003002' and datacolumnid='001833'

2025-09-02 14:12:06 执行时长：6.5秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[AcceptDate] AS [受理日期],[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],审核计划.[DispatchBy] AS [审核派遣人],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > '02' AND [审核类型_审核类型].[TypeName] <> '变更' and ( [审核计划].org ='0001'  or [审核计划].org ='01'  or [审核计划].org ='02'  or [审核计划].org ='03'  or [审核计划].org ='04'  or [审核计划].org ='05'  or [审核计划].org ='20'  or [审核计划].org ='21'  or [审核计划].org ='2101'  or [审核计划].org ='2102'  or [审核计划].org ='2103'  or [审核计划].org ='22'  or [审核计划].org ='23'  or [审核计划].org ='25'  or [审核计划].org ='2501'  or [审核计划].org ='26'  or [审核计划].org ='27'  or [审核计划].org ='29'  or [审核计划].org ='30'  or [审核计划].org ='301'  or [审核计划].org ='302'  or [审核计划].org ='303'  or [审核计划].org ='304'  or [审核计划].org ='305'  or [审核计划].org ='306'  or [审核计划].org ='307'  or [审核计划].org ='308'  or [审核计划].org ='309'  or [审核计划].org ='31'  or [审核计划].org ='310'  or [审核计划].org ='311'  or [审核计划].org ='312'  or [审核计划].org ='313'  or [审核计划].org ='315'  or [审核计划].org ='316'  or [审核计划].org ='32'  or [审核计划].org ='40'  or [审核计划].org ='41'  or [审核计划].org ='42'  or [审核计划].org ='43'  or [审核计划].org ='4301'  or [审核计划].org ='4302'  or [审核计划].org ='4303'  or [审核计划].org ='44'  or [审核计划].org ='45'  or [审核计划].org ='46'  or [审核计划].org ='48'  or [审核计划].org ='49'  or [审核计划].org ='50' )) AND (( [计划状态_计划状态].[StatusCode] >= '10') and ([组织名称_组织信息].[CorpName] like '%贵州茅台酒厂（集团）%')) ) as CurrentCount

2025-09-02 14:12:12 执行时长：5.58秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove, relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,dataentitycode, notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull, displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.bizdataname  FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id  where bizEntityID=@bizEntityID and isprimary=1 

2025-09-02 14:12:12 执行时长：5.55秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove, relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,dataentitycode, notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull, displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.bizdataname  FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id  where bizEntityID=@bizEntityID and isprimary=1 

2025-09-02 14:12:15 执行时长：15.22秒 sql:SELECT a.id,bizentityid,a.dataentityid,isprimary,isapprove,relatedcolumnid,relatedmaincolumnid,dataentityname,a.readonly,b.dataentitycode,notneedsecurity,a.orderno,cardinput,batchupdate,pagesize,a.refbizentityid,a.notallownull,displayinlist,NotCascadeDelete,rowfilter,NotAllowAdd,NotAllowDelete,a.BizDataName   FROM Base_BizData a left join Base_DataEntity b on a.dataentityid=b.id where a.bizentityid=@bizEntityID order by a.orderno,a.id

2025-09-02 14:12:15 执行时长：21.09秒 sql:SELECT a.*,b.dataentitycode,b.dataentityname,c.datacolumncode as rscolumncode,d.datacolumncode as rsdisplaycolumncode,e.id,  g.visibleInList,g.orderno,e.ordernoinlist,e.ordercolumn,e.ordernumber,e.bizdefaultvalue,scancodeinput  FROM Base_DataColumn a left join base_dataentity b on a.rsentity=b.id left join base_datacolumn c on a.rscolumn=c.id left join base_datacolumn d on a.rsdisplaycolumn=d.id left join Base_BizColumn e on a.id=e.datacolumnid and bizDataID=@id   left join base_bizdata f on a.dataentityid=f.dataentityid left join base_bizcolumncustom g on e.bizdataid=g.bizdataid and e.datacolumnid=g.datacolumnid and g.userid=@userID where f.id=@id   order by g.visibleinlist desc,g.orderno,e.orderno,a.DisplayNo,a.id

2025-09-02 14:12:18 执行时长：23.74秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN 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 Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-319559'') AND ([审核计划].BeginDate>=''2025-08-25 00:00'' and [审核计划].BeginDate<=''2025-09-05 23:59'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN 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 Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-319559'') AND ([审核计划].BeginDate>=''2025-08-25 00:00'' and [审核计划].BeginDate<=''2025-09-05 23:59'')'

2025-09-02 14:12:19 执行时长：13.01秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[AcceptDate] AS [受理日期],[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],审核计划.[DispatchBy] AS [审核派遣人],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusCode] >= ''10'') and ([组织名称_组织信息].[CorpName] like ''%贵州茅台酒厂（集团）%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[计划状态] asc',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间],[计划状态_计划状态].StatusName AS [计划状态]  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusCode] >= ''10'') and ([组织名称_组织信息].[CorpName] like ''%贵州茅台酒厂（集团）%''))'

2025-09-02 14:12:21 执行时长：5.09秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[AcceptDate] AS [受理日期],[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],审核计划.[DispatchBy] AS [审核派遣人],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusCode] >= ''10'') and ([组织名称_组织信息].[CorpName] like ''%贵州茅台酒厂（集团）%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[计划状态] asc',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间],[计划状态_计划状态].StatusName AS [计划状态]  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusCode] >= ''10'') and ([组织名称_组织信息].[CorpName] like ''%贵州茅台酒厂（集团）%''))'

2025-09-02 14:22:33 执行时长：5.93秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CommitDate] AS [审核员交卷日期],[阅卷人员_登录用户].UserName AS [阅卷人员],审核计划.[SupportBy] AS [支持人员],[评定人员_登录用户].UserName AS [评定人员],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[EndDate] AS [审核结束日期],审核计划.[ReceiveDate] AS [接卷日期],[项目编号_认证项目].ProjectNo AS [项目编号],[标准代码_认证标准].StandardCode AS [标准代码],审核计划.[AuditTeam] AS [审核组],审核计划.[ProfessionalCode] AS [专业代码] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo 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_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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 WHERE ([审核计划].[PlanStatus] > '10'   AND  [审核类别_审核类别].[ClassName] <> '一阶段') AND ([审核计划].RetrivalDate>='2025-09-02 00:00' and [审核计划].RetrivalDate<='2025-09-02 23:59') ) as CurrentCount

2025-09-02 14:37:15 执行时长：6.95秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK)  LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount

2025-09-02 14:56:03 执行时长：8.46秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[ContractNo] AS [合同编号],[风险等级_代码表].CodeName AS [风险等级],[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].StandardCode AS [标准代码],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],[项目编号_认证项目].ProjectNo AS [项目编号],审核计划.[ApproveRange] AS [认证范围],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[ChangeInfo] AS [变更描述],[阅卷人员_登录用户].UserName AS [阅卷人员],审核计划.[SupportBy] AS [支持人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[ScopeOfEvaluation] AS [评定范围],[案卷质量_案卷质量].LevelName AS [案卷质量],审核计划.[DecideOn] AS [认证决定日期],[批准结论_批准结论].ResultName AS [批准结论],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[CertiInfo] AS [证书信息],(case 审核计划.[IsReform] when 1 then ''√'' else '''' end) AS [已整改],(case 审核计划.[HasPause] when 1 then ''√'' else '''' end) AS [已办暂停],审核计划.[ID] AS [系统主键],审核计划.[UpdateVersion] AS [修改版本],审核计划.[Createby] AS [创建者],审核计划.[CreateOn] AS [创建时间],审核计划.[Updateby] AS [修改者],审核计划.[UpdateOn] AS [修改时间],审核计划.[ApproveBy] AS [审核者],审核计划.[ApproveOn] AS [审核时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE  1=1  ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[组织名称] DESC,[申请单号] ASC,[审核类别] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],[组织名称_组织信息].CorpName AS [组织名称],[申请单号_认证申请].ApplyNo AS [申请单号],[审核类别_审核类别].ClassName AS [审核类别] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode 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 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE  1=1 '

2025-09-02 14:56:54 执行时长：18.87秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-F') delete from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-F' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-F-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-F-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_InvalidDoc where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM GB_ProjectPlan WHERE ID='508001311' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='508001311' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='508001311' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='508001311' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='508001311') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='508001311' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='508001311') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='508001311'

2025-09-02 14:57:07 执行时长：6.32秒 sql:select count(a.id) from gb_projectplan a  inner join (select a.OrgID from View_Org a left join base_user b on a.P_orgID=b.OrgID  where UserID='ISC[S]0044') b on a.org=b.orgid and b.orgid<>''  where PlanStatus>='10'  and a.DispatchDate>='2025-09-02'  and a.DispatchDate<='2025-09-02 23:59:59'  and a.ApproveClass not in ('10','60') 

2025-09-02 14:57:20 执行时长：24.45秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-H') delete from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-H' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-H-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-H-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_InvalidDoc where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditProblem where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_AuditorContactRecord where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanCombine where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3') delete from  GB_ProjectPlanTeam where TaskNo = N'43b3bdd5c98047fb89d22008661d28f3' DELETE FROM GB_ProjectPlan WHERE ID='508001313' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='508001313' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='508001313' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='508001313' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='508001313') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='508001313' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='508001313') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='508001313'

2025-09-02 14:57:23 执行时长：11.68秒 sql:select count(a.id) from GB_ProjectPlan a   inner join (select a.OrgID from View_Org a left join base_user b on a.P_orgID=b.OrgID  where UserID='ISC[S]0044') b on a.org=b.orgid and b.orgid<>''  where a.DecideResult='01' and a.planstatus>='14' and approveclass not in ('10','50','60') and substring(a.decideon,1,10) ='2025-09-02'  

2025-09-02 14:57:29 执行时长：6.8秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],(case 审核计划.[CertificateUrgent] when 1 then '√' else '' end) AS [证书加急],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],审核计划.[CertiCompletionDate] AS [完成日期],(case 审核计划.[ReturnContract] when 1 then '√' else '' end) AS [纸质合同],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[ChangeInfo] AS [变更描述],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ContractNo] AS [合同编号],[省份_省份].Province AS [省份],审核计划.[UrgentReason] AS [加急说明],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核类别_审核类别].[ClassName] not in ('一阶段')  AND [批准结论_批准结论].[ResultName] = '通过'
 AND [计划状态_计划状态].[StatusName] in ('证书制作中','完成') and ( [审核计划].org ='0001'  or [审核计划].org ='01'  or [审核计划].org ='02'  or [审核计划].org ='03'  or [审核计划].org ='04'  or [审核计划].org ='05'  or [审核计划].org ='20'  or [审核计划].org ='21'  or [审核计划].org ='2101'  or [审核计划].org ='2102'  or [审核计划].org ='2103'  or [审核计划].org ='22'  or [审核计划].org ='23'  or [审核计划].org ='25'  or [审核计划].org ='2501'  or [审核计划].org ='26'  or [审核计划].org ='27'  or [审核计划].org ='29'  or [审核计划].org ='30'  or [审核计划].org ='301'  or [审核计划].org ='302'  or [审核计划].org ='303'  or [审核计划].org ='304'  or [审核计划].org ='305'  or [审核计划].org ='306'  or [审核计划].org ='307'  or [审核计划].org ='308'  or [审核计划].org ='309'  or [审核计划].org ='31'  or [审核计划].org ='310'  or [审核计划].org ='311'  or [审核计划].org ='312'  or [审核计划].org ='313'  or [审核计划].org ='315'  or [审核计划].org ='316'  or [审核计划].org ='32'  or [审核计划].org ='40'  or [审核计划].org ='41'  or [审核计划].org ='42'  or [审核计划].org ='43'  or [审核计划].org ='4301'  or [审核计划].org ='4302'  or [审核计划].org ='4303'  or [审核计划].org ='44'  or [审核计划].org ='45'  or [审核计划].org ='46'  or [审核计划].org ='48'  or [审核计划].org ='49'  or [审核计划].org ='50' )) AND (( [计划状态_计划状态].[StatusName] = '完成') and ([组织名称_组织信息].[CorpName] like '%天津市正方智成石油装备有限公司%')) ) as CurrentCount

2025-09-02 14:57:34 执行时长：14.61秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-H' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-H') delete from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-H' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-H-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-H-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_InvalidDoc where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM GB_ProjectPlan WHERE ID='508001314' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='508001314' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='508001314' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='508001314' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='508001314') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='508001314' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='508001314') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='508001314'

2025-09-02 14:57:45 执行时长：15.86秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],(case 审核计划.[CertificateUrgent] when 1 then ''√'' else '''' end) AS [证书加急],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],审核计划.[CertiCompletionDate] AS [完成日期],(case 审核计划.[ReturnContract] when 1 then ''√'' else '''' end) AS [纸质合同],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[ChangeInfo] AS [变更描述],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ContractNo] AS [合同编号],[省份_省份].Province AS [省份],审核计划.[UrgentReason] AS [加急说明],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核类别_审核类别].[ClassName] not in (''一阶段'')  AND [批准结论_批准结论].[ResultName] = ''通过''
 AND [计划状态_计划状态].[StatusName] in (''证书制作中'',''完成'') and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusName] = ''完成'') and ([组织名称_组织信息].[CorpName] like ''%天津市正方智成石油装备有限公司%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] asc',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[DecideOn] AS [认证决定日期]  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核类别_审核类别].[ClassName] not in (''一阶段'')  AND [批准结论_批准结论].[ResultName] = ''通过''
 AND [计划状态_计划状态].[StatusName] in (''证书制作中'',''完成'') and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusName] = ''完成'') and ([组织名称_组织信息].[CorpName] like ''%天津市正方智成石油装备有限公司%''))'

2025-09-02 14:57:45 执行时长：26.8秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],(case 审核计划.[CertificateUrgent] when 1 then ''√'' else '''' end) AS [证书加急],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],审核计划.[CertiCompletionDate] AS [完成日期],(case 审核计划.[ReturnContract] when 1 then ''√'' else '''' end) AS [纸质合同],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[ChangeInfo] AS [变更描述],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ContractNo] AS [合同编号],[省份_省份].Province AS [省份],审核计划.[UrgentReason] AS [加急说明],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核类别_审核类别].[ClassName] not in (''一阶段'')  AND [批准结论_批准结论].[ResultName] = ''通过''
 AND [计划状态_计划状态].[StatusName] in (''证书制作中'',''完成'') and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusName] = ''完成'') and ([组织名称_组织信息].[CorpName] like ''%天津市正方智成石油装备有限公司%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],[合同来源_合同来源].OrgName AS [合同来源]  FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode 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_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE ([审核类别_审核类别].[ClassName] not in (''一阶段'')  AND [批准结论_批准结论].[ResultName] = ''通过''
 AND [计划状态_计划状态].[StatusName] in (''证书制作中'',''完成'') and ( [审核计划].org =''0001''  or [审核计划].org =''01''  or [审核计划].org =''02''  or [审核计划].org =''03''  or [审核计划].org =''04''  or [审核计划].org =''05''  or [审核计划].org =''20''  or [审核计划].org =''21''  or [审核计划].org =''2101''  or [审核计划].org =''2102''  or [审核计划].org =''2103''  or [审核计划].org =''22''  or [审核计划].org =''23''  or [审核计划].org =''25''  or [审核计划].org =''2501''  or [审核计划].org =''26''  or [审核计划].org =''27''  or [审核计划].org =''29''  or [审核计划].org =''30''  or [审核计划].org =''301''  or [审核计划].org =''302''  or [审核计划].org =''303''  or [审核计划].org =''304''  or [审核计划].org =''305''  or [审核计划].org =''306''  or [审核计划].org =''307''  or [审核计划].org =''308''  or [审核计划].org =''309''  or [审核计划].org =''31''  or [审核计划].org =''310''  or [审核计划].org =''311''  or [审核计划].org =''312''  or [审核计划].org =''313''  or [审核计划].org =''315''  or [审核计划].org =''316''  or [审核计划].org =''32''  or [审核计划].org =''40''  or [审核计划].org =''41''  or [审核计划].org =''42''  or [审核计划].org =''43''  or [审核计划].org =''4301''  or [审核计划].org =''4302''  or [审核计划].org =''4303''  or [审核计划].org =''44''  or [审核计划].org =''45''  or [审核计划].org =''46''  or [审核计划].org =''48''  or [审核计划].org =''49''  or [审核计划].org =''50'' )) AND (( [计划状态_计划状态].[StatusName] = ''完成'') and ([组织名称_组织信息].[CorpName] like ''%天津市正方智成石油装备有限公司%''))'

2025-09-02 14:57:48 执行时长：13.75秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F') delete from  GB_ProjectPlanCerti where ProjectNo = N'11063-2025-FH-F' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-F') delete from  GB_CertiDoc where ProjectNo = N'11063-2025-FH-F' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-F-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'11063-2025-FH-F-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_InvalidDoc where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditProblem where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_AuditorContactRecord where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanCombine where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f') delete from  GB_ProjectPlanTeam where TaskNo = N'75fa7a1649324f769c8dc06ba25ba17f' DELETE FROM GB_ProjectPlan WHERE ID='508001312' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='508001312' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='508001312' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='508001312' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='508001312') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='508001312' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='508001312') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='508001312'

2025-09-02 14:57:49 执行时长：25.96秒 sql:select count(a.id) from GB_ProjectPlan a   inner join (select a.OrgID from View_Org a left join base_user b on a.P_orgID=b.OrgID  where UserID='ISC[S]0044') b on a.org=b.orgid and b.orgid<>''  where a.DecideResult='01' and a.planstatus>='14' and approveclass not in ('10','50','60') and substring(a.decideon,1,10)>='2025-09-01'  and substring(a.decideon,1,10)<'2025-10-01'   

2025-09-02 14:57:54 执行时长：9.71秒 sql:exec [GB_AuditorSchedule] '2025-09-01','','','','','','123','0.5','ISC0042'