2026-02-02 14:01:53 执行时长：8.85秒 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'' )'

2026-02-02 14:17:12 执行时长：8.7秒 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'' )'

2026-02-02 14:23:55 执行时长：12.82秒 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] =''已评审'')'
concreteDbConn状态:Open
2026-02-02 14:55:19
Sql：select count(*) from ( SELECT DISTINCT 审核费.ID as [~ID~] ,审核费.[DecideOn] AS [认证决定日期] FROM GB_AuditFee 审核费 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 审核费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 审核费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 审核费.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 审核费.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核费.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核费.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核费.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_AuditFeeRule [匹配规则_审核费结算规则] WITH(NOLOCK) ON 审核费.RuleCode = [匹配规则_审核费结算规则].RuleCode WHERE ((([审核费_合同来源].[组织机构编号] in (select OrgID  from View_Org where p_orgid='21')


))) AND ([审核费].DecideOn>='2026-01-01' and [审核费].DecideOn<='2026-01-31') ) as CurrentCount
Error：无法绑定由多个部分组成的标识符 "审核费_合同来源.组织机构编号"。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207
concreteDbConn状态:Open
2026-02-02 14:55:20
Sql：select count(*) from ( SELECT DISTINCT 审核费.ID as [~ID~] ,审核费.[DecideOn] AS [认证决定日期] FROM GB_AuditFee 审核费 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 审核费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 审核费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 审核费.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 审核费.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核费.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核费.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核费.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_AuditFeeRule [匹配规则_审核费结算规则] WITH(NOLOCK) ON 审核费.RuleCode = [匹配规则_审核费结算规则].RuleCode WHERE ((([审核费_合同来源].[组织机构编号] in (select OrgID  from View_Org where p_orgid='21')


))) AND ([审核费].DecideOn>='2026-01-01' and [审核费].DecideOn<='2026-01-31') ) as CurrentCount
Error：无法绑定由多个部分组成的标识符 "审核费_合同来源.组织机构编号"。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207
concreteDbConn状态:Open
2026-02-02 14:55:21
Sql：select count(*) from ( SELECT DISTINCT 审核费.ID as [~ID~] ,审核费.[DecideOn] AS [认证决定日期] FROM GB_AuditFee 审核费 WITH(NOLOCK)  LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 审核费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 审核费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 审核费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 审核费.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 审核费.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 审核费.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核费.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 审核费.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 审核费.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_PlanStatus [计划状态_计划状态] WITH(NOLOCK) ON 审核费.PlanStatus = [计划状态_计划状态].StatusCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 审核费.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_AuditFeeRule [匹配规则_审核费结算规则] WITH(NOLOCK) ON 审核费.RuleCode = [匹配规则_审核费结算规则].RuleCode WHERE ((([审核费_合同来源].[组织机构编号] in (select OrgID  from View_Org where p_orgid='21')


))) AND ([审核费].DecideOn>='2026-01-01' and [审核费].DecideOn<='2026-01-31') ) as CurrentCount
Error：无法绑定由多个部分组成的标识符 "审核费_合同来源.组织机构编号"。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 Redsoft.DatabaseProvider.DbAccess.Query(String sql) 位置 D:\MyProduct\GMIS2020\DatabaseProvider\DbAccess.cs:行号 207