public IActionResult ChangeStatus(ChangeStatusRequest model)
{
if (model == null)
{
return this.BadRequest();
}
var result = this.CommentService.ChangeStatus(model);
return this.ApiResponse(result);
}
public OperationResult ChangeStatus(ChangeStatusRequest model)
{
using (var conn = this.OpenConnection())
{
string sql = @"
UPDATE [Comment] SET [Status]=@Status
WHERE ID IN @IDs;
SELECT DISTINCT ArticleID FROM [Comment] WITH(NOLOCK)
WHERE ID IN @IDs;
";
var para = new
{
Status = model.Status,
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();
}
}