concreteDbConn状态:Open
2025-07-15 17:18:06
Sql：select count([~ID~]) from ( SELECT DISTINCT 审核组组成.ID as [~ID~] ,审核组组成.[ID] AS [系统主键],审核组组成.[TaskNo] AS [任务编号],[标准代码_认证标准].StandardCode AS [标准代码],[人员编号_人员信息表].AuditorCode AS [人员编号],审核组组成.[AuditorName] AS [姓名],[性别_代码表].CodeName AS [性别],[组内职责_代码表].CodeName AS [组内职责],[审核方式_审核方式].ApproveMode AS [审核方式],[注册级别_人员资质类型].QCName AS [注册级别] FROM GB_ProjectPlanTeam 审核组组成 WITH(NOLOCK)  LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 审核组组成.StandardCode = [标准代码_认证标准].ID LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 审核组组成.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 审核组组成.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 审核组组成.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 审核组组成.ApproveMode = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 审核组组成.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 审核组组成.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Base_OrgV [人员来源_合同来源] WITH(NOLOCK) ON 审核组组成.Org = [人员来源_合同来源].Org where 1=1  and ([审核组组成].[计划编号] = '[审议问题].[计划编号]') ) 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