/// <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)); }