GridControlEx.cs 34 KB

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