1.报工审核查询、审核提交接口 2.报工调整接口优化 3.统计报表：生产进度报表接口

yl

2023-10-09 aa391b0c42e561f198e9a9f91e32073500001193

 VueWebCoreApi/Tools/DownLoad.cs

@@ -1,4 +1,5 @@
using NPOI.HSSF.UserModel;
using 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;
                }
            }