/[H6]/MicrosoftDBLayer.cpp
ViewVC logotype

Diff of /MicrosoftDBLayer.cpp

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

revision 41 by torben, Tue Sep 5 12:50:38 2006 UTC revision 52 by torben, Sat Sep 9 05:24:33 2006 UTC
# Line 6  Line 6 
6  #include ".\MicrosoftDBLayer.h"  #include ".\MicrosoftDBLayer.h"
7    
8    
9  MicrosoftDBLayer::MicrosoftDBLayer(void)  MicrosoftDBLayer::MicrosoftDBLayer(ConfigFile &config)
10  {  {
11          db.OpenEx("ODBC; Description=; DRIVER=SQL Server; SERVER=TK-Teacher; UID=GroupTwo; PWD=toog30", CDatabase::noOdbcDialog);          CString dsn;
12          db.ExecuteSQL("USE GroupTwo");          dsn.Format("ODBC; Description=; DRIVER=SQL Server; SERVER=%s; UID=%s; PWD=%s", config.host, config.username, config.password);
13            db.OpenEx(dsn, CDatabase::noOdbcDialog);
14    
15            CString sql;
16            sql.Format("USE %s", config.database);
17            db.ExecuteSQL(sql);
18  }  }
19    
20  MicrosoftDBLayer::~MicrosoftDBLayer(void)  MicrosoftDBLayer::~MicrosoftDBLayer(void)
# Line 156  bool MicrosoftDBLayer::UpdateEquipment(E Line 161  bool MicrosoftDBLayer::UpdateEquipment(E
161          CheckEquip.placement.Replace("'","\"");          CheckEquip.placement.Replace("'","\"");
162          CheckEquip.status.Replace("'","\"");          CheckEquip.status.Replace("'","\"");
163          CheckEquip.barcode.Replace("'","\"");          CheckEquip.barcode.Replace("'","\"");
164          SQL.Format("UPDATE Udstyr SET Navn = '%s', Beskrivelse = '%s', Placering = '%s', Status = '%s' WHERE Stregkode = '%s'", CheckEquip.name, CheckEquip.description, CheckEquip.placement, CheckEquip.status, CheckEquip.barcode);          SQL.Format("UPDATE Udstyr SET Navn = '%s', Beskrivelse = '%s', Placering = '%s' WHERE Stregkode = '%s'", CheckEquip.name, CheckEquip.description, CheckEquip.placement, CheckEquip.barcode);
165          db.ExecuteSQL(SQL);          db.ExecuteSQL(SQL);
166          return true;          return true;
167  }  }
Legend:
Removed from v.41  
changed lines
  Added in v.52
  ViewVC Help
Powered by ViewVC 1.1.20