/// <summary>
/// 查询用户评论对象列表（根据作者查询）？？？？？
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public AjaxResult <Pagination <UserCommentTargetListDto> > GetList(UserCommentTargetListReq req)
{
Pagination <UserCommentTargetListDto> page = new Pagination <UserCommentTargetListDto>();
var query = from b in db.Usercommenttargetinfo
select new UserCommentTargetListDto
{
ID = b.Id,
PlatformID = b.PlatformId,
PlatformName = db.Subchannel.Where(w => w.Id == b.PlatformId).FirstOrDefault().SubChannelName,
CommentType = b.CommentType,
CommentTypeName = b.CommentType == (int)AIDB.Enum.UserCommentListEnum.CommentType.短文 ? "短文" : b.CommentType == (int)AIDB.Enum.UserCommentListEnum.CommentType.长文 ? "长文" : b.CommentType == (int)AIDB.Enum.UserCommentListEnum.CommentType.视频 ? "视频" : "",
CommentTargetID = b.CommentTargetId,
CommentTargetTitle = b.CommentTargetTitle,
Remark = b.Remark,
TableName = b.TableName,
SoureUrl = b.SoureUrl,
PinLunCount = db.Usercommentlistinfo.Where(s => s.CommentTargetId == b.CommentTargetId).Count(),
};
if (req.PlatformID > 0)
{
query = query.Where(w => w.PlatformID == req.PlatformID);
}
if (req.CommentType > 0)
{
query = query.Where(w => w.CommentType == req.CommentType);
}
if (!string.IsNullOrWhiteSpace(req.CommentTargetTitle))
{
query = query.Where(w => w.CommentTargetTitle.Contains(req.CommentTargetTitle));
}
page.TotalCount = query.Count();
page.dataList = query.OrderByDescending(m => m.ID).Skip((req.PageIndex - 1) * req.PageSize).Take(req.PageSize).ToList();
return(new AjaxResult <Pagination <UserCommentTargetListDto> >(page));
}
public JsonResult Ajax_GetList(UserCommentTargetListReq req)
{
return(Json(ucl.GetList(req)));
}
