FileManageController

using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using PT.BLL;
using PT.Common;
using PT.Model;
using PT.Web.Mvc.App_Start;

namespace PT.Web.Mvc.Controllers
{
    [LoginAuthorizationFilter]
    public class FileManageController : BaseController<FileManage, FileManage>
    {

        FileManageBll bll = new FileManageBll();

        private SessionHelper sessionHelper;

        private readonly IHostingEnvironment _hostingEnvironment;

        public FileManageController(IHostingEnvironment hostingEnvironment)
        {
            _hostingEnvironment = hostingEnvironment;
        }
        public IActionResult Index()
        {
            return View();
        }

        /// <summary>
        /// 上传文件
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public IActionResult UploadFile(FileManage t)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {

                sessionHelper = new SessionHelper(HttpContext.Session);
                UserList user = sessionHelper.GetUserInfoString();


                string msg = string.Empty;

                //LoggerHelper._.Info("1");
                HttpRequest request = Request;
                //string TargetID = request.Form["TargetID"];
                //string TargetTable = request.Form["TargetTable"];
                //string TargetField = request.Form["TargetField"];
                //string Remarks = request.Form["Remarks"];


                string webRootPath = _hostingEnvironment.WebRootPath;
                string contentRootPath = _hostingEnvironment.ContentRootPath;
                string uploadPath = contentRootPath + "\\FileManage\\" + t.TargetTable + "\\" + DateTime.Now.ToString("yyyyMMdd") + "\\";// Server.MapPath("~/FileManage/" + TargetTable + "/" + DateTime.Now.ToString("yyyyMMdd") + "/");
                var fileCollection = request.Form.Files;
                // 判断是否有文件
                if (fileCollection.Count > 0)
                {
                    //LoggerHelper._.Info("3");
                    // 获取文件
                    var httpPostedFile = fileCollection[0];
                    string fileExtension = Path.GetExtension(httpPostedFile.FileName);// 文件扩展名
                    //string fileName = Path.GetFileNameWithoutExtension(httpPostedFile.FileName);
                    string fileName = Guid.NewGuid().ToString() + fileExtension;// 名称

                    string filePath = uploadPath + fileName;// 上传路径

                    //LoggerHelper._.Info("5："+ filePath);
                    // 如果目录不存在则要先创建
                    if (!Directory.Exists(uploadPath))
                    {
                        Directory.CreateDirectory(uploadPath);
                    }
                    // 保存新的文件
                    while (System.IO.File.Exists(filePath))
                    {
                        fileName = Guid.NewGuid().ToString() + fileExtension;
                        filePath = uploadPath + fileName;
                    }

                    //httpPostedFile.SaveAs(filePath);

                    using (FileStream fs = System.IO.File.Create(filePath))
                    {
                        httpPostedFile.CopyTo(fs);
                        fs.Flush();
                    }

                    msg = "上传成功";


                    t.FileName = httpPostedFile.FileName;
                    t.FileGuidName = fileName;
                    t.FileSize = httpPostedFile.Length;
                    t.FilePath = filePath;
                    //fileManage.TargetId = TargetID;
                    //fileManage.TargetTable = TargetTable;
                    //fileManage.TargetField = TargetField;
                    //fileManage.Remark = Remarks;
                    t.IsDelete = false;
                    t.CreatBy = user.Id + "|" + user.UserID + "|" + user.UserName;
                    t.CreatDate = DateTime.Now;

                    result.msg = bll.InsertableIgnoreColumns(t).ToString();
                    result.data = t;

                }

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }


        /// <summary>
        /// 上传文件 不存文件管理表
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public IActionResult UploadFileNotSaveData(string TargetTable)
        {
            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };
            try
            {
                FileManage fileManage = new FileManage();

                HttpRequest request = Request;
                string webRootPath = _hostingEnvironment.WebRootPath;
                string contentRootPath = _hostingEnvironment.ContentRootPath;
                string uploadPath = contentRootPath + "\\FileManage\\" + TargetTable + "\\" + DateTime.Now.ToString("yyyyMMdd") + "\\";// Server.MapPath("~/FileManage/" + TargetTable + "/" + DateTime.Now.ToString("yyyyMMdd") + "/");
                var fileCollection = request.Form.Files;
                // 判断是否有文件
                if (fileCollection.Count > 0)
                {
                    //LoggerHelper._.Info("3");
                    // 获取文件
                    var httpPostedFile = fileCollection[0];
                    string fileExtension = Path.GetExtension(httpPostedFile.FileName);// 文件扩展名
                    //string fileName = Path.GetFileNameWithoutExtension(httpPostedFile.FileName);
                    string fileName = Guid.NewGuid().ToString() + fileExtension;// 名称

                    string filePath = uploadPath + fileName;// 上传路径

                    //LoggerHelper._.Info("5："+ filePath);
                    // 如果目录不存在则要先创建
                    if (!Directory.Exists(uploadPath))
                    {
                        Directory.CreateDirectory(uploadPath);
                    }
                    // 如果文件名已存在则生成新的文件名
                    while (System.IO.File.Exists(filePath))
                    {
                        fileName = Guid.NewGuid().ToString() + fileExtension;
                        filePath = uploadPath + fileName;
                    }
                    //保存
                    using (FileStream fs = System.IO.File.Create(filePath))
                    {
                        httpPostedFile.CopyTo(fs);
                        fs.Flush();
                    }

                    fileManage.FileName = httpPostedFile.FileName;
                    fileManage.FileGuidName = fileName;
                    fileManage.FileSize = httpPostedFile.Length;
                    fileManage.FilePath = filePath;
                    fileManage.TargetId = "";
                    fileManage.TargetTable = TargetTable;
                    fileManage.TargetField = "";
                    fileManage.Remark = "";
                    fileManage.IsDelete = false;
                    //fileManage.CreatBy = user.Id + "|" + user.UserID + "|" + user.UserName;
                    fileManage.CreatDate = DateTime.Now;

                    result.data = fileManage;
                }

            }
            catch (Exception ex)
            {

                result.code = -1;
                result.msg = ex.Message;
            }

            var res = new JsonResult(result);
            return res;

        }



        /// <summary>
        /// 导出 excel
        /// </summary>
        /// <returns></returns>
        public IActionResult ExportExcel2()
        {

            ResponseResult result = new ResponseResult()
            {
                code = 0,
                msg = "成功",
                data = 0

            };

            try
            {

                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn() { ColumnName = "AA" });
                dt.Columns.Add(new DataColumn() { ColumnName = "BB" });

                DataRow dr = dt.NewRow();
                dr[0] = "11";
                dr[1] = "22";
                dt.Rows.Add(dr);

                //string[] fileArr = file.Split(new char[] { '.' });
                string file = "测试" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";

                IWorkbook workbook;
                string fileExt = Path.GetExtension(file).ToLower();
                if (fileExt == ".xlsx") { workbook = new XSSFWorkbook(); } else if (fileExt == ".xls") { workbook = new HSSFWorkbook(); } else { workbook = null; }
                if (workbook == null) { return null; }

                ISheet sheet = string.IsNullOrEmpty(dt.TableName) ? workbook.CreateSheet("Sheet1") : workbook.CreateSheet(dt.TableName);

                //设置列宽
                //sheet.SetColumnWidth(0, 15 * 256);
                //sheet.SetColumnWidth(1, 15 * 256);
                //sheet.SetColumnWidth(2, 15 * 256);
                //sheet.SetColumnWidth(3, 15 * 256);
                //sheet.SetColumnWidth(4, 15 * 256);
                //sheet.SetColumnWidth(5, 25 * 256);
                //sheet.SetColumnWidth(6, 25 * 256);
                //sheet.SetColumnWidth(7, 30 * 256);
                //sheet.SetColumnWidth(8, 15 * 256);
                //sheet.SetColumnWidth(9, 15 * 256);
                //sheet.SetColumnWidth(10, 15 * 256);
                //sheet.SetColumnWidth(12, 15 * 256);

                //for (int i = 0; i < dt.Rows.Count; i++)
                //{
                //    sheet.SetColumnWidth(i, 20 * 256);
                //}


                //表头  
                IRow row = sheet.CreateRow(0);
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    ICell cell = row.CreateCell(i);
                    cell.SetCellValue(dt.Columns[i].ColumnName);
                }

                //HSSFPatriarch patriarch = (HSSFPatriarch)sheet.CreateDrawingPatriarch();
                ICellStyle style = workbook.CreateCellStyle();
                ICellStyle style2 = workbook.CreateCellStyle();
                string val = "";
                //数据  
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    IRow row1 = sheet.CreateRow(i + 1);
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        ICell cell = row1.CreateCell(j);

                        val = dt.Rows[i][j].ToString();

                        cell.SetCellValue(val);

                    }
                }



                //设置行高
                //HSSFCellStyle cellStyle = (HSSFCellStyle)workbook.CreateCellStyle();
                //IRow row2 = sheet.GetRow(2);
                //row2.HeightInPoints = 120;
                //row2.GetCell(2).CellStyle = cellStyle;





                //转为字节数组  
                MemoryStream stream = new MemoryStream();
                workbook.Write(stream, true);
                var buf = stream.ToArray();

                string webRootPath = _hostingEnvironment.WebRootPath + "\\Downloads\\";
                string Route = webRootPath;// @"C:\Downloads\";

                //如找不到文件夹则创建   
                if (!Directory.Exists(Route))
                {
                    Directory.CreateDirectory(Route);
                }


                //保存为Excel文件  
                using (FileStream fs = new FileStream(Route + file, FileMode.Create, FileAccess.Write))
                {
                    fs.Write(buf, 0, buf.Length);
                    fs.Flush();
                    fs.Close();
                    fs.Dispose();

                    result.data = file;
                }


                //xls
                //return File(stream, "application/application/vnd.ms-excel", $"{DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss")}");
                //xlsx


                /*
                 * 
                 * 前端调用
                 
                       $.ajax({
                    type: "Get",
                    url: "/FileManage/ExportExcel2",
                    async: true,
                    data: {},
                    success: function (data) {

                        window.open('/Downloads/' + data.data, '_blank');
                    }
                });

                 */

            }
            catch (Exception ex)
            {

                //LoggerHelper._.Error(ex.ToString());
            }


            var res = new JsonResult(result);
            return res;

        }



        /// <summary>
        /// 导出 excel
        /// </summary>
        /// <returns></returns>
        [HttpGet]
        public FileStreamResult ExportExcel()
        {

            try
            {

                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn() { ColumnName = "AA" });
                dt.Columns.Add(new DataColumn() { ColumnName = "BB" });

                DataRow dr = dt.NewRow();
                dr[0] = "11";
                dr[1] = "22";
                dt.Rows.Add(dr);

                //string[] fileArr = file.Split(new char[] { '.' });
                string file = "测试" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";

                IWorkbook workbook;
                string fileExt = Path.GetExtension(file).ToLower();
                if (fileExt == ".xlsx") { workbook = new XSSFWorkbook(); } else if (fileExt == ".xls") { workbook = new HSSFWorkbook(); } else { workbook = null; }
                if (workbook == null) { return null; }

                ISheet sheet = string.IsNullOrEmpty(dt.TableName) ? workbook.CreateSheet("Sheet1") : workbook.CreateSheet(dt.TableName);

                //设置列宽
                //sheet.SetColumnWidth(0, 15 * 256);
                //sheet.SetColumnWidth(1, 15 * 256);
                //sheet.SetColumnWidth(2, 15 * 256);
                //sheet.SetColumnWidth(3, 15 * 256);
                //sheet.SetColumnWidth(4, 15 * 256);
                //sheet.SetColumnWidth(5, 25 * 256);
                //sheet.SetColumnWidth(6, 25 * 256);
                //sheet.SetColumnWidth(7, 30 * 256);
                //sheet.SetColumnWidth(8, 15 * 256);
                //sheet.SetColumnWidth(9, 15 * 256);
                //sheet.SetColumnWidth(10, 15 * 256);
                //sheet.SetColumnWidth(12, 15 * 256);

                //for (int i = 0; i < dt.Rows.Count; i++)
                //{
                //    sheet.SetColumnWidth(i, 20 * 256);
                //}


                //表头  
                IRow row = sheet.CreateRow(0);
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    ICell cell = row.CreateCell(i);
                    cell.SetCellValue(dt.Columns[i].ColumnName);
                }

                //HSSFPatriarch patriarch = (HSSFPatriarch)sheet.CreateDrawingPatriarch();
                ICellStyle style = workbook.CreateCellStyle();
                ICellStyle style2 = workbook.CreateCellStyle();
                string val = "";
                //数据  
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    IRow row1 = sheet.CreateRow(i + 1);
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        ICell cell = row1.CreateCell(j);

                        val = dt.Rows[i][j].ToString();

                        cell.SetCellValue(val);

                    }
                }



                //设置行高
                //HSSFCellStyle cellStyle = (HSSFCellStyle)workbook.CreateCellStyle();
                //IRow row2 = sheet.GetRow(2);
                //row2.HeightInPoints = 120;
                //row2.GetCell(2).CellStyle = cellStyle;





                //转为字节数组  
                MemoryStream stream = new MemoryStream();
                workbook.Write(stream, true);
                var buf = stream.ToArray();

                string webRootPath = _hostingEnvironment.WebRootPath + "\\Downloads\\";
                string Route = webRootPath;// @"C:\Downloads\";

                //如找不到文件夹则创建   
                if (!Directory.Exists(Route))
                {
                    Directory.CreateDirectory(Route);
                }


                //保存为Excel文件  
                using (FileStream fs = new FileStream(Route + file, FileMode.Create, FileAccess.Write))
                {
                    fs.Write(buf, 0, buf.Length);
                    fs.Flush();
                    fs.Close();
                    fs.Dispose();
                }


                //xls
                //return File(stream, "application/application/vnd.ms-excel", $"{DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss")}");
                //xlsx
                return File(stream, "application/vnd.ms-excel", Route + file);



            }
            catch (Exception ex)
            {

                //LoggerHelper._.Error(ex.ToString());
            }

            return null;

        }

    }
}