moveemployee.cs

蓝山人事管理系统

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

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

		public SqlCommand com=null;

		public SqlConnection conn1=null;
		public SqlCommand com1=null;

		public string deptname;
		public string deptname1;
		public void updateemployee()
		{
			conn=new SqlConnection("integrated security=SSPI;data source=(local);initial catalog=BlueHill");
			conn.Open();
			com=new SqlCommand("update tblEmployee set DeptID =(select DeptID from tblDepartment where DeptName ='" + deptname +"') where DeptID=(select DeptID from tblDepartment where DeptName ='" + deptname1 +"')",conn);
		}

		public void deldept()
		{
			conn1=new SqlConnection("integrated security=SSPI;data source=(local);initial catalog=BlueHill");
			conn1.Open();
			com1=new SqlCommand("delete tblDepartment where DeptName ='" + deptname1 +"'",conn1);
		}
	}
}