Guest User

Untitled

a guest
Nov 13th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.   for(int i = 0; i< T.passangers.size();i++)//Add passengers
  2.       {
  3.           QString bot = "bot";
  4.           QString privilages = "No";
  5.           QString dataB = e.train_name+"_people";
  6.           q.prepare("INSERT INTO "+dataB+" (depart_city,arrival_city,firstname,lastname,bot,vagon,place,privilages,distance,ticket_price)"
  7.                     "VALUES (:depart_city,:arrival_city,:firstname,:lastname,:bot,:vagon,:place,:privilages,:distance,:ticket_price)");
  8.  
  9.           q.bindValue(":depart_city",T.passangers[i].left_city);
  10.             q.bindValue(":arrival_city",T.passangers[i].arrival_city);
  11.               q.bindValue(":firstname",T.passangers[i].name);
  12.                 q.bindValue(":lastname",T.passangers[i].surname);
  13.                   q.bindValue(":bot",bot);
  14.                     q.bindValue(":vagon",T.passangers[i].wagon);
  15.                     q.bindValue(":place",T.passangers[i].place);
  16.                       q.bindValue(":privilages",privilages);
  17.                         q.bindValue(":distance",T.passangers[i].way_distance);
  18.                          q.bindValue(":ticket_price",T.passangers[i].ticket_cost);
  19.                          if(!q.exec())
  20.                              ui->textBrowser_2->append(q.lastError().text()+" "+QString::number(q.lastError().number()));
  21. //ui->textBrowser_2->append(QString::number(i+1)+" "+T.passangers[i].left_city+" "+T.passangers[i].arrival_city+" "+T.passangers[i].name+" "
  22. //+T.passangers[i].surname+" "+QString::number(T.passangers[i].wagon)+" "+QString::number(T.passangers[i].place)+" "+QString::number(T.passangers[i].way_distance));
  23. /*if(!q.exec("INSERT INTO " +dataB +" (depart_city,arrival_city,firstname,lastname,bot,vagon,place,privilages,distance,ticket_price)"
  24.           +"values('"+T.passangers[i].left_city+"','"+T.passangers[i].arrival_city+"','"+T.passangers[i].name+"','"
  25. +T.passangers[i].surname+"','"+bot+"','"+T.passangers[i].wagon+"','"+T.passangers[i].place+"','"+privilages+"','"+T.passangers[i].way_distance+"','"+T.passangers[i].ticket_cost+"')"))
  26. {
  27.     ui->textBrowser_2->append(q.lastError().text()+" "+QString::number(q.lastError().number()));
  28. }*/
  29.       }
Add Comment
Please, Sign In to add comment