public async Task <IActionResult> QueryPaginStockRecordAsync(SelectStockAccessDto model) { var result = await _service.QueryPaginStockRecordAsync(model); return(Ok(result)); }
public async Task <ReturnPagin <List <ReturnStockAccessDto> > > QueryPaginStockRecordAsync(SelectStockAccessDto model) { var result = new ReturnPagin <List <ReturnStockAccessDto> >(); var stockAccess = _context.InAndOutStockDetaileds.Include(i => i.Stock.Product).AsNoTracking(); if (model.StockId.HasValue) { stockAccess = stockAccess.Where(i => i.StockId == model.StockId); } result.Page = model.Page; result.Number = model.Number; result.Count = await stockAccess.CountAsync(); result.Items = await stockAccess.Select(i => new ReturnStockAccessDto { InAndOutStockType = i.InAndOutStockType, Number = i.Number, StockProductName = i.Stock.Product.Name, SurplusStock = i.SurplusStock, CreateTime = i.CreateTime }).ToListAsync(); return(result); }