Examples of org.jallinone.documents.java.DocPropertyVO

org.jallinone.documents.java.DocPropertyVO

Title: JAllInOne ERP/CRM application

Description: Value object used to store a level property value for a specific document.

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

      pkAttributes.add("companyCodeSys01DOC20");
      pkAttributes.add("progressiveDoc14DOC20");
      pkAttributes.add("progressiveSys10DOC20");


      Response res = null;
      DocPropertyVO oldVO = null;
      DocPropertyVO newVO = null;


      pstmt = conn.prepareStatement(
          "select PROGRESSIVE_DOC14 from DOC20_DOC_PROPERTIES where "+
          "COMPANY_CODE_SYS01=? and PROGRESSIVE_DOC14=? and PROGRESSIVE_SYS10=?"
      );
      ResultSet rset = null;


      for(int i=0;i<oldVOs.size();i++) {
        oldVO = (DocPropertyVO)oldVOs.get(i);
        newVO = (DocPropertyVO)newVOs.get(i);


        // check if the record already exists: if it does not exist, then insert it...
        pstmt.setString(1,newVO.getCompanyCodeSys01DOC20());
        pstmt.setBigDecimal(2,newVO.getProgressiveDoc14DOC20());
        pstmt.setBigDecimal(3,newVO.getProgressiveSys10DOC20());
        rset = pstmt.executeQuery();
        if(rset.next()) {
          // the record exixts: it will be updated...
          res = org.jallinone.commons.server.QueryUtilExtension.updateTable(
              conn,

Examples of org.jallinone.documents.java.DocPropertyVO

Related Classes of org.jallinone.documents.java.DocPropertyVO