//public async Task<long> AddJournal() //{ //} public async Task <CashSellSearchResult> GetModelListAsync(string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { CashSellSearchResult result = new CashSellSearchResult(); var logs = dbc.GetAll <CashSellEntity>().AsNoTracking(); if (!string.IsNullOrEmpty(keyword)) { logs = logs.Where(a => a.OrderCode.Contains(keyword)); } if (startTime != null) { logs = logs.Where(a => a.CreateTime >= startTime); } if (endTime != null) { logs = logs.Where(a => SqlFunctions.DateDiff("day", endTime, a.CreateTime) <= 0); } result.TotalCount = await logs.LongCountAsync(); result.PageCount = (int)Math.Ceiling((result.TotalCount) * 1.0f / pageSize); var logsResult = await logs.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.log = logsResult.Select(a => ToDTO(a)).ToArray(); return(result); } }
//出售订单 public async Task <CashSellSearchResult> SellListAsync(long?userId, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { CashSellSearchResult result = new CashSellSearchResult(); var logs = dbc.GetAll <CashSellEntity>().AsNoTracking(); if (userId != null && userId > 0) { logs = logs.Where(a => a.UserId == userId); } result.TotalCount = await logs.LongCountAsync(); result.PageCount = (int)Math.Ceiling((result.TotalCount) * 1.0f / pageSize); var logsResult = await logs.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.log = logsResult.Select(a => ToDTO(a)).ToArray(); return(result); } }