XdCxRhDW/XdCxRhDW.X2D1TaskServer/Service/HistoryTaskService.cs

using DevExpress.Utils.Extensions;
using MySqlX.XDevAPI.Common;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using XdCxRhDW.Dto;

namespace XdCxRhDW.X2D1TaskServer.Service
{
    public class HistoryTaskService
    {
        private readonly string baseUrl;
        CancellationTokenSource cts;
        public HistoryTaskService()
        {
            var posPlatformAddr = ConfigurationManager.AppSettings["PosPlatformAddr"].Trim();//like http://127.0.0.1:8091 or http://127.0.0.1:8091/
            if (posPlatformAddr.EndsWith("/"))
                this.baseUrl = posPlatformAddr + "api/";
            else
                this.baseUrl = posPlatformAddr + "/api/";
        }
        public void StartAsync(X2D1HistoryTaskHandleDto dto)
        {
            cts = new CancellationTokenSource();
            if (!Directory.Exists(dto.CapDir))
            {
                StopTask(dto.ID, $"文件路径[{dto.CapDir}]不存在,任务结束");
                return;
            }
            LogHelper.Info($"【任务{dto.ID}】开始执行...");
            bool canConnected = CanGetSatIdFromMySql();
            if (!canConnected)
            {
                LogHelper.Warning("无法连接MySql查询卫星编号,将使用任务中提供的卫星");
            }
            //点击定位平台右上角查看接口可以在浏览器中查看平台提供的所有接口详细信息
            Task.Run(async () =>
            {
                DateTime preTime = dto.StartTime;
                int formatFlag;
                if (string.IsNullOrWhiteSpace(dto.DateDirFormat))
                {
                    //没有日期目录,处理完目录中的数据后停止任务
                    formatFlag = 0;
                }
                else if (dto.DateDirFormat.ToLower().EndsWith("dd"))
                {
                    //处理完一个目录后跳转到第二天的目录
                    formatFlag = 1;
                }
                else if (dto.DateDirFormat.ToUpper().EndsWith("HH"))
                {
                    //处理完一个目录后跳转到下一个小时的目录
                    formatFlag = 2;
                }
                else
                {
                    StopTask(dto.ID, $"执行异常,不支持的日期目录格式");
                    return;
                }
                while (!cts.IsCancellationRequested && preTime <= dto.EndTime)
                {
                    string filesDir = dto.CapDir;
                    try
                    {

                        if (formatFlag != 0)
                        {
                            filesDir = Path.Combine(dto.CapDir, $"{preTime.ToString(dto.DateDirFormat)}");//yyyyMMdd
                        }
                        LogHelper.Info($"【任务{dto.ID}】正在处理[{filesDir}]目录中的数据...");
                        IEnumerable<string> files;
                        if (!Directory.Exists(filesDir))
                        {
                            LogHelper.Info($"【任务{dto.ID}】目录[{filesDir}]不存在,跳过此目录");
                            ResetTime(formatFlag, ref preTime);
                            continue;
                        }
                        files = Directory.EnumerateFiles(filesDir, "*.dat");
                        if (!files.Any())
                        {
                            LogHelper.Info($"【任务{dto.ID}】目录[{filesDir}]中没有文件,跳过此目录");
                            ResetTime(formatFlag, ref preTime);
                            continue;
                        }

                        IOrderedEnumerable<IGrouping<DateTime, HistoryFile>> groups = null;
                        groups = files.Select(f => FileToHistoryFile(dto, f, canConnected)).GroupBy(m => m.CapTime).OrderBy(m => m.Key);
                        foreach (var item in groups)
                        {
                            if (cts.IsCancellationRequested) break;
                            var finfos = item.ToList();
                            var capTime = finfos.First().CapTime;
                            if (capTime < dto.StartTime) continue;
                            if (capTime > dto.EndTime) break;
                            if (finfos.Count < 3)
                            {
                                LogHelper.Warning($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻文件数量只有{finfos.Count}个,跳过此组数据");
                                continue;
                            }
                            //超短波信号
                            var dinfo = finfos.FirstOrDefault(m => m.Ch == 1);
                            if (dinfo == null)
                            {
                                LogHelper.Warning($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻未找到超短波信号ch1文件,跳过此组数据");
                                continue;
                            }
                            //主星
                            var minfo = finfos.FirstOrDefault(m => m.Ch == 2);
                            if (minfo == null)
                            {
                                LogHelper.Warning($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻未找到主星信号ch2文件,跳过此组数据");
                                continue;
                            }
                            //邻1
                            var ninfo = finfos.FirstOrDefault(m => m.Ch == 3);
                            if (ninfo == null)
                            {
                                LogHelper.Info($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻未找到邻星信号ch3文件,跳过此组数据");
                                continue;
                            }
                            try
                            {
                                string mainFile = await HttpHelper.UploadFileAsync(minfo.FilePath, baseUrl + "File/UploadFileAsync", token: cts.Token);//主星文件
                                string adjaFile = await HttpHelper.UploadFileAsync(ninfo.FilePath, baseUrl + "File/UploadFileAsync", token: cts.Token);//邻星文件
                                string cdbFile = await HttpHelper.UploadFileAsync(dinfo.FilePath, baseUrl + "File/UploadFileAsync", token: cts.Token);//超短文件

                                DetectDto detectDto = new DetectDto()
                                {
                                    file1 = cdbFile,//11局使用上行泄露信号进行检测
                                    dmcType = DmcType.Ky5758,//上行信号目前算法只能使用基于能量的Ky或IBS检测
                                    fsHz = minfo.FsHz,
                                };
                                var deteResp = await HttpHelper.PostRequestAsync<List<DetectResDto>>(baseUrl + "DetectCg/DetectCalc", detectDto, token: cts.Token);
                                if (deteResp.code != 200)
                                {
                                    LogHelper.Error($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻信号检测出错.{deteResp.msg}");
                                    continue;
                                }
                                LogHelper.Info($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻信号检测完成,共{deteResp.data.Count}个时隙");
                                var smps = deteResp.data.Select(m => new SmpPosition(m.Start, m.Length)).ToList();//怎么补0?
                                var cgDto = new CpuCgMultiDto()
                                {
                                    dtCenter = 260000,
                                    dtRange = 60000,
                                    file1 = mainFile,
                                    file2 = cdbFile,
                                    samplingRate = minfo.FsHz,
                                    smpPositions = smps,
                                    snrThreshold = 15,
                                };
                                var result1 = await HttpHelper.PostRequestAsync<List<CpuCgResDto>>(baseUrl + "DetectCg/CpuCgMultiCalc", cgDto, token: cts.Token);
                                if (result1.code != 200)
                                {
                                    LogHelper.Error($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻主星超短CPU参估出错.{deteResp.msg}");
                                    continue;
                                }
                                LogHelper.Info($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻主星超短CPU参估完成.");
                                cgDto = new CpuCgMultiDto()
                                {
                                    dtCenter = 260000,
                                    dtRange = 60000,
                                    file1 = adjaFile,
                                    file2 = cdbFile,
                                    samplingRate = minfo.FsHz,
                                    smpPositions = smps,
                                    snrThreshold = 15,
                                };
                                var result2 = await HttpHelper.PostRequestAsync<List<CpuCgResDto>>(baseUrl + "DetectCg/CpuCgMultiCalc", cgDto, token: cts.Token);
                                if (result2.code != 200)
                                {
                                    LogHelper.Error($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻邻星超短CPU参估出错.{deteResp.msg}");
                                    continue;
                                }
                                LogHelper.Info($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻邻星超短CPU参估完成");
                                var data1 = result1.data;
                                var data2 = result2.data;
                                if (data1.Count != data2.Count || data1.Count != deteResp.data.Count)
                                {
                                    LogHelper.Error($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻参估结果个数和检测结果个数不匹配");
                                    continue;
                                }
                                for (int i = 0; i < data1.Count; i++)
                                {
                                    try
                                    {
                                        if (cts.IsCancellationRequested) break;
                                        X2D1NoXlNoParlPosDto x2D1 = new X2D1NoXlNoParlPosDto()
                                        {
                                            TaskID = dto.ID,
                                            SigTime = minfo.CapTime.AddSeconds(data1[i].Smpstart / minfo.FsHz),
                                            MainCode = minfo.SatId,
                                            AdjaCode = ninfo.SatId,
                                            SxDto = data1[i].Dt,
                                            SxDfo = data1[i].Df,
                                            SxSnr = data1[i].Snr,
                                            XdDto = data2[i].Dt,
                                            XdDfo = data2[i].Df,
                                            XdSnr = data2[i].Snr,
                                            SatTxLon = minfo.CapLon,
                                            SatTxLat = minfo.CapLat,
                                            CdbTxLon = minfo.CapLon,
                                            CdbTxLat = minfo.CapLat,
                                            FreqDown = minfo.FreqHz,
                                            FreqUp = dinfo.FreqHz,
                                            CheckRes = new CheckResDto()
                                            {
                                                FileName = Path.GetFileName(dinfo.FilePath),
                                                ModRate = deteResp.data[i].ModRate,
                                                ModType = deteResp.data[i].ModType,
                                                SmpCount = deteResp.data[i].Length,
                                                SmpStart = deteResp.data[i].Start,
                                                UserName = deteResp.data[i].UserName,
                                                PosCheckType = deteResp.data[i].DmcType.GetEnumByDisplayName<EnumPosCheckTypeDto>(),
                                            }
                                        };
                                        var result = await HttpHelper.PostRequestAsync<PosResDto>(baseUrl + "Pos/PosX2D1NoXlNoParAsync", x2D1);
                                        if (result.code != 200)
                                        {
                                            LogHelper.Error($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻时隙位置{data1[i].Smpstart}定位异常.{result.msg}");
                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        LogHelper.Error($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻时隙位置{data1[i].Smpstart}定位异常", ex);
                                    }
                                }
                                LogHelper.Info($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻定位完成");

                            }
                            catch (Exception ex)
                            {
                                LogHelper.Error($"【任务{dto.ID}】{capTime:yyyyMMddHHmmss}时刻文件处理异常", ex);
                                continue;
                            }

                        }
                        ResetTime(formatFlag, ref preTime);
                        LogHelper.Info($"【任务{dto.ID}】目录[{filesDir}]中的数据处理完成");
                    }
                    catch (Exception ex)
                    {
                        LogHelper.Error($"【任务{dto.ID}】目录[{filesDir}]中的数据处理出错,跳过此目录", ex);
                        ResetTime(formatFlag, ref preTime);
                    }
                }
                StopTask(dto.ID, $"数据处理完成,任务结束");
            }, cts.Token);
        }
        private void ResetTime(int formatFlag, ref DateTime time)
        {
            if (formatFlag == 0)
            {
                time = DateTime.MaxValue;
            }
            else if (formatFlag == 1)
            {
                time = time.AddHours(24);
            }
            else
            {
                time = time.AddHours(1);
            }
        }
        private HistoryFile FileToHistoryFile(X2D1HistoryTaskHandleDto dto, string filePath, bool canConnected)
        {  //读取采集文件
           //2024_01_31_10_01_51_000000000_ch11_-1_＿Nxx.xxxxxx_Exx.xxxxxx_xxxxx.xxxHz_xxx.xxxMHz_ch1_xd1.dat
            HistoryFile historyFile = new HistoryFile();
            historyFile.FilePath = filePath;
            var fileName = Path.GetFileNameWithoutExtension(filePath);
            var strs = fileName.Split(new string[] { "_", "MHz", "Hz", "ch" }, StringSplitOptions.RemoveEmptyEntries);

            //采集时间
            var datestr = string.Join("_", strs.Take(6));
            DateTime dateTime;
            bool istime = DateTime.TryParseExact(datestr, "yyyy_MM_dd_HH_mm_ss", null, DateTimeStyles.None, out dateTime);
            if (!istime) return historyFile;
            historyFile.CapTime = dateTime;


            //采集通道
            var chstr = strs.Skip(strs.Length - 2).Take(1).First();
            int ch;
            int.TryParse(chstr, out ch);

            //采集频点
            var freqstr = strs.Skip(strs.Length - 3).Take(1).First();
            double freqMHz;
            double.TryParse(freqstr, out freqMHz);

            //采样率
            var fsstr = strs.Skip(strs.Length - 4).Take(1).First();
            double fsHz;
            double.TryParse(fsstr, out fsHz);

            historyFile.FreqHz = freqMHz * 1e6;
            historyFile.Ch = ch;
            historyFile.FsHz = fsHz;
            if (canConnected)
                historyFile.SatId = GetSatId(historyFile.FreqHz);
            if (ch == 2)
            {
                if (historyFile.SatId == 0)
                {
                    LogHelper.Warning($"【任务{dto.ID}】主星使用任务中的卫星[{dto.MainSatCode}]");
                    historyFile.SatId = dto.MainSatCode;
                }
            }
            else if (ch == 3)
            {
                if (historyFile.SatId == 0)
                {
                    LogHelper.Warning($"【任务{dto.ID}】邻星使用任务中的卫星[{dto.AdjaSatCode}]");
                    historyFile.SatId = dto.AdjaSatCode;
                }
            }
            return historyFile;
        }
        int GetSatId(double freqdown)
        {
            int satId = 0;
            string sql = $"select 卫星ID from freguencysatid where 下行 = '{freqdown}'and 洋区 = 'I' LIMIT 1";
            try
            {
                var res = MySqlTools.ExecuteScalar(System.Data.CommandType.Text, sql);
                if (res == null || res == DBNull.Value)
                {
                    LogHelper.Error($"下行频点{freqdown * 1e-6}未能从MySql中找到对应的卫星编号.SQL={sql}");
                }
                bool isInt = int.TryParse($"{res}", out satId);
                if (!isInt)
                {
                    //System.Configuration.ConfigurationManager.ConnectionStrings["MySql"].ConnectionString
                    LogHelper.Error($"卫星编号转换失败,obj={res}");
                }
            }
            catch (Exception ex)
            {
                LogHelper.Error($"下行频点{freqdown * 1e-6}MySql查询卫星编号异常.ConnectionString={System.Configuration.ConfigurationManager.ConnectionStrings["MySql"].ConnectionString}", ex);
            }
            return satId;
        }
        bool CanGetSatIdFromMySql()
        {
            string sql = $"select 卫星ID from freguencysatid where 下行 = '{0}'and 洋区 = 'I' LIMIT 1";
            try
            {
                var res = MySqlTools.ExecuteScalar(System.Data.CommandType.Text, sql);
                return true;
            }
            catch
            {
                return false;
            }
        }
        void StopTask(int taskID, string stopReason)
        {
            TaskStopHandleDto stopDto = new TaskStopHandleDto() { ID = taskID, StopReason = stopReason };
            if (string.IsNullOrWhiteSpace(stopReason))
                LogHelper.Info($"【任务{taskID}】正常结束");
            else
                LogHelper.Error($"【任务{taskID}】{stopReason}");

            var stopResp = HttpHelper.PostRequestAsync(baseUrl + "Task/StopTask", stopDto).Result;
            if (stopResp.code != 200)
            {
                LogHelper.Error($"【任务{taskID}】停止异常.{stopResp.msg}");
                return;
            }
        }
        public void Stop()
        {
            cts?.Cancel();
        }
    }
}