GridControlEx.cs 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968
  1. using DevExpress.Utils;
  2. using DevExpress.Utils.Helpers;
  3. using DevExpress.Utils.Menu;
  4. using DevExpress.Utils.Paint;
  5. using DevExpress.Utils.Svg;
  6. using DevExpress.XtraBars;
  7. using DevExpress.XtraEditors;
  8. using DevExpress.XtraEditors.Controls;
  9. using DevExpress.XtraGrid;
  10. using DevExpress.XtraGrid.Columns;
  11. using DevExpress.XtraGrid.Views.Grid;
  12. using DxHelper;
  13. using System;
  14. using System.Collections.Generic;
  15. using System.Drawing;
  16. using System.IO;
  17. using System.Linq;
  18. using System.Text;
  19. using System.Threading.Tasks;
  20. using System.Windows.Forms;
  21. public static class GridControlEx
  22. {
  23. internal class GridTag
  24. {
  25. public GridTag() { }
  26. public PopupMenu PopupMenu { get; set; }
  27. public BarManager BarM { get; set; }
  28. public List<BarButtonItem> RowButtonsItems { get; set; } = new List<BarButtonItem>();
  29. public List<BarButtonItem> MultRowButtonsItems { get; set; } = new List<BarButtonItem>();
  30. }
  31. /// <summary>
  32. /// 初始化表格(默认禁用分组)
  33. /// </summary>
  34. /// <param name="grid"></param>
  35. /// <param name="dataSource">绑定的数据源</param>
  36. /// <param name="rowHeight">行高(默认24px)</param>
  37. /// <param name="showScrollH">是否显示水平滚动条(默认不显示)</param>
  38. /// <typeparam name="T">绑定的数据源模型类型</typeparam>
  39. /// <returns></returns>
  40. public static GridControl UseDefault<T>(this GridControl grid, List<T> dataSource, int rowHeight = 24, bool showScrollH = false)
  41. {
  42. grid.DataSource = dataSource;
  43. grid.MainView.BorderStyle = BorderStyles.Flat;
  44. var view = grid.MainView as GridView;
  45. view.CustomColumnDisplayText += View_CustomColumnDisplayText;
  46. view.Appearance.HeaderPanel.TextOptions.HAlignment = HorzAlignment.Center;
  47. view.Appearance.Row.Options.UseTextOptions = true;
  48. view.Appearance.Row.TextOptions.HAlignment = HorzAlignment.Center;
  49. view.OptionsView.ColumnHeaderAutoHeight = DefaultBoolean.True;
  50. view.RowHeight = rowHeight;
  51. view.OptionsView.ShowGroupPanel = false;
  52. view.OptionsBehavior.Editable = false;
  53. view.OptionsView.ShowDetailButtons = false;
  54. view.OptionsView.ShowIndicator = false;
  55. view.OptionsMenu.EnableColumnMenu = true;
  56. view.OptionsCustomization.AllowFilter = true;
  57. view.OptionsCustomization.AllowGroup = false;
  58. view.OptionsCustomization.AllowSort = true;
  59. view.OptionsCustomization.AllowColumnMoving = true;
  60. view.OptionsCustomization.AllowMergedGrouping = DefaultBoolean.False;
  61. view.OptionsSelection.MultiSelect = false;
  62. view.OptionsCustomization.AllowRowSizing = false;
  63. view.OptionsCustomization.AllowQuickHideColumns = false;
  64. view.OptionsMenu.EnableGroupPanelMenu = false;
  65. view.OptionsMenu.EnableGroupRowMenu = false;
  66. view.OptionsMenu.EnableFooterMenu = false;
  67. view.OptionsLayout.StoreAllOptions = true;
  68. view.OptionsLayout.StoreAppearance = true;
  69. view.OptionsLayout.StoreDataSettings = true;
  70. view.OptionsLayout.StoreVisualOptions = true;
  71. view.OptionsLayout.StoreFormatRules = true;
  72. view.OptionsView.ColumnAutoWidth = !showScrollH;
  73. view.PopupMenuShowing += View_PopupMenuShowing;
  74. view.OptionsSelection.EnableAppearanceFocusedCell = false;
  75. string GetLayoutName()
  76. {
  77. Control ctrl;
  78. if (view.Tag is SearchLookUpEdit searchLookUpEdit)
  79. ctrl = searchLookUpEdit;
  80. else
  81. ctrl = grid;
  82. while (ctrl.Parent != null)
  83. {
  84. ctrl = ctrl.Parent;
  85. if (ctrl is UserControl) break;
  86. }
  87. var props = typeof(T).GetProperties();
  88. StringBuilder sb = new StringBuilder();
  89. foreach (var item in props)
  90. {
  91. sb.Append(item.Name);
  92. }
  93. var md5 = MD5Helper.StrToMD5(sb.ToString());
  94. if (view.Tag is SearchLookUpEdit searchLookUpEdit2)
  95. return $"{ctrl.Name}_{searchLookUpEdit2.Name}_{md5}";
  96. else
  97. return $"{ctrl.Name}_{grid.Name}_{md5}";
  98. }
  99. string name = GetLayoutName();
  100. void SaveLayoutAction()
  101. {
  102. Form frm = null;
  103. if (view.Tag is SearchLookUpEdit edit)
  104. frm = edit.FindForm();
  105. else
  106. frm = grid.FindForm();
  107. if (frm != null)
  108. {
  109. frm.VisibleChanged += (sender2, e2) =>
  110. {
  111. Directory.CreateDirectory("Layout");
  112. if (name == null) return;
  113. grid.MainView?.SaveLayoutToXml($"Layout\\{name}.xml", OptionsLayoutBase.FullLayout);
  114. };
  115. }
  116. }
  117. if (grid.IsLoaded)
  118. {
  119. SaveLayoutAction();
  120. }
  121. else
  122. {
  123. grid.Load += (sender, e) => SaveLayoutAction();
  124. }
  125. if (name != null && File.Exists($"Layout\\{name}.xml"))
  126. {
  127. view.RestoreLayoutFromXml($"Layout\\{name}.xml", OptionsLayoutBase.FullLayout);
  128. view.ClearColumnsFilter();
  129. view.ClearFindFilter();
  130. view.ClearInHeaderSearchText();
  131. view.ClearSorting();
  132. view.ClearSelection();
  133. }
  134. view.KeyUp += View_KeyUp;
  135. grid.Tag = new GridTag();
  136. return grid;
  137. }
  138. /// <summary>
  139. /// 为GirdControl启用右键新增数据的功能
  140. /// </summary>
  141. /// <param name="grid"></param>
  142. /// <param name="emptyText"></param>
  143. /// <returns></returns>
  144. public static GridControl UseEmptyText(this GridControl grid, string emptyText = "暂无数据")
  145. {
  146. if (string.IsNullOrWhiteSpace(emptyText)) return grid;
  147. var view = grid.MainView as GridView;
  148. view.CustomDrawEmptyForeground += (sender, e) =>
  149. {
  150. var s = e.Appearance.CalcTextSize(e.Cache, emptyText, e.Bounds.Width).ToSize();
  151. var x = (e.Bounds.Width - s.Width) / 2;
  152. var y = (e.Bounds.Height - s.Height) / 2;
  153. e.Appearance.ForeColor = Color.Gray;
  154. e.Appearance.DrawString(e.Cache, emptyText, new Rectangle(x, y, s.Width, s.Height));
  155. };
  156. return grid;
  157. }
  158. /// <summary>
  159. /// 为GirdControl启用右键新增数据的功能
  160. /// </summary>
  161. /// <typeparam name="T"></typeparam>
  162. /// <param name="grid"></param>
  163. /// <param name="menuCaption"></param>
  164. /// <param name="callback">一个回调函数,返回新增的数据</param>
  165. /// <returns></returns>
  166. public static GridControl UseAdd<T>(this GridControl grid, Func<T> callback, string menuCaption = "新增")
  167. {
  168. var view = grid.MainView as GridView;
  169. view.CustomDrawEmptyForeground += (sender, e) =>
  170. {
  171. string emptyText = "右键添加";
  172. var s = e.Appearance.CalcTextSize(e.Cache, emptyText, e.Bounds.Width).ToSize();
  173. var x = (e.Bounds.Width - s.Width) / 2;
  174. var y = (e.Bounds.Height - s.Height) / 2;
  175. e.Appearance.ForeColor = Color.Gray;
  176. e.Appearance.DrawString(e.Cache, emptyText, new Rectangle(x, y, s.Width, s.Height));
  177. };
  178. grid.AddContentMenu<T>(menuCaption, DxHelper.SvgHelper.CreateAdd(), data =>
  179. {
  180. if (callback != null)
  181. {
  182. var addRow = callback();
  183. if (addRow == null) return;
  184. var ds = grid.DataSource as List<T>;
  185. ds.Add(addRow);
  186. view.RefreshData();
  187. }
  188. }, true);
  189. return grid;
  190. }
  191. /// <summary>
  192. /// 为GirdControl启用右键新增数据的功能
  193. /// </summary>
  194. /// <typeparam name="T"></typeparam>
  195. /// <param name="grid"></param>
  196. /// <param name="menuCaption"></param>
  197. /// <param name="callback">一个回调函数,返回新增的数据</param>
  198. /// <returns></returns>
  199. public static GridControl UseAddAsync<T>(this GridControl grid, Func<Task<T>> callback, string menuCaption = "新增")
  200. {
  201. grid.AddContentMenuAsync<T>(menuCaption, DxHelper.SvgHelper.CreateAdd(), async data =>
  202. {
  203. if (callback != null)
  204. {
  205. var addRow = await callback();
  206. if (addRow == null) return;
  207. var view = grid.MainView as GridView;
  208. var ds = grid.DataSource as List<T>;
  209. ds.Add(addRow);
  210. view.RefreshData();
  211. }
  212. }, true);
  213. return grid;
  214. }
  215. /// <summary>
  216. /// 为GridControl启用右编辑选中的单行功能
  217. /// </summary>
  218. /// <typeparam name="T"></typeparam>
  219. /// <param name="grid"></param>
  220. /// <param name="menuCaption"></param>
  221. /// <param name="callback"></param>
  222. /// <returns></returns>
  223. public static GridControl UseEdit<T>(this GridControl grid, Func<T, T> callback, string menuCaption = "编辑")
  224. {
  225. grid.AddRowMenu<T>(menuCaption, DxHelper.SvgHelper.CreateEdit(), data =>
  226. {
  227. if (callback != null)
  228. {
  229. var newRow = callback(data);
  230. if (newRow == null) return;
  231. var view = grid.MainView as GridView;
  232. var ds = grid.DataSource as List<T>;
  233. var idx = ds.IndexOf(data);
  234. ds.Remove(data);
  235. ds.Insert(idx, newRow);
  236. view.RefreshData();
  237. }
  238. }, null);
  239. return grid;
  240. }
  241. /// <summary>
  242. /// 为GridControl启用右编辑选中的单行功能
  243. /// </summary>
  244. /// <typeparam name="T"></typeparam>
  245. /// <param name="grid"></param>
  246. /// <param name="menuCaption"></param>
  247. /// <param name="callback"></param>
  248. /// <returns></returns>
  249. public static GridControl UseEditAsync<T>(this GridControl grid, Func<T, Task<T>> callback, string menuCaption = "编辑")
  250. {
  251. grid.AddRowMenu<T>(menuCaption, DxHelper.SvgHelper.CreateEdit(), async data =>
  252. {
  253. if (callback != null)
  254. {
  255. var newRow = await callback(data);
  256. if (newRow == null) return;
  257. var view = grid.MainView as GridView;
  258. var ds = grid.DataSource as List<T>;
  259. var idx = ds.IndexOf(data);
  260. ds.Remove(data);
  261. ds.Insert(idx, newRow);
  262. view.RefreshData();
  263. }
  264. }, null);
  265. return grid;
  266. }
  267. /// <summary>
  268. /// 为GridControl启用右删除选中的一行或多行功能(自动启用UseMultiSelect)
  269. /// </summary>
  270. /// <typeparam name="T"></typeparam>
  271. /// <param name="grid"></param>
  272. /// <param name="menuCaption"></param>
  273. /// <param name="action"></param>
  274. /// <returns></returns>
  275. public static GridControl UseDelete<T>(this GridControl grid, Func<List<T>, bool> action = null, string menuCaption = "删除")
  276. {
  277. grid.AddMultRowMenu<T>(menuCaption, DxHelper.SvgHelper.CreateClose(), data =>
  278. {
  279. if (!DxHelper.MsgBoxHelper.ShowConfirm($"确认删除选中的记录?共[{data.Count}]条")) return;
  280. if (action != null)
  281. {
  282. bool succeed = action(data);
  283. if (!succeed) return;
  284. }
  285. var view = grid.MainView as GridView;
  286. view.DeleteSelectedRows();
  287. view.RefreshData();
  288. });
  289. return grid;
  290. }
  291. /// <summary>
  292. /// 为GridControl启用右删除选中的一行或多行功能(自动启用UseMultiSelect)
  293. /// </summary>
  294. /// <typeparam name="T"></typeparam>
  295. /// <param name="grid"></param>
  296. /// <param name="menuCaption"></param>
  297. /// <param name="action"></param>
  298. /// <returns></returns>
  299. public static GridControl UseDeleteAsync<T>(this GridControl grid, Func<List<T>, Task<bool>> action = null, string menuCaption = "删除")
  300. {
  301. grid.AddMultRowMenu<T>(menuCaption, DxHelper.SvgHelper.CreateClose(), async data =>
  302. {
  303. if (!DxHelper.MsgBoxHelper.ShowConfirm($"确认删除选中的记录?共[{data.Count()}]条")) return;
  304. if (action != null)
  305. {
  306. bool succeed = await action(data);
  307. if (!succeed) return;
  308. }
  309. var view = grid.MainView as GridView;
  310. view.DeleteSelectedRows();
  311. view.RefreshData();
  312. });
  313. return grid;
  314. }
  315. /// <summary>
  316. /// 为GirdControl启用右键清除所有数据的功能
  317. /// </summary>
  318. /// <typeparam name="T"></typeparam>
  319. /// <param name="grid"></param>
  320. /// <param name="menuCaption"></param>
  321. /// <param name="action"></param>
  322. /// <returns></returns>
  323. public static GridControl UseClear<T>(this GridControl grid, Func<List<T>, bool> action = null, string menuCaption = "清除")
  324. {
  325. grid.AddContentMenu<T>(menuCaption, DxHelper.SvgHelper.CreateClear(), data =>
  326. {
  327. if (data == null || data.Count == 0) return;
  328. if (!DxHelper.MsgBoxHelper.ShowConfirm($"确认清空所有记录?共[{data.Count}]条")) return;
  329. if (action != null)
  330. {
  331. bool succeed = action(data);
  332. if (!succeed) return;
  333. }
  334. var view = grid.MainView as GridView;
  335. data.Clear();
  336. view.RefreshData();
  337. }, false);
  338. return grid;
  339. }
  340. /// <summary>
  341. /// 为GirdControl启用右键清除所有数据的功能
  342. /// </summary>
  343. /// <typeparam name="T"></typeparam>
  344. /// <param name="grid"></param>
  345. /// <param name="menuCaption"></param>
  346. /// <param name="action"></param>
  347. /// <returns></returns>
  348. public static GridControl UseClearAsync<T>(this GridControl grid, Func<List<T>, Task<bool>> action = null, string menuCaption = "清除")
  349. {
  350. grid.AddContentMenu<T>(menuCaption, DxHelper.SvgHelper.CreateClear(), async data =>
  351. {
  352. if (data == null || data.Count == 0) return;
  353. if (!DxHelper.MsgBoxHelper.ShowConfirm($"确认清空所有记录?共[{data.Count}]条")) return;
  354. if (action != null)
  355. {
  356. bool succeed = await action(data);
  357. if (!succeed) return;
  358. }
  359. var view = grid.MainView as GridView;
  360. data.Clear();
  361. view.RefreshData();
  362. }, false);
  363. return grid;
  364. }
  365. public static GridControl UseExportCsv(this GridControl grid)
  366. {
  367. GridTag tag = grid.Tag as GridTag;
  368. if (tag.BarM == null)
  369. {
  370. tag.BarM = new BarManager();
  371. tag.BarM.Form = grid;
  372. }
  373. if (tag.PopupMenu == null)
  374. {
  375. tag.PopupMenu = new PopupMenu();
  376. }
  377. PopupMenu popupMenu = tag.PopupMenu;
  378. BarButtonItem item = new BarButtonItem();
  379. item.ItemClick += (sender, e) =>
  380. {
  381. SaveFileDialog dialog = new SaveFileDialog();
  382. dialog.Filter = "csv|*.csv";
  383. if (dialog.ShowDialog() == DialogResult.OK)
  384. {
  385. var view = grid.MainView as GridView;
  386. view.ExportToCsv(dialog.FileName);
  387. }
  388. };
  389. item.ImageOptions.SvgImage = DxHelper.SvgHelper.CreateExportCsv();
  390. item.Caption = "导出(CSV)";
  391. tag.BarM.Items.Add(item);
  392. popupMenu.AddItem(item);
  393. popupMenu.Manager = tag.BarM;
  394. tag.PopupMenu = popupMenu;
  395. return grid;
  396. }
  397. public static GridControl UseExportXlsx(this GridControl grid)
  398. {
  399. GridTag tag = grid.Tag as GridTag;
  400. if (tag.BarM == null)
  401. {
  402. tag.BarM = new BarManager();
  403. tag.BarM.Form = grid;
  404. }
  405. if (tag.PopupMenu == null)
  406. {
  407. tag.PopupMenu = new PopupMenu();
  408. }
  409. PopupMenu popupMenu = tag.PopupMenu;
  410. BarButtonItem item = new BarButtonItem();
  411. item.ItemClick += (sender, e) =>
  412. {
  413. SaveFileDialog dialog = new SaveFileDialog();
  414. dialog.Filter = "Excel文件|*.xlsx";
  415. if (dialog.ShowDialog() == DialogResult.OK)
  416. {
  417. var view = grid.MainView as GridView;
  418. view.ExportToXlsx(dialog.FileName);
  419. }
  420. };
  421. item.ImageOptions.SvgImage = DxHelper.SvgHelper.CreateExportXlsx();
  422. item.Caption = "导出(Excel)";
  423. tag.BarM.Items.Add(item);
  424. popupMenu.AddItem(item);
  425. popupMenu.Manager = tag.BarM;
  426. tag.PopupMenu = popupMenu;
  427. return grid;
  428. }
  429. private static void View_KeyUp(object sender, KeyEventArgs e)
  430. {
  431. if (e.Control && e.Shift & e.KeyCode == Keys.C)
  432. {
  433. var view = sender as GridView;
  434. if (view.FocusedColumn == null) return;
  435. var val = view.GetFocusedRowCellDisplayText(view.FocusedColumn);
  436. if (string.IsNullOrWhiteSpace(val)) return;
  437. Clipboard.SetText(val);
  438. }
  439. }
  440. private static void View_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
  441. {
  442. if (e.Column.ColumnType == typeof(DateTime) || e.Column.ColumnType == typeof(DateTime?))
  443. {
  444. if (e.Value == null) return;
  445. if (e.Column.FieldName == "SigTime")
  446. e.DisplayText = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd HH:mm:ss.fff");
  447. else
  448. e.DisplayText = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd HH:mm:ss");
  449. }
  450. }
  451. public static GridControl ShowColumn(this GridControl grid, params string[] colField)
  452. {
  453. var view = grid.MainView as GridView;
  454. if (view.Columns.Count == 0) return grid;
  455. if (colField == null || colField.Length == 0) return grid;
  456. foreach (GridColumn item in view.Columns)
  457. {
  458. if (colField.Contains(item.FieldName))
  459. item.Visible = true;
  460. }
  461. return grid;
  462. }
  463. public static GridControl UseMultiSelect(this GridControl grid)
  464. {
  465. var view = grid.MainView as GridView;
  466. view.OptionsSelection.MultiSelect = true;
  467. view.OptionsSelection.MultiSelectMode = GridMultiSelectMode.RowSelect;
  468. return grid;
  469. }
  470. public static GridControl UseGroup(this GridControl grid)
  471. {
  472. var view = grid.MainView as GridView;
  473. view.OptionsView.GroupFooterShowMode = GroupFooterShowMode.Hidden;
  474. view.OptionsView.ShowGroupPanel = true;
  475. view.OptionsCustomization.AllowGroup = true;
  476. view.OptionsCustomization.AllowSort = true;
  477. return grid;
  478. }
  479. public static GridControl UseFooter(this GridControl grid, Action<object, DevExpress.XtraGrid.Views.Base.RowObjectCustomDrawEventArgs> act)
  480. {
  481. var view = grid.MainView as GridView;
  482. view.OptionsView.ShowFooter = true;
  483. view.CustomDrawFooter += (s, e) => act(s, e);
  484. return grid;
  485. }
  486. public static GridControl UseEdit(this GridControl grid)
  487. {
  488. var view = grid.MainView as GridView;
  489. view.OptionsBehavior.Editable = true;
  490. view.OptionsSelection.EnableAppearanceFocusedCell = true;
  491. foreach (GridColumn item in view.Columns)
  492. {
  493. item.OptionsColumn.AllowEdit = false;
  494. }
  495. return grid;
  496. }
  497. public static GridControl UseRowNumber(this GridControl grid)
  498. {
  499. var view = grid.MainView as GridView;
  500. view.OptionsView.ShowIndicator = true;
  501. view.CustomDrawRowIndicator += (s, e) =>
  502. {
  503. if (!e.Info.IsRowIndicator) return;
  504. if (e.RowHandle < 0) return;
  505. e.Handled = true;
  506. string txt = (e.RowHandle + 1).ToString();
  507. var txtSize = e.Graphics.MeasureString(txt, e.Appearance.Font);
  508. if (view.IndicatorWidth < txtSize.Width + 20)
  509. {
  510. view.IndicatorWidth++;
  511. }
  512. var loc = new PointF(e.Bounds.X + e.Bounds.Width / 2f - txtSize.Width / 2f + 2,
  513. e.Bounds.Y + e.Bounds.Height / 2f - txtSize.Height / 2f);
  514. e.Cache.FillRectangle(new SolidBrush(e.Appearance.BackColor), e.Bounds);
  515. e.Cache.DrawString(txt, e.Appearance.Font, new SolidBrush(e.Appearance.ForeColor), loc);
  516. };
  517. view.RowCountChanged += (sender, e) =>
  518. {
  519. if (view.RowCount == 0)
  520. view.IndicatorWidth = -1;
  521. else
  522. view.IndicatorWidth = view.RowCount.ToString().Length * 6 + 20;
  523. };
  524. return grid;
  525. }
  526. public static GridControl UseNullValueText(this GridControl grid, string nullText = "--")
  527. {
  528. var view = grid.MainView as GridView;
  529. view.CustomColumnDisplayText += (sender, e) =>
  530. {
  531. if (e.Value == null) e.DisplayText = nullText;
  532. };
  533. return grid;
  534. }
  535. public static GridControl SetDisplayText(this GridControl grid, string columnFieldName, Func<object, string> action)
  536. {
  537. var view = grid.MainView as GridView;
  538. view.CustomColumnDisplayText += (sender, e) =>
  539. {
  540. if (e.Column.FieldName != columnFieldName) return;
  541. if (e.Value == null || action == null) return;
  542. e.DisplayText = action(e.Value);
  543. };
  544. return grid;
  545. }
  546. public static GridControl HideColumn(this GridControl grid, params string[] colField)
  547. {
  548. var view = grid.MainView as GridView;
  549. if (colField == null || colField.Length == 0) return grid;
  550. foreach (GridColumn item in view.Columns)
  551. {
  552. if (colField.Contains(item.FieldName))
  553. item.Visible = false;
  554. }
  555. return grid;
  556. }
  557. /// <summary>
  558. /// GridControl添加单行元素选择后的右键菜单
  559. /// </summary>
  560. /// <typeparam name="T">GridControl绑定数据源的泛型类型</typeparam>
  561. /// <param name="grid">GridControl控件</param>
  562. /// <param name="menuText">菜单标题</param>
  563. /// <param name="meunImage">菜单图标</param>
  564. /// <param name="action">菜单要执行的事件函数,参数为选中的单行元素</param>
  565. /// <param name="showCondition">菜单显示的条件</param>
  566. /// <returns></returns>
  567. public static GridControl AddRowMenu<T>(this GridControl grid, string menuText, SvgImage meunImage,
  568. Action<T> action, Func<T, bool> showCondition = null)
  569. {
  570. GridTag tag = grid.Tag as GridTag;
  571. var view = grid.MainView as GridView;
  572. if (tag.BarM == null)
  573. {
  574. tag.BarM = new BarManager();
  575. tag.BarM.Form = grid;
  576. }
  577. if (tag.PopupMenu == null)
  578. {
  579. tag.PopupMenu = new PopupMenu();
  580. }
  581. var popupMenu = tag.PopupMenu;
  582. BarButtonItem item = new BarButtonItem();
  583. tag.RowButtonsItems.Add(item);
  584. Func<bool> showConditionAll = () =>
  585. {
  586. if (!view.GetSelectedRows().Any()) return false;
  587. if (showCondition == null)
  588. return true;
  589. else
  590. return showCondition((T)view.GetFocusedRow());
  591. };
  592. item.Tag = showConditionAll;
  593. var handle = new ItemClickEventHandler((sender, e) =>
  594. {
  595. if (action != null)
  596. {
  597. if (view.GetFocusedRow() == null) return;
  598. item.Enabled = false;
  599. action.Invoke((T)view.GetFocusedRow());
  600. item.Enabled = true;
  601. }
  602. });
  603. item.Events().AddHandler(menuText, handle);
  604. item.ItemClick += handle;
  605. item.ImageOptions.SvgImage = meunImage;
  606. item.Caption = menuText;
  607. tag.BarM.Items.Add(item);
  608. popupMenu.AddItem(item);
  609. popupMenu.Manager = tag.BarM;
  610. tag.PopupMenu = popupMenu;
  611. return grid;
  612. }
  613. /// <summary>
  614. /// GridControl添加单行元素选择后的右键菜单
  615. /// </summary>
  616. /// <typeparam name="T">GridControl绑定数据源的泛型类型</typeparam>
  617. /// <param name="grid">GridControl控件</param>
  618. /// <param name="menuText">菜单标题</param>
  619. /// <param name="meunImage">菜单图标</param>
  620. /// <param name="action">菜单要执行的异步事件函数,参数为选中的单行元素</param>
  621. /// <param name="showCondition">菜单显示的条件</param>
  622. /// <returns></returns>
  623. public static GridControl AddRowMenuAsync<T>(this GridControl grid, string menuText, SvgImage meunImage,
  624. Func<T, Task> action, Func<T, bool> showCondition = null)
  625. {
  626. GridTag tag = grid.Tag as GridTag;
  627. var view = grid.MainView as GridView;
  628. if (tag.BarM == null)
  629. {
  630. tag.BarM = new BarManager();
  631. tag.BarM.Form = grid;
  632. }
  633. if (tag.PopupMenu == null)
  634. {
  635. tag.PopupMenu = new PopupMenu();
  636. }
  637. var popupMenu = tag.PopupMenu;
  638. BarButtonItem item = new BarButtonItem();
  639. tag.RowButtonsItems.Add(item);
  640. Func<bool> showConditionAll = () =>
  641. {
  642. if (!view.GetSelectedRows().Any()) return false;
  643. if (showCondition == null)
  644. return true;
  645. else
  646. return showCondition((T)view.GetFocusedRow());
  647. };
  648. item.Tag = showConditionAll;
  649. var handle = new ItemClickEventHandler(async (sender, e) =>
  650. {
  651. if (action != null)
  652. {
  653. if (view.GetFocusedRow() == null) return;
  654. item.Enabled = false;
  655. await action.Invoke((T)view.GetFocusedRow());
  656. item.Enabled = true;
  657. }
  658. });
  659. item.Events().AddHandler(menuText, handle);
  660. item.ItemClick += handle;
  661. item.ImageOptions.SvgImage = meunImage;
  662. item.Caption = menuText;
  663. tag.BarM.Items.Add(item);
  664. popupMenu.AddItem(item);
  665. popupMenu.Manager = tag.BarM;
  666. tag.PopupMenu = popupMenu;
  667. return grid;
  668. }
  669. /// <summary>
  670. /// GridControl添加多行选择元素的右键菜单(自动启用UseMultiSelect)
  671. /// </summary>
  672. /// <typeparam name="T">GridControl绑定数据源的泛型类型</typeparam>
  673. /// <param name="grid">GridControl控件</param>
  674. /// <param name="menuText">菜单标题</param>
  675. /// <param name="meunImage">菜单图标</param>
  676. /// <param name="action">菜单要执行的事件,参数为选中的一行或多行元素</param>
  677. /// <returns></returns>
  678. public static GridControl AddMultRowMenu<T>(this GridControl grid, string menuText, SvgImage meunImage,
  679. Action<List<T>> action)
  680. {
  681. grid.UseMultiSelect();
  682. GridTag tag = grid.Tag as GridTag;
  683. var view = grid.MainView as GridView;
  684. if (tag.BarM == null)
  685. {
  686. tag.BarM = new BarManager();
  687. tag.BarM.Form = grid;
  688. }
  689. if (tag.PopupMenu == null)
  690. {
  691. tag.PopupMenu = new PopupMenu();
  692. }
  693. var popupMenu = tag.PopupMenu;
  694. BarButtonItem item = new BarButtonItem();
  695. var handle = new ItemClickEventHandler((sender, e) =>
  696. {
  697. if (action != null)
  698. {
  699. var rows = view.GetSelectedRows();
  700. List<T> list = new List<T>();
  701. foreach (var row in rows)
  702. {
  703. if (row < 0) continue;
  704. list.Add((T)view.GetRow(row));
  705. }
  706. if (list.Any())
  707. action.Invoke(list);
  708. }
  709. });
  710. item.Events().AddHandler(menuText, handle);
  711. item.ItemClick += handle;
  712. item.ImageOptions.SvgImage = meunImage;
  713. item.Caption = menuText;
  714. Func<bool> showCondition = () => view.GetSelectedRows().Any();
  715. item.Tag = showCondition;
  716. tag.BarM.Items.Add(item);
  717. popupMenu.AddItem(item);
  718. popupMenu.Manager = tag.BarM;
  719. tag.PopupMenu = popupMenu;
  720. return grid;
  721. }
  722. /// <summary>
  723. /// GridControl添加多行选择元素的右键菜单(自动启用UseMultiSelect)
  724. /// </summary>
  725. /// <typeparam name="T">GridControl绑定数据源的泛型类型</typeparam>
  726. /// <param name="grid">GridControl控件</param>
  727. /// <param name="menuText">菜单标题</param>
  728. /// <param name="meunImage">菜单图标</param>
  729. /// <param name="action">菜单要执行的异步事件函数,参数为选中的一行或多行元素</param>
  730. /// <returns></returns>
  731. public static GridControl AddMultRowMenuAsync<T>(this GridControl grid, string menuText, SvgImage meunImage,
  732. Func<List<T>, Task> action)
  733. {
  734. grid.UseMultiSelect();
  735. GridTag tag = grid.Tag as GridTag;
  736. var view = grid.MainView as GridView;
  737. if (tag.BarM == null)
  738. {
  739. tag.BarM = new BarManager();
  740. tag.BarM.Form = grid;
  741. }
  742. if (tag.PopupMenu == null)
  743. {
  744. tag.PopupMenu = new PopupMenu();
  745. }
  746. var popupMenu = tag.PopupMenu;
  747. BarButtonItem item = new BarButtonItem();
  748. var handle = new ItemClickEventHandler(async (sender, e) =>
  749. {
  750. if (action != null)
  751. {
  752. var rows = view.GetSelectedRows();
  753. List<T> list = new List<T>();
  754. foreach (var row in rows)
  755. {
  756. if (row < 0) continue;
  757. list.Add((T)view.GetRow(row));
  758. }
  759. if (list.Any())
  760. await action.Invoke(list);
  761. }
  762. });
  763. item.Events().AddHandler(menuText, handle);
  764. item.ItemClick += handle;
  765. item.ImageOptions.SvgImage = meunImage;
  766. item.Caption = menuText;
  767. Func<bool> showCondition = () => view.GetSelectedRows().Any();
  768. item.Tag = showCondition;
  769. tag.BarM.Items.Add(item);
  770. popupMenu.AddItem(item);
  771. popupMenu.Manager = tag.BarM;
  772. tag.PopupMenu = popupMenu;
  773. return grid;
  774. }
  775. /// <summary>
  776. /// GridControl添加内容区的右键菜单
  777. /// </summary>
  778. /// <typeparam name="T">GridControl绑定数据源的泛型类型</typeparam>
  779. /// <param name="grid">GridControl控件</param>
  780. /// <param name="menuText">菜单标题</param>
  781. /// <param name="meunImage">菜单图标</param>
  782. /// <param name="action">菜单要执行的事件,参数为绑定的数据源</param>
  783. /// <param name="showWithNoneDataRow">内容区没有元素时是否显示此菜单,默认显示</param>
  784. /// <returns></returns>
  785. public static GridControl AddContentMenu<T>(this GridControl grid, string menuText, SvgImage meunImage,
  786. Action<List<T>> action, bool showWithNoneDataRow = true)
  787. {
  788. GridTag tag = grid.Tag as GridTag;
  789. var view = grid.MainView as GridView;
  790. if (tag.BarM == null)
  791. {
  792. tag.BarM = new BarManager();
  793. tag.BarM.Form = grid;
  794. }
  795. if (tag.PopupMenu == null)
  796. {
  797. tag.PopupMenu = new PopupMenu();
  798. }
  799. var popupMenu = tag.PopupMenu;
  800. BarButtonItem item = new BarButtonItem();
  801. var handle = new ItemClickEventHandler((sender, e) =>
  802. {
  803. if (action != null)
  804. {
  805. var ds = grid.DataSource as List<T>;
  806. if (!showWithNoneDataRow && (ds == null || ds.Count == 0)) return;
  807. item.Enabled = false;
  808. action.Invoke(ds);
  809. item.Enabled = true;
  810. }
  811. });
  812. item.Events().AddHandler(menuText, handle);
  813. item.ItemClick += handle;
  814. item.ImageOptions.SvgImage = meunImage;
  815. item.Caption = menuText;
  816. tag.BarM.Items.Add(item);
  817. popupMenu.AddItem(item);
  818. popupMenu.Manager = tag.BarM;
  819. tag.PopupMenu = popupMenu;
  820. return grid;
  821. }
  822. /// <summary>
  823. /// GridControl添加内容区的右键菜单
  824. /// </summary>
  825. /// <typeparam name="T">GridControl绑定数据源的泛型类型</typeparam>
  826. /// <param name="grid">GridControl控件</param>
  827. /// <param name="menuText">菜单标题</param>
  828. /// <param name="meunImage">菜单图标</param>
  829. /// <param name="action">菜单要执行的事件,参数为绑定的数据源</param>
  830. /// <param name="showWithNoneDataRow">内容区没有元素时是否显示此菜单,默认显示</param>
  831. /// <returns></returns>
  832. public static GridControl AddContentMenuAsync<T>(this GridControl grid, string menuText, SvgImage meunImage,
  833. Func<List<T>, Task> action, bool showWithNoneDataRow = true)
  834. {
  835. GridTag tag = grid.Tag as GridTag;
  836. var view = grid.MainView as GridView;
  837. if (tag.BarM == null)
  838. {
  839. tag.BarM = new BarManager();
  840. tag.BarM.Form = grid;
  841. }
  842. if (tag.PopupMenu == null)
  843. {
  844. tag.PopupMenu = new PopupMenu();
  845. }
  846. var popupMenu = tag.PopupMenu;
  847. BarButtonItem item = new BarButtonItem();
  848. var handle = new ItemClickEventHandler(async (sender, e) =>
  849. {
  850. if (action != null)
  851. {
  852. var ds = grid.DataSource as List<T>;
  853. if (!showWithNoneDataRow && (ds == null || ds.Count == 0)) return;
  854. item.Enabled = false;
  855. await action.Invoke(ds);
  856. item.Enabled = true;
  857. }
  858. });
  859. item.Events().AddHandler(menuText, handle);
  860. item.ItemClick += handle;
  861. item.ImageOptions.SvgImage = meunImage;
  862. item.Caption = menuText;
  863. tag.BarM.Items.Add(item);
  864. popupMenu.AddItem(item);
  865. popupMenu.Manager = tag.BarM;
  866. tag.PopupMenu = popupMenu;
  867. return grid;
  868. }
  869. private static void View_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e)
  870. {
  871. if (e.Menu != null)
  872. {
  873. foreach (DXMenuItem item in e.Menu.Items)
  874. {
  875. if (!item.Enabled)
  876. {
  877. item.Visible = false;
  878. continue;
  879. }
  880. }
  881. }
  882. //if (e.HitInfo.HitTest == DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitTest.EmptyRow)
  883. //{
  884. // return;
  885. //}
  886. var view = sender as GridView;
  887. var grid = view.GridControl;
  888. var p = grid.PointToScreen(e.Point);
  889. var tag = grid.Tag as GridTag;
  890. if (tag?.PopupMenu != null)
  891. {
  892. foreach (BarButtonItemLink item in tag?.PopupMenu?.ItemLinks)
  893. {
  894. var buttonItem = item.Item;
  895. if (buttonItem.Tag != null && buttonItem.Tag is Func<bool> showCondition)
  896. {
  897. if (showCondition())
  898. buttonItem.Visibility = BarItemVisibility.Always;
  899. else
  900. buttonItem.Visibility = BarItemVisibility.Never;
  901. }
  902. }
  903. tag?.PopupMenu?.ShowPopup(p);
  904. }
  905. }
  906. public static GridControl DrawGridColumnHeaderCheckBox(this GridControl grid)
  907. {
  908. //View的 Editable要为true
  909. var view = grid.MainView as GridView;
  910. view.OptionsBehavior.Editable = true;
  911. view.OptionsSelection.MultiSelect = true;
  912. view.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CheckBoxRowSelect;
  913. return grid;
  914. }
  915. }