| | |
| | | using System.Text.RegularExpressions; |
| | | using System.Windows.Forms; |
| | | using System.Windows.Forms.VisualStyles; |
| | | using UserControls.Data; |
| | | using static System.Windows.Forms.Control; |
| | | |
| | | |
| | |
| | | /// <param name="action2">委托2</param> |
| | | public static void SetGridViewParameter(GridView gridView1, PictureBox picCheckBox = null, Form fm = null, string fileName = "checkStatus", string icoName = "", DelegateGetModel action = null, DevExpress.Utils.ToolTipController tips = null, bool isPostSearch = true, DelegateGetModel action2 = null) |
| | | { |
| | | gridView1.PopupMenuShowing += (s, e) => |
| | | { |
| | | if (e.MenuType == DevExpress.XtraGrid.Views.Grid.GridMenuType.Column) |
| | | { |
| | | GridViewColumnMenu menu = e.Menu as GridViewColumnMenu; |
| | | if (menu != null) |
| | | { |
| | | string[] ary = { "Column Chooser", "Hide This Column", "Clear All Sorting", "Clear Sorting", "Sort Descending", "Sort Ascending", "Best Fit (all columns)" }; |
| | | for (int i = menu.Items.Count - 1; i >= 0; i--) |
| | | { |
| | | string _caption = menu.Items[i].Caption; |
| | | if (!ary.Contains(_caption)) |
| | | { |
| | | menu.Items.Remove(menu.Items[i]); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | //2025-11-06 cnf 引入中文插件注 |
| | | /* gridView1.PopupMenuShowing += (s, e) => |
| | | { |
| | | if (e.MenuType == DevExpress.XtraGrid.Views.Grid.GridMenuType.Column) |
| | | { |
| | | GridViewColumnMenu menu = e.Menu as GridViewColumnMenu; |
| | | if (menu != null) |
| | | { |
| | | string[] ary = { "Column Chooser", "Hide This Column", "Clear All Sorting", "Clear Sorting", "Sort Descending", "Sort Ascending", "Best Fit (all columns)" }; |
| | | for (int i = menu.Items.Count - 1; i >= 0; i--) |
| | | { |
| | | string _caption = menu.Items[i].Caption; |
| | | if (!ary.Contains(_caption)) |
| | | { |
| | | menu.Items.Remove(menu.Items[i]); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | };*/ |
| | | gridView1.OptionsView.ColumnAutoWidth = false;//自动调整列宽 |
| | | if (isPostSearch == true) |
| | | { |
| | |
| | | /// <param name="icoName"></param> |
| | | public static void SetGridViewParameterMx(GridView gridView1, DevExpress.Utils.ToolTipController tips = null) |
| | | { |
| | | gridView1.PopupMenuShowing += (s, e) => |
| | | { |
| | | if (e.MenuType == DevExpress.XtraGrid.Views.Grid.GridMenuType.Column) |
| | | { |
| | | GridViewColumnMenu menu = e.Menu as GridViewColumnMenu; |
| | | if (menu != null) |
| | | { |
| | | string[] ary = { "Column Chooser", "Hide This Column", "Clear All Sorting", "Clear Sorting", "Sort Descending", "Sort Ascending", "Best Fit (all columns)" }; |
| | | for (int i = menu.Items.Count - 1; i >= 0; i--) |
| | | { |
| | | string _caption = menu.Items[i].Caption; |
| | | if (!ary.Contains(_caption)) |
| | | { |
| | | menu.Items.Remove(menu.Items[i]); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | gridView1.OptionsView.ShowGroupPanel = false; |
| | | gridView1.OptionsCustomization.AllowGroup = false; |
| | | //2025-11-06 cnf 注 |
| | | /* gridView1.PopupMenuShowing += (s, e) => |
| | | { |
| | | if (e.MenuType == DevExpress.XtraGrid.Views.Grid.GridMenuType.Column) |
| | | { |
| | | GridViewColumnMenu menu = e.Menu as GridViewColumnMenu; |
| | | if (menu != null) |
| | | { |
| | | string[] ary = { "Column Chooser", "Hide This Column", "Clear All Sorting", "Clear Sorting", "Sort Descending", "Sort Ascending", "Best Fit (all columns)" }; |
| | | for (int i = menu.Items.Count - 1; i >= 0; i--) |
| | | { |
| | | string _caption = menu.Items[i].Caption; |
| | | if (!ary.Contains(_caption)) |
| | | { |
| | | menu.Items.Remove(menu.Items[i]); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | gridView1.OptionsView.ShowGroupPanel = false; |
| | | gridView1.OptionsCustomization.AllowGroup = false;*/ |
| | | |
| | | // gridView1.OptionsView.Alignment = DataGridViewContentAlignment.MiddleLeft; |
| | | foreach (GridColumn column in gridView1.Columns) |
| | |
| | | } |
| | | |
| | | |
| | | #region GridView汇总配置工具方法 |
| | | /// <summary> |
| | | /// 2025-08-14 kyy 快速配置GridView底部汇总(启用汇总行+设置列求和汇总) |
| | | /// </summary> |
| | | /// <param name="gridView">目标GridView控件</param> |
| | | /// <param name="summaryColumns">需要进行求和汇总的列名数组</param> |
| | | public static void SetupGridSummary(DevExpress.XtraGrid.Views.Grid.GridView gridView, params string[] summaryColumns) |
| | | { |
| | | // 启用底部汇总行 |
| | | gridView.OptionsView.ShowFooter = true; |
| | | |
| | | // 为每个指定列设置求和汇总 |
| | | foreach (var columnName in summaryColumns) |
| | | { |
| | | // 验证列是否存在(避免异常) |
| | | if (gridView.Columns[columnName] != null) |
| | | { |
| | | gridView.Columns[columnName].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; |
| | | gridView.Columns[columnName].SummaryItem.DisplayFormat = "合计: {0}"; |
| | | } |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 数据过滤 |
| | | /// </summary> |