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