public ActionResult Index()
{
//SetFlashPic();
HomeIndexViewData viewData = new HomeIndexViewData();
//重要新闻
viewData.ImportantList = (from n in CQGJ.News
where n.IsNotify == false && n.IsImportant == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(9).ToList();
//干教动态
int ID1 = Settings.Category_1;
viewData.NewsList1 = (from n in CQGJ.News
from nc in n.NewsColumn
where nc.Column.ColumnID == ID1 && n.IsNotify == false && n.IsApproved == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(4).ToList();
if (viewData.NewsList1.Count() > 0)
{
string t = viewData.NewsList1[0].Content;
t = HtmlHandle.GetPureText(t);
if (t.Length > 50)
{ t = t.Substring(0, 50); }
viewData.NewsList1[0].Content = t;
}
//区县动态
int ID2 = Settings.Category_2;
viewData.NewsList2 = (from n in CQGJ.News
from nc in n.NewsColumn
where nc.Column.ColumnID == ID2 && n.IsNotify == false && n.IsApproved == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(4).ToList();
if (viewData.NewsList2.Count() > 0)
{
string t = viewData.NewsList2[0].Content;
t = HtmlHandle.GetPureText(t);
if (t.Length > 50)
{ t = t.Substring(0, 50); }
viewData.NewsList2[0].Content = t;
}
//领导讲话
int ID3 = Settings.Category_3;
viewData.NewsList3 = (from n in CQGJ.News
from nc in n.NewsColumn
where nc.Column.ColumnID == ID3 && n.IsNotify == false && n.IsApproved == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(6).ToList();
//文件汇编
int ID4 = Settings.Category_4;
viewData.NewsList4 = (from n in CQGJ.News
from nc in n.NewsColumn
where nc.Column.ColumnID == ID4 && n.IsNotify == false && n.IsApproved == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(6).ToList();
//最新通知
viewData.NewsList = (from n in CQGJ.News
where n.IsNotify == true && n.IsApproved == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(6).ToList();
//最新课程
viewData.LatestCourse = (from c in CQGJ.Course
select c).Take(7).ToList();
//最新班级
viewData.LatestClass = (from c in CQGJ.Classes
select c).Take(7).ToList();
//热门课程
viewData.CoursewareList = (from c in CQGJ.Courseware
select c).Take(7).ToList();
//viewData.today = (from s in CQGJ.Statistic
// where s.AddTime.Value >= DateTime.Today
// select s).Sum(s => (int)s.Hits);
//viewData.all = (from s in CQGJ.Statistic
// select s).Sum(s => (int)s.Hits);
return View("Index", viewData);
}
public void Index()
{
//SetFlashPic();
HomeIndexViewData viewData = new HomeIndexViewData();
//viewData.lsFirstNews = (from fn in CQGJ.News
// orderby fn.PubDate descending
// select fn).ToList();
//最新通知
viewData.NewsList = (from n in CQGJ.News
where n.IsNotify == true && n.IsApproval == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(5).ToList();
//干教动态
int ID1 = Convert.ToInt32(ConfigurationManager.AppSettings["Cadre_Education_And_Dynamic"]);
viewData.NewsList1 = (from n in CQGJ.News
from nc in n.NewsColumn
where nc.Column.ColumnID == ID1 && n.IsNotify == false && n.IsApproval == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(8).ToList();
//区县动态
int ID2 = Convert.ToInt32(ConfigurationManager.AppSettings.Get("City_Dynamic"));
viewData.NewsList2 = (from n in CQGJ.News
from nc in n.NewsColumn
where nc.Column.ColumnID == ID2 && n.IsNotify == false && n.IsApproval == true && n.Status == (int?)NewsStatus.Approved
orderby n.PubDate descending
select n).Take(7).ToList();
//最新课程
viewData.LatestCourse = (from c in CQGJ.Course
select c).Take(7).ToList();
//最新班级
viewData.LatestClass = (from c in CQGJ.Classes
select c).Take(7).ToList();
//热门课程
viewData.HotCourse = (from c in CQGJ.Course
select c).Take(7).ToList();
viewData.today = (from s in CQGJ.Statistic
where s.AddTime.Value >= DateTime.Today
select s).Sum(s => (int)s.Hits);
viewData.all = (from s in CQGJ.Statistic
select s).Sum(s => (int)s.Hits);
RenderView("Index", viewData);
}
