public async Task <GoodsTypeSearchResult> GetModelListAsync(string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { GoodsTypeSearchResult result = new GoodsTypeSearchResult(); var entities = dbc.GetAll <GoodsTypeEntity>().AsNoTracking().Where(g => g.IsNull == false); if (!string.IsNullOrEmpty(keyword)) { entities = entities.Where(g => g.Name.Contains(keyword) || g.Description.Contains(keyword)); } if (startTime != null) { entities = entities.Where(a => a.CreateTime >= startTime); } if (endTime != null) { entities = entities.Where(a => SqlFunctions.DateDiff("day", endTime, a.CreateTime) <= 0); } result.PageCount = (int)Math.Ceiling((await entities.LongCountAsync()) * 1.0f / pageSize); var goodsTypesResult = await entities.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.GoodsTypes = goodsTypesResult.Select(a => ToDTO(a)).ToArray(); return(result); } }
public async Task <ActionResult> List(string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1) { GoodsTypeSearchResult result = await goodsTypeService.GetModelListAsync(keyword, startTime, endTime, pageIndex, pageSize); return(Json(new AjaxResult { Status = 1, Data = result })); }
public async Task <ApiResult> List() { string parm = doMain; GoodsTypeSearchResult result = await goodsTypeService.GetModelListAsync(null, null, null, 1, 100); List <GoodsTypeListApiModel> model; model = result.GoodsTypes.Select(g => new GoodsTypeListApiModel { id = g.Id, name = g.Name, imgUrl = parm + g.ImgUrl }).ToList(); return(new ApiResult { status = 1, data = model }); }