private AddressGroupNodeInfo GetNode(string id, DataTable dt)
{
AddressGroupInfo info = this.FindByID(id);
AddressGroupNodeInfo nodeInfo = new AddressGroupNodeInfo(info);
DataRow[] dChildRows = dt.Select(string.Format(" PID='{0}'", id));
for (int i = 0; i < dChildRows.Length; i++)
{
string childId = dChildRows[i]["ID"].ToString();
AddressGroupNodeInfo childNodeInfo = GetNode(childId, dt);
nodeInfo.Children.Add(childNodeInfo);
}
return(nodeInfo);
}
/// <summary>
/// 根据用户，获取树形结构的分组列表
/// </summary>
public List <AddressGroupNodeInfo> GetTree(string addressType, string creator = null)
{
string condition = !string.IsNullOrEmpty(creator) ? string.Format("AND Creator='{0}'", creator) : "";
List <AddressGroupNodeInfo> nodeList = new List <AddressGroupNodeInfo>();
string sql = string.Format("Select * From {0} Where AddressType ='{1}' {2} Order By PID, SEQ ", tableName, addressType, condition);
DataTable dt = base.SqlTable(sql);
DataRow[] dataRows = dt.Select(string.Format(" PID = '{0}' ", -1));
for (int i = 0; i < dataRows.Length; i++)
{
string id = dataRows[i]["ID"].ToString();
AddressGroupNodeInfo nodeInfo = GetNode(id, dt);
nodeList.Add(nodeInfo);
}
return(nodeList);
}
