From 730cbe8b62133097369b9768ef30aa490551063d Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期一, 23 五月 2022 01:04:44 +0800
Subject: [PATCH] 客户操作权限数据隔离
---
web/Dao/GwSpDao.cs | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwSpDao.cs b/web/Dao/GwSpDao.cs
index 848425f..7bfd4a5 100644
--- a/web/Dao/GwSpDao.cs
+++ b/web/Dao/GwSpDao.cs
@@ -245,7 +245,8 @@
return list1;
}
- public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string clientName, int routerType, string opID, int chargeType, int pageIndex, int pageSize, string resendStatus, out int recordCount, string productId )
+ public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string clientName, 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>();
recordCount = 0;
@@ -326,6 +327,10 @@
list2.Add(new OracleParameter(":ProductId", (object)productId));
stringBuilder.Append(" and Product_Id=:ProductId");
}
+
+ //瀹㈡埛鏉冮檺SQL鑴氭湰
+ stringBuilder.Append(permissionsSQL);
+
stringBuilder.Append(" order by ID DESC");
using (OracleDataReader reader = OracleHelper.ExecuteReader("select count(*) as count " + stringBuilder.ToString(), OracleHelper.Connection, list2.ToArray()))
{
--
Gitblit v1.9.1