From 3b18a48485f7207438d9d0eb3038d979e069431d Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期四, 26 五月 2022 17:58:18 +0800
Subject: [PATCH] 优化产品及产品分类，订单，对称加密，IP转地区名称
---
web/Dao/GwClientDao.cs | 20 +++++++++++++++++---
1 files changed, 17 insertions(+), 3 deletions(-)
diff --git a/web/Dao/GwClientDao.cs b/web/Dao/GwClientDao.cs
index 54ac667..63c97d9 100644
--- a/web/Dao/GwClientDao.cs
+++ b/web/Dao/GwClientDao.cs
@@ -23,9 +23,13 @@
/// <param name="clientName">鑱旂郴浜�</param>
/// <param name="telphone">鑱旂郴鐢佃瘽</param>
/// <param name="agent">涓氬姟鍛�</param>
+ /// <param name="company">鍏徃鍚嶇О</param>
+ /// <param name="salesman">褰掑睘涓氬姟鍛�</param>
+ /// <param name="supportStaff">褰掑睘瀹㈡湇浜哄憳</param>
+ /// <param name="productId">浜у搧ID</param>
/// <returns></returns>
//public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telphone, string agent)
- public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telphone, string agent, string company, string salesman, string productId, string permissionsSQL )
+ public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telphone, string agent, string company, string salesman, string supportStaff, string productId, string permissionsSQL )
{
List<GwClient> list = new List<GwClient>();
@@ -34,7 +38,7 @@
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("from GW_CLIENT where 1=1");
- OracleParameter[] oracleParameterArray = new OracleParameter[6];
+ OracleParameter[] oracleParameterArray = new OracleParameter[7];
if (clientID != null && clientID != "")
{
oracleParameterArray[0] = new OracleParameter(":ClientID", (OracleDbType)126);
@@ -70,6 +74,12 @@
oracleParameterArray[5] = new OracleParameter(":Agent", (OracleDbType)126);
((DbParameter)oracleParameterArray[5]).Value = (object)("%" + agent + "%");
stringBuilder.Append(" and Agent like :Agent");
+ }
+ if (supportStaff != null && supportStaff != "")
+ {
+ oracleParameterArray[6] = new OracleParameter(":SupportStaff", (OracleDbType)126);
+ ((DbParameter)oracleParameterArray[6]).Value = (object)(supportStaff);
+ stringBuilder.Append(" and SUPPORT_STAFF = :SupportStaff");
}
if (productId != null && productId != "")
@@ -107,7 +117,7 @@
/**
* 鏌ヨ缁熻鍔熻兘
*/
- public List<GwClient> LoadInfoList(string clientID, string clientName, string company, string agent)
+ public List<GwClient> LoadInfoList(string clientID, string clientName, string company, string agent, string permissionsSQL)
{
@@ -141,6 +151,10 @@
((DbParameter)oracleParameterArray[3]).Value = (object)("%" + agent + "%");
stringBuilder.Append(" and Agent like :Agent");
}
+
+ //瀹㈡埛鏉冮檺SQL鑴氭湰
+ stringBuilder.Append(permissionsSQL);
+
stringBuilder.Append(" order by CREATE_TIME DESC,CLIENT_ID DESC");
using (OracleDataReader reader = OracleHelper.ExecuteReader("select * " + stringBuilder.ToString(), OracleHelper.Connection, oracleParameterArray))
{
--
Gitblit v1.9.1