Index: ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceOptimizeManagerImpl.java =================================================================== diff -u -r35197 -r35523 --- ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceOptimizeManagerImpl.java (.../InvoiceOptimizeManagerImpl.java) (revision 35197) +++ ssts-invoice/src/main/java/com/forgon/disinfectsystem/invoicemanager/service/InvoiceOptimizeManagerImpl.java (.../InvoiceOptimizeManagerImpl.java) (revision 35523) @@ -8521,6 +8521,7 @@ Map invoiceItemMap = new HashMap(); invoiceItemMap.put("serialNumber", serialNumber); invoiceItemMap.put("amount", 1); + invoiceItemMap.put("materialAmount", comboTousseInstace.getMaterialAmount()); invoiceItemMap.put("comboTousseInstanceId", comboTousseInstanceId); invoiceItemMap.put("diposable", Constants.STR_NO); invoiceItemMap.put("isPrint", Constants.STR_NO); @@ -8652,8 +8653,8 @@ String insertIntoInvoiceItemBatchSql = String.format( "insert into %s(%s amount,comboTousseInstanceId," + "diposable,isPrint,settlementPrice,settlementDiscountPrice," - + "tousseDefinitionId,tousseType,tousseName,type,invoiceID,invoice_id) " - + "values (%s ?,?,?,?,?,?,?,?,?,?,?,?)", + + "tousseDefinitionId,tousseType,tousseName,type,invoiceID,invoice_id,materialAmount) " + + "values (%s ?,?,?,?,?,?,?,?,?,?,?,?,?)", InvoiceItem.class.getSimpleName(),idColumnName,idColumnValue); jdbcTemplate.batchUpdate(insertIntoInvoiceItemBatchSql, new BatchPreparedStatementSetter() { @@ -8701,6 +8702,12 @@ Long invoiceId = invoice.getId(); ps.setLong(11, invoiceId); ps.setLong(12, invoiceId); + Integer materialAmount = (Integer)invoiceItemMap.get("materialAmount"); + if(materialAmount == null){ + ps.setObject(13, 0); + }else{ + ps.setInt(13, materialAmount); + } } @Override