2025-12-17 11:24:36 执行时长：5.21秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[批准日期] desc',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~] ,费用结算明细表.[ApproveDate] AS [批准日期]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID'

2025-12-17 11:24:44 执行时长：5.04秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~] ,[合同来源_合同来源].OrgName AS [合同来源],费用结算明细表.[ContractNo] AS [合同编号],[组织名称_组织信息].CorpName AS [组织名称],[认证领域_认证领域].FieldName AS [认证领域],[审核类别_审核类别].ClassName AS [审核类别],费用结算明细表.[ChangeInfo] AS [变更描述],费用结算明细表.[ApproveDate] AS [批准日期],费用结算明细表.[CertiQty] AS [体系人数],[风险等级_代码表].CodeName AS [风险等级],费用结算明细表.[TotalFee] AS [合计],费用结算明细表.[ManageFee] AS [管理费],费用结算明细表.[MultiFee] AS [多场所费],费用结算明细表.[CertiFee] AS [证书费],费用结算明细表.[RecogFee] AS [认可费],费用结算明细表.[LoanFee] AS [借调费],费用结算明细表.[OtherFee] AS [其他费用],(case 费用结算明细表.[ExceptFee] when 1 then ''√'' else '''' end) AS [异议],费用结算明细表.[ExceptDesc] AS [异议说明],[认可标志_认可标志].RecogName AS [认可标志],[处理人_用户].UserName AS [处理人],(case 费用结算明细表.[Processed] when 1 then ''√'' else '''' end) AS [已处理],费用结算明细表.[Remark] AS [备注],费用结算明细表.[PayDate] AS [结算日期],费用结算明细表.[BeginDate] AS [审核开始日期] FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[批准日期] desc',@OnlyID = N' SELECT DISTINCT 费用结算明细表.ID as [~ID~] ,费用结算明细表.[ApproveDate] AS [批准日期]  FROM GB_FeeSettle 费用结算明细表 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 费用结算明细表.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 费用结算明细表.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 费用结算明细表.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 费用结算明细表.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 费用结算明细表.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Recog [认可标志_认可标志] WITH(NOLOCK) ON 费用结算明细表.RecognitionMark = [认可标志_认可标志].RecogCode LEFT JOIN Base_User [处理人_用户] WITH(NOLOCK) ON 费用结算明细表.ProccessBy = [处理人_用户].UserID LEFT JOIN GB_Partner [合作单位_合作单位] WITH(NOLOCK) ON 费用结算明细表.PartnerID = [合作单位_合作单位].PartnerID LEFT JOIN GB_PackageFeeRule [匹配包干费规则_包干费收费标准] WITH(NOLOCK) ON 费用结算明细表.RuleID = [匹配包干费规则_包干费收费标准].RuleID'