public belInfAdic xmlBuscaInfAdic()
{
belInfAdic objInfAdic = new belInfAdic();
XmlDocument xInfAdic = new XmlDocument();
try
{
if (xDoc.GetElementsByTagName("infAdic").Count > 0)
{
xInfAdic.LoadXml(xDoc.GetElementsByTagName("infAdic")[0].OuterXml);
if (xInfAdic.GetElementsByTagName("infAdFisco").Count > 0)
{
objInfAdic.Infadfisco = xInfAdic.GetElementsByTagName("infAdFisco")[0].InnerText;
}
if (xInfAdic.GetElementsByTagName("infCpl").Count > 0)
{
objInfAdic.Infcpl = xInfAdic.GetElementsByTagName("infCpl")[0].InnerText;
}
if (xInfAdic.GetElementsByTagName("obsCont").Count > 0)
{
XmlDocument xobsCont = new XmlDocument();
belObsCont objObsCount = new belObsCont();
xobsCont.LoadXml(xInfAdic.GetElementsByTagName("obsCont")[0].OuterXml);
if (xobsCont.GetElementsByTagName("xCampo").Count > 0)
{
objObsCount.Xcampo = xobsCont.GetElementsByTagName("xCampo")[0].InnerText;
}
if (xobsCont.GetElementsByTagName("xTexto").Count > 0)
{
objObsCount.Xtexto = xobsCont.GetElementsByTagName("xTexto")[0].InnerText;
}
objInfAdic.belObsCont = objObsCount;
}
if (xInfAdic.GetElementsByTagName("obsFisco").Count > 0)
{
XmlDocument xobsFisco = new XmlDocument();
belObsCont objObsFisco = new belObsCont();
xobsFisco.LoadXml(xInfAdic.GetElementsByTagName("obsFisco")[0].OuterXml);
if (xobsFisco.GetElementsByTagName("xCampo").Count > 0)
{
objObsFisco.Xcampo = xobsFisco.GetElementsByTagName("xCampo")[0].InnerText;
}
if (xobsFisco.GetElementsByTagName("xTexto").Count > 0)
{
objObsFisco.Xtexto = xobsFisco.GetElementsByTagName("xTexto")[0].InnerText;
}
objInfAdic.belObsCont = objObsFisco;
}
if (xInfAdic.GetElementsByTagName("procRef").Count > 0)
{
XmlDocument xProcRef = new XmlDocument();
belProcRef objProcRef = new belProcRef();
xProcRef.LoadXml(xInfAdic.GetElementsByTagName("procRef")[0].OuterXml);
if (xProcRef.GetElementsByTagName("nProc").Count > 0)
{
objProcRef.Nproc = xProcRef.GetElementsByTagName("nProc")[0].InnerText;
}
if (xProcRef.GetElementsByTagName("indProc").Count > 0)
{
objProcRef.Indproc = xProcRef.GetElementsByTagName("indProc")[0].InnerText;
}
objInfAdic.belProcRef = objProcRef;
}
}
}
catch (Exception ex)
{
throw new Exception(string.Format("Problemas lendo a Tag infAdic, Erro.: {0}",
ex.Message));
}
return objInfAdic;
}
public belInfAdic BuscaObs(string sEmp,
string sNF,
belDest objbeldest,
List<belDet> objbelDet, belGerarXML objbelGeraXml)
{
belInfAdic objinfadic = new belInfAdic();
try
{
StringBuilder sSql = new StringBuilder();
//Campos do Select
sSql.Append("Select ");
sSql.Append("nf.ds_anota ");
if (((objbelGeraXml.nm_Cliente == "MOGPLAST") || (objbelGeraXml.nm_Cliente == "TSA")) && (sEmp == "003"))
{
sSql.Append(", nf.cd_nfseq_fat_origem ");
}
if (objbelGeraXml.nm_Cliente == "MACROTEX")
{
sSql.Append(", vendedor.nm_vend, ");
sSql.Append("nf.DS_DOCORIG ");
}
//Tabela
sSql.Append("From NF ");
//Relacionamentos
sSql.Append("left join vendedor on (vendedor.cd_vend = nf.cd_vend1) ");
//Where
sSql.Append("Where ");
sSql.Append("(NF.cd_empresa ='");
sSql.Append(sEmp);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(nf.cd_nfseq = '");
sSql.Append(sNF);
sSql.Append("') ");
string sObs = "";
sObs = RetornaBlob(sSql, sEmp, Conn, objbelGeraXml);
if (sObs.IndexOf("\\fs") != -1)// DIEGO - OS_24854
{
sObs = sObs.Substring((sObs.IndexOf("\\fs") + 6), sObs.Length - (sObs.IndexOf("\\fs") + 6));
}
if (objbelGeraXml.nm_Cliente == "MARPA")
{
sObs += MontaObsAgrup(sEmp, sNF, Conn);
}
Globais LeRegWin = new Globais();
string sBanco = LeRegWin.LeRegConfig("BancoDados");
{
//Fim - Danner - o.s. 24383 - 22/04/2010
//belGerarXML BuscaConexao = new belGerarXML();
//FbConnection Conn = BuscaConexao.Conn;
#region OS_24245
try
{
if (sBanco.ToUpper().IndexOf("CERAMICAC0") == -1) //Claudinei - o.s. 24245 - 08/03/2010
{
StringBuilder sSuframa = new StringBuilder();
sSuframa.Append("Select First 1 ");
sSuframa.Append("nf.ds_anota, ");
sSuframa.Append("clifor.st_descsuframa, ");
sSuframa.Append("clifor.cd_suframa, ");
sSuframa.Append("clifor.ST_PISCOFINS_SUFRAMA, ");
sSuframa.Append("nf.vl_aliqcofins_suframa, ");
sSuframa.Append("nf.vl_aliqpis_suframa, ");
sSuframa.Append("nf.vl_cofins_suframa, ");
sSuframa.Append("NF.vl_pis_suframa, ");
//Claudinei - o.s. 23683 - 11/09/2009
sSuframa.Append("(select Sum(movitem.vl_descsuframa) from movitem where (movitem.cd_empresa = nf.cd_empresa) and (movitem.cd_nfseq = nf.cd_nfseq)) vl_suframa, ");
sSuframa.Append("icm.vl_aliquot vl_persuframa ");
//Fim - Claudinei - o.s. 23683 - 11/09/2009
//Claudinei - o.s. 23827 - 17/11/2009
sSuframa.Append(", ");
sSuframa.Append("case when empresa.vl_aliqfatcred > 0 then ");
sSuframa.Append("(nf.vl_totnf * empresa.vl_aliqfatcred)/100 ");
sSuframa.Append("else ");
sSuframa.Append("0 ");
sSuframa.Append("end aliq, ");
sSuframa.Append("empresa.vl_aliqfatcred, ");
sSuframa.Append("coalesce(tpdoc.st_hevenda,'N') st_hevenda ");
//Fim - Claudinei - o.s. 23827 - 17/11/2009
//Tabela
sSuframa.Append("From NF ");
//Relacionamentos
sSuframa.Append("left join clifor on (clifor.cd_clifor = nf.cd_clifor) ");
sSuframa.Append("left join icm on (icm.cd_ufnor = clifor.cd_ufnor) ");
sSuframa.Append("left join movitem on (movitem.cd_empresa = nf.cd_empresa) ");
sSuframa.Append("and ");
sSuframa.Append("(movitem.cd_nfseq = nf.cd_nfseq) ");
//Claudinei - o.s. 23827 - 17/11/2009
sSuframa.Append("Inner join ");
sSuframa.Append("Empresa on ");
sSuframa.Append("(Empresa.cd_empresa = nf.cd_empresa) ");
sSuframa.Append("Left join ");
sSuframa.Append("TPDoc on ");
sSuframa.Append("(TPDoc.cd_tipodoc = nf.cd_tipodoc) ");
//Fim - Claudinei - o.s. 23827 - 17/11/2009
//Where
sSuframa.Append("Where ");
sSuframa.Append("(NF.cd_empresa ='");
sSuframa.Append(sEmp);
sSuframa.Append("')");
sSuframa.Append(" and ");
sSuframa.Append("(nf.cd_nfseq = '");
sSuframa.Append(sNF);
sSuframa.Append("') ");
//Conn.Open();
FbCommand cmdSuframa = new FbCommand(sSuframa.ToString(), Conn);
cmdSuframa.ExecuteNonQuery();
FbDataReader drSuframa = cmdSuframa.ExecuteReader();
drSuframa.Read();
if (drSuframa["st_descsuframa"].ToString() == "S")
{
//Claudinei - o.s. 23683 - 11/09/2009
decimal dvlSuframa = Math.Round(Convert.ToDecimal(drSuframa["vl_suframa"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
decimal dvlPerSuframa = Math.Round(Convert.ToDecimal(drSuframa["vl_persuframa"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
//Fim - Claudinei - o.s. 23683 - 11/09/2009
if (sObs.Trim() != "")
{
sObs += string.Format(" - DESCONTO DE {0:C2} REF. AO ICMS {1:f2}% CODIGO SUFRAMA: {2}",
dvlSuframa,
dvlPerSuframa,
drSuframa["cd_suframa"].ToString());
}
else
{
sObs += string.Format("DESCONTO DE {0:C2} REF. AO ICMS 7.00% CODIGO SUFRAMA: {1}",
dvlSuframa,
drSuframa["cd_suframa"].ToString());
}
}
//Claudinei - o.s. sem - 01/09/2009
if (drSuframa["ST_PISCOFINS_SUFRAMA"].ToString() == "S")
{
decimal dvl_aliqcofins_suframa = Math.Round(Convert.ToDecimal(drSuframa["vl_aliqcofins_suframa"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
decimal dvl_cofins_suframa = Math.Round(Convert.ToDecimal(drSuframa["vl_cofins_suframa"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
decimal dvl_aliqpis_suframa = Math.Round(Convert.ToDecimal(drSuframa["vl_aliqpis_suframa"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
decimal dvl_pis_suframa = Math.Round(Convert.ToDecimal(drSuframa["vl_pis_suframa"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
if (sObs.Trim() != "")
{
sObs += string.Format(" - ABATIMENTO COFINS ({0}%) - VALOR R$ {1} - ABATIMENTO PIS ({2}%) - VALOR R$ {3} ",
dvl_aliqcofins_suframa.ToString("#0.00").Replace(',', '.'),
dvl_cofins_suframa.ToString("#0.00").Replace(',', '.'),
dvl_aliqpis_suframa.ToString("#0.00").Replace(',', '.'),
dvl_pis_suframa.ToString("#0.00").Replace(',', '.'));
}
else
{
sObs += string.Format("ABATIMENTO COFINS ({0}%) - VALOR R$ {1} - ABATIMENTO PIS ({2}%) - VALOR R$ {3} ",
dvl_aliqcofins_suframa.ToString("#0.0000").Replace(',', '.'),
dvl_cofins_suframa.ToString("#0.0000").Replace(',', '.'),
dvl_aliqpis_suframa.ToString("#0.0000").Replace(',', '.'),
dvl_pis_suframa.ToString("#0.0000").Replace(',', '.'));
}
}
decimal dvlnf = 0;
if (drSuframa["aliq"].ToString() != "")
{
dvlnf = Math.Round(Convert.ToDecimal(drSuframa["aliq"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
}
}
StringBuilder sDevolucao = new StringBuilder();
//Tabela
sDevolucao.Append("Select ");
sDevolucao.Append("movitem.cd_doc, ");
sDevolucao.Append("nf.cd_clifor, ");
sDevolucao.Append("nf.dt_emi, ");
sDevolucao.Append("movensai.dt_emi EmissaoEntrada, ");
sDevolucao.Append("movitem.vl_totbruto ");
sDevolucao.Append("From Movitem ");
sDevolucao.Append("inner join NF on ");
sDevolucao.Append("(nf.cd_empresa = Movitem.cd_empresa) ");
sDevolucao.Append("and ");
sDevolucao.Append("(nf.cd_nfseq = movitem.cd_nfseq) ");
sDevolucao.Append("inner join opereve on ");
sDevolucao.Append("(opereve.cd_oper = movitem.cd_oper) ");
sDevolucao.Append("left join movensai on (movensai.cd_empresa = movitem.cd_empresa) ");
sDevolucao.Append("and ");
sDevolucao.Append("(movensai.cd_doc = movitem.cd_doc) ");
sDevolucao.Append("and ");
sDevolucao.Append("(movensai.cd_clifor = nf.cd_clifor) ");
//Where
sDevolucao.Append("Where ");
sDevolucao.Append("(Movitem.cd_empresa ='");
sDevolucao.Append(sEmp);
sDevolucao.Append("')");
sDevolucao.Append(" and ");
sDevolucao.Append("(Movitem.cd_nfseq = '");
sDevolucao.Append(sNF);
sDevolucao.Append("') ");
sDevolucao.Append("and ");
sDevolucao.Append("(opereve.ST_ESTTERC = 'S') ");
sDevolucao.Append("and ");
sDevolucao.Append("Movitem.cd_oper <> '202' ");
sDevolucao.Append("and ");
sDevolucao.Append("Movitem.cd_oper <> '227' ");//TESTE-DANI
sDevolucao.Append("Order by movitem.cd_doc");
//if (Conn.State != ConnectionState.Open)
{
//Conn.Open();
}
FbCommand cmdDevolucoes = new FbCommand(sDevolucao.ToString(), Conn);
cmdDevolucoes.ExecuteNonQuery();
FbDataReader drDevolucoes = cmdDevolucoes.ExecuteReader();
List<strucDevolucoes> Devolucoes = new List<strucDevolucoes>();
decimal dvlTotBruto = 0;
string scdDoc = string.Empty;
while (drDevolucoes.Read())
{
if (scdDoc != drDevolucoes["cd_doc"].ToString())
{
dvlTotBruto = 0;
}
dvlTotBruto += Math.Round(Convert.ToDecimal(drDevolucoes["vl_totbruto"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010
StringBuilder sStore = new StringBuilder();
sStore.Append("SELECT ");
sStore.Append("QT_SALDOEN ");
sStore.Append("FROM SP_SALDOTER('");
sStore.Append(sEmp);
sStore.Append("', '");
sStore.Append(drDevolucoes["cd_clifor"].ToString());
sStore.Append("', '");
sStore.Append(" "); //Claudinei - o.s. 24075 - 29/01/2010
sStore.Append("', '");
sStore.Append("|||||||"); //Claudinei - o.s. 24075 - 29/01/2010
sStore.Append("', '");
sStore.Append("X");
sStore.Append("', '");
sStore.Append("N");
sStore.Append("', '");
sStore.Append(sNF);
sStore.Append("', '");
sStore.Append(Convert.ToDateTime(drDevolucoes["dt_emi"]).ToString("dd.MM.yyyy"));
sStore.Append("') ");
sStore.Append("where SP_SALDOTER.cd_doc ='");
sStore.Append(drDevolucoes["cd_doc"].ToString().Trim());
sStore.Append("'");
sStore.Append(" and ");
sStore.Append("SP_SALDOTER.qt_saldoen > 0");
FbCommand cmd = new FbCommand();
cmd.Connection = Conn;
cmd.CommandText = sStore.ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
//if (Conn.State != ConnectionState.Open)
{
//Conn.Open();
}
Int32 iSaldoTer = Convert.ToInt32(cmd.ExecuteScalar());
strucDevolucoes Devolucao = new strucDevolucoes();
if (drDevolucoes["cd_doc"].ToString() != "")
{
Devolucao.scdNotafis = drDevolucoes["cd_doc"].ToString();
if (drDevolucoes["EmissaoEntrada"] != System.DBNull.Value)
{
Devolucao.dDtEmi = Convert.ToDateTime(drDevolucoes["EmissaoEntrada"]);
}
Devolucao.dValorNF = dvlTotBruto.ToString("#0.00");
Devolucao.sSaldo = (iSaldoTer > 0 ? "Parcial" : "Total");
if (!Devolucoes.Exists(c => c.scdNotafis == Devolucao.scdNotafis))
{
Devolucoes.Add(Devolucao);
}
else
{
for (int i = 0; i < Devolucoes.Count; i++)
{
if ((Devolucoes[i].scdNotafis == Devolucao.scdNotafis) && (Devolucoes[i].dDtEmi == Devolucao.dDtEmi)) //OS_25220
{
Devolucoes[i] = Devolucao;
break;
}
}
}
}
scdDoc = drDevolucoes["cd_doc"].ToString();
}
for (int i = 0; i < Devolucoes.Count; i++)
{
if (sObs.Trim().Length > 0)
{
sObs += string.Format(" - Devolucao {0} ref. sua NF {1} de {2} de valor R$ {3}", //Claudinei - o.s. 24043 - 25/01/2010
Devolucoes[i].sSaldo,
Devolucoes[i].scdNotafis,
Devolucoes[i].dDtEmi.ToString("dd/MM/yyyy"),
Devolucoes[i].dValorNF); //Claudinei - o.s. 24043 - 25/01/2010
}
else
{
sObs += string.Format("Devolucao {0} ref. sua NF {1} de {2} de valor R$ {3}", //Claudinei - o.s. 24043 - 25/01/2010
Devolucoes[i].sSaldo,
Devolucoes[i].scdNotafis,
Devolucoes[i].dDtEmi.ToString("dd/MM/yyyy"),
Devolucoes[i].dValorNF); //Claudinei - o.s. 24043 - 25/01/2010
}
}
string sMensagemSuperSimples = MensagemSuperSimples(sEmp, sNF, Conn);
bool cfopsValidos = (objbelDet.Count(p => (p.belProd.Cfop.Equals("5101"))
|| (p.belProd.Cfop.Equals("6107"))
|| (p.belProd.Cfop.Equals("6101"))) > 0 ? true : false);
if (sMensagemSuperSimples != ""
&& (objbeldest.Cnpj != null && objbeldest.Cnpj != "")
|| (objbelGeraXml.nm_Cliente == "TERRAVIS")
&& cfopsValidos) // OS_25182
{
if (sObs.Trim().Length > 0)
{
sObs += " - " + sMensagemSuperSimples;
}
else
{
sObs += sMensagemSuperSimples;
}
}
//Claudinei - o.s. 24118 - 11/02/2010
}
catch (Exception Ex)
{
sExecao = " - Problemas ao Buscar Suframa";
throw new Exception(Ex.Message + sExecao);
}
finally
{
//Conn.Close();
}
#endregion
}
// Diego - 22/06/2010 - OS_24576
//Monta Mensagem de PIS, COFINS
try
{
//belGerarXML BuscaConexao = new belGerarXML();
//FbConnection Conn = BuscaConexao.Conn;
//if (Conn.State != ConnectionState.Open)
{
//Conn.Open();
}
StringBuilder sQuery = new StringBuilder();
sQuery.Append("SELECT ");
sQuery.Append("NF.VL_COFINS, NF.VL_PIS, ");
sQuery.Append("empresa.vl_aliqpis_suframa,empresa.vl_aliqcofins_suframa, ");
sQuery.Append("CLIFOR.st_desc_piscofins_dupl ");
sQuery.Append("from nf inner join empresa ");
sQuery.Append("on (nf.cd_empresa = empresa.cd_empresa)");
sQuery.Append("inner join clifor ");
sQuery.Append("on (nf.cd_clifor = clifor.cd_clifor) ");
sQuery.Append("where (empresa.cd_empresa = '");
sQuery.Append(sEmp);
sQuery.Append("') ");
sQuery.Append("and ( nf.cd_nfseq = '");
sQuery.Append(sNF);
sQuery.Append("') ");
FbCommand cmd = new FbCommand(sQuery.ToString(), Conn);
FbDataReader drPisCofins = cmd.ExecuteReader();
while (drPisCofins.Read())
{
if ((drPisCofins["st_desc_piscofins_dupl"].ToString() == "S"))
{
if ((drPisCofins["vl_aliqpis_suframa"].ToString() != "") && (drPisCofins["vl_aliqcofins_suframa"].ToString() != ""))
{
string sMensagemPisCofins = "(PIS e COFINS retido conforme artigo 3º paragrafo 4º da lei 10.485/02, PIS "
+ drPisCofins["vl_aliqpis_suframa"].ToString()
+ "% R$" + drPisCofins["VL_PIS"].ToString()
+ " , COFINS "
+ drPisCofins["vl_aliqcofins_suframa"].ToString()
+ "% R$"
+ drPisCofins["VL_COFINS"].ToString()
+ " Total R$" + ((Convert.ToDouble(drPisCofins["VL_PIS"].ToString())) + (Convert.ToDouble(drPisCofins["VL_COFINS"].ToString()))).ToString() + ")";
sObs += (sObs != "" ? " - " : "") + sMensagemPisCofins;
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}// Diego - 22/06/2010 - OS_24576 - FIM
// Diego - 15/07/2010 - OS_24665
//Obs de ICMS Recolhido por Substituição
try
{
//belGerarXML BuscaConexao = new belGerarXML();
//FbConnection Conn = BuscaConexao.Conn;
StringBuilder sQuery = new StringBuilder();
sQuery.Append("SELECT ");
sQuery.Append("movitem.cd_sittrib, EMPRESA.ST_SUPERSIMPLES, EMPRESA.ST_IMP_SUPERSIMPLES ");
sQuery.Append("from empresa INNER JOIN movitem ON (EMPRESA.cd_empresa = movitem.cd_empresa)");
sQuery.Append("where (empresa.cd_empresa = '");
sQuery.Append(sEmp);
sQuery.Append("') ");
sQuery.Append("and ( movitem.cd_nfseq = '");
sQuery.Append(sNF);
sQuery.Append("') ");
FbCommand cmd = new FbCommand(sQuery.ToString(), Conn);
FbDataReader drIcmsRecolhido = cmd.ExecuteReader();
string sMensagemIcmsRecolhido = "";
while (drIcmsRecolhido.Read())
{
if ((drIcmsRecolhido["ST_SUPERSIMPLES"].ToString() == "S") && (drIcmsRecolhido["ST_IMP_SUPERSIMPLES"].ToString() == "S"))
{
if ((drIcmsRecolhido["cd_sittrib"].ToString().Equals("010")) ||
(drIcmsRecolhido["cd_sittrib"].ToString().Equals("030")) ||
(drIcmsRecolhido["cd_sittrib"].ToString().Equals("060")) ||
(drIcmsRecolhido["cd_sittrib"].ToString().Equals("070")))
{
sMensagemIcmsRecolhido = "ICMS RECOLHIDO POR SUBSTITUICAO TRIBUTARIA CONFORME DECRETO 54251/09 ART 313 RICMS/2000";
break;
}
}
}
if (sMensagemIcmsRecolhido != "")
{
sObs += (sObs.Trim() != "" ? " - " : "") + sMensagemIcmsRecolhido;
}
}
catch (Exception Ex)
{
throw Ex;
}
// Diego - 15/07/2010 - OS_24665 - FIM
//OS_25201 - DIEGO
if (LeRegWin.LeRegConfig("TotalizaCFOP").Equals("True"))
{
sObs += " " + MessagemTotalizaCFOP(sEmp, sNF, Conn);
}//OS_25201 - FIM
//OS_25224 - INICIO
string sCNPJdest = (objbeldest.Cnpj != null ? Util.Util.RetiraCaracterCNPJ(objbeldest.Cnpj) : "");
try
{
//belGerarXML BuscaConexao = new belGerarXML();
//FbConnection Conn = BuscaConexao.Conn;
if (objbelGeraXml.Equals("JAMAICA"))
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append("select coalesce(clifor.cd_alter2,'') cd_alter2 from clifor ");
sQuery.Append("where clifor.cd_cgc ='" + sCNPJdest + "'");
FbCommand cmd = new FbCommand(sQuery.ToString(), Conn);
FbDataReader dr = cmd.ExecuteReader();
string sMesgCodDest = "";
while (dr.Read())
{
sMesgCodDest = dr["cd_alter2"].ToString();
}
if (sMesgCodDest != "")
{
sObs = "<<COD FORNECEDOR " + sMesgCodDest + ">> " + sObs;
}
}
if (objbelGeraXml.nm_Cliente.Equals("LORENZON"))
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append("select prazos.ds_prazo, vendedor.nm_vend , clifor.cd_clifor from nf ");
sQuery.Append("inner join clifor on nf.cd_clifor = clifor.cd_clifor ");
sQuery.Append("inner join prazos on nf.cd_prazo = prazos.cd_prazo ");
sQuery.Append(" inner join vendedor on nf.cd_vendint = vendedor.cd_vend ");
sQuery.Append("where nf.cd_nfseq = '" + sNF + "' ");
sQuery.Append("and nf.cd_empresa = '" + sEmp + "' ");
FbCommand cmd = new FbCommand(sQuery.ToString(), Conn);
FbDataReader dr = cmd.ExecuteReader();
string sMsgLorenzon = "";
while (dr.Read())
{
sMsgLorenzon = "COND.PGTO = " + dr["ds_prazo"].ToString() + " | VENDEDOR = " + dr["nm_vend"].ToString() + " | COD. CLIENTE = " + dr["cd_clifor"].ToString();
}
if (sMsgLorenzon != "")
{
sObs = "<< " + sMsgLorenzon + " >> " + sObs;
}
}
}
catch (Exception ex)
{
throw ex;
}
//OS_25224 - FIM
if (sObs.Trim() != "")
{
objinfadic.Infcpl = sObs.Trim();
}
//Fim - Montagem do XML
}
catch (Exception Ex)
{
sExecao = " - Problemas nas Obs´s da Nota";
throw new Exception(Ex.Message + sExecao);
}
return objinfadic; //Danner - o.s. sem - 16/11/2009
}
private void Gravar()
{
List<object> lObj = new List<object>();
try
{
#region IDE
objide = new belIde();
objide.Cuf = Convert.ToString(cbxUF.SelectedValue).Trim();
objide.Cnf = txtSeq.Text;
objide.Natop = txtNatOp.Text;
objide.Indpag = Convert.ToString(cbxIndPag.SelectedIndex).Trim();
objide.Mod = txtMod.Text.Trim();
objide.Serie = txtSerie.Text.Trim();
objide.Nnf = txtNNF.Text.Trim();
objide.Demi = Convert.ToDateTime(mtbDEmi.Text);
objide.Dsaient = Convert.ToDateTime(mtbDSaiEnt.Text);
objide.Tpnf = Convert.ToString(cbxTpNF.SelectedIndex);
objide.Cmunfg = txtCMunFG.Text.Trim();
objide.Tpimp = Convert.ToString((int)cbxtpImp.SelectedIndex + 1);
objide.Tpemis = Convert.ToString((int)cbcxTpEmis.SelectedIndex + 1);
objide.Cdv = txtCDV.Text.Trim();
objide.Tpamb = Convert.ToString((int)cbxTpAmb.SelectedIndex + 1);
objide.Finnfe = Convert.ToString((int)cbxFinNFe.SelectedIndex + 1);
objide.Procemi = txtProcEmi.Text.Trim();
objide.Verproc = txtVerProc.Text.Trim();
if (belNFrefBindingSource.Count > 0) // 25360
{
List<belNFref> lObjNFref = new List<belNFref>();
for (int i = 0; i < belNFrefBindingSource.Count; i++)
{
lObjNFref.Add((belNFref)belNFrefBindingSource[i]);
if (lObjNFref[i].cUF != null)
{
if (!HLP.Util.Util.IsNumeric(lObjNFref[i].cUF))
{
belUF objuf = new belUF();
lObjNFref[i].cUF = objuf.RetornaCUF((lObjNFref[i].cUF));
lObjNFref[i].CNPJ = (lObjNFref[i].CNPJ).Replace(",", "").Replace("/", "").Replace("-", "");
lObjNFref[i].nNF = (Convert.ToInt32(lObjNFref[i].nNF)).ToString();
}
}
}
objide.belNFref = lObjNFref;
}
objide.HSaiEnt = dtpHSaiEnt.Value; //NFe_2.0
lObj.Add(objide);
#endregion
#region Emitente
belEmit objemit = new belEmit();
if (cbxPessoaEmit.SelectedIndex == 0)
{
objemit.Cpf = mtbCpfCnpjEmit.Text;
}
else
{
objemit.Cnpj = mtbCpfCnpjEmit.Text;
}
objemit.Xnome = txtXNomeEmit.Text.Trim();
objemit.Xfant = txtXFantEmit.Text.Trim();
if (txtIEEmit.Text != "")
{
objemit.Ie = txtIEEmit.Text.Trim();
}
if (txtIESTEmit.Text != "")
{
objemit.Iest = txtIESTEmit.Text.Trim();
}
if (txtIM.Text != "")
{
objemit.Im = txtIM.Text.Trim();
}
if (txtCNAE.Text != "")
{
objemit.Cnae = txtCNAE.Text;
}
//Endereço
objemit.Xlgr = txtEnderEmitXlgr.Text.Trim();
objemit.Nro = txtEnderEmitNum.Text.Trim();
if (txtEnderEmitCompl.Text != "")
{
objemit.Xcpl = txtEnderEmitCompl.Text.Trim();
}
objemit.Xbairro = txtEnderEmitXbairro.Text.Trim();
objemit.Cmun = txtEnderEmitCmun.Text.Trim();
objemit.Xmun = txtEnderEmitXmun.Text.Trim();
objemit.Uf = txtEnderEmitUF.Text.Trim();
objemit.Cpais = txtEnderEmitCpais.Text.Trim();
objemit.Xpais = txtEnderEmitXpais.Text.Trim();
objemit.Cep = mtbEnderEmitCep.Text.Trim();
objemit.Fone = mtbEnderEmitFone.Text.Trim();
switch (cmbCRT.SelectedIndex) // NFe_2.0
{
case 0: objemit.CRT = 1;
break;
case 1: objemit.CRT = 2;
break;
case 2: objemit.CRT = 3;
break;
}
//Fim - Endereço
lObj.Add(objemit);
#endregion
#region Destinatário
belDest objdest = new belDest();
if (mtbCpfCnpjDest.Mask.Equals("00.000.000/0000-00") || mtbCpfCnpjDest.Text.ToString().ToUpper().Equals("EXTERIOR"))
{
objdest.Cnpj = mtbCpfCnpjDest.Text.Trim();
}
else
{
objdest.Cpf = mtbCpfCnpjDest.Text.Trim();
}
objdest.Xnome = (belStatic.TpAmb == 2 ? "NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL"
: txtXnomeDest.Text.Trim());
objdest.Ie = txtIEDest.Text.Trim();// (belStatic.tpAmb == 2 ? "" : txtIEDest.Text.Trim());
if (txtISUFDest.Text != "")
{
objdest.Isuf = txtISUFDest.Text.Trim();
}
//Endereço
objdest.Xlgr = txtEnderDestXlgr.Text.Trim();
objdest.Nro = txtEnderDestNro.Text.Trim();
objdest.Xcpl = txtEnderDestCpl.Text.Trim(); //OS_26347
objdest.Xbairro = txtEnderDestXbairro.Text.Trim();
objdest.Cmun = txtEnderDestCmun.Text.Trim();
objdest.Xmun = txtEnderDestXmun.Text.Trim();
objdest.Uf = txtEnderDestUF.Text.Trim();
objdest.Cpais = txtEnderDestCpais.Text.Trim();
objdest.Xpais = txtEnderDestXpais.Text.Trim();
objdest.Cep = mtbEnderDestCEP.Text.Trim();
if (mtbEnderDestFone.Text.Trim() != "")
{
objdest.Fone = mtbEnderDestFone.Text.Trim();
}
objdest.email = txtEmaildest.Text.Trim(); // NFe_2.0
//Fim - Endereço
lObj.Add(objdest);
#endregion
#region Endereço de Entrega
belEndEnt objendent = new belEndEnt();
if (mtbEndEntCNPJ.Text != "")
{
objendent.Cnpj = mtbEndEntCNPJ.Text.Trim();
objendent.Xlgr = txtEndEntXlgr.Text.Trim();
objendent.Nro = txtEndEntNro.Text.Trim();
objendent.Cmun = txtEndEntCmun.Text.Trim();
objendent.Xmun = txtEndEntXmun.Text.Trim();
objendent.Uf = txtEndEntUF.Text.Trim();
objendent.Xbairro = txtEndEntXbairro.Text.Trim(); //0S_25185
objendent.Xcpl = txtEndEntCpl.Text.Trim();//0S_25185
}
lObj.Add(objendent);
#endregion
#region Detatalhes
List<belDet> lObjDet = new List<belDet>();
for (int i = 0; i < dgvDet.RowCount; i++)
{
belDet objDet = new belDet();
objDet.Nitem = i + 1;
#region Prod
belProd objprod = new belProd();
objprod.Cean = Convert.ToString(dgvDet["Cean", i].Value);
objprod.Ceantrib = Convert.ToString(dgvDet["Ceantrib", i].Value);
objprod.Cfop = Convert.ToString(dgvDet["Cfop", i].Value);
objprod.Cprod = Convert.ToString(dgvDet["Cprod", i].Value);
if (dgvDet["Extipi", i].Value != null)
{
objprod.Extipi = Convert.ToString(dgvDet["Extipi", i].Value);
}
if (dgvDet["Genero", i].Value != null)
{
objprod.Genero = Convert.ToString(dgvDet["Genero", i].Value);
}
if (Convert.ToString(dgvDet["NCM", i].Value) != "")
{
objprod.Ncm = Convert.ToString(dgvDet["NCM", i].Value);
}
objprod.Qcom = Convert.ToDecimal(dgvDet["Qcom", i].Value);
objprod.Qtrib = Convert.ToDecimal(dgvDet["Qtrib", i].Value);
objprod.Ucom = Convert.ToString(dgvDet["Ucom", i].Value);
objprod.Utrib = Convert.ToString(dgvDet["Utrib", i].Value);
objprod.Vdesc = Convert.ToDecimal(dgvDet["Vdesc", i].Value);
objprod.Vfrete = Convert.ToDecimal(dgvDet["Vfrete", i].Value);
objprod.Vprod = Convert.ToDecimal(dgvDet["Vprod", i].Value);
objprod.Vseg = Convert.ToDecimal(dgvDet["Vseg", i].Value);
objprod.Vuncom = Convert.ToDecimal(dgvDet["Vuncom", i].Value);
objprod.Vuntrib = Convert.ToDecimal(dgvDet["Vuntrib", i].Value);
objprod.Xprod = Convert.ToString(dgvDet["Xprod", i].Value);
objprod.VOutro = Convert.ToDecimal(dgvDet["vOutro", i].Value);// NFe_2.0
objprod.IndTot = Convert.ToInt16(dgvDet["indTot", i].Value); // NFe_2.0
objprod.XPed = dgvDet["xPed", i].Value.ToString();
objprod.NItemPed = dgvDet["nItemPed", i].Value.ToString();
objDet.belProd = objprod;
objDet.belProd.belDI = ((List<belDet>)lObjTotNotas[notAtual - 1][4])[i].belProd.belDI;
#endregion
#region Imposto
belImposto objimposto = new belImposto();
#region ICMS
belIcms objicms = new belIcms();
if (!HLP.Util.Util.VerificaNovaST(Convert.ToString(dgvDet["CstIcms", i].Value)))
{
#region cst_antigas
switch (Convert.ToString(dgvDet["CstIcms", i].Value))
{
case "00":
{
belIcms00 obj00 = new belIcms00();
obj00.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj00.Modbc = Convert.ToString(dgvDet["ModbcIcms", i].Value);
obj00.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj00.Picms = Convert.ToDecimal(dgvDet["PicmsIcms", i].Value);
obj00.Vbc = Convert.ToDecimal(dgvDet["VbcIcms", i].Value);
obj00.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
objicms.belIcms00 = obj00;
break;
}
case "10":
{
belIcms10 obj10 = new belIcms10();
obj10.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj10.Modbc = Convert.ToString(dgvDet["ModbcIcms", i].Value);
obj10.Modbcst = Convert.ToDecimal(dgvDet["ModbcstIcms", i].Value);
obj10.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj10.Picms = Convert.ToDecimal(dgvDet["PicmsIcms", i].Value);
obj10.Picmsst = Convert.ToDecimal(dgvDet["PicmsstIcms", i].Value);
obj10.Pmvast = Convert.ToDecimal(dgvDet["PmvastIcms", i].Value);
obj10.Predbcst = Convert.ToDecimal(dgvDet["PredbcstIcms", i].Value);
obj10.Vbc = Convert.ToDecimal(dgvDet["VbcIcms", i].Value);
obj10.Vbcst = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
obj10.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
obj10.Vicmsst = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
objicms.belIcms10 = obj10;
break;
}
case "20":
{
belIcms20 obj20 = new belIcms20();
obj20.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj20.Modbc = Convert.ToString(dgvDet["ModbcIcms", i].Value);
obj20.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj20.Picms = Convert.ToDecimal(dgvDet["PicmsIcms", i].Value);
obj20.Predbc = Convert.ToDecimal(dgvDet["PredbcIcms", i].Value);
obj20.Vbc = Convert.ToDecimal(dgvDet["VbcIcms", i].Value);
obj20.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
objicms.belIcms20 = obj20;
break;
}
case "30":
{
belIcms30 obj30 = new belIcms30();
obj30.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj30.Modbcst = Convert.ToDecimal(dgvDet["ModbcstIcms", i].Value);
obj30.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj30.Picmsst = Convert.ToDecimal(dgvDet["PicmsstIcms", i].Value);
obj30.Pmvast = Convert.ToDecimal(dgvDet["PmvastIcms", i].Value);
obj30.Predbcst = Convert.ToDecimal(dgvDet["PredbcstIcms", i].Value);
obj30.Vbcst = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
obj30.Vicmsst = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
objicms.belIcms30 = obj30;
break;
}
case "40":
{
belIcms40 obj40 = new belIcms40();
obj40.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj40.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj40.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value); //NFe_2.0
obj40.motDesICMS = Convert.ToInt16(dgvDet["motDesICMS", i].Value);//NFe_2.0
objicms.belIcms40 = obj40;
break;
}
case "41":
{
belIcms40 obj40 = new belIcms40();
obj40.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj40.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj40.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value); //NFe_2.0
obj40.motDesICMS = Convert.ToInt16(dgvDet["motDesICMS", i].Value);//NFe_2.0
objicms.belIcms40 = obj40;
break;
}
case "50":
{
belIcms40 obj40 = new belIcms40();
obj40.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj40.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj40.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value); //NFe_2.0
obj40.motDesICMS = Convert.ToInt16(dgvDet["motDesICMS", i].Value);//NFe_2.0
objicms.belIcms40 = obj40;
break;
}
case "51":
{
belIcms51 obj51 = new belIcms51();
obj51.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj51.Modbc = Convert.ToString(dgvDet["ModbcIcms", i].Value);
obj51.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj51.Picms = Convert.ToDecimal(dgvDet["PicmsIcms", i].Value);
obj51.Predbc = Convert.ToDecimal(dgvDet["PredbcIcms", i].Value);
obj51.Vbc = Convert.ToDecimal(dgvDet["VbcIcms", i].Value);
obj51.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
objicms.belIcms51 = obj51;
break;
}
//Fim - Danner - o.s. 24189 - 26/02/2010
case "60":
{
belIcms60 obj60 = new belIcms60();
obj60.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj60.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj60.Vbcst = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
obj60.Vicmsst = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
objicms.belIcms60 = obj60;
break;
}
case "70":
{
belIcms70 obj70 = new belIcms70();
obj70.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj70.Modbc = Convert.ToString(dgvDet["ModbcIcms", i].Value);
obj70.Modbcst = Convert.ToDecimal(dgvDet["ModbcstIcms", i].Value);
obj70.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj70.Picms = Convert.ToDecimal(dgvDet["PicmsIcms", i].Value);
obj70.Picmsst = Convert.ToDecimal(dgvDet["PicmsstIcms", i].Value);
obj70.Pmvast = Convert.ToDecimal(dgvDet["PmvastIcms", i].Value);
obj70.Predbc = Convert.ToDecimal(dgvDet["PredbcIcms", i].Value);
obj70.Predbcst = Convert.ToDecimal(dgvDet["PredbcstIcms", i].Value);
obj70.Vbc = Convert.ToDecimal(dgvDet["VbcIcms", i].Value);
obj70.Vbcst = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
obj70.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
obj70.Vicmsst = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
objicms.belIcms70 = obj70;
break;
}
case "90":
{
belIcms90 obj90 = new belIcms90();
obj90.Cst = Convert.ToString(dgvDet["CstIcms", i].Value);
obj90.Modbc = Convert.ToString(dgvDet["ModbcIcms", i].Value);
obj90.Modbcst = Convert.ToDecimal(dgvDet["ModbcstIcms", i].Value);
obj90.Orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj90.Picms = Convert.ToDecimal(dgvDet["PicmsIcms", i].Value);
obj90.Picmsst = Convert.ToDecimal(dgvDet["PicmsstIcms", i].Value);
obj90.Pmvast = Convert.ToDecimal(dgvDet["PmvastIcms", i].Value);
obj90.Predbc = Convert.ToDecimal(dgvDet["PredbcIcms", i].Value);
obj90.Predbcst = Convert.ToDecimal(dgvDet["PredbcstIcms", i].Value);
obj90.Vbc = Convert.ToDecimal(dgvDet["VbcIcms", i].Value);
obj90.Vbcst = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
obj90.Vicms = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
obj90.Vicmsst = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
objicms.belIcms90 = obj90;
break;
}
}
#endregion
}
else
{
#region cst_novas
switch (HLP.Util.Util.RetornaSTnovaAserUsada(Convert.ToString(dgvDet["CstIcms", i].Value)))
{
case "101":
{
belICMSSN101 obj101 = new belICMSSN101();
obj101.CSOSN = Convert.ToString(dgvDet["CstIcms", i].Value);
obj101.orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj101.pCredSN = Convert.ToDecimal(dgvDet["pCredSN", i].Value);
obj101.vCredICMSSN = Convert.ToDecimal(dgvDet["vCredICMSSN", i].Value);
objicms.belICMSSN101 = obj101;
break;
}
case "102":
{
belICMSSN102 obj102 = new belICMSSN102();
obj102.CSOSN = Convert.ToString(dgvDet["CstIcms", i].Value);
obj102.orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
objicms.belICMSSN102 = obj102;
break;
}
case "201":
{
belICMSSN201 obj201 = new belICMSSN201();
obj201.CSOSN = Convert.ToString(dgvDet["CstIcms", i].Value);
obj201.orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj201.modBCST = Convert.ToInt32(dgvDet["ModbcstIcms", i].Value);
obj201.pMVAST = Convert.ToDecimal(dgvDet["PmvastIcms", i].Value);
obj201.pRedBCST = Convert.ToDecimal(dgvDet["PredbcstIcms", i].Value);
obj201.vBCST = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
obj201.pICMSST = Convert.ToDecimal(dgvDet["PicmsstIcms", i].Value);
obj201.vICMSST = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
if (Convert.ToString(dgvDet["CstIcms", i].Value).Equals("101"))
{
obj201.pCredSN = Convert.ToDecimal(dgvDet["pCredSN", i].Value);
obj201.vCredICMSSN = Convert.ToDecimal(dgvDet["vCredICMSSN", i].Value);
}
objicms.belICMSSN201 = obj201;
break;
}
case "500":
{
belICMSSN500 obj500 = new belICMSSN500();
obj500.CSOSN = Convert.ToString(dgvDet["CstIcms", i].Value);
obj500.orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
obj500.vBCSTRet = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
obj500.vICMSSTRet = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
objicms.belICMSSN500 = obj500;
break;
}
case "900":
{
belICMSSN900 obj900 = new belICMSSN900();
obj900.CSOSN = Convert.ToString(dgvDet["CstIcms", i].Value);
obj900.orig = Convert.ToString(dgvDet["OrigIcms", i].Value);
//obj900.modBC = Convert.ToInt32(dgvDet["ModbcIcms", i].Value);
//obj900.vBC = Convert.ToDecimal(dgvDet["VbcIcms", i].Value);
//obj900.pRedBC = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
//obj900.pICMS = Convert.ToDecimal(dgvDet["PicmsIcms", i].Value);
//obj900.vICMS = Convert.ToDecimal(dgvDet["VicmsIcms", i].Value);
//obj900.modBCST = Convert.ToInt32(dgvDet["ModbcstIcms", i].Value);
//obj900.pMVAST = Convert.ToDecimal(dgvDet["PmvastIcms", i].Value);
//obj900.pRedBCST = Convert.ToDecimal(dgvDet["PredbcstIcms", i].Value);
//obj900.vBCST = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
//obj900.pICMSST = Convert.ToDecimal(dgvDet["PicmsstIcms", i].Value);
//obj900.vICMSST = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
//obj900.vBCSTRet = Convert.ToDecimal(dgvDet["VbcstIcms", i].Value);
//obj900.vICMSSTRet = Convert.ToDecimal(dgvDet["VicmsstIcms", i].Value);
//obj900.pCredSN = Convert.ToDecimal(dgvDet["pCredSN", i].Value);
//obj900.vCredICMSSN = Convert.ToDecimal(dgvDet["vCredICMSSN", i].Value);
objicms.belICMSSN900 = obj900;
break;
}
}
#endregion
}
objimposto.belIcms = objicms;
#endregion
#region IPI
belIpi objipi = new belIpi();
objipi.Cenq = Convert.ToString(dgvDet["CenqIpi", i].Value);
string sCSTIPI = Convert.ToString(dgvDet["CstIpi", i].Value);
if (sCSTIPI == "00" || sCSTIPI == "49" || sCSTIPI == "50" || sCSTIPI == "99")
{
belIpitrib objipitrib = new belIpitrib();
objipitrib.Cst = sCSTIPI;
objipitrib.Pipi = Convert.ToDecimal(dgvDet["PipiTrib", i].Value);
if (Convert.ToDecimal(dgvDet["QunidIpiTrib", i].Value) != 0)
{
objipitrib.Qunid = Convert.ToString(dgvDet["QunidIpiTrib", i].Value);
}
objipitrib.Vbc = Convert.ToDecimal(dgvDet["VbcIpiTrib", i].Value);
objipitrib.Vipi = Convert.ToDecimal(dgvDet["VipiTrib", i].Value); //Claudinei - o.s. 24192 - 01/03/2010
objipitrib.Vunid = Convert.ToDecimal(dgvDet["VunidTrib", i].Value);
objipi.belIpitrib = objipitrib;
}
else
{
belIpint objipint = new belIpint();
objipint.Cst = sCSTIPI;
objipi.belIpint = objipint;
}
objimposto.belIpi = objipi;
#endregion
#region II
//if (Convert.ToDecimal(dgvDet["VbcIi", i].Value) != 0)
if (objdest.Uf.Equals("EX"))
{
belIi objii = new belIi();
objii.Vbc = Convert.ToDecimal(dgvDet["VbcIi", i].Value);
objii.Vdespadu = Convert.ToDecimal(dgvDet["VdespaduIi", i].Value);
objii.Vii = Convert.ToDecimal(dgvDet["Vii", i].Value);
objii.Viof = Convert.ToDecimal(dgvDet["ViofIi", i].Value);
objimposto.belIi = objii;
}
#endregion
#region PIS
belPis objpis = new belPis();
string sCstPis = Convert.ToString(dgvDet["CstPis", i].Value);
if (sCstPis == "01" || sCstPis == "02") // aqui
{
belPisaliq objpisaliq = new belPisaliq();
objpisaliq.Cst = sCstPis;
objpisaliq.Ppis = Convert.ToDecimal(dgvDet["Ppis", i].Value);
objpisaliq.Vbc = Convert.ToDecimal(dgvDet["VbcPis", i].Value);
objpisaliq.Vpis = Convert.ToDecimal(dgvDet["Vpis", i].Value);
objpis.belPisaliq = objpisaliq;
}
else if (sCstPis == "03")
{
belPisqtde objpisqtde = new belPisqtde();
objpisqtde.Cst = sCstPis;
objpisqtde.Valiqprod = Convert.ToDecimal(dgvDet["ValiqprodPis", i].Value);
objpisqtde.Qbcprod = Convert.ToDecimal(dgvDet["QbcprodPis", i].Value);
objpisqtde.Vpis = Convert.ToDecimal(dgvDet["Vpis", i].Value);
objpis.belPisqtde = objpisqtde;
}
else if (sCstPis == "04" || sCstPis == "06" || sCstPis == "07" || sCstPis == "08" || sCstPis == "09")
{
belPisnt objpisnt = new belPisnt();
objpisnt.Cst = sCstPis;
objpis.belPisnt = objpisnt;
}
else //if (sCstPis == "99")
{
belPisoutr objpisoutr = new belPisoutr();
objpisoutr.Cst = sCstPis;
objpisoutr.Ppis = Convert.ToDecimal(dgvDet["Ppis", i].Value);
objpisoutr.Vbc = Convert.ToDecimal(dgvDet["VbcPis", i].Value);
if (Convert.ToDecimal(dgvDet["ValiqprodPis", i].Value) != 0)
{
objpisoutr.Valiqprod = Convert.ToDecimal(dgvDet["ValiqprodPis", i].Value);
//Danner - o.s. 24167 - 22/01/2010
objpisoutr.Qbcprod = Convert.ToDecimal(dgvDet["QbcprodPis", i].Value);
//Fim - Danner - o.s. 24167 - 22/01/2010
}
//objpisoutr.Vbcprod = Convert.ToString(dgvDet["QbcprodPis", i].Value);//Danner - o.s. 24167 - 22/01/2010
objpisoutr.Vpis = Convert.ToDecimal(dgvDet["Vpis", i].Value);
objpis.belPisoutr = objpisoutr;
}
objimposto.belPis = objpis;
#endregion
#region COFINS
belCofins objcofins = new belCofins();
string sCstCofins = Convert.ToString(dgvDet["CstCofins", i].Value);
if (sCstCofins == "01" || sCstCofins == "02")
{
belCofinsaliq objconfinsaliq = new belCofinsaliq();
objconfinsaliq.Cst = sCstCofins;
objconfinsaliq.Pcofins = Convert.ToDecimal(dgvDet["Pcofins", i].Value);
objconfinsaliq.Vbc = Convert.ToDecimal(dgvDet["VbcCofins", i].Value);
objconfinsaliq.Vcofins = Convert.ToDecimal(dgvDet["Vconfins", i].Value);
objcofins.belCofinsaliq = objconfinsaliq;
}
else if (sCstCofins == "03")
{
belCofinsqtde objcofinsqtde = new belCofinsqtde();
objcofinsqtde.Cst = sCstCofins;
objcofinsqtde.Qbcprod = Convert.ToDecimal(dgvDet["QbcprodCofins", i].Value);
objcofinsqtde.Valiqprod = Convert.ToDecimal(dgvDet["ValiqprodCofins", i].Value);
objcofinsqtde.Vcofins = Convert.ToDecimal(dgvDet["Vconfins", i].Value);
objcofins.belCofinsqtde = objcofinsqtde;
}
else if (sCstCofins == "04" || sCstCofins == "06" || sCstCofins == "07" || sCstCofins == "08" || sCstCofins == "09")
{
belCofinsnt objcofinsnt = new belCofinsnt();
objcofinsnt.Cst = sCstCofins;
objcofins.belCofinsnt = objcofinsnt;
}
else //if (sCstCofins == "99")
{
belCofinsoutr objcofinsoutr = new belCofinsoutr();
objcofinsoutr.Cst = sCstCofins;
objcofinsoutr.Pcofins = Convert.ToDecimal(dgvDet["Pcofins", i].Value);
objcofinsoutr.Vbc = Convert.ToDecimal(dgvDet["VbcCofins", i].Value);
objcofinsoutr.Qbcprod = Convert.ToDecimal(dgvDet["QbcprodCofins", i].Value);
objcofinsoutr.Valiqprod = Convert.ToDecimal(dgvDet["ValiqprodCofins", i].Value);
objcofinsoutr.Vcofins = Convert.ToDecimal(dgvDet["Vconfins", i].Value);
objcofins.belCofinsoutr = objcofinsoutr;
}
objimposto.belCofins = objcofins;
#endregion
#region ISSQN
if (Convert.ToDecimal(dgvDet["VbcIss", i].Value) != 0)
{
belIss objiss = new belIss();
objiss.Clistserv = Convert.ToInt64(dgvDet["ClistservIss", i].Value);
objiss.Cmunfg = Convert.ToString(dgvDet["CmunfgIss", i].Value);
objiss.Valiq = Convert.ToDecimal(dgvDet["ValiqIss", i].Value);
objiss.Vbc = Convert.ToDecimal(dgvDet["VbcIss", i].Value);
objiss.Vissqn = Convert.ToDecimal(dgvDet["VissqnIss", i].Value);
objimposto.belIss = objiss;
}
#endregion
objDet.belImposto = objimposto;
#region InfadProd
belInfadprod objinfadprod = new belInfadprod();
if (Convert.ToString(dgvDet["Infcpl", i].Value) != "")
{
objinfadprod.Infadprid = Convert.ToString(dgvDet["Infcpl", i].Value);
objDet.belInfadprod = objinfadprod;
}
#endregion
#endregion
lObjDet.Add(objDet);
}
lObj.Add(lObjDet);
#endregion
#region Totais
belTotal objtotal = new belTotal();
//Totais
belIcmstot objIcmsTot = new belIcmstot();
objIcmsTot.Vbc = nudVBC.Value;
objIcmsTot.Vicms = nudVICMS.Value;
objIcmsTot.Vbcst = nudVBCICMSST.Value;
objIcmsTot.Vst = nudVST.Value;
objIcmsTot.Vprod = nudVProd.Value;
//Danner - o.s. 24154 - 18/02/2010
objIcmsTot.Vfrete = nudVFrete.Value;
//Fim - Danner - o.s. 24154 - 18/02/2010
objIcmsTot.Vseg = nudVSEG.Value;
objIcmsTot.Vdesc = nudVDesc.Value;
objIcmsTot.Vii = nudVII.Value;
objIcmsTot.Vipi = nudVIPI.Value;
objIcmsTot.Vpis = nudVPIS.Value;
objIcmsTot.Vcofins = nudVCOFINS.Value;
objIcmsTot.Voutro = nudVOutro.Value;
objIcmsTot.Vnf = nudVNF.Value;
objtotal.belIcmstot = objIcmsTot;
//Fim - Totais
//ISSQNtot
if (flpISSNQ.Enabled != false)
{
belIssqntot objissqnTot = new belIssqntot();
objissqnTot.Vserv = nudVServ.Value;
objissqnTot.Vbc = nudVBCISS.Value;
objissqnTot.Viss = nudVISS.Value;
objissqnTot.Vpis = nudVPISISS.Value;
objissqnTot.Vcofins = nudVCOFINSISS.Value;
objtotal.belIssqntot = objissqnTot;
}
//Fin - ISSQNtot;
//retTrib
if (flpRetTrib.Enabled != false)
{
belRetTrib objRetTrib = new belRetTrib();
objRetTrib.Vretpis = nudVPISRet.Value;
objRetTrib.Vretcofins = nudVCOFINSRet.Value;
objRetTrib.Vretcsll = nudVCSLLRet.Value;
objRetTrib.Vbcretprev = nudVBCIRRFRet.Value;
objRetTrib.Virrf = nudVIRRFRet.Value;
objRetTrib.Vbcirrf = nudVBCIRRFRet.Value;
objRetTrib.Vbcretprev = nudVBCRetPrev.Value;
objRetTrib.Vretprev = nudVRetPrev.Value;
objtotal.belRetTrib = objRetTrib;
}
lObj.Add(objtotal);
//Fim - retTrib
#endregion
#region Transporte
belTransp objtransp = new belTransp();
switch (cbxModFrete.SelectedIndex) //Nfe_2.0
{
case 0: objtransp.Modfrete = "0";
break;
case 1: objtransp.Modfrete = "1";
break;
case 2: objtransp.Modfrete = "2";
break;
case 3: objtransp.Modfrete = "9";
break;
}
//objtransp.Modfrete = Convert.ToString(cbxModFrete.SelectedIndex);
//Transportadora
belTransportadora objtransportadora = new belTransportadora();
if (cbxPessoaTranp.SelectedIndex == 1)
{
if (mtbCPJCNPJTransp.Text.Trim() != "")
{
objtransportadora.Cnpj = mtbCPJCNPJTransp.Text.Trim();
}
}
else
{
if (mtbCPJCNPJTransp.Text.Trim() != "")
{
objtransportadora.Cpf = mtbCPJCNPJTransp.Text.Trim();
}
}
if (txtXnomeTransp.Text.Trim() != "")
{
objtransportadora.Xnome = txtXnomeTransp.Text.Trim();
}
if (txtIETransp.Text.Trim() != "")
{
objtransportadora.Ie = txtIETransp.Text.Trim();
}
if (txtEnderTransp.Text.Trim() != "")
{
objtransportadora.Xender = txtEnderTransp.Text.Trim();
}
if (txtUFTransp.Text.Trim() != "")
{
objtransportadora.Uf = txtUFTransp.Text.Trim();
}
if (txtXmunTransp.Text.Trim() != "")
{
objtransportadora.Xmun = txtXmunTransp.Text.Trim();
}
objtransp.belTransportadora = objtransportadora;
//Fim - Transportadora
//VeicTransp
if (flpVeicTransp.Enabled != false)
{
belVeicTransp objVeicTrasnp = new belVeicTransp();
objVeicTrasnp.Placa = mtbPlacaVeicTransp.Text.Trim();
objVeicTrasnp.Uf = txtUFVeicTransp.Text.Trim();
//Danner - o.s. sem - 05/03/2010
if (txtRNTCVeicTransp.Text.Trim() != "")
{
objVeicTrasnp.Rntc = txtRNTCVeicTransp.Text.Trim();
}
//Fim - Danner - o.s. sem - 05/03/2010
objtransp.belVeicTransp = objVeicTrasnp;
}
//Fim - VeicTransp
//Reboque
if (flpReboque.Enabled != false)
{
belReboque objReboque = new belReboque();
objReboque.Placa = mtbPlacaReboque.Text.Trim();
objReboque.Uf = txtUFReboque.Text.Trim();
objReboque.Rntc = txtRNTCReboque.Text.Trim();
objtransp.belReboque = objReboque;
}
//Fim - Reboque
//RetTransp
if (flpRetICMS.Enabled != false)
{
belRetTransp objRetTransp = new belRetTransp();
objRetTransp.Vbvret = nudVBCICMSTransp.Value;
objRetTransp.Vserv = nudVServTransp.Value;
objRetTransp.Picmsret = nudPICMSTRetTransp.Value;
objRetTransp.Vicmsret = nudVICMSRet.Value;
objRetTransp.Cmunfg = txtCmunFGTransp.Text.Trim();
objRetTransp.Cfop = txtCFOPTransp.Text.Trim();
objtransp.belRetTransp = objRetTransp;
}
//Fim - RetTransp
if (flpVolumes.Enabled != false)
{
belVol objVol = new belVol();
objVol.Esp = txtEsp.Text.Trim();
objVol.Marca = txtMarca.Text.Trim();
//Danner - o.s. 24385 - 26/04/2010
if (txtNVol.Text != "")
{
objVol.Nvol = txtNVol.Text;//Danner - o.s. 24432 - 04/05/2010
}
//Fim - Danner - o.s. 24385 - 26/04/2010
objVol.PesoB = nudPesoB.Value;
objVol.PesoL = nudPesoL.Value;
objVol.Qvol = nudQvol.Value;
objtransp.belVol = objVol;
}
lObj.Add(objtransp);
#endregion
#region Cobrança
belCobr objcobr = new belCobr();
belFat objFat = new belFat();
objFat.Nfat = txtNFat.Text.Trim();
objFat.Vorig = nudVOrigFat.Value;
objFat.Vdesc = nudVDescFat.Value;
objFat.Vliq = nudVLiqFat.Value;
if (dgvDup.RowCount != 0)
{
List<belDup> lObjDup = new List<belDup>();
for (int i = 0; i < dgvDup.RowCount; i++)
{
belDup objdup = new belDup();
objdup.Ndup = Convert.ToString(dgvDup[0, i].Value);
objdup.Dvenc = Convert.ToDateTime(dgvDup[1, i].Value);
objdup.Vdup = Convert.ToDecimal(dgvDup[2, i].Value);
lObjDup.Add(objdup);
}
objFat.belDup = lObjDup;
}
objcobr.belFat = objFat;
lObj.Add(objcobr);
#endregion
#region Inf Adicionais
belInfAdic objinfadic = new belInfAdic();
if (txtInfAdic.Text != "")
{
objinfadic.Infcpl = txtInfAdic.Text.Trim().Replace(Environment.NewLine, "");
}
lObj.Add(objinfadic);
#endregion
#region exporta
belExporta objexporta = new belExporta();
if (cbxUF_embarque.SelectedIndex > 0)
{
objexporta.Ufembarq = cbxUF_embarque.Text.ToString();
}
if (txtLocalEntrega.Text != "")
{
objexporta.Xlocembarq = txtLocalEntrega.Text;
}
lObj.Add(objexporta);
#endregion
lObjTotNotasFinal[notAtual - 1] = lObj;
lObjTotNotas[notAtual - 1] = lObjTotNotasFinal[notAtual - 1];
}
catch (Exception ex)
{
KryptonMessageBox.Show(ex.Message); ;
}
}
