【错误日志】本地时间:2022-06-28 14:36:37 --> 服务器时间:2022-06-28 14:31:35【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): “)”附近有语法错误。 “)”附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.Oeg5JcNOqNO(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:086abb4c-090b-42eb-af40-059a6b7d7df9 【错误日志】本地时间:2022-06-28 14:36:38 --> 服务器时间:2022-06-28 14:31:36【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): “)”附近有语法错误。 “)”附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.Oeg5JcNOqNO(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:086abb4c-090b-42eb-af40-059a6b7d7df9 【错误日志】本地时间:2022-06-28 14:36:39 --> 服务器时间:2022-06-28 14:31:37【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): “)”附近有语法错误。 “)”附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.Oeg5JcNOqNO(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:086abb4c-090b-42eb-af40-059a6b7d7df9 【错误日志】本地时间:2022-06-28 14:36:39 --> 服务器时间:2022-06-28 14:31:37【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): “)”附近有语法错误。 “)”附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.Oeg5JcNOqNO(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:086abb4c-090b-42eb-af40-059a6b7d7df9 【错误日志】本地时间:2022-06-28 14:36:40 --> 服务器时间:2022-06-28 14:31:38【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): “)”附近有语法错误。 “)”附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.Oeg5JcNOqNO(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:086abb4c-090b-42eb-af40-059a6b7d7df9 【错误日志】本地时间:2022-06-28 14:36:41 --> 服务器时间:2022-06-28 14:31:39【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): “)”附近有语法错误。 “)”附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.Oeg5JcNOqNO(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:086abb4c-090b-42eb-af40-059a6b7d7df9 【错误日志】本地时间:2022-06-28 20:54:01 --> 服务器时间:2022-06-28 20:48:59【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): 关键字 'and' 附近有语法错误。 关键字 'and' 附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.XES5JdRymKr(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:4ea7b667-2701-4c32-86cc-722fa2016594 【错误日志】本地时间:2022-06-28 21:06:34 --> 服务器时间:2022-06-28 21:01:32【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): “)”附近有语法错误。 “)”附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.Oeg5JcNOqNO(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:f68c9ddc-63a7-4030-98b4-90c3ca4f9a16 【错误日志】本地时间:2022-06-28 21:17:47 --> 服务器时间:2022-06-28 21:12:45【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): 关键字 'and' 附近有语法错误。 关键字 'and' 附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.XES5JdRymKr(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:4ea7b667-2701-4c32-86cc-722fa2016594 【错误日志】本地时间:2022-06-28 21:20:10 --> 服务器时间:2022-06-28 21:15:08【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetCompany】,内容:System.Data.SqlClient.SqlException (0x80131904): 关键字 'and' 附近有语法错误。 关键字 'and' 附近有语法错误。 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 在 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.ExecuteReader(CommandBehavior behavior) 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.PagerPro(String tablename, String Fields, String strcondition, String orderkey, Int32 pageindex, Int32 pagesize, Int32& count) 在 LuZhouSafeProductionPlat.Common.CommonHelper.ExGetListPagerByProAll(String tableName, String fields, String strWhere, String orderKey, Int32 pageIndex, Int32 pageSize, Int32& count) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.XES5JdRymKr(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:4ea7b667-2701-4c32-86cc-722fa2016594