62,046
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM SysUser s
join SysDepartment z on s.DepId=z.DepId
where s.DepId in (select DepId from SysDepartment where DepIndex like('1%'))
public List<SysDepartment> GetDepIndex(string depIndexStr)
{
var depIndexs = (
from m in _db.SysDepartment
where m.DepIndex.StartsWith(depIndexStr)
select m
).Distinct().ToList();
return depIndexs;
}