/// <summary>
/// 添加
/// </summary>
/// <param name="review"></param>
/// <returns></returns>
public static int AddReview(ht_review review)
{
using (Entities db = new Entities())
{
db.ht_review.Add(review);
return(db.SaveChanges());
}
}
public ActionResult AddReview(ht_review review)
{
Model.ht_review model = new Model.ht_review();
AuthenticationUser loginInfo = HT.BLL.BLLUser.GetLoginUserInfo();
if (loginInfo == null)
{
apiResp.msg = "请先登录";
apiResp.code = (int)HT.Model.Enum.APIErrCode.UserIsNotLogin;
return(Json(apiResp));
}
model.avatar = loginInfo.avatar;
model.userid = loginInfo.id;
model.nickname = loginInfo.nickname;
model.status = 0;
model.add_time = DateTime.Now;
model.review_content = review.review_content;
model.news_id = review.news_id;
model.review_type = review.review_type;
model.review_id = review.review_id;
if (HT.BLL.BLLReview.AddReview(model) > 0)
{
apiResp.status = true;
apiResp.result = model;
apiResp.msg = "评论完成";
}
else
{
apiResp.msg = "评论出错";
apiResp.code = (int)HT.Model.Enum.APIErrCode.OperateFail;
}
return(Json(apiResp));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="searchKey"></param>
/// <returns></returns>
public static Model.Model.PageResult <ht_review> GetReviewList(int page, int rows, ht_review searchKey)
{
Model.Model.PageResult <ht_review> pageModel = new Model.Model.PageResult <ht_review>();
using (Entities db = new Entities())
{
db.Configuration.ProxyCreationEnabled = false;
var data = db.ht_review.Where(p => p.status == 1); //审核才出现
if (!string.IsNullOrWhiteSpace(searchKey.review_type))
{
data = data.Where(p => p.review_type == searchKey.review_type);
}
if (searchKey.news_id != 0)
{
data = data.Where(p => p.news_id == searchKey.news_id);
}
data = data.OrderByDescending(p => p.add_time);
pageModel.list = data.Skip((page - 1) * rows).Take(rows).ToList();
foreach (var item in pageModel.list)
{
item.reply_list = db.ht_review
.Where(p => p.review_id == item.id && p.status == 1 && p.review_type == "reply")
.OrderByDescending(p => p.id).ToList();
}
pageModel.total = data.Count();
}
pageModel.totalpage = (int)Math.Ceiling((decimal)pageModel.total / (decimal)rows);//总页数
return(pageModel);
}
