/// <summary> /// 次级页面 /// </summary> /// <param name="id"></param> public void Category(int? id , int? page) { if (id != null && page != null) { HomeCategoryViewData viewData = new HomeCategoryViewData(); //下一部分代码 viewData.sigColumn = (from c in CQGJ.Column where c.ColumnID == id select c).First(); viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify==false && hn.IsApproval==true && hn.Status==(int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(5).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproval == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); //需要对lsNews进行分页 var tempList = (from n in CQGJ.News from nc in n.NewsColumn where nc.Column.ColumnID == id && n.IsApproval == true && n.IsNotify == false && n.Status == (int?)NewsStatus.Approved orderby n.PubDate descending select n); //截取 viewData.lsNews = tempList.Skip(20 * (page.Value - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(),20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; RenderView("Category", viewData); } else { RedirectToAction("Index"); } }
/// <summary> /// 文章显示 /// </summary> /// <param name="id"></param> public void Article(int? id) { if (id == null) { RedirectToAction("Index"); } HomeCategoryViewData viewData = new HomeCategoryViewData(); viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify == false && hn.IsApproval == true && hn.Status == (int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(5).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproval == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); News sigNews = (from n in CQGJ.News where n.NewsID == id select n).First(); if (sigNews.ViewNum == null) { sigNews.ViewNum = 1; } else { sigNews.ViewNum += 1; } CQGJ.SaveChanges(); viewData.sigNews = sigNews; //取得首页进入次级页面article的Column viewData.sigColumn = (from c in CQGJ.Column from nc in CQGJ.NewsColumn where nc.News.NewsID == id && nc.Column.ColumnID == c.ColumnID select c).First(); RenderView("Article",viewData); }
/// <summary> /// 网站-侧栏组件 /// </summary> public ActionResult Sidebar() { HomeCategoryViewData viewData = new HomeCategoryViewData(); viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify == false && hn.IsApproved == true && hn.Status == (int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(6).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproved == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); return View(viewData); }
//公告通知列表 public ActionResult NoticeList(int page) { if (page > 0) { HomeCategoryViewData viewData = new HomeCategoryViewData(); viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify == false && hn.IsApproved == true && hn.Status == (int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(5).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproved == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); //需要对list进行分页 var tempList = (from n in CQGJ.News where n.IsNotify == true orderby n.PubDate descending select n); //截取 viewData.NoticeList = tempList.Skip(20 * (page - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("NoticeList", viewData); } else { return RedirectToAction("Index"); } }
/// <summary> /// 公告通知详细页面 /// </summary> /// <param name="id">公告通知ID</param> public ActionResult NoticeInfo(int id) { HomeCategoryViewData viewData = new HomeCategoryViewData(); viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify == false && hn.IsApproved == true && hn.Status == (int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(5).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproved == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); News sigNews = (from n in CQGJ.News where n.NewsID == id select n).First(); if (sigNews.ViewNum == null) { sigNews.ViewNum = 1; } else { sigNews.ViewNum += 1; } CQGJ.SaveChanges(); viewData.sigNews = sigNews; return View("NoticeInfo", viewData); }