DW5S/DW5S.App/UserControl/CtrlFixedStation.cs

using System;
using System.Collections.Generic;
using System.Data;

using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using DW5S.App.EditForms;
using DW5S.Entity;
using DW5S.Repostory;

namespace DW5S.App.UserControl
{
    public partial class CtrlFixedStation : DevExpress.XtraEditors.XtraUserControl
    {
        readonly List<FixedStation> list = new List<FixedStation>();
        public CtrlFixedStation()
        {
            InitializeComponent();
        }
        private async void CtrlSat_Load(object sender, EventArgs e)
        {
            try
            {
                gridFixedStation.UseDefault(list).UseMultiSelect().UseRowNumber()
                    .UseAddAsync(Add)
                    .UseEditAsync<FixedStation>(Edit)
                    .UseDeleteAsync<FixedStation>(Delete).SetDisplayText(nameof(FixedStation.Value), val => $"{val}秒");
                using (var db = new RHDWContext())
                {
                    var items = await db.FixedStation.OrderBy(p => p.StationName).ToListAsync();
                    list.AddRange(items);
                }
            }
            catch (Exception ex)
            {
                DW5S.Framework.LogHelper.Error("查询固定站信息异常", ex);
                DxHelper.MsgBoxHelper.ShowError("查询固定站信息异常");
            }
        }

        private async Task<FixedStation> Add()
        {
            try
            {
                FixedStationEditor frm = new FixedStationEditor();
                if (frm.ShowDialog() != DialogResult.OK) return null;
                var addItem = frm.info;
                using (RHDWContext db = new RHDWContext())
                {
                    db.FixedStation.Add(addItem);
                    await db.SaveChangesAsync();
                }
                return addItem;
            }
            catch (Exception ex)
            {
                DW5S.Framework.LogHelper.Error("添加卫星信息异常", ex);
                DxHelper.MsgBoxHelper.ShowError("添加卫星信息异常");
                return null;
            }
        }

        private async Task<FixedStation> Edit(FixedStation editItem)
        {
            try
            {
                FixedStationEditor frm = new FixedStationEditor(editItem);
                if (frm.ShowDialog() != DialogResult.OK) return null;
                editItem = frm.info;
                using (RHDWContext db = new RHDWContext())
                {
                    var find = await db.FixedStation.Where(p => p.ID == editItem.ID).FirstOrDefaultAsync();
                    find.StationName = editItem.StationName;
                    find.FreqUpHz = editItem.FreqUpHz;
                    find.Lon = editItem.Lon;
                    find.Lat = editItem.Lat;
                    find.Value = editItem.Value;
                    find.Enable = editItem.Enable;
                    find.UpdateTime = DateTime.Now;
                    await db.SaveChangesAsync();
                }
                return editItem;
            }
            catch (Exception ex)
            {
                DW5S.Framework.LogHelper.Error("保存固定站信息异常", ex);
                DxHelper.MsgBoxHelper.ShowError("保存固定站信息异常");
                return null;
            }
        }

        private async Task<bool> Delete(List<FixedStation> list)
        {
            try
            {
                var ids = list.Select(p => p.ID);
                using (RHDWContext db = new RHDWContext())
                {
                    var delItems = await db.SatInfos.Where(p => ids.Contains(p.ID)).ToListAsync();
                    db.SatInfos.RemoveRange(delItems);
                    await db.SaveChangesAsync();
                }
                return true;
            }
            catch (Exception ex)
            {
                DW5S.Framework.LogHelper.Error("删除卫星信息异常", ex);
                DxHelper.MsgBoxHelper.ShowError("删除卫星信息异常");
                return false;
            }
        }

        private async void gridView1_DoubleClick(object sender, EventArgs e)
        {
            var editItem = gridView1.GetFocusedRow() as FixedStation;
            if (editItem == null) return;
            await Edit(editItem);
        }
    }
}