| | |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Microsoft.AspNetCore.Hosting; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | |
| | | [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> |
| | |
| | | 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 |
| | | |
| | |
| | | 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") |