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

namespace BlueHill.BlueHillWindows.DepartmentManagement
{
	/// <summary>
	/// DepartDetail 的摘要說明。
	/// </summary>
	public class DepartDetail
	{
		public DepartDetail()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		public SqlConnection conn=null; 
		public SqlDataAdapter adp=null;
		public DataSet ds=null;
		public string deptname;
		//public SqlCommand com=null;
		public DataSet displayemployee()
		{
			conn=new SqlConnection("integrated security=SSPI;data source=(local);initial catalog=BlueHill");
			adp=new SqlDataAdapter("select * from tblEmployee where DeptID = (select DeptID from tblDepartment where DeptName ='" + deptname +"')",conn);
			ds=new DataSet();
			adp.Fill(ds,"tblEmployee");
			return ds;
		}
	}
}