コード例 #1
0
  /** Business logic to execute. */
  public VOResponse deleteLedger(ArrayList list, String serverLanguageId, String username)
      throws Throwable {
    Statement stmt = null;
    Connection conn = null;
    try {
      if (this.conn == null) conn = getConn();
      else conn = this.conn;
      stmt = conn.createStatement();

      LedgerVO vo = null;
      for (int i = 0; i < list.size(); i++) {
        // logically delete the record in ACC01...
        vo = (LedgerVO) list.get(i);
        stmt.execute(
            "update ACC01_LEDGER set ENABLED='N' where COMPANY_CODE_SYS01='"
                + vo.getCompanyCodeSys01ACC01()
                + "' and LEDGER_CODE='"
                + vo.getLedgerCodeACC01()
                + "'");
      }

      return new VOResponse(new Boolean(true));
    } catch (Throwable ex) {
      Logger.error(
          username,
          this.getClass().getName(),
          "executeCommand",
          "Error while deleting existing ledger",
          ex);
      try {
        if (this.conn == null && conn != null)
          // rollback only local connection
          conn.rollback();
      } catch (Exception ex3) {
      }
      throw new Exception(ex.getMessage());
    } finally {
      try {
        stmt.close();
      } catch (Exception exx) {
      }
      try {
        if (this.conn == null && conn != null) {
          // close only local connection
          conn.commit();
          conn.close();
        }

      } catch (Exception exx) {
      }
    }
  }
コード例 #2
0
  /** Business logic to execute. */
  public VOListResponse updateLedger(
      ArrayList oldVOs,
      ArrayList newVOs,
      String serverLanguageId,
      String username,
      ArrayList customizedFields)
      throws Throwable {
    Connection conn = null;
    try {
      if (this.conn == null) conn = getConn();
      else conn = this.conn;
      LedgerVO oldVO = null;
      LedgerVO newVO = null;
      Response res = null;

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

        // update SYS10 table...
        TranslationUtils.updateTranslation(
            oldVO.getDescriptionSYS10(),
            newVO.getDescriptionSYS10(),
            newVO.getProgressiveSys10ACC01(),
            serverLanguageId,
            conn);

        HashSet pkAttrs = new HashSet();
        pkAttrs.add("companyCodeSys01ACC01");
        pkAttrs.add("ledgerCodeACC01");

        HashMap attribute2dbField = new HashMap();
        attribute2dbField.put("ledgerCodeACC01", "LEDGER_CODE");
        attribute2dbField.put("progressiveSys10ACC01", "PROGRESSIVE_SYS10");
        attribute2dbField.put("enabledACC01", "ENABLED");
        attribute2dbField.put("companyCodeSys01ACC01", "COMPANY_CODE_SYS01");
        attribute2dbField.put("accountTypeACC01", "ACCOUNT_TYPE");

        res =
            new CustomizeQueryUtil()
                .updateTable(
                    conn,
                    new UserSessionParameters(username),
                    pkAttrs,
                    oldVO,
                    newVO,
                    "ACC01_LEDGER",
                    attribute2dbField,
                    "Y",
                    "N",
                    null,
                    true,
                    customizedFields);
        if (res.isError()) {
          throw new Exception(res.getErrorMessage());
        }
      }

      return new VOListResponse(newVOs, false, newVOs.size());
    } catch (Throwable ex) {
      Logger.error(
          username,
          this.getClass().getName(),
          "executeCommand",
          "Error while updating existing ledger",
          ex);
      try {
        if (this.conn == null && conn != null)
          // rollback only local connection
          conn.rollback();
      } catch (Exception ex3) {
      }
      throw new Exception(ex.getMessage());
    } finally {
      try {
        if (this.conn == null && conn != null) {
          // close only local connection
          conn.commit();
          conn.close();
        }

      } catch (Exception exx) {
      }
    }
  }
コード例 #3
0
  /** Business logic to execute. */
  public VOListResponse insertLedger(
      ArrayList list,
      String serverLanguageId,
      String username,
      ArrayList companyCodes,
      ArrayList customizedFields)
      throws Throwable {

    Connection conn = null;
    try {
      if (this.conn == null) conn = getConn();
      else conn = this.conn;
      String companyCode = companyCodes.get(0).toString();

      LedgerVO vo = null;

      BigDecimal progressiveSYS10 = null;
      Response res = null;

      Map attribute2dbField = new HashMap();
      attribute2dbField.put("ledgerCodeACC01", "LEDGER_CODE");
      attribute2dbField.put("progressiveSys10ACC01", "PROGRESSIVE_SYS10");
      attribute2dbField.put("enabledACC01", "ENABLED");
      attribute2dbField.put("companyCodeSys01ACC01", "COMPANY_CODE_SYS01");
      attribute2dbField.put("accountTypeACC01", "ACCOUNT_TYPE");

      for (int i = 0; i < list.size(); i++) {
        vo = (LedgerVO) list.get(i);
        vo.setEnabledACC01("Y");
        if (vo.getCompanyCodeSys01ACC01() == null) vo.setCompanyCodeSys01ACC01(companyCode);

        // insert record in SYS10...
        progressiveSYS10 =
            TranslationUtils.insertTranslations(
                vo.getDescriptionSYS10(), vo.getCompanyCodeSys01ACC01(), conn);
        vo.setProgressiveSys10ACC01(progressiveSYS10);

        // insert into ACC01...
        res =
            CustomizeQueryUtil.insertTable(
                conn,
                new UserSessionParameters(username),
                vo,
                "ACC01_LEDGER",
                attribute2dbField,
                "Y",
                "N",
                null,
                true,
                customizedFields);
        if (res.isError()) {
          throw new Exception(res.getErrorMessage());
        }
      }

      return new VOListResponse(list, false, list.size());
    } catch (Throwable ex) {
      Logger.error(
          username,
          this.getClass().getName(),
          "executeCommand",
          "Error while inserting new ledgers",
          ex);
      try {
        if (this.conn == null && conn != null)
          // rollback only local connection
          conn.rollback();
      } catch (Exception ex3) {
      }
      throw new Exception(ex.getMessage());
    } finally {
      try {
        if (this.conn == null && conn != null) {
          // close only local connection
          conn.commit();
          conn.close();
        }

      } catch (Exception exx) {
      }
    }
  }