?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.Text;
using System.IO;
using System.Data.SqlClient;
using MySql.Data.MySqlClient;
public partial class select : System.Web.UI.Page
{
    SqlConnection con;
    SqlDataAdapter da;
    DataTable ds;
    DataTable dt;

    MySqlConnection mysqlcon;
    MySqlCommand mysqlcom;
    MySqlDataAdapter mysqlda;
    DataTable myds;
    DataTable mydt;
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            this.TreeView1.Nodes[0].ChildNodes.Clear();

            dt = new DataTable();
            dt = setmysqldata("select * from collection_type");
            if (dt.Rows.Count == 0)
            {
                this.TreeView1.Nodes[0].Text = "請?zhí)砑庸?jié)點(diǎn)";
            }
            else
            {
                addNode(this.TreeView1, dt);
            }
            this.TreeView1.ExpandAll();
        }
        catch
        { }
    }

    public void addNode(TreeView tv, DataTable dt)
    {
        try
        {
            TreeNode tn = new TreeNode();
            tn.Text = dt.Rows[0][1].ToString();
            tn.Target = dt.Rows[0][0].ToString().Trim();
            foreach (DataRow dr in dt.Rows)
            {
                if ((int)dr[0] == 0)
                {
                    continue;
                }
                aaa(dr, tv.Nodes);
            }
        }
        catch
        { }
    }

    void aaa(DataRow dr, TreeNodeCollection tnc)
    {
        try
        {
            foreach (TreeNode tn in tnc)
            {
                if (tn.Target.ToString() == dr[2].ToString().Trim())
                {
                    TreeNode tn1 = new TreeNode();
                    tn1.Text = dr[1].ToString().Trim();
                    tn1.Target = dr[0].ToString().Trim();
                    tn.ChildNodes.Add(tn1);
                    return;
                }
                aaa(dr, tn.ChildNodes);
            }
        }
        catch
        { }
    }

    public bool opendb()
    {
        try
        {
            con = new SqlConnection("server=192.168.1.18;database=catch;uid=zhaojie;pwd=zhaojie123");
            con.Open();
            return true;
        }
        catch
        {
        }
        return false;
    }

    public bool openmysqldb()  //mysql
    {
        try
        {
            string constring = string.Format("server=192.168.1.18; user id=xudengke; password=xudengke123; database=shichuangshop; pooling=false;charset=gbk;");
            mysqlcon = new MySqlConnection(constring);
            mysqlcon.Open();
            return true;
        }
        catch
        {

        }
        return false;
    }

    public DataTable setmysqldata(string sql) //mysql
    {
        if (openmysqldb())
        {
            mysqlda = new MySqlDataAdapter();
            mysqlda.SelectCommand = new MySqlCommand();
            mysqlda.SelectCommand.Connection = mysqlcon;
            mysqlda.SelectCommand.CommandText = sql;
            myds = new DataTable();
            mysqlda.Fill(myds);
            return myds;
        }
        return null;
    }

    public DataTable Getdata(string sql)
    {
        if (opendb())
        {
            da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand();
            da.SelectCommand.Connection = con;
            da.SelectCommand.CommandText = sql;
            ds = new DataTable();
            da.Fill(ds);
            return ds;
        }
        return null;
    }

    protected void TreeView1_SelectedNodeChanged1(object sender, EventArgs e)
    {
        try
        {
            string val = "分類管理/";
            string test = TreeView1.SelectedNode.ValuePath.Remove(TreeView1.SelectedNode.ValuePath.IndexOf(val), val.Length);
            string end = test.Replace("/", "-");
            this.Label2.Text = end;
        }
        catch
        { }
    }
}