Package systextil.integracao.dao

Class GenericDao

java.lang.Object
systextil.integracao.dao.GenericDao
Direct Known Subclasses:
EtapasDao, LiberadoresDao, NotasDao, RoteirosDao
public class GenericDao extends Object

  • Constructor Details

    • GenericDao

      public GenericDao()

  • Method Details

    • removeAcentos

      public static String removeAcentos(String text)

    • excluiIpiIcmsOutros

      public static boolean excluiIpiIcmsOutros(br.com.intersys.systextil.connection.AppConnection conn, Integer empresaMdi, Integer natuOper, String estNatuOper)

    • atlzUltimoPreco

      public static void atlzUltimoPreco(br.com.intersys.systextil.connection.AppConnection conn, double valorUnit, CodProduto prod)

    • getCodProdBasi010

      public static CodProduto getCodProdBasi010(br.com.intersys.systextil.connection.AppConnection conn, String codBarras)

    • getAviamentoProd

      public static String getAviamentoProd(br.com.intersys.systextil.connection.AppConnection conn, String nivel, String grupo)

    • getTpProdutoSped

      public static int getTpProdutoSped(br.com.intersys.systextil.connection.AppConnection conn, int conta_estoque)

    • getFatorConvBasi200

      public static double getFatorConvBasi200(br.com.intersys.systextil.connection.AppConnection conn, String unidadeConv)

    • existsClassificFiscal

      public static boolean existsClassificFiscal(br.com.intersys.systextil.connection.AppConnection conn, String classificFiscal)

    • listExistsClassificFiscal

      public static HashMap<String,Boolean> listExistsClassificFiscal(br.com.intersys.systextil.connection.AppConnection conn, String listaClassificsFiscalFiltro)

    • existsCfopConsignado

      public static boolean existsCfopConsignado(br.com.intersys.systextil.connection.AppConnection conn, String cfop)

    • listCfopConsignado

      public static ArrayList<String> listCfopConsignado(br.com.intersys.systextil.connection.AppConnection conn)

    • existsCfopDevolVenda

      public static boolean existsCfopDevolVenda(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, String cfop)

    • existsExcecaoCfopAliquotaIcms

      public static boolean existsExcecaoCfopAliquotaIcms(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, CNPJ cnpj, String cfopItem, double aliquotaIcmsItem)

    • getCodProdExcecaoCfopAliquotaIcms

      public static CodProduto getCodProdExcecaoCfopAliquotaIcms(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, String cfopItem, double aliquotaIcmsItem)

    • getNaturezaExcecaoCfopAliquotaIcms

      public static int getNaturezaExcecaoCfopAliquotaIcms(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, String cfopItem, double aliquotaIcmsItem)

    • listCfopDevolVenda

      public static ArrayList<String> listCfopDevolVenda(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • existsCfopRetornoIndus

      public static boolean existsCfopRetornoIndus(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, String cfop)

    • usaNotaReferenciada

      public static boolean usaNotaReferenciada(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • existsCfopRemessaIndus

      public static String existsCfopRemessaIndus(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, String cfop)

    • getIpi

      public static ImpostoNotaItem getIpi(br.com.intersys.systextil.connection.AppConnection conn, String classificFiscal)

    • getPlanoDeContas

      public static int getPlanoDeContas(br.com.intersys.systextil.connection.AppConnection conn, int emp, int exercicio)

    • getHistCanc

      public static int getHistCanc(br.com.intersys.systextil.connection.AppConnection conn, int plano_cta)

    • updateSitBloqueio

      public static void updateSitBloqueio(br.com.intersys.systextil.connection.AppConnection conn, int documento, CNPJ cnpj, int tipoTitulo, String parcela)

    • isPosicaoDuplic

      public static boolean isPosicaoDuplic(br.com.intersys.systextil.connection.AppConnection conn, int posicaoTitulo)

    • getDtPeriodoEstq

      public static Date getDtPeriodoEstq(br.com.intersys.systextil.connection.AppConnection conn)

    • getFlagFechamento

      public static int getFlagFechamento(br.com.intersys.systextil.connection.AppConnection conn)

    • listTransacoesAtualizaEstoque

      public static HashMap<Integer,Integer> listTransacoesAtualizaEstoque(br.com.intersys.systextil.connection.AppConnection conn, String transacoesFiltro)

    • getQtdeVendidaRecur

      public static double getQtdeVendidaRecur(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, int numNota, String serie, CodProduto prod)

    • sqlNfItemDevolSemNf

      public static String sqlNfItemDevolSemNf()

    • sqlNfItemDevolSemNfSemCd

      public static String sqlNfItemDevolSemNfSemCd()

    • sqlNfSemProd

      public static String sqlNfSemProd()

    • sqlSaldoItemNfSemProdRefer

      public static String sqlSaldoItemNfSemProdRefer()

    • sqlItemNfSemProdRefer

      public static String sqlItemNfSemProdRefer()

    • sqlItemNfProdRefer

      public static String sqlItemNfProdRefer()

    • sqlItemNfProdReferSemCd

      public static String sqlItemNfProdReferSemCd()

    • sqlItemIndustrial

      public static String sqlItemIndustrial()

    • sqlItemNfNaoRelacionada

      public static String sqlItemNfNaoRelacionada()

    • getCodEmpresa

      public static int getCodEmpresa(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj)

    • getBloqueiaTitulo

      public static int getBloqueiaTitulo(br.com.intersys.systextil.connection.AppConnection conn, int empresa)

    • getGeraContabil

      public static int getGeraContabil(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • getGeraContabil

      public static int getGeraContabil(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, int geraContabil)

    • getCodMatriz

      public static int getCodMatriz(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • getCaracterSerie

      public static String getCaracterSerie(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • getImportaEanXml

      public static String getImportaEanXml(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • getValorMaximoPagamento

      public static double getValorMaximoPagamento(br.com.intersys.systextil.connection.AppConnection conn, Date dataVencimento)

    • isLiberado

      public static boolean isLiberado(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int documento, String parcela, int tipoTitulo, CNPJ cnpj)

    • updateICpag010FlagImportacao

      public static void updateICpag010FlagImportacao(br.com.intersys.systextil.connection.AppConnection conn, int flag, int codEmpresa, int documento, String serie, CNPJ cnpj)

    • updateICpag010NumContabil

      public static void updateICpag010NumContabil(br.com.intersys.systextil.connection.AppConnection conn, int numContabil, int codEmpresa, int documento, String serie, CNPJ cnpj)

    • calcularPrecoCustoItem

      public static double calcularPrecoCustoItem(br.com.intersys.systextil.connection.AppConnection conn, double vlrIcms, double vlrRateioDespesas, double vlrTotalItem, double vlrPis, double vlrCofins, double vlrIpi, double vlrDifAliquota, CodProduto produto, int subtrairIcmsCusto, int codEmpresa)

    • deleteICpag010

      public static void deleteICpag010(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int documento, String serie, CNPJ cgc)

    • exists

      public static boolean exists(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cgc, String chave)

    • exists

      public static boolean exists(br.com.intersys.systextil.connection.AppConnection conn, String chave)

    • updateIObrf010FlagImportacao

      public static void updateIObrf010FlagImportacao(br.com.intersys.systextil.connection.AppConnection conn, int flag, int idReg, int numLctoCtb)

    • deleteIObrf010

      public static void deleteIObrf010(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int documento, String serie, CNPJ cgc)

    • getStatusNf

      public static String getStatusNf(br.com.intersys.systextil.connection.AppConnection conn, String chave)

    • updateIObrf015FlagImportacao

      public static void updateIObrf015FlagImportacao(br.com.intersys.systextil.connection.AppConnection conn, int flag, int documento, String serie, CNPJ cnpj)

    • isItemPedSeq

      public static int isItemPedSeq(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ forn, int pedido, int seqPedido)

    • getFirstPedido

      public static int getFirstPedido(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cnpj)

    • getSumValorIpi

      public static double getSumValorIpi(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cnpj)

    • deleteIObrf015OrigXml

      public static void deleteIObrf015OrigXml(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cgc)

    • deleteIObrf015

      public static void deleteIObrf015(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cgc)

    • updateIObrf016FlagImportacao

      public static void updateIObrf016FlagImportacao(br.com.intersys.systextil.connection.AppConnection conn, int flag, int codEmpresa, int documento, String serie)

    • deleteIObrf016

      public static void deleteIObrf016(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int documento, String serie, CNPJ cgc)

    • existsObrf010

      public static boolean existsObrf010(br.com.intersys.systextil.connection.AppConnection conn, String chaveNf)

    • getUsuarioDigitacaoCapa

      public static String getUsuarioDigitacaoCapa(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cnpj)

    • getHistContabil

      public static int getHistContabil(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int documento, String serie, CNPJ cnpj)

    • updateNumContabil

      public static void updateNumContabil(br.com.intersys.systextil.connection.AppConnection conn, int numLctoContabil, int documento, String serie, CNPJ cnpj)

    • deleteObrf010

      public static void deleteObrf010(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cnpj)

    • deleteObrf015

      public static void deleteObrf015(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cnpj)

    • deleteObrf016

      public static void deleteObrf016(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie)

    • isDivergencia

      public static boolean isDivergencia(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int documento, String serie, CNPJ cnpj)

    • getEspecie

      public static String getEspecie(br.com.intersys.systextil.connection.AppConnection conn, String modeloDocumento)

    • insertObrf275

      public static void insertObrf275(br.com.intersys.systextil.connection.AppConnection conn, Nota nota, NotaFiscalDeSaidaItem itemNfs, NotaFiscalDeSaida nfVenda, double qtdeDevol, double qtdeJaDevol, double qtdeSaldoAdevol, int seqItemNfXml)

    • insertObrf275Recur

      public static void insertObrf275Recur(br.com.intersys.systextil.connection.AppConnection conn, Nota nota, int seqNotaXml, int codEmprVenda, int numNotaVenda, String serieVenda, int seqNotaVenda, double qtdeVenda, CodProduto prod, double qtdeDevol, double qtdeJaDevol, double qtdeSaldoAdevol, double vlrUnitVenda)

    • getConsideraDupXml

      public static String getConsideraDupXml(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa)

    • itemMaisDeUmaNota

      public static boolean itemMaisDeUmaNota(br.com.intersys.systextil.connection.AppConnection conn, String chaveDanfe, CodProduto prod)

    • getNatOperOper279

      public static int getNatOperOper279(br.com.intersys.systextil.connection.AppConnection conn, int cod_empresa, String cfop, int tpProdutoSped, String regimeFornec, int padrao)

    • isOper281

      public static boolean isOper281(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • isOper281

      public static boolean isOper281(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, String tipoAviamento)

    • getTransacaoNatOper

      public static int getTransacaoNatOper(br.com.intersys.systextil.connection.AppConnection conn, int naturOperacao, String estadoNatoper)

    • getEmiteDuplicata

      public static int getEmiteDuplicata(br.com.intersys.systextil.connection.AppConnection conn, int naturOperacao, String estadoNatoper)

    • getNomeFornecedor

      public static String getNomeFornecedor(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj)

    • getTipoPagamentoForn

      public static int getTipoPagamentoForn(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj)

    • getCodContFornecedor

      public static int getCodContFornecedor(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj)

    • getOptanteSimples

      public static String getOptanteSimples(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj, String padrao)

    • getFatorConvSupr060

      public static double getFatorConvSupr060(br.com.intersys.systextil.connection.AppConnection conn, String coditemNivel99, String coditemGrupo, String coditemSubgrupo, String coditemItem, CNPJ cnpj, String unidadeConv, int codEmpresa)

    • getOperCalcSupr060

      public static String getOperCalcSupr060(br.com.intersys.systextil.connection.AppConnection conn, String coditemNivel99, String coditemGrupo, String coditemSubgrupo, String coditemItem, CNPJ cnpj, String unidadeConv, int codEmpresa)

    • encontraFatorConversao

      public static double encontraFatorConversao(br.com.intersys.systextil.connection.AppConnection conn, String coditemNivel99, String coditemGrupo, String coditemSubgrupo, String coditemItem, CNPJ cnpj, String unidadeConv, int codEmpresa)

    • listCodProdutoSupr060

      public static HashMap<String,CodProduto> listCodProdutoSupr060(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj, List<String> listaReferenciasFornXml, int cad_produto_x_fornecedor, int codEmpresa)

    • getCodProdutoSupr060Pedido

      public static int getCodProdutoSupr060Pedido(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj, String referenciaXml, int cad_produto_x_fornecedor, int codEmpresa)

    • getCodProdutoSupr060SeqPedido

      public static int getCodProdutoSupr060SeqPedido(br.com.intersys.systextil.connection.AppConnection conn, int numPedido, CNPJ cnpj, String referenciaXml, int cad_produto_x_fornecedor, int codEmpresa)

    • insertSupr060

      public static void insertSupr060(br.com.intersys.systextil.connection.AppConnection conn, String coditemNivel99, String coditemGrupo, String coditemSubgrupo, String coditemItem, CNPJ cnpj, String referenciaForn, double fatorConv, String umForn)

    • getCondPgtoPedido

      public static int getCondPgtoPedido(br.com.intersys.systextil.connection.AppConnection conn, int pedido)

    • getPortadorPedido

      public static int getPortadorPedido(br.com.intersys.systextil.connection.AppConnection conn, int pedidoCompra)

    • existsPedidoCompra

      public static boolean existsPedidoCompra(br.com.intersys.systextil.connection.AppConnection conn, int pedido, CNPJ cnpj, int codEmpresa)

    • getPedidoCompra

      public static int getPedidoCompra(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj, int codEmpresa)

    • updateFlagItens

      public static void updateFlagItens(br.com.intersys.systextil.connection.AppConnection conn, String chaveNf, int idItemOriginal)

    • getTpProdutoSpedEmpresa

      public static int getTpProdutoSpedEmpresa(br.com.intersys.systextil.connection.AppConnection conn, int cod_empresa, int conta_estoque, String nivel, String grupo, String subGru, String item, int tpProdSped)

    • deletaNota

      public static void deletaNota(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int documento, String serie, CNPJ cgc)

    • getConsideraParametroCompras

      public static int getConsideraParametroCompras(br.com.intersys.systextil.connection.AppConnection conn, int cod_empresa)

    • getNatOperProdSped

      public static int getNatOperProdSped(br.com.intersys.systextil.connection.AppConnection conn, int cod_empresa, String cfop, CNPJ cnpj, int tpProdSped)

    • getTpProdSped

      public static int getTpProdSped(br.com.intersys.systextil.connection.AppConnection conn, int cod_empresa, CodProduto produto)

    • getCondPagtoCompra

      public static int getCondPagtoCompra(br.com.intersys.systextil.connection.AppConnection conn)

    • atualizaRequisicaoAumox

      public static void atualizaRequisicaoAumox(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa, String nivelEstrutura, String grupoEstrutura, String subgruEstrutura, String itemEstrutura, int numPedCompra, int seqItemPedido, String usuario, double qtdEntregue)

    • getNumContabNf

      public static int getNumContabNf(br.com.intersys.systextil.connection.AppConnection conn, int documento, String serie, CNPJ cnpj)

    • getSaldoDevolvido

      public static double getSaldoDevolvido(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida nota, NotaFiscalDeSaidaItem itemNfs, CodProduto prod)

    • getSaldoDevolvidoRecur

      public static double getSaldoDevolvidoRecur(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cgc, int num_nota_fiscal, String serie, int sequencia, CodProduto prod, int codigo_empresa)

    • getSaldoDevolvidoForm

      public static double getSaldoDevolvidoForm(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cgc, int num_nota_fiscal, String serie, int sequencia, CodProduto prod, int codigo_empresa, int notaEntr, String serieEntr, int seqEntr)

    • listSaldosDevolvidos

      public static HashMap<String,Double> listSaldosDevolvidos(br.com.intersys.systextil.connection.AppConnection conn, CNPJ clienteFornecedor, String numerosDanfesNFsReferenciadas)

    • listNaturezasDeOperacao

      public static ArrayList<NaturezaDeOperacao> listNaturezasDeOperacao(br.com.intersys.systextil.connection.AppConnection conn, ArrayList<Integer> naturezasDeOperacao, String ufEmit)

    • insereObrf074

      public static void insereObrf074(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeEntradaIntegracao capa, NotaFiscalDeEntradaIntegracaoItem item)

    • usaReferenciaFornecedor

      public static boolean usaReferenciaFornecedor(br.com.intersys.systextil.connection.AppConnection conn, int codEmpresa)

    • getTipoChavePix

      public static String getTipoChavePix(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj)

    • getChavePix

      public static String getChavePix(br.com.intersys.systextil.connection.AppConnection conn, CNPJ cnpj)

    • sqlBuscaNotaOrigPorEan

      public static String sqlBuscaNotaOrigPorEan()

    • itemComNotaOrigem

      public static boolean itemComNotaOrigem(List<NotaFiscalDeEntradaIntegracaoItem> itens)

    • deleteCpag010

      public static void deleteCpag010(br.com.intersys.systextil.connection.AppConnection conn, int documento, String parcela, CNPJ cnpjCli, int tipoTitulo)

    • sqlBuscaNotaOrigPorSKU

      public static String sqlBuscaNotaOrigPorSKU()

    • updateNotaOrigem

      public static void updateNotaOrigem(br.com.intersys.systextil.connection.AppConnection conn, int numNotaOrig, String serieNotaOrig, int seqNotaOrig, int documento, String serie, int sequencia, CNPJ cgc, String coditemNivel99, String coditemGrupo, String coditemSubgrupo, String coditemItem, String descricao)

    • buscaNotaOrigPorDesc

      public static String buscaNotaOrigPorDesc()