1 |
|
|
2 |
|
|
3 |
#include "StdAfx.h" |
#include "StdAfx.h" |
4 |
#include ".\databaselayer.h" |
#include ".\databaselayer.h" |
5 |
|
|
6 |
|
|
7 |
DatabaseLayer::DatabaseLayer(void) |
DatabaseLayer::DatabaseLayer(void) |
8 |
{ |
{ |
9 |
db.OpenEx("ODBC; Description=; DRIVER=SQL Server; SERVER=TK-Teacher; UID=GroupTwo; PWD=toog30"); |
db.OpenEx("ODBC; Description=; DRIVER=SQL Server; SERVER=TK-Teacher; UID=GroupTwo; PWD=toog30", CDatabase::noOdbcDialog); |
10 |
db.ExecuteSQL("USE GroupTwo"); |
db.ExecuteSQL("USE GroupTwo"); |
11 |
} |
} |
12 |
|
|
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) { |