public async Task <ModelPager <VueUserBook> > queryUserBook(QUserBook query)
{
ModelPager <VueUserBook> result = new ModelPager <VueUserBook>(query.pageIndex, query.pageSize);
var mainSql = Db.Queryable <EUserBook, EBookInfo>((ub, b) => new object[]
{
JoinType.Inner, ub.bookCode == b.Code
})
.Where(ub => ub.userId == query.userId)
.OrderBy(ub => ub.createdDateTime, OrderByType.Desc)
.Select((ub, b) => new VueUserBook
{
id = ub.Id,
Code = b.Code,
CoverUrl = b.CoverUrl,
Name = b.Title,
ResourceCount = b.ResoureNum,
Score = b.Score,
CreateDateTime = ub.createdDateTime,
});
RefAsync <int> totalNumber = new RefAsync <int>();
result.datas = await mainSql.ToPageListAsync(query.pageIndex, query.pageSize, totalNumber);
result.totalCount = totalNumber;
return(result);
}
public ModelPager <VueUserBook> queryUserbookList(QUserBook query)
{
if (string.IsNullOrEmpty(query.userId))
{
throw new Exception("非法操作！");
}
return(_userBookRepository.queryUserBook(query).Result);
}
public ResultPager <VueUserBook> FavBookList(QUserBook query)
{
ResultPager <VueUserBook> result = new ResultPager <VueUserBook>();
try
{
// query.userId = this.getUserId();
result.PageData = _userServices.queryUserbookList(query);
}
catch (Exception ex)
{
result.ErrorMsg = ex.Message;
}
return(result);
}
