protected void ASPxButton1_Click(object sender, EventArgs e) { MemoryStream memoryStream1 = new MemoryStream(); MemoryStream memoryStream2 = new MemoryStream(); MemoryStream memoryStream3 = new MemoryStream(); MemoryStream myZippedStream = new MemoryStream(); ASPxGridViewExporter1.WriteXlsx(memoryStream1); ASPxGridViewExporter2.WriteXlsx(memoryStream2); ASPxGridViewExporter3.WriteXlsx(memoryStream3); memoryStream1.Seek(0, SeekOrigin.Begin); memoryStream2.Seek(0, SeekOrigin.Begin); memoryStream3.Seek(0, SeekOrigin.Begin); using (ZipArchive archive = new ZipArchive()) { archive.AddStream("grid1.xlsx", memoryStream1); archive.AddStream("grid2.xlsx", memoryStream2); archive.AddStream("grid3.xlsx", memoryStream3); archive.Save(myZippedStream); } Response.Clear(); Response.ContentType = "application/zip"; Response.AddHeader("Content-Disposition", "attachment; filename=exportFiles.zip"); Response.AddHeader("Content-Length", myZippedStream.Length.ToString()); Response.BinaryWrite(myZippedStream.ToArray()); Response.Flush(); Response.Close(); Response.End(); }
protected void ASPxMenu2_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e) { try { switch (e.Item.Name) { case "btnReport": //ReportView(); //ASPxPopupControl2.ShowOnPageLoad = true; break; case "btnExcel": ASPxGridViewExporter2.WriteXlsxToResponse(); break; case "btnGraph": GetGraph(ASPxComboBox1.Value.ToString(), 1024, 780, "on_handVSdate"); break; } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
protected void UiMenuDetalle_ItemClick(object source, MenuItemEventArgs e) { try { switch (e.Item.Name) { case "btnExcel": ASPxGridViewExporter2.WriteXlsxToResponse(); break; case "btnReport": ReportViewDetalle(); ASPxPopupControl2.ShowOnPageLoad = true; break; case "btnBill": ValidarPickinFacturacion(); break; } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
protected void ASPxMenu2_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e) { ValidarConexionYUsuarioLogueado(new object()); switch (e.Item.Name) { case "btnExcel": ASPxGridViewExporter2.WriteXlsxToResponse(); break; } }
protected void btnXlsExport2_Click(object sender, EventArgs e) { string sql = Session["2800LINESIDE"].ToString(); DataTable dt = dc.GetTable(sql); ASPxGridView4.DataSource = dt; ASPxGridView4.DataBind(); ASPxGridViewExporter2.WriteXlsToResponse("线边物料清单" + DateTime.Now.ToString() + ".xls"); }
protected void btnXlsExport2_Click(object sender, EventArgs e) { ASPxGridViewExporter2.WriteXlsToResponse("按名称维护现场扫描零件信息导出"); }
protected void btnExportCoursesw_Click(object sender, EventArgs e) { ASPxGridViewExporter2.WriteRtfToResponse(); }
protected void btnExportCoursesx_Click(object sender, EventArgs e) { ASPxGridViewExporter2.WriteXlsToResponse(new XlsExportOptionsEx { ExportType = ExportType.WYSIWYG }); }
//导出物料清单 EXCEL protected void btnXlsExport_Click2(object sender, EventArgs e) { ASPxGridViewExporter2.WriteXlsToResponse("Plan_BOM_List"); }