/// <summary>
/// 查询列表，根据条件
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <Page <SysCodeDto> > > GetPagesAsync(SysCodePostPage parm)
{
var res = new ApiResult <Page <SysCodeDto> >();
try
{
using (Db)
{
var query = Db.Queryable <SysCode>()
.WhereIF(!string.IsNullOrEmpty(parm.guid), m => m.ParentGuid == parm.guid)
.OrderBy(m => m.Sort).Select(m => new SysCodeDto()
{
guid = m.Guid,
name = m.Name,
sort = m.Sort,
parentguid = m.ParentGuid,
status = m.Status,
type = m.CodeType
}).ToPageAsync(parm.page, parm.limit);
res.success = true;
res.message = "获取成功！";
res.data = await query;
}
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
}
return(await Task.Run(() => res));
}
/// <summary>
/// 查询列表，根据条件
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <Page <SysCode> > > GetPagesAsync(SysCodePostPage parm)
{
var res = new ApiResult <Page <SysCode> >();
try
{
res.data = await Db.Queryable <SysCode>()
.WhereIF(!string.IsNullOrEmpty(parm.guid), m => m.ParentGuid == parm.guid)
.OrderBy(m => m.Sort).ToPageAsync(parm.page, parm.limit);
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(res);
}
public async Task <IActionResult> GetPages([FromQuery] SysCodePostPage request)
{
var res = await _sysCodeService.GetPagesAsync(request);
return(Ok(new { code = 0, msg = "success", count = res.data.TotalItems, data = res.data.Items }));
}
