/// <summary>
/// 分页查询
/// </summary>
/// <param name="queryPager_Book_User"></param>
/// <returns></returns>
public Models.Response.PageResult GetByPage(QueryPager_Book_Read_Record queryPager_Book_User)
{
//查询表达式
var exp = Cat.M.Book.Services.Helper.ExpressionHelper.GetExpressionByQueryPager <QueryPager_Book_Read_Record, Book_Read_Record>(queryPager_Book_User);
//排序
Dictionary <string, string> dicOrderBy = new Dictionary <string, string>();
if (!string.IsNullOrEmpty(queryPager_Book_User.sorter))
{
dicOrderBy.Add(queryPager_Book_User.sort, queryPager_Book_User.order);
}
else
{
dicOrderBy.Add("Create_Time", "desc");
}
var q = from a in base.Entities.Where(exp)
join t in AllServices.BookChapterReadRecordService.Entities on a.Last_Reading_Record_Id equals t.Id into temp
from tt in temp.DefaultIfEmpty()
select new Book_Read_Record()
{
Id = a.Id,
Rule = a.Rule,
Author = a.Author,
Book_Name = a.Book_Name,
Book_Classify = a.Book_Classify,
Book_Link = a.Book_Link,
Cover_Image = a.Cover_Image,
Book_Intro = a.Book_Intro,
Openid = a.Openid,
Last_Reading_Record_Id = a.Last_Reading_Record_Id,
IsHidden = a.IsHidden,
AlreadyCollected = a.AlreadyCollected,
Create_Time = a.Create_Time,
Update_Time = a.Update_Time,
Last_Reading_ChapterName = tt.Chapter_Name,
Last_Reading_ChapterLink = tt.Chapter_Link
};
int count = q.Count();
var list = q.OrderBy(dicOrderBy).Skip((queryPager_Book_User.pn - 1) * queryPager_Book_User.ps).Take(queryPager_Book_User.ps).ToList();
return(new Models.Response.PageResult()
{
Count = count,
List = list,
Pageindex = queryPager_Book_User.pn,
Pagesize = queryPager_Book_User.ps,
Pages = (count / queryPager_Book_User.ps) + (count % queryPager_Book_User.ps > 0 ? 1 : 0)
});
//return base.GetByPage(queryPager_Book_User.pn, queryPager_Book_User.ps, exp, listOrderBy);
}
/// <summary>
/// 获取用户阅读记录（小说基本信息）
/// </summary>
/// <param name="requestParams"></param>
/// <returns></returns>
public ActionRes GetListByPage(QueryPager_Book_Read_Record requestParams)
{
var pageResult = AllServices.BookReadRecordService.GetByPage(requestParams);
return(ActionRes.Success(pageResult));
}
