private void XemNV(string sql)
{
//String sql = "SELECT nhanvien.ID, phongban.TENPHONG, HOTEN, NGAYSINH, CMND, DIACHI, DIENTHOAI, QUOCTICH, LOAI_NV, LUONGNGAY, LUONGTHANG, BACLUONG, TONGLUONG FROM nhanvien, phongban WHERE (nhanvien.ID_PHONG = phongban.ID)";
XemNVPresenter xemNVPresenter = new XemNVPresenter(this, sql);
DataTable dt = new DataTable();
xemNVPresenter.getDA().Fill(dt);
listNV_find.DataSource = dt;
}
private void ButtonXem_Update_Click(object sender, EventArgs e)
{
String sql = "SELECT nhanvien.ID, phongban.TENPHONG, HOTEN, NGAYSINH, CMND, DIACHI, DIENTHOAI, QUOCTICH, LOAI_NV, LUONGNGAY, LUONGTHANG, BACLUONG, TONGLUONG FROM nhanvien, phongban WHERE (nhanvien.ID_PHONG = phongban.ID AND phongban.TENPHONG = '" + txtTenphong.Text + "')";
XemNVPresenter xem = new XemNVPresenter(this, sql);
DataTable dt = new DataTable();
xem.getDA().Fill(dt);
listNV_find.DataSource = dt;
}
