/// <summary>
/// 按条件分页查询指定字段，并返回总数
/// </summary>
/// <param name="querySlopeInput"></param>
/// <returns></returns>
public async Task <PagedResultOutput <SlopeDto> > GetFieldsPageList(QuerySlopeInput querySlopeInput)
{
try
{
if (querySlopeInput.DISASTERUNITNAME == "" && querySlopeInput.LOCATION == "")
{
var slope = _iSlopeRepository.GetAll()
.Select
(s => new SlopeDto()
{
Id = s.Id,
UNIFIEDCODE = s.UNIFIEDCODE,
DISASTERUNITNAME = s.DISASTERUNITNAME,
LOCATION = s.LOCATION,
UPDATETIME = s.UPDATETIME,
SLOPETYPE = s.SLOPETYPE
}
)
.OrderBy(s => s.UNIFIEDCODE).Skip((querySlopeInput.PageIndex - 1) * querySlopeInput.PageSize).Take(querySlopeInput.PageSize);
IReadOnlyList <SlopeDto> ir = slope.MapTo <List <SlopeDto> >();
int count = await GetCount(querySlopeInput);
PagedResultOutput <SlopeDto> list = new PagedResultOutput <SlopeDto>(count, ir);
return(list);
}
else
{
var slope = _iSlopeRepository.GetAll()
.Where(_iSlopeRepository.GetWhere(querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION))
.Select
(s => new SlopeDto()
{
Id = s.Id,
UNIFIEDCODE = s.UNIFIEDCODE,
DISASTERUNITNAME = s.DISASTERUNITNAME,
LOCATION = s.LOCATION,
UPDATETIME = s.UPDATETIME,
SLOPETYPE = s.SLOPETYPE
}
)
.OrderBy(s => s.UNIFIEDCODE).Skip((querySlopeInput.PageIndex - 1) * querySlopeInput.PageSize).Take(querySlopeInput.PageSize);
IReadOnlyList <SlopeDto> ir = slope.MapTo <List <SlopeDto> >();
int count = await GetCount(querySlopeInput);
PagedResultOutput <SlopeDto> list = new PagedResultOutput <SlopeDto>(count, ir);
return(list);
}
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// 按条件分页查询
/// </summary>
/// <param name="querySlopeInput"></param>
/// <returns></returns>
public async Task <ListResultOutput <SlopeDto> > GetPageList(QuerySlopeInput querySlopeInput)
{
try
{
var slope = await _iSlopeRepository.GetPageList(querySlopeInput.PageIndex, querySlopeInput.PageSize, querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION);
var list = new ListResultOutput <SlopeDto>(slope.MapTo <List <SlopeDto> >());
return(list);
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// 分页条件查询，并返回总数
/// </summary>
/// <param name="querySlopeInput"></param>
/// <returns></returns>
public async Task <PagedResultOutput <SlopeDto> > GetPageAndCountList(QuerySlopeInput querySlopeInput)
{
try
{
var slope = await _iSlopeRepository.GetPageList(querySlopeInput.PageIndex, querySlopeInput.PageSize, querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION);
IReadOnlyList <SlopeDto> ir = slope.MapTo <List <SlopeDto> >();
int count = await GetCount(querySlopeInput);
PagedResultOutput <SlopeDto> list = new PagedResultOutput <SlopeDto>(count, ir);
return(list);
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// 条件查询获取pageCount
/// </summary>
/// <param name="querySlopeInput"></param>
/// <returns>pageCount</returns>
///
public async Task <int> GetCount(QuerySlopeInput querySlopeInput)
{
int pageCount = await _iSlopeRepository.GetPageCount(querySlopeInput.PageIndex, querySlopeInput.PageSize, querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION);
return(pageCount);
}
