departmentnode.cs

蓝山人事管理系统

using System;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using System.Data.SqlClient;

namespace BlueHill.BlueHillWindows.DepartmentManagement
{
	/// <summary>
	/// DepartmentNode 的摘要说明。
	/// </summary>
	public class DepartmentNode
	{
		public DepartmentNode()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public SqlConnection conn=null; 
		public SqlDataAdapter adp=null;
		public DataSet ds=null;

		public SqlConnection conn1=null; 
		public SqlDataAdapter adp1=null;
		public DataSet ds1=null;
		//        TreeView treeView1=null;
		public void displaydept(TreeView treeView1)
		{
			conn = new SqlConnection("integrated security=SSPI;data source=(local);initial catalog=BlueHill");
			adp = new SqlDataAdapter("select * from tblDepartment",conn);
			ds=new DataSet();
			adp.Fill(ds,"tblDepartment");

			conn1=new SqlConnection("integrated security=SSPI;data source=(local);initial catalog=BlueHill");
			adp1=new SqlDataAdapter("select * from tblEmployee",conn1);
			ds1=new DataSet();
			adp1.Fill(ds1,"tblEmployee");

			int k=ds.Tables[0].Rows.Count;
			int i=0;
			int j=ds1.Tables[0].Rows.Count;
			int n=0;
			//treeView1=new TreeView();
			for(i=0;i<k;i++)
			{
				treeView1.Nodes.Add(ds.Tables[0].Rows[i] ["deptname"].ToString());
				for(n=0;n<j;n++)
					if(ds.Tables[0].Rows[i] ["deptID"].ToString()==ds1.Tables[0].Rows[n] ["deptID"].ToString())
					{
						treeView1.Nodes[i].Nodes.Add(ds1.Tables[0].Rows[n] ["Name"].ToString());
					}
				
			}
			//return treeView1;
		}
	}
}