public List <ReviewOnlyDTO> GetReviewOnlyByCommodityId(ReviewSearchDTO search)
{
//定义返回值
List <ReviewOnlyDTO> result;
try
{
//调用代理方法
result = base.Channel.GetReviewOnlyByCommodityId(search);
}
catch
{
//抛异常
throw;
}
finally
{
//关链接
ChannelClose();
} //返回结果
return(result);
}
/// <summary>
/// 根据商品ID查询商品评价
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public System.Collections.Generic.List <Jinher.AMP.BTP.Deploy.CustomDTO.ReviewOnlyDTO> GetReviewOnlyByCommodityId(ReviewSearchDTO search)
{
base.Do();
return(this.Command.GetReviewOnlyByCommodityId(search));
}
/// <summary>
/// 根据商品ID查询商品评价
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public System.Collections.Generic.List <Jinher.AMP.BTP.Deploy.CustomDTO.ReviewOnlyDTO> GetReviewOnlyByCommodityIdExt(ReviewSearchDTO search)
{
if (search == null || search.PageSize <= 0)
{
return(new List <ReviewOnlyDTO>());
}
try
{
var query = Review.ObjectSet().
Where(n => n.CommodityId == search.CommodityId);
DateTime lastReviewTime = DateTime.Today.AddDays(2);
if (search.LastReviewId.HasValue)
{
var lastReviewId = search.LastReviewId.Value;
var lastReview = Review.ObjectSet().Where(c => c.Id == lastReviewId).Select(c => c.SubTime).FirstOrDefault();
if (lastReview != DateTime.MinValue)
{
lastReviewTime = lastReview;
}
}
else if (search.LastReviewTime.HasValue)
{
lastReviewTime = search.LastReviewTime.Value;
}
var reviewList =
query.Where(n => n.SubTime < lastReviewTime).OrderByDescending(n => n.SubTime).Select(data => new ReviewOnlyDTO
{
ReviewId = data.Id,
UserId = data.UserId,
OrderItemId = data.CommodityId,
Name = data.UserName,
Details = data.Content,
SubTime = data.SubTime,
Size = data.CommodityAttributes,
})
.Take(search.PageSize)
.ToList();
if (reviewList.Any())
{
foreach (var reviewOnlyDTO in reviewList)
{
reviewOnlyDTO.Name = ConvertAnonymous(reviewOnlyDTO.Name);
}
}
return(reviewList);
}
catch (Exception ex)
{
LogHelper.Error(string.Format("ReviewSV.GetReviewOnlyByCommodityIdExt: search:{0}", JsonHelper.JsonSerializer(search)), ex);
return(new List <ReviewOnlyDTO>());
}
}
