Package org.hibernate.criterion

Examples of org.hibernate.criterion.Conjunction


  @SuppressWarnings("unchecked")
  public List<MovimentoIva> leggiMovimentoIva(long numeroArticolo) throws ImpossibileLeggereMovimentoIvaException {
    try {

      DetachedCriteria criteria = DetachedCriteria.forClass(MovimentoIva.class);
      Conjunction conj = Restrictions.conjunction();
      conj.add(Restrictions.eq("movimentoIvaId.legalEntity", legalEntity));
      conj.add(Restrictions.eq("movimentoIvaId.organizationUnit", organizationUnit));
      conj.add(Restrictions.eq("movimentoIvaId.numeroArticolo", numeroArticolo));
      criteria.add(conj);

      return (List<MovimentoIva>) getHibernateTemplate().findByCriteria(criteria);
    } catch (DataAccessException e) {
      throw new ImpossibileLeggereMovimentoIvaException();
View Full Code Here


  @SuppressWarnings("unchecked")
  public List<InterfacciaAntiMafia> leggiInterfacciaAntiMafia(long numeroAntimafia)
      throws ImpossibileLeggereInterfacciaAntiMafiaException {

    DetachedCriteria criteria = DetachedCriteria.forClass(InterfacciaAntiMafia.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("interfacciaAntiMafiaId.legalEntity", legalEntity));
    conj.add(Restrictions.eq("interfacciaAntiMafiaId.organizationUnit", organizationUnit));
    conj.add(Restrictions.eq("interfacciaAntiMafiaId.numeroAntiMafia", numeroAntimafia));

    criteria.add(conj);
    try {
      return (List<InterfacciaAntiMafia>) getHibernateTemplate().findByCriteria(criteria);
    } catch (DataAccessException e) {
View Full Code Here

  }

  @SuppressWarnings("unchecked")
  public List<MovimentoLegale> leggiMovimentoLegale(long pratica) throws ImpossibileLeggereMovimentoLegaleException {
    DetachedCriteria criteria = DetachedCriteria.forClass(MovimentoLegale.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("movimentoLegaleId.legalEntity", legalEntity));
    conj.add(Restrictions.eq("movimentoLegaleId.organizationUnit", organizationUnit));
    conj.add(Restrictions.eq("movimentoLegaleId.pratica", pratica));

    criteria.add(conj);
    try {

      return (List<MovimentoLegale>) getHibernateTemplate().findByCriteria(criteria);
View Full Code Here

  @SuppressWarnings("unchecked")
  public List<Partita> leggiPartita(long numeroArticolo) throws ImpossibileLeggerePartitaException {

    DetachedCriteria criteria = DetachedCriteria.forClass(Partita.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("partitaId.legalEntity", legalEntity));
    conj.add(Restrictions.eq("partitaId.organizationUnit", organizationUnit));
    // conj.add(Restrictions.eq("partitaId.codiceConto", codiceConto));
    conj.add(Restrictions.eq("numeroArticolo", numeroArticolo));

    criteria.add(conj);
    try {

      return (List<Partita>) getHibernateTemplate().findByCriteria(criteria);
View Full Code Here

  }

  @SuppressWarnings("unchecked")
  public List<Conto> leggiConto(long conto) throws ImpossibileCercareContoException {
    DetachedCriteria criteria = DetachedCriteria.forClass(Conto.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("contoId.legalEntity", legalEntity));
    conj.add(Restrictions.eq("contoId.organizationUnit", organizationUnit));
    conj.add(Restrictions.eq("pianoDeiConti.codiceConto", conto));
    criteria.add(conj);
    try {
      return (List<Conto>) getHibernateTemplate().findByCriteria(criteria);
    } catch (DataAccessException e) {
      throw new ImpossibileCercareContoException();
View Full Code Here

  @SuppressWarnings("unchecked")
  public List<DettaglioCausaleOperazione> leggiDettagliCausaleOperazione(String codiceCausaleOperazione)
      throws ImpossibileLeggereDettagliCausaleException {
    DetachedCriteria criteria = DetachedCriteria.forClass(DettaglioCausaleOperazione.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("dettaglioCausaleOperazioneId.legalEntity", legalEntity));
    conj.add(Restrictions.eq("dettaglioCausaleOperazioneId.organizationUnit", organizationUnit));
    conj.add(Restrictions.eq("dettaglioCausaleOperazioneId.codiceCausaleOperazione", codiceCausaleOperazione));
    criteria.add(conj);
    try {
      return (List<DettaglioCausaleOperazione>) getHibernateTemplate().findByCriteria(criteria);
    } catch (DataAccessException e) {
      throw new ImpossibileLeggereDettagliCausaleException();
View Full Code Here

      DetachedCriteria datifinCriteria = null;
      // DetachedCriteria mutuoCriteria = null;
      // Conjunction andsDatifin = Restrictions.conjunction();
      // Conjunction andsMutuo = null;
      Conjunction andsDatifin = null;
      Conjunction andsMutuo = Restrictions.conjunction();

      for (SearchCriteria sc : sclp.getSearchCriteriaList()) {

        SimpleExpression simpleExpression = sc.getSimpleExpression();
        if (sc.getValore() instanceof String)
          simpleExpression.ignoreCase();
        if (((SearchCriteriaWithEntity) sc).getEntity() == GruppoDatiFinanziari.class) {
          // Aggiungo condizioni di and alla subquery dei mutui
          if (datifinCriteria == null) {
            datifinCriteria = DetachedCriteria.forClass(GruppoDatiFinanziari.class);
            datifinCriteria.setProjection(Projections.property("mutuo"));
          }
          if (andsDatifin == null) {
            andsDatifin = Restrictions.conjunction();
          }
          andsDatifin.add(simpleExpression);

        } else if (((SearchCriteriaWithEntity) sc).getEntity() == Mutuo.class) {
          // Aggiungo condizioni di and sui Datifin
          andsMutuo.add(simpleExpression);
        }

        if (andsDatifin != null) {
          andsDatifin.add(Restrictions.isNull("dataFineValidita"));
          datifinCriteria.add(andsDatifin);
          andsMutuo.add(Subqueries.propertyIn("numeroMutuo", datifinCriteria));
        }

        ors.add(andsMutuo);
      }
View Full Code Here

  @SuppressWarnings("unchecked")
  public Penale getPenaleEstinzione(Long numeroMutuo, Date dataMassima) throws PenaleEstinzioneNonPresente {

    DetachedCriteria criteria = DetachedCriteria.forClass(Penale.class);

    Conjunction and = Restrictions.conjunction();
    and.add(Restrictions.eq("mutuo.numeroMutuo", numeroMutuo));
    and.add(Restrictions.le("dataInizioValidita", dataMassima));
    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.isNull("dataFineValidita"));
    or.add(Restrictions.ge("dataFineValidita", dataMassima));
    and.add(or);
    criteria.add(and);
    List<Penale> result = new ArrayList<Penale>();
    result = (List<Penale>) getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0) {
      return result.get(0);
View Full Code Here

  }

  @SuppressWarnings("unchecked")
  public StatoMutuo getStatoMutuo(int codiceStato) {
    DetachedCriteria criteria = DetachedCriteria.forClass(StatoMutuo.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    conj.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    conj.add(Restrictions.eq("codiceStato", codiceStato));
    criteria.add(conj);

    List<StatoMutuo> result = (List<StatoMutuo>) getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0)
      return result.get(0);
View Full Code Here

  @Override
  @SuppressWarnings("unchecked")
  public List<Long> getPraticheLegateA(long numeroSoggetto) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Legame.class);
    Conjunction and = Restrictions.conjunction();
    and.add(Restrictions.eq("numeroSoggetto", numeroSoggetto));

    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.eq("codiceRapporto", CodiceRapporto.CODICE_RAPPORTO_MUTUATARIO.getValue()));
    or.add(Restrictions.eq("codiceRapporto", CodiceRapporto.CODICE_RAPPORTO_GARANTE.getValue()));
    and.add(or);

    criteria.add(and);

    List<Legame> listaMutui = getHibernateTemplate().findByCriteria(criteria);
    List<Long> listaMutuiToReturn = new ArrayList<Long>();
View Full Code Here

TOP

Related Classes of org.hibernate.criterion.Conjunction

Copyright © 2018 www.massapicom. All rights reserved.
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.