301 |
rs.Close(); |
rs.Close(); |
302 |
|
|
303 |
// fill Equipment::reservations |
// fill Equipment::reservations |
304 |
SQL = "SELECT Resevation.StartDato, Resevation.Antaldage, Person.Initialer\ |
SQL = "SELECT Resevation.ResevationID, Resevation.StartDato, Resevation.Antaldage, Person.Initialer\ |
305 |
FROM Resevation\ |
FROM Resevation\ |
306 |
INNER JOIN Person ON Resevation.PersonID = Person.PersonID "; |
INNER JOIN Person ON Resevation.PersonID = Person.PersonID "; |
307 |
SQL += "WHERE Resevation.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC"; |
SQL += "WHERE Resevation.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC"; |
311 |
rs.MoveFirst(); |
rs.MoveFirst(); |
312 |
while ( !rs.IsEOF() ) { |
while ( !rs.IsEOF() ) { |
313 |
Reservation res; |
Reservation res; |
314 |
rs.GetFieldValue((short)0, res.startdate); |
rs.GetFieldValue((short)0, res.reservationID); |
315 |
rs.GetFieldValue(1, res.numdays); |
rs.GetFieldValue(1, res.startdate); |
316 |
rs.GetFieldValue(2, res.inits); |
rs.GetFieldValue(2, res.numdays); |
317 |
|
rs.GetFieldValue(3, res.inits); |
318 |
|
|
319 |
buffer[i].reservations.push_back(res); |
buffer[i].reservations.push_back(res); |
320 |
rs.MoveNext(); |
rs.MoveNext(); |