2025-10-09 13:04:52 执行时长：5.13秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 项目进度查询.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],[计划状态_计划状态].StatusName AS [计划状态],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].StandardCode AS [标准代码],项目进度查询.[CertiCompletionDate] AS [证书完成日期],项目进度查询.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName AS [合同来源],项目进度查询.[ApplyDate] AS [申请日期],项目进度查询.[ApproveOn] AS [审批通过时间],项目进度查询.[CommitDate] AS [审核员交卷日期],项目进度查询.[RetrivalDate] AS [分卷时间],项目进度查询.[ReviewDate] AS [阅卷完成时间],项目进度查询.[ToScheduleDate] AS [转计调日期],项目进度查询.[PlanCommitDate] AS [计划提交时间],[审核类型_审核类型].TypeName AS [审核类型],项目进度查询.[PlanNo] AS [计划编号] FROM GB_ProjectSchedule 项目进度查询 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 项目进度查询.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 项目进度查询.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 项目进度查询.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 项目进度查询.StandardCode = [标准代码_认证标准].ID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 项目进度查询.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 项目进度查询.ApproveType = [审核类型_审核类型].TypeCode WHERE ([审核类别_审核类别].[ClassName] <> ''一阶段'' AND [计划状态_计划状态].[StatusName] <> ''待联系'') AND ([项目进度查询].DecideOn>=''2025-09-26 00:00'' and ([合同来源_合同来源].[OrgName] like ''%市场部%'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC,[组织名称] DESC,[审核类别] DESC,[计划状态] ASC',@OnlyID = N' SELECT DISTINCT 项目进度查询.ID as [~ID~] ,项目进度查询.[DecideOn] AS [认证决定日期],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],[计划状态_计划状态].StatusName AS [计划状态] FROM GB_ProjectSchedule 项目进度查询 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 项目进度查询.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 项目进度查询.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 项目进度查询.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 项目进度查询.StandardCode = [标准代码_认证标准].ID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 项目进度查询.Org = [合同来源_合同来源].Org LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 项目进度查询.ApproveType = [审核类型_审核类型].TypeCode WHERE ([审核类别_审核类别].[ClassName] <> ''一阶段'' AND [计划状态_计划状态].[StatusName] <> ''待联系'') AND ([项目进度查询].DecideOn>=''2025-09-26 00:00'' and ([合同来源_合同来源].[OrgName] like ''%市场部%''))'