Example #1
0
  public QueryResult sort(SortierKriterium[] sortierKriterien, Object selectedId)
      throws EJBExceptionLP {
    this.getQuery().setSortKrit(sortierKriterien);

    QueryResult result = null;
    int rowNumber = 0;

    if (selectedId != null && ((Integer) selectedId).intValue() >= 0) {
      SessionFactory factory = FLRSessionFactory.getFactory();
      Session session = null;

      try {
        session = factory.openSession();
        String queryString =
            "select reportvariante.i_id from FLRReportvariante reportvariante "
                + this.buildWhereClause()
                + this.buildOrderByClause();
        Query query = session.createQuery(queryString);
        ScrollableResults scrollableResult = query.scroll();
        //				boolean idFound = false;
        if (scrollableResult != null) {
          scrollableResult.beforeFirst();
          while (scrollableResult.next()) {
            Integer id = (Integer) scrollableResult.getInteger(0); // TYPE
            // OF
            // KEY
            // ATTRIBUTE
            // !
            // !
            // !
            if (selectedId.equals(id)) {
              rowNumber = scrollableResult.getRowNumber();
              break;
            }
          }
        }
      } catch (Exception e) {
        throw new EJBExceptionLP(EJBExceptionLP.FEHLER_FLR, e);
      } finally {
        try {
          session.close();
        } catch (HibernateException he) {
          throw new EJBExceptionLP(EJBExceptionLP.FEHLER_FLR, he);
        }
      }
    }

    if (rowNumber < 0 || rowNumber >= this.getRowCount()) {
      rowNumber = 0;
    }

    result = this.getPageAt(new Integer(rowNumber));
    result.setIndexOfSelectedRow(rowNumber);

    return result;
  }
  public QueryResult sort(SortierKriterium[] sortierKriterien, Object selectedId)
      throws EJBExceptionLP {
    this.getQuery().setSortKrit(sortierKriterien);

    QueryResult result = null;
    int rowNumber = 0;

    if (selectedId != null && ((Integer) selectedId).intValue() >= 0) {
      SessionFactory factory = FLRSessionFactory.getFactory();
      Session session = null;

      try {
        session = factory.openSession();
        String queryString =
            "select "
                + FLR_ZVL
                + EingangsrechnungFac.FLR_ZV_LAUF_I_ID
                + FLR_ZVL_FROM_CLAUSE
                + this.buildWhereClause()
                + this.buildOrderByClause();
        Query query = session.createQuery(queryString);
        ScrollableResults scrollableResult = query.scroll();
        if (scrollableResult != null) {
          scrollableResult.beforeFirst();
          while (scrollableResult.next()) {
            Integer id = scrollableResult.getInteger(0);
            if (selectedId.equals(id)) {
              rowNumber = scrollableResult.getRowNumber();
              break;
            }
          }
        }
      } catch (Exception e) {
        throw new EJBExceptionLP(EJBExceptionLP.FEHLER_FLR, e);
      } finally {
        try {
          session.close();
        } catch (HibernateException he) {
          throw new EJBExceptionLP(EJBExceptionLP.FEHLER, he);
        }
      }
    }

    if (rowNumber < 0 || rowNumber >= this.getRowCount()) {
      rowNumber = 0;
    }

    result = this.getPageAt(new Integer(rowNumber));
    result.setIndexOfSelectedRow(rowNumber);

    return result;
  }
  public QueryResult sort(SortierKriterium[] sortierKriterien, Object selectedId)
      throws EJBExceptionLP {

    getQuery().setSortKrit(sortierKriterien);

    QueryResult result = null;
    int rowNumber = 0;

    if (selectedId != null) {
      SessionFactory factory = FLRSessionFactory.getFactory();
      Session session = null;

      try {
        session = factory.openSession();
        session = setFilter(session);
        String queryString = getFromClause() + buildWhereClause() + buildOrderByClause();

        Query query = session.createQuery(queryString);
        ScrollableResults scrollableResult = query.scroll();
        if (scrollableResult != null) {
          scrollableResult.beforeFirst();
          while (scrollableResult.next()) {
            FLRLohnartstundenfaktor artikelkommentarart =
                (FLRLohnartstundenfaktor) scrollableResult.get(0);
            Integer iId = artikelkommentarart.getI_id();
            if (selectedId.equals(iId)) {
              rowNumber = scrollableResult.getRowNumber();
              break;
            }
          }
        }
      } catch (Exception e) {
        throw new EJBExceptionLP(EJBExceptionLP.FEHLER_FLR, e);
      } finally {
        try {
          session.close();
        } catch (HibernateException he) {
          throw new EJBExceptionLP(EJBExceptionLP.FEHLER_FLR, he);
        }
      }
    }

    if (rowNumber < 0 || rowNumber >= this.getRowCount()) {
      rowNumber = 0;
    }

    result = this.getPageAt(new Integer(rowNumber));
    result.setIndexOfSelectedRow(rowNumber);

    return result;
  }
  public QueryResult sort(SortierKriterium[] sortierKriterien, Object selectedId)
      throws EJBExceptionLP {
    this.getQuery().setSortKrit(sortierKriterien);

    QueryResult result = null;
    int rowNumber = 0;

    if (selectedId != null) {
      SessionFactory factory = FLRSessionFactory.getFactory();
      Session session = null;

      try {
        session = factory.openSession();
        String queryString =
            "select "
                + FLR_WVKNR
                + FinanzServiceFac.FLR_WARENVERKEHRSNUMMER_C_NR
                + FLR_WVKNR_FROM_CLAUSE
                + this.buildWhereClause()
                + this.buildOrderByClause();
        Query query = session.createQuery(queryString);
        ScrollableResults scrollableResult = query.scroll();
        if (scrollableResult != null) {
          scrollableResult.beforeFirst();
          while (scrollableResult.next()) {
            String id = scrollableResult.getString(0);
            if (selectedId.equals(id)) {
              rowNumber = scrollableResult.getRowNumber();
              break;
            }
          }
        }
      } catch (Exception e) {
        throw new EJBExceptionLP(EJBExceptionLP.FEHLER_FLR, e);
      } finally {
        closeSession(session);
      }
    }

    if (rowNumber < 0 || rowNumber >= this.getRowCount()) {
      rowNumber = 0;
    }

    result = this.getPageAt(new Integer(rowNumber));
    result.setIndexOfSelectedRow(rowNumber);

    return result;
  }