2026-03-22 09:25:11 执行时长：19.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-03-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-03-01'')'

2026-03-22 09:25:32 执行时长：29.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-03-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-03-01'')'

2026-03-22 09:26:15 执行时长：64.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-03-22 09:26:59 执行时长：52.77秒 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 ([人员来源_组织机构].[OrgName] like ''%王蓓蓓%'' 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 ([人员来源_组织机构].[OrgName] like ''%王蓓蓓%'' and [借调费].DecideOn>=''2026-01-01'')'

2026-03-22 09:28:13 执行时长：49.53秒 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 ([人员来源_组织机构].[OrgName] like ''%王蓓蓓%'' 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 ([人员来源_组织机构].[OrgName] like ''%王蓓蓓%'' and [借调费].DecideOn>=''2026-01-01'')'

2026-03-22 09:28:44 执行时长：23.69秒 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-03-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-03-01'')'

2026-03-22 09:29:25 执行时长：54.7秒 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'')'