/// <summary> /// 获取角色权限分页列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public PagerList <dynamic> GetRolePageList(SysRoleMstrQuery query) { var rolePerssion = _permissionHelper.GetRoleSql(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, AbpSession.ORG_NO, AbpSession.BG_NO, "role."); rolePerssion = rolePerssion + query.sql; return(_sqlQuery.Select(@" role.ROLE_ID, role.ROLE_NAME, role.ROLE_SCOPE, ( CASE role.ROLE_STATUS WHEN 1 THEN '启用' ELSE '禁用' END ) AS ROLE_STATUS, role.ROLE_DESC, bu.BU_NAME") .Filter("role.ROLE_NAME", query.ROLE_NAME, Operator.Contains) .Filter("role.ROLE_DESC", query.ROLE_DESC, Operator.Contains) .Filter("role.DEL_FLAG", "1") .And(rolePerssion) .OrderBy("role.CREATE_DATE desc") .GetPageList <dynamic>(@"SYS_ROLE_MSTR role LEFT JOIN MDM_BU_MSTR bu on role.CREATE_ORG_NO=bu.BU_NO", Context.Database.GetDbConnection(), query)); }
public ActionResult GetRolePageList(SysRoleMstrQuery query) { try { var result = _sysRoleMstrService.GetRolePageList(query); return(Page(result.Data, result.Page)); } catch (Exception ex) { return(Fail(ex.Message)); } }
/// <summary> /// 获取角色权限分页列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public PagerList <dynamic> GetRolePageList(SysRoleMstrQuery query) { var rm = new ReturnMsg(); var auth = _sysUsrAuthRepository.FirstOrDefault(c => c.USR_ID == AbpSession.USR_ID && c.DEL_FLAG == 1); if (auth != null) { query.sql = " or role.ROLE_ID=" + auth.ROLE_ID + ""; } var roleList = _sysRoleMstrRepository.GetRolePageList(query); return(roleList); }