// GET: admin/BlogArticle public ActionResult Index() { ViewBag.UserName = LoginUser.uRealName; var BlogArticles = BlogArticleServive.QueryWhere(a => true).OrderByDescending(a => a.bCreateTime); return(View(BlogArticles)); }
public ActionResult Index(int pageIndex = 1) { //获取控制器名称 ViewBag.controllername = RouteData.Values["controller"].ToString().ToLower(); int pageSize = 6; //获取发布博文信息 var blogArticleList = blogArticleServive.QueryWhere(p => true).OrderByDescending(p => p.bCreateTime).ToPagedList(pageIndex, pageSize); foreach (var item in blogArticleList) { if (!string.IsNullOrWhiteSpace(item.bcontent)) { item.bcontent = Server.HtmlDecode(item.bcontent); if (item.bcontent.Length > 100) { item.bcontent = item.bcontent.Substring(0, 200); } } } //获取轮播广告新 ViewBag.adList = advertisementServices.QueryOrderBy(a => true, a => a.Createdate, false).ToPagedList(1, 3); //发布时间排序 ViewBag.blogtimelist = blogArticleServive.QueryOrderBy(p => true, p => p.bCreateTime, false); //评论排序 ViewBag.blogtrafficlist = blogArticleServive.QueryOrderBy(p => true, p => p.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"; return(View(blogArticleList)); }
public ActionResult addGuestbook(GuestbookViewModels model) { model.createdate = DateTime.Now; model.ip = Request.UserHostAddress; //AutoMapper自动映射 Mapper.Initialize(cfg => cfg.CreateMap <GuestbookViewModels, Guestbook> ()); Guestbook models = Mapper.Map <GuestbookViewModels, Guestbook> (model); BlogArticle blogArticle = BlogArticleServive.QueryWhere(a => a.bID == model.blogId).FirstOrDefault(); blogArticle.bcommentNum += 1; BlogArticleServive.SaverChanges(); GuestbookServices.Add(models); GuestbookServices.SaverChanges(); ViewBag.gblist = GuestbookServices.QueryOrderBy(c => c.blogId == model.blogId, c => c.createdate, false).ToPagedList(1, 5); return(PartialView("_GuestbookPage")); }
public ActionResult Index(int pageindex = 1) { //获取控制器名称 ViewBag.controllername = RouteData.Values["controller"].ToString().ToLower(); int pagesize = 6; //获取发布博文信息 var blogArticleList = BlogArticleService.QueryWhere(a => true).OrderByDescending(a => a.create_time).ToPagedList(pageindex, pagesize); foreach (var item in blogArticleList) { if (!string.IsNullOrEmpty(item.content)) { item.content = HtmlTool.ReplaceHtmlTag(item.content); if (item.content.Length > 200) { item.content = item.content.Substring(0, 200); } } } //获取轮播广告新 ViewBag.adList = AdvertisementServices.QueryOrderBy(a => true, a => a.create_time, false).ToPagedList(1, 3); //发布时间排序 ViewBag.blogtimelist = BlogArticleService.QueryOrderBy(c => true, c => c.create_time, false); //评论排序 ViewBag.blogtrafficlist = BlogArticleService.QueryOrderBy(c => true, c => c.traffic, false); //留言排序 string sql = @"select a.*,b.title from (select blog_id,count(1) as counts from guest_book group by blog_id) as a inner join blog_article as b on b.id=a.blog_id order by counts desc"; ViewBag.blogguestbooklist = GuestbookService.RunProc <TopgbViewModel>(sql); return(View(blogArticleList)); }
// GET: admin/BlogArticle public ActionResult Index() { var BlogArticles = BlogArticleServive.QueryWhere(a => true).OrderByDescending(a => a.create_time); return(View(BlogArticles)); }