public List <TextListsHot> GetsortByhots(int n)//博文根据热度排序
{
var hots = new List <TextListsHot>();
var blog = repository.GetTextsAll();
var list = blog.OrderByDescending(m => m.Hot).Take(n).ToList();
foreach (var item in list)
{
var temp = new TextListsHot
{
TextID = item.TextID,
TextTitle = item.TextTitle,
Hot = item.Hot,
Datemouth = item.TextChangeDate.ToString().Substring(0, 6)
};
hots.Add(temp);
}
return(hots);
}
public List <TextListsHot> GetsortBytime(int n)//博文根据时间排序，参数n为获取的文章数量
{
var time_lists = new List <TextListsHot>();
var blog = repository.GetTextsAll();
var time_list = blog.OrderByDescending(m => m.TextChangeDate).Take(n).ToList();
foreach (var item in time_list)
{
var temp = new TextListsHot
{
TextID = item.TextID,
TextTitle = item.TextTitle,
Hot = item.Hot,
CategoryName = item.CategoryName,
Datemouth = item.TextChangeDate.ToString().Substring(0, 6)
};
time_lists.Add(temp);
}
return(time_lists);
}
public List <string> GetCateString()//获取所有分类的名字
{
var templist = new List <string>();
var blog = repository.GetTextsAll();
var cate_list = blog.ToList();
foreach (var item in cate_list)
{
var temp = new TextListsHot
{
TextID = item.TextID,
TextTitle = item.TextTitle,
Hot = item.Hot
};
if (!templist.Contains(item.CategoryName))
{
templist.Add(item.CategoryName);
}
temp.Datemouth = item.TextChangeDate.ToString().Substring(0, 6);
}
return(templist);
}
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));
}