public JsonResult DelPeraonalComment(Blog_Comment bc) { MonkeyDBEntities db = new MonkeyDBEntities(); //查询该篇文章的所有评论 List <Blog_Comment> querybc = db.Blog_Comment.AsNoTracking().Where(a => a.BC_ArticleID == bc.BC_ArticleID).ToList(); del(db, querybc, bc); //操作数据库 int count = db.SaveChanges(); return(Json(count, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 向数据库添加留言 /// </summary> /// <param name="content">内容</param> /// <returns></returns> public ActionResult AddComment(string content) { try { Blog_Comment cont = new Blog_Comment(); cont.Contents = content; cont.Praise = 0; CommentRepository.Insert(cont); return(DataProcess.Success().ToMvcJson()); } catch (Exception ex) { return(DataProcess.Failure("内部问题").ToMvcJson()); } }
/// <summary> /// 删除评论的递归算法 /// </summary> /// <param name="db">数据库上下对象</param> /// <param name="querybc">该条评论所属文章的所有评论</param> /// <param name="bc">该条评论的信息</param> public void del(MonkeyDBEntities db, List <Blog_Comment> querybc, Blog_Comment bc) { //查询该条评论的二级评论 List <Blog_Comment> bclist1 = querybc.Where(a => a.BC_Comment_ParentId == bc.BC_CommentId).ToList(); //设置实体状态 db.Entry(bc).State = System.Data.EntityState.Deleted; //判断该条评论的二级评论条数是否大于等于1 if (bclist1.Count() >= 1) { //遍历该评论的二级评论的集合 foreach (var item in bclist1) { //递归调用 del(db, querybc, item); } } }