/// <summary> /// 删除帖子 /// </summary> /// <param name="id"></param> /// <returns></returns> public Response DeletePost(int id) { if (id == 0) { throw new ArgumentNullException(nameof(id)); } var response = new Response(); using (var tran = DbBase.GetTransaction()) { //删除帖子 var r1 = DbBase.Delete <Posts>(id); //删除评论 var r2 = DbBase.DeleteMany <Comment>().Where(p => p.PostId == id).Execute(); tran.Complete(); if (IsUpdateSuccess(r1)) { response.IsSuccess = true; response.Message = "操作成功"; return(response); } } response.Message = "操作失败"; return(response); }
/// <summary> /// 根据用户ID删除消息 /// </summary> /// <param name="userId"></param> /// <returns></returns> public Response DeleteAllMessages(int userId) { var response = new Response(); var result = DbBase.DeleteMany <Message>().Where(p => p.ToId == userId).Execute(); if (IsUpdateSuccess(result)) { response.IsSuccess = true; response.Message = "删除成功"; return(response); } response.Message = "删除失败"; return(response); }
/// <summary> /// 删除一条消息 /// </summary> /// <param name="messageId"></param> /// <param name="userId"></param> /// <returns></returns> public Response DeleteOneMessage(int messageId, int userId) { var response = new Response(); //这里传用户ID主要是验证:如果是属性他的消息才可以删除 var result = DbBase.DeleteMany <Message>().Where(p => p.Id == messageId && p.ToId == userId).Execute(); if (IsUpdateSuccess(result)) { response.IsSuccess = true; response.Message = "删除成功"; return(response); } response.Message = "删除失败"; return(response); }
/// <summary> /// 关注或取消 /// </summary> /// <param name="likeuserid"></param> /// <param name="ok"></param> /// <param name="userId"></param> /// <returns></returns> public Response AddOrRemoveLike(int likeuserid, bool ok, int userId) { var response = new Response(); var W_Users = DbBase.SingleOrDefaultById <W_Users>(userId); if (W_Users == null) { response.Message = "非法操作"; return(response); } using (var tran = DbBase.GetTransaction()) { if (!ok) { W_Users.LikeNum--; DbBase.DeleteMany <AsterLikes>().Where(p => p.LikeUserId == likeuserid && p.UserId == userId).Execute(); } else { W_Users.LikeNum++; DbBase.Insert(new AsterLikes { LikeUserId = likeuserid, UserId = userId }); } var result = DbBase.UpdateMany <W_Users>().OnlyFields(p => p.LikeNum).Where(p => p.Id == userId).Execute(W_Users); tran.Complete(); if (IsUpdateSuccess(result)) { response.IsSuccess = true; response.Message = "操作成功"; return(response); } } response.Message = "操作失败"; return(response); }
/// <summary> /// 添加或减少赞 /// </summary> /// <param name="commentId">评论Id</param> /// <param name="ok"></param> /// <param name="userId"></param> /// <returns></returns> public Response AddOrRemoveLike(int commentId, bool ok, int userId) { var response = new Response(); var comment = DbBase.SingleOrDefaultById <Comment>(commentId); if (comment == null) { response.Message = "非法操作"; return(response); } using (var tran = DbBase.GetTransaction()) { if (ok) { comment.IsPraise--; DbBase.DeleteMany <ArticleLikes>().Where(p => p.CommentId == commentId && p.UserId == userId).Execute(); } else { comment.IsPraise++; DbBase.Insert(new ArticleLikes { CommentId = commentId, UserId = userId }); } var result = DbBase.UpdateMany <Comment>().OnlyFields(p => p.IsPraise).Where(p => p.Id == commentId).Execute(comment); tran.Complete(); if (IsUpdateSuccess(result)) { response.IsSuccess = true; response.Message = "操作成功"; return(response); } } response.Message = "操作失败"; return(response); }