public ActionResult JokeList(string pinyin) { JokeSearchModel search = new JokeSearchModel(); search.Page = 1; search.PageSize = 20; var pageResult = jokeBusinessLogic.JokePostInfo(search); return(View(pageResult)); }
public ActionResult Images(int page = 1) { SetPageSeo(string.Format("搞笑图片_成人搞笑图片_超级冷笑话_第{0}页", page), SiteKeyWords, SiteDescription); JokeSearchModel search = new JokeSearchModel(); search.Page = page; search.SearchType = JokeSearchType.ImageJokes; var pageResult = jokeLogic.JokePostInfo(search); pageResult.Data = "images"; pageResult.Data1 = "搞笑图片"; return(View("~/Views/Home/JokeList.cshtml", pageResult)); }
public ActionResult LengXiaoHua(int page = 1) { SetPageSeo(string.Format("最新冷笑话_笑话大全_第{0}页", page), SiteKeyWords, SiteDescription); JokeSearchModel search = new JokeSearchModel(); search.Page = page; search.SearchType = JokeSearchType.LengXioaHua; var pageResult = jokeLogic.JokePostInfo(search); pageResult.Data = "lengxiaohua"; pageResult.Data1 = "冷笑话"; return(View("~/Views/Home/JokeList.cshtml", pageResult)); }
public ActionResult Latest(int page = 1) { SetPageSeo(string.Format("{1}年最新冷笑话_最新成人笑话_超级冷笑话_第{0}页", page, DateTime.Now.Year), SiteKeyWords, SiteDescription); JokeSearchModel search = new JokeSearchModel(); search.Page = page; search.SearchType = JokeSearchType.Latest; var pageResult = jokeLogic.JokePostInfo(search); pageResult.Data = "latest"; pageResult.Data1 = "最新冷笑话"; return(View("~/Views/Home/JokeList.cshtml", pageResult)); }
public ActionResult JokeCategoryList(string pinyin, int page = 1, int pagesize = 20) { pinyin = Sanitizer.GetSafeHtmlFragment(pinyin); var category = jokeLogic.CategoryGet(pinyin); string title = string.Format("{0}笑话大全_超级冷笑话_第{1}页", category.Name, page); string keywords = string.Format("{0}笑话,{1}", category.Name, SiteKeyWords); string description = string.Format("{0}笑话,{1}", category.Name, SiteDescription); SetPageSeo(title, keywords, description); JokeSearchModel search = new JokeSearchModel(); search.Page = page; search.PageSize = pagesize; search.CategoryPinyin = pinyin; search.CategoryID = category.ID; var pageResult = jokeLogic.JokePostInfo(search); pageResult.Data = pinyin; pageResult.Data1 = category.Name; return(View("~/Views/Home/JokeList.cshtml", pageResult)); }
public PageSearchResult <JokePostInfo> JokePostInfo(JokeSearchModel search) { StringBuilder where = new StringBuilder(); if (search.SearchType == JokeSearchType.Latest) { where.AppendFormat(" and j.Type={0}", 0); } else if (search.SearchType == JokeSearchType.ImageJokes) { where.AppendFormat(" and j.Type={0}", 1); } if (search.CategoryID > 0) { where.AppendFormat(" and j.Category={0}", search.CategoryID); } string sql = string.Format(@"declare @@pagenum int=@0; declare @@pagesize int = @1; with tmp as ( SELECT ROW_NUMBER() over(order by j.ID DESC) as Num, j.ID as JokeId,j.Title,j.Content,j.LikeCount,j.HateCount,u.NikeName,u.ID as UserId,j.Type as JokeType,j.AddDate as PostDate,u.UserName,c.Name as Category,c.PinYin as CategoryPinyin from T_Joke j with(NOLOCK) inner join T_User u on u.ID = j.PostID inner join T_Category c on c.ID = j.Category where j.State=1 {0} ) SELECT JokeId,Title,Content,LikeCount,HateCount,NikeName,UserId,JokeType,PostDate,UserName,Category,CategoryPinyin from tmp where Num>(@@pagenum-1)*@@pagesize and Num<=@@pagenum*@@pagesize; select COUNT(1) from T_Joke j where State=1 {0}", where.ToString()); var items = this.jokeDatabase.FetchMultiple <JokePostInfo, int>(sql, search.Page, search.PageSize); PageSearchResult <JokePostInfo> pageResult = new PageSearchResult <JokePostInfo>() { Items = items.Item1, Page = search.Page, PageSize = search.PageSize, TotalCount = items.Item2[0] }; return(pageResult); }
public PageSearchResult <JokePostInfo> JokePostInfo(JokeSearchModel search) { return(jokeData.JokePostInfo(search)); }