/// <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))); }