/// <summary> /// 获取所有权限 /// </summary> /// <returns></returns> public async Task <IEnumerable <RoleModel> > GetAllAsync(GetRoleListRequestDto request) { using (var conn = MySqlHelper.GetConnection()) { var sortFields = new string[] { "sort".ToLower(), "creation_Date".ToLower() }; string whereSql = $"WHERE 1=1"; if (!string.IsNullOrEmpty(request.Name)) { whereSql = $" {whereSql} AND (role_name like @name)"; } if (request.Enable != null) { whereSql = $" {whereSql} AND (Enable = @Enable)"; } var orderbySql = "sort desc"; if (!string.IsNullOrWhiteSpace(request.SortField)) { orderbySql = $"{(sortFields.Contains(request.SortField.ToLower()) ? request.SortField : sortFields[0])} {(request.IsAscending ? "asc" : "desc")}"; } return(await conn.GetListAsync <RoleModel>($"{whereSql} ORDER BY {orderbySql}", new { name = $"%{request.Name}%", request.Enable })); } }
public async Task <IActionResult> GetRoleListAsync([FromBody] GetRoleListRequestDto request) { var roleBiz = new RoleBiz(); var entityList = await roleBiz.GetAllAsync(request); var response = entityList?.Select(a => a.ToDto <GetRoleListResponseDto>()); return(Success(response)); }