2026-02-24 09:40:01 执行时长：11.75秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'')'

2026-02-24 09:41:22 执行时长：31.23秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:47:04 执行时长：5.5秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-214795'') AND ([审核计划].BeginDate>=''2026-02-01 00:00'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-214795'') AND ([审核计划].BeginDate>=''2026-02-01 00:00'')'

2026-02-24 09:47:22 执行时长：13.75秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[计划状态_计划状态].StatusName AS [计划状态],[评定状态_评定状态].StatusName AS [评定状态],[组织名称_组织信息].CorpName AS [组织名称],审核计划.[CertiQty] AS [体系人数],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[AuditTeam] AS [审核组],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[ContractNo] AS [合同编号],[合同来源_合同来源].OrgName AS [合同来源],[阅卷人员_登录用户].UserName AS [阅卷人员],[评定人员_登录用户].UserName AS [评定人员],审核计划.[CommitDate] AS [审核员交卷日期] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-330871'') AND ( 1=1 ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[审核开始日期] DESC,[组织名称] DESC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[BeginDate] AS [审核开始日期],[组织名称_组织信息].CorpName AS [组织名称] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN GB_ProjectPlanTeam [审核组组成] WITH(NOLOCK)  ON 审核计划.TaskNo = [审核组组成].TaskNo WHERE ([审核计划].[PlanStatus] >=''10''   AND [审核组组成].[AuditorCode] = ''ISC-330871'') AND ( 1=1 )'

2026-02-24 09:47:23 执行时长：5.78秒 sql:select count(*) from ( 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 ='31' )) AND ([项目进度查询].DecideOn>='2025-11-24 00:00') ) as CurrentCount

2026-02-24 09:47:30 执行时长：6.51秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 项目进度查询.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 =''31'' )) AND ([项目进度查询].DecideOn>=''2025-11-24 00:00'') ',@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 =''31'' )) AND ([项目进度查询].DecideOn>=''2025-11-24 00:00'')'

2026-02-24 09:47:41 执行时长：6.22秒 sql:select count(*) from ( SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [审核计划].[PlanStatus] > '02' AND [审核类型_审核类型].[TypeName] <> '变更' and ( [审核计划].org ='23' ) ) as CurrentCount

2026-02-24 09:48:06 执行时长：25.16秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],[组织名称_组织信息].CorpName AS [组织名称],[标准代码_认证标准].StandardCode AS [标准代码],[审核类别_审核类别].ClassName AS [审核类别],审核计划.[BeginDate] AS [审核开始日期],审核计划.[EndDate] AS [审核结束日期],审核计划.[ApproveDays] AS [审核天数],审核计划.[AuditTeam] AS [审核组],[审核方式_审核方式].ApproveMode AS [审核方式],[省份_省份].Province AS [省份],审核计划.[ProfessionalCode] AS [专业代码],审核计划.[IssuesToBeNoted] AS [审核需关注问题],审核计划.[PlanRemarks] AS [计划备注],[申请单号_认证申请].ApplyNo AS [申请单号],审核计划.[ContractNo] AS [合同编号],[认可标志_认可标志].RecogName AS [认可标志],审核计划.[UpdateOn] AS [修改时间] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''23'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[审核开始日期] DESC,[审核类别] DESC,[申请单号] ASC',@OnlyID = N' SELECT DISTINCT 审核计划.ID as [~ID~] ,审核计划.[UpdateOn] AS [修改时间],审核计划.[BeginDate] AS [审核开始日期],[审核类别_审核类别].ClassName AS [审核类别],[申请单号_认证申请].ApplyNo AS [申请单号] FROM GB_ProjectPlan 审核计划 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核计划.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核计划.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核计划.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核计划.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核计划.AuditForm = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 审核计划.Province = [省份_省份].ProvinceCode LEFT JOIN GB_CertiApply [申请单号_认证申请] WITH(NOLOCK) ON 审核计划.ApplyNo = [申请单号_认证申请].ApplyNo LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 审核计划.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核计划.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN Pub_AssessStatus [评定状态_评定状态] WITH(NOLOCK) ON 审核计划.AssessStatus = [评定状态_评定状态].StatusCode LEFT JOIN Pub_ApproveType [审核类型_审核类型] WITH(NOLOCK) ON 审核计划.ApproveType = [审核类型_审核类型].TypeCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核计划.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核计划.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_ContactResult [联系结果_联系结果] WITH(NOLOCK) ON 审核计划.ContactResults = [联系结果_联系结果].ResultCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 审核计划.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Base_UserV [阅卷人员_登录用户] WITH(NOLOCK) ON 审核计划.ReviewBy = [阅卷人员_登录用户].UserID LEFT JOIN Base_UserV [评定人员_登录用户] WITH(NOLOCK) ON 审核计划.DecideBy = [评定人员_登录用户].UserID LEFT JOIN Pub_Level [项目分级_案卷质量] WITH(NOLOCK) ON 审核计划.ProjectClassification = [项目分级_案卷质量].LevelCode LEFT JOIN Pub_Level [组长分级_案卷质量] WITH(NOLOCK) ON 审核计划.GroupLeaderGrading = [组长分级_案卷质量].LevelCode LEFT JOIN Pub_Level [案卷质量_案卷质量] WITH(NOLOCK) ON 审核计划.QualityOfCaseFiles = [案卷质量_案卷质量].LevelCode LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 审核计划.DecideResult = [批准结论_批准结论].ResultCode LEFT JOIN Base_UserV [合同申请接收人_登录用户] WITH(NOLOCK) ON 审核计划.Receiver = [合同申请接收人_登录用户].UserID LEFT JOIN GB_TrackingResults [跟踪结果_跟踪结果] WITH(NOLOCK) ON 审核计划.TrackingResults = [跟踪结果_跟踪结果].StatusCode WHERE [审核计划].[PlanStatus] > ''02'' AND [审核类型_审核类型].[TypeName] <> ''变更'' and ( [审核计划].org =''23'' )'

2026-02-24 09:48:57 执行时长：143.4秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'')'

2026-02-24 09:49:36 执行时长：149.35秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid='29') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='29') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='29') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='29')) and ([借调费].DecideOn>='2026-02-01')) ) as CurrentCount

2026-02-24 09:49:51 执行时长：284.87秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:39 执行时长：136.2秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'')'

2026-02-24 09:50:41 执行时长：329.66秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:42 执行时长：331.12秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:45 执行时长：331.62秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:45 执行时长：331.8秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:45 执行时长：332.19秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:49 执行时长：326.13秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:51 执行时长：337.56秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:51 执行时长：337.83秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:51 执行时长：337.84秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:51 执行时长：336.68秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:50:52 执行时长：93.39秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-02-01'')'

2026-02-24 09:51:36 执行时长：32.73秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'

2026-02-24 09:53:38 执行时长：31.12秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],借调费.[BeginDate] AS [审核开始日期],借调费.[EndDate] AS [审核结束日期],借调费.[ApproveDays] AS [审核天数],[组内职责_代码表].CodeName AS [组内职责],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[SettleDate] AS [结算日期],[计划状态_计划状态].StatusName AS [计划状态],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[认证决定日期] DESC',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 借调费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 借调费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 借调费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE ((([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''29'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''29'') ))) AND ([借调费].DecideOn>=''2026-01-01'')'