departtree.aspx.cs

商机管理系统


using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;
using System.Configuration;  

public partial class showusers1 : System.Web.UI.Page
{
    DataSet_sjglxt dbtable = new DataSet_sjglxt();
    DataSet_sjglxtTableAdapters.departTableAdapter depart_Control = new DataSet_sjglxtTableAdapters.departTableAdapter();

    DataSet ds1 = new DataSet();
    string pid;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["pid"] != null)
            {
                pid = Request.QueryString["pid"];
            }
            CreateDataSet();
            initTree((TreeView1.Nodes), "0");
        }
    }

    private void CreateDataSet()
    {
        ds1.Clear();
        ds1.Dispose();
        string connectstr = MyCommon.getConnectstr();
        SqlConnection myConn = new SqlConnection(connectstr);
        SqlCommand myCmd=new SqlCommand("select departid,parentid,name from depart");
        SqlDataAdapter myDataAdpter = new SqlDataAdapter();
        myCmd.Connection = myConn;
        myDataAdpter.SelectCommand = myCmd;
        myConn.Open();
        myDataAdpter.Fill(ds1,"depart1");
        myConn.Close();
    }

    private void initTree(TreeNodeCollection Nds,string parentid)
    {
        //DataSet ds = new DataSet();
         DataView   dv=   new   DataView();   
         //    drv;   
        TreeNode   tmpNd;
        string strId;

        dv.Table = ds1.Tables["depart1"];
        //dv.Table = DataTable.GetDataTableSchema(dbtable);
        dv.RowFilter = "parentid=" + parentid + "";

        foreach (DataRowView drv in dv)
        {
            tmpNd = new TreeNode();
            strId = drv["departid"].ToString();
            tmpNd.Value = strId;
            tmpNd.Text = drv["name"].ToString();
            tmpNd.Target = "right";
            switch(pid)
            {
                case "1":
                    tmpNd.NavigateUrl = "showusers.aspx?did=" + drv["departid"].ToString();
                    break;
                case "2":
                    tmpNd.NavigateUrl = "departform.aspx?did=" + drv["departid"].ToString();
                    break;
                case "3":
                    tmpNd.NavigateUrl = "usersform.aspx?did=" + drv["departid"].ToString();
                    break;
                case "4":
                    tmpNd.NavigateUrl = "singleuserchoose.aspx?did=" + drv["departid"].ToString();
                    break;
            }
            Nds.Add(tmpNd);
            initTree(tmpNd.ChildNodes, strId);//or   intiTree(Nds[Nds.Count-1].Nodes,intId);   
        }
    }
}