Examples of InDeliveryNoteRowPK

org.jallinone.warehouse.documents.java.InDeliveryNoteRowPK

Title: JAllInOne ERP/CRM application

Description: Value object used to store in delivery note row info.

This file is part of JAllInOne ERP/CRM application. This application is free software; you can redistribute it and/or modify it under the terms of the (LGPL) Lesser General Public License as published by the Free Software Foundation; GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 This application is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. The author may be contacted at: maurocarniel@tin.it

@author Mauro Carniel @version 1.0

    PreparedStatement pstmt = null;
    PreparedStatement pstmt2 = null;
    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;
      InDeliveryNoteRowPK rowPK = null;


      pstmt = conn.prepareStatement(
        "delete from DOC09_IN_DELIVERY_NOTE_ITEMS where PROGRESSIVE=?"
      );


      pstmt2 = conn.prepareStatement(
       "delete from DOC11_IN_SERIAL_NUMBERS where PROGRESSIVE_DOC09=? "
      );


      Response res = null;
      for(int i=0;i<list.size();i++) {
        rowPK = (InDeliveryNoteRowPK)list.get(i);


        // delete previous serial numbers from DOC11...
        pstmt2.setBigDecimal(1,rowPK.getProgressiveDOC09());
        pstmt2.execute();


        // phisically delete the record in DOC09...
        pstmt.setBigDecimal(1,rowPK.getProgressiveDOC09());
        pstmt.execute();
      }


      return new VOResponse(new Boolean(true));
    }

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of InDeliveryNoteRowPK

Examples of org.jallinone.warehouse.documents.java.InDeliveryNoteRowPK