protected void btnpdf_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string strRuta = Server.MapPath("ListadoArticulos1.rpt");
myReportDocument.Load(strRuta);
DataTable dt = objListado.ListarTodos();
myReportDocument.SetDataSource(dt);
myReportDocument.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, "Listado");
}
protected void btnImprimmer_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rpth = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rpth.Load(Server.MapPath("~/Report/rptAgence.rpt"));
rpth.SetDataSource(GetTableAgence());
rpth.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, String.Format("Liste_Agence_{0}", DateTime.Now));
}
protected void btnImpression_Click(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rpth = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rpth.Load(Server.MapPath("~/Report/rptPersonne.rpt"));
rpth.SetDataSource(GetTablePersonne());
rpth.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, "Liste Personne");
}
public void GetReport()
{
try
{
string sReportHeading = "";
string sAmtInWords = "";
string sReportcomment = "";
string sReportInFile = "";
string strSQL = "";
sReportHeading = "";
if (SessionUserData.AppInfo.TempStrVariable_1 == "IGST")
{
sReportInFile = "GST_I_Invoice.rpt";
}
else
{
sReportInFile = "GST_SU_Invoice.rpt";
}
strSQL = " AAA_M_USP_Print_Invoice " + SessionUserData.Company.CompanyID +
"," + SessionUserData.Company.BranchID +
"," + SessionUserData.Company.YearID +
"," + SessionUserData.AppInfo.TempIntVariable_1;
DataTable myDS = new DataTable();
myDS = MaheshAF18.Application.MEF.DA_GetDataTable(strSQL);
if (File.Exists(Server.MapPath(myDS.Rows[0]["BL_Logo_Url"].ToString())))
{
FileStream stream = new FileStream(Server.MapPath(myDS.Rows[0]["BL_Logo_Url"].ToString()), FileMode.Open, FileAccess.Read);
byte[] ImgData = new byte[stream.Length];
stream.Read(ImgData, 0, Convert.ToInt32(stream.Length));
stream.Close();
myDS.Rows[0]["BL_Logo_Img"] = ImgData;
}
decimal vatTotalAmt = Convert.ToDecimal(0 + myDS.Rows[0]["SINV_HDR_Total_Gross_Amt"].ToString());
sAmtInWords = MaheshAF18.Utility.NoToWord.AmtInWord_INR(vatTotalAmt);
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument = default(CrystalDecisions.CrystalReports.Engine.ReportDocument);
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
myReportDocument.Load(Server.MapPath("..\\Rpt\\") + sReportInFile + "");
myReportDocument.Database.Tables[0].SetDataSource(myDS);
//myReportDocument.SetParameterValue("pRepHeading", sReportHeading);
myReportDocument.SetParameterValue("AmtInWords ", sAmtInWords);
myReportDocument.ExportToHttpResponse(ExportFormatType.PortableDocFormat, System.Web.HttpContext.Current.Response, false, "Invoice");
//Session["reportDataSource"] = myReportDocument;
//CrystalReportViewer1.DisplayGroupTree = false;
//CrystalReportViewer1.ReportSource = myReportDocument;
//CrystalReportViewer1.DataBind();
}
catch (Exception ex)
{
DisplayCustomMessageSummary(ex.Message);
}
}
protected void btnReporte_OnClick(object Sender, EventArgs E)
{
dtsTramitesPagos dtsTramitesPagos = new dtsTramitesPagos();
cargarTramitesPagos(Convert.ToInt32(ddlAnios.SelectedValue));
List <Objetos.TramitePago> lstTramitesPagos = TramitePagoBL.ObtenerListaTramitesPagosPorAnio(Convert.ToInt32(ddlAnios.SelectedValue));
foreach (var tramitePago in lstTramitesPagos)
{
dtsTramitesPagos.TramitesPagos.AddTramitesPagosRow(
tramitePago.FechaActaEntregaRecepcionBienesContratados == null ? "" : tramitePago.FechaActaEntregaRecepcionBienesContratados.Value.ToShortDateString(),
tramitePago.NumActaEntregaRecepcionBienesContratados,
tramitePago.FechaRecepcionFacturaBienesContratados == null ? "": tramitePago.FechaRecepcionFacturaBienesContratados.Value.ToShortDateString(),
tramitePago.FechaFacturaBienesContratados == null ? "" : tramitePago.FechaFacturaBienesContratados.Value.ToShortDateString(),
tramitePago.NumFacturaBienesContratados,
tramitePago.FolioInstanciaEjercicioFiscal,
tramitePago.OficioSolicitudPagoSefin,
tramitePago.FechaOficioSolicitudSefin == null ? "" : tramitePago.FechaOficioSolicitudSefin.Value.ToShortDateString(),
tramitePago.NumContrareciboPago.ToString(),
tramitePago.NumTransferenciaBancaria,
tramitePago.IdTramitePago.ToString()
);
}
CrystalDecisions.CrystalReports.Engine.ReportDocument repote = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
try
{
CrystalDecisions.Shared.ExportFormatType formato = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
repote.Load(Server.MapPath("./../") + "Reportes/CrystalReports/ReporteTramitesPagos.rpt");
repote.SetDataSource(dtsTramitesPagos);
repote.ExportToHttpResponse(formato, Response, true, string.Format("TramitePago{0}", ddlAnios.SelectedValue));
}
catch (Exception e)
{
throw e;
}
}
public void ProcessRequest(HttpContext context)
{
try
{
CrystalDecisions.CrystalReports.Engine.ReportDocument doc
= new CrystalDecisions.CrystalReports.Engine.ReportDocument();
doc.Load(HttpContext.Current.Server.MapPath("~/Reporting/sample.rpt"));
ExportOptions options = new ExportOptions();
options.ExportFormatType = ExportFormatType.PortableDocFormat;
string contentType = "application/pdf";
String fileName = "InterplanReport"; //use for infoXpert upload file name
//export report
doc.ExportToHttpResponse(
options,
context.Response,
false,
null
);
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Init(object sender, EventArgs e)
{
try
{
var culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
culture.NumberFormat.CurrencySymbol = string.Empty;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
base.InitializeCulture();
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/Iva_Compras.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "Iva_Compras.xsd", true);
oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
bool HayME = false;
string reportPath = "";
if (Session["monedasExtranjeras"] != null)
{
HayME = (bool)Session["monedasExtranjeras"];
}
if (!HayME)
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaComprasCR.rpt");
}
else
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaComprasMECR.rpt");
}
oRpt.Load(reportPath);
Entidades.IvaCompras ivaCompras = new Entidades.IvaCompras();
if (Session["ivaCompras"] != null)
{
ivaCompras = (Entidades.IvaCompras)Session["ivaCompras"];
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(ivaCompras.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, ivaCompras);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
oRpt.SetDataSource(ds);
}
else
{
Response.Redirect("~/Facturacion/Electronica/Reportes/IvaComprasFiltros.aspx", true);
}
string formatoRptExportar = "";
if (Session["formatoRptExportar"] != null)
{
formatoRptExportar = (string)Session["formatoRptExportar"];
}
if (Session["mostrarFechaYHora"] != null)
{
if ((bool)Session["mostrarFechaYHora"] == false)
{
oRpt.DataDefinition.FormulaFields["MostrarFechaYHora"].Text = "'N'";
}
}
oRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
oRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
oRpt.DataDefinition.FormulaFields["RazSoc"].Text = "'" + ((Entidades.Sesion)Session["Sesion"]).Cuit.RazonSocial + "'";
if (formatoRptExportar == "")
{
CrystalReportViewer1.GroupTreeStyle.ShowLines = false;
CrystalReportViewer1.HasToggleGroupTreeButton = false;
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
CrystalReportViewer1.ReportSource = oRpt;
CrystalReportViewer1.HasPrintButton = true;
}
else
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(ivaCompras.Cuit);
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaCompras.PeriodoDsd).ToString("yyyyMMdd"));
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaCompras.PeriodoHst).ToString("yyyyMMdd"));
if (formatoRptExportar == "PDF")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
if (formatoRptExportar == "Excel")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.ExcelFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreateExcelFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, Server.MapPath("~/TempExcel/") + sb.ToString() + ".xls");
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.ClearContent();
response.Clear();
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment; filename=" + sb.ToString() + ".xls" + ";");
response.TransmitFile(Server.MapPath("~/TempExcel/" + sb.ToString() + ".xls"));
response.Flush();
response.End();
}
}
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
WebForms.Excepciones.Redireccionar(ex, "~/NotificacionDeExcepcion.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
var culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
culture.NumberFormat.CurrencySymbol = string.Empty;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
base.InitializeCulture();
if (Session["lote"] == null)
{
Response.Redirect("~/Inicio.aspx");
}
else
{
try
{
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/lote_comprobantesT.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "lote_comprobantesT.xsd", true);
string imagen = Server.MapPath("~/Facturacion/Electronica/Reportes/Imagen.xsd");
System.IO.File.Copy(imagen, @System.IO.Path.GetTempPath() + "Imagen.xsd", true);
facturaRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/FacturaT.rpt");
facturaRpt.Load(reportPath);
FeaEntidades.Turismo.lote_comprobantes lc = (FeaEntidades.Turismo.lote_comprobantes)Session["lote"];
AsignarCamposOpcionales(lc);
ReemplarResumenImportesMonedaExtranjera(lc);
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(lc.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, lc);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
bool original = true;
try
{
original = (bool)Session["EsComprobanteOriginal"];
if (original == false)
{
facturaRpt.DataDefinition.FormulaFields["Borrador"].Text = "'BORRADOR'";
}
}
catch
{
}
facturaRpt.SetDataSource(ds);
facturaRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
facturaRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
IncrustarLogo(lc.comprobante[0].cabecera.informacion_vendedor.cuit.ToString(), lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString());
string cae = lc.comprobante[0].cabecera.informacion_comprobante.cae;
if (cae.Replace(" ", string.Empty).Equals(string.Empty))
{
cae = "99999999999999";
}
GenerarCodigoBarras(lc.comprobante[0].cabecera.informacion_vendedor.cuit + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00") + lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000") + cae + System.DateTime.Now.ToString("yyyyMMdd"));
AsignarParametros(lc.comprobante[0].resumen.importe_total_factura);
facturaRpt.Subreports["impuestos"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
facturaRpt.Subreports["resumen"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(lc.comprobante[0].cabecera.informacion_vendedor.cuit);
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.numero_comprobante.ToString("00000000"));
if (original == false)
{
sb.Append("-BORRADOR");
}
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
facturaRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: " + ex.Message + " " + ex.StackTrace);
throw new Exception(ex.Message);
//WebForms.Excepciones.Redireccionar(ex, "~/Excepciones/Excepciones.aspx");
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
try
{
var culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
culture.NumberFormat.CurrencySymbol = string.Empty;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
base.InitializeCulture();
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/Iva_Ventas.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "Iva_Ventas.xsd", true);
oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
bool HayME = false;
string reportPath = "";
if (Session["monedasExtranjeras"] != null)
{
HayME = (bool)Session["monedasExtranjeras"];
}
if (!HayME)
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaVentasCR.rpt");
}
else
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaVentasMECR.rpt");
}
oRpt.Load(reportPath);
Entidades.IvaVentas ivaVentas = new Entidades.IvaVentas();
if (Session["ivaVentas"] != null)
{
ivaVentas = (Entidades.IvaVentas)Session["ivaVentas"];
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(ivaVentas.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, ivaVentas);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
oRpt.SetDataSource(ds);
}
else
{
Response.Redirect("~/Facturacion/Electronica/Reportes/IvaVentasFiltros.aspx", true);
}
string formatoRptExportar = "";
if (Session["formatoRptExportar"] != null)
{
formatoRptExportar = (string)Session["formatoRptExportar"];
}
if (Session["mostrarFechaYHora"] != null)
{
if ((bool)Session["mostrarFechaYHora"] == false)
{
oRpt.DataDefinition.FormulaFields["MostrarFechaYHora"].Text = "'N'";
}
}
oRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
oRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
oRpt.DataDefinition.FormulaFields["RazSoc"].Text = "'" + ((Entidades.Sesion)Session["Sesion"]).Cuit.RazonSocial + "'";
if (formatoRptExportar == "")
{
CrystalReportViewer1.GroupTreeStyle.ShowLines = false;
CrystalReportViewer1.HasToggleGroupTreeButton = false;
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
CrystalReportViewer1.ReportSource = oRpt;
CrystalReportViewer1.HasPrintButton = true;
}
else
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(ivaVentas.Cuit);
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaVentas.PeriodoDsd).ToString("yyyyMMdd"));
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaVentas.PeriodoHst).ToString("yyyyMMdd"));
if (formatoRptExportar == "PDF")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
if (formatoRptExportar == "Excel")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.ExcelFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreateExcelFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, Server.MapPath("~/TempExcel/") + sb.ToString() + ".xls");
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.ClearContent();
response.Clear();
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment; filename=" + sb.ToString() + ".xls" + ";");
response.TransmitFile(Server.MapPath("~/TempExcel/" + sb.ToString() + ".xls"));
response.Flush();
response.End();
}
}
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
WebForms.Excepciones.Redireccionar(ex, "~/NotificacionDeExcepcion.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
var culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
culture.NumberFormat.CurrencySymbol = string.Empty;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
base.InitializeCulture();
if (Session["lote"] == null)
{
Response.Redirect("~/Inicio.aspx");
}
else
{
try
{
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/lote_comprobantes.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "lote_comprobantes.xsd", true);
string imagen = Server.MapPath("~/Facturacion/Electronica/Reportes/Imagen.xsd");
System.IO.File.Copy(imagen, @System.IO.Path.GetTempPath() + "Imagen.xsd", true);
facturaRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/Factura.rpt");
facturaRpt.Load(reportPath);
FeaEntidades.InterFacturas.lote_comprobantes lc = (FeaEntidades.InterFacturas.lote_comprobantes)Session["lote"];
AsignarCamposOpcionales(lc);
ReemplarResumenImportesMonedaExtranjera(lc);
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(lc.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, lc);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
bool original = true;
try
{
original = (bool)Session["EsComprobanteOriginal"];
if (original == false)
{
facturaRpt.DataDefinition.FormulaFields["Borrador"].Text = "'BORRADOR'";
}
}
catch
{
}
facturaRpt.SetDataSource(ds);
facturaRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
facturaRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
IncrustarLogo(lc.cabecera_lote.cuit_vendedor.ToString(), lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString());
string cae = lc.comprobante[0].cabecera.informacion_comprobante.cae;
if (cae.Replace(" ",string.Empty).Equals(string.Empty))
{
cae = "99999999999999";
}
GenerarCodigoBarras(lc.cabecera_lote.cuit_vendedor + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00") + lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000") + cae +System.DateTime.Now.ToString("yyyyMMdd"));
AsignarParametros(lc.comprobante[0].resumen.importe_total_factura);
facturaRpt.Subreports["impuestos"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
facturaRpt.Subreports["resumen"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(lc.cabecera_lote.cuit_vendedor);
sb.Append("-");
sb.Append(lc.cabecera_lote.punto_de_venta.ToString("0000"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.numero_comprobante.ToString("00000000"));
if (original == false)
{
sb.Append("-BORRADOR");
}
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
facturaRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: " + ex.Message + " " + ex.StackTrace);
throw new Exception(ex.Message);
//WebForms.Excepciones.Redireccionar(ex, "~/Excepciones/Excepciones.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["lote"] == null)
{
Response.Redirect("~/Inicio.aspx");
}
else
{
try
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en-US");
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/lote_comprobantes.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "lote_comprobantes.xsd", true);
string imagen = Server.MapPath("~/Facturacion/Electronica/Reportes/Imagen.xsd");
System.IO.File.Copy(imagen, @System.IO.Path.GetTempPath() + "Imagen.xsd", true);
facturaRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/Factura.rpt");
facturaRpt.Load(reportPath);
FeaEntidades.InterFacturas.lote_comprobantes lc = (FeaEntidades.InterFacturas.lote_comprobantes)Session["lote"];
AsignarCamposOpcionales(lc);
ReemplarResumenImportesMonedaExtranjera(lc);
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(lc.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, lc);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
facturaRpt.SetDataSource(ds);
facturaRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
facturaRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
IncrustarLogo();
string cae = lc.comprobante[0].cabecera.informacion_comprobante.cae;
if (cae.Replace(" ",string.Empty).Equals(string.Empty))
{
cae = "99999999999999";
}
GenerarCodigoBarras(lc.cabecera_lote.cuit_vendedor + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00") + lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000") + cae +System.DateTime.Now.ToString("yyyyMMdd"));
AsignarParametros(lc.comprobante[0].resumen.importe_total_factura);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(lc.cabecera_lote.cuit_vendedor);
sb.Append("-");
sb.Append(lc.cabecera_lote.punto_de_venta.ToString("0000"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.numero_comprobante.ToString("00000000"));
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
facturaRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
CedeiraUIWebForms.Excepciones.Redireccionar(ex, "~/Excepciones/Excepcion.aspx");
}
}
}