From 94f6f81692eee7567e24be26e63bc30460307cbd Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期一, 23 五月 2022 13:48:20 +0800
Subject: [PATCH] 客户归属权限优化
---
web/Dao/GwClientDao.cs | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwClientDao.cs b/web/Dao/GwClientDao.cs
index 54ac667..cae844f 100644
--- a/web/Dao/GwClientDao.cs
+++ b/web/Dao/GwClientDao.cs
@@ -107,7 +107,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 +141,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