Package org.hibernate.criterion

Examples of org.hibernate.criterion.Conjunction


  @SuppressWarnings("unchecked")
  public List<MovimentoContabile> cercaMovimentiContabiliByCodiceConto(long codiceConto)
      throws ImpossibileCercareMovimentoContabileException {
    DetachedCriteria criteria = DetachedCriteria.forClass(MovimentoContabile.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("pianoDeiConti.codiceConto", codiceConto));
    conj.add(Restrictions.ne("tipoMovimento", "E"));
    conj.add(Restrictions.ne("tipoMovimento", "X"));
    conj.add(Restrictions.eq("legalEntity", legalEntity));
    conj.add(Restrictions.eq("organizationUnit", organizationUnit));
    criteria.add(conj);
    try {
      return (List<MovimentoContabile>) getHibernateTemplate().findByCriteria(criteria);
    } catch (DataAccessException e) {
      log("Impossibile Cercare Movimento Contabile [CODICECONTO] " + codiceConto);
View Full Code Here


  @SuppressWarnings("unchecked")
  public List<MovimentoContabile> leggiArticolo(long numeroArticolo)
      throws ImpossibileCercareMovimentoContabileException {
    DetachedCriteria criteria = DetachedCriteria.forClass(MovimentoContabile.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("movimentoContabileId.numeroArticolo", numeroArticolo));
    criteria.add(conj);
    try {
      return (List<MovimentoContabile>) getHibernateTemplate().findByCriteria(criteria);
    } catch (DataAccessException e) {
      log("Impossibile Cercare Movimento Contabile [NUMEROARTICOLO] " + numeroArticolo);
View Full Code Here

  @SuppressWarnings("unchecked")
  public Date getMaxDataValutaPartite(Long conto, Integer numeroPam, String tipoPam, Integer progressivoRata) {
    Date dataValuta = null;
    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", conto.intValue()));
    conj.add(Restrictions.eq("numeroPam", numeroPam));
    conj.add(Restrictions.eq("tipoPam", tipoPam));
    conj.add(Restrictions.eq("progressivoRata", progressivoRata));

    criteria.setProjection(Projections.max("dataValuta"));
    criteria.add(conj);
    List<?> result = getHibernateTemplate().findByCriteria(criteria);
View Full Code Here

  @SuppressWarnings("unchecked")
  public Date getMaxDataRegistrazionePartite(Long conto, Integer numeroPam, String tipoPam, Integer progressivoRata) {
    Date dataRegistrazione = null;
    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", conto.intValue()));
    conj.add(Restrictions.eq("numeroPam", numeroPam));
    conj.add(Restrictions.eq("tipoPam", tipoPam));
    conj.add(Restrictions.eq("progressivoRata", progressivoRata));

    criteria.setProjection(Projections.max("dataRegistrazione"));
    criteria.add(conj);
    List<?> result = getHibernateTemplate().findByCriteria(criteria);
View Full Code Here

    // ( MOVCONT.CG01_TP_MOVIMENTO <> 'E' )
    // GROUP BY MOVCONT.CG01_DT_REG,
    // MOVCONT.CG01_COD_SOCIETA_VEICOLO

    DetachedCriteria criteria = DetachedCriteria.forClass(MovimentoContabile.class);
    Conjunction conj = Restrictions.conjunction();

    conj.add(Restrictions.gt("dataRegistrazione", dataRegistrazioneDal));
    conj.add(Restrictions.le("dataRegistrazione", dataRegistrazioneAl));
    conj.add(Restrictions.ne("tipoMovimento", tipoMovimento));
    conj.add(Restrictions.eq("legalEntity", legalEntity));
    conj.add(Restrictions.eq("organizationUnit", organizationUnit));
    criteria.add(conj);

    ProjectionList proList = Projections.projectionList();
    proList.add(Projections.groupProperty("dataRegistrazione"));
    proList.add(Projections.groupProperty("codiceSocietaVeicolo"));
View Full Code Here

  @SuppressWarnings("unchecked")
  public List<Partita> cercaPartitaConTipoPamValorizzato(long codiceConto, String tipoConto, int progressivoPartita)
      throws ImpossibileCercarePartitaException {
    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("partitaId.tipoConto", tipoConto));
    conj.add(Restrictions.eq("partitaId.progressivoPartita", progressivoPartita));
    conj.add(Restrictions.isNotNull("tipoPam"));

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

  @SuppressWarnings("unchecked")
  public List<Partita> cercaPartita(long codiceConto, String tipoConto, String tipoPam, Long numeroPam,
      Integer progressivoRata) throws ImpossibileCercarePartitaException {
    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("partitaId.tipoConto", tipoConto));
    conj.add(Restrictions.eq("tipoPam", tipoPam));
    conj.add(Restrictions.eq("numeroPam", numeroPam));
    conj.add(Restrictions.eq("progressivoRata", progressivoRata));

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

  @SuppressWarnings("unchecked")
  public List<Partita> cercaPartita(long codiceConto, long numeroPam, Integer progressivoRata)
      throws ImpossibileCercarePartitaException {
    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("numeroPam", numeroPam));
    conj.add(Restrictions.eq("progressivoRata", progressivoRata));

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

  }

  @SuppressWarnings("unchecked")
  public List<Partita> cercaPartita(long codiceConto, String tipoConto) throws ImpossibileCercarePartitaException {
    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("partitaId.tipoConto", tipoConto));

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

  @SuppressWarnings("unchecked")
  public List<Partita> cercaPartita(long codiceConto, String tipoConto, int progressivoPartita)
      throws ImpossibileCercarePartitaException {
    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("partitaId.tipoConto", tipoConto));
    conj.add(Restrictions.eq("partitaId.progressivoPartita", progressivoPartita));

    criteria.add(conj);
    try {
      return (List<Partita>) getHibernateTemplate().findByCriteria(criteria);
    } catch (DataAccessException e) {
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.