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