public FaxResponse ObterFaxBmf(FaxRequest lRequest)
{
var lRetorno = new FaxResponse();
var lAcessaDados = new AcessaDados();
log4net.Config.XmlConfigurator.Configure();
try
{
lAcessaDados.ConnectionStringName = "CORRWIN";
this.BuscarFax_Cabecalho(ref lRequest, ref lAcessaDados, ref lRetorno);
this.BuscarFax_DataLiquidacao(ref lRequest, ref lAcessaDados, ref lRetorno);
this.BuscarFax_SOMA(ref lRequest, ref lAcessaDados, ref lRetorno);
this.BuscarFax_NET(ref lRequest, ref lAcessaDados, ref lRetorno);
this.BuscarFax_Papel(ref lRequest, ref lAcessaDados, ref lRetorno);
}
catch (Exception ex)
{
gLogger.Error("ObterFaxBmf", ex);
lRetorno.DescricaoResposta = ex.ToString();
lRetorno.StatusResposta = MensagemResponseStatusEnum.ErroNegocio;
}
return(lRetorno);
}
private void BuscarFaxVol_SOMA(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_VOL_SOMA_BMF"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoClienteBmf.Value);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
plRetorno.RelatorioBmf.CabecalhoGridBmf = new List <FaxBmfCabecalhoGridInfo>();
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
for (int i = 0; i < lDataTable.Rows.Count; i++)
{
FaxBmfCabecalhoGridInfo lCabBmf = new FaxBmfCabecalhoGridInfo();
lCabBmf.CabecalhoSentido = lDataTable.Rows[i]["CD_NATOPE"].DBToString();
lCabBmf.CabecalhoCommod = lDataTable.Rows[i]["CD_COMMOD"].DBToString();
lCabBmf.CabecalhoSerie = lDataTable.Rows[i]["CD_SERIE"].DBToString();
lCabBmf.CabecalhoTipoMercado = lDataTable.Rows[i]["CD_MERCAD"].DBToString();
lCabBmf.SomaCodigoNegocio = lDataTable.Rows[i]["CD_NEGOCIO"].DBToString();
lCabBmf.SomaPreco = lDataTable.Rows[i]["PRECO_MEDIO"].DBToDecimal();
lCabBmf.SomaQuantidade = lDataTable.Rows[i]["QUANTIDADE"].DBToInt32();
plRetorno.RelatorioBmf.CabecalhoGridBmf.Add(lCabBmf);
}
}
}
}
}
private void BuscarFaxVol_NET(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_VOL_NET_BMF"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoClienteBmf.Value);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
for (int i = 0; i < lDataTable.Rows.Count; i++)
{
var lCabBmf = plRetorno.RelatorioBmf.CabecalhoGridBmf.FindAll(papel =>
{
return(papel.CabecalhoCommod == lDataTable.Rows[i]["CD_COMMOD"].DBToString() &&
papel.CabecalhoSerie == lDataTable.Rows[i]["CD_SERIE"].DBToString());
});
for (int j = 0; j < lCabBmf.Count; j++)
{
lCabBmf[j].NetCodigoNegocio = lCabBmf[j].SomaCodigoNegocio;
lCabBmf[j].NetPreco = lDataTable.Rows[i]["VL_NET"].DBToDecimal();
lCabBmf[j].NetQuantidade = lDataTable.Rows[i]["QT_NET"].DBToInt32();
}
}
}
}
}
}
private void AddDocumentToRequest(AssociatedDoc assDoc, FaxRequest request)
{
var originalSelection = ImagesEventManager.Instance.CurrentSelected;
var associatedDocsDto = originalSelection;
bool wasChanged = false;
try
{
if (originalSelection.DocsId != assDoc.Id || originalSelection.Type != ImagesDtoType.Associated)
{
associatedDocsDto = imagesDal.GetByDocId(assDoc.Id, ImagesDtoType.Associated);
ImagesEventManager.Instance.Raise(new ImagesSelectedEventArgs(associatedDocsDto, false));
wasChanged = true;
}
var currentEditor = TifEditor.GetCurrentEditor();
var publishToBytes = currentEditor.PublishToBytes();
associatedDocsDto.MarkupImage = publishToBytes;
imagesDal.Update(associatedDocsDto);
vaulter.VaultAssociatedDoc(assDoc.Id, null);
request.AddDocument(assDoc.FileName, currentEditor.TotalPages, publishToBytes);
}
finally
{
if (wasChanged)
{
ImagesEventManager.Instance.Raise(new ImagesSelectedEventArgs(originalSelection, false));
}
}
}
private void BuscarFax_TOTAL(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_TOTAL_BOV_BR"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoCliente);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
for (int i = 0; i < lDataTable.Rows.Count; i++)
{
var lDetBovespa = plRetorno.Relatorio.DetalhesBovespa.FindAll(papel =>
{
return(papel.PapelCodigoNegocio == lDataTable.Rows[i]["CD_NEGOCIO"].DBToString() &&
papel.PapelSentido == lDataTable.Rows[i]["SENTIDO"].DBToString());
});
for (int j = 0; j < lDetBovespa.Count; j++)
{
lDetBovespa[j].TotalCodigoNegocio = lDataTable.Rows[i]["CD_NEGOCIO"].DBToString();
lDetBovespa[j].TotalNet = lDataTable.Rows[i]["TOTAL_NET"].DBToDecimal();
lDetBovespa[j].TotalSentido = lDataTable.Rows[i]["SENTIDO"].DBToString();
lDetBovespa[j].TotalPrecoNet = lDataTable.Rows[i]["PRECO_NET"].DBToDecimal();
}
//plRetorno.Relatorio.DetalhesBovespa.Add(lDetBovespa);
}
}
}
}
}
private void BuscarFax_Papel(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_PAPEL_BOV_BR"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoCliente);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
plRetorno.Relatorio.DetalhesBovespa = new List <FaxBovespaDetalheInfo>();
for (int i = 0; i < lDataTable.Rows.Count; i++)
{
var lDetBovespa = new FaxBovespaDetalheInfo();
lDetBovespa.PapelCodigoIsin = lDataTable.Rows[i]["CD_CODISI"].DBToString();
lDetBovespa.PapelCodigoNegocio = lDataTable.Rows[i]["CD_NEGOCIO"].DBToString();
lDetBovespa.PapelCorretagem = lDataTable.Rows[i]["CORRETAGEM"].DBToDecimal();
lDetBovespa.PapelNomeRes = lDataTable.Rows[i]["NM_NOMRES"].DBToString();
lDetBovespa.PapelPreco = lDataTable.Rows[i]["PRECO"].DBToDecimal();
lDetBovespa.PapelQuantidade = lDataTable.Rows[i]["QUANT"].DBToInt32();
lDetBovespa.PapelSentido = lDataTable.Rows[i]["SENTIDO"].DBToString();
lDetBovespa.PapelTipoMercado = lDataTable.Rows[i]["TP_MERCADO"].DBToString();
lDetBovespa.PapelTotal = lDataTable.Rows[i]["TOTAL"].DBToDecimal();
plRetorno.Relatorio.DetalhesBovespa.Add(lDetBovespa);
}
}
}
}
}
private void BuscarFaxVol_DataLiquidacao(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_DTLIQ_BMF"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoCliente);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
plRetorno.RelatorioBmf.DataLiquidacao = lDataTable.Rows[0]["DT_LIQUIDACAO"].DBToDateTime();
}
}
}
}
private void BuscarFax_Papel(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_PAPEL_BMF"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoClienteBmf.Value);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
for (int i = 0; i < plRetorno.RelatorioBmf.CabecalhoGridBmf.Count; i++)
{
plRetorno.RelatorioBmf.CabecalhoGridBmf[i].DetalhesBmf = new List <FaxBmfDetalheInfo>();
}
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
//plRetorno.RelatorioBmf.ca.DetalhesBmf = new List<FaxBmfDetalheInfo>();
for (int i = 0; i < lDataTable.Rows.Count; i++)
{
var lCabBmf = plRetorno.RelatorioBmf.CabecalhoGridBmf.FindAll(papel =>
{
return((papel.CabecalhoCommod + papel.CabecalhoSerie) == lDataTable.Rows[i]["CD_NEGOCIO"].DBToString() &&
papel.CabecalhoSentido == lDataTable.Rows[i]["SENTIDO"].DBToString());
});
for (int j = 0; j < lCabBmf.Count; j++)
{
var lDetBmf = new FaxBmfDetalheInfo();
lDetBmf.PapelSentido = lDataTable.Rows[i]["SENTIDO"].DBToString();
lDetBmf.PapelCodigoNegocio = lDataTable.Rows[i]["CD_NEGOCIO"].DBToString();
lDetBmf.PapelPreco = lDataTable.Rows[i]["PRECO"].DBToDecimal();
lDetBmf.PapelQuantidade = lDataTable.Rows[i]["QUANTIDADE"].DBToInt32();
lCabBmf[j].DetalhesBmf.Add(lDetBmf);
}
}
}
}
}
}
public FaxResponse ObterFaxBmfVolatilidade(FaxRequest pParametros)
{
var lRetorno = new FaxResponse();
try
{
lRetorno = new FaxBmfDbLib().ObterFaxBmfVolatilidade(pParametros);
}
catch (Exception ex)
{
gLogger.Error(string.Concat("Erro ao consultar Fax de BMF Volatilidade ; Cliente: ", pParametros.ConsultaCodigoClienteBmf.Value.ToString()), ex);
lRetorno.DescricaoResposta = ex.ToString();
lRetorno.StatusResposta = Library.MensagemResponseStatusEnum.ErroPrograma;
}
return(lRetorno);
}
private void BuscarFax_Cabecalho(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_CAB_BMF"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoClienteBmf.Value);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
plRetorno.RelatorioBmf.CodigoCliente = lDataTable.Rows[0]["CD_CLIENTE"].DBToInt32();
plRetorno.RelatorioBmf.NomeCliente = lDataTable.Rows[0]["NM_CLIENTE"].DBToString();
plRetorno.RelatorioBmf.Telefone = lDataTable.Rows[0]["TELEFONE"].DBToString();
plRetorno.RelatorioBmf.Fax = lDataTable.Rows[0]["FAX"].DBToString();
plRetorno.RelatorioBmf.DataPregao = pParametros.ConsultaDataMovimento;
}
}
}
}
private FaxRequest GetRequest()
{
FaxRequest request = new FaxRequest();
request.AppCode = "CNF";
request.AppReference = "293023";
request.AppSender = "srajaman";
request.ReceiptMethodType = "email";
request.ReceiptMethodValue = "*****@*****.**";
request.Recipient = "Samy Raj";
request.AddDocument(@"c:\temp\test\test3.Tif", 1);
request.FaxNumber = "3555330";
request.Action.SucessMethodType = "email";
request.Action.SucessMethodValue = "*****@*****.**";
request.Action.FailMethodType = "email";
request.Action.FailMethodValue = "*****@*****.**";
return(request);
}
public void SendToGateway(AssociatedDoc assDoc, SummaryData sumData)
{
if (assDoc == null)
{
throw new Exception("Unable to find an associated doc to transmit." + Environment.NewLine +
"Error CNF-421 in " + FORM_NAME + ".SendToGateway().");
}
if (sumData == null)
{
throw new Exception("Unable to transmit an associated document without an attached summary data." + Environment.NewLine +
"Error CNF-422 in " + FORM_NAME + ".SendToGateway().");
}
DetermineTransmitDestination(assDoc);
if (transmitDestination == null)
{
UserCanceled = true;
return;
}
int xmitRequestId = xmitRequestDal.SaveAssociatedDocumentXmitRequest(assDoc.Id,
transmitDestination.Type, transmitDestination.Value, InboundSettings.UserName);
var callbackGen = new TransmitCallbackGenerator(xmitRequestId);
var destinations = transmitDestination.Value.Split(';');
foreach (string destin in destinations)
{
var request = new FaxRequest {
FaxNumber = destin, AppCode = PRODUCT_INB_APP_CODE
};
request.AppSender = InboundSettings.UserName;
request.ReceiptAction = new CallbackAction("http",
callbackGen.GenerateUrl(TransmitCallbackAction.Queued));
request.Action.SuccessAction = new CallbackAction("http",
callbackGen.GenerateUrl(TransmitCallbackAction.Success));
request.Action.FailureAction = new CallbackAction("http",
callbackGen.GenerateUrl(TransmitCallbackAction.Failed));
request.AppReference = Convert.ToString(sumData.TradeSysTicket);
request.Recipient = sumData.CptySn;
AddDocumentToRequest(assDoc, request);
var email = new Emailer();
if (transmitDestination.Type == TransmitDestinationType.EMAIL)
{
request.SendMethod = "EMAIL";
request.EmailAddress = request.FaxNumber;
request.FaxNumber = "";
email.SendToFaxGateway(InboundSettings.EmailHost,
InboundSettings.TransmissionGatewayEmailFromAddress,
InboundSettings.TransmissionGatewayEmailToAddress,
request,
"");
}
else
{
request.SendMethod = "FAX";
email.SendToFaxGateway(InboundSettings.EmailHost,
InboundSettings.TransmissionGatewayEmailFromAddress,
InboundSettings.TransmissionGatewayEmailToAddress,
request,
"");
}
}
}
private void BuscarFax_RODAPE(ref FaxRequest pParametros, ref AcessaDados pAcessoDados, ref FaxResponse plRetorno)
{
using (DbCommand lDbCommand = pAcessoDados.CreateCommand(CommandType.StoredProcedure, "PRC_FAX_RODAPE_BOV_BR"))
{
pAcessoDados.AddInParameter(lDbCommand, "pClienteCodigo", DbType.Int32, pParametros.ConsultaCodigoCliente);
pAcessoDados.AddInParameter(lDbCommand, "pData", DbType.Date, pParametros.ConsultaDataMovimento);
using (var lDataTable = pAcessoDados.ExecuteOracleDataTable(lDbCommand))
{
if (null != lDataTable && lDataTable.Rows.Count > 0)
{
for (int i = 0; i < lDataTable.Rows.Count; i++)
{
if (lDataTable.Rows[i]["TP_NEGOCIO"].DBToString() == "FUT")
{
plRetorno.Relatorio.RodapeTotalComprasOpcao = lDataTable.Rows[i]["TOTAL_COMPRAS_OPCAO"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalVendasOpcao = lDataTable.Rows[i]["TOTAL_VENDAS_OPCAO"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalTermoOpcao = lDataTable.Rows[i]["TOTAL_TERMO"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalAjusteOpcao = lDataTable.Rows[i]["TOTAL_AJUSTE"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalNegociosOpcao = lDataTable.Rows[i]["TOTAL_NEGOCIOS"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalCorretagemOpcao = lDataTable.Rows[i]["TOTAL_CORRETAGEM"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaCblcOpcao = lDataTable.Rows[i]["TAXAS_CBLC"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaBovespaOpcao = lDataTable.Rows[i]["TAXAS_BOVESPA"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaOperacionaisOpcao = lDataTable.Rows[i]["TAXAS_OPERACIONAIS"].DBToDecimal();
plRetorno.Relatorio.RodapeOutrasDepesasOpcao = lDataTable.Rows[i]["OUTRAS_DESPESAS"].DBToDecimal();
plRetorno.Relatorio.RodapeIRDayTradeOpcao = lDataTable.Rows[i]["IR_DAY_TRADE"].DBToDecimal();
plRetorno.Relatorio.RodapeIrOperacoesOpcao = lDataTable.Rows[i]["IR_OPERACOES"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalLiquidoOpcao = lDataTable.Rows[i]["TOTAL_LIQUIDO"].DBToDecimal();
plRetorno.Relatorio.RodapeBaseIRDTOpcao = lDataTable.Rows[i]["BASE_IR_DT"].DBToDecimal();
plRetorno.Relatorio.RodapeBaseIROperacoesOpcao = lDataTable.Rows[i]["BASE_IR_OPER"].DBToDecimal();
plRetorno.Relatorio.RodapeEmolumentoBolsaOpcao = lDataTable.Rows[i]["EMOLUMENTO_BOLSA"].DBToDecimal();
plRetorno.Relatorio.RodapeEmolumentoTotalOpcao = lDataTable.Rows[i]["EMOLUMENTO_TOTAL"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaLiquidacaoOpcao = lDataTable.Rows[i]["TAXA_LIQUIDACAO"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaRegistroBolsaOpcao = lDataTable.Rows[i]["TAXA_REGISTRO_BOLSA"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaRegistroTotalOpcao = lDataTable.Rows[i]["TAXA_REGISTRO_TOTAL"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaRegistroOpcao = lDataTable.Rows[i]["TAXA_REGISTRO"].DBToDecimal();
}
else
{
plRetorno.Relatorio.RodapeTotalComprasVista = lDataTable.Rows[i]["TOTAL_COMPRAS_VISTA"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalVendasVista = lDataTable.Rows[i]["TOTAL_VENDAS_VISTA"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalTermoVista = lDataTable.Rows[i]["TOTAL_TERMO"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalAjusteVista = lDataTable.Rows[i]["TOTAL_AJUSTE"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalNegociosVista = lDataTable.Rows[i]["TOTAL_NEGOCIOS"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalCorretagemVista = lDataTable.Rows[i]["TOTAL_CORRETAGEM"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaCblcVista = lDataTable.Rows[i]["TAXAS_CBLC"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaBovespaVista = lDataTable.Rows[i]["TAXAS_BOVESPA"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaOperacionaisVista = lDataTable.Rows[i]["TAXAS_OPERACIONAIS"].DBToDecimal();
plRetorno.Relatorio.RodapeOutrasDepesasVista = lDataTable.Rows[i]["OUTRAS_DESPESAS"].DBToDecimal();
plRetorno.Relatorio.RodapeIRDayTradeVista = lDataTable.Rows[i]["IR_DAY_TRADE"].DBToDecimal();
plRetorno.Relatorio.RodapeIrOperacoesVista = lDataTable.Rows[i]["IR_OPERACOES"].DBToDecimal();
plRetorno.Relatorio.RodapeTotalLiquidoVista = lDataTable.Rows[i]["TOTAL_LIQUIDO"].DBToDecimal();
plRetorno.Relatorio.RodapeBaseIRDTVista = lDataTable.Rows[i]["BASE_IR_DT"].DBToDecimal();
plRetorno.Relatorio.RodapeBaseIROperacoesVista = lDataTable.Rows[i]["BASE_IR_OPER"].DBToDecimal();
plRetorno.Relatorio.RodapeEmolumentoBolsaVista = lDataTable.Rows[i]["EMOLUMENTO_BOLSA"].DBToDecimal();
plRetorno.Relatorio.RodapeEmolumentoTotalVista = lDataTable.Rows[i]["EMOLUMENTO_TOTAL"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaLiquidacaoVista = lDataTable.Rows[i]["TAXA_LIQUIDACAO"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaRegistroBolsaVista = lDataTable.Rows[i]["TAXA_REGISTRO_BOLSA"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaRegistroTotalVista = lDataTable.Rows[i]["TAXA_REGISTRO_TOTAL"].DBToDecimal();
plRetorno.Relatorio.RodapeTaxaRegistroVista = lDataTable.Rows[i]["TAXA_REGISTRO"].DBToDecimal();
}
}
}
}
}
}
