public static void PrintWebControl(Control ControlToPrint, Control MyStyle) { StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ControlToPrint is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ControlToPrint).Width = w; } System.Web.UI.Page pg = new System.Web.UI.Page(); pg.EnableEventValidation = false; HtmlForm frm = new HtmlForm(); frm.Controls.Add(MyStyle); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ControlToPrint); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write(strHTML); HttpContext.Current.Response.Write("<script>window.print();</script>"); HttpContext.Current.Response.End(); }
private void OutFile() { //定义输出流 System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); System.Web.UI.Page oPage = new System.Web.UI.Page(); System.Web.UI.HtmlControls.HtmlForm oHtmlForm = new System.Web.UI.HtmlControls.HtmlForm(); oPage.EnableEventValidation = false; oPage.DesignerInitialize(); oPage.Controls.Add(oHtmlForm); oPage.EnableViewState = false; oHtmlForm.Controls.Add(_controlOut); oPage.RenderControl(oHtmlTextWriter); //定义文档类型 字符编码 Response.Clear(); Response.Buffer = true; Response.Charset = "gb2312"; string oDisposition = string.Format("attachment;filename=WSS_{0}.{1}", _fileName, _fileSuffix); Response.AppendHeader("Content-disposition", oDisposition); Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); Response.ContentType = string.Format("application/{0}", _fileType); this.EnableViewState = false; string oResponseStr = oStringWriter.ToString().Replace("\r\n", "").Replace("bold;'></th>", "bold;'>"); oResponseStr = System.Text.RegularExpressions.Regex.Replace(oResponseStr, @"<input.*?/>", ""); Response.Write(oResponseStr); Response.End(); }
public static void PrintWebControl(Control ctrl, string Script) { StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ctrl is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ctrl).Width = w; } Page pg = new Page(); pg.EnableEventValidation = false; if (Script != string.Empty) { pg.ClientScript.RegisterStartupScript(pg.GetType(), "PrintJavaScript", Script); } HtmlForm frm = new HtmlForm(); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ctrl); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write(strHTML); HttpContext.Current.Response.Write("<script>window.print();</script>"); HttpContext.Current.Response.End(); }
public static void PrintWebControl(Control ctrl, string Script) { StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ctrl is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ctrl).Width = w; } Page pg = new Page(); pg.EnableEventValidation = false; if (Script != string.Empty) { pg.ClientScript.RegisterStartupScript(pg.GetType(), "PrintJavaScript", Script); } HtmlForm frm = new HtmlForm(); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ctrl); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write(strHTML); HttpContext.Current.Response.Write("<script>window.print();</script>"); HttpContext.Current.Response.End(); }
protected void imgBtnExportarExcelArchivos_Click(object sender, ImageClickEventArgs e) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); gvJobCancelacioneXTicket.AllowPaging = false; gvJobCancelacioneXTicket.DataBind(); gvJobCancelacioneXTicket.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(gvJobCancelacioneXTicket); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=ArchivosDeProcedimiento.xls"); Response.Charset = "UTF-8"; //Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentEncoding = System.Text.Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
protected void imgBtnExportarExcelEjecucion_Click(object sender, ImageClickEventArgs e) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); gvIncidenciasBatch.AllowPaging = false; gvIncidenciasBatch.DataBind(); gvIncidenciasBatch.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(gvIncidenciasBatch); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=ReporteIncidenciasBatch" + DateTime.Now.ToShortDateString() + ".xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = System.Text.Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
public static void PrintWebControl(Control ctrl, string Script) { StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ctrl is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ctrl).Width = w; } Page pg = new Page(); pg.EnableEventValidation = false; pg.StyleSheetTheme = "../CSS/order.css"; if (Script != string.Empty) { pg.ClientScript.RegisterStartupScript(pg.GetType(), "PrintJavaScript", Script); } HtmlLink link = new HtmlLink(); link.Href = "../CSS/order.css"; HtmlForm frm = new HtmlForm(); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ctrl); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write("<head runat='server'> <title>Printer - Bản in tại Support.evnit.evn.com.vn</title> <link type='text/css' rel='stylesheet' href='../CSS/order.css'><link type='text/css' rel='stylesheet' href='../CSS/style.css'></head>"); HttpContext.Current.Response.Write(strHTML); HttpContext.Current.Response.Write("<script>window.print();</script>"); HttpContext.Current.Response.End(); }
protected void Boton_Excel_Dios_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); GridView_Dios.DataSourceID = string.Empty; GridView_Dios.EnableViewState = false; GridView_Dios.AllowPaging = false; GridView_Dios.DataSource = p2P.mostrarPrecios(0); GridView_Dios.DataBind(); page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(GridView_Dios); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "applicattion/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=Panel_Precios.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
public void PrintWebControl(Control ControlToPrint) { StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ControlToPrint is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ControlToPrint).Width = w; } Page pg = new Page(); pg.EnableEventValidation = false; HtmlForm frm = new HtmlForm(); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ControlToPrint); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); string wstawka = Server.MapPath("~").ToString(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write(htmlToImage(strHTML, zmianaAdresu(wstawka))); HttpContext.Current.Response.Write("<script>window.print();</script>"); HttpContext.Current.Response.End(); Response.Redirect("~/ListaImprez.aspx"); }
protected bool Export() { try { //Descargo el objeto tabla de la sesion con nombre "p_c" ó (Plan Operativo) HtmlTable objTable = (HtmlTable)Session["p_c"]; //Instancio un objeto del tipo StringBuilder objsb StringBuilder objsb = new StringBuilder(); //Instancio un objeto del tipo System.IO.StringWriter sw System.IO.StringWriter sw = new System.IO.StringWriter(objsb); //Instancio un objeto del tipo HtmlTextWriter htw HtmlTextWriter htw = new HtmlTextWriter(sw); //Instancio un objeto del tipo System.Web.UI.Page System.Web.UI.Page pagina = new System.Web.UI.Page(); //Instancio un objeto del tipo HtmlForm var form = new HtmlForm(); //Asigno valores a propiedades del objeto page instanciado pagina.EnableEventValidation = false; pagina.DesignerInitialize(); //Agrego el formulario instaciado a la coleccionde paginas pagina.Controls.Add(form); //Agrego el objeto tabla a la coleccion de controles del formulario instanciado anteriormente form.Controls.Add(objTable); //Realizo el proceso de renderizacion para los elementos agregados a la pagina instanciada pagina.RenderControl(htw); //Limpio el canal de respuesta para esta peticion Response.Clear(); //Habilito el buffer Response.Buffer = true; //Asigno el tipo de contenido Response.ContentType = "application/vnd.ms-excel"; //Asigno el nombre del documento a exportar en el header del response Response.AddHeader("Content-Disposition", "attachment;filename=Plan_Operativo.xls"); //Asigno el tipo de charset "UTF-8" Response.Charset = "UTF-8"; //Establesco la configuracion por defecto para la codificacion Response.ContentEncoding = Encoding.Default; //Realizo el proceso de escritura para el objeto objsb Response.Write(objsb.ToString()); //Finalizo la respuesta Response.End(); return true; } catch (Exception) { return false; } }
protected void imgBtnExcel_Click(object sender, ImageClickEventArgs e) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); gdUsuario.EnableViewState = false; // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(gdUsuario); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=datosHotel.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); //Response.Clear(); //Response.AddHeader("content-disposition", "attachment;filename=Catalogo_Productos.xls"); //Response.Charset = ""; //Response.ContentType = "application/vnd.xls"; //StringWriter StringWriter = new System.IO.StringWriter(); //HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter); //gvDatosAdmin.AllowPaging = false; //Response.Write(StringWriter.ToString()); //Response.End(); }
public void PrintWebControl(Control ControlToPrint) { StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ControlToPrint is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ControlToPrint).Width = w; } Page pg = new Page(); pg.EnableEventValidation = false; HtmlForm frm = new HtmlForm(); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ControlToPrint); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); string wstawka = Server.MapPath("~").ToString(); string path = String.Format("{0}\\Images\\Rezerwacje\\{1}.gif", Server.MapPath("~"), Session["ZamowienieId"]); //korzystanie z biblioteki websiteScreenshote WebsitesScreenshot.WebsitesScreenshot _Obj = new WebsitesScreenshot.WebsitesScreenshot(); WebsitesScreenshot.WebsitesScreenshot.Result _Result = _Obj.CaptureHTML(htmlToImage(strHTML, zmianaAdresu(wstawka))); if (_Result == WebsitesScreenshot.WebsitesScreenshot.Result.Captured) { _Obj.ImageFormat = WebsitesScreenshot.WebsitesScreenshot.ImageFormats.GIF; _Obj.SaveImage(path); } _Obj.Dispose(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write(strHTML); Session[Cart.Ident] = null; HttpContext.Current.Response.Write("<script>window.print();</script>"); HttpContext.Current.Response.End(); Response.Redirect("~/ListaImprez.aspx"); }
protected void btnExportar_Command(object sender, CommandEventArgs e) { if (e.CommandName == "Exportar") { if (GridView1.Rows.Count > 0 && GridView1.Visible == true ) { //try //{ lblMsj.Text = ""; StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); System.Web.UI.Page page = new System.Web.UI.Page(); HtmlForm form = new HtmlForm(); GridView1.EnableViewState = false; // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(GridView1); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=Evaluaciones.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); //} //catch (Exception ex) //{ // EventLogger ev = new EventLogger(); // ev.Save("EvaluacionesDetalle, export excel ", ex); //} } else { lblMsj.Text = "la tabla no contiene datos para exportar..."; } } }
protected bool Export() { try { string html = txtgantt_html.Value; html = html.Replace("!1!", ">"); html = html.Replace("!2!", "<"); html = html.Replace("!3!", "="); html = html.Replace("!4!", "#"); html = html.Replace("!5!", "&"); HtmlGenericControl objTable = new HtmlGenericControl("table"); objTable.InnerHtml = html; StringBuilder objsb = new StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(objsb); HtmlTextWriter htw = new HtmlTextWriter(sw); System.Web.UI.Page pagina = new System.Web.UI.Page(); var form = new HtmlForm(); pagina.EnableEventValidation = false; pagina.DesignerInitialize(); pagina.Controls.Add(form); form.Controls.Add(objTable); pagina.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=Cronograma.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(objsb.ToString()); Response.End(); return true; } catch (Exception) { return false; } }
private void ExportToExcel(string nameReport, GridView wControl) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); ListarAsistencia form = new ListarAsistencia(); wControl.EnableViewState = false; // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(wControl); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
protected void ImageButton1_Command(object sender, CommandEventArgs e) { try { if (e.CommandName != "Page") { ////get the gridview row where the command is raised GridViewRow selectedRow = ((Control)sender).Parent.NamingContainer as GridViewRow; Session["Fecha"] = int.Parse(e.CommandArgument.ToString()); SqlDataSource1.DataBind(); /* Sin error */ StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); DataTable dt2 = ((DataView)this.SqlDataSource1.Select(DataSourceSelectArguments.Empty)).ToTable(); //GridView1.EnableViewState = false; GridView dg = new GridView(); dg.EnableViewState = false; dg.DataSource = dt2; dg.DataBind(); page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(dg); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; //Response.ContentType = "application/vnd.ms-excel"; Response.ContentType = "text/plain"; Response.AddHeader("Content-Disposition", "attachment;filename=" + selectedRow.Cells[1].Text.ToString() + "-" + selectedRow.Cells[4].Text.ToString() + ".xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); } } catch (Exception ex) { Data.DataDataContext db = new DataDataContext(); db.CommandTimeout = 900000; db.InsertarError(ex.Message.ToString(),DateTime.Now); } }
public void ExportGridView(GridView gridView, string nombreArchivo) { var control = ((Control)gridView); PrepareGridViewForExport(ref control); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page pagina = new Page(); dynamic form = new HtmlForm(); gridView.EnableViewState = false; pagina.EnableEventValidation = false; pagina.DesignerInitialize(); pagina.Controls.Add(form); form.Controls.Add(gridView); pagina.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=" + nombreArchivo); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
protected bool Export(HtmlTable table) { try { StringBuilder objsb = new StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(objsb); HtmlTextWriter htw = new HtmlTextWriter(sw); System.Web.UI.Page pagina = new System.Web.UI.Page(); var form = new HtmlForm(); pagina.EnableEventValidation = false; pagina.DesignerInitialize(); pagina.Controls.Add(form); form.Controls.Add(table); pagina.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=MarcoLogico.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(objsb.ToString()); Response.End(); return true; } catch (Exception) { return false; } }
/// <summary> /// 导出数据函数 /// </summary> /// <param name="FileType">导出文件MIME类型</param> /// <param name="FileName">导出文件的名称</param> /// this.Export(GV_List, "application/ms-excel", "ShiftProd.xls"); /// this.Export(GV_List, "application/ms-word", "ShiftProd.doc"); protected void Export(String FileType, String FileName) { int maxResult = 5000; this.AllowPaging = false; this.AllowSorting = false; if (this.FindPager().RecordCount > this.FindPager().PageSize) { if (this.FindPager().RecordCount > maxResult) { this.FindPager().PageSize = maxResult; } else { this.FindPager().PageSize = this.FindPager().RecordCount; } } this.Execute(); System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("ZH-CN", true); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(cultureInfo); HtmlTextWriter htw = new HtmlTextWriter(sw); System.Web.UI.Control parent = this.Parent; MethodInfo getResponseMethodInfo = this.Parent.GetType().GetMethod("GetResponse"); HttpResponse Response = (HttpResponse)getResponseMethodInfo.Invoke(this.Parent, null); MethodInfo renderMethodInfo = this.Parent.GetType().GetMethod("Render"); Page page = new Page(); HtmlForm form = new HtmlForm(); this.EnableViewState = false; // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(this); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; //Response.ContentType = "application/vnd.ms-excel"; //Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)); //设置输出流HttpMiME类型(导出文件格式) Response.ContentType = FileType; Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">"); //Response.Charset = "UTF-8"; //设定输出字符集 Response.Charset = "GB2312"; //Response.ContentEncoding = Encoding.Default; //Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); string content = sw.ToString(); content = renderMethodInfo.Invoke(parent, new object[] { content }) as string; Response.Write(content); Response.Flush(); Response.End(); this.AllowPaging = true; this.AllowSorting = true; //this.PageSize = 10; //this.Execute(); }
public void btn_exportar_datos(object sender, EventArgs e) { if (GridViewIncidente.Rows.Count == 0) { lblMensajeError.Text = "Debe de realizar una busqueda"; return; } string inicio = string.Empty; string fin = string.Empty; string nombre = string.Empty; try { if (this.txbxFechaInicio.Text.EndsWith("M")) { inicio = DateTime.ParseExact(this.txbxFechaInicio.Text, GlobalSistema.formatoFecha, CultureInfo.CreateSpecificCulture("en-US")).ToString("MMddyyyy"); } else { inicio = Convert.ToDateTime(this.txbxFechaInicio.Text).ToString("MMddyyyy"); } if (this.txbxFechaFin.Text.EndsWith("M")) { fin = DateTime.ParseExact(this.txbxFechaFin.Text, GlobalSistema.formatoFecha, CultureInfo.CreateSpecificCulture("en-US")).ToString("MMddyyyy"); } else { fin = Convert.ToDateTime(this.txbxFechaFin.Text).ToString("MMddyyyy"); } nombre = inicio + "_" + fin; } catch (FormatException ex) { fin = ex.Message; inicio = txbxCodigoIncidente.Text; nombre = inicio; //lblMensajeError.Text = "Formato de error "+ex.Message; } StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); page.Controls.Add(form); GridViewIncidente.AllowPaging = false; form.Controls.Add(GridViewIncidente); GridViewIncidente.DataSource = lsSucesosReg; GridViewIncidente.DataBind(); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=reporte_" + nombre + ".xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
public static void ExportarExcelGrilla(GridView grilla, Page pag) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page pagina = new Page(); HtmlForm form = new HtmlForm(); grilla.EnableViewState = false; pagina.EnableEventValidation = false; pagina.DesignerInitialize(); pagina.Controls.Add(form); form.Controls.Add(grilla); pagina.RenderControl(htw); pag.Response.Clear(); pag.Response.Buffer = true; pag.Response.ContentType = "application/vnd.ms-excel"; pag.Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); pag.Response.Charset = "UTF-8"; pag.Response.ContentEncoding = Encoding.Default; pag.Response.Output.Write(sb.ToString()); pag.Response.End(); }
protected void BtnExcel_Click(object sender, ImageClickEventArgs e) { /* Sin error */ StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); grvConsultaSolicitud.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(grvConsultaSolicitud); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; //Response.ContentType = "application/vnd.ms-excel"; Response.ContentType = "text/plain"; Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); //grvConsultaSolicitud.AllowPaging = true; }
public void Methods_Deny_Unrestricted () { Page p = new Page (); p.DesignerInitialize (); Assert.IsNotNull (p.GetPostBackClientEvent (control, "mono"), "GetPostBackClientEvent"); Assert.IsNotNull (p.GetPostBackClientHyperlink (control, "mono"), "GetPostBackClientHyperlink"); Assert.IsNotNull (p.GetPostBackEventReference (control), "GetPostBackEventReference(control)"); Assert.IsNotNull (p.GetPostBackEventReference (control, "mono"), "GetPostBackEventReference(control,string)"); Assert.AreEqual (0, p.GetTypeHashCode (), "GetTypeHashCode"); Assert.IsFalse (p.IsClientScriptBlockRegistered ("mono"), "IsClientScriptBlockRegistered"); Assert.IsFalse (p.IsStartupScriptRegistered ("mono"), "IsStartupScriptRegistered"); p.RegisterArrayDeclaration ("arrayname", "value"); p.RegisterClientScriptBlock ("key", "script"); p.RegisterHiddenField ("name", "hidden"); p.RegisterOnSubmitStatement ("key", "script"); p.RegisterRequiresPostBack (new HtmlTextArea ()); p.RegisterRequiresRaiseEvent (new HtmlAnchor ()); p.RegisterStartupScript ("key", "script"); p.Validate (); p.VerifyRenderingInServerForm (control); #if NET_2_0 p.Controls.Add (control); Assert.IsNotNull (p.FindControl ("mono"), "FindControl"); p.RegisterRequiresControlState (control); Assert.IsTrue (p.RequiresControlState (control), "RequiresControlState"); p.UnregisterRequiresControlState (control); Assert.IsNotNull (p.GetValidators (String.Empty), "GetValidators"); p.Validate (String.Empty); #endif }
protected bool Export(IQueryable datasource, string nombre) { try { StringBuilder objsb = new StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(objsb); HtmlTextWriter htw = new HtmlTextWriter(sw); System.Web.UI.Page pagina = new System.Web.UI.Page(); var form = new HtmlForm(); GridView objgv = new GridView(); objgv.EnableViewState = false; objgv.AllowPaging = false; objgv.DataSource = datasource; objgv.DataBind(); pagina.EnableEventValidation = false; pagina.DesignerInitialize(); pagina.Controls.Add(form); form.Controls.Add(objgv); pagina.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=" + nombre + ".xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(objsb.ToString()); Response.End(); return true; } catch (Exception) { return false; } }
public void btn_exportar_datos(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); DataTable lsdatos = (DataTable)Session["dtExcel"]; page.Controls.Add(form); DatosExcel.AllowPaging = false; form.Controls.Add(DatosExcel); DatosExcel.DataSource = lsdatos; DatosExcel.DataBind(); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; string[] datos = DatosExcel.Caption.Split('.'); Response.AddHeader("Content-Disposition", "attachment;filename=validar_" + datos[0] + ".xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
/// <summary> /// 导出数据函数 /// </summary> /// <param name="FileType">导出文件MIME类型</param> /// <param name="FileName">导出文件的名称</param> protected void Export(GridView gridview, String FileType, String FileName) { /* gridview.AllowPaging = false; gridview.AllowSorting = false; */ if (gridview.Rows.Count > 5000) { ShowWarningMessage("Common.Export.Warning.GreatThan5000", gridview.Rows.Count.ToString()); } else if (gridview.Rows.Count == 0) { ShowWarningMessage("Common.GridView.NoRecordFound"); return; } //gridview.DataBind(); System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("ZH-CN", true); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(cultureInfo); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); gridview.EnableViewState = false; // Deshabilitar la validación de eventos, sólo asp.net 2 page.EnableEventValidation = false; // Realiza las inicializaciones de la instancia de la clase Page que requieran los diseñadores RAD. page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(gridview); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; // Response.ContentType = "application/vnd.ms-excel"; //Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)); //设置输出流HttpMiME类型(导出文件格式) Response.ContentType = FileType; //Response.Charset = "UTF-8"; //设定输出字符集 Response.Charset = "GB2312"; //Response.ContentEncoding = Encoding.Default; Response.ContentEncoding = System.Text.Encoding.UTF8; string content = sw.ToString(); if (CurrentUser != null && CurrentUser.UserLanguage != null && CurrentUser.UserLanguage != string.Empty) { content = TheLanguageMgr.ProcessLanguage(content, CurrentUser.UserLanguage); } else { EntityPreference defaultLanguage = TheEntityPreferenceMgr.LoadEntityPreference(BusinessConstants.ENTITY_PREFERENCE_CODE_DEFAULT_LANGUAGE); content = TheLanguageMgr.ProcessLanguage(content, defaultLanguage.Value); } Response.Write(content); Response.End(); Response.Flush(); /* gridview.AllowPaging = true; gridview.AllowSorting = true; */ //gridview.DataBind(); }
protected void btnWysliMail_Click(object sender, EventArgs e) { UkryjKontrolkeWListView("SelectButton"); btnAkceptuj.Visible = false; btnWysliMail.Visible = false; Label1.Visible = false; string path = String.Format("{0}\\Images\\Rezerwacje\\{1}.gif", Server.MapPath("~"), Session["ZamowienieId"]); //----------------------wstawka----------------------------------- -------------------- btnAkceptuj.Visible = false; Session["ctrl"] = Panel1; Control ctrl = (Control)Session["ctrl"]; StringWriter stringWrite = new StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); if (ctrl is WebControl) { Unit w = new Unit(100, UnitType.Percentage); ((WebControl)ctrl).Width = w; } Page pg = new Page(); pg.EnableEventValidation = false; HtmlForm frm = new HtmlForm(); pg.Controls.Add(frm); frm.Attributes.Add("runat", "server"); frm.Controls.Add(ctrl); pg.DesignerInitialize(); pg.RenderControl(htmlWrite); string strHTML = stringWrite.ToString(); string wstawka = Server.MapPath("~").ToString(); //korzystanie z biblioteki websiteScreenshote WebsitesScreenshot.WebsitesScreenshot _Obj = new WebsitesScreenshot.WebsitesScreenshot(); WebsitesScreenshot.WebsitesScreenshot.Result _Result = _Obj.CaptureHTML(htmlToImage(strHTML, zmianaAdresu(wstawka))); if (_Result == WebsitesScreenshot.WebsitesScreenshot.Result.Captured) { _Obj.ImageFormat = WebsitesScreenshot.WebsitesScreenshot.ImageFormats.GIF; _Obj.SaveImage(path); } _Obj.Dispose(); //----------------------wstawka----------------------------------- ----------------------------------------------- StringBuilder emailMessage = new StringBuilder(); emailMessage.Append("Przesyłamy twoje Rezerwacje w załączniku."); emailMessage.Append("<br />"); emailMessage.Append("Wydrukuj plik gif, aby okazać go przy wejściu na impreze"); MailMessage email = new MailMessage(); email.From = new MailAddress("*****@*****.**"); email.To.Add(new MailAddress(tdEmail.InnerText)); email.Subject = "Twoje rezerwacje"; email.Body = emailMessage.ToString(); email.IsBodyHtml = true; email.Attachments.Add(new System.Net.Mail.Attachment(path)); SmtpClient client = new SmtpClient(); try { client.Send(email); } catch (Exception ex) { } finally { Session[Cart.Ident] = null; Session[Cart.ZamowienieId] = null; Session[Potwierdzenie] = 1; Response.Redirect("~/RezerwacjeWyslane.aspx"); } }
public string cArchivoExcelHTMLPorRequerimientoDetalleGrilla(DetailsView objDetailView, string strNombreArchivo, Page objPage, string IdRequerimiento) { int intIdRequerimiento = int.Parse(IdRequerimiento); StringBuilder sb = new StringBuilder(); #region Creamos la cabecera sb.Append(strCrearDocumentoExcelDetalleGrilla(objDetailView, intIdRequerimiento)); #endregion StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); #region Crea el Archivo Excel try { objDetailView.AllowPaging = false; objDetailView.DataBind(); objDetailView.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(objDetailView); page.RenderControl(htw); objPage.Response.Clear(); objPage.Response.Buffer = true; objPage.Response.ContentType = "application/vnd.ms-excel"; objPage.Response.AppendHeader("Content-Disposition", "attachment;filename=" + strNombreArchivo + "" + DateTime.Now.ToShortDateString() + ".xls"); objPage.Response.Charset = "UTF-8"; objPage.Response.ContentEncoding = System.Text.Encoding.Default; objPage.Response.Write(sb.ToString()); objPage.Response.Flush(); objPage.Response.Close(); objPage.Response.End(); } catch (Exception ex) { return "Error al crear Archivo Excel " + ": " + ex.ToString(); } #endregion return "Por favor guardar el archivo Excel creado"; }
protected void Boton_Excel_Supervisor_Click(object sender, EventArgs e) { if (Session["Buscar"] == null) { Session["Buscar"] = string.Empty; } // limpia las variables por las dudaspor si llegan vacios StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); GridView_Supervisor.DataSourceID = string.Empty; GridView_Supervisor.EnableViewState = false; GridView_Supervisor.AllowPaging = false; GridView_Supervisor.DataSource = LBCMCS.Logica_Mostrar_Carga_Credito_Supervisor((string)Session["Buscar"], (int)Session["Opcion"], (string)Session["Empresa"]); GridView_Supervisor.DataBind(); page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(GridView_Supervisor); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "applicattion/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
Document IDocumentFactory.CreateDocument(DocumentProjectItem projectItem, bool readOnly, DocumentMode mode, DocumentViewType initialView, out DocumentWindow documentWindow, out DesignerHost designerHost) { if (projectItem == null) { throw new ArgumentNullException("projectItem"); } if (initialView == DocumentViewType.Default) { initialView = WebPackage.Instance.WebDefaultView; if (initialView == DocumentViewType.Source) { initialView = DocumentViewType.Composite; } } documentWindow = null; AscxDocument document = new AscxDocument(projectItem); designerHost = new WebFormsDesignerHost(document); document.Load(readOnly); Page page = null; UserControl child = null; if (document.DocumentDirective.Inherits.ToLower().IndexOf("mobile") < 0) { page = new Page(); child = new UserControl(); child.ID = "Page"; documentWindow = new AscxDocumentWindow(designerHost, document, initialView); page.Site = new AscxPageSite(designerHost, page); page.DesignerInitialize(); page.Controls.Add(child); } else { if (!_mobileAssemblyLoadFailed) { if (_mobileAssembly == null) { _mobileAssembly = Assembly.LoadWithPartialName(_mobileAssemblyName); } if (_mobileAssembly != null) { document.Dispose(); document = new AscxDocument(projectItem); Type type = _mobileAssembly.GetType("System.Web.UI.MobileControls.MobilePage"); Type type2 = _mobileAssembly.GetType("System.Web.UI.MobileControls.MobileUserControl"); Type type3 = _mobileAssembly.GetType("System.Web.UI.MobileControls.Form"); page = (Page) Activator.CreateInstance(type); child = (UserControl) Activator.CreateInstance(type2); Control control2 = (Control) Activator.CreateInstance(type3); Type type4 = Type.GetType("Microsoft.Matrix.Packages.Web.Mobile.MobileDesignerHost, Microsoft.Matrix.Packages.Web.Mobile"); designerHost = (DesignerHost) Activator.CreateInstance(type4, new object[] { document }); document.Load(readOnly); Type type5 = Type.GetType("Microsoft.Matrix.Packages.Web.Mobile.MobileWebFormsDocumentWindow, Microsoft.Matrix.Packages.Web.Mobile"); documentWindow = (DocumentWindow) Activator.CreateInstance(type5, new object[] { designerHost, document, initialView }); page.Site = new AscxPageSite(designerHost, page); page.DesignerInitialize(); page.Controls.Add(control2); control2.Controls.Add(child); } else { _mobileAssemblyLoadFailed = true; } } if (_mobileAssemblyLoadFailed) { document.Dispose(); Document document2 = new TextDocument(projectItem); designerHost = new DesignerHost(document2); ((IMxUIService) designerHost.GetService(typeof(IMxUIService))).ReportError("Microsoft Mobile Internet Toolkit is required for design-time editing of mobile user controls.\r\nPlease visit 'http://www.asp.net/mobile/default.aspx' for more information.\r\nThe user control will be opened in the text editor instead.", "Mobile User Controls are not enabled.", true); document2.Load(readOnly); documentWindow = new TextDocumentWindow(designerHost, document2); return document2; } } IDesignerHost host = designerHost; host.Container.Add(child, "UserControl"); child.DesignerInitialize(); return document; }
protected void imgBtnExportarExcelHistoricoEjecucion_Click(object sender, ImageClickEventArgs e) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); gvHistoricoDeEjecucionJobs.AllowPaging = false; gvHistoricoDeEjecucionJobs.DataBind(); gvHistoricoDeEjecucionJobs.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(gvHistoricoDeEjecucionJobs); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=HistoricoEjecucionDeJobsPorRequerimiento" + DateTime.Now.ToShortDateString() + ".xls"); Response.Charset = "UTF-8"; //Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentEncoding = System.Text.Encoding.Default; Response.Write(sb.ToString()); Response.End(); }
/*Exportar a excel*/ protected void BtnExportarExcel_Click(object sender, EventArgs e) { //try //{ Response.Clear(); Response.Buffer = true; Response.ClearContent(); Response.ClearHeaders(); Response.Charset = ""; /* Sin error */ StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter htw = new HtmlTextWriter(sw); Page page = new Page(); HtmlForm form = new HtmlForm(); GridView dg5 = new GridView(); dg5.EnableViewState = false; //dg5.DataSource = CargarGrilla; dg5.AllowPaging = false; // dg5.Sort("referencia1", SortDirection.Ascending); DataTable dt5 = ((DataView)this.CargarGrilla.Select(DataSourceSelectArguments.Empty)).ToTable(); // your data table DataView dv = dt5.DefaultView; dv.Sort = "referencia1 desc"; DataTable sortedDT = dv.ToTable(); CompararDatatable(sortedDT); dg5.DataSource = sortedDT; dg5.DataBind(); compare(dg5); form.Controls.Add(GridView3); form.Controls.Add(dg5); /*form.Controls.Add(dg2); form.Controls.Add(dg3); form.Controls.Add(dg);*/ page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); page.RenderControl(htw); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; ///Response.ContentType = "text/plain"; Response.AddHeader("Content-Disposition", "attachment;filename=Archivocomparaciones.xls;"); Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.Default; Response.Write(sb.ToString()); Response.End(); GridView1.AllowPaging = true; GridView1.DataBind(); }