public Result RemoveWork([FromBody] EditWorkStatusReq req)
{
req.Status = (int)WorkStatusTypes.REMOVE;
var result =
SqlHelper.ExecuteNonQuery(SqlHelper.GetConnString(), CommandType.StoredProcedure, StoreProcedureConst
.EditWorkStatus,
EntitySqlHelper.GetParameters(req));
if (result > 0)
{
//p:发送被删除通知
return(EditStatusByRelation(new AccusationEditStatusByRelationParam()
{
RelationId = req.Id,
Status = 2,
TargetType = AccusationTargetTypes.Work
}));
}
else
{
return(new Failure(ResultMsgConst.OperationFailure));
}
}
public Result WorkAccept([FromBody] AcceptReq req)
{
if (req == null)
{
return(new Failure("para is null"));
}
var msg = req.ValidInfo();
if (msg != string.Empty)
{
return(new Failure(msg));
}
var result = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnString(), CommandType.StoredProcedure,
"accusation_edit_item_status",
new SqlParameter("@id", req.Id),
new SqlParameter("@status", 2),
new SqlParameter("@userId", req.UserId));
if (result > 0)
{
//p:发送举报成功通知
var param = new EditWorkStatusReq()
{
Id = req.RelationId,
Status = (int)WorkStatusTypes.REMOVE,
UserId = req.RelationUserId
};
result =
SqlHelper.ExecuteNonQuery(SqlHelper.GetConnString(), CommandType.StoredProcedure, StoreProcedureConst
.EditWorkStatus,
EntitySqlHelper.GetParameters(param));
if (result > 0)
{
//p:发送被删除通知
return(new Success(ResultMsgConst.OperationSuccess));
}
else
{
return(new Failure(ResultMsgConst.OperationFailure));
}
}
else
{
return(new Failure(ResultMsgConst.OperationFailure));
}
}
public Result CommentAccept([FromBody] AcceptReq req)
{
if (req == null)
{
return(new Failure("para is null"));
}
var msg = req.ValidInfo();
if (msg != string.Empty)
{
return(new Failure(msg));
}
var result = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnString(), CommandType.StoredProcedure,
"accusation_edit_item_status",
new SqlParameter("@id", req.Id),
new SqlParameter("@status", 2),
new SqlParameter("@userId", req.UserId));
if (result > 0)
{
var param = new EditStatusReq()
{
Id = req.RelationId,
Status = (int)CommentStatusTypes.UNUSEFUL
};
//p:发送举报成功通知
var executeNonQuery = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnString(), CommandType.StoredProcedure,
StoreProcedureConst.EditCommentStatus,
EntitySqlHelper.GetParameters(param));
if (executeNonQuery > 0)
{
//发送通知
//var msg = $"尊敬的用户,您的评论xxx,由于存在...,已被删除.";
return(new Success(ResultMsgConst.OperationSuccess));
}
else
{
return(new Failure(ResultMsgConst.OperationFailure));
}
}
else
{
return(new Failure(ResultMsgConst.OperationFailure));
}
}
public Result EditStatusByRelation(AccusationEditStatusByRelationParam param)
{
var result = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnString(), CommandType.StoredProcedure,
"accusation_edit_item_status_by_relation",
EntitySqlHelper.GetParameters(param));
if (result > 0)
{
return(new Success(ResultMsgConst.OperationSuccess));
}
else
{
return(new Failure(ResultMsgConst.OperationFailure));
}
}
public Result RemoveComment([FromBody] EditStatusReq req)
{
req.Status = (int)CommentStatusTypes.UNUSEFUL;
var executeNonQuery = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnString(), CommandType.StoredProcedure,
StoreProcedureConst.EditCommentStatus,
EntitySqlHelper.GetParameters(req));
if (executeNonQuery > 0)
{
//发送通知
//var msg = $"尊敬的用户,您的评论xxx,由于存在...,已被删除.";
return(EditStatusByRelation(new AccusationEditStatusByRelationParam()
{
RelationId = req.Id,
Status = 2,
TargetType = AccusationTargetTypes.Comment
}));
}
else
{
return(new Failure(ResultMsgConst.OperationFailure));
}
}