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