From 2f75b4c0a67ccc3a443e7cc4f2f0f909defd9a92 Mon Sep 17 00:00:00 2001
From: hutongqing <hutongqing@hnkhzn.com>
Date: 星期五, 01 十一月 2024 09:49:23 +0800
Subject: [PATCH] 版本更新
---
WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DeviceProtocolService.cs | 46 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 45 insertions(+), 1 deletions(-)
diff --git a/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DeviceProtocolService.cs b/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DeviceProtocolService.cs
index 0fab091..82c0830 100644
--- a/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DeviceProtocolService.cs
+++ b/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DeviceProtocolService.cs
@@ -15,14 +15,18 @@
*----------------------------------------------------------------*/
#endregion << 鐗� 鏈� 娉� 閲� >>
+using Magicodes.ExporterAndImporter.Core.Models;
+using Magicodes.ExporterAndImporter.Excel;
+using Microsoft.AspNetCore.Http;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
+using WIDESEAWCS_Core;
using WIDESEAWCS_Core.BaseRepository;
using WIDESEAWCS_Core.BaseServices;
-
+using WIDESEAWCS_Core.Helper;
using WIDESEAWCS_QuartzJob.Models;
using WIDESEAWCS_QuartzJob.Repository;
@@ -35,5 +39,45 @@
{
_unitOfWorkManage = unitOfWorkManage;
}
+
+ /// <summary>
+ /// 璇诲彇瀵煎叆鏂囦欢鐨勬暟鎹繑鍥炲埌鍓嶇
+ /// </summary>
+ /// <param name="fileInput">鏂囦欢</param>
+ /// <returns>杩斿洖璇诲彇缁撴灉锛屾垚鍔熻繑鍥炴暟鎹紝澶辫触杩斿洖閿欒淇℃伅</returns>
+ public WebResponseContent GetImportData(List<IFormFile> fileInput)
+ {
+ try
+ {
+ if (fileInput == null || fileInput.Count == 0)
+ return new WebResponseContent { Status = true, Message = "璇烽�夋嫨涓婁紶鐨勬枃浠�" };
+ Microsoft.AspNetCore.Http.IFormFile formFile = fileInput[0];
+ string dicPath = AppDomain.CurrentDomain.BaseDirectory + $"ExcelImprot/{DateTime.Now.ToString("yyyMMdd")}/{typeof(Dt_DeviceProtocol).Name}/";
+ if (!Directory.Exists(dicPath)) Directory.CreateDirectory(dicPath);
+ string fileName = $"{Guid.NewGuid()}_{formFile.FileName}";
+ dicPath = $"{dicPath}{fileName}";
+ using (FileStream stream = new FileStream(dicPath, FileMode.Create))
+ {
+ formFile.CopyTo(stream);
+ }
+ ExcelImporter importer = new ExcelImporter();
+ ImportResult<Dt_DeviceProtocol> importResult = importer.Import<Dt_DeviceProtocol>(dicPath, "").Result;
+ if (importResult.HasError)
+ {
+ return WebResponseContent.Instance.Error(importResult.TemplateErrors.Serialize());
+ }
+ return WebResponseContent.Instance.OK(data: importResult.Data);
+ }
+ catch (Exception ex)
+ {
+ return WebResponseContent.Instance.Error(ex.Message);
+ }
+ }
+
+ public override WebResponseContent AddData(SaveModel saveModel)
+ {
+ //saveModel.MainData[""]
+ return base.AddData(saveModel);
+ }
}
}
--
Gitblit v1.9.3