递归输出系统菜单到DropDownList

  public class SysMenuManage
    {
        /// <summary>
        /// 通过父节点id得到系统菜单
        /// </summary>
        public DataTable GetSysMenuByParentId(int parentId)
        {
            string sql = "select * from y_sysMenu where m_parentId=@m_parentId";
            return SQLLinkDatabase.Query(sql, new SqlParameter("@m_parentId", parentId)).Tables[0];
        }

        /// <summary>
        /// 绑定菜单
        /// </summary>
        public void BindSysMenu(int parentId,DropDownList ddlList)
        {
            DataTable dt=GetSysMenuByParentId(parentId);
            foreach (DataRow dr in dt.Rows)
            {
                ListItem li = new ListItem();
                li.Text="╋"+dr["M_Name"].ToString();
                li.Value = dr["M_UID"].ToString();
                ddlList.Items.Add(li);
                BindSysMenuChild(Judge.get_Int(dr["M_UID"].ToString()), ddlList, "├—");
            }
        }

        /// <summary>
        /// 绑定子菜单
        /// </summary>
        public void BindSysMenuChild(int parentId,DropDownList ddlList,String separtor)
        {
            DataTable dt = GetSysMenuByParentId(parentId);
            foreach (DataRow dr in dt.Rows)
            {
                ListItem li = new ListItem();
                li.Text = separtor+dr["M_Name"].ToString();
                li.Value = dr["M_UID"].ToString();
                string separtor_= separtor+"——";
                ddlList.Items.Add(li);
                BindSysMenuChild(Judge.get_Int(dr["M_UID"].ToString()), ddlList, separtor_);
               
            } 
        }
    }