employeenode.cs

蓝山人事管理系统

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


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

		public SqlCommand com=null;
		public void createdept()
		{
			conn=new SqlConnection("Initial Catalog=bluehill;Data Source=localhost;User ID=Sa;Password=sql2000");
			conn.Open();
			com=new SqlCommand("insert into tblDepartment values(@deptID,@deptname,@deptdescription,@managerID)",conn);
			com.Parameters.Add("@deptname",SqlDbType.NChar,10);
			com.Parameters.Add("@deptID",SqlDbType.Int,4);
			com.Parameters.Add("@deptdescription",SqlDbType.NVarChar,50);
			com.Parameters.Add("@managerID",SqlDbType.Int,4);
		}
        
	}
}