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));
}
