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