1

hutongqing

2025-01-02 8c6fd742db249ad4cc819cf041eb98d880a3ef73

 WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DeviceProtocolService.cs

@@ -32,9 +32,16 @@

namespace WIDESEAWCS_QuartzJob.Service
{
    /// <summary>
    /// 设备协议信息业务层
    /// </summary>
    public class DeviceProtocolService : ServiceBase<Dt_DeviceProtocol, IDeviceProtocolRepository>, IDeviceProtocolService
    {
        private readonly IUnitOfWorkManage _unitOfWorkManage;

        /// <summary>
        /// 设备协议信息业务层
        /// </summary>
        public DeviceProtocolService(IDeviceProtocolRepository BaseDal, IUnitOfWorkManage unitOfWorkManage) : base(BaseDal)
        {
            _unitOfWorkManage = unitOfWorkManage;
@@ -49,31 +56,49 @@
        {
            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);
                }
                // 创建Excel导入器
                ExcelImporter importer = new ExcelImporter();
                // 导入Excel文件
                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);
            }
        }

        /// <summary>
        /// 添加数据
        /// </summary>
        /// <param name="saveModel"></param>
        /// <returns></returns>
        public override WebResponseContent AddData(SaveModel saveModel)
        {
            //saveModel.MainData[""]