2025-08-06 10:03:34 执行时长：5.11秒 sql:UPDATE GB_ProjectPlan SET  [CertificateUrgent]=0,[CertiAcceptanceDate]='2025-08-06',updateby= '邵松林',updateon='2025-08-06 10:03:28' ,updateversion=updateversion+1  WHERE ID='49285' UPDATE GB_CertiDoc SET  [ProjectNo]=N'10448-2024-Q-Q_18440',[CorpCanDownload]=0,updateby= '邵松林',updateon='2025-08-06 10:03:28' ,updateversion=updateversion+1  WHERE ID='179838' UPDATE GB_CertiDoc SET  [ProjectNo]=N'10448-2024-Q-Q_18440',[CorpCanDownload]=0,updateby= '邵松林',updateon='2025-08-06 10:03:28' ,updateversion=updateversion+1  WHERE ID='179839' insert into GB_CertiDoc([ProjectNo],[Corp],[ApproveType],[FileName],[UploadBy],[UploadOn],[CorpCanDownload],[ID],[UpdateVersion],[Createby],[CreateOn],[Updateby],[UpdateOn],[ApproveBy],[ApproveOn]) values (N'10448-2024-Q-Q_18440',N'7716',N'01',N'16-2  管理体系审核报告(监督) (2).pdf',N'ISC0021','2025-08-06 10:03:22',1,N'508000242ISC0021',0,N'邵松林','2025-08-06 10:03:28',N'邵松林','2025-08-06 10:03:28',N'','') insert into GB_CertiDoc([ProjectNo],[Corp],[ApproveType],[FileName],[UploadBy],[UploadOn],[CorpCanDownload],[ID],[UpdateVersion],[Createby],[CreateOn],[Updateby],[UpdateOn],[ApproveBy],[ApproveOn]) values (N'10448-2024-Q-Q_18440',N'7716',N'01',N'ISC-Q-2024-4146证书.pdf',N'ISC0021','2025-08-06 10:03:23',1,N'508000243ISC0021',0,N'邵松林','2025-08-06 10:03:28',N'邵松林','2025-08-06 10:03:28',N'','') insert into GB_CertiDoc([ProjectNo],[Corp],[ApproveType],[FileName],[UploadBy],[UploadOn],[CorpCanDownload],[ID],[UpdateVersion],[Createby],[CreateOn],[Updateby],[UpdateOn],[ApproveBy],[ApproveOn]) values (N'10448-2024-Q-Q_18440',N'7716',N'01',N'涿州市飞亚机械有限责任公司 年度监督审核合格通知书 (3).pdf',N'ISC0021','2025-08-06 10:03:23',1,N'508000244ISC0021',0,N'邵松林','2025-08-06 10:03:28',N'邵松林','2025-08-06 10:03:28',N'','')

2025-08-06 10:03:37 执行时长：19.25秒 sql:SELECT DISTINCT 审核计划.ID as [~ID~] ,[批准结论_批准结论].ResultName AS [批准结论],[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[认可标志_认可标志].RecogName AS [认可标志],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],[审核类别_审核类别].ClassName AS [审核类别],(case 审核计划.[CertificateUrgent] when 1 then '√' else '' end) AS [证书加急],审核计划.[DecideOn] AS [认证决定日期],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],审核计划.[CertiCompletionDate] AS [完成日期],审核计划.[ProjectLeader] AS [项目负责人],[计划状态_计划状态].StatusName AS [计划状态],[项目编号_认证项目].ProjectNo AS [项目编号],审核计划.[PlanNo] AS [计划编号],审核计划.[StandardName] AS [标准名称],审核计划.[CertiFee] AS [证书费],[阅卷人员_登录用户].UserName AS [阅卷人员],审核计划.[SupportBy] AS [支持人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[ChangeInfo] AS [变更描述],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ScopeOfEvaluation] AS [评定范围],审核计划.[ContractNo] AS [合同编号],[省份_省份].Province AS [省份],审核计划.[UrgentReason] AS [加急说明],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode 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_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode 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 LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode WHERE ([审核类别_审核类别].[ClassName] not in ('一阶段')  AND [批准结论_批准结论].[ResultName] = '通过'
 AND [计划状态_计划状态].[StatusName] in ('证书制作中','完成')) AND ([审核计划].DecideOn>='2023-07-31 00:00' and [审核计划].DecideOn<='2024-07-31 23:59') order by [审核计划].[UpdateOn] DESC,[组织名称_组织信息].[CorpName] ASC,[审核类别_审核类别].[ClassName] ASC

2025-08-06 10:05:11 执行时长：7.14秒 sql:exec [GB_PartnerCertiStatistics]

2025-08-06 10:05:11 执行时长：7.33秒 sql:exec [GB_PartnerCertiStatistics]