C#文件处理（下载、导出）

using System;using System.Configuration;using System.IO;using Microsoft.Office.Interop.Excel;using TMS.IMEX.Extensions;using log4net;namespace TMS.IMEX{    public class IMEXExportBase    {        private static readonly ILog m_log = LogManager.GetLogger(typeof(IMEXExportBase));        #region 一览导出文件处理        /// <summary>        /// 一览导出文件处理        /// </summary>        /// <param name="dt"></param>        /// <param name="pathModuleFile"></param>        /// <param name="filePath"></param>        /// <param name="fileName"></param>        public bool ProcessGeneralExportFile(System.Data.DataTable dt, string pathModuleFile, string filePath, string fileName)        {            // 写日志            m_log.Debug("IMEXExportBase->ProcessGeneralExportFile Start");            try            {                int rows = dt.Rows.Count;                int cols = dt.Columns.Count;                string[,] dataArray = new string[rows,cols];                for (int i = 0; i < rows; i++)                {                    for (int j = 0; j < cols; j++)                    {                        dataArray[i, j] = dt.Rows[i][j].ToString();                    }                }                m_log.Debug("Application 实例化");                Application app = new Application();                m_log.Debug("Workbook 实例化");                Workbook book =                    (Workbook)                    app.Workbooks.Open(pathModuleFile, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                                       Type.Missing, Type.Missing,                                       Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                                       Type.Missing, Type.Missing, Type.Missing);                m_log.Debug("Worksheet 实例化");                Worksheet sheet = (Worksheet) book.Sheets[1];                m_log.Debug("sheet.Range 数据加载");                sheet.Range["A2", app.Cells[rows + 1, cols]].Value = dataArray;                // 如果路径不存在 创建路径                CreateDirectory(filePath);                string newfilePath = filePath +"\\"+ fileName;                //如果文件存在就删除文件                DeleteFile(newfilePath);                m_log.Debug("book._SaveAs Start");                book._SaveAs(newfilePath, XlFileFormat.xlWorkbookNormal, null, null, false, false,                             XlSaveAsAccessMode.xlNoChange, null, null, null, null);                m_log.Debug("book._SaveAs End");                //关闭Excel进程                book.Close(null, null, null);                System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);                System.Runtime.InteropServices.Marshal.ReleaseComObject(book);                app.Quit();                System.Runtime.InteropServices.Marshal.ReleaseComObject(app);                sheet = null;                book = null;                app = null;                GC.Collect();                return true;            }            catch (Exception ex)            {                m_log.Error("IMEXExportBase->ExportExcel" + ex.Message);                return false;            }            finally            {                // 写日志                m_log.Debug("IMEXExportBase->ProcessGeneralExportFile End");            }        }        #endregion        #region 创建工作目录        /// <summary>        /// 创建工作目录        /// </summary>        /// <param name="pathDir"></param>        /// <returns></returns>        public void CreateDirectory(string pathDir)        {            if (!Directory.Exists(pathDir))            {                Directory.CreateDirectory(pathDir);            }        }        #endregion        #region 删除文件        /// <summary>        /// 删除文件        /// </summary>        /// <param name="filePath"></param>        /// <returns></returns>        public void DeleteFile(string filePath)        {            if (!string.IsNullOrEmpty(filePath)&&File.Exists(filePath))                    File.Delete(filePath);        }        #endregion    }}

下载文件

        #region 模板导出        /// <summary>        /// 模板导出        /// </summary>        /// <returns></returns>        public FileStreamResult TemplateExport()        {            m_log.Debug("RCV0060Controller->TemplateExport Start");            try            {                string phyPath = ConfigurationSettings.AppSettings[IMEXConfig.IMMAWBQuoteTemplatePath];                string absoluFilePath = Server.MapPath(phyPath);                return File(new FileStream(absoluFilePath, FileMode.Open, FileAccess.Read), "application/octet-stream",                            Server.UrlEncode("MAWB报价导入模板.xlsx"));            }            catch (Exception ex)            {                m_log.Error("RCV0060Controller->TemplateExport Error:", ex);                throw;            }            finally            {                m_log.Debug("RCV0060Controller->TemplateExport End");            }        }        #endregion