CMDTgest/piece.cpp at master · Yugo19/CMDTgest · GitHub

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
48
49
50
51
52
#include "piece.h"
#include "ui_piece.h"
#include <QSqlQuery>
#include <QSql>
#include <QMessageBox>

piece::piece(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::piece)
{
    ui->setupUi(this);
}

piece::~piece()
{
    delete ui;
}

void piece::on_pushButton_clicked()
{
    con->connect();
    qry = new QSqlQuery;
    qry->prepare("insert into piece (Code, Ref_PCS, REF_Mag, Désignations, unités, Casiers, P_U)"
                 "values(?, ? ,? ?, ?, ?, ?)");
    qry->addBindValue(ui->code->text());
    qry->addBindValue(ui->Ref_pcs->text());
    qry->addBindValue(ui->Ref_mag->text());
    qry->addBindValue(ui->Designation->text());
    qry->addBindValue(ui->unites->text());
    qry->addBindValue(ui->casiers->text());
    qry->addBindValue(ui->prix_u->text());

    if(qry->exec())
    {
        msg->setText("Enregistrer avec succes");
        msg->show();
        ui->code->setText("");
        ui->Ref_mag->setText("");
        ui->Ref_pcs->setText("");
        ui->Designation->setText("");
        ui->unites->setText("");
        ui->casiers->setText("");
        ui->prix_u->setText("");
    }else
    {
        msg->setText("Erreur: Reverifier les données saisies");
        msg->show();
    }

    con->disconnect();

}