接到一个需求,需要将图片及其他数据信息存储到txt文件下并根据上传时间分别打包到文件夹内。
需要打包的数据:Img1,img2,updatetime,carcode,address
分析:首先,创建一级文件夹:firstFile,创建二级文件夹:secondFile.
其次,将carcode,address数据存储到txt文本内
第三,将txt文本和img1、img2分别存储到secondFile文件夹
第四,压缩文件并下载
第五,删除压缩包及创建的文件夹
结果:程序根目录下的Download文件夹内,
代码:
创建一级文件夹FirstFile public string FirstCreate(string dt) { string path = @System.AppDomain.CurrentDomain.BaseDirectory + @"Download/记录_" + dt; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } return path; }
创建二级文件夹 secondFile public string SecondCreate(string path,string vdt, string CarNo) { string dt = DateTime.Now.ToString("yyyyMMddHHmmss"); vdt = DateTime.Parse(vdt).ToString("yyyyMMddHHmmss"); string filname = path + "\" + vdt + "_" + CarNo; if (!Directory.Exists(filname)) { Directory.CreateDirectory(filname); } return filname; }
将数据存入到txt文件中 public bool txtData(string path, string bianhao, string carcode, string carcolor, string cartype, string codecolor, string violationtime, string violationaddr, string x, string y) { string filename = path + "\" + carcode + ".txt";//这是地址 string Text = "编号:" + bianhao + " " +"车辆牌号:" + carcode + " " +"地点:" + violationaddr ; FileStream fs = new FileStream(filename, FileMode.Create); StreamWriter sw = new StreamWriter(fs, Encoding.Unicode); sw.Write(Text); sw.Close(); fs.Close(); return true; }
图片在数据库中存储的未URL,所以需要根据图片地址下载图片到本地磁盘
/// <summary> /// 从图片地址下载图片到本地磁盘 /// </summary> /// <param name="ToLocalPath">图片本地磁盘地址</param> /// <param name="Url">图片网址</param> /// <returns></returns> public bool SavePhotoFromUrl(string FileName, string Url) { bool Value = false; WebResponse response = null; Stream stream = null; try { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Url); response = request.GetResponse(); stream = response.GetResponseStream(); if (!response.ContentType.ToLower().StartsWith("text/")) { Value = SaveBinaryFile(response, FileName); } //stream.Close(); } catch (Exception err) { string aa = err.ToString(); } return Value; } /// <summary> /// Save a binary file to disk. /// </summary> /// <param name="response">The response used to save the file</param> // 将二进制文件保存到磁盘 private static bool SaveBinaryFile(WebResponse response, string FileName) { bool Value = true; byte[] buffer = new byte[1024]; try { //if (File.Exists(FileName)) // File.Delete(FileName); //Stream outStream = System.IO.File.Create(FileName+"\"+ carcode+".jpg"); Stream outStream = System.IO.File.Create(FileName); Stream inStream = response.GetResponseStream(); int l; do { l = inStream.Read(buffer, 0, buffer.Length); if (l > 0) outStream.Write(buffer, 0, l); } while (l > 0); //outStream.Flush(); outStream.Close(); //inStream.Flush(); inStream.Close(); } catch { Value = false; } return Value; }
压缩文件
此处需要引用:
using ICSharpCode.SharpZipLib.Zip;
using ICSharpCode.SharpZipLib.Checksums;
/// <summary> /// 压缩文件 /// </summary> /// <param name="sourceFilePath">待拷贝文件或文件夹 绝对路径</param> /// <param name="destinationZipFilePath"> 生成zip文件的绝对路径 </param> public void CreateZip(string sourceFilePath, string destinationZipFilePath) { if (sourceFilePath[sourceFilePath.Length - 1] != Path.DirectorySeparatorChar) sourceFilePath += Path.DirectorySeparatorChar; ZipOutputStream zipStream = new ZipOutputStream(File.Create(destinationZipFilePath)); zipStream.SetLevel(6); // 压缩级别 0-9 CreateZipFiles(sourceFilePath, zipStream, sourceFilePath); zipStream.Finish(); zipStream.Close(); } /// <summary> /// 递归压缩文件 /// </summary> /// <param name="sourceFilePath">待压缩的文件或文件夹路径</param> /// <param name="zipStream">打包结果的zip文件路径(类似 D:WorkSpacea.zip),全路径包括文件名和.zip扩展名</param> /// <param name="staticFile"></param> public void CreateZipFiles(string sourceFilePath, ZipOutputStream zipStream, string staticFile) { if (sourceFilePath[sourceFilePath.Length - 1] != Path.DirectorySeparatorChar) sourceFilePath += Path.DirectorySeparatorChar; Crc32 crc = new Crc32(); string[] filesArray = Directory.GetFileSystemEntries(sourceFilePath); foreach (string file in filesArray) { if (Directory.Exists(file)) //如果当前是文件夹,递归 { CreateZipFiles(file, zipStream, staticFile); } else//如果是文件,开始压缩 { FileStream fileStream = File.OpenRead(file); byte[] buffer = new byte[fileStream.Length]; fileStream.Read(buffer, 0, buffer.Length); string tempFile = file.Substring(staticFile.LastIndexOf("\") + 1); ZipEntry entry = new ZipEntry(tempFile); entry.DateTime = DateTime.Now; entry.Size = fileStream.Length; fileStream.Close(); crc.Reset(); crc.Update(buffer); entry.Crc = crc.Value; zipStream.PutNextEntry(entry); zipStream.Write(buffer, 0, buffer.Length); //zipStream.Flush(); //zipStream.Close(); } } }
下载文件(在控制器中写) public void OutPutZipFile(HttpContext context, string fileName) { //客户端保存的文件名 string zipname = fileName; //目标文件路径 string filePath = Server.MapPath("~/Download/" + fileName + ""); //Console.WriteLine(filePath); FileInfo fileInfo = new FileInfo(filePath); Response.Clear(); Response.ClearContent(); Response.ClearHeaders();// "attachment;filename=" + HttpUtility.UrlEncode(Encoding.GetEncoding(65001).GetBytes(name)) Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(Encoding.GetEncoding(65001).GetBytes(zipname))); Response.AddHeader("Content-Length", fileInfo.Length.ToString()); Response.AddHeader("Content-Range", "bytes 0-" + (fileInfo.Length - 1) + "/" + fileInfo.Length); Response.AddHeader("Content-Transfer-Encoding", "binary"); Response.ContentType = "application/octet-stream"; Response.ContentEncoding = Encoding.GetEncoding("gb2312"); Response.Flush(); //文件发送到客户端 Response.WriteFile(fileInfo.FullName); Response.End(); Response.Close(); //string zipName = "违法停车.zip"; //string filePath = Server.MapPath("~/Download/" + fileName + ""); ////string filePath = Base_Dir + "\" + fileName; //FileStream fs = new FileStream(filePath, FileMode.Open);//使用字节流的方式打开 //byte[] bytes = new byte[(int)fs.Length]; //fs.Read(bytes, 0, bytes.Length); //fs.Close(); //Response.ContentType = "application/octet-stream"; //Response.AddHeader("Title", fileName); ////通知浏览器下载文件而不是打开 //Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(zipName, System.Text.Encoding.UTF8)); //Response.BinaryWrite(bytes); //Response.Flush(); //Response.End(); }
删除文件,此处有些麻烦,会有更好的解决方式
//删除文件夹 public void DelectDir(string srcPath) { if (File.Exists(srcPath)) { // 2、根据路径字符串判断是文件还是文件夹 FileAttributes attr = File.GetAttributes(srcPath); // 3、根据具体类型进行删除 if (attr == FileAttributes.Directory) { // 3.1、删除文件夹 Directory.Delete(srcPath, true); } else { // 3.2、删除文件 File.Delete(srcPath); } File.Delete(srcPath); } } //删除download文件夹下的所有子文件,删除zip文件 public void DeleteDir(string file) { try { //去除文件夹和子文件的只读属性 //去除文件夹的只读属性 DirectoryInfo fileInfo = new DirectoryInfo(file); fileInfo.Attributes = FileAttributes.Normal & FileAttributes.Directory; //去除文件的只读属性 File.SetAttributes(file, FileAttributes.Normal); //判断文件夹是否还存在 if (Directory.Exists(file)) { foreach (string f in Directory.GetFileSystemEntries(file)) { if (File.Exists(f)) { //如果有子文件删除文件 File.Delete(f); Console.WriteLine(f); } else { //循环递归删除子文件夹 DeleteDir(f); } } //删除空文件夹 Directory.Delete(file); } } catch (Exception ex) // 异常处理 { Console.WriteLine(ex.Message.ToString());// 异常信息 } }
代码调用
using System.Data;
using System.Text;
using System.IO;
using System.Text;
using System.Web;
获取需要打包的数据
DataTable table = new DataTable();
string str="select img1,img2,carcode,address,updatetime from table";
table = this.BaseRepository().FindTable(str.ToString());
//创建一级菜单,目录为~Download/记录_202107300902
string dt = DateTime.Now.ToString("yyyyMMddHHmmss");
string firstPath = df.FirstCreate(dt);
foreach (DataRow dr in table.Rows)
{
string carcode = dr["carcode"].ToString();
string carcode = dr["address"].ToString();
string carcode = dr["img1"].ToString();
string carcode = dr["img2"].ToString();
//创建二级菜单,并将url地址图片存放到二级菜单中
string TheFolder = df.SecondCreate(firstPath, updatetime, carcode);
//图片地址
string Img1 = TheFolder + "\" + carcode + "_1.jpg";
string Img2 = TheFolder + "\" + carcode + "_2.jpg";
//图片下载到子文件夹中
SavePhotoFromUrl(Img1, img1Url);
SavePhotoFromUrl(Img2, img2Url);
//将其他数据存储到txt文件中
txtData(TheFolder,carcode,address,updatetime);
}
//待压缩的文件或文件夹路径路径+文件名称
string ZipFilePath = @System.AppDomain.CurrentDomain.BaseDirectory + @"Download /记录_" + FirstFileName + ".zip";
CreateZip(firstPath, ZipFilePath);
//下载文件
this.OutPutZipFile(Request.RequestContext.HttpContext.ApplicationInstance.Context, zipName);//调用方式
//删除文件
string destFilePath = @System.AppDomain.CurrentDomain.BaseDirectory + @"Download/记录_" + FirstFileName ;
DeleteDir(destFilePath);
string Path = @System.AppDomain.CurrentDomain.BaseDirectory + @"Download/记录_" + FirstFileName + ".zip";
DelectDir(Path);
注意:
1、添加引用CSharpCode.SharpZipLib.dll ,此处引用的版本为:0.85.4.369。
引用0.85.4.369版本的dll从服务器上下载解压没有问题,但是添加了0.86.0.518版本,从服务器上下载下来后解压提示图片文件头损坏。【此处巨坑。。。。。。】
添加引用的方式(vs2017):
工具——NuGet包管理器——管理解决方案的NuGet程序包
2、添加后,运行代码,可能会报出【未能加载文件或程序集“ICSharpCode.SharpZipLib”或它的某一个依赖项】这种错误,
解决方式:将ICSharpCode.SharpZipLib.dll 复制到web下的bin下面即可。