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 xmlBuscaCobr()
{
belCobr objCobr = new belCobr();
XmlDocument xCobr = new XmlDocument();
belFat objFat = new belFat();
try
{
if (xDoc.GetElementsByTagName("cobr").Count > 0)
{
xCobr.LoadXml(xDoc.GetElementsByTagName("cobr")[0].OuterXml);
if (xCobr.GetElementsByTagName("fat").Count > 0)
{
XmlDocument xFat = new XmlDocument();
xFat.LoadXml(xCobr.GetElementsByTagName("fat")[0].OuterXml);
if (xFat.GetElementsByTagName("nFat").Count > 0)
{
objFat.Nfat = xFat.GetElementsByTagName("nFat")[0].InnerText;
}
if (xFat.GetElementsByTagName("vOrig").Count > 0)
{
objFat.Vorig = Convert.ToDecimal(xFat.GetElementsByTagName("vOrig")[0].InnerText.ToString().Replace(".", ","));
}
if (xFat.GetElementsByTagName("vDesc").Count > 0)
{
objFat.Vdesc = Convert.ToDecimal(xFat.GetElementsByTagName("vDesc")[0].InnerText.ToString().Replace(".", ","));
}
if (xFat.GetElementsByTagName("vLiq").Count > 0)
{
objFat.Vliq = Convert.ToDecimal(xFat.GetElementsByTagName("vLiq")[0].InnerText.ToString().Replace(".", ","));
}
}
List<belDup> lobjDup = new List<belDup>();
for (int i = 0; i < xCobr.GetElementsByTagName("dup").Count; i++)
{
XmlDocument xDup = new XmlDocument();
xDup.LoadXml(xCobr.GetElementsByTagName("dup")[i].OuterXml);
belDup objDup = new belDup();
if (xDup.GetElementsByTagName("nDup").Count > 0)
{
objDup.Ndup = xDup.GetElementsByTagName("nDup")[0].InnerText;
}
if (xDup.GetElementsByTagName("dVenc").Count > 0)
{
objDup.Dvenc = Convert.ToDateTime(xDup.GetElementsByTagName("dVenc")[0].InnerText);
}
if (xDup.GetElementsByTagName("vDup").Count > 0)
{
objDup.Vdup = Convert.ToDecimal(xDup.GetElementsByTagName("vDup")[0].InnerText.ToString().Replace(".", ","));
}
lobjDup.Add(objDup);
}
objFat.belDup = lobjDup;
objCobr.Fat = objFat;
}
}
catch (Exception ex)
{
throw new Exception(string.Format("Problemas lendo a Tag Transp, Cobr.: {0}",
ex.Message));
}
return objCobr;
}
