【错误日志】本地时间:2023-02-07 16:54:12 --> 服务器时间:2023-02-07 16:44:21【异常】:开发人【周琴】,页面地址【/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:38f82271-f49d-4697-b309-36440671bf32 【错误日志】本地时间:2023-02-07 17:29:04 --> 服务器时间:2023-02-07 17:19:13【异常】:开发人【周琴】,页面地址【/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:921b602b-b021-4787-b820-51b23e2c2e92 【错误日志】本地时间:2023-02-07 17:35:26 --> 服务器时间:2023-02-07 17:25:35【异常】:开发人【周琴】,页面地址【/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:921b602b-b021-4787-b820-51b23e2c2e92 【错误日志】本地时间:2023-02-07 17:49:41 --> 服务器时间:2023-02-07 17:39:50【异常】:开发人【周琴】,页面地址【/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) 【错误日志】本地时间:2023-02-07 18:02:26 --> 服务器时间:2023-02-07 17:52:35【异常】:开发人【周琴】,页面地址【/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) 【错误日志】本地时间:2023-02-07 18:05:34 --> 服务器时间:2023-02-07 17:55:43【异常】:开发人【周琴】,页面地址【/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) 【错误日志】本地时间:2023-02-07 18:15:11 --> 服务器时间:2023-02-07 18:05:20【异常】:开发人【周琴】,页面地址【/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:719cbecd-82a8-413a-8af9-049ad5947328 【错误日志】本地时间:2023-02-07 18:17:12 --> 服务器时间:2023-02-07 18:07:21【异常】:开发人【周琴】,页面地址【/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) 【错误日志】本地时间:2023-02-07 18:40:01 --> 服务器时间:2023-02-07 18:30:10【异常】:开发人【周琴】,页面地址【/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)