• 打包成zip


    protected void btnExportZip_Click(object sender,EventArgs e)

    {

    string archiveName=String.Format("zip文件名{0}-{1}.zip",CurrentUser.DepartmentName,DateTime.Now.ToString("yyyy-MM-dd");

    Resoponse.CotentType="application/zip";

    Response.AddHeader("content-disposition","attachment;filename=""+HttpUtility.UrlEncode(archiveName,Encoding.UTF8)+""");

    var docHelper=new DocHelper();

    var template=Server.MapPath("~/Template/export/template.doc");//模板

    var streamList=new List<MemoryStream>();

    //数据源赋值

    using(var zip=new ZipFile(Encoding.UTF8))

    {

    foreach(var proposal in proposaList)

    {

    var newDs=new Dataset();

    var dt1=ListExtend.ListToDataTable(new List<Proposal>(){proposal});// T转换为datatable

    dt1.TableName="table";

    newDs.Tables.add(dt1);

    //关联建议人 把建议人数据放入提案数据的尾部

    var suggesterList=ProposerService.GetListByProposalId(proposal.Id);

    var dtSuggester=ListExtend.ListToDataTable(suggesterList);

    dtSuggester.TableName="Proposer";

    newDs.Table.Add(dtSuggester);

    newDs.Relations.Add("ProposalWithProposer",dt1.Columns["Id"],dtSuggester.Colums["ProposalId"]);

    docHelper.DataSetList=new List<DataSet>(){newDs};

    var fileName=string.Format("{0}-{1}-政协提案交办全文.doc",proposal.Num,proposal.Title);

    var stream=docHelper.ExportStream(template);

    stream.Seek(0,SeekOrigin.Begin);

    zip.AddEntry(fileName,stream);

    streamList.Add(stream);

    }

    zip.save(Response.OutputStream);

    foreach(var memoryStream in streamList)

    {

    memoryStream.Close();

    }

    }

    }

  • 相关阅读:
    聊聊、最新 IDEA 2019.3.3 版本 注册码 有效期 2089
    聊聊、Spring自动扫描器
    聊聊、JVM 第一篇
    聊聊、AES 和 DES
    聊聊、Spring WebApplicationInitializer
    聊聊、Java SPI
    聊聊、Spring ServletContainerInitializer
    《Redis
    《Redis
    《Redis
  • 原文地址:https://www.cnblogs.com/sunzgod/p/4343725.html
Copyright © 2020-2023  润新知