concreteDbConn状态:Open
2026-03-20 10:11:12
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:12
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>='2026-03-20' 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='29') 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
2026-03-20 10:11:19
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:19
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>='2026-03-20' 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='29') 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
2026-03-20 10:11:24
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:24
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>='2026-03-20' 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='29') 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
2026-03-20 10:11:25
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:25
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>='2026-03-20' 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='29') 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
2026-03-20 10:11:26
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:26
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>='2026-03-20' 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='29') 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
2026-03-20 10:11:26
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:26
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>='2026-03-20' 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='29') 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
2026-03-20 10:11:27
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:27
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>='2026-03-20' 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='29') 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
2026-03-20 10:11:35
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:11:35
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>='2026-03-20' 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='29') 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
2026-03-20 10:18:25
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>=''2026-03-20'' 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=''0001'') 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
2026-03-20 10:18:25
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>='2026-03-20' 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='0001') 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
2026-03-20 10:18:27
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>=''2026-03-20'' 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=''0001'') 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
2026-03-20 10:18:27
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>='2026-03-20' 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='0001') 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
2026-03-20 10:18:30
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>=''2026-03-20'' 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=''0001'') or a.ispublic=1 ) and j.ProfessionalCode in  ( ''17.09.00''  ,''17.10.01''  ,''17.10.02'' )  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
2026-03-20 10:18:30
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>='2026-03-20' 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='0001') or a.ispublic=1 ) and j.ProfessionalCode in  ( '17.09.00'  ,'17.10.01'  ,'17.10.02' )  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
2026-03-20 10:18:31
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>=''2026-03-20'' 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=''0001'') or a.ispublic=1 ) and j.ProfessionalCode in  ( ''17.09.00''  ,''17.10.01''  ,''17.10.02'' )  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
2026-03-20 10:18:31
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>='2026-03-20' 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='0001') or a.ispublic=1 ) and j.ProfessionalCode in  ( '17.09.00'  ,'17.10.01'  ,'17.10.02' )  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
2026-03-20 10:18:35
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>=''2026-03-20'' 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=''0001'') 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
2026-03-20 10:18:36
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>='2026-03-20' 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='0001') 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
2026-03-20 10:18:38
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>=''2026-03-20'' 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=''0001'') 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
2026-03-20 10:18:38
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>='2026-03-20' 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='0001') 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
2026-03-20 10:20:18
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:20:18
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>='2026-03-20' 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='29') 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
2026-03-20 10:20:19
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>=''2026-03-20'' 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=''29'') 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
2026-03-20 10:20:19
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>='2026-03-20' 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='29') 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
2026-03-20 10:24:30
Sql：select count(*) from ( SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].TaskNo LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status='hide' and userid='ISC-300074')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-300074' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='0001') )  ) as CurrentCount
Error：列名 'TaskNo' 无效。
   在 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
2026-03-20 10:24:55
Sql：select count(*) from ( SELECT DISTINCT 公告.ID as [~ID~] ,公告.[CreateOn] AS [创建时间] FROM Base_Announce 公告 WITH(NOLOCK)  LEFT JOIN Base_AnnounceOrg [可见部门] WITH(NOLOCK)  ON 公告.ID = [可见部门].TaskNo LEFT JOIN Base_AnnounceStaff [可见人员] WITH(NOLOCK)  ON 公告.ID = [可见人员].AnnounceID WHERE [公告].[ID] not in (select id from Base_BizEntityStatus where status='hide' and userid='ISC-300074')   AND ([公告].[IsPublic] =1 or [可见人员].[UserID] = 'ISC-300074' or exists (select orgid from View_Org where View_Org.p_orgid=[可见部门].org and View_Org.orgid='0001') )  ) as CurrentCount
Error：列名 'TaskNo' 无效。
   在 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