XdCxRhDW/XdCxRhDW.App/UserControl/CtrlHome.cs

using DevExpress.Utils;
using DevExpress.Utils.Drawing;
using DevExpress.Utils.Svg;
using DevExpress.XtraEditors.ButtonsPanelControl;
using DevExpress.XtraGrid.Views.Grid;
using DxHelper;
using Microsoft.Owin.Hosting;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Data;
using System.Data.Entity;
using System.Drawing;
using System.Linq;
using System.Net;
using System.Reflection;
using System.Text;
using System.Windows.Forms;
using XdCxRhDW.App.Api;
using XdCxRhDW.App.EditForms;
using XdCxRhDW.Repostory.Model;
using XdCxRhDW.Repostory.EFContext;
using XdCxRhDW.WebApi;
using XdCxRhDW.Core.ObServer;
using ExtensionsDev;
using DevExpress.XtraEditors;
using System.Data.Entity.Migrations;
using System.Threading;
using System.Threading.Tasks;
using System.IO;
using XdCxRhDW.App.PopupControl;
namespace XdCxRhDW.App.UserControl
{
    public partial class CtrlHome : DevExpress.XtraEditors.XtraUserControl
    {
        List<TaskInfo> list = new List<TaskInfo>();
        TaskInfo tsk = new TaskInfo();
        List<CancellationTokenSource> listCts = new List<CancellationTokenSource>();
        public CtrlHome()
        {
            InitializeComponent();
            gridHomeTask.Init<TaskInfo>().UseFilter();
            gridHomePosRes.Init<PosRes>().UseMultiSelect().UseRowNumber().UseFilter();
            layoutControl1.UseDefault();
            txtStartTime.UseDefault();
            txtEndTime.UseDefault();
            btnDrawDto.ImageOptions.SvgImage = SvgHelper.LoadFromFile("Image\\DtoLine.svg");
            btnDrawDfo.ImageOptions.SvgImage = SvgHelper.LoadFromFile("Image\\DfoLine.svg");
            btnGDOP.ImageOptions.SvgImage = SvgHelper.LoadFromFile("Image\\GDOP.svg");
            var mapService = string.Empty;//http://ows.mundialis.de/services/service
            using (RHDWContext db = new RHDWContext())
            {
                mapService = db.SysSetings.FirstOrDefault()?.MapService;
            }
            mapControl1.UseDefalutOptions()
            //.UseCluster()//定位点使用内置聚合
            .UseClearAll()
            .UseDistanceLine()
            .UseMarkDot()
            .UseExportImg()
            .UseExportXlsx()
            .UseExportCsv()
            .SetMapLayerType(mapService)
            //.SetMapLayerType("")
            //.UseHJ(item =>
            //{
            //    (double Lon, double Lat) = item;
            //    PosRes pos = new PosRes();
            //    pos.PosLon = Lon;
            //    pos.PosLat = Lat;
            //    pos.SigTime = DateTime.Now;
            //    mapControl1.AddHJPosItem(pos);
            //})
            .UseDrawRect(rect =>
            {
                (double startLon, double startLat, double centerLon, double centerLat, double endLon, double endLat, double lonRange, double latRange) = rect;
            });

            PosObServer.Instance.Sub(PosSubEvent);
        }

        private void PosSubEvent(PosRes posRes)
        {
            var currentTask = gridView1.GetFocusedRow() as TaskInfo;
            if (currentTask.ID == posRes.TaskInfoID)
            {
                var ds = this.gridHomePosRes.DataSource as List<PosRes>;
                ds.Insert(0, posRes);
                this.Invoke(new Action(() =>
                {
                    gridView2.RefreshData();
                    mapControl1.AddPosItem(posRes);
                }));
            }
        }

        private async void CtrlHome_Load(object sender, EventArgs e)
        {
            gridView1.FocusedRowObjectChanged += GridView1_FocusedRowObjectChanged;
            gridView2.FocusedRowObjectChanged += GridView2_FocusedRowObjectChanged;
            try
            {
                List<TxInfo> txList = new List<TxInfo>();
                using (RHDWContext db = new RHDWContext())
                {
                    var qq = db.TaskInfos.OrderByDescending(p => p.UpdateTime).ToList();
                    list.AddRange(qq);
                    var runningList = await db.TaskInfos.Where(p => p.TaskState == EnumTaskState.Running).ToListAsync();
                    foreach (var item in runningList)
                    {
                        item.TaskState = EnumTaskState.Stopped;
                    }
                    await db.SaveChangesAsync();

                    var satres = db.SatInfos.OrderBy(p => p.SatName).OrderBy(p => p.SatName);

                    var txres = await db.TxInfos.ToListAsync();
                    txList.AddRange(txres);
                }
                mapControl1.AddRectMenu<PosRes>("删除定位点", SvgHelper.CreateClose(), items =>
                {
                    DeletePosRes(items.ToList());
                });
                mapControl1.AddRectMenu<PosRes>("使用镜像点", SvgHelper.LoadFromFile("Image\\Pos.svg"), items =>
                   {
                       UseMirr(items.ToList());
                   });
                mapControl1.AddRectMenu<PosRes>("编辑目标", SvgHelper.LoadFromFile("Image\\Edit.svg"), items =>
                {
                    EditTarget(items.ToList());
                });
                mapControl1.AddPosMenu<PosRes>("绘制时差线", SvgHelper.LoadFromFile("Image\\DtoLine.svg"), item =>
                {
                    DrawDtoLine(item);
                }, p =>
                {
                    switch (p.PosResType)
                    {

                        case EnumPosResType.X3TwoDfo:
                        case EnumPosResType.RH:
                        default:
                            return false;
                        case EnumPosResType.X1D1CX:
                        case EnumPosResType.X2D1:
                        case EnumPosResType.X2D1NoRef:
                        case EnumPosResType.X3:
                        case EnumPosResType.X3NoRef:
                        case EnumPosResType.X2Dfo:
                            return true;
                    }
                })
                .AddPosMenu<PosRes>("绘制频差线", SvgHelper.LoadFromFile("Image\\DfoLine.svg"), item =>
                {
                    DrawDfoLine(item);
                }, p =>
                {
                    switch (p.PosResType)
                    {
                        case EnumPosResType.X3TwoDfo:
                        case EnumPosResType.X2Dfo:
                            return true;
                        case EnumPosResType.X2D1:
                        case EnumPosResType.X2D1NoRef:
                        case EnumPosResType.RH:
                        case EnumPosResType.X3:
                        case EnumPosResType.X3NoRef:
                        case EnumPosResType.X1D1CX:
                        default:
                            return false;
                    }
                })
                 .AddPosMenu<PosRes>("绘制GDOP", SvgHelper.LoadFromFile("Image\\GDOP.svg"), item =>
                  {
                      DrawGDOP(item);
                  }, p =>
                  {
                      switch (p.PosResType)
                      {
                          case EnumPosResType.X3TwoDfo:
                          case EnumPosResType.X2Dfo:
                          case EnumPosResType.X2D1:
                          case EnumPosResType.X2D1NoRef:
                          case EnumPosResType.X3:
                          case EnumPosResType.X3NoRef:
                          case EnumPosResType.X1D1CX:
                              return true;
                          case EnumPosResType.RH:
                          default:
                              return false;
                      }
                  })
                 .AddPosMenu<PosRes>("绘制测向线", btnDrawCX.ImageOptions.SvgImage, item =>
                  {
                      DrawCXLine(item);
                  }, p =>
                  {
                      switch (p.PosResType)
                      {
                          case EnumPosResType.X1D1CX:
                              return true;
                          case EnumPosResType.RH:
                          case EnumPosResType.X3TwoDfo:
                          case EnumPosResType.X2Dfo:
                          case EnumPosResType.X2D1:
                          case EnumPosResType.X2D1NoRef:
                          case EnumPosResType.X3:
                          case EnumPosResType.X3NoRef:
                          default:
                              return false;
                      }
                  });

            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "加载任务信息异常");
                DxHelper.MsgBoxHelper.ShowError("加载任务信息异常");
            }
            gridHomeTask.DataSource = list;
            gridView1.Columns[nameof(TaskInfo.TaskName)].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Near;
            this.svgImageCollection1.Add("Stopped", SvgHelper.CreateCycle("#1E8B58"));
            this.svgImageCollection1.Add("Running", SvgHelper.CreateCycle("#2E8B57"));
            gridView1.CustomDrawCell += GridView1_CustomDrawCell;
            gridView1.CustomColumnDisplayText += GridView1_CustomColumnDisplayText;
            gridView1.RowClick += GridView1_RowClick;
            using (RHDWContext db = new RHDWContext())
            {
                var settings = await db.SysSetings.FirstOrDefaultAsync();
                if (settings == null)
                {
                    DxHelper.MsgBoxHelper.ShowWarning($"请在系统设置中配置IP端口信息");
                    return;
                }
                try
                {
                    StartOptions options = new StartOptions();
                    options.Urls.Add($"http://+:{settings.HttpPort}");
                    httpServer = WebApp.Start<Startup>(options);
                }
                catch (System.Reflection.TargetInvocationException ex)
                {
                    httpServer = null;
                    Serilog.Log.Error(ex, $"启动Http服务失败!");
                    if (ex.InnerException is HttpListenerException)
                    {
                        DxHelper.MsgBoxHelper.ShowWarning($"{ex.InnerException.Message}");
                    }
                    else
                    {
                        DxHelper.MsgBoxHelper.ShowWarning($"启动Http服务失败!");
                    }
                }
                catch (Exception ex)
                {
                    httpServer = null;
                    Serilog.Log.Error(ex, $"启动Http服务失败!");
                    DxHelper.MsgBoxHelper.ShowWarning($"启动Http服务失败!");
                }
            }

            WaitHelper.CloseForm();
        }
        private async void EditTarget(List<PosRes> items)
        {
            if (items == null || items.Count() == 0)
            {
                DxHelper.MsgBoxHelper.ShowWarning($"请选择需要编辑目标的定位数据信息!");
                return;
            }
            try
            {
                var firstItem = items.First();
                EditorTar frm = new EditorTar(new TargetInfo() { ID = firstItem.TargetID.HasValue ? firstItem.TargetID.Value : 0, TargetName = firstItem.TarName });
                if (frm.ShowDialog() != DialogResult.OK) return;
                var tar = frm.info;
                var groupItems = items.GroupBy(p => p.SigTime.ToString("yyyyMMdd"));
                foreach (var groupItem in groupItems)
                {
                    var ids = groupItem.Select(m => m.ID).ToList();
                    using (RHDWPartContext db = RHDWPartContext.GetContext(groupItem.First().SigTime))
                    {
                        var array = await db.PosRes.Where(p => ids.Contains(p.ID)).ToArrayAsync();
                        EditTarget(array, tar);
                        await db.SaveChangesAsync();
                    }
                }
                EditTarget(items, tar);
                gridView2.RefreshData();
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "编辑定位目标异常!");
                MsgBoxHelper.ShowError("编辑定位目标异常!");
            }

        }
        private void EditTarget(IEnumerable<PosRes> pos, TargetInfo tar)
        {
            foreach (var item in pos)
            {
                item.TargetID = tar.ID;
                item.TarName = tar.TargetName;
            }

        }
        private async void UseMirr(List<PosRes> items)
        {
            if (items == null || items.Count() == 0)
            {
                DxHelper.MsgBoxHelper.ShowWarning($"请选择需要使用镜像点的定位数据信息!");
                return;
            }
            try
            {
                if (XtraMessageBox.Show("确认使用镜像点?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
                {
                    return;
                }
                var groupItems = items.GroupBy(p => p.SigTime.ToString("yyyyMMdd"));
                foreach (var groupItem in groupItems)
                {
                    var ids = groupItem.Select(m => m.ID).ToList();
                    using (RHDWPartContext db = RHDWPartContext.GetContext(groupItem.First().SigTime))
                    {
                        var array = await db.PosRes.Where(p => ids.Contains(p.ID)).ToArrayAsync();
                        UseMirror(array);
                        await db.SaveChangesAsync();

                    }
                }
                UseMirror(items);
                mapControl1.UpdatePosItem(items);
                gridView2.RefreshData();
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "使用镜像点失败!");
                MsgBoxHelper.ShowError("使用镜像点失败!");
            }

        }
        private async void DeletePosRes(List<PosRes> items)
        {
            if (items == null || items.Count() == 0)
            {
                DxHelper.MsgBoxHelper.ShowWarning($"请选择需要删除的定位数据信息!");
                return;
            }
            try
            {
                if (XtraMessageBox.Show("确认删除定位点?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
                {
                    return;
                }
                var groupItems = items.GroupBy(p => p.SigTime.ToString("yyyyMMdd"));
                foreach (var groupItem in groupItems)
                {
                    var ids = groupItem.Select(m => m.ID).ToList();
                    using (RHDWPartContext db = RHDWPartContext.GetContext(groupItem.First().SigTime))
                    {
                        List<PosRes> list = await db.PosRes.Where(p => ids.Contains(p.ID)).ToListAsync();
                        db.PosRes.RemoveRange(list);
                        await db.SaveChangesAsync();
                    }
                }
                mapControl1.DelPosItem(items);
                var ds = this.gridHomePosRes.DataSource as List<PosRes>;
                ds.RemoveAll(m => items.Select(p => p.ID).Contains(m.ID));
                gridView2.RefreshData();
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "删除定位点失败");
                MsgBoxHelper.ShowError("删除定位点失败!");
            }
        }
        private void UseMirror(IEnumerable<PosRes> pos)
        {
            foreach (var item in pos)
            {
                var mirrlon = item.MirrLon;
                var mirrLat = item.MirrLat;
                if (mirrlon == 999)
                {
                    continue;
                }
                item.MirrLon = item.PosLon;
                item.MirrLat = item.PosLat;
                item.PosLon = mirrlon;
                item.PosLat = mirrLat;
            }

        }
        private async void GridView1_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e)
        {
            listCts.ForEach(t => t.Cancel());
            listCts.Clear();
            var cts = new CancellationTokenSource();
            listCts.Add(cts);
            mapControl1.DelFixedImg("Sat");
            mapControl1.DelFixedImg("Tx");
            tsk = (e.Row as TaskInfo);
            if (tsk == null) return;

            var btnEdit = (layoutControlGroup1.CustomHeaderButtons[1] as GroupBoxButton);
            var btnDel = (layoutControlGroup1.CustomHeaderButtons[2] as GroupBoxButton);
            btnDel.Enabled = btnEdit.Enabled = tsk.TaskState != EnumTaskState.Running;
            List<PosRes> listPos = await searchPos(cts.Token);
            this.gridHomePosRes.DataSource = listPos;

            using (RHDWContext db = new RHDWContext())
            {
                var sat1 = db.SatInfos.Where(p => p.SatCode == tsk.MainSat).FirstOrDefault();
                var sat2 = db.SatInfos.Where(p => p.SatCode == tsk.Adja1Sat).FirstOrDefault();
                var sat3 = db.SatInfos.Where(p => p.SatCode == tsk.Adja2Sat).FirstOrDefault();
                if (sat1 != null && sat1.SatLon != null)
                    mapControl1.DrawFixedImg("Sat", 0, sat1.SatLon.Value, DxHelper.SvgHelper.CreateSat(), $"主星\r\n{sat1.Sat}");
                if (sat2 != null && sat2.SatLon != null)
                    mapControl1.DrawFixedImg("Sat", 0, sat2.SatLon.Value, DxHelper.SvgHelper.CreateSat(), $"邻1星\r\n{sat2.Sat}");
                if (sat3 != null && sat3.SatLon != null)
                    mapControl1.DrawFixedImg("Sat", 0, sat3.SatLon.Value, DxHelper.SvgHelper.CreateSat(), $"邻2星\r\n{sat3.Sat}");
            }
            mapControl1.SetPosDataSource(listPos);

        }
        private void GridView2_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e)
        {
            mapControl1.DelFixedImg("Tx");
            var posItem = (e.Row as PosRes);
            if (posItem == null) return;
            using (RHDWPartContext db = RHDWPartContext.GetContext(posItem.SigTime))
            {
                var station = db.StationRes.Where(p => p.ID == posItem.StationResID).FirstOrDefault();
                if (station != null)
                {
                    mapControl1.DrawFixedImg("Tx", station.SatTxLat, station.SatTxLon, DxHelper.SvgHelper.CreateAnt(), $"[卫星接收天线]\r\n经度:{station.SatTxLon}°\r\n纬度:{station.SatTxLat}°");
                    if (station.CdbTxLon != null)
                        mapControl1.DrawFixedImg("Tx", station.CdbTxLat.Value, station.CdbTxLon.Value, DxHelper.SvgHelper.CreateAnt(), $"[超短接收天线]\r\n经度:{station.CdbTxLon.Value}°\r\n纬度:{station.CdbTxLat.Value}°");
                    if (station.RefLon != null)
                        mapControl1.DrawFixedImg("Tx", station.RefLat.Value, station.RefLon.Value, DxHelper.SvgHelper.CreatePentagram(), $"[参考站]\r\n经度:{station.RefLon.Value}°\r\n纬度:{station.RefLat.Value}°");
                    if (station.CxLon != null)
                        mapControl1.DrawFixedImg("Tx", station.CxLat.Value, station.CxLon.Value, DxHelper.SvgHelper.CreatePentagram(), $"[测向站]\r\n经度:{station.CxLon.Value}°\r\n纬度:{station.CxLat.Value}°");

                }
            }
        }
        private void GridView1_RowClick(object sender, RowClickEventArgs e)
        {
            if (e.Clicks > 1)
            {
                layoutControlGroup1_CustomButtonClick(null, new DevExpress.XtraBars.Docking2010.BaseButtonEventArgs(new GroupBoxButton() { Caption = "编辑任务" }));
            }
        }

        private void GridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
        {
            if (e.Column.FieldName == nameof(TaskInfo.Freq))
            {
                e.DisplayText = $"{(long)e.Value / 1e6}MHz";
            }
            else if (e.Column.FieldName == nameof(TaskInfo.Band))
            {
                e.DisplayText = $"{(int)e.Value / 1e6}MHz";
            }
        }

        private void GridView1_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
        {
            if (e.Column.FieldName == nameof(TaskInfo.TaskName) && (EnumTaskState)gridView1.GetRowCellValue(e.RowHandle, nameof(TaskInfo.TaskState)) == EnumTaskState.Running)
            {
                var palette = SvgPaletteHelper.GetSvgPalette(this.LookAndFeel, ObjectState.Normal);
                e.Cache.DrawSvgImage(svgImageCollection1[1], new Rectangle(new Point(e.Bounds.X + 4, e.Bounds.Y + (e.Bounds.Height - 16) / 2), new Size(16, 16)), palette);

                Rectangle txtBounds = e.Bounds;
                txtBounds.Width -= 24;
                txtBounds.X += 24;
                e.Appearance.DrawString(e.Cache, e.DisplayText, txtBounds);
                e.Handled = true;
            }
        }

        private void toolTipController1_GetActiveObjectInfo(object sender, DevExpress.Utils.ToolTipControllerGetActiveObjectInfoEventArgs e)
        {
            var hitInfo = gridView1.CalcHitInfo(e.ControlMousePosition);

            if (hitInfo.RowHandle < 0 || hitInfo.Column == null || hitInfo.HitTest != DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitTest.RowCell)
            {
                toolTipController1.HideHint();
                return;
            }
            if (hitInfo.Column.FieldName == nameof(TaskInfo.TaskName))
            {
                var state = (EnumTaskState)gridView1.GetRowCellValue(hitInfo.RowHandle, nameof(TaskInfo.TaskState));
                if (state == EnumTaskState.Running)
                    e.Info = new ToolTipControlInfo(hitInfo.RowHandle, "执行中");
            }
        }

        private void gridView1_PopupMenuShowing(object sender, DevExpress.XtraGrid.Views.Grid.PopupMenuShowingEventArgs e)
        {
            if (gridView1.FocusedRowHandle < 0) return;
            var state = (EnumTaskState)gridView1.GetFocusedRowCellValue(nameof(TaskInfo.TaskState));
            btnStart.Enabled = state == EnumTaskState.Stopped;
            btnStop.Enabled = state == EnumTaskState.Running;
            popupMenu1.ShowPopup(MousePosition);
        }
        private void gridView2_PopupMenuShowing(object sender, DevExpress.XtraGrid.Views.Grid.PopupMenuShowingEventArgs e)
        {
            if (gridView2.FocusedRowHandle < 0) return;
            var posRes = GetPosRes("");
            switch (posRes.PosResType)
            {
                case EnumPosResType.X1D1CX:
                    //一星一地 测向线 GDOP
                    btnDrawDfo.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    btnDrawDto.Visibility = btnGDOP.Visibility = btnDrawCX.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
                    btnShowCxRes.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
                    break;
                case EnumPosResType.X2D1:
                case EnumPosResType.X2D1NoRef:
                    //两星一地 GDOP 时差线
                    btnDrawDto.Visibility = btnGDOP.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
                    btnDrawCX.Visibility = btnDrawDfo.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    btnShowCxRes.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    break;
                case EnumPosResType.RH:
                    //融合DW=
                    btnDrawDto.Visibility = btnDrawCX.Visibility = btnGDOP.Visibility = btnDrawDfo.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    btnShowCxRes.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
                    break;
                case EnumPosResType.X3:
                case EnumPosResType.X3NoRef:
                    //三星双时差DW GDOP 时差线 
                    btnDrawDto.Visibility = btnGDOP.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
                    btnDrawCX.Visibility = btnDrawDfo.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    btnShowCxRes.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    break;
                case EnumPosResType.X3TwoDfo:
                    //三星双频差DW GDOP 频差线 
                    btnDrawDfo.Visibility = btnGDOP.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
                    btnDrawDto.Visibility = btnDrawCX.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    btnShowCxRes.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    break;
                case EnumPosResType.X2Dfo:
                    //双星时频差DW GDOP 时频差线 
                    btnDrawDto.Visibility = btnDrawDfo.Visibility = btnGDOP.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
                    btnDrawCX.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    btnShowCxRes.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                    break;
                default:
                    break;
            }
            popupMenu2.ShowPopup(MousePosition);
        }
        private async void layoutControlGroup1_CustomButtonClick(object sender, DevExpress.XtraBars.Docking2010.BaseButtonEventArgs e)
        {
            var txt = (e.Button as GroupBoxButton).Caption;
            if (txt == "新建任务")
            {
                try
                {
                    TaskEditor frm = new TaskEditor();
                    if (frm.ShowDialog() != DialogResult.OK) return;
                    var addItem = frm.info;
                    using (RHDWContext db = new RHDWContext())
                    {
                        if (await db.TaskInfos.AnyAsync(p => p.TaskName == addItem.TaskName))
                        {
                            DxHelper.MsgBoxHelper.ShowWarning("任务名称重复");
                            return;
                        }
                        if (addItem.PosType == EnumPosType.X1D1CX)
                        {
                            addItem.Adja1Sat = null;
                            addItem.Adja2Sat = null;
                        }
                        else if (addItem.PosType == EnumPosType.X2D1 || addItem.PosType == EnumPosType.X2Dfo || addItem.PosType == EnumPosType.RH)
                        {
                            addItem.Adja2Sat = null;
                        }
                        db.TaskInfos.Add(addItem);
                        await db.SaveChangesAsync();
                    }
                    list.Insert(0, addItem);
                    gridView1.RefreshData();
                    gridView1.FocusedRowHandle = 0;
                }
                catch (Exception ex)
                {
                    Serilog.Log.Error(ex, "保存任务异常");
                    DxHelper.MsgBoxHelper.ShowError("保存任务异常");
                }
            }
            else if (txt == "编辑任务")
            {
                try
                {
                    var editItem = gridView1.GetFocusedRow() as TaskInfo;
                    TaskEditor frm = new TaskEditor(editItem);
                    if (frm.ShowDialog() != DialogResult.OK) return;
                    editItem = frm.info;
                    using (RHDWContext db = new RHDWContext())
                    {
                        if (await db.TaskInfos.AnyAsync(p => p.ID != editItem.ID && p.TaskName == editItem.TaskName))
                        {
                            DxHelper.MsgBoxHelper.ShowWarning("任务名称重复");
                            return;
                        }
                        var find = await db.TaskInfos.Where(p => p.ID == editItem.ID).FirstOrDefaultAsync();
                        find.TaskName = editItem.TaskName;
                        find.PosType = editItem.PosType;
                        find.UpdateTime = DateTime.Now;
                        find.Freq = editItem.Freq;
                        find.Band = editItem.Band;
                        find.MainSat = editItem.MainSat;
                        if (find.PosType == EnumPosType.X1D1CX)
                        {
                            find.Adja1Sat = null;
                            find.Adja2Sat = null;
                        }
                        else if (find.PosType == EnumPosType.X2D1 || find.PosType == EnumPosType.X2Dfo || find.PosType == EnumPosType.RH)
                        {
                            find.Adja2Sat = null;
                        }
                        else
                        {
                            find.Adja1Sat = editItem.Adja1Sat;
                            find.Adja2Sat = editItem.Adja2Sat;
                        }

                        await db.SaveChangesAsync();
                    }
                    gridView1.RefreshData();
                }
                catch (Exception ex)
                {
                    Serilog.Log.Error(ex, "保存任务异常");
                    DxHelper.MsgBoxHelper.ShowError("保存任务异常");
                }
            }
            else
            {
                try
                {
                    var tsk = gridView1.GetFocusedRow() as TaskInfo;
                    if (tsk == null) return;
                    if (!DxHelper.MsgBoxHelper.ShowConfirm($"删除任务[{tsk.TaskName}]?"))
                        return;
                    using (RHDWContext db = new RHDWContext())
                    {
                        var item = db.TaskInfos.FirstOrDefault(p => p.ID == tsk.ID);
                        db.TaskInfos.Remove(item);
                        db.SaveChanges();
                    }
                    gridView1.DeleteSelectedRows();

                }
                catch (Exception ex)
                {
                    Serilog.Log.Error(ex, "删除任务异常");
                    DxHelper.MsgBoxHelper.ShowError("删除任务异常");
                }
            }
        }
        IDisposable httpServer;
        private async void btn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            var tsk = gridView1.GetFocusedRow() as TaskInfo;
            if (e.Item.Caption == "启动任务")
            {
                try
                {
                    using (RHDWContext db = new RHDWContext())
                    {
                        var find = await db.TaskInfos.FirstOrDefaultAsync(p => p.TaskState == EnumTaskState.Running && p.PosType == tsk.PosType);
                        if (find != null)
                        {
                            var field = typeof(EnumPosType).GetField(Enum.GetName(typeof(EnumPosType), find.PosType));
                            DxHelper.MsgBoxHelper.ShowWarning($"已经有一个[{field.GetCustomAttribute<DisplayAttribute>().Name}]任务正在执行,请先停止!");
                            return;
                        }
                        var settings = await db.SysSetings.FirstOrDefaultAsync();
                        if (settings == null)
                        {
                            DxHelper.MsgBoxHelper.ShowWarning($"请在系统设置中配置IP端口信息");
                            return;
                        }
                        if (httpServer == null)
                        {
                            try
                            {
                                StartOptions options = new StartOptions();
                                options.Urls.Add($"http://+:{settings.HttpPort}");
                                httpServer = WebApp.Start<Startup>(options);
                            }
                            catch (Exception ex)
                            {
                                Serilog.Log.Error(ex, "启动任务异常,Http定位接口服务启动失败");
                                DxHelper.MsgBoxHelper.ShowError($"启动任务异常,Http定位接口服务启动失败");
                            }
                        }
                        var item = await db.TaskInfos.FirstOrDefaultAsync(p => p.ID == tsk.ID);
                        item.TaskState = EnumTaskState.Running;
                        await db.SaveChangesAsync();
                        tsk.TaskState = EnumTaskState.Running;
                        Serilog.Log.Information($"用户启动了任务,ID={tsk.ID}");
                    }
                }
                catch (Exception ex)
                {
                    Serilog.Log.Error(ex, "启动任务异常");
                    DxHelper.MsgBoxHelper.ShowError($"启动任务异常.{ex.Message}");
                }
            }
            else
            {
                try
                {
                    using (RHDWContext db = new RHDWContext())
                    {
                        var item = await db.TaskInfos.FirstOrDefaultAsync(p => p.ID == tsk.ID);
                        item.TaskState = EnumTaskState.Stopped;
                        await db.SaveChangesAsync();
                        //if (!db.TaskInfos.Any(p => p.TaskState == EnumTaskState.Running))
                        //{
                        //    server?.StopListening();
                        //    server = null;
                        //}
                    }
                    tsk.TaskState = EnumTaskState.Stopped;
                    Serilog.Log.Information($"用户停止了任务,ID={tsk.ID}");

                }
                catch (Exception ex)
                {
                    Serilog.Log.Error(ex, "停止任务异常");
                    DxHelper.MsgBoxHelper.ShowError($"停止任务异常.{ex.Message}");
                }
            }
            gridView1.RefreshData();
            var btnEdit = (layoutControlGroup1.CustomHeaderButtons[1] as GroupBoxButton);
            var btnDel = (layoutControlGroup1.CustomHeaderButtons[2] as GroupBoxButton);
            btnDel.Enabled = btnEdit.Enabled = tsk.TaskState != EnumTaskState.Running;
        }

        private void gridView1_CustomDrawEmptyForeground(object sender, DevExpress.XtraGrid.Views.Base.CustomDrawEventArgs e)
        {
            if (gridView1.RowCount == 0)
            {
                string txt = "点击+创建任务";
                var s = e.Appearance.CalcTextSize(e.Cache, txt, e.Bounds.Width).ToSize();
                var x = (e.Bounds.Width - s.Width) / 2;
                var y = (e.Bounds.Height - s.Height) / 2;
                //e.Appearance.DrawString(e.Cache, txt, new Rectangle(x,y,s.Width,s.Height));
                e.DrawHtml(htmlTemplate1);
            }
        }


        private void gridView2_RowClick(object sender, RowClickEventArgs e)
        {
            var p = gridView2.GetFocusedRow() as PosRes;
            p.Selected = true;
            mapControl1.UpdatePosItem(p);
        }


        private void btnDrawDto_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            var info = GetPosRes("绘制时差");
            if (info == null) return;
            DrawDtoLine(info);
        }
        private PosRes GetPosRes(string msg)
        {
            var ids = gridView2.GetSelectedRows();
            if (ids.Length <= 0)
            {
                DxHelper.MsgBoxHelper.ShowWarning($"请选择需要{msg}的定位数据信息!");
                return null;
            }
            var item = gridView2.GetRow(ids[0]) as PosRes;
            return item;
        }

        private void btnDrawDfo_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            var info = GetPosRes("绘制频差");
            if (info == null) return;
            DrawDfoLine(info);
        }

        private void btnDrawCX_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {

            var ids = gridView2.GetSelectedRows();
            if (ids.Length <= 0)
            {
                DxHelper.MsgBoxHelper.ShowWarning($"请选择需要绘制测向线的定位数据信息!");
                return;
            }
            var item = gridView2.GetRow(ids[0]) as PosRes;
            if (item.PosResType == EnumPosResType.X1D1CX)
            {
                DrawCXLine(item);
            }
        }

        private void btnGDOP_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            var info = GetPosRes("绘制GDOP");
            if (info == null) return;
            DrawGDOP(info);
        }
        private void btnShowCgRes_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            var item = gridView2.GetFocusedRow() as PosRes;
            DxHelper.PopupHelper.ShowPopup(new ShowCgCtrl(item), gridHomePosRes, gridHomePosRes.Height, EnumPopupDirection.Bottom,showCloseButton:true);
        }

        private void btnShowCxRes_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            var item = gridView2.GetFocusedRow() as PosRes;
            DxHelper.PopupHelper.ShowPopup(new ShowCxCtrl(item), gridHomePosRes, gridHomePosRes.Height, EnumPopupDirection.Bottom, showCloseButton: true);
        }
        private void DrawGDOP(PosRes item)
        {
            try
            {
                switch (item.PosResType)
                {
                    case EnumPosResType.X1D1CX:
                        X1D1GDOPParam x1D1GdopParam = new X1D1GDOPParam(item);
                        x1D1GdopParam.mapControl1 = mapControl1;
                        DxHelper.PopupHelper.ShowPopup(x1D1GdopParam, layoutControl1, 400);
                        break;
                    case EnumPosResType.X2D1:
                    case EnumPosResType.X2D1NoRef:
                        X2D1GDOPParam x2D1GdopParam = new X2D1GDOPParam(item);
                        x2D1GdopParam.mapControl1 = mapControl1;
                        DxHelper.PopupHelper.ShowPopup(x2D1GdopParam, layoutControl1, 400);
                        break;
                    case EnumPosResType.X3:
                    case EnumPosResType.X3NoRef:
                        X3GDOPParam x3GdopParam = new X3GDOPParam(item);
                        x3GdopParam.mapControl1 = mapControl1;
                        DxHelper.PopupHelper.ShowPopup(x3GdopParam, layoutControl1, 400);
                        break;
                    case EnumPosResType.X3TwoDfo:
                        X3DFGDOPParam x3DFGdopParam = new X3DFGDOPParam(item);
                        x3DFGdopParam.mapControl1 = mapControl1;
                        DxHelper.PopupHelper.ShowPopup(x3DFGdopParam, layoutControl1, 400);
                        break;
                    case EnumPosResType.X2Dfo:
                        X2DFGDOPParam x2DFGdopParam = new X2DFGDOPParam(item);
                        x2DFGdopParam.mapControl1 = mapControl1;
                        DxHelper.PopupHelper.ShowPopup(x2DFGdopParam, layoutControl1, 400);
                        break;
                    default:
                        break;
                }
            }
            catch (Exception ex)
            {
                DxHelper.MsgBoxHelper.ShowWarning($"绘制{item.PosResType.GetEnumDisplayName()}GDOP失败,{ex.Message}");

            }
        }

        private void DrawDtoLine(PosRes item)
        {

            switch (item.PosResType)
            {
                case EnumPosResType.X1D1CX:
                    X1D1DTOParamEditor frm = new X1D1DTOParamEditor(item, mapControl1);
                    frm.ShowDialog();
                    break;
                case EnumPosResType.X2D1:
                case EnumPosResType.X2D1NoRef:
                    DrawXDtoLine(item);
                    break;
                case EnumPosResType.X3:
                case EnumPosResType.X3NoRef:
                    DrawX3toLine(item);
                    break;
                case EnumPosResType.X2Dfo:
                    X2DTOParamEditor frm2 = new X2DTOParamEditor(item, mapControl1);
                    frm2.ShowDialog();
                    break;
                default:
                    break;
            }

        }
        private void DrawXDtoLine(PosRes item)
        {
            try
            {
                X2D1DTOParamEditor frm = new X2D1DTOParamEditor(item, mapControl1);
                frm.ShowDialog();

            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, $"绘制{item.PosResType.GetEnumDisplayName()}时差线失败.PosID={item.ID},SigTime={item.SigTime}");
                DxHelper.MsgBoxHelper.ShowWarning($"绘制{item.PosResType.GetEnumDisplayName()}时差线失败");
            }
        }

        private void DrawX3toLine(PosRes item)
        {
            try
            {
                X3DTOParamEditor frm = new X3DTOParamEditor(item, mapControl1);
                frm.ShowDialog();

            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, $"绘制{item.PosResType.GetEnumDisplayName()}时差线失败.PosID={item.ID},SigTime={item.SigTime}");
                DxHelper.MsgBoxHelper.ShowWarning($"绘制{item.PosResType.GetEnumDisplayName()}时差线失败");
            }
        }

        private void DrawDfoLine(PosRes item)
        {
            switch (item.PosResType)
            {
                case EnumPosResType.X3TwoDfo:
                case EnumPosResType.X2Dfo:
                    DrawX3DfoLine(item);
                    break;
                default:
                    break;
            }

        }
        private async void DrawX3DfoLine(PosRes item)
        {
            try
            {
                StationRes station;
                CgRes cg;

                using (RHDWPartContext db = RHDWPartContext.GetContext(item.SigTime))
                {
                    cg = await db.CgRes.Where(m => m.ID == item.CgResID).FirstOrDefaultAsync();
                    station = await db.StationRes.Where(m => m.ID == item.StationResID).FirstOrDefaultAsync();
                }
                if (cg == null)
                {
                    Serilog.Log.Error($"绘制三星频差线错误,未找到定位关联的参估计信息.PosID={item.ID},SigTime={item.SigTime}");
                    DxHelper.MsgBoxHelper.ShowError($"未找到定位关联的参估计信息");
                    return;
                }
                if (station == null)
                {
                    Serilog.Log.Error($"绘制三星频差线错误,未找到定位关联的站点信息.PosID={item.ID},SigTime={item.SigTime}");
                    DxHelper.MsgBoxHelper.ShowError($"未找到定位关联的站点信息");
                    return;
                }
                if (station.SatTxLon == 0 || station.SatTxLat == 0)
                {
                    Serilog.Log.Error($"绘制三星频差线错误,天线信息为空.PosID={item.ID},SigTime={item.SigTime}");
                    DxHelper.MsgBoxHelper.ShowError($"天线信息为空!");
                    return;
                }
                if (station.RefLon == 0 || station.RefLat == 0)
                {
                    Serilog.Log.Error($"绘制三星频差线错误,参考站信息为空.PosID={item.ID},SigTime={item.SigTime}");
                    DxHelper.MsgBoxHelper.ShowError($"参考站信息为空!");
                    return;
                }
                DfoLineTwoStartOption twoStartOption = new DfoLineTwoStartOption();
                twoStartOption.Freq = cg.TarFreqUp.HasValue ? cg.TarFreqUp.Value : 0;
                twoStartOption.RefFreq = cg.RefFreqUp.HasValue ? cg.RefFreqUp.Value : 0;
                twoStartOption.MsEph = new double[] { cg.MainX.Value, cg.MainY.Value, cg.MainZ.Value, cg.MainVx.Value, cg.MainVy.Value, cg.MainVz.Value };
                twoStartOption.NsEph = new double[] { cg.Adja1X.Value, cg.Adja1Y.Value, cg.Adja1Z.Value, cg.Adja1Vx.Value, cg.Adja1Vy.Value, cg.Adja1Vz.Value };
                twoStartOption.MsAnt = new double[] { station.SatTxLon, station.SatTxLat, 0 };
                twoStartOption.NsAnt = new double[] { station.SatTxLon, station.SatTxLat, 0 };
                twoStartOption.RefGeod = new double[] { station.RefLon.Value, station.RefLat.Value, 0 };
                twoStartOption.TargetDfo = cg.Dfo1.Value;
                twoStartOption.Turn1 = Math.Abs(twoStartOption.Freq - (cg.TarFreqDown.HasValue ? cg.TarFreqDown.Value : 0));
                twoStartOption.Turn2 = Math.Abs(twoStartOption.RefFreq - (cg.RefFreqDown.HasValue ? cg.RefFreqDown.Value : 0));
                twoStartOption.RefDfo = cg.YbMainDfo.Value - cg.YbAdja1Dfo.Value;
                var tsDtoLine = DrawDfoLineHelper.DfoLineTwoStart(twoStartOption);

                List<SatInfo> listSat = null;
                using (RHDWContext db = new RHDWContext())
                {
                    listSat = await db.SatInfos.ToListAsync();
                }
                var msat = listSat?.FirstOrDefault(m => m.SatCode == cg.MainCode.Value)?.Sat; ;
                var ad1sat = listSat?.FirstOrDefault(m => m.SatCode == cg.Adja1Code.Value)?.Sat;
                if (msat == null) msat = cg.MainCode.ToString();
                if (ad1sat == null) ad1sat = cg.Adja1Code.ToString();
                mapControl1.DrawDtoPonit($"{item.PosResType.GetEnumDisplayName()}[{msat},{ad1sat}]频差线", tsDtoLine);

                if (item.PosResType == EnumPosResType.X3TwoDfo)
                {
                    twoStartOption.NsEph = new double[] { cg.Adja2X.Value, cg.Adja2Y.Value, cg.Adja2Z.Value, cg.Adja2Vx.Value, cg.Adja2Vy.Value, cg.Adja2Vz.Value };
                    twoStartOption.TargetDfo = cg.Dfo2.Value;
                    twoStartOption.RefDfo = cg.YbMainDfo.Value - cg.YbAdja2Dfo.Value;
                    var tsDtoLine1 = DrawDfoLineHelper.DfoLineTwoStart(twoStartOption);
                    string ad2sat = string.Empty;
                    if (cg.Adja2Code.HasValue)
                    {
                        ad2sat = listSat.FirstOrDefault(m => m.SatCode == cg.Adja2Code.Value)?.Sat;
                    }
                    mapControl1.DrawDtoPonit($"{item.PosResType.GetEnumDisplayName()}[{msat},{ad2sat}]频差线", tsDtoLine1);
                }
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, $"绘制{item.PosResType.GetEnumDisplayName()}频差线失败.PosID={item.ID},SigTime={item.SigTime}");
                DxHelper.MsgBoxHelper.ShowError($"绘制{item.PosResType.GetEnumDisplayName()}频差线失败");
            }
        }
        private async void DrawCXLine(PosRes item)
        {
            try
            {
                CxRes cx;
                StationRes station;
                using (RHDWPartContext db = RHDWPartContext.GetContext(item.SigTime))
                {
                    cx = await db.CxRes.Where(m => m.ID == item.CxResID.Value).FirstOrDefaultAsync();
                    station = await db.StationRes.Where(m => m.ID == item.StationResID).FirstOrDefaultAsync();
                }
                if (cx == null)
                {
                    Serilog.Log.Error($"绘制测向线错误,未找到定位关联的测向信息.PosID={item.ID},SigTime={item.SigTime}");
                    DxHelper.MsgBoxHelper.ShowError($"未找到定位关联的测向信息");
                    return;
                }
                if (station == null)
                {
                    Serilog.Log.Error($"绘制测向线错误,未找到定位关联的站点信息.PosID={item.ID},SigTime={item.SigTime}");
                    DxHelper.MsgBoxHelper.ShowError($"未找到定位关联的站点信息!");
                    return;
                }

                if (station.CxLon == 0 || station.CxLat == 0)
                {
                    Serilog.Log.Error($"绘制测向线错误,测向站信息为空.PosID={item.ID},SigTime={item.SigTime}");
                    DxHelper.MsgBoxHelper.ShowError($"测向站信息为空!");
                    return;
                }
                double deg = cx.Fx;//向北顺时针方向为夹角
                //计算测向站到定位点之间的距离
                var km = MapControlEx.CalcLineKm(station.CxLon.Value, station.CxLat.Value, item.PosLon, item.PosLat);
                var endpoint = MapControlEx.CalcSituation(station.CxLon.Value, station.CxLat.Value, deg, (km + 100) * 1000);
                List<(double, double)> points = new List<(double, double)>();
                points.Add((station.CxLon.Value, station.CxLat.Value));
                points.Add((endpoint.Item1, endpoint.Item2));
                mapControl1.DrawCXLine($"测向线角度:{cx.Fx}°\t\n", points, true);
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, $"绘制测向线失败.PosID={item.ID},SigTime={item.SigTime}");
                DxHelper.MsgBoxHelper.ShowWarning($"绘制测向线失败");
            }
        }

        private async void txtTimeCho_SelectedIndexChanged(object sender, EventArgs e)
        {
            listCts.ForEach(t => t.Cancel());
            listCts.Clear();
            this.gridHomePosRes.DataSource = new List<PosRes>();//先设为空,数据相同时便于观察结果有没有变化
            if (tsk == null)
            {
                return;
            }
            var cts = new CancellationTokenSource();
            listCts.Add(cts);
            switch (txtTimeCho.Text)
            {
                case "最近1小时":
                case "最近6小时":
                case "最近12小时":
                case "最近1天":
                case "最近3天":
                    layoutControlItemStartTime.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
                    layoutControlItemEndTime.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
                    layoutControlItemSearch.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
                    this.gridHomePosRes.DataSource = await searchPos(cts.Token);
                    break;
                case "自定义":
                    layoutControlItemStartTime.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
                    layoutControlItemEndTime.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
                    layoutControlItemSearch.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
                    break;
            }

        }
        private async void btnSearch_Click(object sender, EventArgs e)
        {
            if (txtStartTime.EditValue == null)
            {
                DxHelper.MsgBoxHelper.ShowError($"请选择信号开始时间!");
                return;
            }
            if (txtEndTime.EditValue == null)
            {
                DxHelper.MsgBoxHelper.ShowError($"请选择信号结束时间!");
                return;
            }
            if (txtStartTime.DateTime > txtEndTime.DateTime)
            {
                DxHelper.MsgBoxHelper.ShowError($"开始时间不能大于结束时间!");
                return;
            }
            if ((txtEndTime.DateTime - txtStartTime.DateTime).TotalDays > 10)
            {
                MsgBoxHelper.ShowWarning("时间跨度不能超过10天!");
                return;
            }
            listCts.ForEach(t => t.Cancel());
            listCts.Clear();
            var cts = new CancellationTokenSource();
            listCts.Add(cts);
            var listPos = await searchPos(cts.Token);
            this.gridHomePosRes.DataSource = listPos;


        }
        private async Task<List<PosRes>> searchPos(CancellationToken ct = default)
        {
            try
            {
                DateTime start, end = DateTime.MinValue;
                if (txtTimeCho.SelectedText == "自定义")
                {
                    start = txtStartTime.DateTime;
                    end = txtEndTime.DateTime;
                }
                else
                {
                    if (!Directory.Exists("DbPart")) return new List<PosRes>();
                    var yearDirs = Directory.EnumerateDirectories(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "DbPart")).OrderByDescending(p => Convert.ToInt32(new DirectoryInfo(p).Name));//年目录,倒叙排列
                    foreach (var yearDir in yearDirs)
                    {
                        //每一天的db文件,倒序排列
                        var dayFiles = Directory.EnumerateFiles(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, yearDir), "*.db").OrderByDescending(p => Convert.ToInt32(new DirectoryInfo(p).Name.Substring(0, 4)));
                        foreach (var dayFile in dayFiles)
                        {
                            using (RHDWPartContext db = RHDWPartContext.GetContext(dayFile))
                            {
                                if (db.PosRes.Any(p => p.TaskInfoID == tsk.ID))
                                    end = await db.PosRes.Where(p => p.TaskInfoID == tsk.ID).MaxAsync(p => p.SigTime);
                            }
                            if (end != DateTime.MinValue)
                            {
                                goto skip;
                            }
                        }
                    }
                }
            skip:
                if (end == DateTime.MinValue)
                {
                    return new List<PosRes>();//没有数据不查询
                }
                start = end.AddHours(-(int)txtTimeCho.EditValue);
                DateTime endDay = new DateTime(end.Year, end.Month, end.Day);
                DateTime startDay = new DateTime(start.Year, start.Month, start.Day);
                List<PosRes> list = new List<PosRes>();
                while (endDay >= startDay)
                {
                    using (RHDWPartContext db = RHDWPartContext.GetContext(endDay))
                    {
                        var posRes = await db.PosRes
                            .Where(w => w.SigTime >= start && w.SigTime <= end && w.TaskInfoID == tsk.ID)
                            .OrderByDescending(o => o.SigTime).ToListAsync(ct);
                        list.AddRange(posRes);
                    }
                    endDay = endDay.AddDays(-1);
                }
                return list;

            }
            catch (TaskCanceledException) { }//屏蔽掉取消查询的异常
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "定位结果查询异常");
                MsgBoxHelper.ShowError("定位结果查询异常");
            }
            return new List<PosRes>();
        }


    }
}