DynamicColumnGrid.cs 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Threading;
  5. using InABox.Core;
  6. namespace InABox.DynamicGrid;
  7. internal class DynamicColumnGrid : DynamicGrid<DynamicGridColumn>
  8. {
  9. public DynamicColumnGrid()
  10. {
  11. Columns = new DynamicGridColumns();
  12. }
  13. protected override void Init()
  14. {
  15. ActionColumns.Add(new DynamicRowMovementColumn(DynamicRowMovement.Up, SwapRows));
  16. ActionColumns.Add(new DynamicRowMovementColumn(DynamicRowMovement.Down, SwapRows));
  17. var column = MasterColumns.FirstOrDefault(x => string.Equals(x.ColumnName, nameof(DynamicGridColumn.ColumnName)));
  18. if(column is not null && column.Editor is DynamicColumnNameEditor edit)
  19. {
  20. edit.ColumnNames = () => ProcessColumns().Select(x => x.ColumnName).ToArray();
  21. }
  22. }
  23. protected override void DoReconfigure(DynamicGridOptions options)
  24. {
  25. options.RecordCount = true;
  26. options.MultiSelect = true;
  27. options.AddRows = true;
  28. options.EditRows = true;
  29. options.DeleteRows = true;
  30. }
  31. public Type Type { get; set; }
  32. public DynamicGridColumns Columns { get; }
  33. public bool DirectEdit { get; set; }
  34. private bool SwapRows(int row1, int row2)
  35. {
  36. var item = Columns[row1];
  37. Columns.Remove(item);
  38. Columns.Insert(row2, item);
  39. return true;
  40. }
  41. protected override void DoAdd(bool openEditorOnDirectEdit = false)
  42. {
  43. if(DynamicGridColumnNameSelectorGrid.SelectColumnName(ProcessColumns().Select(x => x.ColumnName).ToArray(), out var column))
  44. {
  45. var item = CreateItem();
  46. var prop = DatabaseSchema.Property(Type, column);
  47. item.ColumnName = column;
  48. if(prop is not null)
  49. {
  50. item.Width = prop.Editor.Width;
  51. item.Alignment = prop.Editor.Alignment;
  52. item.Format = prop.Editor.Format;
  53. item.Editor = prop.Editor.CloneEditor();
  54. item.Caption = prop.Caption;
  55. }
  56. SaveItem(item);
  57. DoChanged();
  58. Refresh(false, true);
  59. }
  60. }
  61. protected override void DoValidate(DynamicGridColumn[] items, List<string> errors)
  62. {
  63. base.DoValidate(items, errors);
  64. if (items.Any(x => string.IsNullOrWhiteSpace(x.ColumnName)))
  65. errors.Add("[ColumnName] must not be blank!");
  66. }
  67. protected override Dictionary<string, object?> EditorValueChanged(IDynamicEditorForm editor, DynamicGridColumn[] items, string name, object value)
  68. {
  69. var changes = base.EditorValueChanged(editor, items, name, value);
  70. if(name == nameof(DynamicGridColumn.ColumnName) && value is string columnName)
  71. {
  72. var prop = DatabaseSchema.Property(Type, columnName);
  73. if(prop is not null)
  74. {
  75. foreach(var item in items)
  76. {
  77. CoreUtils.MonitorChanges(item, () =>
  78. {
  79. item.Width = prop.Editor.Width;
  80. item.Alignment = prop.Editor.Alignment;
  81. item.Format = prop.Editor.Format;
  82. item.Editor = prop.Editor.CloneEditor();
  83. item.Caption = prop.Caption;
  84. }, changes);
  85. }
  86. }
  87. }
  88. return changes;
  89. }
  90. private IEnumerable<DynamicGridColumn> ProcessColumns()
  91. {
  92. var result = new List<DynamicGridColumn>();
  93. var cols = new DynamicGridColumns();
  94. cols.ExtractColumns(Type);
  95. foreach (var col in cols)
  96. {
  97. if (col.Editor == null)
  98. continue;
  99. if (col.Editor is NullEditor)
  100. continue;
  101. if (col.Editor.Visible != Visible.Hidden)
  102. {
  103. result.Add(col);
  104. continue;
  105. }
  106. if (!DirectEdit)
  107. continue;
  108. if (col.Editor.Editable.IsEditable() && col.ColumnName.Split('.').Length <= 2)
  109. result.Add(col);
  110. }
  111. result.Sort((a, b) => a.ColumnName.CompareTo(b.ColumnName));
  112. return result;
  113. }
  114. protected override void DefineLookups(ILookupEditorControl sender, DynamicGridColumn[] items, bool async = true)
  115. {
  116. if (Type != null && sender.ColumnName.Equals("ColumnName"))
  117. {
  118. var results = new CoreTable();
  119. results.Columns.Add(new CoreColumn { ColumnName = sender.ColumnName, DataType = typeof(string) });
  120. results.Columns.Add(new CoreColumn { ColumnName = "Display", DataType = typeof(string) });
  121. var cols = ProcessColumns();
  122. foreach (var col in cols)
  123. {
  124. var row = results.NewRow();
  125. row[sender.ColumnName] = col.ColumnName;
  126. row["Display"] = col.ColumnName;
  127. results.Rows.Add(row);
  128. }
  129. sender.LoadLookups(results);
  130. }
  131. else
  132. {
  133. base.DefineLookups(sender, items, async);
  134. }
  135. }
  136. #region Save / Load
  137. protected override void Reload(
  138. Filters<DynamicGridColumn> criteria, Columns<DynamicGridColumn> columns, ref SortOrder<DynamicGridColumn>? sort,
  139. CancellationToken token, Action<CoreTable, Exception?> action)
  140. {
  141. var result = new CoreTable();
  142. if (columns == null || columns.Count == 0)
  143. result.LoadColumns(typeof(DynamicGridColumn));
  144. else
  145. result.LoadColumns(columns);
  146. result.LoadRows(Columns);
  147. action.Invoke(result, null);
  148. }
  149. public override DynamicGridColumn LoadItem(CoreRow row)
  150. {
  151. var index = Data.Rows.IndexOf(row);
  152. return Columns[index];
  153. }
  154. public override void SaveItem(DynamicGridColumn item)
  155. {
  156. try
  157. {
  158. var prop = DatabaseSchema.Property(Type, item.ColumnName);
  159. item.Editor = prop.Editor;
  160. }
  161. catch (Exception e)
  162. {
  163. Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
  164. }
  165. if (!Columns.Contains(item))
  166. Columns.Add(item);
  167. }
  168. public override void DeleteItems(params CoreRow[] rows)
  169. {
  170. foreach (var row in rows.OrderByDescending(x => x.Index))
  171. Columns.RemoveAt(row.Index);
  172. }
  173. #endregion
  174. }