private void jButton1CommandeClientRechercheMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton1CommandeClientRechercheMouseClicked
        try {
            /*lance recherche produits*/
            mondecimal = new DecimalFormat("#######.00");
             Article article= new Article();
             article = RequetesArticle.selectArticleByRef(jTextFieldCommandeClentProduitRecherche.getText());
             
             // TEST DE LA ZONE DISPONIBLE
          
            if (jTextFieldCmdCliLg1Prod1.getText().trim().equals("")) {
                
                jTextFieldCmdCliLg1Prod1.setText(article.getLibelle());
                Tva tva1 = RequetesTva.selectTvaById(article.getId()); //taux tva
                jTextFieldCmdCliLg1Tva1.setText(mondecimal.format(tva1.getTaux()));
                jTextFieldCmdCliPxHt1.setText(mondecimal.format(article.getPrixht()));
                  
                article1= article;
            }
             else
                  if (jTextFieldCmdCliLg2Prod2.getText().trim().equals("")) {
                jTextFieldCmdCliLg2Prod2.setText(article.getLibelle());
                Tva tva2 = RequetesTva.selectTvaById(article.getId()); //taux tva
                jTextFieldCmdCliLg2Tva2.setText(mondecimal.format(tva2.getTaux()));
                jTextFieldCmdCliPxHt2.setText(mondecimal.format(article.getPrixht()));
                article2= article;
            }
             else
                 if (jTextFieldCmdCliLg3Prod3.getText().trim().equals("")) {
                jTextFieldCmdCliLg3Prod3.setText(article.getLibelle());
                Tva tva3 = RequetesTva.selectTvaById(article.getId());
                jTextFieldCmdCliLg3Tva3.setText(mondecimal.format(tva3.getTaux()));
                jTextFieldCmdCliPxHt3.setText(mondecimal.format(article.getPrixht()));
                article3= article;
            }
             else
                  if (jTextFieldCmdCliLg4Prod4.getText().trim().equals("")) {
                jTextFieldCmdCliLg4Prod4.setText(article.getLibelle());
                Tva tva4 = RequetesTva.selectTvaById(article.getId());
                jTextFieldCmdCliLg4Tva4.setText(mondecimal.format(tva4.getTaux()));
                jTextFieldCmdCliPxHt4.setText(mondecimal.format(article.getPrixht()));
                article4= article;
            }
             else
                  if (jTextFieldCmdCliLg5Prod5.getText().trim().equals("")) {
                jTextFieldCmdCliLg5Prod5.setText(article.getLibelle());
                Tva tva5 = RequetesTva.selectTvaById(article.getId());
                jTextFieldCmdCliLg5Tva5.setText(mondecimal.format(tva5.getTaux()));
                jTextFieldCmdCliPxHt5.setText(mondecimal.format(article.getPrixht()));
                article5= article;
            }
             else
                  if (jTextFieldCmdCliLg6Prod6.getText().trim().equals("")) {
                jTextFieldCmdCliLg6Prod6.setText(article.getLibelle());
                Tva tva6 = RequetesTva.selectTvaById(article.getId());
                jTextFieldCmdCliLg6Tva6.setText(mondecimal.format(tva6.getTaux()));
                jTextFieldCmdCliPxHt6.setText(mondecimal.format(article.getPrixht()));
                article6= article;
            }
             else
                  if (jTextFieldCmdCliLg7Prod7.getText().trim().equals("")) {
                jTextFieldCmdCliLg7Prod7.setText(article.getLibelle());
                Tva tva7 = RequetesTva.selectTvaById(article.getId());
                jTextFieldCmdCliLg7Tva7.setText(mondecimal.format(tva7.getTaux()));
                jTextFieldCmdCliPxHt7.setText(mondecimal.format(article.getPrixht()));
                article7= article;
            }
             else
                  if (jTextFieldCmdCliLg8Prod8.getText().trim().equals("")) {
                jTextFieldCmdCliLg8Prod8.setText(article.getLibelle());
                Tva tva8 = RequetesTva.selectTvaById(article.getId());
                jTextFieldCmdCliLg8Tva8.setText(mondecimal.format(tva8.getTaux()));
                jTextFieldCmdCliPxHt8.setText(mondecimal.format(article.getPrixht()));
                article8= article;
            }
            else
                  {
                      JOptionPane.showMessageDialog(this, "Fin de tableau atteint enregistrer votre commande",  " Erreur ",  JOptionPane.INFORMATION_MESSAGE);
                  }
             
             
           
        } catch (SQLException ex) {
            Logger.getLogger(VueCommandeClient.class.getName()).log(Level.SEVERE, null, ex);
        }
        
            
        
        jTextFieldCommandeTotalHT.setText(String.valueOf(TOTALHT));
        
        
    }//GEN-LAST:event_jButton1CommandeClientRechercheMouseClicked