Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Preco = null;
- PermitirAlteracao = null;
- ExternalID = null;
- PrecoAnterior = null;
- ExternalID = targetNode.getExternalId();
- Preco = sqlTemplate.queryForString("SELECT preco FROM grid_produtos WHERE loja = ? and produtos_id = ?", new Object[] {ExternalID, ID});
- PermitirAlteracao = sqlTemplate.queryForString("SELECT permitir_alteracao FROM grid_produtos WHERE loja = ? and produtos_id = ?", new Object[] {ExternalID, ID});
- PrecoAnterior = sqlTemplate.queryForString("SELECT preco FROM produtos WHERE id = ?", new Object[] {ID});
- int PermitirAlteracao = Integer.parseInt(PermitirAlteracao);
- if(PermitirAlteracao == 1){
- return PrecoAnterior;
- }
- if( Preco != null ){
- return Preco;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement