コード例 #1
0
ファイル: CommentsController.cs プロジェクト: md-prog/LL
        //
        // GET: /Comments/

        public ActionResult Index(int?gridNum, CommentsSearch frm)
        {
            ViewBag.GridNum = AppFunc.GetGridItemsCombo(gridNum);

            var query = cRepo.GetQuery(false);

            if (frm.DateFrom.HasValue)
            {
                query = query.Where(t => t.AddDate >= frm.DateFrom);
            }

            if (frm.DateTo.HasValue)
            {
                query = query.Where(t => t.AddDate <= frm.DateTo);
            }

            if (!string.IsNullOrWhiteSpace(frm.Search))
            {
                query = query.Where(t => t.Comment.Contains(frm.Search));
            }

            frm.CommentsQuery = query;

            return(View(frm));
        }
コード例 #2
0
        //
        // GET: /Users/

        public ActionResult Index(int?gridNum)
        {
            ViewBag.PageSize = gridNum ?? GlobVars.GridItems;

            ViewBag.GridNum = AppFunc.GetGridItemsCombo(gridNum);

            var query = uRepo.GetQuery();

            return(View(query.OrderByDescending(t => t.UserId)));
        }
コード例 #3
0
        public ActionResult Index(int?gridNum, string search, bool isArchive = false)
        {
            ViewBag.GridNum  = AppFunc.GetGridItemsCombo(gridNum);
            ViewBag.PageSize = gridNum ?? GlobVars.GridItems;

            var query = contRepo.GetQuery(isArchive);

            if (!string.IsNullOrWhiteSpace(search))
            {
                query = query.Where(t => t.Email.Contains(search) ||
                                    t.Phone.Contains(search) ||
                                    t.Company.Contains(search) ||
                                    t.FullName.Contains(search) ||
                                    t.LastName.Contains(search));
            }

            query = query.OrderBy(t => t.IsDone).ThenByDescending(t => t.ContactId);

            return(View(query));
        }