/// <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);
}
