var q = from a in db.Job join b in db.Department on a.Dp_ID equals b.ID
where (from c in db.Department where c.Parent_ID == 35 select c.id).Contains(b.Parent_ID) || b.Parent_ID == 35 || b.ID == 35
select new { Job = a, Department = b };
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024