DropDownList 递归绑定

要实现下面的效果:

首先可实现DropDownList:

     public void SetDDL(ref  System.Web.UI.WebControls.DropDownList ddl, string value)
        {
            if (ddl != null)
            {
                if (ddl.Items.FindByValue(value) != null)
                {
                    ddl.SelectedIndex = -1;
                    ddl.Items.FindByValue(value).Selected = true;
                }

            }
        }

 

具体实现的方法:

        public void BindAccountTree(ref  System.Web.UI.WebControls.DropDownList ddl, bool withEmptyItem)
        {
            int AccountID= -1;

            ddl.Items.Clear();
            Account rootAccount = AccountLogic.GetInstance().GetAccount(AccountID);
            ddl.Items.Add(new ListItem(rootAccount.Name, rootAccount.AccountID.ToString()));

            AddChild(rootAccount.AccountID, ddl, 0);

            if (withEmptyItem)
            {
                ListItem item = new ListItem("请选择...", "");
                ddl.Items.Insert(0, item);
            }
        }

 

GetAccount 方法:

 public Account GetAccount(int AccountID) //Get one Account
        {

            string sqlCommand = "SELECT * FROM Account WHERE AccountID=" + AccountID;

        }

AddChild方法:

 private void AddChild(int ParentID, DropDownList ddl, int Level)
        {
            string strSpace = "　　　　　　　　　　　　　　　　　　　　";
            IList list = AccountLogic.GetInstance().FetchSubAccounts(ParentID, "Name");
            string strA = strSpace.Substring(0, Level + 1) + "|-";

            Account account = null;

            for (int i = 0; i < list.Count; i++)
            {
                account = (Account)list[i];

                ddl.Items.Add(new ListItem(strA + account.Name, account.AccountID.ToString()));

                if (Level > 20)
                    break;
                AddChild(account.AccountID, ddl, Level + 1);
            }
        }

FetchSubAccounts方法:

       public IList FetchSubAccounts(int AccountID, string Order)
        {
            IList Accounts = new ArrayList();
            Database db = DatabaseFactory.CreateDatabase();
            string sqlCommand = "SELECT * FROM Account ";

            sqlCommand += (sqlCommand.IndexOf("WHERE") > 0 ? " AND" : " WHERE") + " (Deleted = 0)";

            sqlCommand += " AND (ParentID=" + AccountID + ")";

            if (Order.Trim().Length > 0)
            {
                sqlCommand += " ORDER BY " + Order;//Title DESC, Href
            }
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
            try
            {
                using (IDataReader dr = db.ExecuteReader(dbCommand))
                {
                    while (dr.Read())
                    {
                        Accounts.Add(GetAccount(dr));
                    }
                }
            }
            catch (Exception ex)
            {
                Logging.WriteLog(ex);
            }
            return Accounts;
        }

页面调用方法:

 private void BindParentAccount()
        {
            this.BindAccountTree(ref this.ddlAccount, true);
        }

数据库表结构: