DropDownList中绑定树形结构

数据库表图

要显示的结果图

 

private void InitDepartDropDown()
        {

            CustomerControlInfo info;
            this.Items.Clear();
            this.Items.Add(new ListItem("请选择成员", "0"));
            int OwnerUserId = GetOwnerUserID();
            ArrayList al = CustomerControlController.GetUCPBerInfoDeptName(OwnerUserId);
            if (al.Count > 0)
            {
                for (int i = 0; i < al.Count; i++)
                {
                     info = (CustomerControlInfo)al[i];
                    int UserId = info.UserId;
                    int ParentDept = info.ParentDept;
                    string DeptName = info.DeptName;
                    if (ParentDept>0)
                        {
                            DeptName = "**|-" + DeptName;
                        }
                        else
                        {
                            DeptName = "|--" + DeptName;
                        }
                    this.Items.Add(new ListItem(DeptName, UserId.ToString()));

                }
            }