/// <summary>
/// 评论获得的赞
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private ISugarQueryable <VueUserPraize> sql_UserCommentPraize(QUserPraize query)
{
ISugarQueryable <VueUserPraize> prSql = Db.Queryable <EPraize_Comment, EComment_Res, EBookInfo>((p, c, b) => new object[]
{
JoinType.Inner, p.commentId == c.Id,
JoinType.Inner, c.parentRefCode == b.Code
})
.Where(p => p.userId == query.userId)
.OrderBy(p => p.praizeDate, OrderByType.Desc)
.Select((p, c, b) => new VueUserPraize
{
id = p.Id,
CreateDateTime = p.praizeDate,
code = c.Id.ToString(),
resCode = c.refCode,
commentId = c.Id,
bookCode = b.Code,
bookName = b.Title,
bookUrl = b.CoverUrl,
content = c.content,
});
return(prSql);
}
public async Task <ModelPager <VueUserPraize> > queryUserCommentReplyPraize(QUserPraize query)
{
ModelPager <VueUserPraize> result = new ModelPager <VueUserPraize>(query.pageIndex, query.pageSize);
var prSql = sql_UserCommReplyPraize(query);
RefAsync <int> totalNumber = new RefAsync <int>();
result.datas = await prSql.ToPageListAsync(query.pageIndex, query.pageSize, totalNumber);
result.totalCount = totalNumber;
return(result);
}
public ResultPager <VueUserPraize> UserPraize(QUserPraize query)
{
ResultPager <VueUserPraize> result = new ResultPager <VueUserPraize>();
try
{
result.PageData = _praizeServices.queryUserPraize(query);
}
catch (Exception ex)
{
result.ErrorMsg = ex.Message;
}
return(result);
}
public ModelPager <VueUserPraize> queryUserPraize(QUserPraize query)
{
if (string.IsNullOrEmpty(query.userId))
{
throw new Exception("非法操作！");
}
switch (query.praizeTarget)
{
case PraizeTarget.Resource:
return(_praizeRepository.queryUserResPraize(query).Result);
case PraizeTarget.Comment:
return(_praizeRepository.queryUserCommentPraize(query).Result);
case PraizeTarget.CommentReply:
return(_praizeRepository.queryUserCommentReplyPraize(query).Result);
default:
return(new ModelPager <VueUserPraize>());
}
}
/// <summary>
/// 资源获得的赞
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private ISugarQueryable <VueUserPraize> sql_UserResPraize(QUserPraize query)
{
ISugarQueryable <VueUserPraize> prSql = Db.Queryable <EPraize_Res, EResourceInfo, EBookInfo>((p, r, b) => new object[]
{
JoinType.Inner, p.ResCode == r.Code,
JoinType.Inner, p.bookCode == b.Code
})
.Where(p => p.userId == query.userId)
.OrderBy(p => p.praizeDate, OrderByType.Desc)
.Select((p, r, b) => new VueUserPraize
{
id = p.Id,
CreateDateTime = p.praizeDate,
code = r.Code,
resCode = r.Code,
bookCode = b.Code,
bookName = b.Title,
bookUrl = b.CoverUrl,
resPraizeType = p.PraizeType,
content = b.Title + "的" + "[" + r.FileType + "资源文件]-" + (r.ResType == ResType.BookOss ? r.OrigFileName : "url地址"),
});
return(prSql);
}
