<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Fdy.aspx.cs" Inherits="Fdy" EnableViewState="false" %>
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
http://www.w3.org/1999/xhtml" >
无标题页
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class Fdy : System.Web.UI.Page
{
DataBase db = new DataBase();
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ds = db.Query("SELECT [ApplicationID], [A_AppName], [A_AppUrl], [FatherId], [Depth], [A_AppDescription], [Deleted] FROM sys_Applications where deleted=0");
//调用递归函数,完成树形结构的生成
AddTree(0, (TreeNode)null);
}
}
// 递归添加树的节点
public void AddTree(int ParentID, TreeNode pNode)
{
DataView dvTree = new DataView(ds.Tables[0]);
//过滤ParentID,得到当前的所有子节点
dvTree.RowFilter = "[FatherId] = " + ParentID;
foreach (DataRowView Row in dvTree)
{
TreeNode Node = new TreeNode();
Node.Text = Row["A_AppName"].ToString();
if (Row["A_AppUrl"].ToString().Length == 0)
Node.SelectAction = TreeNodeSelectAction.Expand;
Node.NavigateUrl = Row["A_AppUrl"].ToString();
if (pNode == null)
{
TreeView1.Nodes.Add(Node);
}
else
{
pNode.ChildNodes.Add(Node);
}
AddTree(Int32.Parse(Row["ApplicationID"].ToString()), Node);//再次递归
}
}
}