concreteDbConn状态:Open 2025-09-16 10:08:10 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '46' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%三体系人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%重庆市%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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 2025-09-16 10:08:21 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '46' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%三体系人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%重庆市%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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 2025-09-16 10:08:23 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '46' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%三体系人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%重庆市%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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 2025-09-16 10:08:24 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '46' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%三体系人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%重庆市%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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 2025-09-16 10:08:29 Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],[专兼职_代码表].CodeName AS [专兼职],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],人员信息表.[UpdateOn] AS [修改时间] FROM GB_Auditor 人员信息表 WITH(NOLOCK) LEFT JOIN Pub_Code [性别_代码表] WITH(NOLOCK) ON 人员信息表.Gender = [性别_代码表].CodeID LEFT JOIN Pub_Province [所在省份_省份] WITH(NOLOCK) ON 人员信息表.Province = [所在省份_省份].ProvinceCode LEFT JOIN Pub_Code [专兼职_代码表] WITH(NOLOCK) ON 人员信息表.WorkType = [专兼职_代码表].CodeID LEFT JOIN Pub_Code [聘用状态_代码表] WITH(NOLOCK) ON 人员信息表.StaffStatus = [聘用状态_代码表].CodeID LEFT JOIN Pub_DutyTitle [职称_职称] WITH(NOLOCK) ON 人员信息表.DutyTitle = [职称_职称].TitleCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员信息表.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK) ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE ((([注册与保持].[Org] = '46' OR [人员信息表].[IsPublic] =1 ))) AND (([人员归属_领域归属].[OSName] like '%三体系人员%') and ([聘用状态_代码表].[CodeName] like '%在聘%') and ([所在省份_省份].[Province] like '%重庆市%')) ) as CurrentCount Error：无法绑定由多个部分组成的标识符 "人员归属_领域归属.OSName"。 在 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 2025-09-16 10:47:38 执行时长：5.14秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK) LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount