Exemple #1
0
        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();
            }
        }
Exemple #2
0
 // GET: LeanManage/Comment
 public ActionResult Index(CommentCondition condition)
 {
     var datas = CommentBiz.Search(condition);
     var model = PDM.Create(datas.AsEnumerable(), condition);
     return View(model);
 }