2025-08-26 09:56:08 执行时长：7.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-26 09:56:09 执行时长：7.23秒 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-26 09:56:09 执行时长：7.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-26 09:56:09 执行时长：7.33秒 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-26 09:56:10 执行时长：6.89秒 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-26 09:56:10 执行时长：7.05秒 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-26 09:56:10 执行时长：6.58秒 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-26 09:56:10 执行时长：7.32秒 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-26 09:56:10 执行时长：7.03秒 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-26 09:56:11 执行时长：7.31秒 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-26 09:56:11 执行时长：7.51秒 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-26 09:56:11 执行时长：7.72秒 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-26 09:56:11 执行时长：7.87秒 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-26 09:56:11 执行时长：7.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-26 09:56:11 执行时长：8.11秒 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-26 09:56:13 执行时长：8.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'' )'