public ModelPager <VueUserRes> queryUserRes(QUserRes query)
{
if (string.IsNullOrEmpty(query.userId))
{
throw new Exception("非法操作！");
}
return(_ResourceReponsitory.queryUserRes_GroupByBook(query));
}
public ResultPager <VueUserRes> GetAllResourceByOwner(QUserRes query)
{
ResultPager <VueUserRes> result = new ResultPager <VueUserRes>();
try
{
// query.userId = base.getUserId();
result.PageData = _resourceServices.queryUserRes(query);
}
catch (Exception ex)
{
result.ErrorMsg = ex.Message;
}
return(result);
}
public ModelPager <VueUserRes> queryUserRes_GroupByBook(QUserRes query)
{
ModelPager <VueUserRes> result = new ModelPager <VueUserRes>(query.pageIndex, query.pageSize);
var mainSql = Db.Queryable <EResourceInfo, EBookInfo>((r, b) => new object[]
{
JoinType.Inner, r.RefCode == b.Code
})
.Where((r, b) => r.Owner == query.userId && r.IsDelete == false)
.GroupBy((r, b) => new { b.Code, r.Owner, b.Title, b.CoverUrl })
.Select((r, b) => new VueUserRes
{
bookCode = b.Code,
bookCoverUrl = b.CoverUrl,
bookName = b.Title,
});
// RefAsync<int> totalNumber = new RefAsync<int>();
int totalNumber = 0;
result.datas = mainSql.ToPageList(query.pageIndex, query.pageSize, ref totalNumber);
result.totalCount = totalNumber;
result.datas = arrangeUserRes(result.datas);
return(result);
}
