2025-10-30 10:05:49 执行时长：5.81秒 sql:exec [GB_AuditorSchedule] '','','','','','0001','','1','ISC0032'

2025-10-30 10:22:42 执行时长：11.2秒 sql:exec [GB_PartnerCertiStatistics]

2025-10-30 10:22:46 执行时长：15.75秒 sql:exec [GB_PartnerCertiStatistics]
2025-10-30 10:24:37
Sql：insert into GB_PlanDoc (ID,UpdateVersion,Createby,CreateOn,ApproveBy,ApproveOn,TaskNo,DocumentType,FileName,UploadBy,UploadOn,IsHistry) values (N'510013021',N'0',N'',N'2025-10-30 10:24:37',N'',N'',N'92b02076015e4bfa85a158516c821bde',N'212',N'05  审核组沟通培训记录.pdf',N'ISC-267703',N'2025-10-30 10:24:37',0) 
Error：违反了 PRIMARY KEY 约束“PK__GB_PlanD__3213E83F42B7D1CC”。不能在对象“dbo.GB_PlanDoc”中插入重复键。重复键值为 (510013021)。
语句已终止。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   在 Redsoft.DatabaseProvider.DbAccess.Execute(String[] sql, ArrayList paraList) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 745
2025-10-30 10:24:38
Sql：insert into GB_PlanDoc (ID,UpdateVersion,Createby,CreateOn,ApproveBy,ApproveOn,TaskNo,DocumentType,FileName,UploadBy,UploadOn,IsHistry) values (N'510013024',N'0',N'',N'2025-10-30 10:24:38',N'',N'',N'92b02076015e4bfa85a158516c821bde',N'212',N'07  一阶段管理体系审核记录表.pdf',N'ISC-267703',N'2025-10-30 10:24:38',0) 
Error：违反了 PRIMARY KEY 约束“PK__GB_PlanD__3213E83F42B7D1CC”。不能在对象“dbo.GB_PlanDoc”中插入重复键。重复键值为 (510013024)。
语句已终止。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   在 Redsoft.DatabaseProvider.DbAccess.Execute(String[] sql, ArrayList paraList) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 745

2025-10-30 10:27:46 执行时长：12.23秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[PlanApproveDate] AS [预计审核日期],[联系结果_联系结果].ResultName AS [联系结果],审核计划.[ToScheduleDate] AS [转计调日期],(case 审核计划.[ToSchedule] when 1 then ''√'' else '''' end) AS [报审核计调],审核计划.[ProjectLeader] AS [项目负责人],审核计划.[PlanReturnReason] AS [审核联络退回理由],审核计划.[ToScheduleInfo] AS [传计调信息],[项目编号_认证项目].ProjectNo AS [项目编号],[省份_省份].Province AS [省份],审核计划.[StandardName] 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 Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org 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_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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 ''%庞大%'' and 1=1) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[预计审核日期] ASC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[PlanApproveDate] 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 Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org 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_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo 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_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode 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 ''%庞大%'' and 1=1)'

2025-10-30 10:28:26 执行时长：5.04秒 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='ISC0020')  and (a.roleid='' or a.roleid in (select roleid from base_userrole where userid='ISC0020'))  and (a.org='' or a.org='0001')

2025-10-30 10:34:06 执行时长：8.23秒 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 [已办暂停],审核计划.[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='510001549'

2025-10-30 10:34:07 执行时长：8.26秒 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-10-30 10:45:16 执行时长：10.4秒 sql:exec GB_PartnerBizStatistics '2025','ISC1604'