自述:在工作中遇到很多有趣的需求,在实施过程中看到了自己的很多不足。
仅在这里记录收获,积累成就感,愉悦自己,感谢他人!
// <summary>
/// 将数据部分处理生成excel 并打包成zip
/// </summary>
/// <param name="datas">数据列表</param>
public static void CreatZip(List<AmmeterProportionLogBll.AmmeterProportionLog_Aduit_Export> datas)
{
HttpContext curContext = HttpContext.Current;
curContext.Response.ContentType = "application/zip";
curContext.Response.ContentEncoding = Encoding.UTF8;
curContext.Response.Charset = "";
curContext.Response.AppendHeader("Content-Disposition",
"attachment;filename=" + HttpUtility.UrlEncode(DateTime.Now.ToString("yyyyMMddhhmmss") + ".zip", Encoding.UTF8));
//处理数据生成excel表 以K_V形式保存 Workbooks
Dictionary<string, HSSFWorkbook> Workbooks = new Dictionary<string, HSSFWorkbook>();
datas.ForEach(p => Workbooks.Add(p.txtAmmeterNum, Export0(p)));
//遍历Workbooks 生成zip文件
curContext.Response.BinaryWrite(PackageManyZip(Workbooks)<