/// <summary>
/// 获取WinningRecord的分页列表信息
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PagedResultDto <WinningRecordListDto> > GetPagedWinningRecords(GetWinningRecordsInput input)
{
var query = _winningrecordRepository.GetAll();
//TODO:根据传入的参数添加过滤条件
var winningrecordCount = await query.CountAsync();
var winningrecords = await query
.OrderBy(input.Sorting).AsNoTracking()
.PageBy(input)
.ToListAsync();
//var winningrecordListDtos = ObjectMapper.Map<List <WinningRecordListDto>>(winningrecords);
var winningrecordListDtos = winningrecords.MapTo <List <WinningRecordListDto> >();
return(new PagedResultDto <WinningRecordListDto>(
winningrecordCount,
winningrecordListDtos
));
}
/// <summary>
/// 获取中奖记录
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PagedResultDto <WinningRecordListDto> > GetPagedWinningRecordsOtherTable(GetWinningRecordsInput input)
{
var queryWin = _winningrecordRepository.GetAll();
var queryPr = _prizeRepository.GetAll();
var queryWe = _wechatuserRepository.GetAll();
var query = from w in queryWin
join we in queryWe on w.UserId equals we.Id into qw
from wp in qw.DefaultIfEmpty()
join pr in queryPr on w.PrizeId equals pr.Id into qp
from wpw in qp.DefaultIfEmpty()
select new WinningRecordListDto
{
Id = w.Id,
PrizeName = wpw != null?wpw.Name:"",
UserName = wp != null?wp.NickName:"",
WinningTime = w.WinningTime,
Num = w.Num,
ExpiryTime = w.ExpiryTime,
Status = w.Status,
ApplyTime = w.ApplyTime,
CompleteTime = w.CompleteTime,
};
//TODO:根据传入的参数添加过滤条件
var winningrecordCount = await query.CountAsync();
var winningrecords = await query
.OrderBy(input.Sorting).AsNoTracking()
.PageBy(input)
.ToListAsync();
//var winningrecordListDtos = ObjectMapper.Map<List <WinningRecordListDto>>(winningrecords);
var winningrecordListDtos = winningrecords.MapTo <List <WinningRecordListDto> >();
return(new PagedResultDto <WinningRecordListDto>(
winningrecordCount,
winningrecordListDtos
));
}
