private void btnNewAdd_Click(object sender, EventArgs e)
{
Employee_info emp = new Employee_info();
emp.EmployeeName = txtName.Text.Trim();
emp.TelephoneNo = txtTelpone.Text.Trim();
emp.Email = txtEmail.Text.Trim();
emp.EducationId = Convert.ToInt32((cmbEducation.SelectedValue));
//emp.EmployeeId = int.Parse(txtID.Text.Trim());
emp.SalLevelId = cmbPay.Text.Trim() == ""? 0: int.Parse(cmbPay.Text.Trim());
emp.DeptId = Convert.ToInt32(cmbDep.SelectedValue);
emp.PositionId = Convert.ToInt32(cmbZwei.SelectedValue);
if (rdbMan.Checked)
{
emp.Gender = true;
}
else
{
emp.Gender = false;
}
emp.HireDate = dateTimePicker1.Value;
emp.Desc = txtInformation.Text;
AddEmployee emp1 = new AddEmployee();
emp1.AddEmloy(emp);
MessageBox.Show("数据插入成功");
}
public List <Employee_info> GetEmployee(string name, int depid, int locid)
{
List <Employee_info> emps = new List <Employee_info>();
try
{//打开连接
DBHelper.conn.Open();
//创建命令对象
SqlCommand com = new SqlCommand();
com.Connection = DBHelper.conn;
//命令类型为储存过程
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "usp_emp";
//向储存过程传参数
SqlParameter paraUser = com.Parameters.Add("empName", SqlDbType.NVarChar, 20);
paraUser.Direction = ParameterDirection.Input;
paraUser.Value = name;
SqlParameter paraPassword = com.Parameters.Add("dept", SqlDbType.NVarChar, 20);
paraPassword.Direction = ParameterDirection.Input;
paraPassword.Value = depid;
SqlParameter ret = com.Parameters.Add("loc", SqlDbType.Int);
ret.Direction = ParameterDirection.Input;
ret.Value = locid;
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
Employee_info emp = new Employee_info();
emp.EmployeeId = int.Parse(dr["EmployeeId"].ToString());
emp.EmployeeName = dr["EmployeeName"].ToString();
emp.Gender = bool.Parse((dr["Gender"].ToString()));
emp.HireDate = Convert.ToDateTime(dr["HireDate"].ToString());
emp.PositionId = int.Parse(dr["PositionId"].ToString());
emp.SalLevelId = int.Parse(dr["SalLevelId"].ToString());
emp.TelephoneNo = dr["TelephoneNo"].ToString();
emp.Email = dr["Email"].ToString();
emp.DeptId = int.Parse(dr["DeptId"].ToString());
emp.EducationId = int.Parse(dr["EducationId"].ToString());
emp.Desc = dr["Desc"].ToString();
emps.Add(emp);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DBHelper.conn.Close();
}
return(emps);
}
//岗位
//public DataSet ReJob()
//{
// //SqlCommand com = new SqlCommand(connection);
// //com.CommandType = CommandType.StoredProcedure;
// //com.CommandText = "selectdept";
// string sqlcom = "Select DeptName from dbo.Dept_info";
// SqlDataAdapter da = new SqlDataAdapter(sqlcom, DBHelper.conn);
// DataSet ds = new DataSet();
// da.Fill(ds, "data");
// return ds;
//}
#endregion
public List <Employee_info> Rename(int index)
{
#region MyRegion
DBHelper.conn.Open();
List <Employee_info> emps = new List <Employee_info>();
SqlCommand com = new SqlCommand();
com.Connection = DBHelper.conn;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "us_selectworker";
SqlParameter depname = com.Parameters.Add("dep", SqlDbType.Int);
depname.Direction = ParameterDirection.Input;
depname.Value = index;
SqlDataReader dr = com.ExecuteReader();
//SqlDataAdapter da = new SqlDataAdapter();
//DataSet ds = new DataSet();
while (dr.Read())
{
Employee_info emp = new Employee_info();
emp.EmployeeId = int.Parse(dr["EmployeeId"].ToString());
emp.EmployeeName = dr["EmployeeName"].ToString();
//emp.Gender = bool.Parse((dr["Gender"].ToString()));
//emp.HireDate = Convert.ToDateTime(dr["HireDate"].ToString());
//emp.PositionId = int.Parse(dr["PositionId"].ToString());
//emp.SalLevelId = int.Parse(dr["SalLevelId"].ToString());
//emp.TelephoneNo = dr["TelephoneNo"].ToString();
//emp.Email = dr["Email"].ToString();
//emp.DeptId = int.Parse(dr["DeptId"].ToString());
//emp.EducationId = int.Parse(dr["EducationId"].ToString());
//emp.Desc = dr["Desc"].ToString();
emps.Add(emp);
}
dr.Close();
DBHelper.conn.Close();
return(emps);
#endregion
//string sql = "select EmployeeName from dbo.Employee_info where DeptId=" + index;
//SqlDataAdapter da = new SqlDataAdapter(sql,DBHelper.conn);
//DataSet ds = new DataSet();
//da.Fill(ds,"name");
//return ds;
}
/// <summary>
/// 查询员工信息
/// </summary>
/// <returns></returns>
public List <Employee_info> GetEployeeinfo()
{
List <Employee_info> list = new List <Employee_info>();
StringBuilder SQL = new StringBuilder();
SQL.Append(@"select *from dbo.Employee_info ");
DBHelper.conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = DBHelper.conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = SQL.ToString();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Employee_info emp = new Employee_info();
emp.EmployeeId = int.Parse(dr["EmployeeId"].ToString());
emp.EmployeeName = dr["EmployeeName"].ToString();
emp.Gender = bool.Parse((dr["Gender"].ToString()));
emp.HireDate = Convert.ToDateTime(dr["HireDate"].ToString());
emp.PositionId = int.Parse(dr["PositionId"].ToString());
emp.SalLevelId = int.Parse(dr["SalLevelId"].ToString());
emp.TelephoneNo = dr["TelephoneNo"].ToString();
emp.Email = dr["Email"].ToString();
emp.DeptId = int.Parse(dr["DeptId"].ToString());
emp.EducationId = int.Parse(dr["EducationId"].ToString());
emp.Desc = dr["Desc"].ToString();
list.Add(emp);
}
return(list);
}
//public int AddEmloy(int empid, string name, int depid, int posid, int eduid, int sleveid, string telephone,string email,bool gnder,string date)
public int AddEmloy(Employee_info emp)
{
try
{//打开连接
DBHelper.conn.Open();
//创建命令对象
SqlCommand com = new SqlCommand();
com.Connection = DBHelper.conn;
//命令类型为储存过程
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "usp_select3";
//向储存过程传参数
//SqlParameter emid = com.Parameters.Add("employeeid", SqlDbType.Int);
//emid.Direction = ParameterDirection.Input;
//emid.Value = empid;
SqlParameter emname = com.Parameters.Add("name", SqlDbType.NVarChar, 20);
emname.Direction = ParameterDirection.Input;
emname.Value = emp.EmployeeName;
//com.Parameters.Add(emname);
SqlParameter emdepid = com.Parameters.Add("depid", SqlDbType.Int);
emdepid.Direction = ParameterDirection.Input;
emdepid.Value = emp.DeptId;
//com.Parameters.Add(emdepid);
SqlParameter emposid = com.Parameters.Add("posid", SqlDbType.Int);
emposid.Direction = ParameterDirection.Input;
emposid.Value = emp.PositionId;
///com.Parameters.Add(emposid);
SqlParameter emeduid = com.Parameters.Add("eduid", SqlDbType.Int);
emeduid.Direction = ParameterDirection.Input;
emeduid.Value = emp.EducationId;
//com.Parameters.Add(emeduid);
SqlParameter emsleveid = com.Parameters.Add("sleveid", SqlDbType.Int);
emsleveid.Direction = ParameterDirection.Input;
emsleveid.Value = emp.SalLevelId;
//com.Parameters.Add(emsleveid);
SqlParameter emtelephone = com.Parameters.Add("telephone", SqlDbType.NVarChar, 20);
emtelephone.Direction = ParameterDirection.Input;
emtelephone.Value = emp.TelephoneNo;
//com.Parameters.Add(emtelephone);
SqlParameter ememail = com.Parameters.Add("email", SqlDbType.NVarChar, 20);
ememail.Direction = ParameterDirection.Input;
ememail.Value = emp.Email;
SqlParameter gnder = com.Parameters.Add("gnder", SqlDbType.Bit);
gnder.Direction = ParameterDirection.Input;
gnder.Value = emp.Gender;
SqlParameter date1 = com.Parameters.Add("date", SqlDbType.DateTime);
date1.Direction = ParameterDirection.Input;
date1.Value = emp.HireDate;
SqlParameter desc1 = com.Parameters.Add("desc1", SqlDbType.NVarChar, 100);
desc1.Direction = ParameterDirection.Input;
desc1.Value = emp.Desc;
//com.Parameters.Add(ememail);
com.ExecuteNonQuery();
return(1);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DBHelper.conn.Close();
}
}
