//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)); }