public IEnumerable<Comment> Search(CommentCondition condition) { using (var db = new Entities()) { IQueryable<Comment> query = db.Comment.Include(m => m.UserInfo).Include(m => m.UserRole); query = condition.Filter(query); if (condition.StartCreateDate.HasValue) { var date = condition.StartCreateDate.Value.Date; query = query.Where(q => q.CreateDate >= date); } if (condition.EndCreateDate.HasValue) { var date = condition.EndCreateDate.Value.Date.AddDays(1).AddMilliseconds(-1); query = query.Where(q => q.CreateDate <= date); } return query.OrderByDescending(q => q.CreateDate).DoPage(condition.Pager).ToList(); } }
// GET: LeanManage/Comment public ActionResult Index(CommentCondition condition) { var datas = CommentBiz.Search(condition); var model = PDM.Create(datas.AsEnumerable(), condition); return View(model); }