2025-09-28 15:10:18 执行时长：14.2秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 项目进度查询.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].StandardCode AS [标准代码],项目进度查询.[ToScheduleDate] AS [转计调日期],项目进度查询.[PlanCommitDate] AS [计划提交时间],项目进度查询.[CommitDate] AS [审核员交卷日期],项目进度查询.[RetrivalDate] AS [分卷时间],项目进度查询.[ReviewDate] AS [阅卷完成时间],项目进度查询.[CertiCompletionDate] AS [证书完成日期],项目进度查询.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName AS [合同来源],项目进度查询.[PlanNo] AS [计划编号] FROM GB_ProjectSchedule 项目进度查询 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 项目进度查询.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 项目进度查询.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 项目进度查询.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 项目进度查询.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 项目进度查询.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 项目进度查询.Org = [合同来源_合同来源].Org WHERE [审核类别_审核类别].[ClassName] <> ''一阶段'' AND [计划状态_计划状态].[StatusName] <> ''待联系'' and ( [项目进度查询].org =''23'' ) ',@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 Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 项目进度查询.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 项目进度查询.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 项目进度查询.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 项目进度查询.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 项目进度查询.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 项目进度查询.Org = [合同来源_合同来源].Org WHERE [审核类别_审核类别].[ClassName] <> ''一阶段'' AND [计划状态_计划状态].[StatusName] <> ''待联系'' and ( [项目进度查询].org =''23'' )'

2025-09-28 15:35:41 执行时长：6.55秒 sql:exec [GB_AuditorSchedule] '','','','','','','','','ISC-418501'