Example usage for org.hibernate.criterion Restrictions ne

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ne.

Prototype

public static SimpleExpression ne(String propertyName, Object value) 

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:com.bakeryfactory.cadastros.servidor.CargoDetalheAction.java

License:Open Source License

private Response update(Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request,
        HttpServletResponse response, HttpSession userSession, ServletContext context) {
    Session session = null;/*from   ww w . j a  v  a 2 s .  com*/
    try {
        Object[] pars = (Object[]) inputPar;
        CargoVO cargo = (CargoVO) pars[2];

        session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();

        Criteria criteria = session.createCriteria(ClienteVO.class);
        criteria.add(Restrictions.eq("empresa", cargo.getEmpresa()));
        criteria.add(Restrictions.ne("id", cargo.getId()));

        session.update(cargo);
        session.getTransaction().commit();

        return new VOResponse(cargo);

    } catch (Exception ex) {
        ex.printStackTrace();
        if (session != null) {
            session.getTransaction().rollback();
        }
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }
}

---

From source file:com.bakeryfactory.cadastros.servidor.ClienteDetalheAction.java

License:Open Source License

private Response update(Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request,
        HttpServletResponse response, HttpSession userSession, ServletContext context) {
    Session session = null;//  w  w  w  . j  a  va 2  s. com
    try {
        Object[] pars = (Object[]) inputPar;
        ClienteVO cliente = (ClienteVO) pars[2];

        session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();

        Criteria criteria = session.createCriteria(ClienteVO.class);
        criteria.add(Restrictions.eq("pessoa", cliente.getPessoa()));
        criteria.add(Restrictions.ne("id", cliente.getId()));

        if (criteria.uniqueResult() != null) {
            throw new Exception("J existe um Cliente vinculado  pessoa selecionada.");
        }

        if (cliente.getContabilConta().getId() == null) {
            cliente.setContabilConta(null);
        }

        if (cliente.getTributOperacaoFiscal().getId() == null) {
            cliente.setTributOperacaoFiscal(null);
        }

        session.update(cliente);

        session.getTransaction().commit();

        return new VOResponse(cliente);

    } catch (Exception ex) {
        if (session != null) {
            session.getTransaction().rollback();
        }
        ex.printStackTrace();
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }
}

---

From source file:com.bakeryfactory.cadastros.servidor.ColaboradorDetalheAction.java

License:Open Source License

private Response update(Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request,
        HttpServletResponse response, HttpSession userSession, ServletContext context) {
    Session session = null;//  ww w  .  j a  va  2 s . co  m
    try {
        Object[] pars = (Object[]) inputPar;
        ColaboradorVO colaborador = (ColaboradorVO) pars[2];

        session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();

        Criteria criteria = session.createCriteria(ColaboradorVO.class);
        criteria.add(Restrictions.eq("pessoa", colaborador.getPessoa()));
        criteria.add(Restrictions.ne("id", colaborador.getId()));

        if (criteria.uniqueResult() != null) {
            throw new Exception("J existe um Colaborador vinculado  pessoa selecionada.");
        }

        if (colaborador.getContabilConta().getId() == null) {
            colaborador.setContabilConta(null);
        }

        if (colaborador.getSindicato().getId() == null) {
            colaborador.setSindicato(null);
        }

        if (colaborador.getTipoAdmissao().getId() == null) {
            colaborador.setTipoAdmissao(null);
        }

        session.update(colaborador);

        session.getTransaction().commit();

        return new VOResponse(colaborador);

    } catch (Exception ex) {
        if (session != null) {
            session.getTransaction().rollback();
        }
        ex.printStackTrace();
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }
}

---

From source file:com.bakeryfactory.cadastros.servidor.FornecedorDetalheAction.java

License:Open Source License

private Response update(Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request,
        HttpServletResponse response, HttpSession userSession, ServletContext context) {
    Session session = null;//from   ww  w  .  ja  va2 s .c  om
    try {
        Object[] pars = (Object[]) inputPar;
        FornecedorVO fornecedor = (FornecedorVO) pars[2];

        Criteria criteria = session.createCriteria(FornecedorVO.class);
        criteria.add(Restrictions.eq("pessoa", fornecedor.getPessoa()));
        criteria.add(Restrictions.ne("id", fornecedor.getId()));

        if (criteria.uniqueResult() != null) {
            throw new Exception("J Existe um Fornecedor Vinculado  Pessoa Selecionada!");
        }

        if (fornecedor.getContabilConta().getId() == null) {
            fornecedor.setContabilConta(null);
        }

        session.update(fornecedor);
        session.getTransaction().commit();

        return new VOResponse(fornecedor);

    } catch (Exception ex) {
        ex.printStackTrace();
        if (session != null) {
            session.getTransaction().rollback();
        }
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }
}

---

From source file:com.bakeryfactory.cadastros.servidor.PaisDetalheAction.java

License:Open Source License

private Response update(Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request,
        HttpServletResponse response, HttpSession userSession, ServletContext context) {
    Session session = null;/* ww w. j av  a2s .c o m*/
    try {
        Object[] pars = (Object[]) inputPar;
        FornecedorVO fornecedor = (FornecedorVO) pars[2];

        Criteria criteria = session.createCriteria(FornecedorVO.class);
        criteria.add(Restrictions.eq("pessoa", fornecedor.getPessoa()));
        criteria.add(Restrictions.ne("id", fornecedor.getId()));

        if (criteria.uniqueResult() != null) {
            throw new Exception("J Existe um Fornecedor Vinculado  Pessoa Selecionada!");
        }

        /**
         *  Implementar if(fornecedor.getContabilConta().getId() == null) { fornecedor.setContabilConta(null); }
         */
        fornecedor.setDataCadastro(new Date());

        session.update(fornecedor);
        session.getTransaction().commit();

        return new VOResponse(fornecedor);

    } catch (Exception ex) {
        ex.printStackTrace();
        if (session != null) {
            session.getTransaction().rollback();
        }
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }
}

---

From source file:com.bakeryfactory.cadastros.servidor.PessoaDetalheAction.java

License:Open Source License

public void updateOnTipoPessoa(PessoaVO pessoa, Session session, PessoaFisicaVO pessoaFisica,
        PessoaJuridicaVO pessoaJuridica) throws Exception {
    if (pessoa.getTipo().equals("F")) {
        Criteria criteria = session.createCriteria(PessoaFisicaVO.class);
        criteria.add(Restrictions.eq("cpf", pessoaFisica.getCpf()));
        criteria.add(Restrictions.ne("pessoa", pessoa));
        /* if (criteria.uniqueResult() != null) {
        throw new Exception("O CPF informado j esta cadastrado no Banco de Dados");
         }*/// w  w  w.j a v  a  2 s.c o m
    } else {
        Criteria criteria = session.createCriteria(PessoaJuridicaVO.class);
        criteria.add(Restrictions.eq("cnpj", pessoaJuridica.getCnpj()));
        criteria.add(Restrictions.ne("pessoa", pessoa));
        /* if (criteria.uniqueResult() != null) {
        throw new Exception("O CNPJ informado j esta cadastrado no Banco de Dados");
         }*/
    }
}

---

From source file:com.bakeryfactory.cadastros.servidor.ProdutoDetalheAction.java

License:Open Source License

private Response update(Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request,
        HttpServletResponse response, HttpSession userSession, ServletContext context) {
    Session session = null;//from   w w w .jav a 2s .c  om
    try {
        Object[] pars = (Object[]) inputPar;
        ProdutoVO produto = (ProdutoVO) pars[2];
        List<FichaTecnicaVO> fichaTecnica = (Vector) pars[3];

        session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();

        Criteria criteria = session.createCriteria(ProdutoVO.class);
        criteria.add(Restrictions.eq("gtin", produto.getGtin()));
        criteria.add(Restrictions.ne("id", produto.getId()));

        if (criteria.uniqueResult() != null) {
            throw new Exception("J existe um GTIN vinculado por outro produto.");
        }

        checaProdutoAlmoxarifado(produto);
        checaProdutoMarca(produto);
        checaIcms(produto);
        checaGrupoTributario(produto);

        if (produto.getCaminhoFotoProduto() != null) {
            String caminhoArquivo = context.getRealPath("/imagens") + System.getProperty("file.separator")
                    + "produtos" + System.getProperty("file.separator") + produto.getGtin() + ".jpg";
            produto.setCaminhoFotoProduto(caminhoArquivo);
            Biblioteca.salvaArquivo(caminhoArquivo, produto.getImagem());
        }

        produto.setDataAlteracao(new Date());
        session.update(produto);

        for (FichaTecnicaVO f : fichaTecnica) {
            f.setProduto(produto);
            session.saveOrUpdate(f);
        }

        session.getTransaction().commit();

        return new VOResponse(produto);

    } catch (Exception ex) {
        if (session != null) {
            session.getTransaction().rollback();
        }
        ex.printStackTrace();
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }
}

---

From source file:com.bakeryfactory.cadastros.servidor.TransportadoraDetalheAction.java

License:Open Source License

private Response update(Object inputPar, UserSessionParameters userSessionPars, HttpServletRequest request,
        HttpServletResponse response, HttpSession userSession, ServletContext context) {
    Session session = null;//from  w  w  w . j  av  a  2s. c o  m
    try {
        Object[] pars = (Object[]) inputPar;
        TransportadoraVO transportadora = (TransportadoraVO) pars[2];

        session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();

        Criteria criteria = session.createCriteria(TransportadoraVO.class);
        criteria.add(Restrictions.eq("pessoa", transportadora.getPessoa()));
        criteria.add(Restrictions.ne("id", transportadora.getId()));

        if (criteria.uniqueResult() != null) {
            throw new Exception("J existe um Cliente vinculado  pessoa selecionada.");
        }

        if (transportadora.getContabilConta().getId() == null) {
            transportadora.setContabilConta(null);
        }

        session.update(transportadora);

        session.getTransaction().commit();

        return new VOResponse(transportadora);

    } catch (Exception ex) {
        if (session != null) {
            session.getTransaction().rollback();
        }
        ex.printStackTrace();
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }
    }
}

---

From source file:com.blue.ssh.core.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ??Criterion,.//from  w w  w .jav  a2s  .c  om
 */
protected Criterion buildCriterion(final String propertyName, final Object propertyValue,
        final MatchType matchType) {
    Assert.hasText(propertyName, "propertyName?");
    Criterion criterion = null;
    // ?MatchTypecriterion
    switch (matchType) {
    case EQ:
        criterion = Restrictions.eq(propertyName, propertyValue);
        break;
    case LIKE:
        criterion = Restrictions.like(propertyName, (String) propertyValue, MatchMode.ANYWHERE);
        break;

    case LE:
        criterion = Restrictions.le(propertyName, propertyValue);
        break;
    case LT:
        criterion = Restrictions.lt(propertyName, propertyValue);
        break;
    case GE:
        criterion = Restrictions.ge(propertyName, propertyValue);
        break;
    case GT:
        criterion = Restrictions.gt(propertyName, propertyValue);
    case NE:
        criterion = Restrictions.ne(propertyName, propertyValue);
    }
    return criterion;
}

---

From source file:com.cai310.lottery.web.controller.lottery.SchemeBaseController.java

/**
 * ? ???//from w ww . j  av a 2 s .  c  o  m
 */
protected XDetachedCriteria buildFilterListDetachedCriteria() {
    XDetachedCriteria criteria = new XDetachedCriteria(this.schemeClass, "m");
    criteria.add(Restrictions.eq("m.periodId", this.period.getId()));

    criteria.add(Restrictions.eq("m.shareType", ShareType.TOGETHER));
    if (queryForm != null) {
        // ??
        if (queryForm != null && queryForm.getSecretType() != null) {
            if (queryForm.getSecretType() != SecretType.FULL_PUBLIC) {
                // 
                criteria.add(Restrictions.ne("m.secretType", SecretType.FULL_PUBLIC));
                Struts2Utils.setAttribute("flag", 1);
            }

        } else {
            Struts2Utils.setAttribute("flag", 0);
        }
        if (StringUtils.isNotBlank(queryForm.getSponsorName())) {
            ///?
            if (!"???".equals(queryForm.getSponsorName().trim())) {
                Long schemeId = this.period.getLotteryType().getSchemeId(queryForm.getSponsorName().trim());
                if (schemeId != null) {
                    criteria.add(Restrictions.eq("m.id", schemeId));
                } else {
                    criteria.add(Restrictions.eq("m.sponsorName", queryForm.getSponsorName().trim()));
                }
            }
        }
        if (null != queryForm.getCostType()) {
            queryForm.setMinMaxCost();
        }
        if (null != queryForm.getChooseType()) {
            if (Integer.valueOf(1).equals(queryForm.getChooseType())) {
                // ?
                criteria.add(Restrictions.eq("m.sendToPrint", true));
            } else if (Integer.valueOf(2).equals(queryForm.getChooseType())) {
                // 
                User user = this.getLoginUser();
                if (user != null) {
                    criteria.add(Restrictions.eq("m.sponsorId", user.getId()));
                }
            }
        }
        if (queryForm.getMinSchemeCost() != null)
            criteria.add(Restrictions.ge("m.schemeCost", queryForm.getMinSchemeCost()));

        if (queryForm.getMaxSchemeCost() != null)
            criteria.add(Restrictions.le("m.schemeCost", queryForm.getMaxSchemeCost()));

        if (queryForm.getSchemeState() != null) {
            criteria.add(Restrictions.eq("m.state", queryForm.getSchemeState()));
        }
    }
    if (queryForm != null && queryForm.getOrderType() != null) {
        switch (queryForm.getOrderType()) {
        case CREATE_TIME_DESC:
            criteria.addOrder(Order.desc("m.id"));
            break;
        case CREATE_TIME_ASC:
            criteria.addOrder(Order.asc("m.id"));
            break;
        case PROCESS_RATE_DESC:
            criteria.addOrder(Order.desc("m.progressRate"));
            break;
        case PROCESS_RATE_ASC:
            criteria.addOrder(Order.asc("m.progressRate"));
            break;
        case SCHEME_COST_DESC:
            criteria.addOrder(Order.desc("m.schemeCost"));
            break;
        case SCHEME_COST_ASC:
            criteria.addOrder(Order.asc("m.schemeCost"));
            break;
        }
    } else {
        criteria.addOrder(Order.desc("m.orderPriority"));
        criteria.addOrder(Order.asc("m.state"));
        criteria.addOrder(Order.desc("m.progressRate"));
    }

    Calendar c = Calendar.getInstance();
    c.add(Calendar.HOUR_OF_DAY, 0);
    c.add(Calendar.MINUTE, 0);
    c.add(Calendar.SECOND, 0);
    c.add(Calendar.DAY_OF_MONTH, -10);
    criteria.add(Restrictions.gt("m.createTime", c.getTime()));

    criteria.setMaxResults(50);
    criteria.addOrder(Order.desc("m.id"));
    return criteria;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »