XdCxRhDW/XdCxRhDW.App/ExtensionsDev/GridControlEx.cs

using DevExpress.Utils;
using DevExpress.Utils.Menu;
using DevExpress.Utils.Svg;
using DevExpress.XtraBars;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraGrid.Views.Tile;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows.Forms;
public static class GridControlEx
{
    class GridTag
    {
        public GridTag() { }
        public PopupMenu PopupMenu { get; set; }

        public BarManager BarM { get; set; }
    }
    /// <summary>
    /// <para>初始化表格</para>
    /// <para>禁用列菜单、排序、分组、过滤、列拖动等</para>
    /// </summary>
    /// <param name="grid"></param>
    /// <param name="rowHeight"></param>
    /// <param name="showScrollH"></param>
    /// <typeparam name="T">绑定的数据源模型类型</typeparam>
    /// <param name="searchLookUpEdit">searchLookUpEditd控件</param>
    /// <returns></returns>
    public static GridControl Init<T>(this GridControl grid, int rowHeight = 24, bool showScrollH = false, Control searchLookUpEdit = null)
    {
        grid.MainView.BorderStyle = BorderStyles.Flat;
        var view = grid.MainView as GridView;
        view.CustomColumnDisplayText += View_CustomColumnDisplayText;
        view.Appearance.HeaderPanel.TextOptions.HAlignment = HorzAlignment.Center;

        view.Appearance.Row.Options.UseTextOptions = true;
        view.Appearance.Row.TextOptions.HAlignment = HorzAlignment.Center;
        view.OptionsView.ColumnHeaderAutoHeight = DefaultBoolean.True;
        view.RowHeight = rowHeight;
        view.OptionsView.ShowGroupPanel = false;

        view.OptionsBehavior.Editable = false;
        view.OptionsView.ShowDetailButtons = false;
        view.OptionsView.ShowIndicator = false;

        view.OptionsMenu.EnableColumnMenu = true;
        view.OptionsCustomization.AllowFilter = false;
        view.OptionsCustomization.AllowGroup = false;
        view.OptionsCustomization.AllowSort = false;
        view.OptionsCustomization.AllowColumnMoving = true;
        view.OptionsCustomization.AllowMergedGrouping = DefaultBoolean.False;
        view.OptionsSelection.MultiSelect = false;
        view.OptionsCustomization.AllowRowSizing = false;
        view.OptionsCustomization.AllowQuickHideColumns = false;
        view.OptionsMenu.EnableGroupPanelMenu = false;
        view.OptionsMenu.EnableGroupRowMenu = false;
        view.OptionsMenu.EnableFooterMenu = false;
        view.OptionsLayout.StoreAllOptions = true;
        view.OptionsLayout.StoreAppearance = true;
        view.OptionsLayout.StoreDataSettings = true;
        view.OptionsLayout.StoreVisualOptions = true;
        view.OptionsLayout.StoreFormatRules = true;
        view.OptionsView.ColumnAutoWidth = !showScrollH;
        view.PopupMenuShowing += View_PopupMenuShowing;
        view.OptionsSelection.EnableAppearanceFocusedCell = false;
        string GetLayoutName()
        {
            Control ctrl;
            if (searchLookUpEdit != null)
                ctrl = searchLookUpEdit;
            else
                ctrl = grid;
            while (ctrl.Parent != null)
            {
                ctrl = ctrl.Parent;
                if (ctrl is UserControl) break;
            }
            var props = typeof(T).GetProperties();
            StringBuilder sb = new StringBuilder();
            foreach (var item in props)
            {
                sb.Append(item.Name);
            }
            var md5 = MD5Helper.StrToMD5(sb.ToString());
            if (searchLookUpEdit != null)
                return $"{ctrl.Name}_{searchLookUpEdit.Name}_{md5}";
            else
                return $"{ctrl.Name}_{grid.Name}_{md5}";
        }
        string name = GetLayoutName();
        void SaveLayoutAction()
        {
            Form frm = null;
            if (searchLookUpEdit == null)
                frm = grid.FindForm();
            else
                frm = searchLookUpEdit.FindForm();
            if (frm != null)
            {
                frm.VisibleChanged += (sender2, e2) =>
                {
                    Directory.CreateDirectory("Layout");
                    if (name == null) return;
                    grid.MainView?.SaveLayoutToXml($"Layout\\{name}.xml", OptionsLayoutBase.FullLayout);
                };
            }
        }
        if (grid.IsLoaded)
        {
            SaveLayoutAction();
        }
        else
        {
            grid.Load += (sender, e) => SaveLayoutAction();
        }

        if (name != null && File.Exists($"Layout\\{name}.xml"))
        {
            view.RestoreLayoutFromXml($"Layout\\{name}.xml", OptionsLayoutBase.FullLayout);
        }
        view.KeyUp += View_KeyUp;
        grid.Tag = new GridTag();
        return grid;
    }


    public static GridControl UseExportCsv(this GridControl grid)
    {
        GridTag tag = grid.Tag as GridTag;
        if (tag.BarM == null)
        {
            tag.BarM = new BarManager();
            tag.BarM.Form = grid;
        }
        if (tag.PopupMenu == null)
        {
            tag.PopupMenu = new PopupMenu();
        }

        PopupMenu popupMenu = tag.PopupMenu;
        BarButtonItem item = new BarButtonItem();
        item.ItemClick += (sender, e) =>
        {
            SaveFileDialog dialog = new SaveFileDialog();
            dialog.Filter = "csv|*.csv";
            if (dialog.ShowDialog() == DialogResult.OK)
            {
                var view = grid.MainView as GridView;
                view.ExportToCsv(dialog.FileName);
            }
        };
        item.ImageOptions.SvgImage = DxHelper.SvgHelper.CreateExportCsv();
        item.Caption = "导出(CSV)";
        tag.BarM.Items.Add(item);
        popupMenu.AddItem(item);
        popupMenu.Manager = tag.BarM;
        tag.PopupMenu = popupMenu;
        return grid;
    }
    public static GridControl UseExportXlsx(this GridControl grid)
    {
        GridTag tag = grid.Tag as GridTag;
        if (tag.BarM == null)
        {
            tag.BarM = new BarManager();
            tag.BarM.Form = grid;
        }
        if (tag.PopupMenu == null)
        {
            tag.PopupMenu = new PopupMenu();
        }

        PopupMenu popupMenu = tag.PopupMenu;
        BarButtonItem item = new BarButtonItem();
        item.ItemClick += (sender, e) =>
        {
            SaveFileDialog dialog = new SaveFileDialog();
            dialog.Filter = "Excel文件|*.xlsx";
            if (dialog.ShowDialog() == DialogResult.OK)
            {
                var view = grid.MainView as GridView;
                view.ExportToXlsx(dialog.FileName);
            }
        };
        item.ImageOptions.SvgImage = DxHelper.SvgHelper.CreateExportXlsx();
        item.Caption = "导出(Excel)";
        tag.BarM.Items.Add(item);
        popupMenu.AddItem(item);
        popupMenu.Manager = tag.BarM;
        tag.PopupMenu = popupMenu;
        return grid;
    }
    private static void View_KeyUp(object sender, KeyEventArgs e)
    {
        if (e.Control && e.Shift & e.KeyCode == Keys.C)
        {
            var view = sender as GridView;
            if (view.FocusedColumn == null) return;
            var val = view.GetFocusedRowCellDisplayText(view.FocusedColumn);
            if (string.IsNullOrWhiteSpace(val)) return;
            Clipboard.SetText(val);
        }
    }

    private static void View_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
    {
        if (e.Column.ColumnType == typeof(DateTime) || e.Column.ColumnType == typeof(DateTime?))
        {
            if (e.Value == null) return;
            if (e.Column.FieldName == "SigTime")
                e.DisplayText = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd HH:mm:ss.fff");
            else
                e.DisplayText = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd HH:mm:ss");

        }
    }
    public static GridControl ShowColumn(this GridControl grid, params string[] colField)
    {
        var view = grid.MainView as GridView;
        if (view.Columns.Count == 0) return grid;
        if (colField == null || colField.Length == 0) return grid;
        foreach (GridColumn item in view.Columns)
        {
            if (colField.Contains(item.FieldName))
                item.Visible = true;
        }
        return grid;
    }
    public static GridControl UseMultiSelect(this GridControl grid)
    {
        var view = grid.MainView as GridView;
        view.OptionsSelection.MultiSelect = true;
        view.OptionsSelection.MultiSelectMode = GridMultiSelectMode.RowSelect;
        return grid;
    }
    public static GridControl UseSort(this GridControl grid)
    {
        var view = grid.MainView as GridView;
        view.OptionsCustomization.AllowSort = true;
        return grid;
    }

    public static GridControl UseGroup(this GridControl grid)
    {
        var view = grid.MainView as GridView;
        view.OptionsView.GroupFooterShowMode = GroupFooterShowMode.Hidden;
        view.OptionsView.ShowGroupPanel = true;
        view.OptionsCustomization.AllowGroup = true;
        view.OptionsCustomization.AllowSort = true;

        return grid;
    }
    public static GridControl UseFooter(this GridControl grid, Action<object, DevExpress.XtraGrid.Views.Base.RowObjectCustomDrawEventArgs> act)
    {
        var view = grid.MainView as GridView;
        view.OptionsView.ShowFooter = true;
        view.CustomDrawFooter += (s, e) => act(s, e);
        return grid;

    }
    public static GridControl UseFilter(this GridControl grid)
    {
        var view = grid.MainView as GridView;
        view.OptionsCustomization.AllowFilter = true;
        return grid;
    }
    public static GridControl UseEdit(this GridControl grid)
    {
        var view = grid.MainView as GridView;
        view.OptionsBehavior.Editable = true;
        view.OptionsSelection.EnableAppearanceFocusedCell = true;
        foreach (GridColumn item in view.Columns)
        {
            item.OptionsColumn.AllowEdit = false;
        }
        return grid;
    }
    public static GridControl UseRowNumber(this GridControl grid)
    {
        var view = grid.MainView as GridView;
        view.OptionsView.ShowIndicator = true;
        view.CustomDrawRowIndicator += (s, e) =>
        {
            if (!e.Info.IsRowIndicator) return;
            if (e.RowHandle < 0) return;
            e.Handled = true;
            string txt = (e.RowHandle + 1).ToString();
            var txtSize = e.Graphics.MeasureString(txt, e.Appearance.Font);
            if (view.IndicatorWidth < txtSize.Width + 20)
            {
                view.IndicatorWidth++;
            }
            var loc = new PointF(e.Bounds.X + e.Bounds.Width / 2f - txtSize.Width / 2f + 2,
                e.Bounds.Y + e.Bounds.Height / 2f - txtSize.Height / 2f);

            e.Cache.FillRectangle(new SolidBrush(e.Appearance.BackColor), e.Bounds);
            e.Cache.DrawString(txt, e.Appearance.Font, new SolidBrush(e.Appearance.ForeColor), loc);
        };
        view.RowCountChanged += (sender, e) =>
        {
            if (view.RowCount == 0)
                view.IndicatorWidth = -1;
            else
                view.IndicatorWidth = view.RowCount.ToString().Length * 6 + 20;
        };
        return grid;

    }


    public static GridControl HideColumn(this GridControl grid, params string[] colField)
    {

        var view = grid.MainView as GridView;
        if (colField == null || colField.Length == 0) return grid;
        foreach (GridColumn item in view.Columns)
        {
            if (colField.Contains(item.FieldName))
                item.Visible = false;
        }
        return grid;
    }
    private static void View_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e)
    {
        if (e.Menu != null)
        {
            foreach (DXMenuItem item in e.Menu.Items)
            {
                if (!item.Enabled)
                {
                    item.Visible = false;
                    continue;
                }
            }
        }
        if (e.HitInfo.HitTest == DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitTest.EmptyRow)
        {
            return;
        }
        var view = sender as GridView;
        var grid = view.GridControl;
        var p = grid.PointToScreen(e.Point);
        var tag = grid.Tag as GridTag;
        tag?.PopupMenu?.ShowPopup(p);
    }

    public static GridControl AddMenu(this GridControl grid, string menuText, SvgImage meunImage, Action onClick, PopupMenu existMenu = null)
    {
        GridTag tag = grid.Tag as GridTag;
        PopupMenu popupMenu;
        if (existMenu == null)
        {
            if (tag.BarM == null)
            {
                tag.BarM = new BarManager();
                tag.BarM.Form = grid;
            }
            if (tag.PopupMenu == null)
            {
                tag.PopupMenu = new PopupMenu();
            }
            popupMenu = tag.PopupMenu;
        }
        else
        {
            popupMenu = existMenu;
            tag.PopupMenu = existMenu;
            tag.BarM = existMenu.Manager;
        }
        BarButtonItem item = new BarButtonItem();
        item.ItemClick += (sender, e) =>
        {
            item.Enabled = false;
            onClick?.Invoke();
            item.Enabled = true;
        };
        item.ImageOptions.SvgImage = meunImage;
        item.Caption = menuText;
        tag.BarM.Items.Add(item);
        popupMenu.AddItem(item);
        popupMenu.Manager = tag.BarM;
        tag.PopupMenu = popupMenu;
        return grid;
    }
}