62,073
社区成员
发帖
与我相关
我的任务
分享
//数据库表结构: id fatherId ...
public string GetAllSon(int iDomainId)
{
string ayId = iDomainId + ",";
ayId = GetSonDomainID(ayId, iDomainId);
if (ayId != "")
ayId = ayId.Substring(0, ayId.Length - 1);
return ayId;
}
/// <summary>
///递归生成企业“树枝”
/// </summary>
/// <param name="iDomainID">父级企业ID</param>
/// <returns>子企业ID集合</returns>
public string GetSonDomainID(string ayId, int iDomainID)
{
IList<tbDomain> ilist = dbDomain.GetDomain(iDomainID);
for (int i = 0; i < ilist.Count; i++)
{
string ayDomainID = ilist[i].domainID + ",";
//递归实现无限分级机构
ayDomainID = GetSonDomainID(ayDomainID, ilist[i].domainID);
ayId = ayId + ayDomainID;
}
return ayId;
}