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));
}
}
