/// <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);
        }
Exemplo n.º 9
0
 public static SP_ProductComment ToEntity(this SP_ProductCommentModel model)
 {
     return(Mapper.Map <SP_ProductComment>(model));
 }