• .net 批量导出文件,以ZIP压缩方式导出


     1. 首先Nuget          ICSharpCode.SharpZipLib

        <script type="text/javascript">
            $(function () {
                $("#OutPutLink").click(function () {    // 单击下文件时
                    $.ajax({         // 先判断条件时间内没有文件
                        url: "/Home/ExistsFile?statTime=" + $("#statTime").val() + "&endTime=" + $("#endTime").val(),
                        type: "Get",
                        success: function (data) {
                            if (data == "Exists") {    // 如果有   就下载
                                window.location.href = "/Home/OutputFile?statTime=" + $("#statTime").val() + "&endTime=" + $("#endTime").val();
                            }
                            else
                                alert("该时间区域内无文件");
                        }
                    });
                });
            });
        </script>
    /// <summary>
            /// 验证该时间段是否有文件
            /// </summary>
            /// <param name="statTime">开始时间</param>
            /// <param name="endTime">结束时间</param>
            /// <returns></returns>
            public string ExistsFile(DateTime statTime, DateTime endTime)
            {
                DateTime sTime = DateTime.Parse(statTime.ToString("yyyy-MM-dd") + " 00:00:00");
                DateTime eTime = DateTime.Parse(endTime.ToString("yyyy-MM-dd") + " 23:59:59");
                DirectoryInfo TheFolder = new DirectoryInfo(Server.MapPath("~/Content/ExcelFile"));
                //遍历文件夹下的文件
                List<string> listFJName = new List<string>();//保存附件名字
                foreach (FileInfo NextFile in TheFolder.GetFiles())
                {
                    string fileType = Path.GetExtension(NextFile.FullName).ToString().ToLower();
                    if (fileType == ".xls" || fileType == ".xlsx")
                    {
                        string fileDate = NextFile.Name.Substring(0, 8);
                        DateTime dtime = DateTime.ParseExact(fileDate, "yyyyMMdd", null);
                        if (dtime >= sTime && dtime <= eTime)
                        {
                            listFJName.Add(NextFile.Name);
                        }
                    }
                }
                if (listFJName.Count > 0)
                    return "Exists";
                return "NotExists";
            }
    
            /// <summary>
            /// 执行将文件压缩下载
            /// </summary>
            /// <param name="statTime"></param>
            /// <param name="endTime"></param>
            public void OutputFile(DateTime statTime,DateTime endTime)
            {
                DateTime sTime = DateTime.Parse(statTime.ToString("yyyy-MM-dd") + " 00:00:00");
                DateTime eTime = DateTime.Parse(endTime.ToString("yyyy-MM-dd") + " 23:59:59");
                DirectoryInfo TheFolder = new DirectoryInfo(Server.MapPath("~/Content/ExcelFile"));
                //遍历文件夹下的文件
                List<string> listFJ = new List<string>();//保存附件路径
                List<string> listFJName = new List<string>();//保存附件名字
                foreach (FileInfo NextFile in TheFolder.GetFiles())
                {
                    string fileType = Path.GetExtension(NextFile.FullName).ToString().ToLower();
                    if (fileType == ".xls" || fileType == ".xlsx")
                    {
                        string fileDate = NextFile.Name.Substring(0, 8);
                        DateTime dtime = DateTime.ParseExact(fileDate, "yyyyMMdd", null);
                        if (dtime >= sTime && dtime <= eTime)
                        {
                            listFJ.Add(Server.MapPath("~/Content/ExcelFile/") + NextFile.Name);
                            listFJName.Add(NextFile.Name);
                        }
                    }
                }
                if (listFJ.Count > 0 && listFJName.Count > 0)
                {
                    string time = DateTime.Now.Ticks.ToString();
                    ZipFileMain(listFJ.ToArray(), listFJName.ToArray(), Server.MapPath("~/Content/ExcelFile/" + time + ".zip"), 9);//压缩文件
                    DownloadFile(Server.UrlEncode("附件.zip"), Server.MapPath("~/Content/ExcelFile/" + time + ".zip"));//下载文件
                }
            }
           
            /// <summary>
            /// 下载文件
            /// </summary>
            /// <param name="fileName"></param>
            /// <param name="filePath"></param>
            private void DownloadFile(string fileName, string filePath)
            {
                FileInfo fileInfo = new FileInfo(filePath);
                Response.Clear();
                Response.ClearContent();
                Response.ClearHeaders();
                Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);
                Response.AddHeader("Content-Length", fileInfo.Length.ToString());
                Response.AddHeader("Content-Transfer-Encoding", "binary");
                Response.ContentType = "application/octet-stream";
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
                Response.WriteFile(fileInfo.FullName);
                Response.Flush();
                System.IO.File.Delete(filePath);//删除已下载文件
                Response.End();
            }
    
            /// <summary>
            /// 压缩文件
            /// </summary>
            /// <param name="fileName">要压缩的所有文件(完全路径)</param>
            /// <param name="fileName">文件名称</param>
            /// <param name="name">压缩后文件路径</param>
            /// <param name="Level">压缩级别</param>
            public void ZipFileMain(string[] filenames, string[] fileName, string name, int Level)
            {
                ZipOutputStream s = new ZipOutputStream(System.IO.File.Create(name));
                Crc32 crc = new Crc32();
                //压缩级别
                s.SetLevel(Level); // 0 - store only to 9 - means best compression
                try
                {
                    int m = 0;
                    foreach (string file in filenames)
                    {
                        //打开压缩文件
                        FileStream fs = System.IO.File.OpenRead(file);//文件地址
                        byte[] buffer = new byte[fs.Length];
                        fs.Read(buffer, 0, buffer.Length);
                        //建立压缩实体
                        ZipEntry entry = new ZipEntry(fileName[m].ToString());//原文件名
                                                                              //时间
                        entry.DateTime = DateTime.Now;
                        //空间大小
                        entry.Size = fs.Length;
                        fs.Close();
                        crc.Reset();
                        crc.Update(buffer);
                        entry.Crc = crc.Value;
                        s.PutNextEntry(entry);
                        s.Write(buffer, 0, buffer.Length);
                        m++;
                    }
                }
                catch
                {
                    throw;
                }
                finally
                {
                    s.Finish();
                    s.Close();
                }
            }
  • 相关阅读:
    UVA247 电话圈 Calling Circles
    Python开发之路
    Day 8-模块
    Homework
    Day 7- 装饰器
    Day 6-文件操作的其他方法 迭代器 生成器
    数据-进制
    Day 5-变量与高阶函数
    Day 4-集合、百分号拼接及函数
    Day 3-Python列表、元祖、词典
  • 原文地址:https://www.cnblogs.com/yingger/p/11423961.html
Copyright © 2020-2023  润新知