public static PhongDetail LoadChiTietPhong(int idPhong) { PhongDetail phongDetail = new PhongDetail(); string query = string.Format("exec pro_LoadThongTinChiTietPhong '{0}'", idPhong); DataTable dt = DataProvider.Instance.ExcuteQuery(query); phongDetail.IdPhong = idPhong; phongDetail.GhiChu = dt.Rows[0]["GhiChu"].ToString(); phongDetail.TinhTrang = int.Parse(dt.Rows[0]["TinhTrang"].ToString()); phongDetail.DsKhachThue = new List <Dictionary>(); if (phongDetail.TinhTrang == 1) { query = string.Format("exec pro_LoadDSKhachThuePhong '{0}'", idPhong); dt = DataProvider.Instance.ExcuteQuery(query); phongDetail.IdPhieuThue = int.Parse(dt.Rows[0]["idPhieuThue"].ToString()); DateTime date = (DateTime)dt.Rows[0]["NgayThue"]; phongDetail.NgayThue = date.ToString("dd/MM/yyyy HH:mm"); foreach (DataRow item in dt.Rows) { Dictionary dsKhachThue = new Dictionary(); dsKhachThue.Id = int.Parse(item["STT"].ToString()); dsKhachThue.Name = item["TenKhachHang"].ToString(); phongDetail.DsKhachThue.Add(dsKhachThue); } } return(phongDetail); }
void DatLai() { lblTenPhong.Text = ""; idPhong = -1; PhongDetail phongDetail = new PhongDetail(); phongDetail.DsKhachThue = new List <Dictionary>(); txtTinhTrang.Text = ""; txtNgayThue.Text = ""; txtGhiChu.Text = ""; dtgDSKhachThue.DataSource = phongDetail.DsKhachThue; }
private void Btn_Click(object sender, EventArgs e) { Button btn = ((sender as Button)); lblTenPhong.Text = btn.Text; idPhong = int.Parse(btn.Name); PhongDetail phongDetail = PhongDAO.LoadChiTietPhong(int.Parse(btn.Name)); if (phongDetail.TinhTrang == 0) { txtTinhTrang.Text = "Còn trống"; txtNgayThue.Text = ""; } else { txtTinhTrang.Text = "Đã thuê"; txtNgayThue.Text = phongDetail.NgayThue; } txtGhiChu.Text = phongDetail.GhiChu; dtgDSKhachThue.DataSource = phongDetail.DsKhachThue; }