everlight.eap/backend/DllEapDal/OFILM/MacOrderDescDal.cs

using DllEapCommon.NPOI;
using DllEapEntity.Dtos;
using DllEapEntity.OFILM;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DllEapDal.OFILM
{
    /// <summary>
    /// 获取指令描述
    /// </summary>
    public class MacOrderDescDal
    {
        /// <summary>
        /// 获取指令描述
        /// </summary>
        /// <param name="order"></param>
        /// <returns></returns>
        public async Task<LayuiModel<MacOrderDescDto>> Get(string order, string filePath)
        {
            string errorinfo = string.Empty;
            var helper = new DataImportHelper();
            var fs = new FileStream(filePath, FileMode.Open);
            var ext = Path.GetExtension(filePath);
            var dt = helper.GetImportData(fs, ext, 0, 0, ref errorinfo);
            var list = new List<MacOrderDescDto>();
            foreach (DataRow item in dt.Rows)
            {
                var entity = new MacOrderDescDto();
                entity.SendOrder = item["发送指令"].ToString();
                entity.SendEnDesc = item["发送指令英文描述"].ToString();
                entity.SendChDesc = item["发送指令翻译"].ToString();
                entity.ReceiveOrder = item["返回指令"].ToString();
                entity.ReceiveEnDesc = item["返回指令英文描述"].ToString();
                entity.ReceiveChDesc = item["返回指令翻译"].ToString();
                list.Add(entity);
            }
            if (!string.IsNullOrEmpty(order))
            {
                list = list.Where(c => c.SendOrder.Contains(order) || c.ReceiveOrder.Contains(order))
                    .ToList();
            }
            await Task.CompletedTask;
            return new LayuiModel<MacOrderDescDto>
            {
                count = list.Count,
                data = list
            };
        }
    }
}