public int DeleteArticleCategoryById(int id) { // 删除栏目的同时 删除栏目下属的文章 IArticleCategoryService articleCategoryService = new ArticleCategoryService(); var articleCategory = articleCategoryService.GetArticleCategoryById(id); if (articleCategory != null) { IArticleService articleService = new ArticleService(); //WHERE Lft BETWEEN @MyLeft AND @MyRight; var all = articleCategoryService.GetAllArticleCategory().Where(s => s.Lft >= articleCategory.Lft && s.Lft <= articleCategory.Rgt); foreach (ArticleCategoryInfo articleCategoryInfo in all) { articleService.DeleteByCategoryId(articleCategory.Id); } } return(articleCategoryService.Delete(id)); }