根据分类ID查找子项

根据分类ID查找子项

public static List<Guid> GetProductKindsByID(SEEntities db, Guid ID)
        {
            var query = from c in db.ProductKinds where c.ParentID == ID select c;
            var q = query.Select(r => r.ID).ToList().Concat(query.ToList().SelectMany(t => GetProductKindsByID(db, t.ID)));
            return q.ToList();
        }

//树形分类
                var db = GetSEEntities();
                List<Guid> productKindList = new List<Guid>();
                if (productKindID.HasValue && productKindID!= Guid.Empty)
                {
                    productCategoryList.Add(productCategoryID.Value);
                    productKindList.AddRange(GetProductCategoryByID(db, productKindID.Value));
                }
                if (productKindList.Any())
                {
                    result = result.Where(r => productKindList.Contains(r.ProductKindID)).ToList();
                }