public ActionResult JokeList(int page = 1, int pagesize = 20, int state = 0)
{
UserJokesSearchModel userSearch = new UserJokesSearchModel();
userSearch.JokeState = state;
var pageViewResult = jokeLogic.UserJokesSearch(userSearch);
return(View(pageViewResult));
}
public ActionResult JokeList(int page = 1)
{
UserJokesSearchModel search = new UserJokesSearchModel();
search.UserId = user.UserId;
search.Page = page;
var pageViewResult = jokeLogic.UserJokesSearch(search);
return(View(pageViewResult));
}
public ActionResult Index(int page = 1)
{
UserJokesSearchModel userSearch = new UserJokesSearchModel();
userSearch.JokeType = 0;
userSearch.JokeState = 1;
userSearch.UserId = null;
userSearch.Page = page;
var items = jokeLogic.UserJokesSearch(userSearch);
items.Data = "latest";
items.Data1 = "最新";
return(View(items));
}
public PageSearchResult <JokePostInfo> UserJokesSearch(UserJokesSearchModel search)
{
StringBuilder where = new StringBuilder();
if (search.UserId != null)
{
where.AppendFormat(" and j.postid={0}", search.UserId);
}
if (search.JokeState != null)
{
where.AppendFormat(" and j.State={0}", search.JokeState);
}
if (search.JokeType != null)
{
where.AppendFormat(" and j.Type={0}", search.JokeType);
}
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,j.State as JokeState,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 1=1 {0}
)
SELECT JokeId,Title,Content,LikeCount,HateCount,NikeName,UserId,JokeType,PostDate,UserName,JokeState,CategoryPinyin,Category from tmp where Num>(@@pagenum-1)*@@pagesize and Num<=@@pagenum*@@pagesize;
select COUNT(1) from T_Joke j where 1=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> UserJokesSearch(UserJokesSearchModel search)
{
var pageViewResult = jokeData.UserJokesSearch(search);
return(pageViewResult);
}
