巨立Api
blame | 历史 | 补丁 | 提交 | 提交对比 | 显示空白
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;




@@ -230,9 +231,7 @@


                        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;


                }


            }