【错误日志】本地时间:2022-10-31 16:11:52 --> 服务器时间:2022-10-31 16:00:18【异常】:开发人【周琴】,页面地址【/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.Sb5i7bHddvu(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:b56b3e87-d993-4069-9c2e-89f3d99ba63b 【错误日志】本地时间:2022-10-31 16:17:17 --> 服务器时间:2022-10-31 16:05:43【异常】:开发人【周琴】,页面地址【/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.Sb5i7bHddvu(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:e32b2fa2-2195-46f1-8c9a-3ae38f0af8cf 【错误日志】本地时间:2022-10-31 16:17:34 --> 服务器时间:2022-10-31 16:06:00【异常】:开发人【周琴】,页面地址【/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.Sb5i7bHddvu(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:b56b3e87-d993-4069-9c2e-89f3d99ba63b 【错误日志】本地时间:2022-10-31 20:53:40 --> 服务器时间:2022-10-31 20:42:06【异常】:开发人【周琴】,页面地址【/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.Sb5i7bHddvu(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:7bdb69bd-0efa-43e8-9ef1-a03baa62657a 【错误日志】本地时间:2022-10-31 20:53:41 --> 服务器时间:2022-10-31 20:42: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.Sb5i7bHddvu(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:7bdb69bd-0efa-43e8-9ef1-a03baa62657a 【错误日志】本地时间:2022-10-31 20:53:51 --> 服务器时间:2022-10-31 20:42:17【异常】:开发人【周琴】,页面地址【/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.Sb5i7bHddvu(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:7bdb69bd-0efa-43e8-9ef1-a03baa62657a