/// <summary>
/// 分页结果
/// </summary>
/// <param name="filters"></param>
/// <returns></returns>
public async Task <PagedResult <StationDto> > SearchAsync(StationFilters filters)
{
if (filters == null)
{
return(new PagedResult <StationDto>(0, 0));
}
var dbset = _context.Stations;
var query = dbset.Where(item => !item.IsDeleted);
if (filters.keywords.IsNotBlank())
{
query = query.Where(item => item.站点名称.Contains(filters.keywords));
}
return(await query.OrderByDescending(item => item.分区名称)
.Select(item => new StationDto
{
Id = item.Id,
分区名称 = item.分区名称,
分区类型 = item.分区类型,
站点名称 = item.站点名称,
站点编号 = item.站点编号,
编号 = item.编号,
站点全名 = item.站点全名,
站点类型 = item.站点类型,
分区内排序 = item.分区内排序
}).PagingAsync(filters.page, filters.rows));
}
public async Task <IActionResult> GetListWithPager(StationFilters filters)
{
var result = await _stationservice.SearchAsync(filters);
return(Json(result));
}