2026-02-03 13:01:33 执行时长：138.89秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01')) ) as CurrentCount

2026-02-03 13:01:34 执行时长：142.85秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid='[组织机构')) and ([借调费].DecideOn>='2026-01-01')) ) as CurrentCount

2026-02-03 13:01:41 执行时长：143.19秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01')) ) as CurrentCount

2026-02-03 13:01:53 执行时长：154.62秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01')) ) as CurrentCount

2026-02-03 13:03:56 执行时长：143.17秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01''))'

2026-02-03 13:04:00 执行时长：138.88秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01''))'

2026-02-03 13:04:05 执行时长：151.63秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01''))'

2026-02-03 13:04:11 执行时长：138.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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01''))'

2026-02-03 13:12:47 执行时长：72.48秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-02-25')) ) as CurrentCount

2026-02-03 13:13:27 执行时长：96.77秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-01-25')) ) as CurrentCount

2026-02-03 13:13:42 执行时长：120.14秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-02-25')) ) as CurrentCount

2026-02-03 13:14:40 执行时长：113.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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-02-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-02-25''))'

2026-02-03 13:14:53 执行时长：71.3秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-02-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-02-25''))'

2026-02-03 13:14:55 执行时长：87.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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25''))'

2026-02-03 13:15:45 执行时长：28.86秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid='[组织机构')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-01-25')) ) as CurrentCount

2026-02-03 13:16:14 执行时长：28.65秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25''))'

2026-02-03 13:17:07 执行时长：28.95秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid='[组织机构')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-01-25')) ) as CurrentCount

2026-02-03 13:17:36 执行时长：28.94秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25''))'

2026-02-03 13:19:32 执行时长：12.51秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,[项目状态_项目状态].Name AS [项目状态],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],认证申请.[ProjectLeader] AS [项目负责人],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[StaffQty] AS [组织人数],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE ([项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001''  or [认证申请].org =''01''  or [认证申请].org =''02''  or [认证申请].org =''03''  or [认证申请].org =''04''  or [认证申请].org =''05''  or [认证申请].org =''20''  or [认证申请].org =''21''  or [认证申请].org =''2101''  or [认证申请].org =''2102''  or [认证申请].org =''2103''  or [认证申请].org =''22''  or [认证申请].org =''23''  or [认证申请].org =''25''  or [认证申请].org =''2501''  or [认证申请].org =''26''  or [认证申请].org =''27''  or [认证申请].org =''29''  or [认证申请].org =''30''  or [认证申请].org =''301''  or [认证申请].org =''302''  or [认证申请].org =''303''  or [认证申请].org =''304''  or [认证申请].org =''305''  or [认证申请].org =''306''  or [认证申请].org =''307''  or [认证申请].org =''308''  or [认证申请].org =''309''  or [认证申请].org =''31''  or [认证申请].org =''310''  or [认证申请].org =''311''  or [认证申请].org =''312''  or [认证申请].org =''313''  or [认证申请].org =''315''  or [认证申请].org =''316''  or [认证申请].org =''32''  or [认证申请].org =''40''  or [认证申请].org =''41''  or [认证申请].org =''42''  or [认证申请].org =''43''  or [认证申请].org =''4301''  or [认证申请].org =''4302''  or [认证申请].org =''4303''  or [认证申请].org =''44''  or [认证申请].org =''45''  or [认证申请].org =''46''  or [认证申请].org =''48''  or [认证申请].org =''49''  or [认证申请].org =''50''  or [认证申请].org =''51'' )) AND ([项目状态_项目状态].[Name] =''已评审'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[UpdateOn] AS [修改时间] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE ([项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001''  or [认证申请].org =''01''  or [认证申请].org =''02''  or [认证申请].org =''03''  or [认证申请].org =''04''  or [认证申请].org =''05''  or [认证申请].org =''20''  or [认证申请].org =''21''  or [认证申请].org =''2101''  or [认证申请].org =''2102''  or [认证申请].org =''2103''  or [认证申请].org =''22''  or [认证申请].org =''23''  or [认证申请].org =''25''  or [认证申请].org =''2501''  or [认证申请].org =''26''  or [认证申请].org =''27''  or [认证申请].org =''29''  or [认证申请].org =''30''  or [认证申请].org =''301''  or [认证申请].org =''302''  or [认证申请].org =''303''  or [认证申请].org =''304''  or [认证申请].org =''305''  or [认证申请].org =''306''  or [认证申请].org =''307''  or [认证申请].org =''308''  or [认证申请].org =''309''  or [认证申请].org =''31''  or [认证申请].org =''310''  or [认证申请].org =''311''  or [认证申请].org =''312''  or [认证申请].org =''313''  or [认证申请].org =''315''  or [认证申请].org =''316''  or [认证申请].org =''32''  or [认证申请].org =''40''  or [认证申请].org =''41''  or [认证申请].org =''42''  or [认证申请].org =''43''  or [认证申请].org =''4301''  or [认证申请].org =''4302''  or [认证申请].org =''4303''  or [认证申请].org =''44''  or [认证申请].org =''45''  or [认证申请].org =''46''  or [认证申请].org =''48''  or [认证申请].org =''49''  or [认证申请].org =''50''  or [认证申请].org =''51'' )) AND ([项目状态_项目状态].[Name] =''已评审'')'

2026-02-03 13:21:29 执行时长：35.13秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-01-25')) ) as CurrentCount

2026-02-03 13:22:00 执行时长：31.6秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25''))'

2026-02-03 13:22:45 执行时长：29.02秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-01-25')) ) as CurrentCount

2026-02-03 13:23:15 执行时长：29.25秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] not in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25''))'

2026-02-03 13:28:05 执行时长：28.87秒 sql:select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid='46') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid='46') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid='[组织机构')) and ([借调费].DecideOn>='2026-01-01' and [借调费].DecideOn<='2026-01-25')) ) as CurrentCount

2026-02-03 13:28:37 执行时长：32.38秒 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25'')) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[合同来源] asc',@OnlyID = N' SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[DecideOn] AS [认证决定日期],[合同来源_合同来源].OrgName 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=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ) or ([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') or [借调费].[AuditorOrg] in (select OrgID  from View_Org where p_orgid=''46'') ))) AND (([借调费].[Org] in (select OrgID  from View_Org where p_orgid=''46'') and [借调费].[AuditorOrg] not in (select OrgID  from View_Org where p_orgid=''[组织机构'')) and ([借调费].DecideOn>=''2026-01-01'' and [借调费].DecideOn<=''2026-01-25''))'

2026-02-03 13:31:33 执行时长：13.45秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,[项目状态_项目状态].Name AS [项目状态],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],认证申请.[ProjectLeader] AS [项目负责人],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[StaffQty] AS [组织人数],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE ([项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001''  or [认证申请].org =''01''  or [认证申请].org =''02''  or [认证申请].org =''03''  or [认证申请].org =''04''  or [认证申请].org =''05''  or [认证申请].org =''20''  or [认证申请].org =''21''  or [认证申请].org =''2101''  or [认证申请].org =''2102''  or [认证申请].org =''2103''  or [认证申请].org =''22''  or [认证申请].org =''23''  or [认证申请].org =''25''  or [认证申请].org =''2501''  or [认证申请].org =''26''  or [认证申请].org =''27''  or [认证申请].org =''29''  or [认证申请].org =''30''  or [认证申请].org =''301''  or [认证申请].org =''302''  or [认证申请].org =''303''  or [认证申请].org =''304''  or [认证申请].org =''305''  or [认证申请].org =''306''  or [认证申请].org =''307''  or [认证申请].org =''308''  or [认证申请].org =''309''  or [认证申请].org =''31''  or [认证申请].org =''310''  or [认证申请].org =''311''  or [认证申请].org =''312''  or [认证申请].org =''313''  or [认证申请].org =''315''  or [认证申请].org =''316''  or [认证申请].org =''32''  or [认证申请].org =''40''  or [认证申请].org =''41''  or [认证申请].org =''42''  or [认证申请].org =''43''  or [认证申请].org =''4301''  or [认证申请].org =''4302''  or [认证申请].org =''4303''  or [认证申请].org =''44''  or [认证申请].org =''45''  or [认证申请].org =''46''  or [认证申请].org =''48''  or [认证申请].org =''49''  or [认证申请].org =''50''  or [认证申请].org =''51'' )) AND ([项目状态_项目状态].[Name] =''已评审'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[UpdateOn] AS [修改时间] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE ([项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001''  or [认证申请].org =''01''  or [认证申请].org =''02''  or [认证申请].org =''03''  or [认证申请].org =''04''  or [认证申请].org =''05''  or [认证申请].org =''20''  or [认证申请].org =''21''  or [认证申请].org =''2101''  or [认证申请].org =''2102''  or [认证申请].org =''2103''  or [认证申请].org =''22''  or [认证申请].org =''23''  or [认证申请].org =''25''  or [认证申请].org =''2501''  or [认证申请].org =''26''  or [认证申请].org =''27''  or [认证申请].org =''29''  or [认证申请].org =''30''  or [认证申请].org =''301''  or [认证申请].org =''302''  or [认证申请].org =''303''  or [认证申请].org =''304''  or [认证申请].org =''305''  or [认证申请].org =''306''  or [认证申请].org =''307''  or [认证申请].org =''308''  or [认证申请].org =''309''  or [认证申请].org =''31''  or [认证申请].org =''310''  or [认证申请].org =''311''  or [认证申请].org =''312''  or [认证申请].org =''313''  or [认证申请].org =''315''  or [认证申请].org =''316''  or [认证申请].org =''32''  or [认证申请].org =''40''  or [认证申请].org =''41''  or [认证申请].org =''42''  or [认证申请].org =''43''  or [认证申请].org =''4301''  or [认证申请].org =''4302''  or [认证申请].org =''4303''  or [认证申请].org =''44''  or [认证申请].org =''45''  or [认证申请].org =''46''  or [认证申请].org =''48''  or [认证申请].org =''49''  or [认证申请].org =''50''  or [认证申请].org =''51'' )) AND ([项目状态_项目状态].[Name] =''已评审'')'

2026-02-03 13:35:03 执行时长：8.92秒 sql:exec [GB_PartnerCertiStatistics]

2026-02-03 13:35:03 执行时长：9.1秒 sql:exec [GB_PartnerCertiStatistics]

2026-02-03 13:48:47 执行时长：8.84秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,[项目状态_项目状态].Name AS [项目状态],[组织名称_组织信息].CorpName AS [组织名称],认证申请.[ContractNo] AS [合同编号],认证申请.[BackReason] AS [合评问题记录],认证申请.[ProjectLeader] AS [项目负责人],[合同来源_合同来源].OrgName AS [合同来源],认证申请.[ApplyDate] AS [申请日期],认证申请.[AcceptDate] AS [受理日期],认证申请.[StaffQty] AS [组织人数],[受理评审人_登录用户].UserName AS [受理评审人],[受理评审结论_代码表].CodeName AS [受理评审结论],认证申请.[UpdateOn] AS [修改时间],认证申请.[ApproveBy] AS [审核者] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE [项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001''  or [认证申请].org =''01''  or [认证申请].org =''02''  or [认证申请].org =''03''  or [认证申请].org =''04''  or [认证申请].org =''05''  or [认证申请].org =''20''  or [认证申请].org =''21''  or [认证申请].org =''2101''  or [认证申请].org =''2102''  or [认证申请].org =''2103''  or [认证申请].org =''22''  or [认证申请].org =''23''  or [认证申请].org =''25''  or [认证申请].org =''2501''  or [认证申请].org =''26''  or [认证申请].org =''27''  or [认证申请].org =''29''  or [认证申请].org =''30''  or [认证申请].org =''301''  or [认证申请].org =''302''  or [认证申请].org =''303''  or [认证申请].org =''304''  or [认证申请].org =''305''  or [认证申请].org =''306''  or [认证申请].org =''307''  or [认证申请].org =''308''  or [认证申请].org =''309''  or [认证申请].org =''31''  or [认证申请].org =''310''  or [认证申请].org =''311''  or [认证申请].org =''312''  or [认证申请].org =''313''  or [认证申请].org =''315''  or [认证申请].org =''316''  or [认证申请].org =''32''  or [认证申请].org =''40''  or [认证申请].org =''41''  or [认证申请].org =''42''  or [认证申请].org =''43''  or [认证申请].org =''4301''  or [认证申请].org =''4302''  or [认证申请].org =''4303''  or [认证申请].org =''44''  or [认证申请].org =''45''  or [认证申请].org =''46''  or [认证申请].org =''48''  or [认证申请].org =''49''  or [认证申请].org =''50''  or [认证申请].org =''51'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 认证申请.ID as [~ID~] ,认证申请.[UpdateOn] AS [修改时间] FROM GB_CertiApply 认证申请 WITH(NOLOCK)  LEFT JOIN Pub_ProjectStatus [项目状态_项目状态] WITH(NOLOCK) ON 认证申请.ProjectStatus = [项目状态_项目状态].Code LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 认证申请.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 认证申请.Org = [合同来源_合同来源].Org LEFT JOIN Base_UserV [受理评审人_登录用户] WITH(NOLOCK) ON 认证申请.AcceptanceReviewer = [受理评审人_登录用户].UserID LEFT JOIN Pub_Code [受理评审结论_代码表] WITH(NOLOCK) ON 认证申请.Conclusion = [受理评审结论_代码表].CodeID LEFT JOIN Base_UserV [申请人_登录用户] WITH(NOLOCK) ON 认证申请.ApplyBy = [申请人_登录用户].UserID WHERE [项目状态_项目状态].[Name] in (''已提交'',''已评审'',''已退回'') and ( [认证申请].org =''0001''  or [认证申请].org =''01''  or [认证申请].org =''02''  or [认证申请].org =''03''  or [认证申请].org =''04''  or [认证申请].org =''05''  or [认证申请].org =''20''  or [认证申请].org =''21''  or [认证申请].org =''2101''  or [认证申请].org =''2102''  or [认证申请].org =''2103''  or [认证申请].org =''22''  or [认证申请].org =''23''  or [认证申请].org =''25''  or [认证申请].org =''2501''  or [认证申请].org =''26''  or [认证申请].org =''27''  or [认证申请].org =''29''  or [认证申请].org =''30''  or [认证申请].org =''301''  or [认证申请].org =''302''  or [认证申请].org =''303''  or [认证申请].org =''304''  or [认证申请].org =''305''  or [认证申请].org =''306''  or [认证申请].org =''307''  or [认证申请].org =''308''  or [认证申请].org =''309''  or [认证申请].org =''31''  or [认证申请].org =''310''  or [认证申请].org =''311''  or [认证申请].org =''312''  or [认证申请].org =''313''  or [认证申请].org =''315''  or [认证申请].org =''316''  or [认证申请].org =''32''  or [认证申请].org =''40''  or [认证申请].org =''41''  or [认证申请].org =''42''  or [认证申请].org =''43''  or [认证申请].org =''4301''  or [认证申请].org =''4302''  or [认证申请].org =''4303''  or [认证申请].org =''44''  or [认证申请].org =''45''  or [认证申请].org =''46''  or [认证申请].org =''48''  or [认证申请].org =''49''  or [认证申请].org =''50''  or [认证申请].org =''51'' )'