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+"$" ); |
