BiosealMVCWeb.Controllers.NewsCenterController.List C# (CSharp) Метод

        public ActionResult List()
        {
            //设置分页类
            int? pageIndex = Convert.ToInt16(Request.QueryString["pageIndex"]);
            pageIndex = (pageIndex == null ? 0 : pageIndex);

            int pageSize = 10; //设置每页显示条数

            //获取新闻分类列表的CategoryId
            int CategoryId = Convert.ToInt32(Request.QueryString["CategoryId"]);
            db = new biosealEntities();
            //获取置顶新闻
            var TopNewsId = db.TopNews.Single();
            var TopNews = db.News.Where(i => i.Id == TopNewsId.NewsID && i.CategoryId == CategoryId).SingleOrDefault();
            ViewBag.TopNews = TopNews;
            //获取分类列表的前20条记录
            var News = db.News.Where(i => i.Id != TopNewsId.NewsID && i.CategoryId == CategoryId).OrderByDescending(i => i.DateTime).Skip(pageIndex.Value * pageSize).Take(pageSize).ToList();

            ViewBag.Pagination = new Pagination(pageIndex, pageSize, db.News.Where(i => i.Id != TopNewsId.NewsID && i.CategoryId == CategoryId).Count());

            return View(News);
        }