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)); }
/// <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 = 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: 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)); }
public ActionResult Search(string wd) { var content = wd; var str = ""; var segmenter = new JiebaSegmenter(); str += ($"原检索语句: {content}<br >"); if (!string.IsNullOrEmpty(content)) { //PanGuLuceneHelper.instance.DeleteAll(); var segments4 = segmenter.CutForSearch(content); // 搜索引擎模式 str += ($"【搜索引擎模式】:{ string.Join("/ ", segments4)}<br >"); var topicList = TopicServive.QueryOrderBy(a => !a.tIsDelete, a => a.tCreatetime, false); var topicDetailList = TopicDetailServive.QueryOrderBy(a => !a.tdIsDelete, a => a.tdCreatetime, false); var blogArticleList = BlogArticleServive.QueryOrderBy(a => true, a => a.bCreateTime, false); List <MySearchUnit> list = new List <MySearchUnit>(); foreach (var item in topicList) { list.Add(new MySearchUnit("Topic" + item.Id, item.tName, item.tDetail, new Random().Next(1, 100).ToString(), "", item.tCreatetime.ToString("yyyy年MM月dd日"))); } foreach (var item in topicDetailList) { item.tdContent = Tools.ReplaceHtmlTag(item.tdContent); list.Add(new MySearchUnit("TopicDetail" + item.Id, item.tdName, item.tdContent, new Random().Next(1, 100).ToString(), "", item.tdCreatetime.ToString("yyyy年MM月dd日"))); } foreach (var item in blogArticleList) { item.bcontent = Tools.ReplaceHtmlTag(item.bcontent); list.Add(new MySearchUnit("BlogArtic" + item.bID, item.btitle, item.bcontent, new Random().Next(1, 100).ToString(), "", item.bCreateTime.ToString("yyyy年MM月dd日"))); } PanGuLuceneHelper.instance.CreateIndex(list);//添加索引 int count = 0; int PageIndex = 1; int PageSize = 100; string html_content = ""; List <MySearchUnit> searchlist = PanGuLuceneHelper.instance.Search("", string.Join(" ", segments4.Where(d => d.Length >= 2)), PageIndex, PageSize, out count); List <string> idList = new List <string>(); if (searchlist == null || searchlist.Count == 0) { html_content += ("未查询到数据。<br/>"); } else { foreach (MySearchUnit data in searchlist) { if (!idList.Contains(data.id)) { //html_content += (string.Format("id:{0},title:{1},content:{2},flag:{3},updatetime:{4}<br/>", data.id, data.title, data.content, data.flag, data.updatetime)); html_content += GetSearchHtml(data.id, data.title, data.content, data.updatetime); idList.Add(data.id); } } } html_content += ("查询结果:" + idList.Count + "条数据<br/>"); str += html_content; } else { return(View("Home")); } ViewBag.html = str; return(View()); }