1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
QString messagerecu;
in >> messagerecu;
message2->append(messagerecu);
if( messagerecu == "macommande")
{
QSqlDatabase db ( QSqlDatabase::addDatabase("QMYSQL"));
db.setHostName("localhost");
db.setDatabaseName("e-commerce");
db.setUserName("root");
db.setPassword("");
QString idcommande;
QString produit;
QString client;
QString qtemax;
QString qte;
db.open();
QSqlQuery query("SELECT *from commande ORDER BY idcommande ASC ");
while(query.next())
{
idcommande = query.value(0).toString();
produit =query.value(1).toString();
client=query.value(2).toString();
qtemax=query.value(3).toString();
qte=query.value(5).toString();
messageAEnvoyer ="$"+idcommande+"+"+client+"+"+produit+"+"+qtemax+"+"+qte+"$";
QByteArray paquetsend;
QDataStream out(&paquetsend, QIODevice::WriteOnly);
out << (quint16) 0;
out << messageAEnvoyer;
out.device()->seek(0);
out << (quint16) (paquetsend.size() - sizeof(quint16));
clients[0]->write(paquetsend); // On envoie le paquet
}
message2->append(tr("Message envoyer! Serveur")+":$" +messageAEnvoyer+"$" ); |
Partager