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 btnXlsExport3_Click(object sender, EventArgs e)
{
string sql = Session["2800COMPARE"].ToString();
DataTable dt = dc.GetTable(sql);
ASPxGridView5.DataSource = dt;
ASPxGridView5.DataBind();
ASPxGridViewExporter3.WriteXlsToResponse("在制品物料清单导出" + DateTime.Now.ToString() + ".xls");
}
protected void btnXlsExport3_Click(object sender, EventArgs e)
{
ASPxGridViewExporter3.WriteXlsToResponse("统计工位漏扫导出");
}
//导出分配流水号 EXCEL
protected void btnXlsExport_Click3(object sender, EventArgs e)
{
ASPxGridViewExporter3.WriteXlsToResponse("SN_List");
}
