public IActionResult Delete(DeleteCommentRequest model) { if (model == null) { return this.BadRequest(); } var result = this.CommentService.Delete(model); return this.ApiResponse(result); }
public OperationResult Delete(DeleteCommentRequest model) { using (var conn = this.OpenConnection()) { string sql = @" SELECT DISTINCT ArticleID FROM [Comment] WITH(NOLOCK) WHERE ID IN @IDs; UPDATE [Comment] SET ReplyTo=NULL WHERE ReplyTo IN @IDs; DELETE FROM [Comment] WHERE ID IN @IDs; "; var para = new { IDs = model.CommentIDList }; var articleIDList = conn.Query<int>(sql, para).ToList(); if (articleIDList.Count == 0) { return OperationResult.ErrorResult("不存在的评论"); } foreach (var articleID in articleIDList) { string cacheKey = Helpers.CacheKeyHelper.GetArticleCommentsCacheKey(articleID); this.Cache.Remove(cacheKey); } return OperationResult.SuccessResult(); } }