/// <summary> /// 发表对职业路线的评论 /// </summary> /// <param name="userId">用户ID</param> /// <param name="pathId">职业路线ID</param> /// <param name="content">评论内容</param> /// <returns></returns> public RetJsonModel PublishComment(string userId, string pathId, string content, int pathType) { var db = DBContext.GetInstance; try { DateTime now = db.GetDate(); int timestamp = FunctionHelper.GetTimestamp(); RetJsonModel jsonModel = new RetJsonModel(); jsonModel.time = timestamp; db.Ado.BeginTran(); BUS_CAREERPATH_COMMENT commentModel = new BUS_CAREERPATH_COMMENT(); commentModel.ID = Guid.NewGuid().ToString(); commentModel.DATETIME_CREATED = now; commentModel.STATE = "A"; commentModel.TIMESTAMP_INT = timestamp; commentModel.PATH_ID = pathId; commentModel.CONTENT = content; commentModel.FROM_UID = userId; commentModel.PATH_TYPE = pathType; db.Insertable(commentModel).ExecuteCommand(); //保存通知 MessageClass MC = new MessageClass(); MC.SaveMsg(db, userId, pathId, 1, 1, content); db.Ado.CommitTran(); jsonModel.status = 1; jsonModel.msg = "评论成功"; return(jsonModel); } catch (Exception ex) { db.Ado.RollbackTran(); throw ex; } }
/// <summary> /// 发表对评论的回复或用户间的互动 /// </summary> /// <param name="userId">用户ID</param> /// <param name="commentId">评论表ID</param> /// <param name="replyId">评论表ID</param> /// <param name="replyType">评论表类型(COMMENT:评论;REPLY:回复)</param> /// <param name="content">评论内容</param> /// <param name="toUid">被评论人ID</param> /// <returns></returns> public RetJsonModel PublishReply(string userId, string commentId, string replyId, string content, string toUid) { var db = DBContext.GetInstance; try { DateTime now = db.GetDate(); int timestamp = FunctionHelper.GetTimestamp(); RetJsonModel jsonModel = new RetJsonModel(); jsonModel.time = timestamp; db.Ado.BeginTran(); BUS_COMMENT_REPLY replyModel = new BUS_COMMENT_REPLY(); replyModel.ID = Guid.NewGuid().ToString(); replyModel.DATETIME_CREATED = now; replyModel.STATE = "A"; replyModel.TIMESTAMP_INT = timestamp; replyModel.COMMENT_ID = commentId; replyModel.REPLY_ID = replyId; replyModel.CONTENT = content; replyModel.FROM_UID = userId; replyModel.TO_UID = toUid; db.Insertable(replyModel).ExecuteCommand(); //保存通知 MessageClass MC = new MessageClass(); MC.SaveMsg(db, userId, commentId, 2, 4, content); jsonModel.status = 1; jsonModel.msg = "回复成功"; return(jsonModel); } catch (Exception ex) { db.Ado.RollbackTran(); throw ex; } }