XdCxRhDW/XdCxRhDW.App/UserControl/CtrlXlCalculate.cs

using DevExpress.XtraEditors;
using XdCxRhDW.App.EFContext;
using XdCxRhDW.App.Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Entity;
using System.Data.Entity.Migrations;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Net.Http;

namespace XdCxRhDW.App.UserControl
{
    public partial class CtrlXlCalculate : DevExpress.XtraEditors.XtraUserControl
    {
        List<XlInfo> list = new List<XlInfo>();
        public CtrlXlCalculate()
        {
            InitializeComponent();
        }
        private async void CtrlXl_Load(object sender, EventArgs e)
        {
            gridXl.Init().UseSort().UseFilter().UseMultiSelect().UseRowNumber();
            //gridXl.DataSource = list;
           // await LoadData();
        }
        private void btnOpen_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (xtraOpenFileDialog1.ShowDialog() == DialogResult.OK)
            {
                btnOpen.Text = xtraOpenFileDialog1.FileName;
            }
        }


        private async void btnImp_Click(object sender, EventArgs e)
        {
          

        }

        private async void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {
                this.Enabled = false;
                await Task.Run(async () =>
                {
                    var ids = gridView1.GetSelectedRows();
                    List<int> listID = new List<int>();
                    foreach (var idx in ids)
                    {
                        var id = (gridView1.GetRow(idx) as XlInfo).ID;
                        listID.Add(id);
                    }
                    using (RHDWContext db = new RHDWContext())
                    {
                        var delItems = await db.XlInfos.Where(p => listID.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.Enabled = true;
            }
        }

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