2025-08-21 14:18:20 执行时长：5.42秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] 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' ) as CurrentCount

2025-08-21 14:26:29 执行时长：5.06秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:29 执行时长：5.19秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:29 执行时长：5.2秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:29 执行时长：5.12秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:29 执行时长：5.13秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:30 执行时长：5.09秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:30 执行时长：5.74秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:30 执行时长：5.59秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:30 执行时长：5.61秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:31 执行时长：5.62秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:31 执行时长：6.39秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'

2025-08-21 14:26:31 执行时长：6.47秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[项目编号_认证项目].ProjectNo AS [项目编号],证书信息.[OrganizationName] AS [组织名称],证书信息.[CertiNo] AS [证书编号],[证书类别_代码表].CodeName AS [证书类别],证书信息.[FirstCertiDate] AS [初次获证日期],证书信息.[RegiDate] AS [有效期起],证书信息.[RegiToDate] AS [有效期至],证书信息.[ChangeDate] AS [换证日期],[证书状态_证书状态].StatusName AS [证书状态],[标准代码_认证标准].StandardCode AS [标准代码],[审核类型_审核类型].TypeName AS [审核类型],证书信息.[Fee] AS [费用] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[有效期至] DESC',@OnlyID = N' SELECT DISTINCT 证书信息.ID as [~ID~] ,证书信息.[RegiToDate] AS [有效期至] FROM GB_ProjectPlanCerti 证书信息 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书信息.Org = [合同来源_合同来源].Org LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书信息.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_Code [证书类别_代码表] WITH(NOLOCK) ON 证书信息.CertiClass = [证书类别_代码表].CodeID LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书信息.CertifacateStatus = [证书状态_证书状态].StatusCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 证书信息.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 证书信息.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书信息.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_Corp [组织编号_组织信息] WITH(NOLOCK) ON 证书信息.CorpID = [组织编号_组织信息].CorpID LEFT JOIN Pub_ChangeReason [换证原因_换证原因] WITH(NOLOCK) ON 证书信息.ChangeReason = [换证原因_换证原因].ReasonCode LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书信息.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书信息.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书信息.RevokeReason = [注销原因_注销原因].ReasonCode WHERE ( [证书信息].org =''25''  or [证书信息].org =''2501'' )'