Examples with SQLBuilder it.cnr.jada.persistency.sql.SQLBuilder used on opensource projects

Example 1 with SQLBuilder

use of it.cnr.jada.persistency.sql.SQLBuilder in project sigla-main by consiglionazionaledellericerche.

the class Scrittura_partita_doppiaHome method findByDocumentoCoge.

public List<Scrittura_partita_doppiaBulk> findByDocumentoCoge(IDocumentoCogeBulk documentoCogeBulk) throws PersistencyException {
    SQLBuilder sql = this.createSQLBuilder();
    sql.addClause("AND", "esercizio", SQLBuilder.EQUALS, documentoCogeBulk.getEsercizio());
    sql.addClause("AND", "cd_cds_documento", SQLBuilder.EQUALS, documentoCogeBulk.getCd_cds());
    sql.addClause("AND", "cd_uo_documento", SQLBuilder.EQUALS, documentoCogeBulk.getCd_uo());
    sql.addClause("AND", "pg_numero_documento", SQLBuilder.EQUALS, documentoCogeBulk.getPg_doc());
    sql.addClause("AND", "cd_tipo_documento", SQLBuilder.EQUALS, documentoCogeBulk.getCd_tipo_doc());
    return fetchAll(sql);
}

Example 2 with SQLBuilder

use of it.cnr.jada.persistency.sql.SQLBuilder in project sigla-main by consiglionazionaledellericerche.

the class Classificazione_voci_ep_pat_liv1Home method selectByClause.

public SQLBuilder selectByClause(UserContext usercontext, CompoundFindClause compoundfindclause) throws PersistencyException {
    SQLBuilder sql = super.selectPat(usercontext, compoundfindclause);
    sql.addSQLClause("AND", "cd_livello1", SQLBuilder.ISNOTNULL, null);
    sql.addSQLClause("AND", "cd_livello2", SQLBuilder.ISNULL, null);
    return sql;
}

Example 3 with SQLBuilder

use of it.cnr.jada.persistency.sql.SQLBuilder in project sigla-main by consiglionazionaledellericerche.

the class Classificazione_voci_ep_pat_liv2Home method selectByClause.

public SQLBuilder selectByClause(UserContext usercontext, CompoundFindClause compoundfindclause) throws PersistencyException {
    SQLBuilder sql = super.selectPat(usercontext, compoundfindclause);
    sql.addSQLClause("AND", "cd_livello2", SQLBuilder.ISNOTNULL, null);
    sql.addSQLClause("AND", "cd_livello3", SQLBuilder.ISNULL, null);
    return sql;
}

Example 4 with SQLBuilder

use of it.cnr.jada.persistency.sql.SQLBuilder in project sigla-main by consiglionazionaledellericerche.

the class Classificazione_voci_ep_pat_liv4Home method selectByClause.

public SQLBuilder selectByClause(UserContext usercontext, CompoundFindClause compoundfindclause) throws PersistencyException {
    SQLBuilder sql = super.selectPat(usercontext, compoundfindclause);
    sql.addSQLClause("AND", "cd_livello4", SQLBuilder.ISNOTNULL, null);
    sql.addSQLClause("AND", "cd_livello5", SQLBuilder.ISNULL, null);
    return sql;
}

Example 5 with SQLBuilder

use of it.cnr.jada.persistency.sql.SQLBuilder in project sigla-main by consiglionazionaledellericerche.

the class Classificazione_voci_ep_pat_liv5Home method selectByClause.

public SQLBuilder selectByClause(UserContext usercontext, CompoundFindClause compoundfindclause) throws PersistencyException {
    SQLBuilder sql = super.selectPat(usercontext, compoundfindclause);
    sql.addSQLClause("AND", "cd_livello5", SQLBuilder.ISNOTNULL, null);
    sql.addSQLClause("AND", "cd_livello6", SQLBuilder.ISNULL, null);
    return sql;
}