2025-10-27 17:00:09 执行时长：7.34秒 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 =''25'' or [审核计划].org =''2501'' )) AND ( [计划状态_计划状态].[StatusName] = ''待安排'') ',@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 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 =''25'' or [审核计划].org =''2501'' )) AND ( [计划状态_计划状态].[StatusName] = ''待安排'')' 2025-10-27 17:00:17 执行时长：8.38秒 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 =''25'' or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and (([省份_省份].[Province] like ''%安徽省%'' or [省份_省份].[Province] like ''%江苏省%'' or [省份_省份].[Province] 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 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 =''25'' or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and (([省份_省份].[Province] like ''%安徽省%'' or [省份_省份].[Province] like ''%江苏省%'' or [省份_省份].[Province] like ''%浙江省%'')))' 2025-10-27 17:00:19 执行时长：5.14秒 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 =''25'' or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and (([省份_省份].[Province] like ''%安徽省%'' or [省份_省份].[Province] like ''%江苏省%'' or [省份_省份].[Province] 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 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 =''25'' or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and (([省份_省份].[Province] like ''%安徽省%'' or [省份_省份].[Province] like ''%江苏省%'' or [省份_省份].[Province] like ''%浙江省%'')))' 2025-10-27 17:00:24 执行时长：8.88秒 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 =''25'' or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and (([省份_省份].[Province] like ''%安徽省%'' or [省份_省份].[Province] like ''%江苏省%'' or [省份_省份].[Province] 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 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 =''25'' or [审核计划].org =''2501'' )) AND (( [计划状态_计划状态].[StatusName] = ''待安排'') and (([省份_省份].[Province] like ''%安徽省%'' or [省份_省份].[Province] like ''%江苏省%'' or [省份_省份].[Province] like ''%浙江省%'')))' 2025-10-27 17:00:40 执行时长：63.45秒 sql:exec [GB_AuditorSchedule] '2025-11-01','','','','','','','0.5','ISC3201' 2025-10-27 17:00:51 执行时长：83.15秒 sql:exec [GB_AuditorSchedule] '2025-11-01','','','','','','','0.5','ISC3201' 2025-10-27 17:01:02 执行时长：66.86秒 sql:exec [GB_AuditorSchedule] '2025-11-01','','','','','','','0.5','ISC3201' 2025-10-27 17:01:10 执行时长：18.69秒 sql:exec [GB_AuditorSchedule] '2025-10-01','','','','','','123','0.5','ISC0042' 2025-10-27 17:28:43 执行时长：7.63秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],(case 审核计划.[ReturnContract] when 1 then '√' else '' end) AS [纸质合同],审核计划.[ChangeInfo] AS [变更描述],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[PlanRemarks] AS [计划备注],审核计划.[CertiCompletionDate] AS [完成日期],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],(case 审核计划.[CertificateUrgent] when 1 then '√' else '' end) 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] = '完成') ) as CurrentCount 2025-10-27 17:28:48 执行时长：5.14秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],(case 审核计划.[ReturnContract] when 1 then ''√'' else '''' end) AS [纸质合同],审核计划.[ChangeInfo] AS [变更描述],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[PlanRemarks] AS [计划备注],审核计划.[CertiCompletionDate] AS [完成日期],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],(case 审核计划.[CertificateUrgent] when 1 then ''√'' else '''' end) 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] = ''完成'') ',@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] = ''完成'')' 2025-10-27 17:29:05 执行时长：6.13秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],(case 审核计划.[ReturnContract] when 1 then '√' else '' end) AS [纸质合同],审核计划.[ChangeInfo] AS [变更描述],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[PlanRemarks] AS [计划备注],审核计划.[CertiCompletionDate] AS [完成日期],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],(case 审核计划.[CertificateUrgent] when 1 then '√' else '' end) 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] = '完成') ) as CurrentCount 2025-10-27 17:29:27 执行时长：22.29秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],(case 审核计划.[ReturnContract] when 1 then ''√'' else '''' end) AS [纸质合同],审核计划.[ChangeInfo] AS [变更描述],[计划状态_计划状态].StatusName AS [计划状态],审核计划.[PlanRemarks] AS [计划备注],审核计划.[CertiCompletionDate] AS [完成日期],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],(case 审核计划.[CertificateUrgent] when 1 then ''√'' else '''' end) 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] = ''完成'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[完成日期] desc',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[CertiCompletionDate] 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] = ''完成'')' 2025-10-27 17:29:31 执行时长：8.06秒 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