public IActionResult Delete(DeleteCategoryRequest model) { if (model == null) { return this.BadRequest(); } var result = this.CategoryService.Delete(model); return this.ApiResponse(result); }
public OperationResult Delete(DeleteCategoryRequest model) { using (var conn = this.OpenConnection()) { string sql = @" UPDATE [Category] SET ParentID=NULL WHERE ParentID IN @IDs; DELETE FROM [Category] WHERE ID IN @IDs; DELETE FROM [CategoryArticle] WHERE CategoryID IN @IDs; "; var para = new { IDs = model.CategoryIDList }; var rows = conn.Execute(sql, para); if (rows == 0) { return OperationResult.ErrorResult("不存在的分类"); } this.ClearCache(); return OperationResult.SuccessResult(); } }