1 |
|
|
2 |
|
|
3 |
#include "StdAfx.h" |
#include "StdAfx.h" |
4 |
#include ".\databaselayer.h" |
#include ".\databaselayer.h" |
5 |
|
|
279 |
for (int i=0; i<buffer.size(); i++) { |
for (int i=0; i<buffer.size(); i++) { |
280 |
//fill Equipment::checkouts |
//fill Equipment::checkouts |
281 |
|
|
282 |
SQL = "SELECT Udlån.StartDato, Udlån.Afleveringsdato,Udlån.Antaldage, Person.Initialer\ |
SQL = "SELECT TOP 10 Udlån.StartDato, Udlån.Afleveringsdato,Udlån.Antaldage, Person.Initialer\ |
283 |
FROM Udlån\ |
FROM Udlån\ |
284 |
INNER JOIN Person ON Udlån.PersonID = Person.PersonID "; |
INNER JOIN Person ON Udlån.PersonID = Person.PersonID "; |
285 |
SQL += "WHERE Udlån.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC"; |
SQL += "WHERE Udlån.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO DESC"; |
286 |
CRecordset rs(&db); |
CRecordset rs(&db); |
287 |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL); |
288 |
if (rs.GetRecordCount()>0) { |
if (rs.GetRecordCount()>0) { |