C sharp动态生成树型结构的Web程序设计(2)

using Microsoft.Web.UI.WebControls;//添加控件的引用
private void GetTreeView()//程序开始

{

　try

　{

string strSql = "SELECT DISTINCT Menu_id，Menu_name from docmodulemanager 
where Menu_level = 1 and sn in
("+All.Substring(0，All.Length-1).ToString()+")";

OracleDataAdapter

objAdapter = new OracleDataAdapter(strSql，objConn);

DataSet ds = new DataSet();

ds.Clear ();

objAdapter.Fill(ds，"temp");

DataTable dt = ds.Tables["temp"];

TreeView1.Nodes.Clear();

//建立根节点，遍历。
foreach(DataRow dr in dt.Rows)

{

　TreeNode Root = new TreeNode();

　Root.Text = dr["Menu_name"].ToString();

　TreeView1.Nodes.Add(Root);//建立根节点

　string str = "SELECT Menu_name，menu_addr，sn from docmodulemanager 
where upper_id = '" + dr["Menu_id"].ToString() + 
"' and sn in ("+menu_sn.Substring(0，menu_sn.Length-1).ToString()+")"
+"order by menu_id，child_id";
　OracleDataAdapter objAdapterNode = new OracleDataAdapter(str，objConn);

　DataSet dsNode = new DataSet();

　dsNode.Clear ();

　objAdapterNode.Fill(dsNode，"tempNode");

　DataTable dtNode = dsNode.Tables["tempNode"];
//建立子节点，遍历。
foreach(DataRow drNode in dtNode.Rows)

{

　TreeNode Node = new TreeNode();

　Node.Text = drNode["Menu_name"].ToString();

　Node.Target = "mainbottom";

　string Path = drNode["menu_addr"].ToString();

　int menusn = Convert.ToInt32(drNode["sn"].ToString());

　Node.NavigateUrl = "Transfer.aspx"+"?menu_addr="+ Path;

　Root.Nodes.Add(Node);//建立子节点

}

　}

}

catch

{

　Response.Write(" alert('您没有可操作的菜单项，请与管理员联系!'); ");

}

finally

{

　if (objConn.State.ToString().Equals ("Open")) objConn.Close();

}

}