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); }