From 6c4ea53f92500f49959013c36b5c67fed25cd791 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期一, 11 十月 2021 19:00:15 +0800
Subject: [PATCH] 产品分配账户
---
web/Dao/GwClientDao.cs | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwClientDao.cs b/web/Dao/GwClientDao.cs
index 1d595b4..e3f102f 100644
--- a/web/Dao/GwClientDao.cs
+++ b/web/Dao/GwClientDao.cs
@@ -24,7 +24,7 @@
/// <param name="telphone">鑱旂郴鐢佃瘽</param>
/// <param name="agent">涓氬姟鍛�</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 company, string clientName, string telphone, string agent)
{
List<GwClient> list = new List<GwClient>();
@@ -39,6 +39,12 @@
oracleParameterArray[0] = new OracleParameter(":ClientID", (OracleDbType)126);
((DbParameter)oracleParameterArray[0]).Value = (object)('%' + clientID + '%');
stringBuilder.Append(" and CLIENT_ID like :ClientID");
+ }
+ if (company != null && company != "")
+ {
+ oracleParameterArray[1] = new OracleParameter(":Company", (OracleDbType)126);
+ ((DbParameter)oracleParameterArray[1]).Value = (object)('%' + company + '%');
+ stringBuilder.Append(" and Company like :Company");
}
if (clientName != null && clientName != "")
{
@@ -331,6 +337,7 @@
}
return true;
}
+
}
}
--
Gitblit v1.9.1