From 203edd6bbdf883e897a0075037a4ef68cd519ac9 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期四, 23 六月 2022 00:07:56 +0800
Subject: [PATCH] 系统账户管理列表用户角色显示优化
---
web/Dao/GwDmDao.cs | 12 ++++++++++--
1 files changed, 10 insertions(+), 2 deletions(-)
diff --git a/web/Dao/GwDmDao.cs b/web/Dao/GwDmDao.cs
index b7a424e..9e717d9 100644
--- a/web/Dao/GwDmDao.cs
+++ b/web/Dao/GwDmDao.cs
@@ -11,7 +11,7 @@
{
public class GwDmDao : IDisposable
{
- public List<GwDm> LoadInfoList(string ApID, string OpID, string spID, string DestnationId, string sDate, out int recordcount, int pageSize, int PageIndex)
+ public List<GwDm> LoadInfoList(string ApID, string OpID, string spID, string DestnationId, string sDate, string permissionsSQL, out int recordcount, int pageSize, int PageIndex)
{
List<GwDm> list1 = new List<GwDm>();
recordcount = 0;
@@ -49,6 +49,10 @@
list2.Add(oracleParameter);
stringBuilder.Append(" and SP_ID=:SP_ID ");
}
+
+ //瀹㈡埛鏉冮檺SQL鑴氭湰
+ stringBuilder.Append(permissionsSQL);
+
using (OracleDataReader reader = OracleHelper.ExecuteReader(" select count(*) as count " + stringBuilder.ToString(), OracleHelper.Connection, list2.ToArray()))
{
while (((DbDataReader) reader).Read())
@@ -110,7 +114,7 @@
{
}
- public List<GwDm> LoadInfoList(string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, out int recordcount, int pageSize, int pageIndex)
+ public List<GwDm> LoadInfoList(string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, string permissionsSQL, out int recordcount, int pageSize, int pageIndex)
{
List<GwDm> list = new List<GwDm>();
recordcount = 0;
@@ -138,6 +142,10 @@
((DbParameter) oracleParameterArray[0]).Value = (object) destnationId;
stringBuilder.Append(" and MOBILE=:DestnationId");
}
+
+ //瀹㈡埛鏉冮檺SQL鑴氭湰
+ stringBuilder.Append(permissionsSQL);
+
using (OracleDataReader reader = OracleHelper.ExecuteReader("select count(*) as count " + stringBuilder.ToString(), OracleHelper.Connection, oracleParameterArray))
{
while (((DbDataReader) reader).Read())
--
Gitblit v1.9.1