2025-12-23 19:35:37 执行时长：6.78秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].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 [体系人数],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName 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_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_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 ( [审核计划].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'  or [审核计划].org ='51' ) ) as CurrentCount

2025-12-23 19:38:43 执行时长：5.37秒 sql:SELECT DISTINCT 组织信息文档.ID as [~ID~] ,组织信息文档.[SerialNo] AS [文档序号],[文档类型_组织信息文档类型].Name AS [文档类型],(case 组织信息文档.[IsMust] when 1 then '√' else '' end) AS [必须上传],组织信息文档.[FileName] AS [文件名称],[上传人_用户].UserName AS [上传人],组织信息文档.[UploadOn] AS [上传时间],(case 组织信息文档.[NotAddPackage] when 1 then '√' else '' end) AS [不加入文件包] FROM GB_CertiApplyCorpDoc 组织信息文档 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 组织信息文档.Corp = [组织名称_组织信息].CorpID LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 组织信息文档.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_OrgDocType [文档类型_组织信息文档类型] WITH(NOLOCK) ON 组织信息文档.DocumentType = [文档类型_组织信息文档类型].Code LEFT JOIN Base_User [上传人_用户] WITH(NOLOCK) ON 组织信息文档.UploadBy = [上传人_用户].UserID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 组织信息文档.ApproveClass = [审核类别_审核类别].ClassCode WHERE [组织信息文档].Corp='202512230004' order by [组织信息文档].[SerialNo] ASC

2025-12-23 19:38:44 执行时长：5.38秒 sql:select year('2025-03-04')

2025-12-23 19:43:25 执行时长：6.4秒 sql:select * from Pub_CertiType  WITH(NOLOCK) where id='72'

2025-12-23 19:43:25 执行时长：10.42秒 sql:select d.dataentityname,b.datacolumncode,a.orderoption,e.dataentityname,f.datacolumncode,b.datacolumnname,b.rsmultiselect as multiselect,c.bizdataname  from base_bizcolumn a left join base_datacolumn b on a.datacolumnid=b.id  left join base_bizdata c on a.bizdataid=c.id  left join base_dataentity d on c.dataentityid=d.id  left join base_dataentity e on b.rsentity=e.id  left join base_datacolumn f on b.RsDisplayColumn=f.id  where ordercolumn=1 and orderoption<>'' and VisibleInList=1 and a.bizdataid='0046' and b.datacolumncode<>''  order by ordernumber

2025-12-23 19:43:31 执行时长：5.91秒 sql:SELECT DISTINCT 认证项目.ID as [~ID~] ,认证项目.[ProjectNo] AS [项目编号],[审核类型_审核类型].TypeName AS [审核类型],认证项目.[CertiQty] AS [体系人数],认证项目.[ApproveRange] AS [评审范围],[标准代码_认证标准].StandardCode AS [标准代码],认证项目.[BasicDays] AS [基础人日],认证项目.[TotalDays] AS [现场总人日],[组织名称_组织信息].CorpName AS [组织名称],认证项目.[StandardName] AS [标准名称],[认证领域_认证领域].FieldName AS [认证领域],认证项目.[SpecialSpecifications] AS [专项规范],认证项目.[FixedMultiLocation] AS [固定多场所数],认证项目.[ReCertiQty] AS [再认证次数],认证项目.[SuperQty] AS [监督次数],[审核类别说明_代码表].CodeName AS [审核类别说明],(case 认证项目.[SubCertificateRequired] when 1 then '√' else '' end) AS [需要子证书],认证项目.[ProfessionalCode] AS [专业代码],认证项目.[UnrecognizedProfession] AS [未认可专业],[一阶段实施类型_代码表].CodeName AS [一阶段实施类型],[风险等级_代码表].CodeName AS [风险等级],[认可标志_认可标志].RecogName AS [认可标志],认证项目.[IncreaseDays] AS [增加人日],认证项目.[AddReasons] AS [增加理由],认证项目.[ReduceDays] AS [减少人日],认证项目.[ReasonsForReduction] AS [减少理由],认证项目.[TempMultiLocation] AS [临时多场所数],认证项目.[FirstOffSiteHumanDays] AS [一阶非现场人日],认证项目.[FirstStageOnsiteDays] AS [一阶现场人日],认证项目.[SecondStageDays] AS [二阶段人日],认证项目.[SupervisoryDays] AS [监督人日],认证项目.[ReexaminationDays] AS [复评人日],[申请单号_认证申请].ApplyNo AS [申请单号] FROM GB_CertificationProject 认证项目 WITH(NOLOCK)  LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 认证项目.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 认证项目.StandardCode = [标准代码_认证标准].ID LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证项目.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 认证项目.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [审核类别说明_代码表] WITH(NOLOCK) ON 认证项目.ExplanationOfAuditCategory = [审核类别说明_代码表].CodeID LEFT JOIN Pub_Code [一阶段实施类型_代码表] WITH(NOLOCK) ON 认证项目.FirstClass = [一阶段实施类型_代码表].CodeID LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 认证项目.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 认证项目.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 认证项目.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证项目.Org = [合同来源_合同来源].Org WHERE [认证项目].ApplyNo='13280' order by [认证项目].ID

2025-12-23 19:43:31 执行时长：5.96秒 sql:select * from Pub_CertiType  WITH(NOLOCK) where id='58'

2025-12-23 19:43:37 执行时长：5.65秒 sql:select * from Pub_CertiType  WITH(NOLOCK) where id='72'

2025-12-23 19:43:43 执行时长：5.71秒 sql:select * from Pub_CertiField  WITH(NOLOCK) where FieldCode='O'

2025-12-23 19:43:43 执行时长：11.36秒 sql:SELECT DISTINCT 受理及评审文档.ID as [~ID~] ,[申请单号_认证申请].ApplyNo AS [申请单号],[组织名称_组织信息].CorpName AS [组织名称],受理及评审文档.[SerialNo] AS [文档序号],[文档类型_受理及评审文档类型].DocumentType AS [文档类型],(case 受理及评审文档.[IsMust] when 1 then '√' else '' end) AS [必须上传],受理及评审文档.[FileName] AS [文件名称],[上传人_用户].UserName AS [上传人],受理及评审文档.[UploadOn] AS [上传时间],(case 受理及评审文档.[NotAddPackage] when 1 then '√' else '' end) AS [不加入文件包] FROM GB_CertiApplyApproveDoc 受理及评审文档 WITH(NOLOCK)  LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 受理及评审文档.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 受理及评审文档.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 受理及评审文档.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ProjectDocType [文档类型_受理及评审文档类型] WITH(NOLOCK) ON 受理及评审文档.DocumentType = [文档类型_受理及评审文档类型].ClassCode LEFT JOIN Base_User [上传人_用户] WITH(NOLOCK) ON 受理及评审文档.UploadBy = [上传人_用户].UserID WHERE [受理及评审文档].ApplyNo='13280' order by [受理及评审文档].[SerialNo] ASC

2025-12-23 19:43:49 执行时长：5.72秒 sql:SELECT paraclass FROM Base_bizQuerypara where bizentityid='003005' and datacolumnid='001915'

2025-12-23 19:43:49 执行时长：5.88秒 sql:SELECT 审核计划.ID as [~ID~] ,审核计划.[BizAddress] AS [生产经营地址],审核计划.[AcceptDate] AS [受理日期],审核计划.[FeeDays] AS [收费人日],审核计划.[CheckDate] AS [评审通过时间],审核计划.[PauseNotice] AS [暂停通知],审核计划.[SuperNoticeDate] AS [监督通知时间],审核计划.[SuperCommitDate] AS [监督维护提交时间],[计划状态_计划状态].StatusCode AS [计划状态_Value],[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusCode AS [评定状态_Value],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpID AS [组织名称_Value],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanNo] AS [计划编号],[标准代码_认证标准].ID AS [标准代码_Value],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeCode AS [审核类型_Value],[审核类型_审核类型].TypeName AS [审核类型],[审核类别_审核类别].ClassCode AS [审核类别_Value],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveModeCode AS [审核方式_Value],[审核方式_审核方式].ApproveMode AS [审核方式],[合同来源_合同来源].Org AS [合同来源_Value],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].ProvinceCode AS [省份_Value],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[CertiQty] AS [体系人数],[风险等级_代码表].CodeID AS [风险等级_Value],[风险等级_代码表].CodeName AS [风险等级],审核计划.[IssuesToBeNoted] AS [审核需关注问题],审核计划.[PlanRemarks] AS [计划备注],审核计划.[StandardName] AS [标准名称],审核计划.[BasicDays] AS [基础人日],审核计划.[FirstOffSiteHumanDays] AS [一阶非现场人日],审核计划.[FirstStageOnsiteDays] AS [一阶现场人日],审核计划.[SecondStageDays] AS [二阶段人日],审核计划.[SupervisoryDays] AS [监督人日],审核计划.[ReexaminationDays] AS [复评人日],审核计划.[TotalDays] AS [现场总人日],[申请单号_认证申请].ApplyNo AS [申请单号_Value],[申请单号_认证申请].ApplyNo AS [申请单号],[项目编号_认证项目].ProjectNo AS [项目编号_Value],[项目编号_认证项目].ProjectNo AS [项目编号],审核计划.[ContractNo] AS [合同编号],审核计划.[TaskNo] AS [任务编号],审核计划.[ApproveRange] AS [认证范围],审核计划.[ReportDate] AS [已上报日期],审核计划.[CertiFee] AS [证书费],审核计划.[ReturnDate] AS [退回日期],审核计划.[ReasonForReturn] AS [退回理由],审核计划.[DispatchBy] AS [审核派遣人],审核计划.[DispatchDate] AS [派组日期],审核计划.[Approver] AS [审批人],审核计划.[ApproveDate] AS [审批日期],审核计划.[PlanApproveDate] AS [预计审核日期],[联系结果_联系结果].ResultCode AS [联系结果_Value],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],审核计划.[ToSchedule] AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] AS [传计调信息],[认可标志_认可标志].RecogCode AS [认可标志_Value],[认可标志_认可标志].RecogName AS [认可标志],[认证领域_认证领域].FieldCode AS [认证领域_Value],[认证领域_认证领域].FieldName AS [认证领域],审核计划.[FeeDate] AS [计费日期],审核计划.[ChangeInfo] AS [变更描述],审核计划.[SuperQty] AS [监督周期],审核计划.[ReviewRemarks] AS [审议备注],审核计划.[ReCertiQty] AS [复评周期],[阅卷人员_登录用户].UserID AS [阅卷人员_Value],[阅卷人员_登录用户].UserName AS [阅卷人员],审核计划.[SupportBy] AS [支持人员],[评定人员_登录用户].UserID AS [评定人员_Value],[评定人员_登录用户].UserName AS [评定人员],审核计划.[RetrivalDate] AS [分卷时间],审核计划.[ReceiveDate] AS [接卷日期],审核计划.[DocReceiveBy] AS [档案受理人],审核计划.[DistributeOn] AS [分发评定老师时间],审核计划.[ReasonsForAuditFailure] AS [现场审核不通过理由],审核计划.[CertificateUrgent] AS [证书加急],审核计划.[UrgentReason] AS [加急说明],审核计划.[AcceptanceEvaluationTime] AS [受理评定时间],审核计划.[PlanCommitDate] AS [计划提交时间],审核计划.[CommitDate] AS [审核员交卷日期],审核计划.[ScopeOfEvaluation] AS [评定范围],[项目分级_案卷质量].LevelCode AS [项目分级_Value],[项目分级_案卷质量].LevelName AS [项目分级],[组长分级_案卷质量].LevelCode AS [组长分级_Value],[组长分级_案卷质量].LevelName AS [组长分级],[案卷质量_案卷质量].LevelCode AS [案卷质量_Value],[案卷质量_案卷质量].LevelName AS [案卷质量],审核计划.[ProfessionalEvaluation] AS [评定专业],审核计划.[ReviewDate] AS [阅卷完成时间],审核计划.[DocReturnDate] AS [审核员回卷时间],审核计划.[ReturnContractQty] AS [合同数量],审核计划.[ReturnDoc] AS [纸质案卷],审核计划.[ReturnContract] AS [纸质合同],审核计划.[ReturnApply] AS [认证申请],审核计划.[ReturnContractTransfer] AS [合同移交],审核计划.[DocReceiveRemark] AS [资料回收备注],审核计划.[DecideOn] AS [认证决定日期],[批准结论_批准结论].ResultCode AS [批准结论_Value],[批准结论_批准结论].ResultName AS [批准结论],审核计划.[ReturnReason] AS [退回原因],审核计划.[UnPassReason] AS [未通过原因],审核计划.[ProcessResult] AS [处理结果],审核计划.[SuperviseEndDate] AS [监审最后日期],审核计划.[SuperNoticeSent] AS [监审通知],审核计划.[NextApproveType] AS [下次审核类型],审核计划.[NextApproveDate] AS [下次审核最迟日期],审核计划.[NextPlanCreated] AS [下次计划已生成],审核计划.[CertiInfo] AS [证书信息],审核计划.[CertiAcceptanceDate] AS [证书接受日期],审核计划.[CertiCompletionDate] AS [完成日期],审核计划.[NonCompliantTerms] AS [本次审核部门及不符合条款],审核计划.[NextAuditAdvice] AS [下次审核部门建议],审核计划.[NextAuditFocus] AS [下次审核关注点],审核计划.[DocUploaded] AS [资料上传完成],审核计划.[IsReform] AS [已整改],审核计划.[ReformDate] AS [整改完成日期],审核计划.[FromChangeNo] AS [来源变更单号],审核计划.[ReceiveDateI] AS [合同申请接收时间],[合同申请接收人_登录用户].UserID AS [合同申请接收人_Value],[合同申请接收人_登录用户].UserName AS [合同申请接收人],审核计划.[MoveDate] AS [移交时间],审核计划.[HandOverBy] AS [交接人],审核计划.[MailingInformation] AS [审核老师确认邮寄信息],审核计划.[FollowUpTracking] AS [案卷后续跟踪],[跟踪结果_跟踪结果].StatusCode AS [跟踪结果_Value],[跟踪结果_跟踪结果].StatusName AS [跟踪结果],审核计划.[HasPause] AS [已办暂停],审核计划.[IsReceive] 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_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 审核计划.id='60655'

2025-12-23 19:43:55 执行时长：5.47秒 sql:select a.userid,a.roleid,a.org,a.bizentityid,a.id,a.reltype,a.condition,b.username,orgname,rolename  from Base_BizEntityFilter a   left join base_user b on a.userid=b.userid   left join base_role c on a.roleid=c.roleid  left join base_org d on a.org=d.orgid  where bizentityid=@BizEntityID and (a.userid='' or a.userid='liudajun')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='liudajun'))  and (a.org='' or a.org='0001')

2025-12-23 19:43:55 执行时长：5.1秒 sql:select datatype,DataColumnName,DateFormat  from Base_DataColumn where DataType in (3,1) and SysColumn=0 and dataentityid='008001'  

2025-12-23 19:43:55 执行时长：5.55秒 sql:select * from GB_ProjectPlanCerti  WITH(NOLOCK) where ProjectNo='20176-2025-QEO-E_23244'

2025-12-23 19:44:00 执行时长：5.23秒 sql:select TaskNo from GB_ProjectPlan  WITH(NOLOCK) where ID='60655'

2025-12-23 19:44:01 执行时长：5.93秒 sql:select datatype,DataColumnName,DateFormat  from Base_DataColumn where DataType in (3,1) and SysColumn=0 and dataentityid='002001'  

2025-12-23 19:44:06 执行时长：10.88秒 sql:SELECT * FROM Base_DataEntity WHERE ID=@id

2025-12-23 19:44:12 执行时长：11.3秒 sql:select d.dataentityname,b.datacolumncode,a.orderoption,e.dataentityname,f.datacolumncode,b.datacolumnname,b.rsmultiselect as multiselect,c.bizdataname  from base_bizcolumn a left join base_datacolumn b on a.datacolumnid=b.id  left join base_bizdata c on a.bizdataid=c.id  left join base_dataentity d on c.dataentityid=d.id  left join base_dataentity e on b.rsentity=e.id  left join base_datacolumn f on b.RsDisplayColumn=f.id  where ordercolumn=1 and orderoption<>'' and VisibleInList=1 and a.bizdataid='0114' and b.datacolumncode<>''  order by ordernumber

2025-12-23 19:44:12 执行时长：5.68秒 sql:select * from Base_BizentityCustom where BizEntityID='003005' and UserID='' and propertyname='ListWithSubData'

2025-12-23 19:44:13 执行时长：18.07秒 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-12-23 19:44:25 执行时长：6.2秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[批准结论_批准结论].ResultName AS [批准结论],审核计划.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],[组长分级_案卷质量].LevelName AS [组长分级],[案卷质量_案卷质量].LevelName AS [案卷质量],审核计划.[DecideOn] AS [认证决定日期],审核计划.[AuditTeam] AS [审核组],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[SupportBy] AS [支持人员],(case 审核计划.[CertificateUrgent] when 1 then ''√'' else '''' end) AS [证书加急],审核计划.[UrgentReason] AS [加急说明],(case 审核计划.[IsReform] when 1 then ''√'' else '''' end) AS [已整改],审核计划.[ReformDate] AS [整改完成日期],审核计划.[PlanNo] 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 Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode 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_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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 Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID WHERE ((( [审核计划].[PlanStatus] >= ''13''  and [审核类别_审核类别].[ClassName] in (''二阶段'',''监查1'',''监查2'',''监督3'',''监督4'',''再认证'',''补充'',''变更'')  AND ([评定状态_评定状态].[StatusName] is null or [评定状态_评定状态].[StatusName] = ''合格档''or [评定状态_评定状态].[StatusName] = ''问题档'' OR [审核计划].[IsReform] =1)))) AND ([审核计划].DecideOn>=''2025-03-01 00:00'' and [审核计划].DecideOn<=''2025-03-31 23:59'') ',@PageSize = 500, @PageCurrent = 1, @FdShow = '',@FdOrder = '[组织名称] asc',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[DecideOn] 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 Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode 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_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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 Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID WHERE ((( [审核计划].[PlanStatus] >= ''13''  and [审核类别_审核类别].[ClassName] in (''二阶段'',''监查1'',''监查2'',''监督3'',''监督4'',''再认证'',''补充'',''变更'')  AND ([评定状态_评定状态].[StatusName] is null or [评定状态_评定状态].[StatusName] = ''合格档''or [评定状态_评定状态].[StatusName] = ''问题档'' OR [审核计划].[IsReform] =1)))) AND ([审核计划].DecideOn>=''2025-03-01 00:00'' and [审核计划].DecideOn<=''2025-03-31 23:59'')'

2025-12-23 19:46:34 执行时长：7.93秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[批准结论_批准结论].ResultName AS [批准结论],审核计划.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],[组长分级_案卷质量].LevelName AS [组长分级],[案卷质量_案卷质量].LevelName AS [案卷质量],审核计划.[DecideOn] AS [认证决定日期],审核计划.[AuditTeam] AS [审核组],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[SupportBy] AS [支持人员],(case 审核计划.[CertificateUrgent] when 1 then '√' else '' end) AS [证书加急],审核计划.[UrgentReason] AS [加急说明],(case 审核计划.[IsReform] when 1 then '√' else '' end) AS [已整改],审核计划.[ReformDate] AS [整改完成日期],审核计划.[PlanNo] 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 Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode 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_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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 Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID WHERE ((( [审核计划].[PlanStatus] >= '13'  and [审核类别_审核类别].[ClassName] in ('二阶段','监查1','监查2','监督3','监督4','再认证','补充','变更')  AND ([评定状态_评定状态].[StatusName] is null or [评定状态_评定状态].[StatusName] = '合格档'or [评定状态_评定状态].[StatusName] = '问题档' OR [审核计划].[IsReform] =1)))) AND ( 1=1 ) ) as CurrentCount

2025-12-23 19:51:33 执行时长：6.63秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],审核计划.[BeginDate] AS [审核开始日期],审核计划.[ContractNo] AS [合同编号],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].StandardCode AS [标准代码],[认可标志_认可标志].RecogName AS [认可标志],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[PlanRemarks] AS [计划备注],审核计划.[EndDate] AS [审核结束日期],[合同来源_合同来源].OrgName AS [合同来源],审核计划.[ChangeInfo] AS [变更描述],审核计划.[PlanNo] AS [计划编号],审核计划.[CertiInfo] AS [证书信息],[评定状态_评定状态].StatusName AS [评定状态],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode 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] <> ''变更'' ',@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_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode 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] <> ''变更'''