/// <summary>
/// 删除商品评论
/// </summary>
/// <param name="ProductCommentId">评论ID</param>
/// <returns></returns>
public JsonResult DeleteSP_ProductComment(long?ProductCommentId)
{
SP_ProductCommentModel model = new SP_ProductCommentModel();
var resultModel = new ResultModel();
if (ProductCommentId.HasValue)
{
model.ProductCommentId = ProductCommentId.Value;
var result = this._sp_ProductCommentService.DeleteSP_ProductComment(model);
var opera = string.Empty;
opera += "删除商品评论 ProductCommentId:" + model.ProductCommentId + ",结果:" + result.IsValid;
LogPackage.InserAC_OperateLog(opera, "Review product comment");
resultModel = LogPackage.GetResulMessagest(result.IsValid, new List <string> {
result.IsValid == true ? "Delete success" : "Delete failed"
});
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
else
{
resultModel = LogPackage.GetResulMessagest(false, new List <string> {
"Invalid comment ID "
});
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 添加商品评论
/// </summary>
/// <param name="model">商品评论</param>
/// <returns>是否成功</returns>
public ResultModel AddSP_ProductComment(SP_ProductCommentModel model)
{
var result = new ResultModel
{
Data = base._database.Db.SP_ProductComment.Insert(model)
};
return(result);
}
/// <summary>
/// 删除商品评论
/// </summary>
/// <param name="model">商品评论模型</param>
/// <returns>是否删除成功</returns>
public ResultModel DeleteSP_ProductComment(SP_ProductCommentModel model)
{
var result = new ResultModel()
{
Data = base._database.Db.SP_ProductComment.Delete(ProductCommentId: model.ProductCommentId)
};
result.IsValid = result.Data > 0 ? true : false;
return(result);
}
/// <summary>
/// 更新商品评论状态
/// </summary>
/// <param name="model">商品评论模型</param>
/// <returns>是否修改成功</returns>
public ResultModel UpdateSP_ProductCommentCheckStatus(SP_ProductCommentModel model)
{
var result = new ResultModel()
{
Data = base._database.Db.SP_ProductComment.UpdateByProductCommentId(ProductCommentId: model.ProductCommentId, CheckStatus: model.CheckStatus, CheckBy: model.CheckBy, CheckDT: model.CheckDT)
};
result.IsValid = result.Data > 0 ? true : false;
return(result);
}
/// <summary>
/// 商品加载数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Create(long?id)
{
SP_ProductCommentModel model = new SP_ProductCommentModel();
if (id.HasValue)
{
SearchSP_ProductCommentModel smodel = new SearchSP_ProductCommentModel();
smodel.ProductCommentId = id.Value;
smodel.PagedIndex = 0;
smodel.PagedSize = 100;
//查询列表
List <SP_ProductCommentModel> List = this._sp_ProductCommentService.GetSP_ProductCommentList(smodel).Data;
if (List != null && List.Count > 0)
{
model = List[0];
}
}
return(PartialView(model));
}
public ActionResult Create(SP_ProductCommentModel model)
{
if (ModelState.IsValid)
{
ResultModel resultModel = new ResultModel();
model.CheckBy = UserInfo.CurrentUserName;
model.CheckDT = DateTime.Now;
var result = this._sp_ProductCommentService.UpdateSP_ProductCommentCheckStatus(model);
if (result != null)
{
resultModel.Messages = new List <string> {
result.IsValid == true ? "Review success！" : "Review failed！"
};
var opera = string.Empty;
opera += "修改审核状态CheckStatus:" + model.CheckStatus + ",ProductCommentId:" + model.ProductCommentId + ",结果:" + result.IsValid;
LogPackage.InserAC_OperateLog(opera, "Review product comment");
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
return(PartialView(model));
}
/// <summary>
/// 批量添加商品评论
/// </summary>
/// <param name="models">商品评论</param>
/// <returns>评论列表</returns>
public ResultModel BatchAddSP_ProductComment(List <SP_ProductCommentModel> models)
{
var result = new ResultModel();
//List<SP_ProductCommentModel> entities = new List<SP_ProductCommentModel>();
if (models == null || models.Count == 0)
{
result.IsValid = false;
result.Messages.Add("请输入评论内容");
}
else
{
int count = _database.Db.Order.GetCount(_database.Db.Order.OrderID == models[0].OrderId && _database.Db.Order.UserID == models[0].UserID);
if (count == 0)
{
result.IsValid = false;
result.Messages.Add("参数非法,该订单不是您的订单");
}
else
{
//获取订单详情
List <OrderDetailsViewT1> orderDetails = _database.Db.OrderDetails.FindAll(_database.Db.OrderDetails.OrderID ==
models.Select(x => x.OrderId).ToArray() &&
_database.Db.OrderDetails.SKU_ProducId ==
models.Select(x => x.SKU_ProducId).ToArray() &&
_database.Db.OrderDetails.Iscomment == 0);
//开启事务
var trans = _database.Db.BeginTransaction();
try
{
foreach (var model in models)
{
var orderDetail =
orderDetails.FirstOrDefault(x => x.OrderID == model.OrderId.ToString() && x.ProductId == model.ProductId && x.SKU_ProducId == model.SKU_ProducId);
if (orderDetail != null && orderDetail.Iscomment == 0)
{
List <CommentLablesList> _list = CommentLablesList.ReturnList(model.LablesStr);
SP_ProductCommentModel tempModel = trans.SP_ProductComment.Insert(model);
//是否评价成功
if (tempModel.ProductCommentId > 0)
{
foreach (CommentLablesList x in _list)
{
trans.SP_ProductComment_Labels.Insert(ProductCommentId: tempModel.ProductCommentId, UserID: model.UserID, Labels: x.Labels);
}
if (trans.OrderDetails.UpdateByOrderDetailsID(OrderDetailsID: orderDetail.OrderDetailsID, Iscomment: 1) == 0)
{
//entities.Add(tempModel);
trans.Rollback();
}
}
else
{
trans.Rollback();
}
}
}
trans.Commit();
result.IsValid = true;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
//result.Data = entities;
}
}
return(result);
}
public void SP_ProductCommentService_GetSP_ProductCommentById_Test()
{
SP_ProductCommentModel resultModel = this._sp_productCommentService.GetSP_ProductCommentById(5).Data;
Assert.IsTrue(true);
}
public static SP_ProductComment ToEntity(this SP_ProductCommentModel model)
{
return(Mapper.Map <SP_ProductComment>(model));
}
