Examples of org.jallinone.documents.java.LevelPropertyVO

org.jallinone.documents.java.LevelPropertyVO

Title: JAllInOne ERP/CRM application

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

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

  public VOListResponse updateLevelProperties(ArrayList oldVOs,ArrayList newVOs,String serverLanguageId,String username) throws Throwable {
    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;


      LevelPropertyVO oldVO = null;
      LevelPropertyVO newVO = null;


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


        // update property description...
        CompanyTranslationUtils.updateTranslation(
            newVO.getCompanyCodeSys01DOC21(),
            oldVO.getDescriptionSYS10(),
            newVO.getDescriptionSYS10(),
            newVO.getProgressiveSys10DOC21(),
            serverLanguageId,
            username,
            conn
        );
      }

View Full Code Here

  public VOListResponse insertLevelProperties(ArrayList list,String serverLanguageId,String username,ArrayList companiesList) throws Throwable {
    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;
      String companyCode = companiesList.get(0).toString();
      LevelPropertyVO vo = null;
      BigDecimal progressiveSys10DOC21 = null;


      Map attribute2dbField = new HashMap();
      attribute2dbField.put("companyCodeSys01DOC21","COMPANY_CODE_SYS01");
      attribute2dbField.put("progressiveSys10DOC21","PROGRESSIVE_SYS10");
      attribute2dbField.put("progressiveHie01DOC21","PROGRESSIVE_HIE01");
      attribute2dbField.put("progressiveHie02DOC21","PROGRESSIVE_HIE02");
      attribute2dbField.put("propertyTypeDOC21","PROPERTY_TYPE");


      Response res = null;


      for(int i=0;i<list.size();i++) {
        vo = (LevelPropertyVO)list.get(i);
        if (vo.getCompanyCodeSys01DOC21() == null)
          vo.setCompanyCodeSys01DOC21(companyCode);


        // insert record in SYS10 and generate progressive for property description...
        progressiveSys10DOC21 = CompanyTranslationUtils.insertTranslations(vo.getDescriptionSYS10(),vo.getCompanyCodeSys01DOC21(),username,conn);
        vo.setProgressiveSys10DOC21(progressiveSys10DOC21);


        // insert into DOC21...
        res = org.jallinone.commons.server.QueryUtilExtension.insertTable(
            conn,
            new UserSessionParameters(username),

View Full Code Here

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


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


        // phisically delete records in DOC20...
        stmt.execute("delete from DOC20_DOC_PROPERTIES where "+
            "COMPANY_CODE_SYS01='"+vo.getCompanyCodeSys01DOC21()+"' and "+
            "PROGRESSIVE_SYS10="+vo.getProgressiveSys10DOC21());


        // phisically delete record in DOC21...
        stmt.execute("delete from DOC21_LEVEL_PROPERTIES where "+
            "COMPANY_CODE_SYS01='"+vo.getCompanyCodeSys01DOC21()+"' and "+
            "PROGRESSIVE_SYS10="+vo.getProgressiveSys10DOC21());
      }


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

View Full Code Here

TOP

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

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.