/// <summary>
/// 根据用户，获取树形结构的分组列表
/// </summary>
public List <ContactGroupNodeInfo> GetTree(string creator)
{
string condition = !string.IsNullOrEmpty(creator) ? string.Format("AND Creator='{0}'", creator) : "";
List <ContactGroupNodeInfo> nodeList = new List <ContactGroupNodeInfo>();
string sql = string.Format("Select * From {0} Where 1=1 {1} Order By PID, HandNo ", tableName, 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();
ContactGroupNodeInfo nodeInfo = GetNode(id, dt);
nodeList.Add(nodeInfo);
}
return(nodeList);
}