public List <PM_ThingsTodo> GetList(DataProvider dp, ThingsTodoFilter filter, out int total, bool IsPage = true) { var list = dp.PM_ThingsTodo.Where(m => true); if (filter.BeginTime.HasValue) { list = list.Where(m => m.TodoDate >= filter.BeginTime.Value); } if (filter.EndTime.HasValue) { list = list.Where(m => m.TodoDate <= filter.EndTime.Value); } if (filter.TodoThings.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.TodoThings.Contains(filter.TodoThings)); } if (filter.CreateUser.HasValue) { list = list.Where(m => m.CreateUser == filter.CreateUser.Value); } if (filter.IsAlert.HasValue) { list = list.Where(m => m.IsAlert == filter.IsAlert.Value); } list = list.OrderByDescending(m => m.TodoDate); total = list.Count(); if (IsPage) { return(list.Skip(filter.Skip).Take(filter.PageSize).ToList()); } else { return(list.ToList()); } }
public ActionResult GetList(ThingsTodoFilter filter) { filter.CreateUser = CurrentUser.Id; var data = business.GetList(filter, out int total); return(Json(new TableDataModel(total, data))); }
public List <ThingsTodoModel> GetList(ThingsTodoFilter filter, out int total, bool isPage = true) { using (DataProvider dp = new DataProvider()) { var list = data.GetList(dp, filter, out total, isPage); return(Mapper.Map <List <ThingsTodoModel> >(list)); } }
public List <ThingsTodoModel> GetWeekThingsTodo(Guid CreateUser) { DateTime now = DateTime.Now.Date; ThingsTodoFilter filter = new ThingsTodoFilter { BeginTime = now, EndTime = now.AddDays(6), CreateUser = CreateUser }; using (DataProvider dp = new DataProvider()) { var list = data.GetList(dp, filter, out int total, false); return(Mapper.Map <List <ThingsTodoModel> >(list)); } }