2026-02-28 17:21:08 执行时长：5.33秒 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 [风险等级],人员专业能力.[SourceOfAbility] 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 WHERE ((([人员编号_人员信息表].[Org] = ''25'' OR [人员编号_人员信息表].[IsPublic] =1))) 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 WHERE ((([人员编号_人员信息表].[Org] = ''25'' OR [人员编号_人员信息表].[IsPublic] =1))) AND (([认证领域_认证领域].[FieldName] like ''%能源管理体系%''))'

2026-02-28 17:39:09 执行时长：7.06秒 sql:SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],[中类编码_专业中类].MediumClassEncoding AS [中类编码],人员专业能力.[TechField] AS [技术领域],[大类编码_专业大类].CategoryEncoding AS [大类编码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],人员专业能力.[SourceOfAbility] 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 WHERE ([人员编号_人员信息表].[StaffStatus] = '127' 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' )) AND (([认证领域_认证领域].[FieldName] like '%环境管理体系%'))

2026-02-28 17:53:13 执行时长：282.2秒 sql:UPDATE GB_AuditorProfessional SET  [TechField]=N'39-5',updateby= '刘达军',updateon='2026-02-28 17:48:31' ,updateversion=updateversion+1  WHERE ID='508006866ISC0028'

2026-02-28 17:55:30 执行时长：8.78秒 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 [风险等级],人员专业能力.[SourceOfAbility] 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 WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'' 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'' )) AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%'')) ',@PageSize = 100, @PageCurrent = 322, @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 WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'' 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'' )) AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%''))'

2026-02-28 17:56:22 执行时长：8.55秒 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 [风险等级],人员专业能力.[SourceOfAbility] 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 WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'' 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'' )) AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%'')) ',@PageSize = 100, @PageCurrent = 321, @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 WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'' 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'' )) AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%''))'

2026-02-28 17:57:31 执行时长：10.95秒 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 [风险等级],人员专业能力.[SourceOfAbility] 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 WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'' 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'' )) AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%'')) ',@PageSize = 100, @PageCurrent = 322, @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 WHERE ([人员编号_人员信息表].[StaffStatus] = ''127'' 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'' )) AND (([认证领域_认证领域].[FieldName] like ''%环境管理体系%''))'