aa.aspx.cs

来自「商机管理系统」· CS 代码 · 共 100 行

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;
using System.Data.SqlClient;


public partial class role_aa : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BuilderTree("00000", (TreeNode)null);
            TreeView1.Attributes.Add("onclick", "CheckEvent()");

        }
    }
    private void BuilderTree(string ParentID, TreeNode pNode)
    {
        string strConn, strSql;
        strConn = MyCommon.getConnectstr();
        SqlConnection myConn = new SqlConnection(strConn);
        SqlDataAdapter myDataAdpter = new SqlDataAdapter();
        SqlCommand myCmd = new SqlCommand("select * from T_MODULE_SYS");
        myCmd.Connection = myConn;
        myDataAdpter.SelectCommand = myCmd;
        myConn.Open();
       


       //System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(strSql,strConn);
        DataSet ds = new DataSet();
        myDataAdpter.Fill(ds, "T_MODULE_SYS");
        myConn.Close();

        //XBGQWZ.BusinessLayer.T_Modle bus_model = new XBGQWZ.BusinessLayer.T_Modle();
        //DataSet ds = bus_model.GetList("");
        DataView dvTree = new DataView(ds.Tables[0]);
        //过滤ParentID,得到当前的所有子节点
        dvTree.RowFilter = "[MOD_PARENT_ID] = " + ParentID;
        foreach (DataRowView row in dvTree)
       {
            TreeNode Node = new TreeNode();
            if (pNode == null)
            {
                //添加根节点
                Node.Text = row["MOD_DESC"].ToString();
                Node.ToolTip = row["MOD_ID"].ToString();
                TreeView1.Nodes.Add(Node);
                Node.Expanded = true;
                BuilderTree(row["MOD_ID"].ToString(), Node);//递归
            }
            else
            {
                //添加当前节点的自节点
                Node.Text = row["MOD_DESC"].ToString();
                Node.ToolTip = row["MOD_ID"].ToString();
                pNode.ChildNodes.Add(Node);
                //pNode.Target = row["MOD_DESC"].ToString();
                Node.Target = "page_right";
                Node.NavigateUrl = "http://www.baidu.com/";
                Node.Expanded = true;
                BuilderTree(row["MOD_ID"].ToString(), Node);//递归

            }
        }

    }
    //遍历树
    private void GetAllNodeText(TreeNodeCollection tnc)
    {
        foreach (TreeNode node in tnc)
        {
            if (node.ChildNodes.Count != 0)

                GetAllNodeText(node.ChildNodes);
            if (node.Checked == true)
            {
                Response.Write(node.Text + " ");
                Response.Write(node.ToolTip + " ");
                Response.Write("<br/>");
            }
        }
    }
    //在button的click事件中将其输出
    protected void Button1_Click(object sender, EventArgs e)
    {
        GetAllNodeText(this.TreeView1.Nodes);
    }


}