Пример #1
0
        public IActionResult Edit(EditCategoryRequest model)
        {
            if (model == null)
            {
                return this.BadRequest();
            }

            var result = this.CategoryService.Edit(model);

            return this.ApiResponse(result);
        }
Пример #2
0
        public OperationResult Edit(EditCategoryRequest model)
        {
            if (!this.CheckCategoryName(model.Name, model.ID))
            {
                return OperationResult<int?>.ErrorResult("分类名称重复");
            }
            if (model.ParentID.Value == model.ID.Value)
            {
                return OperationResult.ErrorResult("错误的上级分类");
            }
            if (model.ParentID.HasValue && !this.CheckParentID(model.ParentID.Value))
            {
                return OperationResult<int?>.ErrorResult("错误的上级分类");
            }
            if (this.GetCategoryList().Any(t => t.ParentID == model.ID.Value))
            {
                return OperationResult<int?>.ErrorResult("只允许二级分类");
            }

            using (var conn = this.OpenConnection())
            {
                string sql = @"
UPDATE TOP(1) [Category]
SET Name=@Name, ParentID=@ParentID
WHERE ID=@ID;
";

                var para = new
                {
                    model.ID,
                    model.Name,
                    model.ParentID
                };

                var rows = conn.Execute(sql, para);

                if (rows == 0)
                {
                    return OperationResult.ErrorResult("不存在的分类");
                }
                else
                {
                    this.ClearCache();

                    return OperationResult.SuccessResult();
                }
            }
        }