/[H6]/DatabaseLayer.cpp
ViewVC logotype

Diff of /DatabaseLayer.cpp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 18 by torben, Thu Aug 31 16:32:37 2006 UTC revision 19 by torben, Fri Sep 1 02:23:19 2006 UTC
# Line 1  Line 1 
1    
2    
3  #include "StdAfx.h"  #include "StdAfx.h"
4  #include ".\databaselayer.h"  #include ".\databaselayer.h"
5    
# Line 277  vector<Equipment> DatabaseLayer::Search( Line 279  vector<Equipment> DatabaseLayer::Search(
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) {
Legend:
Removed from v.18  
changed lines
  Added in v.19
  ViewVC Help
Powered by ViewVC 1.1.20