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