From c052583025ff87735d2120dc63aeee7ea5e5524e Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期三, 23 十一月 2022 09:25:11 +0800
Subject: [PATCH] 多项优化
---
web/Dao/GwSpDao.cs | 14 +++++++-------
1 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/web/Dao/GwSpDao.cs b/web/Dao/GwSpDao.cs
index 3c3843a..afb0514 100644
--- a/web/Dao/GwSpDao.cs
+++ b/web/Dao/GwSpDao.cs
@@ -249,7 +249,7 @@
return list1;
}
- public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string clientName, int routerType, string opID, int chargeType, int pageIndex, int pageSize
+ public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string company, int routerType, string opId, int chargeType, int pageIndex, int pageSize
, string resendStatus, string productId, string permissionsSQL, out int recordCount)
{
List<GwSp> list1 = new List<GwSp>();
@@ -288,9 +288,9 @@
list2.Add(new OracleParameter(":ClientID", (object)('%' + clientId + '%')));
stringBuilder.Append(" and CLIENT_ID like :ClientID");
}
- if (clientName != null && clientName != "")
+ if (company != null && company != "")
{
- stringBuilder.Append(" and CLIENT_ID IN (SELECT CLIENT_ID FROM GW_CLIENT WHERE CLIENT_NAME like '%" + clientName + "%' )");
+ stringBuilder.Append(" and CLIENT_ID IN (SELECT CLIENT_ID FROM GW_CLIENT WHERE COMPANY like '%" + company + "%' )");
}
/**
if (chargeType > 0)
@@ -309,20 +309,20 @@
{
list2.Add(new OracleParameter(":ROUTER_TYPE", (object)routerType));
stringBuilder.Append(" and ROUTER_TYPE=:ROUTER_TYPE");
- if (!string.IsNullOrEmpty(opID))
+ if (!string.IsNullOrEmpty(opId))
{
stringBuilder.Append(" and (CM_OP_ID=:OPID) OR (CT_OP_ID=:OPID) OR (UN_OP_ID=:OPID) ");
- list2.Add(new OracleParameter(":OPID", (object)opID));
+ list2.Add(new OracleParameter(":OPID", (object)opId));
}
}
if (routerType == 3)
{
list2.Add(new OracleParameter(":ROUTER_TYPE", (object)routerType));
stringBuilder.Append(" and ROUTER_TYPE=:ROUTER_TYPE");
- if (!string.IsNullOrEmpty(opID))
+ if (!string.IsNullOrEmpty(opId))
{
stringBuilder.Append(" and (CM_GROUP_ID=:OPID) OR (CU_GROUP_ID=:OPID) OR (CT_GROUP_ID=:OPID) ");
- list2.Add(new OracleParameter(":OPID", (object)opID));
+ list2.Add(new OracleParameter(":OPID", (object)opId));
}
}
}
--
Gitblit v1.9.1