2025-07-11 21:15:24 执行时长：6.14秒 sql:SELECT 项目进度查询.ID as [~ID~] ,项目进度查询.[ID] AS [系统主键],项目进度查询.[Createby] AS [创建者],项目进度查询.[UpdateVersion] AS [修改版本],[计划状态_计划状态].StatusCode AS [计划状态_Value],[计划状态_计划状态].StatusName AS [计划状态],[组织名称_组织信息].CorpID AS [组织名称_Value],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassCode AS [审核类别_Value],[审核类别_审核类别].ClassName AS [审核类别],[标准代码_认证标准].ID AS [标准代码_Value],[标准代码_认证标准].StandardCode AS [标准代码],项目进度查询.[ApplyDate] AS [申请日期],项目进度查询.[ApproveOn] AS [审批通过时间],[审核类型_审核类型].TypeCode AS [审核类型_Value],[审核类型_审核类型].TypeName AS [审核类型],项目进度查询.[ToScheduleDate] AS [转计调日期],项目进度查询.[PlanCommitDate] AS [计划提交时间],项目进度查询.[CommitDate] AS [审核员交卷日期],项目进度查询.[RetrivalDate] AS [分卷时间],项目进度查询.[ReviewDate] AS [阅卷完成时间],项目进度查询.[CertiCompletionDate] AS [证书完成日期],项目进度查询.[DecideOn] AS [认证决定日期],[合同来源_合同来源].Org AS [合同来源_Value],[合同来源_合同来源].OrgName AS [合同来源],项目进度查询.[PlanNo] AS [计划编号],项目进度查询.[ApplyNo] 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 项目进度查询.id='1863448045'