/[H6]/MicrosoftDBLayer.cpp
ViewVC logotype

Diff of /MicrosoftDBLayer.cpp

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

revision 55 by torben, Tue Sep 12 09:09:30 2006 UTC revision 56 by torben, Tue Sep 12 10:16:06 2006 UTC
# Line 210  vector<Equipment> MicrosoftDBLayer::GetE Line 210  vector<Equipment> MicrosoftDBLayer::GetE
210  Equipment MicrosoftDBLayer::GetEquipment(CString wantBarcode)  Equipment MicrosoftDBLayer::GetEquipment(CString wantBarcode)
211  {  {
212    
213          CString barcode,name,description,placement,status;          CString barcode,name,description,placement,status,statusid;
214    
215          CString SQL;          CString SQL;
216    
# Line 218  Equipment MicrosoftDBLayer::GetEquipment Line 218  Equipment MicrosoftDBLayer::GetEquipment
218    
219          Equipment e;          Equipment e;
220    
221          SQL.Format("SELECT Stregkode,Navn,Udstyr.Beskrivelse,Placering,Status.Beskrivelse FROM Udstyr INNER JOIN Status ON Udstyr.Status = Status.StatusID Where (Stregkode = '%s')", wantBarcode);          SQL.Format("SELECT Stregkode,Navn,Udstyr.Beskrivelse,Placering,Status.Beskrivelse, Udstyr.Status FROM Udstyr INNER JOIN Status ON Udstyr.Status = Status.StatusID Where (Stregkode = '%s')", wantBarcode);
222          CRecordset rs(&db);          CRecordset rs(&db);
223          rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);          rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
224          if (!rs.IsEOF() )          if (!rs.IsEOF() )
# Line 228  Equipment MicrosoftDBLayer::GetEquipment Line 228  Equipment MicrosoftDBLayer::GetEquipment
228                  rs.GetFieldValue(2,description);                  rs.GetFieldValue(2,description);
229                  rs.GetFieldValue(3,placement);                  rs.GetFieldValue(3,placement);
230                  rs.GetFieldValue(4,status);                  rs.GetFieldValue(4,status);
231                    rs.GetFieldValue(5,statusid);
232    
233                  e.barcode = barcode;                  e.barcode = barcode;
234                  e.name = name;                  e.name = name;
235                  e.description = description;                  e.description = description;
236                  e.placement = placement;                  e.placement = placement;
237                  e.status = status;                  e.status = status;
238                    e.statusid = atoi( statusid );
239    
240                  rs.Close();                  rs.Close();
241    
Legend:
Removed from v.55  
changed lines
  Added in v.56
  ViewVC Help
Powered by ViewVC 1.1.20