private CustomerGroupNodeInfo GetNode(string id, DataTable dt) { CustomerGroupInfo info = this.FindByID(id); CustomerGroupNodeInfo nodeInfo = new CustomerGroupNodeInfo(info); DataRow[] dChildRows = dt.Select(string.Format(" PID='{0}'", id)); for (int i = 0; i < dChildRows.Length; i++) { string childId = dChildRows[i]["ID"].ToString(); CustomerGroupNodeInfo childNodeInfo = GetNode(childId, dt); nodeInfo.Children.Add(childNodeInfo); } return(nodeInfo); }
/// <summary> /// 根据用户,获取树形结构的客户分组列表 /// </summary> public List <CustomerGroupNodeInfo> GetTree(string creator, string condition) { string where = !string.IsNullOrEmpty(creator) ? string.Format("AND Creator='{0}'", creator) : ""; if (!string.IsNullOrEmpty(condition)) { where += " AND " + condition; } List <CustomerGroupNodeInfo> nodeList = new List <CustomerGroupNodeInfo>(); string sql = string.Format("Select * From {0} Where 1=1 {1} Order By PID, HandNo ", tableName, where); 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(); CustomerGroupNodeInfo nodeInfo = GetNode(id, dt); nodeList.Add(nodeInfo); } return(nodeList); }