choosedepart.aspx.cs

商机管理系统

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 depart_users_choosedepart : 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.NavigateUrl = "javascript:var a='"+drv["name"].ToString()+"';window.returnValue=a;window.close();";
            //tmpNd.NavigateUrl = "javascript:window.close();";
            Nds.Add(tmpNd);
            initTree(tmpNd.ChildNodes, strId);//or   intiTree(Nds[Nds.Count-1].Nodes,intId);   
        }
    }
}