1.Startup.cs 文件中增加授权.apk文件 2.Excel下载方法中增加.net core直接下载wwwroot下的文件代码(暂时不用，先注释掉)

yl

2024-01-05 b7041949338728f4f8b7cc96f4ed6a92b40fda36

 VueWebCoreApi/Controllers/ImportExcelController.cs

@@ -1,4 +1,5 @@
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Data;
@@ -15,9 +16,15 @@
    [ApiExplorerSettings(GroupName = "Excel导入")]
    [ApiController]
    [Route("api/[controller]")]
    [ChannelActionFilter]
    //[ChannelActionFilter]
    public class ImportExcelController : Controller
    {
        private readonly IWebHostEnvironment _hostingEnvironment;

        public ImportExcelController(IWebHostEnvironment hostingEnvironment)
        {
            _hostingEnvironment = hostingEnvironment;
        }

        #region[Excel导入模板列表]
        /// <summary>
@@ -55,6 +62,33 @@
            mes.code = "200";
            mes.data = msg;
            return Json(mes);

            //ToMessage mes = new ToMessage();
            //List<ScoreReport> list = ExcelList.ExcelData();
            //list = list.Where(s => s.FileCode == FileCode).ToList();
            //var filename = list[0].FileName + ".xls";
            //var wwwRootPath = _hostingEnvironment.WebRootPath;
            //var fileDirectory = Path.Combine(wwwRootPath, "Excel"); // 替换为您的Excel文件所在目录
            //var filePath = Path.Combine(fileDirectory, $"{filename}.xlsx"); // 假设文件名编码为文件名

            //if (System.IO.File.Exists(filePath))
            //{
            //    var fileInfo = new FileInfo(filePath);
            //    var result = new
            //    {
            //        FileName = fileInfo.Name,
            //        FilePath = filePath,
            //        FileSize = fileInfo.Length
            //    };
            //    return Json(result);
            //}
            //else
            //{
            //    mes.code = "300";
            //    mes.data = "";
            //    mes.message = "文件不存在";
            //}
            //return Json(mes);
        }
        #endregion

@@ -119,7 +153,7 @@
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
                mes.message = e.Message;
            }
            return mes;
        }
@@ -145,7 +179,7 @@
            List<DataTable> dataTable = myModel.TableData;
            list = ExcelCheckBLL.ExcelCheckData(FileCode, dataTable, out StuCode, out message, out count);
            mes.code = StuCode;
            mes.Message = message;
            mes.message = message;
            mes.count = count;
            mes.data = list;
            return mes;
@@ -167,7 +201,8 @@
            ToMessage mes = new ToMessage();
            try
            {
                var token = HttpContext.Request.Headers["Token"].ToString();
                //var token = HttpContext.Request.Headers["Token"].ToString();
                var token = "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyY29kZSI6Ijk5OSIsInVzZXJuYW1lIjoi5rWL6K-V6LSm5Y-3Iiwic3RvcmdfY29kZSI6IlNDQjAxXzEiLCJzdG9yZ19uYW1lIjoi55Sf5Lqn5LiA6YOoIiwiaXNfc3lzdGVtX2FkbWluIjoiTiIsInJvbGVfY29kZSI6IlIyMzA4MjMwMiw5OTk5Iiwicm9sZV9kYXRhcGVybWlzc2lvbnMiOiIiLCJ1c2VydHlwZSI6IlBDIiwicmVkaXNrZXkiOiJOZXdNRVNMb2dpblVzZXJJRFBDOTk5IiwidGltZW91dCI6IjIwMjMtMTItMTVUMTc6MTg6MjEuMTQyMjc1MiswODowMCJ9.IPaJpspiHjk4Qh9keXNy8lJl1Scj87EnnksKd8Hnj8o";
                User us = JwtTools.Denocode(token.ToString());
                mes = ExcelCheckBLL.ExcelImportSubmit(FileCode, dataTable, us);
                if (mes.code == "300") 
@@ -179,7 +214,7 @@
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
                mes.message = e.Message;
            }
            return mes;
        }