C#代碼:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
#region 變數定義區塊
/// <summary>
/// 變數定義
/// </summary>
private DataSet objDS = new DataSet();
#endregion
protected void Page_Load(object sender, EventArgs e)
{
Sql_Helper sqlHelper = new Sql_Helper();
string strSqlCmd = string.Format("select a.ModelID,ModelName from sysModel a inner join sysPermission b on a.ModelID=b.ModelID where RoleID='{0}';select FuncName,FuncURL,FuncModelID from sysFunc", Session["RoleID"]);
objDS = sqlHelper.getDataSet(strSqlCmd);
if (IsPostBack) return;
BindTree();
///初次加载页面时设定菜单为收缩样式
TreeCTS.CollapseAll();
Btn_Expand.Visible = true;
}
#region 绑定根节点
protected void BindTree()
{
foreach (DataRow dr in objDS.Tables[0].Rows)
{
TreeNode node = new TreeNode();
node.Text = dr["ModelName"].ToString();
node.Value = dr["ModelID"].ToString();
BindNode(node);
TreeCTS.Nodes.Add(node);
}
}
#endregion