concreteDbConn状态:Open 2025-07-22 16:08:01 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and a.AuditorCode in (SELECT AuditorCode FROM GB_AuditorRegister WHERE StandardCode IN() and IsEffective = ''27'' GROUP BY AuditorCode HAVING COUNT(DISTINCT StandardCode) >= 0) and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:01 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and a.AuditorCode in (SELECT AuditorCode FROM GB_AuditorRegister WHERE StandardCode IN() and IsEffective = '27' GROUP BY AuditorCode HAVING COUNT(DISTINCT StandardCode) >= 0) and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:03 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) and j.ProfessionalCode in ( ''19.05.01'' ,''29.09.01'' ,''29.10.07'' ,''33.02.01'' ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:03 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) and j.ProfessionalCode in ( '19.05.01' ,'29.09.01' ,'29.10.07' ,'33.02.01' ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:08 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:08 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:08 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:08 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:08 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:09 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：EXEC dbo.p_show @QueryStr = N' select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>=''2025-07-22'' and IsEffective=''27'' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like ''%邓%'' and h.StandardCode in () and a.StaffStatus = ''127'' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID=''25'') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ',@PageSize = 50, @PageCurrent = 1, @FdShow = '',@FdOrder = '' Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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-22 16:08:10 Sql：select count(id) from ( select a.id, a.AuditorCode as 人员编号,a.AuditorName as 姓名,b.CodeName as 性别, BirthDay as 出生日期,PartyType as 政治面貌,MAX(c. Education) as 学历,d.TitleName as 职称, a.ProfessionalTitle as 职称专业,a.address as 通讯地址,e.Province as 省份, Mobile as 手机,Email ,OrgName as 区域,g.CodeName as 专兼职,StaffClass as 人员分类 from GB_Auditor a left join Pub_Code b on a.Gender=b.CodeID left join GB_AuditorEducation c on a.auditorcode=c.AuditorCode left join Pub_DutyTitle d on a.DutyTitle=d.TitleCode left join Pub_Province e on a.Province=e.ProvinceCode left join Base_Org f on a.Org=f.OrgID left join Pub_Code g on a.WorkType=g.CodeID left join GB_AuditorRegister h on a.auditorcode=h.AuditorCode and h.EndDate>='2025-07-22' and IsEffective='27' left join GB_AuditorProfessional i on a.AuditorCode=i.AuditorCode left join Pub_ProfessionalCode j on i.professionalcode=j.id where 1=1 and a.AuditorName like '%邓%' and h.StandardCode in () and a.StaffStatus = '127' and (a.Org in (select b.Org from View_Org a left join Base_OrgV b on a.OrgID=b.Org where P_orgID='25') or a.ispublic=1 ) group by a.id,a.AuditorCode,a.AuditorName,b.CodeName,BirthDay,PartyType,d.TitleName, a.ProfessionalTitle,a.address,e.Province,a.Mobile,Email,OrgName,g.CodeName, StaffClass ) as CurrentCount Error：“)”附近有语法错误。 关键字 'or' 附近有语法错误。 在 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