DataSimulation/DataSimulation.Forms/UserControl/CtrlXl.cs

using DataSimulation.Repostory;
using DataSimulation.Repostory.EFContext;
using DataSimulation.Repostory.Model;
using DevExpress.XtraEditors;
using DxHelper;
using ExtensionsDev;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Data.Entity.Migrations;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace DataSimulation.Forms.UserControl
{
    public partial class CtrlXl : DevExpress.XtraEditors.XtraUserControl
    {
        List<XlInfo> list = new List<XlInfo>();
        public CtrlXl()
        {
            InitializeComponent();
            this.layoutControl1.UseDefault();
            btnOpen.UseChooseFile().UseDoubleClickToSelectAll();
            btnImp.ImageOptions.SvgImage = SvgHelper.LoadFromFile("Images\\Import.svg");
            btnImp.ImageOptions.SvgImageSize = new Size(20, 20);

        }
        private async void CtrlXl_Load(object sender, EventArgs e)
        {
            gridXl.Init<XlInfo>().UseSort().UseFilter().UseMultiSelect().UseRowNumber();
            gridXl.DataSource = list;
            await LoadData();
        }
        public async Task LoadData()
        {
            try
            {
                list.Clear();
                list.AddRange(await XlCache.GetAllAsync());
                gridView1.RefreshData();
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex,"加载星历信息异常");
                DxHelper.MsgBoxHelper.ShowError("加载星历信息异常");
            }
        }

        private async void btnImp_Click(object sender, EventArgs e)
        {
            //https://www.space-track.org/documentation#tle网站上有星历文件格式说明
            string line = null;
            try
            {
                this.btnImp.Enabled = false;
                await Task.Run(async () =>
                {
                    var lines = File.ReadAllLines(btnOpen.Text).ToList();
                    lines.RemoveAll(p => string.IsNullOrWhiteSpace(p));
                    List<XlInfo> tmp = new List<XlInfo>();
                    for (int i = 0; i < lines.Count; i += 3)
                    {
                        line = lines[i];
                        var satName = lines[i].Trim();
                        if (satName.StartsWith("0 "))
                            satName = satName.Substring(2).Trim();
                        if (satName.StartsWith("TBA"))//待发布的卫星
                            continue;
                        XlInfo xl = new XlInfo()
                        {
                            SatName = satName,
                            Line1 = lines[i + 1],
                            Line2 = lines[i + 2],
                            SatCode = Convert.ToInt32(lines[i + 1].Substring(2, 5))
                        };
                        //https://www.space-track.org/documentation#tle星历接口中说这里面可以接受空格
                        var timeStr = lines[i + 1].Substring(18, 14).Replace(" ","");
                        var yearStr = timeStr.Substring(0, 2);
                        var dayStr = timeStr.Substring(2, timeStr.Length - 2);
                        var day = Convert.ToDouble(dayStr);
                        var year = 2000 + Convert.ToInt32(yearStr);
                        DateTime dt = new DateTime(year, 1, 1, 0, 0, 0);
                        dt = dt.AddDays(day);
                        xl.TimeBJ = dt.AddHours(8);
                        tmp.Add(xl);
                    }
                    var groupData = tmp.GroupBy(p => p.TimeBJ.ToString("yyyyMMdd"));
                    foreach (var items in groupData)
                    {
                        using (SimulationPartContext db = SimulationPartContext.GetContext(items.First().TimeBJ))
                        {
                            foreach (var item in items)
                            {
                                var findItem = await db.XlInfos.FirstOrDefaultAsync(p => p.SatCode == item.SatCode && p.TimeBJ == item.TimeBJ);
                                if (findItem != null)
                                {
                                    findItem.Line1 = item.Line1;
                                    findItem.Line2 = item.Line2;
                                    findItem.UpdateTime = item.UpdateTime;
                                    db.XlInfos.AddOrUpdate(findItem);
                                }
                                else
                                {
                                    db.XlInfos.Add(item);
                                }
                            }
                            await db.SaveChangesAsync();
                        }

                    }
                   
                   
                });
                await LoadData();
                Serilog.Log.Information("星历导入成功");
                DxHelper.MsgBoxHelper.ShowInfo("星历导入成功");
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, $"{line}星历导入异常");
                DxHelper.MsgBoxHelper.ShowError("星历导入异常");
            }
            finally
            {
                this.btnImp.Enabled = true;
            }

        }

        private async void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {
                if (XtraMessageBox.Show("确认删除选择的星历信息?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
                {
                    return;
                }
                this.btnImp.Enabled = false;
                await Task.Run(async () =>
                {
                    var ids = gridView1.GetSelectedRows();
                    List<XlInfo> list = new List<XlInfo>();
                    foreach (var idx in ids)
                    {
                        var item = gridView1.GetRow(idx) as XlInfo;
                        list.Add(item);
                    }
                    var groupData=list.GroupBy(p => p.TimeBJ.ToString("yyyyMMdd"));
                    foreach (var item in groupData)
                    {
                        var dayIds = item.Select(p=>p.ID).ToList();
                        using (SimulationPartContext db = SimulationPartContext.GetContext(item.First().TimeBJ))
                        {
                            var delItems = await db.XlInfos.Where(p => dayIds.Contains(p.ID)).ToListAsync();
                            db.XlInfos.RemoveRange(delItems);
                            await db.SaveChangesAsync();
                        }

                    }
                   
                });
                gridView1.DeleteSelectedRows();

            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "删除选中的星历时异常");
                DxHelper.MsgBoxHelper.ShowError("删除选中的星历时异常");
            }
            finally
            {
                this.btnImp.Enabled = true;
            }
        }

        private void gridView1_PopupMenuShowing(object sender, DevExpress.XtraGrid.Views.Grid.PopupMenuShowingEventArgs e)
        {
            if (gridView1.FocusedRowObject != null)
                popupMenu1.ShowPopup(MousePosition);
        }
    }
}