protected void btnGenerar_Click(object sender, EventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { cReportingRegional oReportingRegional = new cReportingRegional(ref oConn); oReportingRegional.NomReporting = "Reporte solicitado el " + DateTime.Now.ToString("dd-MM-yyyy"); oReportingRegional.EstReporting = "S"; oReportingRegional.FechReporting = DateTime.Now.ToString("yyyyMMdd"); oReportingRegional.AnoReporting = cmbox_ano.SelectedValue; oReportingRegional.CodTipo = oUsuario.CodTipoUsuario; oReportingRegional.Accion = "CREAR"; oReportingRegional.Put(); StringBuilder js = new StringBuilder(); js.Append("function LgRespuesta() {"); js.Append(" window.radalert('Se realizo la solicitud de generación del Reporting Regional, espere uno 5 minutos y vuelva a ingresar a la funcionalidad para obtener el reporte.', 330, 210); "); js.Append(" Sys.Application.remove_load(LgRespuesta); "); js.Append("};"); js.Append("Sys.Application.add_load(LgRespuesta);"); Page.ClientScript.RegisterStartupScript(this.GetType(), "radalert", js.ToString(), true); rdGridReporting.Rebind(); } oConn.Close(); }
protected void rdGridReporting_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { cReportingRegional oReportingRegional = new cReportingRegional(ref oConn); oReportingRegional.CodTipo = oUsuario.CodTipoUsuario; rdGridReporting.DataSource = oReportingRegional.Get(); } oConn.Close(); }
public void ProcessRequest(HttpContext context) { string sPath = string.Empty; string sFileName = string.Empty; string sCodUsuario = oWeb.GetData("CodUsuario"); string pCodReporting = oWeb.GetData("pCodReporting"); DBConn oConn = new DBConn(); if (oConn.Open()) { cReportingRegional oReportingRegional = new cReportingRegional(ref oConn); oReportingRegional.CodReporting = pCodReporting; DataTable dtReportingRegional = oReportingRegional.Get(); if (dtReportingRegional != null) { if (dtReportingRegional.Rows.Count > 0) { sFileName = dtReportingRegional.Rows[0]["filename_reporting"].ToString(); cCliente oCliente = new cCliente(ref oConn); oCliente.NkeyCliente = sCodUsuario; DataTable dtCliente = oCliente.Get(); if (dtCliente != null) { if (dtCliente.Rows.Count > 0) { sPath = dtCliente.Rows[0]["pathsdocscaneados"].ToString(); } } dtReportingRegional = null; } } } oConn.Close(); System.Web.HttpResponse oResponse = System.Web.HttpContext.Current.Response; sPath = sPath + "\\Mattel Europa\\Reporte_Regional\\" + sFileName; oResponse.AppendHeader("Content-Disposition", "attachment; filename=" + sFileName); // Write the file to the Response const int bufferLength = 10000; byte[] buffer = new Byte[bufferLength]; int length = 0; Stream download = null; try { download = new FileStream(sPath, FileMode.Open, FileAccess.Read); do { if (oResponse.IsClientConnected) { length = download.Read(buffer, 0, bufferLength); oResponse.OutputStream.Write(buffer, 0, length); buffer = new Byte[bufferLength]; } else { length = -1; } }while (length > 0); oResponse.Flush(); oResponse.End(); } finally { if (download != null) { download.Close(); } } }