2025-07-28 17:10:24 执行时长：5.48秒 sql:exec [GB_SuperRateStatistics] '2025','liudajun'
concreteDbConn状态:Open
2025-07-28 17:21:36
Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],人员信息表.[Address] AS [通讯地址],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[FirstEmploymentDate] AS [首聘日期],人员信息表.[EmploymentDate] AS [聘用日期],人员信息表.[ContractEndDate] AS [合同到期日],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],[人员归属_领域归属].OSName AS [人员归属],人员信息表.[StaffClass] AS [人员分类],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] 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 GB_PersonnelAffiliation [人员归属_领域归属] WITH(NOLOCK) ON 人员信息表.PersonnelAffiliation = [人员归属_领域归属].PriceCode LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN Pub_Code [合同类型_代码表] WITH(NOLOCK) ON 人员信息表.ContractType = [合同类型_代码表].CodeID WHERE (( [人员信息表].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 ='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' )) AND (EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = GB_AuditorRegister.auditorcode AND standardcode = '60')
AND EXISTS (SELECT 1 FROM GB_AuditorRegister WHERE [人员信息表].auditorcode = tGB_AuditorRegister.auditorcode AND standardcode = '65')) ) as CurrentCount
Error：无法绑定由多个部分组成的标识符 "tGB_AuditorRegister.auditorcode"。
   在 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-07-28 17:29:53
Sql：select count(*) from ( SELECT DISTINCT 人员信息表.ID as [~ID~] ,人员信息表.[AuditorCode] AS [人员编号],人员信息表.[AuditorName] AS [人员姓名],人员信息表.[Mobile] AS [手机号],[性别_代码表].CodeName AS [性别],[所在省份_省份].Province AS [所在省份],人员信息表.[Address] AS [通讯地址],[专兼职_代码表].CodeName AS [专兼职],人员信息表.[FirstEmploymentDate] AS [首聘日期],人员信息表.[EmploymentDate] AS [聘用日期],人员信息表.[ContractEndDate] AS [合同到期日],[聘用状态_代码表].CodeName AS [聘用状态],人员信息表.[Education] AS [学历],[职称_职称].TitleName AS [职称],人员信息表.[ProfessionalTitle] AS [职称专业],[组织机构_组织机构].OrgName AS [组织机构],[人员归属_领域归属].OSName AS [人员归属],人员信息表.[StaffClass] AS [人员分类],人员信息表.[BirthDay] AS [出生日期],人员信息表.[IDCard] AS [证件号码],人员信息表.[DismissalDate] 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 GB_PersonnelAffiliation [人员归属_领域归属] WITH(NOLOCK) ON 人员信息表.PersonnelAffiliation = [人员归属_领域归属].PriceCode LEFT JOIN Pub_IDCardClass [证件类型_证件类型] WITH(NOLOCK) ON 人员信息表.IDCardClass = [证件类型_证件类型].ClassCode LEFT JOIN Pub_Code [合同类型_代码表] WITH(NOLOCK) ON 人员信息表.ContractType = [合同类型_代码表].CodeID LEFT JOIN GB_AuditorRegister [注册与保持] WITH(NOLOCK)  ON 人员信息表.AuditorCode = [注册与保持].AuditorCode WHERE SELECT [人员编号] FROM [注册与保持] WHERE [标准代码] IN ('60', '65') GROUP BY [人员编号] HAVING COUNT(DISTINCT [标准代码]) = 2  AND [聘用状态_代码表].[CodeName] = '在聘' ) as CurrentCount
Error：关键字 'SELECT' 附近有语法错误。
“)”附近有语法错误。
   在 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