【错误日志】本地时间:2022-12-26 14:00:43 --> 服务器时间:2022-12-26 13:51:28【异常】:开发人【周琴】,页面地址【/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.Q61QY1LRprb(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:4768c7a6-d765-499c-bd49-94f084d19700 【错误日志】本地时间:2022-12-26 14:15:14 --> 服务器时间:2022-12-26 14:05:58【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetAssistant】,内容:System.Exception: 列名 'AddTime' 无效。 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.Query(String SQLString) 在 LuZhouSafeProductionPlat.DAL.SafetyProduction_YearRecord.GetList(String strWhere) 在 LuZhouSafeProductionPlat.BLL.SafetyProduction_YearRecord.GetModelList(String strWhere) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.GetAssistant(String PersonId, Int32 Year, String Type) 【错误日志】本地时间:2022-12-26 14:15:47 --> 服务器时间:2022-12-26 14:06:31【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetAssistant】,内容:System.Exception: 列名 'AddTime' 无效。 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.Query(String SQLString) 在 LuZhouSafeProductionPlat.DAL.SafetyProduction_YearRecord.GetList(String strWhere) 在 LuZhouSafeProductionPlat.BLL.SafetyProduction_YearRecord.GetModelList(String strWhere) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.GetAssistant(String PersonId, Int32 Year, String Type) 【错误日志】本地时间:2022-12-26 14:15:48 --> 服务器时间:2022-12-26 14:06:32【异常】:开发人【周琴】,页面地址【/Government/SafetyProduction/PersonPerformDuties/Handler.ashx】,方法名【GetAssistant】,内容:System.Exception: 列名 'AddTime' 无效。 在 LuZhouSafeProductionPlat.DBUtility.DbHelperSQL.Query(String SQLString) 在 LuZhouSafeProductionPlat.DAL.SafetyProduction_YearRecord.GetList(String strWhere) 在 LuZhouSafeProductionPlat.BLL.SafetyProduction_YearRecord.GetModelList(String strWhere) 在 LuZhouSafeProductionPlat.Government.SafetyProduction.PersonPerformDuties.Handler.GetAssistant(String PersonId, Int32 Year, String Type) 【错误日志】本地时间:2022-12-26 15:16:31 --> 服务器时间:2022-12-26 15:07:15【异常】:开发人【周琴】,页面地址【/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.Q61QY1LRprb(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:d274bb4d-a08c-400c-aaeb-4dcc150a2b31 【错误日志】本地时间:2022-12-26 15:16:34 --> 服务器时间:2022-12-26 15:07: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.Q61QY1LRprb(Int32 , String , String , String , Int32 , Int32 ) ClientConnectionId:d274bb4d-a08c-400c-aaeb-4dcc150a2b31