Exemple #1
0
        protected override void carregaDadosBDEspecificos()
        {
            try
            {
                m_cls_dba_ConnectionDB.FonteDosDados = mdlDataBaseAccess.FonteDados.DataBase;

                System.Collections.ArrayList arlCondicoesNome       = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicoesComparador = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicoesValor      = new System.Collections.ArrayList();
                arlCondicoesNome.Add("idExportador");
                arlCondicoesComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicoesValor.Add(m_nIdExportador);
                arlCondicoesNome.Add("idPE");
                arlCondicoesComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicoesValor.Add(m_strCodigo);
                m_typDatSetTbSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicoesNome, arlCondicoesComparador, arlCondicoesValor, null, null);
                if (m_typDatSetTbSaques.tbSaques.Rows.Count > 0)
                {
                    mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaques;
                    for (int nCount = 0; nCount < m_typDatSetTbSaques.tbSaques.Rows.Count; nCount++)
                    {
                        dtrwSaques = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)m_typDatSetTbSaques.tbSaques.Rows[nCount];
                        if (!dtrwSaques.IsnIdIdiomaNull())
                        {
                            m_nIdioma = dtrwSaques.nIdIdioma;
                        }
                    }
                }
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_ter_tratadorErro.trataErro(ref erro);
            }
        }
        public double dCarregaValorSaque()
        {
            double dReturn = 0;

            // Loading data
            System.Collections.ArrayList arlCondicaoCampo      = new System.Collections.ArrayList();
            System.Collections.ArrayList arlCondicaoComparador = new System.Collections.ArrayList();
            System.Collections.ArrayList arlCondicaoValor      = new System.Collections.ArrayList();
            arlCondicaoCampo.Add("idExportador");
            arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
            arlCondicaoValor.Add(m_nIdExportador);
            arlCondicaoCampo.Add("idPe");
            arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
            arlCondicaoValor.Add(m_strPe);
            mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
            if (typDatSetSaques.tbSaques.Rows.Count > 0)
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaques.tbSaques.Rows[0];
                if ((dtrwSaque.IsdValorNull()) || (dtrwSaque.dValor == 0))
                {
                    dReturn          = dValorFaturaSemAntecipado();
                    dtrwSaque.dValor = dReturn;
                    m_cls_dba_ConnectionDB.SetTbSaques(typDatSetSaques);
                }
                else
                {
                    dReturn = dtrwSaque.dValor;
                }
            }
            return(dReturn);
        }
Exemple #3
0
 private void vCarregaDadosDefault()
 {
     mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaque = XsdDatSetSaque();
     if (typDatSetSaque.tbSaques.Rows.Count > 0)
     {
         mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaque.tbSaques.Rows[0];
         vCarregaDadosDefault(ref dtrwSaque);
     }
 }
Exemple #4
0
 private bool bSalvaDados()
 {
     mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaque = XsdDatSetSaque();
     if (typDatSetSaque.tbSaques.Rows.Count == 0)
     {
         return(false);
     }
     mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaque.tbSaques.Rows[0];
     dtrwSaque.mstrDataVencimento = m_strData;
     m_cls_dba_ConnectionDB.SetTbSaques(typDatSetSaque);
     return(m_cls_dba_ConnectionDB.Erro == null);
 }
Exemple #5
0
 private bool bSalvaValorExtensoSaque(string strValorExtenso)
 {
     mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaque = XsdDatSetSaque();
     if (typDatSetSaque.tbSaques.Rows.Count > 0)
     {
         mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaque.tbSaques.Rows[0];
         dtrwSaque.mstrValor = strValorExtenso;
         m_cls_dba_ConnectionDB.SetTbSaques(typDatSetSaque);
         return(m_cls_dba_ConnectionDB.Erro == null);
     }
     else
     {
         return(false);
     }
 }
Exemple #6
0
 private void vCaregaDadosValorExtenso()
 {
     mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaque = XsdDatSetSaque();
     if (typDatSetSaque.tbSaques.Rows.Count > 0)
     {
         mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaque.tbSaques.Rows[0];
         if (!dtrwSaque.IsmstrValorNull())
         {
             m_strValorExtenso = dtrwSaque.mstrValor;
         }
         else
         {
             m_strValorExtenso = this.ValorExtensoDefault;
         }
     }
 }
Exemple #7
0
 private void vCarregaDados()
 {
     mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaque = XsdDatSetSaque();
     if (typDatSetSaque.tbSaques.Rows.Count > 0)
     {
         mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaque.tbSaques.Rows[0];
         if (!dtrwSaque.IsmstrDataVencimentoNull())
         {
             m_strData = dtrwSaque.mstrDataVencimento;
         }
         else
         {
             m_strData = this.DataDefault;
         }
     }
 }
        /// <summary>
        /// Cria o registro do Saque caso necessário
        /// </summary>
        /// <returns></returns>
        private bool bCriaRegistroSaque()
        {
            try
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwRowTbSaques;
                System.Collections.ArrayList arlCondicaoCampo = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoTipo  = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoValor = new System.Collections.ArrayList();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);

                arlCondicaoCampo.Add("idPE");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_strIdCodigo);

                m_cls_dba_ConnectionDB.FonteDosDados = mdlDataBaseAccess.FonteDados.DataBase;
                m_typDatSetTbSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoTipo, arlCondicaoValor, null, null);
                if (m_typDatSetTbSaques.tbSaques.Rows.Count == 0)
                {
                    dtrwRowTbSaques = m_typDatSetTbSaques.tbSaques.NewtbSaquesRow();
                    dtrwRowTbSaques.idExportador  = m_nIdExportador;
                    dtrwRowTbSaques.idPE          = m_strIdCodigo;
                    dtrwRowTbSaques.nIdRelatorio  = 0;
                    dtrwRowTbSaques.dtDataEmissao = System.DateTime.Now.Date;
                    dtrwRowTbSaques.nIdIdioma     = 3;
                    base.Idioma = 3;
                    dtrwRowTbSaques.nImpressoes = 0;
                    m_typDatSetTbSaques.tbSaques.AddtbSaquesRow(dtrwRowTbSaques);
                    m_cls_dba_ConnectionDB.SetTbSaques(m_typDatSetTbSaques);
                    mdlNumero.clsNumero obj = new mdlNumero.Saque.clsSaque(ref m_cls_ter_tratadorErro, ref m_cls_dba_ConnectionDB, m_strEnderecoExecutavel, m_nIdExportador, m_strIdCodigo);
                    obj.salvaDiretoSemMostrarInterface();
                    obj = null;
                    return(true);
                }
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_ter_tratadorErro.trataErro(ref erro);
            }
            return(false);
        }
        protected override bool bSalvaIdRelatorio()
        {
            try
            {
                mdlDataBaseAccess.Tabelas.XsdTbExportadores.tbExportadoresRow dtrwTbExportadores;
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow             dtrwRowTbSaques;
                System.Collections.ArrayList arlCondicaoCampo = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoTipo  = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoValor = new System.Collections.ArrayList();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);

                m_typDatSetTbExportadores = m_cls_dba_ConnectionDB.GetTbExportadores(arlCondicaoCampo, arlCondicaoTipo, arlCondicaoValor, null, null);
                if (m_typDatSetTbExportadores.tbExportadores.Rows.Count > 0)
                {
                    dtrwTbExportadores = (mdlDataBaseAccess.Tabelas.XsdTbExportadores.tbExportadoresRow)m_typDatSetTbExportadores.tbExportadores.Rows[0];
                    dtrwTbExportadores.idRelatorioSaque = m_nIdRelatorio;
                    m_cls_dba_ConnectionDB.SetTbExportadores(m_typDatSetTbExportadores);
                }

                arlCondicaoCampo.Add("idPE");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_strIdCodigo);

                m_cls_dba_ConnectionDB.FonteDosDados = mdlDataBaseAccess.FonteDados.DataBase;
                m_typDatSetTbSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoTipo, arlCondicaoValor, null, null);
                if (m_typDatSetTbSaques.tbSaques.Rows.Count > 0)
                {
                    dtrwRowTbSaques = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)m_typDatSetTbSaques.tbSaques.Rows[0];
                    dtrwRowTbSaques.nIdRelatorio = m_nIdRelatorio;
                    m_cls_dba_ConnectionDB.SetTbSaques(m_typDatSetTbSaques);
                    return(true);
                }
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_ter_tratadorErro.trataErro(ref erro);
            }
            return(false);
        }
        public override bool bCarregaIdRelatorio()
        {
            try
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwRowTbSaques;
                System.Collections.ArrayList arlCondicaoCampo = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoTipo  = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoValor = new System.Collections.ArrayList();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);

                arlCondicaoCampo.Add("idPE");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_strIdCodigo);

                m_cls_dba_ConnectionDB.FonteDosDados = mdlDataBaseAccess.FonteDados.DataBase;
                m_typDatSetTbSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoTipo, arlCondicaoValor, null, null);
                if (m_typDatSetTbSaques.tbSaques.Rows.Count > 0)
                {
                    dtrwRowTbSaques = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)m_typDatSetTbSaques.tbSaques.Rows[0];
                    if (!dtrwRowTbSaques.IsnIdRelatorioNull())
                    {
                        m_nIdRelatorio = dtrwRowTbSaques.nIdRelatorio;
                    }
                    else
                    {
                        m_nIdRelatorio = -1;
                    }
                    return(bRelatorioExiste());
                }
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_ter_tratadorErro.trataErro(ref erro);
            }
            return(false);           //soh para compilar......nao existe!
        }
Exemple #11
0
        private void vCaregaDadosValorExtensoDefault()
        {
            mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaque = XsdDatSetSaque();
            if (typDatSetSaque.tbSaques.Rows.Count > 0)
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaque.tbSaques.Rows[0];

                // Idioma
                int nIdIdioma = 3;
                if (!dtrwSaque.IsnIdIdiomaNull())
                {
                    nIdIdioma = dtrwSaque.nIdIdioma;
                }
                // Moeda
                int               nIdMoeda = 28;
                string            strTemp;
                bool              bTemp;
                mdlMoeda.clsMoeda objMoeda = new mdlMoeda.clsMoedaComercial(ref m_cls_ter_tratadorErro, ref m_cls_dba_ConnectionDB, m_strEnderecoExecutavel, m_nIdExportador, m_strIdPE);
                objMoeda.retornaValores(out nIdMoeda, out strTemp, out strTemp, out bTemp);
                m_strValorExtensoDefault = mdlConversao.clsValorExtenso.strRetornaValorExtenso(this.Valor, nIdIdioma, nIdMoeda);
            }
        }
        public override bool bCarregaIdIdioma()
        {
            try
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwRowTbSaques;
                System.Collections.ArrayList arlCondicaoCampo = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoTipo  = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoValor = new System.Collections.ArrayList();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);

                arlCondicaoCampo.Add("idPE");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_strIdCodigo);

                m_typDatSetTbSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoTipo, arlCondicaoValor, null, null);
                if (m_typDatSetTbSaques.tbSaques.Rows.Count > 0)
                {
                    dtrwRowTbSaques = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)m_typDatSetTbSaques.tbSaques.Rows[0];
                    if (!dtrwRowTbSaques.IsnIdIdiomaNull())
                    {
                        m_nIdIdioma = dtrwRowTbSaques.nIdIdioma;
                    }
                    else
                    {
                        m_nIdIdioma = 3;
                    }
                    return(true);
                }
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_ter_tratadorErro.trataErro(ref erro);
            }
            return(false);
        }
        protected override void vIncrementaNumeroImpressoes()
        {
            try
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwRowTbSaques;
                System.Collections.ArrayList arlCondicaoCampo = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoTipo  = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoValor = new System.Collections.ArrayList();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);

                arlCondicaoCampo.Add("idPE");
                arlCondicaoTipo.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_strIdCodigo);

                m_cls_dba_ConnectionDB.FonteDosDados = mdlDataBaseAccess.FonteDados.DataBase;
                m_typDatSetTbSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoTipo, arlCondicaoValor, null, null);
                if (m_typDatSetTbSaques.tbSaques.Rows.Count > 0)
                {
                    dtrwRowTbSaques = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)m_typDatSetTbSaques.tbSaques.Rows[0];
                    if (!dtrwRowTbSaques.IsnImpressoesNull())
                    {
                        dtrwRowTbSaques.nImpressoes++;
                    }
                    else
                    {
                        dtrwRowTbSaques.nImpressoes = 1;
                    }
                }
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_ter_tratadorErro.trataErro(ref erro);
            }
        }
        public bool bSalvaValorSaque(double dValor)
        {
            bool bReturn = false;

            System.Collections.ArrayList arlCondicaoCampo      = new System.Collections.ArrayList();
            System.Collections.ArrayList arlCondicaoComparador = new System.Collections.ArrayList();
            System.Collections.ArrayList arlCondicaoValor      = new System.Collections.ArrayList();
            arlCondicaoCampo.Add("idExportador");
            arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
            arlCondicaoValor.Add(m_nIdExportador);
            arlCondicaoCampo.Add("idPe");
            arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
            arlCondicaoValor.Add(m_strPe);
            mdlDataBaseAccess.Tabelas.XsdTbSaques typDatSetSaques = m_cls_dba_ConnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
            if (typDatSetSaques.tbSaques.Rows.Count > 0)
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)typDatSetSaques.tbSaques.Rows[0];
                dtrwSaque.dValor = dValor;
                m_cls_dba_ConnectionDB.SetTbSaques(typDatSetSaques);
                bReturn = (m_cls_dba_ConnectionDB.Erro == null);
            }
            return(bReturn);
        }
        private void carregaTypDatSet()
        {
            try
            {
                System.Collections.ArrayList arlCondicaoCampo      = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoComparador = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoValor      = new System.Collections.ArrayList();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);

                arlCondicaoCampo.Add("idPE");
                arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_strIdPE);

                m_typDatSetTbPes                        = m_cls_dbaConnnectionDB.GetTbPes(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbSaques                     = m_cls_dbaConnnectionDB.GetTbSaques(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbBorderos                   = m_cls_dbaConnnectionDB.GetTbBorderos(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbRomaneios                  = m_cls_dbaConnnectionDB.GetTbRomaneios(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbFaturasComerciais          = m_cls_dbaConnnectionDB.GetTbFaturasComerciais(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbInstrucoesEmbarque         = m_cls_dbaConnnectionDB.GetTbInstrucoesEmbarque(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbCertificadosOrigem         = m_cls_dbaConnnectionDB.GetTbCertificadosOrigem(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbProdutosCertificadosOrigem = m_cls_dbaConnnectionDB.GetTbProdutosCertificadoOrigem(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);

                arlCondicaoCampo.Clear();
                arlCondicaoCampo.Add("nIdExportador");
                arlCondicaoCampo.Add("strIdPE");
                m_typDatSetTbProdutosBordero = m_cls_dbaConnnectionDB.GetTbProdutosBordero(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_terTratadorErro.trataErro(ref erro);
            }
        }
Exemple #16
0
        protected new void carregaTypDatSet()
        {
            try
            {
                mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow dtrwRowTbSaque;
                mdlDataBaseAccess.Tabelas.XsdTbFaturasComerciais.tbFaturasComerciaisRow dtrwRowTbFaturasComerciais;
                System.Collections.ArrayList arlCondicaoCampo      = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoComparador = new System.Collections.ArrayList();
                System.Collections.ArrayList arlCondicaoValor      = new System.Collections.ArrayList();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);

                m_typDatSetTbExportadores = m_cls_dba_ConnectionBD.GetTbExportadores(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);

                arlCondicaoCampo.Add("idPE");
                arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_strIdPE);

                m_typDatSetTbSaques            = m_cls_dba_ConnectionBD.GetTbSaques(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
                m_typDatSetTbFaturasComerciais = m_cls_dba_ConnectionBD.GetTbFaturasComerciais(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);;
                if (m_typDatSetTbSaques.tbSaques.Rows.Count > 0)
                {
                    dtrwRowTbSaque = (mdlDataBaseAccess.Tabelas.XsdTbSaques.tbSaquesRow)m_typDatSetTbSaques.tbSaques.Rows[0];
                    if (!dtrwRowTbSaque.IsdtDataEmissaoNull())
                    {
                        m_dtData = dtrwRowTbSaque.dtDataEmissao;
                    }
                    if (!dtrwRowTbSaque.IsstrNumeroSaqueNull())
                    {
                        m_strNumero = dtrwRowTbSaque.strNumeroSaque.Replace("\0", "");
                    }
                    if (m_typDatSetTbFaturasComerciais.tbFaturasComerciais.Rows.Count > 0)
                    {
                        dtrwRowTbFaturasComerciais = (mdlDataBaseAccess.Tabelas.XsdTbFaturasComerciais.tbFaturasComerciaisRow)m_typDatSetTbFaturasComerciais.tbFaturasComerciais.Rows[0];
                        if (!dtrwRowTbFaturasComerciais.IsidImportadorNull())
                        {
                            m_nIdImportador = dtrwRowTbFaturasComerciais.idImportador;
                        }
                    }
                }
                else if (m_typDatSetTbFaturasComerciais.tbFaturasComerciais.Rows.Count > 0)
                {
                    dtrwRowTbFaturasComerciais = (mdlDataBaseAccess.Tabelas.XsdTbFaturasComerciais.tbFaturasComerciaisRow)m_typDatSetTbFaturasComerciais.tbFaturasComerciais.Rows[0];
                    if (!dtrwRowTbFaturasComerciais.IsidImportadorNull())
                    {
                        m_nIdImportador = dtrwRowTbFaturasComerciais.idImportador;
                    }
                }

                arlCondicaoCampo.Clear();
                arlCondicaoComparador.Clear();
                arlCondicaoValor.Clear();

                arlCondicaoCampo.Add("idExportador");
                arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdExportador);
                arlCondicaoCampo.Add("idImportador");
                arlCondicaoComparador.Add(mdlDataBaseAccess.Comparador.Igual);
                arlCondicaoValor.Add(m_nIdImportador);

                m_typDatSetTbImportadores = m_cls_dba_ConnectionBD.GetTbImportadores(arlCondicaoCampo, arlCondicaoComparador, arlCondicaoValor, null, null);
            }
            catch (Exception err)
            {
                Object erro = err;
                m_cls_ter_tratadorErro.trataErro(ref erro);
            }
        }