public void TestFindEmpByIDDAO()
{
EmpDAO empDao = new EmpDAO();
OleDbConnection con = empDao.Begin();
Emp emp = empDao.FindEmpByIdDAO(con, 5);
Assert.AreEqual(emp.M_leaderName, "gray.piao");
empDao.Commit();
empDao.Close();
}
public void TestUpdateEmpItemDAO()
{
EmpDAO empDao = new EmpDAO();
OleDbConnection con = empDao.Begin();
Emp emp = empDao.FindEmpByIdDAO(con, 1);
empDao.UpdateEmpItemDAO(con, emp);
empDao.Commit();
empDao.Close();
}
public void TestAddEmpItemDAO()
{
Emp emp = new Emp();
emp.M_name = "emp\" )'01";
emp.M_statue = "0";
emp.M_title = "TM";
EmpDAO empDao = new EmpDAO();
OleDbConnection con = empDao.Begin();
empDao.AddEmpItemDAO(con, emp);
empDao.Commit();
empDao.Close();
}
/// <summary>
/// 사원또는 이름으로 검색
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
EmpDAO empDAO = new EmpDAO();
dataGridView1.DataSource = "";
if (txtSearch.Text == "")
{
Attendance_SearchEmpno_Load(null, null);
}
else
{
bool a = false;
if (cbFilter.Text == "사원번호")
{
a = true;
}
lst = empDAO.nameSelect(a, txtSearch.Text);
dataGridView1.DataSource = lst;
}
ColumnSetKor();
}
