bool temprole=UserBll.Instance.HasRole(SysVisitor.Instance.UserId, 33);//假如我们要判断是否拥有客服的角色权限 default: List<int> powerlist = UserBll.Instance.GetDepIDs(SysVisitor.Instance.UserId, true);//得到用户数据权限(角色数据权限+用户数据权限) string powerstring = string.Join(",", powerlist);//ist<int>: 1,2,3,4,5,6,7 转换成字符串:“1,2,3,4,5,6,7” if (string.IsNullOrEmpty(powerstring)) { powerstring = "0"; } string sqlwhere = "(depid in (" + powerstring + "))";//根据后台数据权限(角色数据权限+用户数据权限)看信息 //string sqlwhere = "(depid in (" + SysVisitor.Instance.cookiesDepartments + "))";//当前用户可看当前部门信息 if (SysVisitor.Instance.cookiesIsAdmin == "True") { //判断是否是超管如果是超管理,所有显示 sqlwhere = " 1=1 ";//如果是超管则不显示 } if (!string.IsNullOrEmpty(rpm.Filter))//如果筛选不为空 { string str = " and " + FilterTranslator.ToSql(rpm.Filter); sqlwhere = sqlwhere + str; } //TableConvention.Resolve(typeof(MJUserModel)) 转换成表名 var pcp = new ProcCustomPage(TableConvention.Resolve(typeof(Wzsh_khxxModel))) { PageIndex = rpm.Pageindex, PageSize = rpm.Pagesize, OrderFields = rpm.Sort, WhereString = sqlwhere }; int recordCount; DataTable dt = DbUtils.GetPageWithSp(pcp, out recordCount); context.Response.Write(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt)); //context.Response.Write(Wzsh_khxxBll.Instance.GetJson(rpm.Pageindex, rpm.Pagesize, rpm.Filter, rpm.Sort, rpm.Order)); break;
Copyright © 2004-2024 Ynicp.com 版权所有 法律顾问:建纬(昆明)律师事务所 昆明市网翼通科技有限公司 滇ICP备08002592号-4