public async Task <IActionResult> QueryAsync(SelectPurchaseDto model)
{
var result = new ReturnData <ReturnPaginSelectDto <ReturnPuurchaseDto> >();
result.Obj = await _service.QueryPaginAsync(model);
return(Ok(result));
}
public async Task <ReturnPaginSelectDto <ReturnPuurchaseDto> > QueryPaginAsync(SelectPurchaseDto model)
{
var result = new ReturnPaginSelectDto <ReturnPuurchaseDto>();
var purchases = from p in _context.Purchases
join g in _context.Games on p.GameId equals g.Id
join c in _context.Currencys on p.CurrencyId equals c.Id
select new ReturnPuurchaseDto()
{
CreateTime = p.CreateTime,
CurrencyName = c.Name,
OrderNumber = p.OrderNumber,
GameName = g.Name,
Id = p.Id,
Number = p.Number,
OrderDate = p.OrderDate,
PaymentAccount = p.PaymentAccount,
PaymentStatus = p.PaymentStatus,
RealIncome = p.RealIncome,
Remarks = p.Remarks,
ServerName = p.ServerName,
SupplierPhone = p.SupplierPhone,
TotalNumber = p.TotalNumber,
TotalPrice = p.TotalPrice,
UnitPrice = p.UnitPrice,
Handler = p.Handler,
RealIncomeRMB = p.RealIncomeRMB
};
result.Total = await purchases.CountAsync();
result.PageNumber = model.PageNumber;
result.Amount = model.Amount;
result.Items = await purchases.Pagin(model).OrderBy(i => i.CreateTime).ToListAsync();
return(result);
}
