/// <summary>
/// 添加回复
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public OperationResult <AddReplyCommonEntity> ArticleReply_Insert(EventItemReplyEntity entity)
{
try
{
AddReplyCommonEntity acEntity = new AddReplyCommonEntity();
ReplyCommonEntity rcEntity = new ReplyCommonEntity();
using (SqlConnection con = new SqlConnection(SQlHelper.MyConnectStr))
{
SqlTransaction trans = null;
con.Open();
trans = con.BeginTransaction();
DateTime? nowDate = entity.ReplyTime == null ? DateTime.Now : entity.ReplyTime;
SqlParameter[] prms =
{
new SqlParameter("@ReplyID", entity.ReplyID),
new SqlParameter("@CommentID", entity.CommentID),
new SqlParameter("@UserID", entity.UserID),
new SqlParameter("@IsAnonymous", entity.IsAnonymous),
new SqlParameter("@ReplyParentID", entity.ReplyParentID),
new SqlParameter("@ReplyContent", entity.ReplyContent),
new SqlParameter("@ReplyTime", nowDate),
new SqlParameter("@CheckTypeID", entity.CheckTypeID),
new SqlParameter("@ViewStateID", entity.ViewStateID)
};
SqlParameter[] commPrms =
{
new SqlParameter("@CommentID", entity.CommentID),
new SqlParameter("@UserID", entity.UserID),
};
prms[0].Direction = ParameterDirection.Output;
int state = SQlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "M_EventItemReply_Insert", prms);
trans.Commit();
DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "M_ReplyCommon_Get", commPrms).Tables[0];
if (table != null && table.Rows.Count != 0)
{
rcEntity = ConvertDataTable <ReplyCommonEntity> .ConvertToList(table)[0];
}
acEntity.ReplyID = prms[0].Value.ToInt();
acEntity.ReplyTime = nowDate;
acEntity.ReviewLikeCount = rcEntity.ReviewLikeCount;
acEntity.IsReviewLike = rcEntity.IsReviewLike;
acEntity.ReplyCount = rcEntity.ReplyCount;
if (state > 0)
{
return(new OperationResult <AddReplyCommonEntity>(OperationResultType.Success, "回复完成！", acEntity));
}
else
{
return(new OperationResult <AddReplyCommonEntity>(OperationResultType.NoChanged, "评论已被删除,无法回复！", acEntity));
}
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(new OperationResult <AddReplyCommonEntity>(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection)));
}
}
/// <summary>
/// 评论点赞插入
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public OperationResult <ReplyCommonEntity> CommentsLike_Insert(CommentLikeEntity entity)
{
try
{
ReplyCommonEntity rcEntity = new ReplyCommonEntity();
using (SqlConnection con = new SqlConnection(SQlHelper.MyConnectStr))
{
SqlTransaction trans = null;
con.Open();
trans = con.BeginTransaction();
SqlParameter[] prms =
{
new SqlParameter("@CommentID", entity.CommentID),
new SqlParameter("@UserID", entity.UserID),
new SqlParameter("@LikeCnt", entity.LikeCnt),
new SqlParameter("@LikeTime", entity.LikeTime == null ? DateTime.Now :entity.LikeTime)
};
SqlParameter[] commPrms =
{
new SqlParameter("@CommentID", entity.CommentID),
new SqlParameter("@UserID", entity.UserID)
};
int state = SQlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "M_Comments_Like_Insert", prms);
trans.Commit();
DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "M_ReplyCommon_Get", commPrms).Tables[0];
if (table != null && table.Rows.Count != 0)
{
rcEntity = ConvertDataTable <ReplyCommonEntity> .ConvertToList(table)[0];
}
if (state > 0)
{
return(new OperationResult <ReplyCommonEntity>(OperationResultType.Success, "评论点赞成功！", rcEntity));
}
else
{
return(new OperationResult <ReplyCommonEntity>(OperationResultType.NoChanged, "您已点过赞了！", rcEntity));
}
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(new OperationResult <ReplyCommonEntity>(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection)));
}
}