// GET: Blog
public ActionResult Index(int id = 1, string bcategory = "随笔日志")
{
//获取控制器名称
ViewBag.controllername = RouteData.Values["controller"].ToString().ToLower();
int pagesize = 6;
var blogArticleList = BlogArticleServive.QueryOrderBy(a => a.bcategory == bcategory, a => a.bCreateTime, false).ToPagedList(id, pagesize);
foreach (var item in blogArticleList)
{
if (!string.IsNullOrEmpty(item.bcontent))
{
item.bcontent = Tools.ReplaceHtmlTag(item.bcontent);
if (item.bcontent.Length > 200)
{
item.bcontent = item.bcontent.Substring(0, 200);
}
}
}
//发布时间排序
ViewBag.blogtimelist = BlogArticleServive.QueryOrderBy(c => c.bcategory == bcategory, c => c.bCreateTime, false);
//评论排序
ViewBag.blogtrafficlist = BlogArticleServive.QueryOrderBy(c => c.bcategory == bcategory, c => c.btraffic, false);
//留言排序
string sql = @"select a.*,b.btitle from (select blogId,count(1) as counts from Guestbook group by blogId) as a
inner join BlogArticle as b
on
b.bID=a.blogId order by counts desc";
ViewBag.blogguestbooklist = GuestbookServices.RunProc <TopgbViewModels>(sql);
if (Request.IsAjaxRequest())
{
return(PartialView("_ArticleList", blogArticleList));
}
return(View(blogArticleList));
}
/// <summary>
/// 详情页
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Detail(int id)
{
//获取控制器名称
ViewBag.controllername = RouteData.Values["controller"].ToString().ToLower();
var model = BlogArticleServive.getBlogDetails(id);
ViewBag.gblist = GuestbookServices.QueryOrderBy(c => c.blogId == id, c => c.createdate, false).ToPagedList(1, 5);
//发布时间排序
ViewBag.blogtimelist = BlogArticleServive.QueryOrderBy(c => true, c => c.bCreateTime, false);
//评论排序
ViewBag.blogtrafficlist = BlogArticleServive.QueryOrderBy(c => true, c => c.btraffic, false);
//留言排序
string sql = @"select a.*,b.btitle from (select blogId,count(1) as counts from Guestbook group by blogId) as a
inner join BlogArticle as b
on
b.bID=a.blogId order by counts desc";
ViewBag.blogguestbooklist = GuestbookServices.RunProc <TopgbViewModels>(sql);
return(View(model));
}
public ActionResult Index(int pageindex = 1)
{
//获取控制器名称
ViewBag.controllername = RouteData.Values["controller"].ToString().ToLower();
int pagesize = 6;
//获取发布博文信息
var blogArticleList = BlogArticleServive.QueryWhere(a => true).OrderByDescending(a => a.bCreateTime).ToPagedList(pageindex, pagesize);
foreach (var item in blogArticleList)
{
if (!string.IsNullOrEmpty(item.bcontent))
{
item.bcontent = Tools.ReplaceHtmlTag(item.bcontent);
if (item.bcontent.Length > 200)
{
item.bcontent = item.bcontent.Substring(0, 200);
}
}
}
//获取轮播广告新
ViewBag.adList = AdvertisementServices.QueryOrderBy(a => true, a => a.Createdate, false).ToPagedList(1, 3);
//发布时间排序
ViewBag.blogtimelist = BlogArticleServive.QueryOrderBy(c => true, c => c.bCreateTime, false);
//评论排序
ViewBag.blogtrafficlist = BlogArticleServive.QueryOrderBy(c => true, c => c.btraffic, false);
//留言排序
string sql = @"select a.*,b.btitle from (select blogId,count(1) as counts from Guestbook group by blogId) as a
inner join BlogArticle as b
on
b.bID=a.blogId order by counts desc";
ViewBag.blogguestbooklist = GuestbookServices.RunProc <TopgbViewModels>(sql);
return(View(blogArticleList));
}
