public static int retonarTpamb(string sEmp)
{
belConnection cx = new belConnection();
int tp_amb;
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("select ");
sSql.Append("empresa.st_ambiente ");
sSql.Append("uf.nr_ufnfe cd_ufnor, ");
sSql.Append("from empresa ");
sSql.Append("left join uf on (uf.cd_uf = empresa.cd_ufnor) ");
sSql.Append("where ");
sSql.Append("cd_empresa ='");
sSql.Append(sEmp);
sSql.Append("'");
FbCommand cmdIde = new FbCommand(sSql.ToString(), cx.get_Conexao());
cx.Open_Conexao();
cmdIde.ExecuteNonQuery();
FbDataReader dr = cmdIde.ExecuteReader();
dr.Read();
tp_amb = Convert.ToInt16((dr["st_ambiente"].ToString() != "" ? dr["st_ambiente"].ToString() : "2"));
}
catch (Exception x)
{
throw new Exception("Erro de " + x.Source + Environment.NewLine + x.Message);
}
finally { cx.Close_Conexao(); }
return tp_amb;
}
public List<string> BuscaCodigoEmpresas()
{
List<string> slCodigos = new List<string>();
belConnection cx = new belConnection();
try
{
using (FbCommand cmd = new FbCommand("Select empresa.cd_empresa from empresa order by empresa.cd_empresa", cx.get_Conexao()))
{
cx.Open_Conexao();
cmd.ExecuteNonQuery();
FbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
slCodigos.Add(dr["cd_empresa"].ToString());
}
}
}
catch (Exception ex)
{
throw;
}
finally
{
cx.Close_Conexao();
}
return slCodigos;
}
public List<string> VerificaPendenciasdeEnvio()
{
belConnection cx = new belConnection();
try
{
List<string> ListaConhecimento = new List<string>();
StringBuilder sQuery = new StringBuilder();
sQuery.Append("Select conhecim.nr_lanc from conhecim ");
sQuery.Append("where conhecim.st_contingencia ='S' ");
sQuery.Append("and (conhecim.st_cte='N' or conhecim.st_cte is null)");
FbCommand fbConn = new FbCommand(sQuery.ToString(), cx.get_Conexao());
cx.Open_Conexao();
FbDataReader dr = fbConn.ExecuteReader();
while (dr.Read())
{
ListaConhecimento.Add(dr["nr_lanc"].ToString());
}
return ListaConhecimento;
}
catch (Exception ex)
{
cx.Close_Conexao();
throw ex;
}
finally
{
cx.Close_Conexao();
}
}
public void BuscaUFeAmb()
{
belConnection cx = new belConnection();
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("Select ");
sSql.Append("empresa.nm_empresa, ");
sSql.Append("empresa.cd_ufnor, ");
sSql.Append("coalesce(empresa.st_ambiente, '2') tpAmb ");
sSql.Append("from empresa ");
sSql.Append("where ");
sSql.Append("cd_empresa ='");
sSql.Append(belStatic.CodEmpresaCte);
sSql.Append("'");
using (FbCommand cmd = new FbCommand(sSql.ToString(), cx.get_Conexao()))
{
cx.Open_Conexao();
cmd.ExecuteNonQuery();
FbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
belStatic.Sigla_uf = dr["cd_ufnor"].ToString();
belStatic.TpAmb = Convert.ToInt32(dr["tpAmb"].ToString());
//belStatic.sNomeEmpresa = dr["nm_empresa"].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally { cx.Close_Conexao(); }
}
public bool VerificaEmailContador()
{
belConnection cx = new belConnection();
try
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append("select coalesce(empresa.cd_emailcont,'')cd_emailcont , empresa.nm_empresa from empresa ");
sQuery.Append("where empresa.cd_empresa = '" + belStatic.codEmpresaNFe + "'");
FbCommand fbCom = new FbCommand(sQuery.ToString(), cx.get_Conexao());
cx.Open_Conexao();
FbDataReader dr = fbCom.ExecuteReader();
dr.Read();
string sEmailCont = dr["cd_emailcont"].ToString();
if (sEmailCont.Equals(""))
{
return false;
throw new Exception("Não existe nenhum e-mail de contador cadastrado nesse empresa");
}
else
{
belStatic.sEmailContador = sEmailCont;
belStatic.sNomeEmpresaCompleto = dr["nm_empresa"].ToString();
return true;
}
}
catch (Exception ex)
{
return false;
throw ex;
}
finally
{
cx.Close_Conexao();
}
}
private void populaComboGruposFat()
{
try
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append("select hlpstatus.ds_descvalor, hlpstatus.ds_valor FROM hlpstatus ");
sQuery.Append("where hlpstatus.ds_referencia = 'CD_GRUPONF'");
cx = new belConnection();
FbCommand command = new FbCommand(sQuery.ToString(), cx.get_Conexao());
cx.Open_Conexao();
command.ExecuteNonQuery();
FbDataReader dr = command.ExecuteReader();
List<GruposFaturamento> objLista = new List<GruposFaturamento>();
while (dr.Read())
{
objLista.Add(new GruposFaturamento
{
ds_descvalor = dr["ds_valor"].ToString() + " - " + dr["ds_descvalor"].ToString(),
ds_valor = dr["ds_valor"].ToString()
});
}
cbxGruposServico.DataSource = objLista;
cbxGruposServico.SelectedIndex = -1;
}
catch (Exception)
{
throw;
}
finally { cx.Close_Conexao(); }
}
public string BuscaNumeroConhecimento(string sSeq)
{
belConnection cx = new belConnection();
try
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append("Select conhecim.cd_conheci ");
sQuery.Append("from conhecim ");
sQuery.Append("where conhecim.nr_lanc ='" + sSeq + "' ");
sQuery.Append("and conhecim.cd_empresa ='" + belStatic.CodEmpresaCte + "'");
FbCommand fbConn = new FbCommand(sQuery.ToString(), cx.get_Conexao());
cx.Open_Conexao();
fbConn.ExecuteNonQuery();
FbDataReader dr = fbConn.ExecuteReader();
dr.Read();
return dr["cd_conheci"].ToString();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cx.Close_Conexao();
}
}
public string VerificaCampoProtocoloEnvio(string sNumCte)
{
belConnection objbelConn = new belConnection();
try
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append("Select coalesce(conhecim.cd_nprotcte,'')cd_nprotcte ");
sQuery.Append("from conhecim ");
sQuery.Append("where conhecim.cd_conheci ='" + sNumCte + "' ");
sQuery.Append("and conhecim.cd_empresa ='" + belStatic.CodEmpresaCte + "' AND CONHECIM.st_cte = 'S'");
FbCommand fbConn = new FbCommand(sQuery.ToString(), cx.get_Conexao());
cx.Open_Conexao();
fbConn.ExecuteNonQuery();
FbDataReader dr = fbConn.ExecuteReader();
dr.Read();
string sProt = dr["cd_nprotcte"].ToString();
return sProt;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cx.Close_Conexao();
}
}
private void frmGerarXmlNfe_Load(object sender, EventArgs e)
{
try
{
foreach (Control ctl in this.Controls)
{
if ((ctl) is MdiClient)
{
ctl.BackColor = Color.White;
break;
}
}
if (ApplicationDeployment.IsNetworkDeployed)
{
ApplicationDeployment ad = ApplicationDeployment.CurrentDeployment;
lblVersao.Text = "Versão Atual: " + ad.CurrentVersion.ToString();
belStatic.sVersaoAtual = ad.CurrentVersion.ToString();
belVersionamento objbelVersion = new belVersionamento();
if (objbelVersion.VerificaPublicacaoDisponivel())
{
frmPopup popup = new frmPopup(PopupSkins.InfoSkin);
popup.ShowPopup("Atualização", "Uma nova versão do Sistema já está Disponível!", 200, 4000, 2000);
tsAtualizacao.Visible = true;
}
else
{
tsAtualizacao.Visible = false;
}
versãoHlpToolStripMenuItem.Visible = false;
}
//Carrega os arquivos de configuração
if (!Util.VerificaConfiguracaoPastasXml())
{
frmLocalXml objfrm = new frmLocalXml("");
objfrm.ShowDialog();
}
else
{
DirectoryInfo dinfo = new DirectoryInfo(belStatic.Pasta_xmls_Configs);
if (!dinfo.Exists)
{
KryptonMessageBox.Show(null, "O caminho configurado abaixo não foi encontrado!! "
+ Environment.NewLine
+ Environment.NewLine
+ belStatic.Pasta_xmls_Configs, "A V I S O", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmLocalXml objfrm = new frmLocalXml(belStatic.Pasta_xmls_Configs);
objfrm.ShowDialog();
}
}
int iCountFiles = 0;
DirectoryInfo dPastaData = new DirectoryInfo(belStatic.Pasta_xmls_Configs);
if (!dPastaData.Exists)
{
dPastaData.Create();
}
else
{
FileInfo[] finfo = dPastaData.GetFiles("*.xml");
foreach (FileInfo item in finfo)
{
iCountFiles++;
}
}
belStatic.IPrimeiroLoad = 1;
if (iCountFiles != 0)
{
frmSelecionaConfigs objFrmSeleciona = new frmSelecionaConfigs();
objFrmSeleciona.ShowDialog();
if (objFrmSeleciona.bFecharApp)
{
throw new Exception("Fechar");
}
if (!objFrmSeleciona.bESCRITA)
{
objFrmSeleciona.Hide();
belStatic.IPrimeiroLoad = 1;
frmLogin objfrm = new frmLogin();
objfrm.ShowDialog();
CarregaDadosEmpresa();
VerificaAcessoUserEmprersa(sender, e);
belStatic.IPrimeiroLoad = 0;
lblUsuario.Text = "Usuário: " + belStatic.SUsuario;
lblEmpresa.Text = belStatic.sNomeEmpresa;
gerarAquivosXmlsToolStripMenuItem.Visible = true;
tsNfe.Enabled = true;
tsNfes.Enabled = true;
headerMenuLateral.Visible = true;
cx = new belConnection();
}
else
{
gerarAquivosXmlsToolStripMenuItem.Visible = false;
tsNfe.Enabled = false;
tsNfes.Enabled = false;
headerMenuLateral.Visible = false;
}
}
else
{
if (KryptonMessageBox.Show(null, "Não existe nenhum arquivo de configuração na pasta Selecionada."
+ Environment.NewLine
+ Environment.NewLine
+ "Deseja selecionar uma outra Pasta ?",
"A V I S O",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
frmLocalXml objfrm = new frmLocalXml(belStatic.Pasta_xmls_Configs);
objfrm.ShowDialog();
Application.Restart();
this.Close();
}
belStatic.BSemArquivo = true;
frmLoginConfig objFrm = new frmLoginConfig();
objFrm.ShowDialog();
lblUsuario.Text = " Usuário : " + belStatic.SUsuario;
}
CarregaStatuModoSistema();
//carrega Logotipo
Globais LeRegWin = new Globais();
LeRegWin.CarregaInfStaticas(); // INICIALIZA AS CONFIGURAÇÕES PADRÕES
Byte[] bimagem = belUtil.carregaImagem(LeRegWin.LeRegConfig("Logotipo"));
if (bimagem != null)
{
pictureBox1.BackgroundImage = belUtil.byteArrayToImage(bimagem);
}
HLP.Dao.daoEmailContador objdaoemailCont = new HLP.Dao.daoEmailContador();
if (objdaoemailCont.VerificaDiaParaEnviarEmail())
{
try
{
KryptonMessageBox.Show("Hoje é dia de enviar Email para o Contador, Verifique suas Pendências!!", "A V I S O", MessageBoxButtons.OK, MessageBoxIcon.Information);
NfeGerarXml.NFe.frmEmailContadorNfe objfrm = new NfeGerarXml.NFe.frmEmailContadorNfe();
objfrm.MdiParent = this;
objfrm.Show();
}
catch (Exception ex)
{
KryptonMessageBox.Show(null, ex.Message, "A V I S O", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (belStatic.RAMO == "TRANSPORTE")
{
btnNfe.Enabled = false;
tsNfe.Enabled = false;
btnNfes.Enabled = false;
tsNfes.Enabled = false;
btnCte.Enabled = true;
tsCte.Enabled = true;
btnCce.Enabled = false;
tsCce.Enabled = false;
//btnEmail.Enabled = false;
//tsEmail.Enabled = false;
tsOrganizarPasta.Enabled = false;
tsProtocolos.Enabled = false;
tsImportarXmlEscritor.Enabled = false;
}
else
{
btnNfe.Enabled = true;
tsNfe.Enabled = true;
btnNfes.Enabled = true;
tsNfes.Enabled = true;
btnCte.Enabled = false;
tsCte.Enabled = false;
btnCce.Enabled = true;
tsCce.Enabled = true;
btnEmail.Enabled = true;
tsEmail.Enabled = true;
tsOrganizarPasta.Enabled = true;
tsProtocolos.Enabled = true;
tsImportarXmlEscritor.Enabled = true;
}
}
catch (FbException fbx)
{
KryptonMessageBox.Show(null, "Ocorreu uma falha ao montar a string de Conexão!"
+ Environment.NewLine
+ "Verifique se o arquivo está configurado corretamente!"
+ Environment.NewLine,
"A V I S O", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmLocalXml objfrm = new frmLocalXml(belStatic.Pasta_xmls_Configs);
frmLoginConfig objFrm = new frmLoginConfig();
objFrm.ShowDialog();
lblUsuario.Text = " Usuário : " + belStatic.SUsuario;
Application.Restart();
}
catch (Exception ex)
{
if (ex.Message.Equals("Fechar"))
{
this.Close();
}
else
{
KryptonMessageBox.Show(ex.Message);
}
}
}
private void conexãoToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
belConnection objboCon = new belConnection();
MessageBox.Show(objboCon.get_Conexao().ConnectionString);
}
catch (Exception)
{
throw;
}
}
public void CarregaDadosEmpresa()
{
try
{
cx = new belConnection();
string sQuery = "select empresa.nm_cidnor, empresa.cd_ufnor from empresa where empresa.cd_empresa ='" + belStatic.codEmpresaNFe + "'";
FbCommand command = new FbCommand(sQuery, cx.get_Conexao());
cx.Open_Conexao();
command.ExecuteNonQuery();
FbDataReader dr = command.ExecuteReader();
dr.Read();
List<string> ObjListCidadesNFse = new List<string>();
ObjListCidadesNFse.Add("itu");
ObjListCidadesNFse.Add("jundiai");
belStatic.sNmCidadeEmpresa = dr["nm_cidnor"].ToString().ToUpper().Trim().ToLower();
belStatic.sUF = dr["cd_ufnor"].ToString().ToUpper().Trim().ToUpper();
belStatic.Sigla_uf = belStatic.sUF;
belStatic.CodEmpresaCte = belStatic.codEmpresaNFe;
}
catch (Exception)
{
throw;
}
finally { cx.Close_Conexao(); }
}
public void LimpaCampoRecibo(string sEmp, string sSeq)
{
belConnection cx = new belConnection();
StringBuilder sSql = new StringBuilder();
try
{
sSql.Append("update nf ");
sSql.Append("set cd_recibonfe = null ");
sSql.Append("where ");
sSql.Append("cd_empresa ='");
sSql.Append(sEmp);
sSql.Append("' ");
sSql.Append("and ");
sSql.Append("cd_nfseq ='");
sSql.Append(sSeq);
sSql.Append("'");
using (FbCommand cmdUpdate = new FbCommand(sSql.ToString(), cx.get_Conexao()))
{
cx.Open_Conexao();
cmdUpdate.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
finally
{
cx.Close_Conexao();
}
}
public void SalvaRetornoNotaDuplicada(string sRecibo, string sSeq)
{
belConnection cx = new belConnection();
StringBuilder sSql = new StringBuilder();
try
{
sSql.Append("UPDATE NF ");
sSql.Append("set cd_recibonfe = '" + sRecibo + "' ");
sSql.Append("where ");
sSql.Append("cd_empresa ='");
sSql.Append(belStatic.codEmpresaNFe);
sSql.Append("' ");
sSql.Append("and ");
sSql.Append("cd_nfseq ='");
sSql.Append(sSeq);
sSql.Append("'");
using (FbCommand cmdUpdate = new FbCommand(sSql.ToString(), cx.get_Conexao()))
{
cx.Open_Conexao();
cmdUpdate.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
finally { cx.Close_Conexao(); }
}
private string geraChaveCanc(string sEmp, string sSeq)
{
belConnection cx = new belConnection();
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("Select ");
sSql.Append("uf.nr_ufnfe, ");
sSql.Append("coalesce(nf.cd_serie, 1) serie, ");
sSql.Append("nf.cd_notafis nNF, ");
sSql.Append("nf.dt_emi dEmi, ");
sSql.Append("empresa.cd_cgc CNPJ, ");
sSql.Append("nf.cd_nfseq cNF ");
sSql.Append(" From ");
sSql.Append("NF ");
sSql.Append("inner join empresa on (empresa.cd_empresa = nf.cd_empresa) ");
sSql.Append("left join uf on (uf.cd_uf = empresa.cd_ufnor) ");
sSql.Append("where ");
sSql.Append("(nf.cd_empresa ='");
sSql.Append(sEmp);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(nf.cd_nfseq = '");
sSql.Append(sSeq);
sSql.Append("')");
FbCommand sqlConsulta = new FbCommand(sSql.ToString(), cx.get_Conexao());
cx.Open_Conexao();
sqlConsulta.ExecuteNonQuery();
FbDataReader drChave = sqlConsulta.ExecuteReader();
drChave.Read();
GeraXMLExp objgeraxmlexp = new GeraXMLExp();
string scUF, sAAmM, sCNPJ, sMod, sSerie, snNF, scNF;
scUF = drChave["nr_ufnfe"].ToString().PadLeft(2, '0');
sAAmM = drChave["demi"].ToString().Replace("/", "").Substring(6, 2).ToString() +
drChave["demi"].ToString().Replace("/", "").Substring(2, 2).ToString();
sCNPJ = belUtil.TiraSimbolo(drChave["cnpj"].ToString(), "");
sCNPJ = sCNPJ.PadLeft(14, '0');
sMod = "55";
if (IsNumeric(drChave["serie"].ToString()))
{
sSerie = drChave["serie"].ToString().PadLeft(3, '0');
}
else
{
sSerie = "001";
}
snNF = drChave["nNF"].ToString().PadLeft(9, '0');
scNF = drChave["cNF"].ToString().PadLeft(9, '0');
string sChaveantDig = "";
string sChave = "";
string sDig = "";
sChaveantDig = scUF.Trim() + sAAmM.Trim() + sCNPJ.Trim() + sMod.Trim() + sSerie.Trim() + snNF.Trim() + scNF.Trim();
sDig = objgeraxmlexp.CalculaDig11(sChaveantDig).ToString();
sChave = sChaveantDig + sDig;
return sChave;
}
catch (Exception)
{
throw;
}
finally
{
cx.Close_Conexao();
}
}
public tcLoteRps BuscaDadosNFes(List<string> sListaNotas)
{
belConnection cx = new belConnection();
try
{
objLoteRps = new tcLoteRps();
objLoteRps.Rps = new List<TcRps>();
foreach (string sNota in sListaNotas)
{
TcRps objTcRps = new TcRps();
//IdentificacaoRps - TcIdentificacaoRps
daotcIdentificacaoRps objdaotcIdentificacaoRps = new daotcIdentificacaoRps();
objTcRps.InfRps = new TcInfRps();
StringBuilder sQuery = new StringBuilder();
sQuery.Append("SELECT coalesce (tpdoc.cd_natureza_oper_nfse,'1')cd_natureza_oper_nfse , ");
sQuery.Append("coalesce (empresa.st_simples,'')st_simples , ");
sQuery.Append("coalesce (empresa.cd_regime_trib_especial,'0')RegimeEspecialTributacao , ");
sQuery.Append("coalesce (empresa.st_insentivador_cultural,'N')st_insentivador_cultural from nf ");
sQuery.Append("inner join tpdoc on nf.cd_tipodoc = tpdoc.cd_tipodoc ");
sQuery.Append("inner join empresa on empresa.cd_empresa = nf.cd_empresa ");
sQuery.Append(" where nf.cd_nfseq = '" + sNota + "' and ");
sQuery.Append(" nf.cd_empresa = '" + belStatic.codEmpresaNFe + "'");
FbCommand Command = new FbCommand(sQuery.ToString(), cx.get_Conexao());
cx.Open_Conexao();
Command.ExecuteNonQuery();
FbDataReader dr = Command.ExecuteReader();
dr.Read();
objTcRps.InfRps.DataEmissao = HLP.Util.Util.GetDateServidor();
objTcRps.InfRps.NaturezaOperacao = Convert.ToInt16(dr["cd_natureza_oper_nfse"].ToString());
objTcRps.InfRps.OptanteSimplesNacional = (dr["st_simples"].ToString().Equals("S") ? 1 : 2);
objTcRps.InfRps.IncentivadorCultural = (dr["st_insentivador_cultural"].ToString().Equals("S")?1:2);
objTcRps.InfRps.Status = 1;//Normal;
if (objTcRps.InfRps.OptanteSimplesNacional == 1)
{
objTcRps.InfRps.RegimeEspecialTributacao = Convert.ToInt16(dr["RegimeEspecialTributacao"].ToString());
}
else
{
objTcRps.InfRps.RegimeEspecialTributacao = 0;
}
objTcRps.InfRps.IdentificacaoRps = objdaotcIdentificacaoRps.BuscatcIdentificacaoRps(cx.get_Conexao(), sNota);
//RpsSubstituido - TcIdentificacaoRps // Método tratado na visualização da Nota;
//daoRpsSubstituido objdaoRpsSubstituido = new daoRpsSubstituido();
//objTcRps.InfRps.RpsSubstituido = objdaoRpsSubstituido.RetornaIdentificacaoRpds(Conn, sNota);
//Servico - TcDadosServico
daoServico objdaoServico = new daoServico();
objTcRps.InfRps.Servico = objdaoServico.RetornaDadosServico(cx.get_Conexao(), sNota, objTcRps.InfRps.NaturezaOperacao);
//Prestador - tcIdentificacaoPrestador
daoPrestador objdaoPrestador = new daoPrestador();
objTcRps.InfRps.Prestador = objdaoPrestador.RettcIdentificacaoPrestador(cx.get_Conexao(), sNota);
objLoteRps.Cnpj = objTcRps.InfRps.Prestador.Cnpj; // Tag Pai;
objLoteRps.InscricaoMunicipal = objTcRps.InfRps.Prestador.InscricaoMunicipal; //Tag Pai;
//Tomador - TcDadosTomador
daoTomador objdaoTomador = new daoTomador();
objTcRps.InfRps.Tomador = objdaoTomador.RettcDadosTomador(cx.get_Conexao(), sNota);
//IntermediarioServico - tcIdentificacaoIntermediarioServico //Tratado na visualização da Nota
//daoIntermediarioServico objdaoIntermediarioServico = new daoIntermediarioServico();
//objTcRps.InfRps.IntermediarioServico = objdaoIntermediarioServico.RettcIdentificacaoIntermediarioServico(Conn, sNota);
//ConstrucaoCivil - TcDadosContrucaoCivil - Tratado na Visualização da Nota
if (belStatic.sNomeEmpresa.Equals("AENGE"))
{
daoConstrucaoCivil objdaoConstrucaoCivil = new daoConstrucaoCivil();
objTcRps.InfRps.ConstrucaoCivil = objdaoConstrucaoCivil.RettcDadosConstrucaoCivil(cx.get_Conexao(), sNota);
}
objLoteRps.Rps.Add(objTcRps);
}
daoUtil objdaoUtil = new daoUtil();
objLoteRps.NumeroLote = objdaoUtil.RetornaProximoValorGenerator("GEN_LOTE_NFES", 15);
objLoteRps.QuantidadeRps = objLoteRps.Rps.Count;
return objLoteRps;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cx.Close_Conexao();
}
}
private void NfeDadosMsg()
{
XmlSchemaCollection myschema = new XmlSchemaCollection();
XmlValidatingReader reader;
Globais sPath = new Globais();
belConnection cx = new belConnection();
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("select ");
sSql.Append("cd_chavenferet, ");
sSql.Append("cd_nprotnfe ");
sSql.Append("from nf ");
sSql.Append("where ");
sSql.Append("(cd_empresa = '");
sSql.Append(_emp);
sSql.Append("') ");
sSql.Append("and ");
sSql.Append("(cd_nfseq = '");
sSql.Append(_seq);
sSql.Append("')");
FbCommand cmdcanc = new FbCommand(sSql.ToString(), cx.get_Conexao());
cx.Open_Conexao();
cmdcanc.ExecuteNonQuery();
FbDataReader drCanc = cmdcanc.ExecuteReader();
drCanc.Read();
_chnfe = drCanc["cd_chavenferet"].ToString();
_nprot = drCanc["cd_nprotnfe"].ToString();
_id = "ID" + _chnfe;
XNamespace xname = "http://www.portalfiscal.inf.br/nfe";
XDocument xdoc = new XDocument(new XElement(xname + "cancNFe", new XAttribute("versao", _versaodados),
new XElement(xname + "infCanc", new XAttribute("Id", _id),
new XElement(xname + "tpAmb", _tpamb),
new XElement(xname + "xServ", _xserv),
new XElement(xname + "chNFe", _chnfe),
new XElement(xname + "nProt", _nprot),
new XElement(xname + "xJust", _xjust))));
xdoc.Save(_spath + "\\" + _seq + "_ped-can.xml");
AssinaNFeCancXml assinaCanc = new AssinaNFeCancXml();
assinaCanc.ConfigurarArquivo(_spath + "\\" + _seq + "_ped-can.xml", "infCanc", _cert);
StreamReader ler;
ler = File.OpenText(_spath + "\\" + _seq + "_ped-can.xml");
XmlParserContext context = new XmlParserContext(null, null, "", XmlSpace.None);
reader = new XmlValidatingReader(ler.ReadToEnd().ToString(), XmlNodeType.Element, context);
myschema.Add("http://www.portalfiscal.inf.br/nfe", belStaticPastas.SCHEMA_NFE + "\\cancNFe_v2.00.xsd");
reader.ValidationType = ValidationType.Schema;
reader.Schemas.Add(myschema);
while (reader.Read())
{ }
}
catch (Exception x)
{
throw new Exception(x.Message);
}
finally { cx.Close_Conexao(); }
}
public List<belNumeroNF> GeraNumeroNF(List<string> lsNFSEq, string sProximaNF, string sEmpresa)
{
belConnection cx = new belConnection();
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("select ");
sSql.Append("nf.cd_nfseq ");
sSql.Append("From nf ");
sSql.Append("where ");
sSql.Append("((nf.cd_notafis is null) or (nf.cd_notafis = '')) and (");
sSql.Append("nf.cd_empresa ='");
sSql.Append(sEmpresa);
sSql.Append("') and (");
sSql.Append("nf.cd_nfseq in('");
int iCont = 0;
foreach (var sNfseq in lsNFSEq)
{
iCont++;
sSql.Append(sNfseq);
if (lsNFSEq.Count > iCont)
{
sSql.Append("','");
}
}
sSql.Append("')) ");
sSql.Append("Order by nf.cd_empresa, nf.cd_nfseq ");
//Fim - Claudinei - o.s. sem - 11/03/2010
FbCommand cmd = new FbCommand(sSql.ToString(), cx.get_Conexao());
cx.Open_Conexao();
cmd.ExecuteNonQuery();
FbDataReader dr = cmd.ExecuteReader();
Int32 iNumeroNF = Convert.ToInt32(sProximaNF);
List<belNumeroNF> objNumeroNFs = new List<belNumeroNF>();
//dr = AcessoDados.ExecuteReader(sSql.ToString(), CommandType.Text);
while (dr.Read())
{
belNumeroNF objNumeroNF = new belNumeroNF();
objNumeroNF._nfseq = dr["cd_nfseq"].ToString();
objNumeroNF.Cdnotafis = iNumeroNF.ToString().PadLeft(6, '0');
objNumeroNFs.Add(objNumeroNF);
iNumeroNF++;
}
return objNumeroNFs;
}
catch (Exception)
{
throw;
}
finally { cx.Close_Conexao(); }
}
public static DateTime GetDateServidor()
{
belConnection cx = new belConnection();
try
{
using (FbCommand cmd = new FbCommand("Select current_timestamp d from empresa", cx.get_Conexao()))
{
cx.Open_Conexao();
cmd.ExecuteNonQuery();
FbDataReader dr = cmd.ExecuteReader();
string d = "";
while (dr.Read())
{
d = dr["d"].ToString();
break;
}
DateTime dtRet = Convert.ToDateTime(d);
return dtRet;
}
}
catch (Exception ex)
{
throw ex;
}
finally { cx.Close_Conexao(); }
}
/// <summary>
/// Método Responsavel por gravar os campos cd_chavenferet e cd_nprotnfe. Responsavel tambem montar o TAG procNFe no xml e
/// grava-lo na pasta de xml enviados.
/// </summary>
/// <param name="sEmp"></param>
/// <param name="sSeq"></param>
/// <param name="sNFe"></param>
/// <param name="sChNfe"></param>
/// <param name="sNProt"></param>
/// <param name="xret"></param>
/// <param name="glob"></param>
/// <param name="pf"></param>
public void geraProcNFe(string sSeq, string sNFe, string sChNfe, string sNProt,
XmlNode xret, XNamespace pf)//Danner - o.s. 24435 - 05/05/2010
{
Globais glob = new Globais();
XDocument retcab = new XDocument();
belConnection cx = new belConnection();
try
{
//String sql que dará o update no campos: cd_recibonfe, cd_chavenferet, cd_nprotnfe.
StringBuilder sSql = new StringBuilder();
sSql.Append("update nf set cd_chavenferet ='");
sSql.Append(sChNfe);
sSql.Append("', ");
sSql.Append("cd_nprotnfe ='");
sSql.Append(sNProt);
sSql.Append("' ");
sSql.Append("Where nf.cd_empresa = '");
sSql.Append(belStatic.codEmpresaNFe);
sSql.Append("' and ");
sSql.Append("nf.cd_nfseq ='");
sSql.Append(sSeq);
sSql.Append("'");
using (FbCommand cmdUpdate = new FbCommand(sSql.ToString(), cx.get_Conexao()))
{
cx.Open_Conexao();
cmdUpdate.ExecuteNonQuery();
}
//Geração do Xml da nfe Autorizado, incluindo a TAG infProc onde consta as informaçoes de retorno da nfe.
XContainer retproc = new XElement(pf + "nfeProc", new XAttribute("versao", "2.00"),
new XAttribute("xmlns", "http://www.portalfiscal.inf.br/nfe"));
XElement retxml = XElement.Parse(sNFe);
string sCodificacao = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
string sRetProc = "<nfeProc versao=\"2.00\" xmlns=\"http://www.portalfiscal.inf.br/nfe\">";
XmlDocument xmldocteste = new XmlDocument();
xmldocteste.LoadXml(sNFe);
DirectoryInfo dPastaData = new DirectoryInfo(belStaticPastas.ENVIADOS + "\\" + sChNfe.Substring(2, 4));
if (!dPastaData.Exists) { dPastaData.Create(); }
StreamWriter sw = new StreamWriter(belStaticPastas.ENVIADOS + "\\" + sChNfe.Substring(2, 4) + "\\" + sChNfe + "-nfe.xml"); //OS_25024
if (@xmldocteste.FirstChild.Name.Equals("xml"))
{
sw.Write(@sRetProc + @xmldocteste.OuterXml.Remove(0, 38) + @xret.OuterXml.ToString() + @"</nfeProc>");
}
else
{
sw.Write(@sCodificacao + @sRetProc + @xmldocteste.OuterXml + @xret.OuterXml.ToString() + @"</nfeProc>");
}
sw.Close();
//Geração do Xml da nfe Autorizado, incluindo a TAG infProc onde consta as informaçoes de retorno da nfe.
}
catch (Exception x)
{
throw new Exception("Erro na geração do XML Protocolado, infProt - " + x.Message);
}
finally
{
cx.Close_Conexao();
}
}
//Fim - Danner - o.s. 23732 - 11/11/2009
//Danner - o.s. 23732 - 13/11/2009
public static string retornaCdfunor(string sEmp)
{
belConnection cx = new belConnection();
string cd_ufnor;
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("select ");
sSql.Append("uf.nr_ufnfe cd_ufnor, ");
sSql.Append("from empresa ");
sSql.Append("left join uf on (uf.cd_uf = empresa.cd_ufnor) ");
sSql.Append("where ");
sSql.Append("cd_empresa ='");
sSql.Append(sEmp);
sSql.Append("'");
FbCommand cmdIde = new FbCommand(sSql.ToString(), cx.get_Conexao());
cx.Open_Conexao();
cmdIde.ExecuteNonQuery();
FbDataReader dr = cmdIde.ExecuteReader();
dr.Read();
cd_ufnor = dr["cd_ufnor"].ToString();
}
catch (Exception x)
{
throw new Exception("Erro de " + x.Source + Environment.NewLine + x.Message);
}
finally
{
cx.Close_Conexao();
}
return cd_ufnor;
}
private string retEmailTransportador(string sSeq, string sEmp)
{
StringBuilder sSql = new StringBuilder();
string email = "";
belConnection cx = new belConnection();
try
{
sSql.Append("select ");
sSql.Append("transpor.cd_email ");
sSql.Append("from ");
sSql.Append("transpor inner join nf ");
sSql.Append("on transpor.cd_trans = nf.cd_trans ");
sSql.Append("where ");
sSql.Append("nf.cd_empresa = '");
sSql.Append(sEmp);
sSql.Append("' ");
sSql.Append("and ");
sSql.Append("nf.cd_nfseq = '");
sSql.Append(sSeq);
sSql.Append("'");
FbCommand sqlConsulta = new FbCommand(sSql.ToString(), cx.get_Conexao());
cx.Open_Conexao();
sqlConsulta.ExecuteNonQuery();
FbDataReader drDest = sqlConsulta.ExecuteReader();
drDest.Read();
string[] split = drDest["cd_email"].ToString().Split(';');
foreach (var i in split)
{
email = i;
break;
}
}
catch (Exception x)
{
throw new Exception(x.Message);
}
finally { cx.Close_Conexao(); }
return email;
}
public void CarregarDados()
{
if (File.Exists(belStatic.Pasta_xmls_Configs + spath))
{
if (!spath.ToUpper().Equals("ESCRITA.XML"))
{
try
{
populaComboGruposFat();
StringBuilder sSql = new StringBuilder();
sSql.Append("Select ");
sSql.Append("gen_id(gen_nomearqxml, 0) ");
sSql.Append("from rdb$database");
cx = new belConnection();
using (FbCommand cmd = new FbCommand(sSql.ToString(), cx.get_Conexao()))
{
cx.Open_Conexao();
lblAtual.Text = cmd.ExecuteScalar().ToString();
}
}
catch (FbException ex)
{
KryptonMessageBox.Show(string.Format("Erro.: {0}", ex.Message), "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Error);
lblAtual.Text = "Generator Inexistente!";
}
finally { cx.Close_Conexao(); }
}
XmlTextReader reader = new XmlTextReader(belStatic.Pasta_xmls_Configs + spath);
cbxFormDanfe.SelectedIndex = 0;
while (reader.Read())
{
if ((reader.NodeType != XmlNodeType.Element) || !(reader.Name == "nfe_configuracoes"))
{
continue;
}
#region Campos
while (reader.Read())
{
if (reader.NodeType == XmlNodeType.Element)
{
if (reader.Name == "PastaXmlEnvio")
{
reader.Read();
txtEnvioArquivo.Text = reader.Value;
}
else
{
if (reader.Name == "PastaXmlEnviado")
{
reader.Read();
txtXmlEnviados.Text = reader.Value;
continue;
}
//Danner - o.s. 23851 - 17/11/2009
if (reader.Name == "PastaXmlCancelados")
{
reader.Read();
txtXmlCancelados.Text = reader.Value;
continue;
}
if (reader.Name == "PastaProtocolos")
{
reader.Read();
txtProtocolo.Text = reader.Value;
continue;
}
if (reader.Name == "PastaContingencia")
{
reader.Read();
txtContingencia.Text = reader.Value;
continue;
}
if (reader.Name == "PastaCCe")
{
reader.Read();
txtCCe.Text = reader.Value;
continue;
}
if (reader.Name == "CaminhoPadrao")
{
reader.Read();
txtCaminhoPadrao.Text = reader.Value;
continue;
}
if (reader.Name == "UsaRelatorioEspecifico")
{
reader.Read();
chkRelatorio.Checked = Convert.ToBoolean(reader.Value);
continue;
}
if (reader.Name == "UsaDanfeSimplificada")
{
reader.Read();
ckbDanfeSimplificada.Checked = Convert.ToBoolean(reader.Value);
continue;
}
if (reader.Name == "CaminhoRelatorioEspecifico")
{
reader.Read();
txtCaminhoPastaRelatorio.Text = reader.Value;
continue;
}
//Claudinei - o.s. 23507 - 08/06/2009
if (reader.Name == "BancoDados")
{
reader.Read();
txtBancoDados.Text = reader.Value;
continue;
}
if (reader.Name == "Servidor")
{
reader.Read();
txtServidor.Text = reader.Value;
continue;
}
if (reader.Name == "Porta")
{
reader.Read();
txtPorta.Text = reader.Value;
continue;
}
if (reader.Name == "Usuario")
{
reader.Read();
txtUsuario.Text = reader.Value;
continue;
}
if (reader.Name == "Senha")
{
reader.Read();
txtSenha.Text = reader.Value;
continue;
}
if (reader.Name == "Empresa")
{
reader.Read();
txtEmpresa.Text = reader.Value;
continue;
}
//Danner - o.s. 23851 - 19/11/2009
if (reader.Name == "QtdeTentativas")
{
reader.Read();
nudQtdeTentativas.Value = Convert.ToInt16(reader.Value);
continue;
}
if (reader.Name == "GravaNumNFseDupl")
{
reader.Read();
chkGravaNumNFseDup.Checked = Convert.ToBoolean(reader.Value);
continue;
}
if (reader.Name == "GrupoServico")
{
reader.Read();
cbxGruposServico.SelectedValue = reader.Value.ToString();
continue;
}
if (reader.Name == "Fuso")
{
reader.Read();
cbxFusoHorario.SelectedItem = reader.Value.ToString();
continue;
}
if (reader.Name == "TipoImpressao")
{
reader.Read();
cbxFormDanfe.Text = reader.Value.ToString();
continue;
}
if (reader.Name == "HostServidor")
{
reader.Read();
txtHostServidor.Text = reader.Value;
continue;
}
if (reader.Name == "PortaServidor")
{
reader.Read();
numericUpDown1.Value = Convert.ToInt16(reader.Value);
continue;
}
if (reader.Name == "EmailRemetente")
{
reader.Read();
txtEmailRemetente.Text = reader.Value;
continue;
}
if (reader.Name == "SenhaRemetente")
{
reader.Read();
txtSenhaEmail.Text = reader.Value;
continue;
}
//Danner - o.s. 24329 - 08/04/2010
if (reader.Name == "RequerSSL")
{
reader.Read();
ckbRequerSSL.Checked = (reader.Value == "True" ? true : false);
continue;
}
//Fim - Danner - o.s. 24329 - 08/04/2010
if (reader.Name == "EmailAutomatico")
{
reader.Read();
ckbEmailAutomatico.Checked = (reader.Value == "True" ? true : false);
continue;
}
if (reader.Name == "DestacaImpTribMun")
{
reader.Read();
chkTribMunicipio.Checked = (reader.Value == "True" ? true : false);
continue;
}
if (reader.Name == "CodBarras")
{
reader.Read();
txtCaminhoBarrasTemp.Text = reader.Value;
continue;
}
//Diego - o.s. 23723 - 06/11/2009
if (reader.Name == "Logotipo")
{
reader.Read();
txtCaminhoLogo.Text = reader.Value;
continue;
}
//Fim - o.s. 23723 - 06/11/2009
// Diego - OS_24178 - 25/02/2010
if (reader.Name == "QtdeCasasProdutos")
{
reader.Read();
nupCasasQtdeProd.Value = Convert.ToInt16(reader.Value);
continue;
}
if (reader.Name == "QtdeCasasVlUnit")
{
reader.Read();
nudQtd_Vl_unitario.Value = (Convert.ToInt16(reader.Value) > 1 ? Convert.ToInt16(reader.Value) : 2);
continue;
}
// Diego - OS_24178 - 25/02/2010 - Fim
// Diego - O.S 24344 - 05/05/2010
if (reader.Name == "VisualizaHoraDanfe")
{
reader.Read();
ckbHoraSaidaDanfe.Checked = (reader.Value == "True" ? true : false);
continue;
}
if (reader.Name == "VisualizaDataDanfe")
{
reader.Read();
ckbDataSaidaDanfe.Checked = (reader.Value == "True" ? true : false);
continue;
}
if (reader.Name == "CodBarrasXml")
{
reader.Read();
chkCodBarras.Checked = (reader.Value == "True" ? true : false);
continue;
}
if (reader.Name == "TotalizaCFOP") //OS_25021
{
reader.Read();
chkTotCfop.Checked = (reader.Value == "True" ? true : false);
continue;
}
if (reader.Name == "AtivaModuloScan")
{
reader.Read();
chkModuloScan.Checked = (reader.Value == "True" ? true : false);
if (chkModuloScan.Checked)
{
nudScan.Enabled = true;
}
else
{
nudScan.Enabled = false;
}
continue;
} if (reader.Name == "SerieScan")
{
reader.Read();
nudScan.Value = Convert.ToDecimal(reader.Value);
continue;
} if (reader.Name == "AtivaModuloContingencia")
{
reader.Read();
chkContingencia.Checked = (reader.Value == "True" ? true : false);
continue;
}
if (reader.Name == "PastaArquivosEscritor")
{
reader.Read();
txtEscrituracao.Text = reader.Value.ToString().Trim();
}
if (reader.Name == "BancoEscritor")
{
reader.Read();
txtBancoEscritor.Text = reader.Value.ToString().Trim();
}
if (reader.Name == "ServidorEscritor")
{
reader.Read();
txtServidorEscritor.Text = reader.Value.ToString().Trim();
}
}
}
}
#endregion
reader.Close();
}
}
if (cbxFusoHorario.Text == "")
{
cbxFusoHorario.SelectedItem = "-02:00";
}
// Diego - OS-24566 - 18/06/2010
cbxIndustrializacao.SelectedIndex = 1;
// Diego - OS-24566 - 18/06/2010 - FIM
}
private void btnAtualiza_Click(object sender, EventArgs e)
{
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("SET GENERATOR gen_nomearqxml TO ");
sSql.Append(nudNovo_Lote.Value.ToString().Trim());
cx = new belConnection();
using (FbCommand cmd = new FbCommand(sSql.ToString(), cx.get_Conexao()))
{
cx.Open_Conexao();
cmd.ExecuteNonQuery();
}
CarregarDados();
}
catch (Exception)
{
throw;
}
finally { cx.Close_Conexao(); }
}
private void NotaDenegada(string sNfseq)
{
belConnection cx = new belConnection();
try
{
string sSql = string.Format("UPDATE NF SET " +
"cd_recibonfe = 'denegada', " +
"st_nfe = 'S' " +
(belUtil.CampoExisteNaTabela("ST_DENEGADA", "NF") ? " ,ST_DENEGADA = 'S' " : "") +
(belUtil.CampoExisteNaTabela("CD_STDOC", "NF") ? " ,CD_STDOC = '04' " : "") +
"WHERE CD_NFSEQ = '{0}' AND CD_EMPRESA = '{1}'",
sNfseq,
belStatic.codEmpresaNFe);
using (FbCommand cmdUpdate = new FbCommand(sSql.ToString(), cx.get_Conexao()))
{
cx.Open_Conexao();
cmdUpdate.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw;
}
finally { cx.Close_Conexao(); }
}
