public IActionResult Add(AddCategoryRequest model) { if (model == null) { return this.BadRequest(); } var result = this.CategoryService.Add(model); return this.ApiResponse(result); }
public OperationResult<int?> Add(AddCategoryRequest model) { if (!this.CheckCategoryName(model.Name, null)) { return OperationResult<int?>.ErrorResult("分类名称重复"); } if (model.ParentID.HasValue && !this.CheckParentID(model.ParentID.Value)) { return OperationResult<int?>.ErrorResult("错误的上级分类"); } using (var conn = this.OpenConnection()) { string sql = @" INSERT INTO [Category] ( Name, ParentID ) VALUES ( @Name, @ParentID ); SELECT @@IDENTITY; "; var para = new { Name = model.Name, ParentID = model.ParentID }; var id = conn.ExecuteScalar<int>(sql, para); this.ClearCache(); return OperationResult<int?>.SuccessResult(id); } }