public int dislike(int cmtId)//点灭 { int user_auth = (Convert.ToBoolean(Session["user_auth"])) ? 1 : 0; if (user_auth == 0) { return(-1); } int user_id = Convert.ToInt32(Session["user_id"].ToString()); int ID = cmtId; int exist = db.Database.SqlQuery <int>("select count(*) from COMMENT_FEEDBACK where USER_ID=" + user_id.ToString() + " and COMMENT_ID=" + ID.ToString()).FirstOrDefault(); if (exist > 0)//已经对该评论有点赞或点灭 { return(0); } COMMENT_FEEDBACK temp = new COMMENT_FEEDBACK();//新建点灭记录 temp.USER_ID = user_id; temp.COMMENT_ID = ID; temp.ATTITUDE = "DISLIKE"; temp.TIME = DateTime.Now.ToString(); db.COMMENT_FEEDBACK.Add(temp); COMMENTS comment = db.COMMENTS.Find(ID);//获得该评论 int after = Convert.ToInt32(comment.TOTAL_DISLIKE) + 1; comment.TOTAL_DISLIKE = after.ToString(); comment.TOTAL = comment.TOTAL - 1; db.SaveChanges(); return(0); }
//向数据库中添加用户的评论 public void AddComment(string user_id, string video_id, string comment_content) { COMMENTS cOMMENTS = new COMMENTS(); cOMMENTS.COMMENT_CONTENT = comment_content; cOMMENTS.LIKES_NUM = 0; cOMMENTS.COMMENT_ID = "0"; db.COMMENTS.Add(cOMMENTS); db.SaveChanges(); SEND_COMMENT sEND_COMMENT = new SEND_COMMENT(); sEND_COMMENT.USER_ID = user_id; var commentid = from c in db.COMMENTS orderby c.COMMENT_ID descending select c; sEND_COMMENT.COMMENT_ID = commentid.ToList()[0].COMMENT_ID; db.SEND_COMMENT.Add(sEND_COMMENT); db.SaveChanges(); HAS_COMMENT hAS_COMMENT = new HAS_COMMENT(); hAS_COMMENT.VIDEO_ID = video_id; var commentid2 = from c in db.COMMENTS orderby c.COMMENT_ID descending select c; hAS_COMMENT.COMMENT_ID = commentid2.ToList()[0].COMMENT_ID; hAS_COMMENT.COMMENT_TIME = DateTime.Now; db.HAS_COMMENT.Add(hAS_COMMENT); db.SaveChanges(); }
public void Publishcomt(int musicid, string value) { var id = (int)Session["account"]; var comments = new COMMENTS(); comments.MUSICID = musicid; var maxid = db.Database.SqlQuery <int>("select max(COMMENTNUMBER) from COMMENTS").FirstOrDefault(); maxid++; comments.COMMENTNUMBER = maxid; comments.USERID = id; comments.CONTENT = value; comments.LIKES = 0; db.COMMENTS.Add(comments); db.SaveChanges(); // return View(); }
//Comment book public void SetComment(int bookId, int grade, string content) { COMMENTS temp = new COMMENTS(); int max = db.Database.SqlQuery <int>("select max(ID) from COMMENTS").FirstOrDefault(); max++;//新评论的ID temp.ID = max; temp.USER_ID = user_id; temp.BOOK_ID = bookId; temp.CONTENT = content; temp.TIME = DateTime.Now.ToString("u"); temp.SCORE = grade; temp.TOTAL_LIKE = 0.ToString(); temp.TOTAL_DISLIKE = 0.ToString(); temp.TOTAL_LIKE = "0"; db.COMMENTS.Add(temp); db.SaveChanges(); }