Line 105... |
Line 105... |
105 |
for (SQLRow row : rows) {
|
105 |
for (SQLRow row : rows) {
|
106 |
rowVals.put("ID_AFFAIRE", row.getForeignID("ID_AFFAIRE"));
|
106 |
rowVals.put("ID_AFFAIRE", row.getForeignID("ID_AFFAIRE"));
|
107 |
SQLRowValues rowValsCmdElt = inj.createRowValuesFrom(row);
|
107 |
SQLRowValues rowValsCmdElt = inj.createRowValuesFrom(row);
|
108 |
rowValsCmdElt.put("ID_STYLE", idNormal);
|
108 |
rowValsCmdElt.put("ID_STYLE", idNormal);
|
109 |
rowValsCmdElt.put("ID_MODE_VENTE_ARTICLE", ReferenceArticleSQLElement.A_LA_PIECE);
|
109 |
rowValsCmdElt.put("ID_MODE_VENTE_ARTICLE", ReferenceArticleSQLElement.A_LA_PIECE);
|
110 |
rowValsCmdElt.put("ID_TAXE", TaxeCache.getCache().getFirstTaxe().getID());
|
110 |
rowValsCmdElt.put("ID_TAXE", TaxeCache.getCache().getFirstTaxeAchat().getID());
|
111 |
rowValsCmdElt.put("ID_DEMANDE_PRIX", rowVals);
|
111 |
rowValsCmdElt.put("ID_DEMANDE_PRIX", rowVals);
|
112 |
rowValsCmdElt.put("ID_DEMANDE_ACHAT_ELEMENT", row.getID());
|
112 |
rowValsCmdElt.put("ID_DEMANDE_ACHAT_ELEMENT", row.getID());
|
113 |
if (row.getObject("ID_ARTICLE") != null && !row.isForeignEmpty("ID_ARTICLE")) {
|
113 |
if (row.getObject("ID_ARTICLE") != null && !row.isForeignEmpty("ID_ARTICLE")) {
|
114 |
BigDecimal ha = row.getForeign("ID_ARTICLE").getBigDecimal("PA_HT");
|
114 |
BigDecimal ha = row.getForeign("ID_ARTICLE").getBigDecimal("PA_HT");
|
115 |
rowValsCmdElt.put("PA_HT", ha);
|
115 |
rowValsCmdElt.put("PA_HT", ha);
|
Line 163... |
Line 163... |
163 |
for (SQLRow row : rows) {
|
163 |
for (SQLRow row : rows) {
|
164 |
rowVals.put("ID_AFFAIRE", row.getForeignID("ID_AFFAIRE"));
|
164 |
rowVals.put("ID_AFFAIRE", row.getForeignID("ID_AFFAIRE"));
|
165 |
SQLRowValues rowValsCmdElt = inj.createRowValuesFrom(row);
|
165 |
SQLRowValues rowValsCmdElt = inj.createRowValuesFrom(row);
|
166 |
rowValsCmdElt.put("ID_STYLE", idNormal);
|
166 |
rowValsCmdElt.put("ID_STYLE", idNormal);
|
167 |
rowValsCmdElt.put("ID_MODE_VENTE_ARTICLE", ReferenceArticleSQLElement.A_LA_PIECE);
|
167 |
rowValsCmdElt.put("ID_MODE_VENTE_ARTICLE", ReferenceArticleSQLElement.A_LA_PIECE);
|
168 |
rowValsCmdElt.put("ID_TAXE", TaxeCache.getCache().getFirstTaxe().getID());
|
168 |
rowValsCmdElt.put("ID_TAXE", TaxeCache.getCache().getFirstTaxeAchat().getID());
|
169 |
rowValsCmdElt.put("ID_COMMANDE", rowVals);
|
169 |
rowValsCmdElt.put("ID_COMMANDE", rowVals);
|
170 |
rowValsCmdElt.put("ID_DEMANDE_ACHAT_ELEMENT", row.getID());
|
170 |
rowValsCmdElt.put("ID_DEMANDE_ACHAT_ELEMENT", row.getID());
|
171 |
if (row.getObject("ID_ARTICLE") != null && !row.isForeignEmpty("ID_ARTICLE")) {
|
171 |
if (row.getObject("ID_ARTICLE") != null && !row.isForeignEmpty("ID_ARTICLE")) {
|
172 |
BigDecimal ha = row.getForeign("ID_ARTICLE").getBigDecimal("PA_HT");
|
172 |
BigDecimal ha = row.getForeign("ID_ARTICLE").getBigDecimal("PA_HT");
|
173 |
rowValsCmdElt.put("PA_HT", ha);
|
173 |
rowValsCmdElt.put("PA_HT", ha);
|