XdCxRhDW/XdCxRhDW.App/UserControl/CtrlCgRes.cs

using DevExpress.Data;
using DevExpress.XtraEditors;
using DevExpress.XtraExport.Helpers;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Entity;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Forms;
using XdCxRhDW.App.EFContext;
using XdCxRhDW.App.Model;

namespace XdCxRhDW.App.UserControl
{
    public partial class CtrlCgRes : DevExpress.XtraEditors.XtraUserControl
    {
        public CtrlCgRes()
        {
            InitializeComponent();
        }

        private async void CtrlCgRes_Load(object sender, EventArgs e)
        {
            try
            {
                gridCg.Init().UseSort().UseFilter().UseMultiSelect().UseRowNumber();
                using (RHDWContext db = new RHDWContext())
                {
                    gridCg.DataSource = await db.CgRes.OrderByDescending(p => p.SigTime).ToListAsync();
                }
                gridView1.Columns["SigTime"].SortOrder = ColumnSortOrder.Descending;
            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "查询参估结果异常");
                DxHelper.MsgBoxHelper.ShowError("查询参估结果异常");

            }
        }

        private void gridView1_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e)
        {
            if (gridView1.FocusedRowHandle < 0) return;
            if (!gridView1.GetSelectedRows().Any())
            {
                btnDel.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
            }
            else
            {
                btnDel.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
            }
            popupMenu2.ShowPopup(MousePosition);
        }

        private async void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {
                var ids = gridView1.GetSelectedRows();
                using (RHDWContext db = new RHDWContext())
                {
                    foreach (var id in ids)
                    {
                        var item = gridView1.GetRow(id) as CgRes;
                        var delItem = await db.CgRes.Where(p => p.ID == item.ID).FirstOrDefaultAsync();
                        if (delItem != null)
                        {
                            db.CgRes.Remove(delItem);
                        }
                    }
                    await db.SaveChangesAsync();
                }
                gridView1.DeleteSelectedRows();

            }
            catch (Exception ex)
            {
                Serilog.Log.Error(ex, "删除参估结果异常");
                DxHelper.MsgBoxHelper.ShowError("删除参估结果异常");
            }
        }
    }
}