【错误日志】本地时间:2022-07-27 11:35:35 --> 服务器时间:2022-07-27 11:28:11【异常】:开发人【周琴】,页面地址【/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.S7o5SdFOFJT(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:60a28e96-855b-4721-aadc-f3dc56f4bf29 【错误日志】本地时间:2022-07-27 14:14:25 --> 服务器时间:2022-07-27 14:07:02【异常】:开发人【周琴】,页面地址【/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.S7o5SdFOFJT(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:ae82897d-36d0-4754-aaf2-0509c0d361cc 【错误日志】本地时间:2022-07-27 14:15:53 --> 服务器时间:2022-07-27 14:08:29【异常】:开发人【周琴】,页面地址【/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.S7o5SdFOFJT(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:ae82897d-36d0-4754-aaf2-0509c0d361cc 【错误日志】本地时间:2022-07-27 14:48:37 --> 服务器时间:2022-07-27 14:41:13【异常】:开发人【周琴】,页面地址【/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.o1e5ScVH53j(Int32 , String , String , String , String , Int32 , Int32 ) ClientConnectionId:ae82897d-36d0-4754-aaf2-0509c0d361cc