Beispiel #1
0
 @Override
 public void addStockRecord(StockRecord stockRecord) throws OmsDataAccessException {
   try {
     jdbcTemplate.update(
         addStockRecordQuery,
         new Object[] {
           stockRecord.getTransDocRef(),
           stockRecord.getProduct().getProductId(),
           stockRecord.getFromTo(),
           stockRecord.getGoodIn(),
           stockRecord.getGoodOut(),
           stockRecord.getGoodBalance(),
           stockRecord.getDefIn(),
           stockRecord.getDefOut(),
           stockRecord.getDefBalance()
         });
   } catch (DataAccessException dae) {
     throw new OmsDataAccessException(dae);
   }
 }
Beispiel #2
0
    public StockRecord mapRow(ResultSet resultSet, int arg1) throws SQLException {
      StockRecord stockRecord = new StockRecord();
      stockRecord.setRecordId(resultSet.getLong("record_id"));
      stockRecord.setTransDocRef(resultSet.getString("trans_doc_ref"));
      stockRecord.setFromTo(resultSet.getString("fromTo"));
      stockRecord.setGoodIn(resultSet.getLong("good_in"));
      stockRecord.setGoodOut(resultSet.getLong("good_out"));
      stockRecord.setGoodBalance(resultSet.getLong("good_balance"));
      stockRecord.setDefIn(resultSet.getLong("def_in"));
      stockRecord.setDefOut(resultSet.getLong("def_out"));
      stockRecord.setDefBalance(resultSet.getLong("def_balance"));
      stockRecord.setCreatedDate(resultSet.getString("created_date"));

      Product product = new Product();
      product.setProductId(resultSet.getLong("product_id"));
      product.setProductName(resultSet.getString("product_name"));

      stockRecord.setProduct(product);
      return stockRecord;
    }