2026-01-30 08:44:41 执行时长：12.69秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,[项目状态_项目状态].Name AS [项目状态],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],认证申请.[ProjectLeader] AS [项目负责人],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[StaffQty] AS [组织人数],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE [项目状态_项目状态].[Name] 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''  or [认证申请].org =''51'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[UpdateOn] AS [修改时间] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE [项目状态_项目状态].[Name] 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''  or [认证申请].org =''51'' )'

2026-01-30 08:48:33 执行时长：8.21秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[TechField] AS [技术领域],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期],人员专业能力.[Remark] 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'') AND (([认证领域_认证领域].[FieldName] like ''%信息安全管理体系%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 人员专业能力.ID as [~ID~]  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'') AND (([认证领域_认证领域].[FieldName] like ''%信息安全管理体系%''))'

2026-01-30 08:49:16 执行时长：8.17秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[TechField] AS [技术领域],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期],人员专业能力.[Remark] 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'') AND (([认证领域_认证领域].[FieldName] like ''%信息技术服务管理体系%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 人员专业能力.ID as [~ID~]  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'') AND (([认证领域_认证领域].[FieldName] like ''%信息技术服务管理体系%''))'

2026-01-30 08:49:44 执行时长：7.58秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[TechField] AS [技术领域],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期],人员专业能力.[Remark] 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'') AND (([认证领域_认证领域].[FieldName] like ''%信息安全管理体系%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '',@OnlyID = N' SELECT DISTINCT 人员专业能力.ID as [~ID~]  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'') AND (([认证领域_认证领域].[FieldName] like ''%信息安全管理体系%''))'