public string GeraChave(string sCte)
{
try
{
string sChave = "";
DataTable dt = BuscaDadosChave(sCte);
foreach (DataRow drChave in dt.Rows)
{
bel.belUF objbelUf = new bel.belUF();
objbelUf.SiglaUF = drChave["sUF"].ToString();
string sData = daoUtil.GetDateServidor().Date.ToString("dd-MM-yyyy");
string scUF, sAAmM, sCNPJ, sMod, sSerie, snCT, scCT;
scUF = objbelUf.CUF;
sAAmM = sData.Substring(8, 2) + sData.Substring(3, 2);
sCNPJ = Util.TiraSimbolo(drChave["CNPJ"].ToString());
sCNPJ = sCNPJ.PadLeft(14, '0');
sMod = "57";
if (IsNumeric(drChave["serie"].ToString()))
{
sSerie = Acesso.TP_EMIS != 1 ? "900" : drChave["serie"].ToString().PadLeft(3, '0');
}
else
{
sSerie = Acesso.TP_EMIS != 1 ? "900" : "001";
}
snCT = drChave["nCT"].ToString().PadLeft(9, '0');
scCT = (Acesso.TP_EMIS != 1 ? "5" : "1") + drChave["cCT"].ToString().PadLeft(8, '0');
string sChaveantDig = "";
string sDig = "";
sChaveantDig = scUF.Trim() + sAAmM.Trim() + sCNPJ.Trim() + sMod.Trim() + sSerie.Trim() + snCT.Trim() + scCT.Trim();
sDig = CalculaDig11(sChaveantDig).ToString();
sChave = sChaveantDig + sDig;
}
return sChave;
}
catch (Exception ex)
{
throw ex;
}
}
public string GeraChave(string sCte)
{
try
{
string sChave = "";
DataTable dt = BuscaDadosChave(sCte);
foreach (DataRow drChave in dt.Rows)
{
bel.belUF objbelUf = new bel.belUF();
objbelUf.SiglaUF = drChave["sUF"].ToString();
string sData = daoUtil.GetDateServidor().Date.ToString("dd-MM-yyyy");
string scUF, sAAmM, sCNPJ, sMod, sSerie, snCT, scCT;
scUF = objbelUf.CUF;
sAAmM = sData.Substring(8, 2) + sData.Substring(3, 2);
sCNPJ = Util.TiraSimbolo(drChave["CNPJ"].ToString());
sCNPJ = sCNPJ.PadLeft(14, '0');
sMod = "57";
if (IsNumeric(drChave["serie"].ToString()))
{
sSerie = Acesso.TP_EMIS != 1 ? "900" : drChave["serie"].ToString().PadLeft(3, '0');
}
else
{
sSerie = Acesso.TP_EMIS != 1 ? "900" : "001";
}
snCT = drChave["nCT"].ToString().PadLeft(9, '0');
scCT = (Acesso.TP_EMIS != 1 ? "5" : "1") + drChave["cCT"].ToString().PadLeft(8, '0');
string sChaveantDig = "";
string sDig = "";
sChaveantDig = scUF.Trim() + sAAmM.Trim() + sCNPJ.Trim() + sMod.Trim() + sSerie.Trim() + snCT.Trim() + scCT.Trim();
sDig = CalculaDig11(sChaveantDig).ToString();
sChave = sChaveantDig + sDig;
}
return(sChave);
}
catch (Exception ex)
{
throw ex;
}
}
public void PopulaDadosInutilizacao(string sNumInicial, string sNumFinal, string sJustificativa)
{
try
{
objBelInutiliza = new belInutilizaFaixaCte();
StringBuilder sQuery = new StringBuilder();
sQuery.Append("Select ");
sQuery.Append("coalesce(empresa.cd_ufnor,'') cUF,");
sQuery.Append("coalesce(empresa.cd_cgc,'')CNPJ ");
sQuery.Append("from empresa ");
sQuery.Append("where empresa.cd_empresa ='" + belStatic.CodEmpresaCte + "' ");
FbCommand fbConn = new FbCommand(sQuery.ToString(), cx.get_Conexao());
cx.Open_Conexao();
fbConn.ExecuteNonQuery();
FbDataReader dr = fbConn.ExecuteReader();
dr.Read();
bel.belUF objbelUf = new bel.belUF();
objbelUf.SiglaUF = dr["cUF"].ToString();
objBelInutiliza.versao = "1.03";
objBelInutiliza.tpAmb = belStatic.TpAmb.ToString();
objBelInutiliza.xServ = "INUTILIZAR";
objBelInutiliza.cUF = objbelUf.CUF;
objBelInutiliza.ano = HLP.Util.Util.GetDateServidor().ToString("yy");
objBelInutiliza.CNPJ = util.TiraSimbolo(dr["CNPJ"].ToString());
objBelInutiliza.mod = "57";
objBelInutiliza.serie = "1";
objBelInutiliza.nCTIni = sNumInicial;
objBelInutiliza.nCTFin = sNumFinal;
objBelInutiliza.xJust = sJustificativa;
objBelInutiliza.Id = GeraChave(objBelInutiliza.cUF, objBelInutiliza.CNPJ, objBelInutiliza.nCTIni, objBelInutiliza.nCTFin);
}
catch (Exception)
{
throw;
}
finally { cx.Close_Conexao(); }
}
public string GeraChave(string sEmp, string sNF)
{
try
{
StringBuilder sSql = new StringBuilder();
sSql.Append("Select ");
sSql.Append("coalesce(empresa.cd_serie, 1) serie, c.cd_conheci nCT, ");
sSql.Append("empresa.cd_cgc CNPJ, c.nr_lanc cCT, empresa.cd_ufnor sUF ");
sSql.Append("From ");
sSql.Append("conhecim c inner join empresa on (empresa.cd_empresa = c.cd_empresa) ");
sSql.Append("where ");
sSql.Append("(c.cd_empresa ='");
sSql.Append(sEmp);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(c.nr_lanc = '");
sSql.Append(sNF);
sSql.Append("')");
FbCommand sqlConsulta = new FbCommand(sSql.ToString(), cx.get_Conexao());
cx.Open_Conexao();
sqlConsulta.ExecuteNonQuery();
FbDataReader drChave = sqlConsulta.ExecuteReader();
drChave.Read();
bel.belUF objbelUf = new bel.belUF();
objbelUf.SiglaUF = drChave["sUF"].ToString();
string sData = HLP.Util.Util.GetDateServidor().Date.ToString("dd-MM-yyyy");
string scUF, sAAmM, sCNPJ, sMod, sSerie, snCT, scCT;
scUF = objbelUf.CUF;
sAAmM = sData.Substring(8, 2) + sData.Substring(3, 2);
sCNPJ = util.TiraSimbolo(drChave["CNPJ"].ToString());
sCNPJ = sCNPJ.PadLeft(14, '0');
sMod = "57";
if (IsNumeric(drChave["serie"].ToString()))
{
sSerie = belStatic.bModoContingencia == true ? "900" : drChave["serie"].ToString().PadLeft(3, '0');
}
else
{
sSerie = belStatic.bModoContingencia == true ? "900" : "001";
}
snCT = drChave["nCT"].ToString().PadLeft(9, '0');
scCT = (belStatic.bModoContingencia == true ? "5" : "1") + drChave["cCT"].ToString().PadLeft(8, '0');
string sChaveantDig = "";
string sChave = "";
string sDig = "";
sChaveantDig = scUF.Trim() + sAAmM.Trim() + sCNPJ.Trim() + sMod.Trim() + sSerie.Trim() + snCT.Trim() + scCT.Trim();
sDig = CalculaDig11(sChaveantDig).ToString();
sChave = sChaveantDig + sDig;
return sChave;
}
catch (Exception ex)
{
throw ex;
}
finally { cx.Close_Conexao(); }
}
public void PopulaIde(string sCte, string sDigVerif, belinfCte objbelinfCte, string sId)
{
try
{
DataTable dt = BuscaDadosPopulaIde(sCte);
foreach (DataRow dr in dt.Rows)
{
objbelinfCte.ide = new belide();
bel.belUF objbelUF = new bel.belUF();
objbelinfCte.id = sId;
objbelinfCte.ide.cUF = objbelUF.RetornaCUF(dr["cUF"].ToString());
objbelinfCte.ide.cCT = dr["cCT"].ToString();
objbelinfCte.ide.CFOP = dr["CFOP"].ToString();
objbelinfCte.ide.natOp = dr["natOp"].ToString().Length > 60 ? dr["natOp"].ToString().Substring(0, 60) : dr["natOp"].ToString();
objbelinfCte.ide.forPag = Convert.ToInt32(dr["forPag"]);
objbelinfCte.ide.mod = "57";
objbelinfCte.ide.serie = Acesso.TP_EMIS == 3 ? "900" : "1";
objbelinfCte.ide.nCT = dr["nCT"].ToString();
objbelinfCte.ide.tpImp = "1";
objbelinfCte.ide.tpEmis = Acesso.TP_EMIS != 1 ? "5" : "1";
objbelinfCte.ide.cDV = sDigVerif;
objbelinfCte.ide.tpAmb = Convert.ToString(Acesso.TP_AMB);
objbelinfCte.ide.tpCTe = 0;
objbelinfCte.ide.procEmi = 0;
objbelinfCte.ide.verProc = Acesso.versaoCTe;
objbelinfCte.ide.xMunEnv = dr["xMunEmi"].ToString();
objbelinfCte.ide.UFEnv = dr["UFEmi"].ToString();
objbelinfCte.ide.cMunEnv = RetornaCodigoCidade(objbelinfCte.ide.xMunEnv, objbelinfCte.ide.UFEnv);
objbelinfCte.ide.modal = "01";
objbelinfCte.ide.tpServ = 0;
objbelinfCte.ide.xMunIni = dr["xMunIni"].ToString();
objbelinfCte.ide.UFIni = dr["UFIni"].ToString();
objbelinfCte.ide.cMunIni = dr["cMunIni"].ToString();
objbelinfCte.ide.xMunFim = dr["xMunFim"].ToString();
objbelinfCte.ide.UFFim = dr["UFFim"].ToString();
objbelinfCte.ide.cMunFim = dr["cMunFim"].ToString();
objbelinfCte.ide.retira = 0;
objbelinfCte.ide.xDetRetira = null;
if (dr["Veiculo"].ToString() != "")
{
objbelinfCte.ide.Veiculo.Add(dr["Veiculo"].ToString());
}
if (dr["Veiculo2"].ToString() != "")
{
objbelinfCte.ide.Veiculo.Add(dr["Veiculo2"].ToString());
}
if (dr["Veiculo3"].ToString() != "")
{
objbelinfCte.ide.Veiculo.Add(dr["Veiculo3"].ToString());
}
if (dr["Veiculo4"].ToString() != "")
{
objbelinfCte.ide.Veiculo.Add(dr["Veiculo4"].ToString());
}
objbelinfCte.ide.Motorista = dr["Motorista"].ToString();
string sTipoTomador = dr["Tomador"].ToString();
switch (sTipoTomador)
{
case "R": objbelinfCte.ide.toma03 = new beltoma03();
objbelinfCte.ide.toma03.toma = "0";
break;
case "D": objbelinfCte.ide.toma03 = new beltoma03();
objbelinfCte.ide.toma03.toma = "3";
break;
default: objbelinfCte.ide.toma04 = new beltoma04();
objbelinfCte.ide.toma04.toma = "4";
break;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void PopulaIde(string sCte, string sDigVerif, FbConnection conn, belinfCte objbelinfCte, string sId)
{
try
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append("select ");
sQuery.Append("coalesce(conhecim.cd_consignat,'')cd_consignat, ");
sQuery.Append("coalesce(empresa.cd_ufnor,'') cUF,");
sQuery.Append("coalesce(conhecim.cd_respons,'') Tomador,");
sQuery.Append("coalesce(conhecim.nr_lanc,'') cCT,");
sQuery.Append("coalesce(conhecim.cd_cfop,'') CFOP,");
sQuery.Append("coalesce(natop.ds_natop,'') natOp ,");
sQuery.Append("coalesce(conhecim.cd_serie,'') serie,");
sQuery.Append("coalesce(conhecim.cd_conheci,'') nCT,");
sQuery.Append("coalesce(empresa.nm_cidnor,'') xMunEmi,");
sQuery.Append("coalesce(empresa.cd_ufnor,'') UFEmi,");
sQuery.Append("coalesce(cidade1.cd_municipio,'') cMunIni,");
sQuery.Append("coalesce(conhecim.ds_cidcole,'') xMunIni,");
sQuery.Append("coalesce(conhecim.cd_ufcole,'') UFIni,");
sQuery.Append("coalesce(destino.cd_uf,'') UFFim, ");
sQuery.Append("coalesce(cidade2.cd_municipio,'') cMunFim,");
sQuery.Append("coalesce(conhecim.ds_calc,'') xMunFim,");
sQuery.Append("coalesce(conhecim.st_forpag,'1') forPag,");
sQuery.Append("coalesce(conhecim.cd_veiculo,'') Veiculo,");
sQuery.Append("coalesce(conhecim.cd_veiculo2,'') Veiculo2,");
sQuery.Append("coalesce(conhecim.cd_veiculo3,'') Veiculo3,");
sQuery.Append("coalesce(conhecim.cd_veiculo4,'') Veiculo4,");
sQuery.Append("coalesce(conhecim.cd_motoris,'') Motorista ");
sQuery.Append("from conhecim left join natop on conhecim.cd_cfop = natop.cd_cfop ");
sQuery.Append("left join empresa on conhecim.cd_empresa = empresa.cd_empresa ");
sQuery.Append("left join remetent destino on (destino.cd_remetent = conhecim.cd_redes and conhecim.cd_redes is not null) ");
sQuery.Append("or (destino.cd_remetent = conhecim.cd_destinat and conhecim.cd_redes is null) ");
sQuery.Append("left join clifor on conhecim.cd_clifor = clifor.cd_clifor ");
sQuery.Append("left join cidades cidade1 on cidade1.nm_cidnor = conhecim.ds_cidcole and cidade1.cd_ufnor = conhecim.cd_ufcole ");
sQuery.Append("left join cidades cidade2 on cidade2.nm_cidnor = conhecim.ds_calc and cidade2.cd_ufnor = destino.cd_uf ");
sQuery.Append("where empresa.cd_empresa ='" + belStatic.CodEmpresaCte);
sQuery.Append("' and conhecim.nr_lanc ='" + sCte + "'");
FbCommand fbConn = new FbCommand(sQuery.ToString(), conn);
fbConn.ExecuteNonQuery();
FbDataReader dr = fbConn.ExecuteReader();
dr.Read();
objbelinfCte.ide = new belide();
bel.belUF objbelUF = new bel.belUF();
objbelinfCte.id = sId;
objbelinfCte.ide.cUF = objbelUF.RetornaCUF(dr["cUF"].ToString());
objbelinfCte.ide.cCT = dr["cCT"].ToString();
objbelinfCte.ide.CFOP = dr["CFOP"].ToString();
objbelinfCte.ide.natOp = dr["natOp"].ToString().Length > 60 ? dr["natOp"].ToString().Substring(0, 60) : dr["natOp"].ToString();
objbelinfCte.ide.forPag = Convert.ToInt32(dr["forPag"]);
objbelinfCte.ide.mod = "57";
objbelinfCte.ide.serie = belStatic.bModoContingencia == true ? "900" : "1";
objbelinfCte.ide.nCT = dr["nCT"].ToString();
objbelinfCte.ide.tpImp = "1";
objbelinfCte.ide.tpEmis = belStatic.bModoContingencia == true ? "5" : "1";
objbelinfCte.ide.cDV = sDigVerif;
objbelinfCte.ide.tpAmb = Convert.ToString(belStatic.TpAmb);
objbelinfCte.ide.tpCTe = 0;
objbelinfCte.ide.procEmi = 0;
objbelinfCte.ide.verProc = "1.04";
objbelinfCte.ide.xMunEnv = dr["xMunEmi"].ToString();
objbelinfCte.ide.UFEnv = dr["UFEmi"].ToString();
objbelinfCte.ide.cMunEnv = RetornaCodigoCidade(objbelinfCte.ide.xMunEnv, objbelinfCte.ide.UFEnv, conn);
objbelinfCte.ide.modal = "01";
objbelinfCte.ide.tpServ = 0;
objbelinfCte.ide.xMunIni = dr["xMunIni"].ToString();
objbelinfCte.ide.UFIni = dr["UFIni"].ToString();
objbelinfCte.ide.cMunIni = dr["cMunIni"].ToString();
objbelinfCte.ide.xMunFim = dr["xMunFim"].ToString();
objbelinfCte.ide.UFFim = dr["UFFim"].ToString();
objbelinfCte.ide.cMunFim = dr["cMunFim"].ToString();
objbelinfCte.ide.retira = 0;
objbelinfCte.ide.xDetRetira = null;
if (dr["Veiculo"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo"].ToString()); }
if (dr["Veiculo2"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo2"].ToString()); }
if (dr["Veiculo3"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo3"].ToString()); }
if (dr["Veiculo4"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo4"].ToString()); }
objbelinfCte.ide.Motorista = dr["Motorista"].ToString();
string sTipoTomador = dr["Tomador"].ToString();
switch (sTipoTomador)
{
case "R": objbelinfCte.ide.toma03 = new beltoma03();
objbelinfCte.ide.toma03.toma = "0";
break;
case "D": objbelinfCte.ide.toma03 = new beltoma03();
objbelinfCte.ide.toma03.toma = "3";
break;
default: objbelinfCte.ide.toma04 = new beltoma04();
if (dr["cd_consignat"].ToString() != "")
{
CarregaToma4(dr["cd_consignat"].ToString(), objbelinfCte.ide.toma04, conn);
}
else
{
throw new Exception("Não foi selecionado um Consignatário no sistema");
}
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
public void PopulaIde(string sCte, string sDigVerif, belinfCte objbelinfCte, string sId)
{
try
{
DataTable dt = BuscaDadosPopulaIde(sCte);
foreach (DataRow dr in dt.Rows)
{
objbelinfCte.ide = new belide();
bel.belUF objbelUF = new bel.belUF();
objbelinfCte.id = sId;
objbelinfCte.ide.cUF = objbelUF.RetornaCUF(dr["cUF"].ToString());
objbelinfCte.ide.cCT = dr["cCT"].ToString();
objbelinfCte.ide.CFOP = dr["CFOP"].ToString();
objbelinfCte.ide.natOp = dr["natOp"].ToString().Length > 60 ? dr["natOp"].ToString().Substring(0, 60) : dr["natOp"].ToString();
objbelinfCte.ide.forPag = Convert.ToInt32(dr["forPag"]);
objbelinfCte.ide.mod = "57";
objbelinfCte.ide.serie = Acesso.TP_EMIS == 3 ? "900" : "1";
objbelinfCte.ide.nCT = dr["nCT"].ToString();
objbelinfCte.ide.tpImp = "1";
objbelinfCte.ide.tpEmis = Acesso.TP_EMIS != 1 ? "5" : "1";
objbelinfCte.ide.cDV = sDigVerif;
objbelinfCte.ide.tpAmb = Convert.ToString(Acesso.TP_AMB);
objbelinfCte.ide.tpCTe = 0;
objbelinfCte.ide.procEmi = 0;
objbelinfCte.ide.verProc = Acesso.versaoCTe;
objbelinfCte.ide.xMunEnv = dr["xMunEmi"].ToString();
objbelinfCte.ide.UFEnv = dr["UFEmi"].ToString();
objbelinfCte.ide.cMunEnv = RetornaCodigoCidade(objbelinfCte.ide.xMunEnv, objbelinfCte.ide.UFEnv);
objbelinfCte.ide.modal = "01";
objbelinfCte.ide.tpServ = 0;
objbelinfCte.ide.xMunIni = dr["xMunIni"].ToString();
objbelinfCte.ide.UFIni = dr["UFIni"].ToString();
objbelinfCte.ide.cMunIni = dr["cMunIni"].ToString();
objbelinfCte.ide.xMunFim = dr["xMunFim"].ToString();
objbelinfCte.ide.UFFim = dr["UFFim"].ToString();
objbelinfCte.ide.cMunFim = dr["cMunFim"].ToString();
objbelinfCte.ide.retira = 0;
objbelinfCte.ide.xDetRetira = null;
if (dr["Veiculo"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo"].ToString()); }
if (dr["Veiculo2"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo2"].ToString()); }
if (dr["Veiculo3"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo3"].ToString()); }
if (dr["Veiculo4"].ToString() != "") { objbelinfCte.ide.Veiculo.Add(dr["Veiculo4"].ToString()); }
objbelinfCte.ide.Motorista = dr["Motorista"].ToString();
string sTipoTomador = dr["Tomador"].ToString();
switch (sTipoTomador)
{
case "R": objbelinfCte.ide.toma03 = new beltoma03();
objbelinfCte.ide.toma03.toma = "0";
break;
case "D": objbelinfCte.ide.toma03 = new beltoma03();
objbelinfCte.ide.toma03.toma = "3";
break;
default: objbelinfCte.ide.toma04 = new beltoma04();
objbelinfCte.ide.toma04.toma = "4";
break;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
