private void validerCommandes() {
Commandes commandes = (Commandes) classe;
if (commandes
.getDonnees()
.exist(
"commandes", "NumCommande", "NumCommande = " + commandes.getjNumCommande().getText())) {
if (!commandes.getNumClient().getText().equals("")
&& commandes
.getDonnees()
.exist("clients", "NumClient", "NumClient = " + commandes.getNumClient().getText())) {
String[] re = commandes.getValeurDevises().get(commandes.getDevises().getSelectedItem());
commandes
.getBase()
.update(
"commandes",
"numClient = "
+ commandes.getNumClient().getText()
+ ", CdeComClient = '"
+ apostrophe(commandes.getjNumCommandeClient().getText())
+ "', Lblcommande = '"
+ apostrophe(commandes.getjLibelle().getText())
+ "', MntFour = "
+ commandes.getjFournitures().getText().replaceAll(",", "\\.")
+ ", CoutMO = "
+ commandes.getjCout().getText().replaceAll(",", "\\.")
+ ", HeureSite = "
+ commandes.getjHeureSite().getText().replaceAll(",", "\\.")
+ ", HeureAtelier = "
+ commandes.getjHeureAtelier().getText().replaceAll(",", "\\.")
+ ", Corem = "
+ commandes.getCheck().isSelected()
+ ", Prefabrication = "
+ commandes.getjPrefabrication().getText().replaceAll(",", "\\.")
+ ", MatierePrevu = "
+ commandes.getjPrevu().getText().replaceAll(",", "\\.")
+ ", MatiereCommande = "
+ commandes.getjCommande().getText().replaceAll(",", "\\.")
+ ", CodeDevise = "
+ re[0],
"numCommande = " + commandes.getjNumCommande().getText());
comparaisonDevis(commandes);
JOptionPane.showMessageDialog(null, "commandes validé !");
commandes.dispose();
commandes.getFenetre().setEnabled(true);
commandes.getFenetre().setVisible(true);
} else {
JOptionPane.showMessageDialog(
null,
"Erreur : Numéro de Client inconnu ou vide",
"ATTENTION",
JOptionPane.WARNING_MESSAGE);
}
} else {
JOptionPane.showMessageDialog(
null, "Numéro de Devis inexistant", "ATTENTION", JOptionPane.WARNING_MESSAGE);
}
}
