Ejemplo n.º 1
0
        //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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
 public DataTable LoadChiTietThuePhong(PhongTro phongtro)
 {
     return(PhongTroDAL.getInstance().LoadChiTietThuePhong(phongtro));
 }