From aa391b0c42e561f198e9a9f91e32073500001193 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 09 十月 2023 20:17:04 +0800
Subject: [PATCH] 1.报工审核查询、审核提交接口 2.报工调整接口优化 3.统计报表：生产进度报表接口
---
VueWebCoreApi/Tools/DownLoad.cs | 21 +++++++++------------
1 files changed, 9 insertions(+), 12 deletions(-)
diff --git a/VueWebCoreApi/Tools/DownLoad.cs b/VueWebCoreApi/Tools/DownLoad.cs
index 66d159c..431fffa 100644
--- a/VueWebCoreApi/Tools/DownLoad.cs
+++ b/VueWebCoreApi/Tools/DownLoad.cs
@@ -1,4 +1,5 @@
-锘縰sing NPOI.HSSF.UserModel;
+锘縰sing Microsoft.AspNetCore.Hosting;
+using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;
@@ -27,7 +28,7 @@
{
var filename = filenName + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
string fileip = AppSetting.GetAppSetting("FileIP");
- var filepath = CoreHttpContext.MapPath("/File/newxls/");
+ var filepath = CoreHttpContext.MapPath("/newxls/");
var path = filepath + filename;
if (!Directory.Exists(filepath))
@@ -82,7 +83,7 @@
var b = DALSkillCondition.ResultExcel(path, dt);
if (b)
{
- var url = fileip + "/apis/File/newxls/" + filename;
+ var url = fileip + "/apis/newxls/" + filename;
return url;
}
var messge = filename + "涓嬭浇澶辫触";
@@ -100,7 +101,7 @@
{
string fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx";
string fileip = AppSetting.GetAppSetting("FileIP");
- string filePath = CoreHttpContext.MapPath("/File/newxls/");
+ string filePath = CoreHttpContext.MapPath("/newxls/");
Directory.CreateDirectory(filePath);
string Path = filePath + fileName;
@@ -172,7 +173,7 @@
using (fs = File.OpenWrite(Path))
{
workbook.Write(fs);
- var url = fileip + "/File/newxls/" + fileName;
+ var url = fileip + "/newxls/" + fileName;
return url;
}
}
@@ -193,7 +194,7 @@
{
string fileName = filenName + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx";
string fileip = AppSetting.GetAppSetting("FileIP");
- string filePath = CoreHttpContext.MapPath("/File/newxls/");
+ string filePath = CoreHttpContext.MapPath("wwwroot/newxls/");
Directory.CreateDirectory(filePath);
string Path = filePath + fileName;
@@ -226,13 +227,11 @@
for (var j = 0; j < ds.Columns.Count; j++)
{
sheet.SetColumnWidth(j, 30 * 256);//
- //sheet.AutoSizeColumn(j); //鑷�傚簲瀹藉害
+ //sheet.AutoSizeColumn(j); //鑷�傚簲瀹藉害
headerRow.CreateCell(j).SetCellValue(ds.Columns[j].ColumnName);
headerRow.GetCell(j).CellStyle = headStyle;
}
-
#endregion
-
rowIndex = 1;
}
@@ -258,12 +257,10 @@
rowIndex++;
}
-
-
using (fs = File.OpenWrite(Path))
{
workbook.Write(fs);
- var url = fileip + "/File/newxls/" + fileName;
+ var url = fileip + "/newxls/" + fileName;
return url;
}
}
--
Gitblit v1.9.3