From 6deef5b408b08add4ad38314e37d7c6a38d4b031 Mon Sep 17 00:00:00 2001 From: wangsheng <123456> Date: 星期四, 09 九月 2021 17:24:00 +0800 Subject: [PATCH] 优化自动补发开关，不显示具体补发通道，显示通道时，显示通道ID+通道名，优化补发记录表显示问题 --- web/web/logs/err.txt | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 44 insertions(+), 0 deletions(-) diff --git a/web/web/logs/err.txt b/web/web/logs/err.txt index eaf8683..8c71894 100644 --- a/web/web/logs/err.txt +++ b/web/web/logs/err.txt @@ -535,3 +535,47 @@ Process ID: 7904 Session ID: 6 Serial number: 11866 +#6 2021-09-03 11:07:11,651 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#6 2021-09-03 11:07:17,336 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 408 + +#9 2021-09-03 11:07:17,644 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#9 2021-09-03 11:07:18,930 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 408 + +#6 2021-09-03 11:07:24,386 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#6 2021-09-03 11:08:09,005 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210902 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210902 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 408 + +#7 2021-09-03 11:08:45,659 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#7 2021-09-03 11:09:27,156 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1 from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) + -- Gitblit v1.9.1