public IActionResult Edit(EditArticleRequest model) { if (model == null) { return this.BadRequest(); } var result = this.ArticleService.Edit(model); return this.ApiResponse(result); }
public OperationResult Edit(EditArticleRequest model) { using (var scope = new TransactionScope()) using (var conn = this.OpenConnection()) { string sql = @" UPDATE TOP(1) Article SET Title=@Title,Content=@Content,Summary=@Summary,UserID=@UserID,[From]=@From,PostDate=ISNULL(@PostDate,PostDate),Status=isnull(@Status,Status),AllowComment=@AllowComment WHERE ID=@ID; "; var rows = conn.Execute(sql, new { ID = model.ID.Value, model.Title, model.Content, model.Summary, model.UserID, model.From, PostDate = model.PostDate ?? DateTime.Now, Status = model.Status, model.AllowComment }); if (rows == 0) { return OperationResult.ErrorResult("不存在的文章"); } sql = @" DELETE FROM CategoryArticle WHERE ArticleID=@ID; "; conn.Execute(sql, new { ID = model.ID.Value }); if (model.CategoryIDList.Length > 0) { var paras = model.CategoryIDList .Select(t => new { ArticleID = model.ID.Value, CategoryID = t }).ToArray(); string insertCategorySql = @" INSERT INTO [CategoryArticle] ( ArticleID, CategoryID ) VALUES ( @ArticleID, @CategoryID ); "; conn.Execute(insertCategorySql, paras); } scope.Complete(); this.CategoryService.ClearCache(); return OperationResult.SuccessResult(); } }