private void btnDuyet_Click(object sender, EventArgs e)
{
int tinhTrang = int.Parse(cmbTinhTrang.SelectedValue.ToString());
string DateFrom = this.dateFrom.Value.ToString("yyyy/MM/dd HH:mm");
string DateTo = this.dateTo.Value.ToString("yyyy/MM/dd HH:mm");
total = PhieuThueDAO.LaySoLuongPhieuThue(DateFrom, DateTo, tinhTrang);
dtgDSPhieuThue.DataSource = PhieuThueDAO.DuyetDSPhieuThue(DateFrom, DateTo, tinhTrang, limit, offset);
dtgChiTietPhieuThue.DataSource = PhieuThueDAO.LayChiTietPhieuThue(-1);//load lại bảng chi tiết phiếu thuê
}