public TcDadosServico RetornaDadosServico(string sNFSEQ, int iNaturezaOperacao) { try { TcDadosServico objTcDadosServico = new TcDadosServico(); objTcDadosServico.Valores = BuscaValores(sNFSEQ, iNaturezaOperacao); DataTable dt = BuscaDadosServico(sNFSEQ); objTcDadosServico.Discriminacao = "Serviço(s) Realizado(s): "; foreach (DataRow dr in dt.Rows) { if (objTcDadosServico.ItemListaServico.Equals("")) { string CodLista = ""; if (dr["cd_lista_servico_Prod"].ToString() != "") { CodLista = dr["cd_lista_servico_Prod"].ToString(); } else if (dr["cd_lista_servico_Emp"].ToString() != "") { CodLista = dr["cd_lista_servico_Emp"].ToString(); } else { throw new Exception("É Necessário Configurar o Código da lista de Serviço no Cadastro de Produto!"); } objTcDadosServico.ItemListaServico = CodLista; } if (objTcDadosServico.CodigoTributacaoMunicipio.Equals("")) { objTcDadosServico.CodigoTributacaoMunicipio = dr["cd_trib_municipio"].ToString(); } objTcDadosServico.Discriminacao += Environment.NewLine + "* " + dr["ds_prod"].ToString().ToUpper() + " R$ " + Convert.ToDecimal(dr["vl_totbruto"].ToString()).ToString("#0.00") + ((Acesso.NM_EMPRESA.Equals("FORMINGP") && dr["ds_obs"].ToString() != "") ? " - Obs.: " + dr["ds_obs"].ToString() : ""); if (Acesso.TRANSPARENCIA != 3) { objTcDadosServico.Discriminacao += Environment.NewLine + daoUtil.CarregaObsTransparenciaNF(sNFSEQ); } } if (Acesso.NM_EMPRESA.Equals("FORMINGP")) { belCobr objCobrancas = new belCobr(); objCobrancas.Carrega(sNFSEQ); string sDescDup = "{0}{0}VENCIMENTO: {1}{0}VALOR LÍQUIDO A PAGAR: R${2}{0}{0}"; if (objCobrancas.Fat != null) { foreach (belDup dup in objCobrancas.Fat.belDup) { objTcDadosServico.Discriminacao += string.Format(sDescDup, Environment.NewLine, dup.Dvenc.ToShortDateString(), dup.Vdup); } } } objTcDadosServico.Discriminacao += Environment.NewLine + Environment.NewLine + "Observação:" + Environment.NewLine + daoUtil.GetTotImpostosServ(sNFSEQ) + BuscaObs(sNFSEQ); if (objTcDadosServico.Discriminacao[objTcDadosServico.Discriminacao.Length - 1].ToString().Equals("}")) { objTcDadosServico.Discriminacao = objTcDadosServico.Discriminacao.Remove(objTcDadosServico.Discriminacao.Length - 1); } StringBuilder sQuery = new StringBuilder(); sQuery.Append(" select "); sQuery.Append(" cidades.cd_municipio "); sQuery.Append(" from empresa "); sQuery.Append(" left join cidades on (cidades.nm_cidnor = empresa.nm_cidnor) "); sQuery.Append(" where empresa.cd_empresa = '" + Acesso.CD_EMPRESA + "'"); FbConnection con = HlpDbFuncoesGeral.conexao; FbCommand Command = new FbCommand(sQuery.ToString(), con); con.Open(); objTcDadosServico.CodigoMunicipio = Command.ExecuteScalar().ToString(); objTcDadosServico.CodigoCnae = ""; con.Close(); return(objTcDadosServico); } catch (Exception ex) { throw ex; } }
public belCobr BuscaFat(string sEmp, string sNF) { belCobr objcobr = new belCobr(); List<belFat> objfats = new List<belFat>(); try { StringBuilder sSql = new StringBuilder(); //Campos do Select sSql.Append("Select "); sSql.Append("doc_ctr.cd_dupli, "); sSql.Append("DOC_CTR.dt_venci, "); sSql.Append("DOC_CTR.vl_doc ,"); sSql.Append("doc_ctr.vl_totdesc, "); sSql.Append("doc_ctr.cd_documento "); //Tabela sSql.Append("From doc_ctr "); //Relacionamentos sSql.Append("INNER JOIN NF ON (NF.cd_empresa = DOC_CTR.cd_empresa) AND "); sSql.Append("(NF.cd_nfseq = DOC_CTR.cd_nfseq) "); //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("') "); //belGerarXML cx = new belGerarXML(); //FbConnection Conn = cx.Conn; //Conn.Open(); FbCommand cmdFat = new FbCommand(sSql.ToString(), cx.get_Conexao()); cmdFat.ExecuteNonQuery(); FbDataReader drFat = cmdFat.ExecuteReader(); sSql.Remove(0, sSql.Length); sSql.Append("Select "); sSql.Append("nf.cd_notafis nFat, "); sSql.Append("coalesce((nf.vl_totnf + nf.vl_desccomer ), 0) vOrig, "); sSql.Append("nf.vl_desccomer vDesc, "); sSql.Append("nf.vl_totnf vLiq "); sSql.Append("from nf "); 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("') "); FbCommand cmdCob = new FbCommand(sSql.ToString(), cx.get_Conexao()); cmdCob.ExecuteNonQuery(); FbDataReader drCob = cmdCob.ExecuteReader(); belFat objfat = new belFat(); while (drCob.Read()) { decimal dvDup = Math.Round(Convert.ToDecimal(drCob["vOrig"].ToString()), 2); decimal dDesc = Math.Round(Convert.ToDecimal(drCob["vDesc"].ToString()), 2); if (drCob["nFat"].ToString().Trim() != "") { objfat.Nfat = belUtil.TiraSimbolo(drCob["nFat"].ToString(), ""); } objfat.Vorig = dvDup; if (drCob["vDesc"].ToString() != "0") { objfat.Vdesc = Math.Round(Convert.ToDecimal(dDesc.ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010 } if (drCob["vLiq"].ToString() != "0") { decimal dLiq = Math.Round(Convert.ToDecimal(drCob["vLiq"].ToString()), 2); objfat.Vliq = dLiq; } } List<belDup> objdups = new List<belDup>(); while (drFat.Read()) { belDup objdup = new belDup(); if (drFat["cd_dupli"].ToString() != "") { objdup.Ndup = belUtil.TiraSimbolo(drFat["cd_dupli"].ToString(), ""); } if (!drFat["dt_venci"].Equals(string.Empty)) { objdup.Dvenc = System.DateTime.Parse(drFat["dt_venci"].ToString()); } decimal dvDup = Math.Round(Convert.ToDecimal(drFat["vl_doc"].ToString()), 2); //Claudinei - o.s. 24248 - 26/03/2010 if (dvDup != 0) { objdup.Vdup = dvDup; } objdups.Add(objdup); } objfat.belDup = objdups; objcobr.belFat = objfat; } catch (Exception Ex) { sExecao = " - Problemas nas Faturas da Nota"; throw new Exception(Ex.Message + sExecao); } return objcobr; }