/// <summary>
/// 插入热门评论
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static int RecommendComments_Insert(RecommendCommentInfo obj)
{
using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key))
{
return(access.RecommendComments_Insert(obj));
}
}
public int RecommendComments_Insert(RecommendCommentInfo obj)
{
DbCommand dbCommandWrapper = Db_0.GetStoredProcCommand("Proc_RecommendComments_Insert");
Db_0.AddOutParameter(dbCommandWrapper, "@rcmt_id", DbType.Int32, 4);
Db_0.AddInParameter(dbCommandWrapper, "@rcmt_createUser", DbType.String, obj.rcmt_createUser);
Db_0.AddInParameter(dbCommandWrapper, "@rcmt_createTime", DbType.DateTime, obj.rcmt_createTime);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_id", DbType.Int32, obj.cmt_id);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_uid", DbType.String, obj.cmt_uid);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_sourceType", DbType.String, obj.cmt_sourceType);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_sourceId", DbType.String, obj.cmt_sourceId);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_title", DbType.String, obj.cmt_title);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_content", DbType.String, obj.cmt_content);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_parentIds", DbType.String, obj.cmt_parentIds);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_accept", DbType.Int32, obj.cmt_accept);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_status", DbType.Int32, obj.cmt_status);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_ip", DbType.String, obj.cmt_ip);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_ipArea", DbType.String, obj.cmt_ipArea);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_createUserID", DbType.Int32, obj.cmt_createUserID);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_createUser", DbType.String, obj.cmt_createUser);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_createTime", DbType.DateTime, obj.cmt_createTime);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_checkUser", DbType.String, obj.cmt_checkUser);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_checkTime", DbType.String, obj.cmt_checkTime);
Db_0.AddInParameter(dbCommandWrapper, "@cmt_checkRemark", DbType.String, obj.cmt_checkRemark);
try
{
int _returnValue = Db_0.ExecuteNonQuery(dbCommandWrapper);
int rcmt_id = (int)dbCommandWrapper.Parameters["@rcmt_id"].Value;
return(_returnValue);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// 评论顶操作
/// </summary>
/// <param name="rData"></param>
/// <returns></returns>
public Stream DoAgree(RequestData rData)
{
// 解析得到评论ID
var data = rData.details.Split('|');
string cmt_uid = data[0].ToSafety();
// 得到上下文
WebOperationContext woc = WebOperationContext.Current;
//设置响应格式，消除了返回为string的有反斜杠情况
woc.OutgoingResponse.ContentType = "application/json; charset=utf-8";
string json = "";
if (cmt_uid == string.Empty)
{
json = Util.GetResultStr("“顶”失败：参数错误！");
return(new MemoryStream(Encoding.UTF8.GetBytes(json)));
}
//
int result = DataAccess_News.FavorLog_Insert(cmt_uid);
if (result > 0)
{
int relt = DataAccess_News.Comments_AddAccept(cmt_uid); // 评论记录中评论“支持”字段值增1
if (relt > 0)
{
json = " { \"success\" : true, \"errors\" : { \"text\" : \"“顶”成功！\", \"num\" : 1 } }";
CommentInfo comment = DataAccess_News.Comments_Selectbycmt_uid(cmt_uid);
if ((comment != null) && (comment.cmt_accept > 10)) // 顶超过10设为热评
{
// 判断是否已设为热评
List <CommentInfo> comments = DataAccess_News.RecommendComments_Selectbycmt_uid(cmt_uid);
if ((comments == null) || (comments.Count < 1))
{
// 设为热评
RecommendCommentInfo rcomment = new RecommendCommentInfo();
rcomment.cmt_accept = comment.cmt_accept;
rcomment.cmt_checkRemark = comment.cmt_checkRemark;
rcomment.cmt_checkTime = comment.cmt_checkTime;
rcomment.cmt_checkUser = comment.cmt_checkUser;
rcomment.cmt_content = comment.cmt_content;
rcomment.cmt_createTime = comment.cmt_createTime;
rcomment.cmt_createUser = comment.cmt_createUser;
rcomment.cmt_createUserID = comment.cmt_createUserID;
rcomment.cmt_id = comment.cmt_id;
rcomment.cmt_ip = comment.cmt_ip;
rcomment.cmt_ipArea = comment.cmt_ipArea;
rcomment.cmt_parentIds = comment.cmt_parentIds;
rcomment.cmt_sourceId = comment.cmt_sourceId;
rcomment.cmt_sourceType = comment.cmt_sourceType;
rcomment.cmt_status = comment.cmt_status;
rcomment.cmt_title = comment.cmt_title;
rcomment.cmt_uid = comment.cmt_uid;
rcomment.rcmt_createUser = comment.cmt_createUser;
rcomment.rcmt_createTime = DateTime.Now;
DataAccess_News.RecommendComments_Insert(rcomment);
}
}
return(new MemoryStream(Encoding.UTF8.GetBytes(json)));
}
json = Util.GetResultStr("“顶”失败，请稍候再试");
return(new MemoryStream(Encoding.UTF8.GetBytes(json)));
}
json = " { \"success\" : true, \"errors\" : { \"text\" : \"“顶”已成功！\", \"num\" : 0 } }";
return(new MemoryStream(Encoding.UTF8.GetBytes(json)));
}
