public PageList <ReceiveModel> SearchReceives(ReceiveSearchCondition condition)
{
var query = _shoppingContext.Receives.AsNoTracking().AsQueryable();
if (condition.ApprovedBy > 0)
{
query = query.Where(p => p.ApprovedBy == condition.ApprovedBy);
}
if (!string.IsNullOrEmpty(condition.Code))
{
query = query.Where(p => p.Code.ToLower().Contains(condition.Code.ToLower()));
}
if (!string.IsNullOrEmpty(condition.ReceiveFrom))
{
query = query.Where(p => p.ReceiveFrom.ToLower().Contains(condition.ReceiveFrom.ToLower()));
}
if (condition.DateFrom.HasValue)
{
query = query.Where(p => p.CreatedDateTime >= condition.DateFrom.Value);
}
if (condition.DateTo.HasValue)
{
var dateTo = condition.DateTo.Value.AddDays(1);
query = query.Where(p => p.CreatedDateTime < dateTo);
}
var products = query.OrderBy(o => o.CreatedDateTime).Skip(condition.PageSize * condition.PageNumber).Take(condition.PageSize).ToList();
return(new PageList <ReceiveModel>(Mapper.Map <List <ReceiveModel> >(products), query.Count()));
}
public ActionResult List(DataSourceRequest command, ReceiveSearchCondition condition)
{
condition.PageSize = command.PageSize;
condition.PageNumber = command.Page - 1;
var receives = _receiveService.SearchReceives(condition);
var gridModel = new DataSourceResult()
{
Data = receives.DataSource,
Total = receives.TotalItems
};
return(Json(gridModel));
}
public ActionResult List()
{
var model = new ReceiveSearchCondition();
return(View(model));
}
