concreteDbConn状态:Open
2025-12-02 16:46:13
Sql：select count(*) from ( SELECT DISTINCT 借调费.ID as [~ID~] ,借调费.[AuditorCode] AS [人员编号],借调费.[AuditorName] AS [人员姓名],[人员来源_组织机构].OrgName AS [人员来源],[组织名称_组织信息].CorpName AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],借调费.[ApproveDays] AS [审核天数],借调费.[LoanFee] AS [借调费],借调费.[DaysFee] AS [审核费],借调费.[DocFee] AS [文审费],借调费.[LeaderFee] AS [组长费],借调费.[ExpertFee] AS [技术专家费],借调费.[TotalFee] AS [费用合计],借调费.[PlanNo] AS [计划编号],借调费.[TaskNo] AS [任务编号],借调费.[PlanCommitDate] AS [计划提交日期],借调费.[SettleDate] AS [结算日期],借调费.[Remark] AS [费用说明],[项目归属合作方_合作单位].PartnerName AS [项目归属合作方],[人员归属合作方_合作单位].PartnerName AS [人员归属合作方],借调费.[DecideOn] AS [认证决定日期] FROM GB_LoanFee 借调费 WITH(NOLOCK)  LEFT JOIN Base_Org [人员来源_组织机构] WITH(NOLOCK) ON 借调费.AuditorOrg = [人员来源_组织机构].OrgID LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 借调费.Corp = [组织名称_组织信息].CorpID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 借调费.Org = [合同来源_合同来源].Org LEFT JOIN GB_Partner [项目归属合作方_合作单位] WITH(NOLOCK) ON 借调费.ProjectPartner = [项目归属合作方_合作单位].PartnerID LEFT JOIN GB_Partner [人员归属合作方_合作单位] WITH(NOLOCK) ON 借调费.AuditorPartner = [人员归属合作方_合作单位].PartnerID WHERE .SettleDate>='2025-12-01' ) as CurrentCount
Error：无法绑定由多个部分组成的标识符 ".SettleDate"。
   在 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