Examples of org.jallinone.documents.java.DocumentLinkVO

org.jallinone.documents.java.DocumentLinkVO

Title: JAllInOne ERP/CRM application

Description: Value object used to store a document link in DOC17.

Copyright: Copyright (C) 2006 Mauro Carniel

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

      if (resDOC14.isError()) {
        throw new Exception(resDOC14.getErrorMessage());
      }


      // create a document link with the specified tree level...
      DocumentLinkVO linkVO = new DocumentLinkVO();
      linkVO.setCompanyCodeSys01DOC17(vo.getCompanyCodeSys01DOC14());
      linkVO.setProgressiveDoc14DOC17(vo.getProgressiveDOC14());
      linkVO.setProgressiveHie01DOC17(vo.getProgressiveHie01DOC17());
      Response res = insertDocumentLinkBean.insertDocumentLink(
          linkVO,
          username
      );
      if (res.isError()) {

View Full Code Here

    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;
      insertDocumentLinkBean.setConn(conn);


      DocumentLinkVO vo = null;
      Response res = null;


      for(int i=0;i<list.size();i++) {
        vo = (DocumentLinkVO)list.get(i);

View Full Code Here

      if (res.isError())
        throw new Exception(res.getErrorMessage());


      // for each document link retrieve ancient progressiveHIE01s...
      java.util.List linkVOs = ((VOListResponse)res).getRows();
      DocumentLinkVO linkVO = null;
      pstmt = conn.prepareStatement(
          "select HIE01_COMPANY_LEVELS.PROGRESSIVE,HIE01_COMPANY_LEVELS.PROGRESSIVE_HIE01 from HIE01_COMPANY_LEVELS "+
          "where COMPANY_CODE_SYS01='"+pk.getCompanyCodeSys01DOC14()+"' and HIE01_COMPANY_LEVELS.PROGRESSIVE<=? and PROGRESSIVE_HIE02=?"
      );
      Hashtable parents = new Hashtable();
      HashSet progressiveHIE01s = new HashSet();
      BigDecimal progressiveHIE01 = null;
      for(int i=0;i<linkVOs.size();i++) {
        linkVO = (DocumentLinkVO)linkVOs.get(i);
        parents.clear();
        pstmt.setBigDecimal(1,linkVO.getProgressiveHie01DOC17());
        pstmt.setBigDecimal(2,linkVO.getProgressiveHIE02());
        ResultSet rset = pstmt.executeQuery();
        while(rset.next()) {
          progressiveHIE01 = rset.getBigDecimal(2);
          if (progressiveHIE01!=null)
            parents.put(rset.getBigDecimal(1),progressiveHIE01);
        }
        rset.close();


        // fill in the hashset "progressiveHIE01s"...
        progressiveHIE01 = linkVO.getProgressiveHie01DOC17();
        while(progressiveHIE01!=null) {
          progressiveHIE01s.add(progressiveHIE01);
          progressiveHIE01 = (BigDecimal)parents.get(progressiveHIE01);
        }
      }

View Full Code Here

    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;
      stmt = conn.createStatement();


      DocumentLinkVO vo = null;
      for(int i=0;i<list.size();i++) {
        // phisically delete records in DOC17...
        vo = (DocumentLinkVO)list.get(i);
        stmt.execute("delete from DOC17_DOCUMENT_LINKS where "+
            "COMPANY_CODE_SYS01='"+vo.getCompanyCodeSys01DOC17()+"' and "+
            "PROGRESSIVE_DOC14="+vo.getProgressiveDoc14DOC17()+" and "+
            "PROGRESSIVE_HIE01="+vo.getProgressiveHie01DOC17());
      }


      return new VOResponse(new Boolean(true));
    }
    catch (Throwable ex) {

View Full Code Here

TOP

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

org.jallinone.documents.server.DocumentsBean

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.