//load chi tiết khách thuê phòng
public DataTable LoadChiTietThuePhong(PhongTro phongtro)
{
String sql = "select PHONG_TRO.MaPhong, CT_KHACH_THUE.MaKhach, CT_KHACH_THUE.TenKhach, KHACH_THUE.Phai, KHACH_THUE.NgheNghiep, CT_KHACH_THUE.NgayVaoPhong from PHONG_TRO, CT_KHACH_THUE, KHACH_THUE where PHONG_TRO.MaPhong = CT_KHACH_THUE.MaPhong and CT_KHACH_THUE.MaKhach = KHACH_THUE.MaKhach and PHONG_TRO.MaPhong = '" + phongtro.getMaPhong() + "'";
rs = manager.executeQuery(sql);
return(rs);
}
private void dgvTrangThaiPhong_CellClick(object sender, DataGridViewCellEventArgs e)
{
string maphong = dgvTrangThaiPhong.Rows[e.RowIndex].Cells[0].Value.ToString();
PhongTro phongtro = new PhongTro();
phongtro.setMaPhong(maphong);
dgvChiTietPhong.DataSource = phongTroBLL.LoadChiTietThuePhong(phongtro);
}
public DataTable LoadChiTietThuePhong(PhongTro phongtro)
{
return(PhongTroDAL.getInstance().LoadChiTietThuePhong(phongtro));
}