/// <summary>
/// 获取角色列表
/// </summary>
/// <param name="param">角色搜索实体</param>
/// <returns>PageDataModel<RoleEntity></returns>
public Task <BasePagedListModel <RoleEntity> > GetListAsync(RoleSearchParam param)
{
if (param == null)
{
throw new ArgumentNullException(nameof(param));
}
return(roleRepository.GetListAsync(param));
}
public async Task <IActionResult> GetGridJson(RoleSearchParam param)
{
BasePagedListModel <RoleEntity> pageDataModel = await roleService.GetListAsync(param);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
public async Task <string> QueryPagedAsync([FromQuery] RoleSearchParam param)
{
var filter = param.SearchLambda <TRole, RoleSearchParam>();
var result = await _iTRoleRepository.QueryPagedAsync(param.Page, param.Limit, c => c.CreateTime, filter);
var pageData = new LayuiTableDto <TRole>
{
Code = "0",
Msg = "获取数据成功",
Count = result.TotalResults,
Data = result.Items.ToList()
};
var json = JsonConvert.SerializeObject(pageData);
return(json);
}
/// <summary>
/// 获取角色列表
/// </summary>
/// <param name="param">角色搜索实体</param>
/// <returns>PageDataModel<RoleEntity></returns>
public async Task <BasePagedListModel <RoleEntity> > GetListAsync(RoleSearchParam param)
{
BasePagedListModel <RoleEntity> list = new BasePagedListModel <RoleEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder("1=1");
if (param.Name.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND R_NAME='{0}'", param.Name.FilterSql());
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "*";
criteria.PageSize = param.PageSize;
criteria.TableName = "S_ROLE";
criteria.PrimaryKey = "R_ID";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <RoleEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetListAsync(RoleSearchParam param)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetListAsync(RoleSearchParam param)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetListAsync(RoleSearchParam param)发生Exception，异常信息：{0}", ex);
}
return(list);
}
