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