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