From f63d8ead25bdb3c32dacca817a059bd30390e9bc Mon Sep 17 00:00:00 2001 From: yzh <snbbt@21cn.com> Date: 星期三, 15 六月 2022 22:20:07 +0800 Subject: [PATCH] 1.系统账户数据库优化: 修改“账户类型”的数据类型为VARCHAR2(1024),多个角色时以半角“,”分隔。 加密盐。 密码加密优化;账户登录优化;角色权限管理(作废用户权限); 2.字典类型管理(定义:用户角色) 3.字典数据管理(初始化用户角色数据) 3.角色权限管理 4.系统账户管理,账户类型对应用户角色(可多选)。 --- web/web/GwStatisV3.ashx | 10 ++++++---- 1 files changed, 6 insertions(+), 4 deletions(-) diff --git a/web/web/GwStatisV3.ashx b/web/web/GwStatisV3.ashx index 0604141..e3e87ce 100644 --- a/web/web/GwStatisV3.ashx +++ b/web/web/GwStatisV3.ashx @@ -11,7 +11,7 @@ { private GwStatisV3Dao _Dao = new GwStatisV3Dao(); private int _userId = -1; - private int _userType = -1; + private string _userType = ""; private string _account = ""; public override JsonPageResult ProcessRequestInternal(PageContext<Model.SysUser> context) @@ -81,6 +81,8 @@ string opID = context.GetString("opid"); string statistype = context.GetString("statistype"); StatisOption statisoption = (StatisOption)context.GetInt("statisoption"); + + string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null); List<GwOp> opList; @@ -93,7 +95,7 @@ using (GwClientDao dao = new GwClientDao()) { - clientList = dao.LoadInfoList("", "", "", ""); + clientList = dao.LoadInfoList("", "", "", "", permissionsSQL); } List<GwAp> apList; @@ -104,10 +106,10 @@ apList = dao.LoadInfoList("", "", "", out recordCount, 99999, 1); } + + //var list = _Dao.Query(beginTime, endTime, clientID, spID, apID, opID, statistype, (StatisOption)statisoption); //鏍规嵁绯荤粺鐢ㄦ埛鑾峰彇鏈夋潈闄愬鎴� - string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null); - var list = _Dao.Query(beginTime, endTime, clientID, spID, apID, opID, statistype, permissionsSQL, (StatisOption)statisoption); System.Text.StringBuilder sb = new System.Text.StringBuilder(); -- Gitblit v1.9.1