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); ; } }