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