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/GwSpDao.cs | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/web/Dao/GwSpDao.cs b/web/Dao/GwSpDao.cs
index 7bfd4a5..492f708 100644
--- a/web/Dao/GwSpDao.cs
+++ b/web/Dao/GwSpDao.cs
@@ -208,7 +208,7 @@
return OracleHelper.Execute(PubConstant.doOracleSql(100000, stringBuilder.ToString()).ToString(), OracleHelper.Connection, oracleParameterArray);
}
- public List<GwSp> LoadInfoList(string spId, string apId, string clientId)
+ public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string permissionsSQL)
{
List<GwSp> list1 = new List<GwSp>();
StringBuilder stringBuilder = new StringBuilder();
@@ -232,7 +232,11 @@
list2.Add(new OracleParameter(":ClientID", (object) clientId));
stringBuilder.Append(" and CLIENT_ID=:ClientID");
}
- stringBuilder.Append(" order by SP_ID DESC");
+
+ //瀹㈡埛鏉冮檺SQL鑴氭湰
+ stringBuilder.Append(permissionsSQL);
+
+ stringBuilder.Append(" order by SP_ID DESC");
using (OracleDataReader reader = OracleHelper.ExecuteReader("select * " + stringBuilder.ToString(), OracleHelper.Connection, list2.ToArray()))
{
while (((DbDataReader) reader).Read())
--
Gitblit v1.9.1