public async Task <GoodsSecondTypeSearchResult> GetModelListAsync(long?goodTypeId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
GoodsSecondTypeSearchResult result = new GoodsSecondTypeSearchResult();
var entities = dbc.GetAll <GoodsSecondTypeEntity>().AsNoTracking().Where(g => g.IsNull == false);
if (goodTypeId != null)
{
entities = entities.Where(a => a.GoodsTypeId == goodTypeId);
}
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 goodsSecondTypesResult = await entities.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync();
result.GoodsSecondTypes = goodsSecondTypesResult.Select(a => ToDTO(a)).ToArray();
return(result);
}
}
public async Task <ActionResult> List(long id, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
GoodsSecondTypeSearchResult result = await goodsSecondTypeService.GetModelListAsync(id, keyword, startTime, endTime, pageIndex, pageSize);
return(Json(new AjaxResult {
Status = 1, Data = result
}));
}
public async Task <ApiResult> SecondList(GoodsTypeSecondListModel model)
{
GoodsSecondTypeSearchResult result = await goodsSecondTypeService.GetModelListAsync(model.Id, null, null, null, 1, 100);
List <GoodsTypeListApiModel> listModel;
listModel = result.GoodsSecondTypes.Select(g => new GoodsTypeListApiModel {
id = g.Id, name = g.Name
}).ToList();
return(new ApiResult {
status = 1, data = listModel
});
}
