using Microsoft.AspNetCore.Mvc;
|
using System;
|
using System.Collections.Generic;
|
using System.IO;
|
using System.Linq;
|
using System.Threading.Tasks;
|
using VueWebCoreApi.Tools;
|
|
namespace VueWebCoreApi.Controllers
|
{
|
[ApiExplorerSettings(GroupName = "Excel导入")]
|
[ApiController]
|
[Route("api/[controller]")]
|
//[ChannelActionFilter]
|
public class ImportExcelController : Controller
|
{
|
//定义全局信息返回变量
|
ToMessage mes = new ToMessage();
|
|
#region[Excel导入模板列表]
|
/// <summary>
|
/// Excel导入模板列表
|
/// </summary>
|
/// <returns></returns>
|
[Route(template: "ExcelModelData")]
|
[HttpGet]
|
public JsonResult ExcelModelData()
|
{
|
List<ScoreReport> list = ExcelList.ExcelData();
|
mes.code = "200";
|
mes.data = list;
|
return Json(mes);
|
}
|
#endregion
|
|
#region [Excel导入模板下载]
|
/// <summary>
|
/// Excel导入模板下载
|
/// </summary>
|
/// <param name="FileCode"></param>
|
/// <returns></returns>
|
[Route(template: "DownLoadExcel")]
|
[HttpGet]
|
public JsonResult DownLoadExcel(string FileCode = null)
|
{
|
List<ScoreReport> list = ExcelList.ExcelData();
|
list = list.Where(s => s.FileCode == FileCode).ToList();
|
var filename = list[0].FileName + ".xls";
|
string fileip = AppSetting.GetAppSetting("FileIP");
|
var msg = fileip + "/Excel/" + filename;
|
mes.code = "200";
|
mes.data = msg;
|
return Json(mes);
|
}
|
#endregion
|
}
|
}
|
