private void getAllCommits() { this.SCommits = new List <ShowCommit>(); var trans = db.CommitLists.Select(m => new { m.CommitID, m.Account, m.TextID, m.CommitText, m.CommitChangeDate }).ToList(); foreach (var item in trans) { ShowCommit temp = new ShowCommit { Account = item.Account, Id = item.CommitID, Name = db.Users.Where(c => c.Account == item.Account).FirstOrDefault().Name, TextId = item.TextID, Content = item.CommitText, Date = item.CommitChangeDate.ToString() }; this.SCommits.Add(temp); } }
public ActionResult MBlog(int id) { var currentLoginUser = Session["loginuser"] == null ? null : (User)Session["loginuser"]; ViewBag.currentLoginInfo = currentLoginUser; var model = db.TextLists.FirstOrDefault(m => m.TextID == id); if (model == null) { return(Redirect("/home")); } model.Hot += 1; DbEntityEntry entry = db.Entry(model); entry.State = EntityState.Modified; int res = db.SaveChanges(); //评论模块 var temp = db.CommitLists.Where(c => c.TextID == id).ToList(); var cmt = new List <ShowCommit>(); int i = 1; foreach (var item in temp) { var tmp = new ShowCommit(); tmp.Name = db.Users.Where(c => c.Account == item.Account).FirstOrDefault().Name; tmp.Date = item.CommitChangeDate.ToString("yyyy-MM-dd") + " " + item.CommitChangeDate.ToShortTimeString(); tmp.Account = item.Account; tmp.Content = item.CommitText; tmp.Id = item.CommitID; tmp.Num = i; cmt.Add(tmp); i++; } ViewBag.CmtList = cmt; return(View(model)); }
public ActionResult Sidebar(string searchSthing) { var model = new SerializeTool().DeSerialize <BlogConfig>(); ViewBag.Config = model; var hots = new List <TextListsHot>(); var blog = from m in db.TextLists select m; //热度排序 var list = blog.OrderByDescending(m => m.Hot).Take(5).ToList(); foreach (var item in list) { var temp = new TextListsHot(); temp.TextID = item.TextID; temp.TextTitle = item.TextTitle; temp.Hot = item.Hot; temp.Datemouth = item.TextChangeDate.ToString().Substring(0, 6); hots.Add(temp); } //最新博文,时间排序 var time_lists = new List <TextListsHot>(); var time_list = blog.OrderByDescending(m => m.TextChangeDate).Take(2).ToList(); foreach (var item in time_list) { var temp = new TextListsHot(); temp.TextID = item.TextID; temp.TextTitle = item.TextTitle; temp.Hot = item.Hot; temp.CategoryName = item.CategoryName; temp.Datemouth = item.TextChangeDate.ToString().Substring(0, 6); time_lists.Add(temp); } ViewBag.timesort = time_lists; //分类查找 var cate_list = blog.ToList(); var templist = new List <string>(); foreach (var item in cate_list) { var temp = new TextListsHot(); temp.TextID = item.TextID; temp.TextTitle = item.TextTitle; temp.Hot = item.Hot; if (!templist.Contains(item.CategoryName)) { templist.Add(item.CategoryName); } temp.Datemouth = item.TextChangeDate.ToString().Substring(0, 6); } ViewBag.categroyList = templist; //最新评论 var commit = from c in db.CommitLists select c; var Ctime_list = commit.OrderByDescending(m => m.CommitChangeDate).Take(1).ToList(); var tempC = new ShowCommit(); var users = from u in db.Users select u; foreach (var item in Ctime_list) { var textT = blog.Where(m => m.TextID == item.TextID).ToList(); var NameC = users.Where(m => m.Account == item.Account).ToList(); tempC.TextId = item.TextID; tempC.Content = item.CommitText; tempC.TextTitle = textT[0].TextTitle; tempC.Name = NameC[0].Name; tempC.Date = item.CommitChangeDate.ToString(); } ViewBag.newestCom = tempC; ViewBag.TopComList = GetTopCmtLst(5);//设定评论排行榜的文章数量 return(View("~/Views/Shared/_Sidebar.cshtml", hots)); }