From 6deef5b408b08add4ad38314e37d7c6a38d4b031 Mon Sep 17 00:00:00 2001
From: wangsheng <123456>
Date: 星期四, 09 九月 2021 17:24:00 +0800
Subject: [PATCH] 优化自动补发开关，不显示具体补发通道，显示通道时，显示通道ID+通道名，优化补发记录表显示问题
---
web/Dao/GwSmDao.cs | 13 ++++++++++---
1 files changed, 10 insertions(+), 3 deletions(-)
diff --git a/web/Dao/GwSmDao.cs b/web/Dao/GwSmDao.cs
index 14b7cc3..2cce7b0 100644
--- a/web/Dao/GwSmDao.cs
+++ b/web/Dao/GwSmDao.cs
@@ -323,7 +323,7 @@
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
- public List<GwSm> LoadInfoList(string apMID, string opName, string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, string content, string opstat, int TStatus, out int recordcount, int pageSize, int pageIndex)
+ public List<GwSm> LoadInfoList(string apMID, string opName, string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, string content, string opstat, int TStatus, out int recordcount, int pageSize, int pageIndex,string ReSend=null)
{
List<GwSm> list1 = new List<GwSm>();
recordcount = 0;
@@ -331,8 +331,15 @@
{
string str = sDate.Replace("-", "");
StringBuilder stringBuilder = new StringBuilder();
- stringBuilder.Append("from LG_SM_").Append(str).Append(" sm left join GW_OP op on sm.op_id=op.op_id where 1=1 ");
- List<OracleParameter> list2 = new List<OracleParameter>();
+ if (ReSend == "ReSend")
+ {
+ stringBuilder.Append("from LG_SM_").Append(str).Append(" sm left join GW_OP op on sm.op_id=op.op_id where 1=1 and ResendStatus = 1 and ResendFlag = 0 ");
+ }
+ else
+ {
+ stringBuilder.Append("from LG_SM_").Append(str).Append(" sm left join GW_OP op on sm.op_id=op.op_id where 1=1 ");
+ }
+ List<OracleParameter> list2 = new List<OracleParameter>();
if (apMID != null && apMID != "")
{
OracleParameter oracleParameter = new OracleParameter(":ApMID", (OracleDbType)126);
--
Gitblit v1.9.1