123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198 |
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.Collections.ObjectModel;
- using System.ComponentModel;
- using System.Data;
- using System.Diagnostics;
- using System.Drawing;
- using System.Globalization;
- using System.Linq;
- using System.Linq.Expressions;
- using System.Reflection;
- using System.Threading.Tasks;
- using System.Windows;
- using System.Windows.Controls;
- using System.Windows.Data;
- using System.Windows.Input;
- using System.Windows.Media;
- using System.Windows.Media.Imaging;
- using System.Windows.Threading;
- using InABox.Clients;
- using InABox.Core;
- using InABox.Scripting;
- using InABox.WPF;
- using Syncfusion.Data;
- using Syncfusion.UI.Xaml.Grid;
- using Syncfusion.UI.Xaml.Grid.Cells;
- using Syncfusion.UI.Xaml.Grid.Helpers;
- using Syncfusion.Windows.Controls.Cells;
- using Syncfusion.Windows.Controls.Grid;
- using Syncfusion.Windows.Shared;
- using Syncfusion.Windows.Tools.Controls;
- using Syncfusion.XPS;
- using Color = System.Drawing.Color;
- using DataRow = System.Data.DataRow;
- using FilterElement = Syncfusion.UI.Xaml.Grid.FilterElement;
- using Geometry = System.Windows.Media.Geometry;
- using GridCellToolTipOpeningEventArgs = Syncfusion.UI.Xaml.Grid.GridCellToolTipOpeningEventArgs;
- using GridFilterEventArgs = Syncfusion.UI.Xaml.Grid.GridFilterEventArgs;
- using GridSelectionMode = Syncfusion.UI.Xaml.Grid.GridSelectionMode;
- using Image = System.Windows.Controls.Image;
- using Path = System.Windows.Shapes.Path;
- using Point = System.Windows.Point;
- using Resources = InABox.DynamicGrid.Properties.Resources;
- using RowColumnIndex = Syncfusion.UI.Xaml.ScrollAxis.RowColumnIndex;
- using SolidColorBrush = System.Windows.Media.SolidColorBrush;
- using Transform = System.Windows.Media.Transform;
- using VirtualizingCellsControl = Syncfusion.UI.Xaml.Grid.VirtualizingCellsControl;
- namespace InABox.DynamicGrid
- {
- public class TimeSpanToStringConverter : IValueConverter
- {
- public TimeSpanToStringConverter(string format)
- {
- Format = format;
- }
- public string Format { get; set; }
- public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
- {
- if (value is TimeSpan time)
- {
- var result = string.IsNullOrWhiteSpace(Format) || string.Equals(Format, "hh:mm")
- ? Math.Truncate(time.TotalHours).ToString("#00") + ":" + time.Minutes.ToString("D2")
- : string.Format("{0:" + Format.Replace(":", "\\:") + "}", time);
- return result;
- }
- return "";
- }
- public object? ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
- {
- return null;
- }
- }
- public class TimeSpanAggregate : ISummaryAggregate
- {
- public int Count { get; private set; }
- public TimeSpan Sum { get; private set; }
- public Action<IEnumerable, string, PropertyDescriptor> CalculateAggregateFunc()
- {
- return CalculateAggregate;
- }
- private void CalculateAggregate(IEnumerable items, string property, PropertyDescriptor args)
- {
- if(items is IEnumerable<DataRowView> rows)
- {
- if (string.Equals(args.Name, "Count"))
- {
- Count = rows.Count();
- }
- else if (string.Equals(args.Name, "Sum"))
- {
- Sum = new TimeSpan();
- foreach (var row in rows)
- if (row[property] is TimeSpan)
- Sum += (TimeSpan)row[property];
- }
- }
- else
- {
- Logger.Send(LogType.Error, "", $"Attempting to caluculate aggregate on invalid data type '{items.GetType()}'.");
- }
- }
- }
- public class TimeSpanAggregateRenderer : GridTableSummaryCellRenderer
- {
- public override void OnUpdateEditBinding(DataColumnBase dataColumn, GridTableSummaryCell element, object dataContext)
- {
- if (DataGrid == null)
- return;
- var record = dataContext as SummaryRecordEntry;
- if (record == null || record.SummaryRow == null)
- return;
- foreach (var summaryColumn in record.SummaryRow.SummaryColumns)
- {
- if (!summaryColumn.MappingName.Equals(dataColumn.GridColumn.MappingName))
- continue;
- var tsAgg = DataGrid != null
- ? SummaryCreator.GetSummaryAggregate(summaryColumn, DataGrid.View) as TimeSpanAggregate
- : null;
- if (tsAgg != null)
- {
- var format = summaryColumn.Format.Replace("{", "").Replace("}", "").Split(':');
- var cmd = format.FirstOrDefault();
- var fmt = format.Length > 1 ? string.Join(":", format.Skip(1)) : "";
- if (string.Equals(cmd, "Sum"))
- element.Content = string.IsNullOrWhiteSpace(fmt) || string.Equals(fmt, "hh':'mm")
- ? Math.Truncate(tsAgg.Sum.TotalHours).ToString("#00") + ":" + tsAgg.Sum.Minutes.ToString("D2")
- : string.Format("{0:" + fmt.Replace(":", "\\:") + "}", tsAgg.Sum);
- else if (string.Equals(summaryColumn.Format, "Count"))
- element.Content = string.Format(fmt, tsAgg.Count);
- }
- else
- {
- base.OnUpdateEditBinding(dataColumn, element, dataContext);
- }
- }
- }
- }
- public class NewDynamicGridStyle : DynamicGridStyle<VirtualizingCellsControl>
- {
- public NewDynamicGridStyle() : base(null)
- {
- }
- public NewDynamicGridStyle(IDynamicGridStyle source) : base(source)
- {
- }
- public override DependencyProperty FontSizeProperty => Control.FontSizeProperty;
- public override DependencyProperty FontStyleProperty => Control.FontStyleProperty;
- public override DependencyProperty FontWeightProperty => Control.FontWeightProperty;
- public override DependencyProperty BackgroundProperty => Control.BackgroundProperty;
- public override DependencyProperty ForegroundProperty => Control.ForegroundProperty;
- }
- public class GridSelectionControllerExt : GridSelectionController
- {
- public GridSelectionControllerExt(SfDataGrid datagrid)
- : base(datagrid)
- {
- }
- protected override void ProcessSelectedItemChanged(SelectionPropertyChangedHandlerArgs handle)
- {
- base.ProcessSelectedItemChanged(handle);
- if (handle.NewValue != null)
- {
- //this.DataGrid.ScrollInView(this.CurrentCellManager.CurrentRowColumnIndex);
- //int rowIndex = this.CurrentCellManager.CurrentRowColumnIndex.RowIndex;
- var columnIndex = CurrentCellManager.CurrentRowColumnIndex.ColumnIndex;
- var scrollRowIndex = DataGrid.GetVisualContainer().ScrollRows.LastBodyVisibleLineIndex;
- DataGrid.ScrollInView(new RowColumnIndex(scrollRowIndex, columnIndex));
- }
- }
- }
- public class DynamicGridSummaryStyleSelector : StyleSelector
- {
- private readonly IDynamicGrid _grid;
- public DynamicGridSummaryStyleSelector(IDynamicGrid grid)
- {
- _grid = grid;
- }
- public override Style SelectStyle(object item, DependencyObject container)
- {
- var vcol = ((GridTableSummaryCell)container).ColumnBase.ColumnIndex;
- var col = vcol > -1 && vcol < _grid.VisibleColumns.Count ? _grid.VisibleColumns[vcol] : null;
- var style = new Style(typeof(GridTableSummaryCell));
- style.Setters.Add(new Setter(Control.BackgroundProperty, new SolidColorBrush(Colors.Gainsboro)));
- style.Setters.Add(new Setter(Control.ForegroundProperty, new SolidColorBrush(Colors.Black)));
- style.Setters.Add(new Setter(Control.HorizontalContentAlignmentProperty,
- col != null ? col.HorizontalAlignment(typeof(double)) : HorizontalAlignment.Right));
- style.Setters.Add(new Setter(Control.BorderBrushProperty, new SolidColorBrush(Colors.Gray)));
- style.Setters.Add(new Setter(Control.BorderThicknessProperty, new Thickness(0, 0, 0.75, 0)));
- style.Setters.Add(new Setter(Control.FontSizeProperty, 12D));
- style.Setters.Add(new Setter(Control.FontWeightProperty, FontWeights.DemiBold));
- return style;
- }
- }
- // Used to render boolean columns (the default "false" value shows what appears to be an intermediate state, which is ugly
- // This should show nothing for false, and a tick in a box for true
- public class BoolToImageConverter : IValueConverter
- {
- private static readonly BitmapImage tick = Resources.Bullet_Tick.AsBitmapImage();
- public object? Convert(object value, Type targetType, object parameter, CultureInfo culture)
- {
- return value is bool boolean && boolean ? tick : null;
- }
- public object? ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
- {
- return null;
- }
- }
- public class StringToColorImageConverter : IValueConverter
- {
- private readonly int _height = 50;
- private readonly int _width = 25;
- private readonly Dictionary<string, BitmapImage> cache = new();
- public StringToColorImageConverter(int width, int height)
- {
- _width = width;
- _height = height;
- }
- public object? Convert(object value, Type targetType, object parameter, CultureInfo culture)
- {
- var str = value?.ToString();
- if (str is null)
- return null;
- var colorcode = str.TrimStart('#');
- if (!cache.ContainsKey(colorcode))
- {
- var col = ImageUtils.StringToColor(colorcode);
- var bmp = ImageUtils.BitmapFromColor(col, _width, _height, Color.Black);
- cache[colorcode] = bmp.AsBitmapImage();
- }
- var result = cache[colorcode];
- return result;
- }
- public object? ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
- {
- return null;
- }
- }
- public class StringArrayConverter : IValueConverter
- {
- object? IValueConverter.Convert(object value, Type targetType, object parameter, CultureInfo culture)
- {
- if(value is string[] strArray)
- {
- return string.Join("\n", strArray);
- }
- Logger.Send(LogType.Error, "", $"Attempt to convert an object which is not a string array: {value}.");
- return null;
- }
- object IValueConverter.ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
- {
- return value;
- }
- }
- public abstract class DynamicGrid<T> : BaseDynamicGrid<T> where T : BaseObject, new()
- {
- private readonly Dictionary<string, string> _filterpredicates = new();
- private UIElement? _header;
- private readonly Button Add;
- private bool bChanged;
- private bool bRefreshing;
- private readonly Label ClipboardSpacer;
- private readonly ContextMenu ColumnsMenu;
- private readonly Button Copy;
- private readonly Label Count;
- private readonly Button Cut;
- private readonly SfDataGrid DataGrid;
- private readonly Button Delete;
- private readonly DockPanel Docker;
- private readonly DynamicRowMovementColumn? down;
- private readonly Button Edit;
- private readonly Label EditSpacer;
- private readonly Button Export;
- private readonly Label ExportSpacer;
- private readonly GridRowSizingOptions gridRowResizingOptions = new() { CanIncludeHiddenColumns = false, AutoFitMode = AutoFitMode.SmartFit };
- private readonly Button Help;
- private readonly Button Import;
- private T? inplaceeditor;
- private readonly Grid Layout;
- private readonly Label Loading;
- protected Dictionary<string, CoreTable> Lookups = new();
- private readonly Button MultiEdit;
- private readonly Button Paste;
- private readonly Button Print;
- private readonly Label PrintSpacer;
- private readonly StackPanel Stack;
- private readonly DynamicRowMovementColumn? up;
- private DataTable DataGridItems => (DataGrid.ItemsSource as DataTable)!;
- #region Events
- public event SelectItemHandler? OnSelectItem;
- public event OnDoubleClick? OnDoubleClick;
- public OnGridChanged? OnChanged;
- public event EditorValueChangedHandler? OnEditorValueChanged;
- public override event OnCustomiseEditor<T>? OnCustomiseEditor;
- public override event OnCustomiseColumns? OnCustomiseColumns;
- public override event OnFilterRecord? OnFilterRecord;
- #endregion
- public DynamicGrid() : base()
- {
- IsReady = false;
- Data = new CoreTable();
- ColumnsMenu = new ContextMenu();
- var SelectColumns = new MenuItem { Header = "Select Columns" };
- SelectColumns.Click += SelectColumnsClick;
- ColumnsMenu.Items.Add(SelectColumns);
- LoadColumnsMenu(ColumnsMenu);
- MasterColumns = new DynamicGridColumns();
- MasterColumns.ExtractColumns(typeof(T), "");
- ActionColumns = new DynamicActionColumns();
- if (IsSequenced)
- {
- up = new DynamicRowMovementColumn(DynamicRowMovement.Up, SwapRows);
- ActionColumns.Add(up);
- down = new DynamicRowMovementColumn(DynamicRowMovement.Down, SwapRows);
- ActionColumns.Add(down);
- HiddenColumns.Add(x => (x as ISequenceable)!.Sequence);
- }
- VisibleColumns = new DynamicGridColumns();
- DataGrid = new SfDataGrid();
- DataGrid.VerticalAlignment = VerticalAlignment.Stretch;
- DataGrid.HorizontalAlignment = HorizontalAlignment.Stretch;
- DataGrid.HeaderContextMenu = ColumnsMenu;
- DataGrid.CellTapped += DataGrid_CellTapped;
- DataGrid.CellDoubleTapped += DataGrid_CellDoubleTapped;
- DataGrid.SelectionMode = GridSelectionMode.Extended;
- DataGrid.SelectionUnit = GridSelectionUnit.Row;
- DataGrid.CanMaintainScrollPosition = true;
- DataGrid.NavigationMode = NavigationMode.Row;
- DataGrid.AllowEditing = false;
- DataGrid.EditTrigger = EditTrigger.OnTap;
- DataGrid.CurrentCellBeginEdit += DataGrid_CurrentCellBeginEdit;
- DataGrid.CurrentCellEndEdit += DataGrid_CurrentCellEndEdit;
- DataGrid.CurrentCellValueChanged += DataGrid_CurrentCellValueChanged;
- DataGrid.CurrentCellDropDownSelectionChanged += DataGrid_CurrentCellDropDownSelectionChanged;
- DataGrid.CurrentCellRequestNavigate += DataGrid_CurrentCellRequestNavigate;
- DataGrid.PreviewKeyUp += DataGrid_PreviewKeyUp;
- DataGrid.CurrentCellActivated += DataGrid_CurrentCellActivated;
- DataGrid.BorderBrush = new SolidColorBrush(Colors.Gray);
- DataGrid.BorderThickness = new Thickness(0.75F);
- DataGrid.Background = new SolidColorBrush(Colors.DimGray);
- DataGrid.AutoGenerateColumns = false;
- DataGrid.ColumnSizer = GridLengthUnitType.AutoLastColumnFill;
- DataGrid.SelectionForegroundBrush = BaseDynamicGrid.SelectionForeground;
- DataGrid.RowSelectionBrush = BaseDynamicGrid.SelectionBackground;
-
- DataGrid.CurrentCellBorderThickness = new Thickness(0);
- DataGrid.AllowFiltering = false;
- DataGrid.EnableDataVirtualization = true;
- DataGrid.RowHeight = 30;
- DataGrid.QueryRowHeight += DataGrid_QueryRowHeight;
- DataGrid.HeaderRowHeight = 30;
- DataGrid.MouseLeftButtonUp += DataGrid_MouseLeftButtonUp;
- DataGrid.MouseRightButtonUp += DataGrid_MouseRightButtonUp;
- DataGrid.KeyUp += DataGrid_KeyUp;
- DataGrid.PreviewGotKeyboardFocus += DataGrid_PreviewGotKeyboardFocus;
- //DataGrid.SelectionController = new GridSelectionControllerExt(DataGrid);
- DataGrid.FilterChanged += DataGrid_FilterChanged;
- DataGrid.FilterItemsPopulating += DataGrid_FilterItemsPopulating;
- var fltstyle = new Style(typeof(GridFilterControl));
- fltstyle.Setters.Add(new Setter(GridFilterControl.FilterModeProperty, FilterMode.Both));
- fltstyle.Setters.Add(new Setter(GridFilterControl.SortOptionVisibilityProperty, Visibility.Collapsed));
- DataGrid.FilterPopupStyle = fltstyle;
- DataGrid.RowStyleSelector = StyleSelector;
- DataGrid.TableSummaryCellStyleSelector = new DynamicGridSummaryStyleSelector(this);
- //DataGrid.MouseMove += DataGrid_MouseMove;
- DataGrid.CellToolTipOpening += DataGrid_CellToolTipOpening;
- //var headstyle = new Style(typeof(GridHeaderCellControl));
- //headstyle.Setters.Add(new Setter(GridHeaderCellControl.BackgroundProperty, new SolidColorBrush(Colors.WhiteSmoke)));
- //headstyle.Setters.Add(new Setter(GridHeaderCellControl.ForegroundProperty, new SolidColorBrush(Colors.Green)));
- //headstyle.Setters.Add(new Setter(GridHeaderCellControl.FontSizeProperty, 12.0F));
- //DataGrid.HeaderStyle = headstyle;
- DataGrid.SizeChanged += DataGrid_SizeChanged;
- DataGrid.SetValue(Grid.RowProperty, 1);
- Loading = new Label();
- Loading.Content = "Loading...";
- Loading.Foreground = new SolidColorBrush(Colors.White);
- Loading.VerticalContentAlignment = VerticalAlignment.Center;
- Loading.HorizontalContentAlignment = HorizontalAlignment.Center;
- Loading.Visibility = Visibility.Collapsed;
- Loading.SetValue(Panel.ZIndexProperty, 999);
- Loading.SetValue(Grid.RowProperty, 1);
- Loading.FontSize = 14.0F;
- Loading.Tag = new DispatcherTimer { Interval = TimeSpan.FromMilliseconds(50) };
- Help = CreateButton(Properties.Resources.help.AsBitmapImage(Color.White));
- Help.Margin = new Thickness(0, 2, 2, 0);
- Help.SetValue(DockPanel.DockProperty, Dock.Right);
- Help.Click += (o, e) => ShowHelp(typeof(T).Name.Split('.').Last().SplitCamelCase().Replace(" ","_"));
- Add = CreateButton(Properties.Resources.add.AsBitmapImage(Color.White));
- Add.Margin = new Thickness(0, 2, 2, 0);
- Add.Click += Add_Click;
- Edit = CreateButton(Properties.Resources.pencil.AsBitmapImage(Color.White));
- Edit.Margin = new Thickness(0, 2, 2, 0);
- Edit.Click += Edit_Click;
- MultiEdit = CreateButton(Properties.Resources.doc_xls.AsBitmapImage(Color.White));
- MultiEdit.Margin = new Thickness(0, 2, 2, 0);
- MultiEdit.Click += MultiEdit_Click;
- EditSpacer = new Label { Width = 5 };
- Print = CreateButton(Properties.Resources.print.AsBitmapImage(Color.White));
- Print.Margin = new Thickness(0, 2, 2, 0);
- Print.Click += (o, e) => DoPrint(o);
- PrintSpacer = new Label { Width = 5 };
- Cut = CreateButton(Properties.Resources.cut.AsBitmapImage(Color.White));
- Cut.Margin = new Thickness(0, 2, 2, 0);
- Cut.Click += Cut_Click;
- Copy = CreateButton(Properties.Resources.copy.AsBitmapImage(Color.White));
- Copy.Margin = new Thickness(0, 2, 2, 0);
- Copy.Click += Copy_Click;
- Paste = CreateButton(Properties.Resources.paste.AsBitmapImage(Color.White));
- Paste.Margin = new Thickness(0, 2, 2, 0);
- Paste.Click += Paste_Click;
- ClipboardSpacer = new Label { Width = 5 };
- Export = CreateButton(Properties.Resources.doc_xls.AsBitmapImage(Color.White), "Export");
- Export.Margin = new Thickness(0, 2, 2, 0);
- Export.Click += Export_Click;
- Import = CreateButton(Properties.Resources.doc_xls.AsBitmapImage(Color.White), "Import");
- Import.Margin = new Thickness(0, 2, 2, 0);
- Import.Click += Import_Click;
- ExportSpacer = new Label { Width = 5 };
- Stack = new StackPanel();
- Stack.Orientation = Orientation.Horizontal;
- Stack.SetValue(DockPanel.DockProperty, Dock.Left);
- Stack.Children.Add(Help);
- Stack.Children.Add(Add);
- Stack.Children.Add(Edit);
- Stack.Children.Add(MultiEdit);
- Stack.Children.Add(EditSpacer);
- Stack.Children.Add(Print);
- Stack.Children.Add(PrintSpacer);
- Stack.Children.Add(Cut);
- Stack.Children.Add(Copy);
- Stack.Children.Add(Paste);
- Stack.Children.Add(ClipboardSpacer);
- Stack.Children.Add(Export);
- Stack.Children.Add(Import);
- Stack.Children.Add(ExportSpacer);
- Delete = CreateButton(Properties.Resources.delete.AsBitmapImage(Color.White));
- Delete.Margin = new Thickness(0, 2, 0, 0);
- Delete.SetValue(DockPanel.DockProperty, Dock.Right);
- Delete.Click += Delete_Click;
- Count = new Label();
- Count.Height = 30;
- Count.Margin = new Thickness(0, 2, 0, 0);
- Count.VerticalContentAlignment = VerticalAlignment.Center;
- Count.HorizontalContentAlignment = HorizontalAlignment.Center;
- Count.SetValue(DockPanel.DockProperty, Dock.Left);
- Docker = new DockPanel();
- Docker.SetValue(Grid.RowProperty, 2);
- Docker.SetValue(Grid.ColumnProperty, 0);
- Docker.Children.Add(Stack);
- Docker.Children.Add(Delete);
- Docker.Children.Add(Count);
- Layout = new Grid();
- Layout.ColumnDefinitions.Add(new ColumnDefinition { Width = new GridLength(1, GridUnitType.Star) });
- Layout.RowDefinitions.Add(new RowDefinition { Height = new GridLength(1, GridUnitType.Auto) });
- Layout.RowDefinitions.Add(new RowDefinition { Height = new GridLength(1, GridUnitType.Star) });
- Layout.RowDefinitions.Add(new RowDefinition { Height = new GridLength(1, GridUnitType.Auto) });
- Layout.Children.Add(DataGrid);
- Layout.Children.Add(Loading);
- Layout.Children.Add(Docker);
- //Scroll.ApplyTemplate();
- Content = Layout;
- Options.Clear();
- }
- public bool IsReady { get; private set; }
- public UIElement? Header
- {
- get => _header;
- set
- {
- if (_header is not null && Layout.Children.Contains(_header))
- Layout.Children.Remove(_header);
- _header = value;
- if(_header is not null)
- {
- _header.SetValue(Grid.RowProperty, 0);
- _header.SetValue(Grid.ColumnProperty, 0);
- _header.SetValue(Grid.ColumnSpanProperty, 2);
- Layout.Children.Add(_header);
- }
- }
- }
- /// <summary>
- /// Represents the data in the grid. This is <see langword="null"/> until <see cref="Refresh(bool, bool)"/> is called.
- /// </summary>
- public CoreTable? MasterData { get; set; }
- public DynamicActionColumns ActionColumns { get; }
- private bool IsSequenced => typeof(T).GetInterfaces().Any(x => x.Equals(typeof(ISequenceable)));
- public override double RowHeight
- {
- get => DataGrid.RowHeight;
- set => DataGrid.RowHeight = value;
- }
- public override double HeaderHeight
- {
- get => DataGrid.HeaderRowHeight;
- set => DataGrid.HeaderRowHeight = value;
- }
- protected override void OptionsChanged(object sender, EventArgs args)
- {
- ColumnsMenu.Visibility = Options.Contains(DynamicGridOption.SelectColumns) ? Visibility.Visible : Visibility.Hidden;
- Help.Visibility = Options.Contains(DynamicGridOption.ShowHelp) ? Visibility.Visible : Visibility.Collapsed;
- Add.Visibility = Options.Contains(DynamicGridOption.AddRows) ? Visibility.Visible : Visibility.Collapsed;
- Edit.Visibility = Options.Contains(DynamicGridOption.EditRows) ? Visibility.Visible : Visibility.Collapsed;
- MultiEdit.Visibility =
- Visibility.Collapsed; // _Options.Contains(DynamicGridOptions.DirectEdit) ? Visibility.Visible : Visibility.Collapsed;
- EditSpacer.Visibility = Options.Contains(DynamicGridOption.AddRows) || Options.Contains(DynamicGridOption.EditRows)
- ? Visibility.Visible
- : Visibility.Collapsed;
- Print.Visibility = Options.Contains(DynamicGridOption.Print) ? Visibility.Visible : Visibility.Collapsed;
- PrintSpacer.Visibility = Options.Contains(DynamicGridOption.Print) ? Visibility.Visible : Visibility.Collapsed;
- Cut.Visibility = IsSequenced ? Visibility.Visible : Visibility.Collapsed;
- Copy.Visibility = IsSequenced ? Visibility.Visible : Visibility.Collapsed;
- Paste.Visibility = IsSequenced ? Visibility.Visible : Visibility.Collapsed;
- ClipboardSpacer.Visibility = IsSequenced ? Visibility.Visible : Visibility.Collapsed;
- Export.Visibility = Options.Contains(DynamicGridOption.ExportData) ? Visibility.Visible : Visibility.Collapsed;
- Import.Visibility = Options.Contains(DynamicGridOption.ImportData) ? Visibility.Visible : Visibility.Collapsed;
- ExportSpacer.Visibility = Options.Contains(DynamicGridOption.ExportData) || Options.Contains(DynamicGridOption.ImportData)
- ? Visibility.Visible
- : Visibility.Collapsed;
- DataGrid.NavigationMode = Options.Contains(DynamicGridOption.DirectEdit) ? NavigationMode.Cell : NavigationMode.Row;
- DataGrid.AllowEditing = Options.Contains(DynamicGridOption.DirectEdit);
- Count.Visibility = Options.Contains(DynamicGridOption.RecordCount) ? Visibility.Visible : Visibility.Collapsed;
- Delete.Visibility = Options.Contains(DynamicGridOption.DeleteRows) ? Visibility.Visible : Visibility.Collapsed;
- DataGrid.AllowFiltering = Options.Contains(DynamicGridOption.FilterRows);
- DataGrid.FilterRowPosition = Options.Contains(DynamicGridOption.FilterRows) ? FilterRowPosition.FixedTop : FilterRowPosition.None;
- DataGrid.SelectionMode = Options.Contains(DynamicGridOption.MultiSelect) ? GridSelectionMode.Extended : GridSelectionMode.Single;
- if (up != null)
- up.Position = Options.Contains(DynamicGridOption.EditRows) ? DynamicActionColumnPosition.Start : DynamicActionColumnPosition.Hidden;
- if (down != null)
- down.Position = Options.Contains(DynamicGridOption.EditRows) ? DynamicActionColumnPosition.Start : DynamicActionColumnPosition.Hidden;
- }
- protected override DynamicGridStyleSelector<T> GetStyleSelector()
- {
- return new DynamicGridStyleSelector<T, NewDynamicGridStyle>();
- }
- protected override DynamicGridStyle GetStyle(CoreRow row, DynamicGridStyle style)
- {
- var result = base.GetStyle(row, style);
- if (ClipBuffer != null)
- if (ClipBuffer.Item2.Contains(row))
- {
- var bgbrush = style.Background as SolidColorBrush;
- var bgcolor = bgbrush != null ? bgbrush.Color : Colors.Transparent;
- result = new NewDynamicGridStyle(style);
- result.Background = ClipBuffer.Item1 == ClipAction.Cut
- ? new SolidColorBrush(bgcolor.MixColors(0.5, Colors.Orchid))
- : new SolidColorBrush(bgcolor.MixColors(0.5, Colors.LightGreen));
- result.Foreground = new SolidColorBrush(Colors.Gray);
- result.FontStyle = FontStyles.Italic;
- }
- return result;
- }
- private void DataGrid_CurrentCellActivated(object? sender, CurrentCellActivatedEventArgs e)
- {
- if (!Options.Contains(DynamicGridOption.DirectEdit))
- return;
- if (!DataGrid.SelectionController.CurrentCellManager.CurrentCell.IsEditing && e.ActivationTrigger == ActivationTrigger.Keyboard)
- DataGrid.SelectionController.CurrentCellManager.BeginEdit();
- }
- private void DataGrid_PreviewKeyUp(object sender, KeyEventArgs e)
- {
- if (e.Key == Key.OemPeriod)
- {
- var editor = e.OriginalSource as TimeSpanEdit;
- if (editor != null && editor.SelectionStart < 2) editor.SelectionStart = 3;
- }
- else if (e.Key == Key.Tab)
- {
- }
- //throw new NotImplementedException();
- }
- private void DataGrid_CurrentCellRequestNavigate(object? sender, CurrentCellRequestNavigateEventArgs e)
- {
- //throw new NotImplementedException();
- }
- private void DataGrid_FilterChanged(object? o, GridFilterEventArgs e)
- {
- var col = DataGrid.Columns.IndexOf(e.Column);
- if (ColumnList[col] is DynamicActionColumn column)
- {
- if (e.FilterPredicates != null)
- {
- var filter = e.FilterPredicates.Select(x => x.FilterValue.ToString()!).ToArray();
- bool include = e.FilterPredicates.Any(x => x.FilterType == FilterType.Equals);
- column.SelectedFilters = include ? filter : column.Filters.Except(filter).ToArray();
- }
- else
- column.SelectedFilters = Array.Empty<string>();
- DataGrid.ClearFilter(e.Column);
- //e.FilterPredicates?.Clear();
- //e.FilterPredicates?.Add(new FilterPredicate() { PredicateType = PredicateType.Or, FilterBehavior = Syncfusion.Data.FilterBehavior.StringTyped, FilterMode = ColumnFilter.DisplayText, FilterType = Syncfusion.Data.FilterType.NotEquals, FilterValue = "" });
- //e.FilterPredicates?.Add(new FilterPredicate() { PredicateType = PredicateType.Or, FilterBehavior = Syncfusion.Data.FilterBehavior.StringTyped, FilterMode = ColumnFilter.DisplayText, FilterType = Syncfusion.Data.FilterType.Equals, FilterValue = "" });
- Refresh(false, false);
- e.Handled = true;
- }
- if (e.FilterPredicates == null)
- {
- if (_filterpredicates.ContainsKey(e.Column.MappingName))
- _filterpredicates.Remove(e.Column.MappingName);
- }
- else
- {
- _filterpredicates[e.Column.MappingName] = Serialization.Serialize(e.FilterPredicates, true);
- }
- UpdateRecordCount();
- }
- private void DataGrid_FilterItemsPopulating(object? sender, GridFilterItemsPopulatingEventArgs e)
- {
- var col = DataGrid.Columns.IndexOf(e.Column);
- var column = ColumnList[col] as DynamicActionColumn;
- if (column != null)
- e.ItemsSource = column.Filters.Select(x => new FilterElement
- { DisplayText = x, ActualValue = x, IsSelected = column.SelectedFilters == null || column.SelectedFilters.Contains(x) });
- }
- private void DataGrid_CellToolTipOpening(object? sender, GridCellToolTipOpeningEventArgs e)
- {
- if (ColumnList[e.RowColumnIndex.ColumnIndex] is not DynamicActionColumn col)
- return;
- var toolTip = col.ToolTip;
- if (toolTip is null)
- return;
- var row = e.RowColumnIndex.RowIndex - (Options.Contains(DynamicGridOption.FilterRows) ? 2 : 1);
- if (row < 0)
- return;
- row = DataGridItems.Rows.IndexOf((DataGrid.View.Records[row].Data as DataRowView)!.Row);
- if (row < 0)
- return;
- e.ToolTip.Template = TemplateGenerator.CreateControlTemplate(
- typeof(ToolTip),
- () => toolTip.Invoke(col, Data.Rows[row])
- );
- }
- //private void DataGrid_MouseMove(object sender, MouseEventArgs e)
- //{
- // var visualcontainer = DataGrid.GetVisualContainer();
- // var point = e.GetPosition(visualcontainer);
- // var rowColumnIndex = visualcontainer.PointToCellRowColumnIndex(point);
- // var recordIndex = DataGrid.ResolveToRecordIndex(rowColumnIndex.RowIndex);
- // if (recordIndex < 0)
- // return;
- // if (!rowColumnIndex.IsEmpty)
- // {
- // if (DataGrid.View.TopLevelGroup != null)
- // {
- // // Get the current row record while grouping
- // var record = DataGrid.View.TopLevelGroup.DisplayElements[recordIndex];
- // if (record.GetType() == typeof(RecordEntry))
- // {
- // var data = (record as RecordEntry).Data as CoreRow;
- // }
- // }
- // else
- // {
- // //For getting the record, need to resolve the corresponding record index from row index
- // var record1 = DataGrid.View.Records[DataGrid.ResolveToRecordIndex(rowColumnIndex.RowIndex)].Data;
- // }
- // //Gets the column from ColumnsCollection by resolving the corresponding column index from GridVisibleColumnIndex
- // var gridColumn = DataGrid.Columns[DataGrid.ResolveToGridVisibleColumnIndex(rowColumnIndex.ColumnIndex)];
- // if (gridColumn is GridImageColumn)
- // {
- // }
- // }
- //}
- protected virtual void LoadColumnsMenu(ContextMenu menu)
- {
- }
- private void DataGrid_CurrentCellBeginEdit(object? sender, CurrentCellBeginEditEventArgs e)
- {
- var headerrows = Options.Contains(DynamicGridOption.FilterRows) ? 2 : 1;
- if (e.RowColumnIndex.RowIndex < headerrows)
- return;
- if (inplaceeditor == null)
- inplaceeditor = LoadItem(Data.Rows[e.RowColumnIndex.RowIndex - headerrows]);
- var column = DataGrid.Columns[e.RowColumnIndex.ColumnIndex] as GridComboBoxColumn;
- if (column != null && column.ItemsSource == null)
- {
- var colname = column.MappingName;
- var colno = DataGridItems.Columns.IndexOf(colname);
- var property = Data.Columns[colno].ColumnName;
- var prop = CoreUtils.GetProperty(typeof(T), property);
- var editor = prop.GetEditor();
- if (editor is ILookupEditor)
- {
- if (!Lookups.ContainsKey(property))
- Lookups[property] = ((ILookupEditor)editor).Values(property);
- var combo = column;
- combo.ItemsSource = Lookups[property].ToDictionary(Lookups[property].Columns[0].ColumnName, "Display");
- combo.SelectedValuePath = "Key";
- combo.DisplayMemberPath = "Value";
- }
- }
- bChanged = false;
- }
- private void DataGrid_CurrentCellValueChanged(object? sender, CurrentCellValueChangedEventArgs e)
- {
- var headerrows = Options.Contains(DynamicGridOption.FilterRows) ? 2 : 1;
- if (e.RowColumnIndex.RowIndex < headerrows)
- return;
- if (e.Column is GridCheckBoxColumn)
- inplaceeditor = LoadItem(Data.Rows[e.RowColumnIndex.RowIndex - headerrows]);
- if(inplaceeditor is not null)
- UpdateData(inplaceeditor, e.RowColumnIndex.ColumnIndex);
- if (e.Column is GridCheckBoxColumn)
- inplaceeditor = null;
- if (inplaceeditor is not null)
- bChanged = true;
- }
- private void DataGrid_CurrentCellDropDownSelectionChanged(object? sender, CurrentCellDropDownSelectionChangedEventArgs e)
- {
- var headerrows = Options.Contains(DynamicGridOption.FilterRows) ? 2 : 1;
- if (e.RowColumnIndex.RowIndex < headerrows)
- return;
- inplaceeditor ??= LoadItem(Data.Rows[e.RowColumnIndex.RowIndex - headerrows]);
- if (inplaceeditor != null)
- bChanged = true;
- }
- protected void UpdateCell(int row, string colname, object value)
- {
- var table = DataGridItems;
- var colno = table.Columns.IndexOf(colname);
- var corecol = Data.Columns[colno].ColumnName;
- var corerow = Data.Rows[row];
- corerow[corecol] = value;
- var datarow = table.Rows[row];
- datarow[colname] = value;
- }
- private void DataGrid_CurrentCellEndEdit(object? sender, CurrentCellEndEditEventArgs e)
- {
- var headerrows = Options.Contains(DynamicGridOption.FilterRows) ? 2 : 1;
- if (e.RowColumnIndex.RowIndex < headerrows)
- return;
- if (inplaceeditor is not null && bChanged) UpdateData(inplaceeditor, e.RowColumnIndex.ColumnIndex);
- bChanged = false;
- inplaceeditor = null;
- }
- private void UpdateData(T obj, int columnindex)
- {
- var table = DataGridItems;
- var iRow = SelectedRows.First().Index; //e.RowColumnIndex.RowIndex - (Options.Contains(DynamicGridOptions.FilterRows) ? 2 : 1);
- var row = table.Rows[iRow];
- var colname = DataGrid.Columns[columnindex].MappingName;
- var value = row[colname];
- var colno = table.Columns.IndexOf(colname);
- var corecol = Data.Columns[colno].ColumnName;
- var corerow = Data.Rows[iRow];
- corerow[corecol] = value;
- CoreUtils.SetPropertyValue(obj, corecol, value);
- SaveItem(obj);
- Data.LoadRow(corerow, obj);
- foreach (var column in Data.Columns.Where(x => !string.Equals(corecol, x.ColumnName)))
- {
- var scol = column.ColumnName.Replace('.', '_');
- row[scol] = corerow[column.ColumnName];
- }
- for (var i = 0; i < ActionColumns.Count; i++) row[string.Format("ActionColumn{0}", i)] = ActionColumns[i].Image.Invoke(corerow);
- }
- private void DataGrid_QueryRowHeight(object? sender, QueryRowHeightEventArgs e)
- {
- if (e.RowIndex > 0)
- {
- e.Height = DataGrid.RowHeight;
- if (DataGrid.GridColumnSizer.GetAutoRowHeight(e.RowIndex, gridRowResizingOptions, out var autoHeight))
- if (autoHeight > DataGrid.RowHeight)
- e.Height = autoHeight;
- e.Handled = true;
- }
- }
- private void DataGrid_SizeChanged(object sender, SizeChangedEventArgs e)
- {
- if (IsReady && !bRefreshing) ResizeColumns(DataGrid, e.NewSize.Width - 2, e.NewSize.Height - 2);
- }
- #region Row Selections
- protected CoreRow[] GetVisibleRows()
- {
- var items = DataGrid.ItemsSource;
- var result = new List<CoreRow>();
- var table = DataGridItems;
- var rows = DataGrid.View.Records.Select(x => (x.Data as DataRowView)!).ToList();
- foreach (var row in rows)
- {
- var iRow = table.Rows.IndexOf(row.Row);
- result.Add(Data.Rows[iRow]);
- }
- //foreach (var item in DataGrid.SelectedItems)
- //{
- // if (item is CoreRow)
- // {
- // //result.Add(item as CoreRow);
- // }
- // else
- // {
- // var datarow = item as System.Data.DataRowView;
- // int row = datarow.Row.Table.Rows.IndexOf(datarow.Row);
- // result.Add(Data.Rows[row]);
- // }
- //}
- return result.ToArray();
- }
- private CoreRow[] GetSelectedRows()
- {
- //Logger.Send(LogType.Information, ClientFactory.UserID, String.Format("{0}: GetSelectedRows({1})", this.GetType().EntityName(), DataGrid.SelectedItems.Count));
- var result = new List<CoreRow>();
- foreach (var item in DataGrid.SelectedItems)
- if (item is CoreRow)
- {
- //result.Add(item as CoreRow);
- }
- else
- {
- var datarow = item as DataRowView;
- if (datarow != null)
- {
- var row = datarow.Row.Table.Rows.IndexOf(datarow.Row);
- result.Add(Data.Rows[row]);
- }
- }
- return result.ToArray();
- }
- private void SetSelectedRows(CoreRow[] rows)
- {
- //Logger.Send(LogType.Information, ClientFactory.UserID, String.Format("{0}: SetSelectedRows({1})", this.GetType().EntityName(), rows.Length));
- // CoreTableAdapter<T> adapter = (CoreTableAdapter<T>)DataGrid.ItemsSource;
- DataGrid.SelectedItems.Clear();
- var bFirst = true;
- foreach (var row in rows.Where(x => x.Index > -1))
- {
- //DataTable table = (DataTable)DataGrid.ItemsSource;
- if (bFirst || Options.Contains(DynamicGridOption.MultiSelect))
- DataGrid.SelectedItems.Add(DataGrid.GetRecordAtRowIndex(row.Index + (Options.Contains(DynamicGridOption.FilterRows) ? 2 : 1)));
- bFirst = false;
- }
- }
- public override CoreRow[] SelectedRows
- {
- get => GetSelectedRows();
- set => SetSelectedRows(value);
- }
- protected virtual void SelectItems(CoreRow[]? rows)
- {
- OnSelectItem?.Invoke(this, new DynamicGridSelectionEventArgs(rows));
- }
- private bool bFilterVisible;
- private bool bSwallowKey;
- private void DataGrid_PreviewGotKeyboardFocus(object sender, KeyboardFocusChangedEventArgs e)
- {
- var bOld = bFilterVisible;
- if (e.NewFocus is GridFilterControl)
- bFilterVisible = true;
- else if (e.NewFocus is ScrollViewer || e.NewFocus is SfDataGrid)
- bFilterVisible = false;
- if (bOld && !bFilterVisible)
- {
- //Logger.Send(LogType.Information, "", String.Format("{0}: PreviewGotKeyboardFocus -> {1}", this.GetType().EntityName(), e.NewFocus.GetType().EntityName()));
- SelectItems(SelectedRows);
- bSwallowKey = true;
- }
- }
- private void DataGrid_KeyUp(object sender, KeyEventArgs e)
- {
- if (!bFilterVisible && !bSwallowKey && DataGrid.SelectedIndex > -1)
- //Logger.Send(LogType.Information, "", String.Format("{0}: KeyUp -> {1}", this.GetType().EntityName(), SelectedRows.Length));
- SelectItems(SelectedRows);
- bSwallowKey = false;
- if (IsSequenced)
- {
- if (e.Key == Key.X && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
- {
- CutToClipBuffer();
- }
- else if (e.Key == Key.C && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
- {
- CopyToClipBuffer();
- }
- else if (e.Key == Key.V && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
- {
- PasteFromClipBuffer();
- }
- else if (e.Key == Key.Escape)
- {
- ResetClipBuffer();
- InvalidateGrid();
- }
- }
- }
- private DispatcherTimer? clicktimer;
- private void StartTimer()
- {
- if (clicktimer is null)
- {
- clicktimer = new DispatcherTimer();
- clicktimer.Interval = TimeSpan.FromMilliseconds(200);
- clicktimer.Tick += (o, e) =>
- {
- clicktimer.IsEnabled = false;
- SelectItems(SelectedRows);
- };
- }
- clicktimer.IsEnabled = true;
- }
- private void StopTimer()
- {
- if (clicktimer is not null)
- clicktimer.IsEnabled = false;
- }
- private void DataGrid_MouseRightButtonUp(object sender, MouseButtonEventArgs e)
- {
- if (!IsEnabled)
- return;
- var visualContainer = DataGrid.GetVisualContainer();
- var rowcolumnindex = visualContainer.PointToCellRowColumnIndex(e.GetPosition(visualContainer));
- var columnindex = DataGrid.ResolveToGridVisibleColumnIndex(rowcolumnindex.ColumnIndex);
- var column = ColumnList[columnindex] as DynamicActionColumn;
- var rowindex = rowcolumnindex.RowIndex - (Options.Contains(DynamicGridOption.FilterRows) ? 2 : 1);
- if (rowindex < 0)
- return;
- var row = Data.Rows[rowindex];
- var menu = column?.ContextMenu?.Invoke(SelectedRows);
- if (menu != null && menu.Items.Count > 0)
- menu.IsOpen = true;
- }
- private void DataGrid_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
- {
- if (!IsEnabled)
- return;
- // Header Click Here!
- if (DataGrid.SelectedIndex == -1)
- {
- var visualContainer = DataGrid.GetVisualContainer();
- var rowcolumnindex = visualContainer.PointToCellRowColumnIndex(e.GetPosition(visualContainer));
- var columnindex = DataGrid.ResolveToGridVisibleColumnIndex(rowcolumnindex.ColumnIndex);
- if (columnindex > -1 && columnindex < ColumnList.Count)
- {
- var bRefresh = false;
- var dac = ColumnList[columnindex] as DynamicActionColumn;
- if (dac != null)
- if (dac.Action?.Invoke(null) == true)
- bRefresh = true;
- if (bRefresh)
- Dispatcher.Invoke(() => { Refresh(false, true); });
- }
- }
- else if (!bFilterVisible)
- {
- StartTimer();
- }
- bSwallowKey = false;
- }
- private void DataGrid_CellTapped(object? sender, GridCellTappedEventArgs e)
- {
- if (!IsEnabled)
- return;
- var dac = ColumnList[e.RowColumnIndex.ColumnIndex] as DynamicActionColumn;
- if (dac != null)
- {
- var bRefresh = false;
- {
- foreach (var row in SelectedRows)
- if (dac.Action?.Invoke(row) == true)
- bRefresh = true;
- }
- if (bRefresh)
- Task.Run(() => { Dispatcher.Invoke(() => { Refresh(false, true); }); });
- }
- else
- {
- StartTimer();
- }
- }
- protected virtual void DoDoubleClick(object sender)
- {
- if (Options.Contains(DynamicGridOption.DirectEdit))
- return;
- SelectItems(SelectedRows);
- var args = new HandledEventArgs(false);
- OnDoubleClick?.Invoke(sender, args);
- if (args.Handled)
- return;
- if (Options.Contains(DynamicGridOption.EditRows))
- DoEdit();
- }
- private void DataGrid_CellDoubleTapped(object? sender, GridCellDoubleTappedEventArgs e)
- {
- StopTimer();
- if (e.Record != null)
- DoDoubleClick(this);
- }
- #endregion
- #region Column Handling
- private readonly List<object> ColumnList = new();
- protected virtual DynamicGridColumns LoadColumns()
- {
- var result = new DynamicGridColumns();
- var cols = Options.Contains(DynamicGridOption.DirectEdit)
- ? new Columns<T>().Default(ColumnType.IncludeForeignKeys)
- : new Columns<T>().Default(ColumnType.IncludeLinked);
- result.AddRange(MasterColumns.Where(x => cols.Items.Any(c => c.Property.Equals(x.ColumnName)))
- .OrderBy(x => CoreUtils.GetPropertySequence(typeof(T), x.ColumnName)));
- return result;
- }
- private bool SwapRows(int row1, int row2)
- {
- CoreRow[] rows = Data.Rows.Where(x => x.Index.Equals(row1) || x.Index.Equals(row2)).ToArray();
- var items = LoadItems(rows);
- var first = (items.First() as ISequenceable)!;
- var last = (items.Last() as ISequenceable)!;
- var iBuf1 = first.Sequence;
- var iBuf2 = last.Sequence;
- first.Sequence = iBuf2;
- last.Sequence = iBuf1;
- SaveItems(items);
- return true;
- }
- protected virtual void SaveColumns(DynamicGridColumns columns)
- {
- }
- public override int DesiredWidth()
- {
- var result = 0;
- for (var i = 0; i < ColumnList.Count; i++)
- {
- var col = ColumnList[i];
- if (col is DynamicActionColumn)
- {
- result += (int)RowHeight;
- }
- else if (col is DynamicGridColumn)
- {
- var dgc = (DynamicGridColumn)col;
- result += dgc.Width > 0 ? dgc.Width : 300;
- }
- }
- return result;
- }
- private void ResizeColumns(SfDataGrid grid, double width, double height)
- {
- if (Data == null || width <= 0)
- return;
- var fAvailWidth = width;
- //if (Data.Rows.Count * (DataGrid.RowHeight + 1) + DataGrid.HeaderRowHeight > height + 0.5F)
- if(height < DataGrid.AutoScroller.VScrollBar.Maximum)
- fAvailWidth -= (SystemParameters.VerticalScrollBarWidth+0.75);
- double fCurWidth = 0.0F;
- var NumAutoCols = 0;
- var colWidths = new Dictionary<int, double>();
- for (var i = 0; i < ColumnList.Count; i++)
- {
- var col = ColumnList[i];
- if (col is DynamicActionColumn dac)
- {
- colWidths[i] = dac.Width == 0 ? RowHeight : dac.Width;
- fCurWidth += colWidths[i];
- }
- else if (col is DynamicGridColumn dgc)
- {
- colWidths[i] = dgc.Width;
- if (dgc.Width != 0)
- fCurWidth += Math.Max(0.0F, dgc.Width);
- else
- NumAutoCols++;
- }
- }
- if (NumAutoCols > 0)
- {
- var fAutoWidth = (fAvailWidth - fCurWidth) / NumAutoCols;
- if (fAutoWidth < 100)
- fAutoWidth = 100;
- for (var i = 0; i < ColumnList.Count; i++)
- if (colWidths[i] == 0)
- colWidths[i] = fAutoWidth;
- }
- foreach (var index in colWidths.Keys)
- DataGrid.Columns[index].Width = Math.Max(0.0F, colWidths[index]);
- var vc = DataGrid.GetVisualContainer();
- vc.RowHeightManager.Reset();
- vc.InvalidateMeasureInfo();
- if (vc.ScrollOwner != null)
- vc.ScrollOwner.HorizontalScrollBarVisibility = vc.ExtentWidth <= fAvailWidth ? ScrollBarVisibility.Hidden : ScrollBarVisibility.Visible;
- }
- private void LoadActionColumns(DynamicActionColumnPosition position)
- {
- for (var i = 0; i < ActionColumns.Count; i++)
- {
- var column = ActionColumns[i];
- if (column.Position == position)
- {
- //String sColName = String.Format("ActionColumn{0}{1}", i, position == DynamicActionColumnPosition.Start ? "L" : "R");
- var sColName = string.Format("ActionColumn{0}", i);
- gridRowResizingOptions.ExcludeColumns.Add(sColName);
- var newcol = new GridImageColumn();
- newcol.MappingName = sColName;
- //newcol.Stretch = Stretch.Uniform;
- newcol.Width = column.Width == 0 ? DataGrid.RowHeight : column.Width;
- newcol.Padding = new Thickness(4);
- newcol.ImageHeight = DataGrid.RowHeight - 8;
- newcol.ImageWidth = DataGrid.RowHeight - 8;
- newcol.ColumnSizer = GridLengthUnitType.None;
- newcol.HeaderText = column.HeaderText;
- newcol.AllowFiltering = column.Filters != null && column.Filters.Any();
- newcol.AllowSorting = false;
- newcol.FilterRowOptionsVisibility = Visibility.Collapsed;
- newcol.ShowToolTip = column.ToolTip != null;
- var style = new Style();
- style.Setters.Add(new Setter(BackgroundProperty, new SolidColorBrush(Colors.Gainsboro)));
- style.Setters.Add(new Setter(IsEnabledProperty, false));
- newcol.FilterRowCellStyle = style;
-
- var headstyle = new Style(typeof(GridHeaderCellControl));
- headstyle.Setters.Add(new Setter(BackgroundProperty, new SolidColorBrush(Colors.Gainsboro)));
- headstyle.Setters.Add(new Setter(ForegroundProperty, new SolidColorBrush(Colors.Black)));
- headstyle.Setters.Add(new Setter(FontSizeProperty, 12D));
- if (!string.IsNullOrWhiteSpace(column.HeaderText))
- {
- //headstyle.Setters.Add(new Setter(LayoutTransformProperty, new RotateTransform(270.0F)));
- headstyle.Setters.Add(new Setter(BorderThicknessProperty, new Thickness(0.0, 0.0, 0, 0)));
- headstyle.Setters.Add(new Setter(MarginProperty, new Thickness(0, 0, 0.75, 0.75)));
- headstyle.Setters.Add(new Setter(TemplateProperty, Application.Current.Resources["VerticalColumnHeader"] as ControlTemplate));
- }
- else
- {
- var image = column.Image?.Invoke(null);
- if (image != null)
- {
- var template = new ControlTemplate(typeof(GridHeaderCellControl));
- var border = new FrameworkElementFactory(typeof(Border));
- border.SetValue(Border.BackgroundProperty, new SolidColorBrush(Colors.Gainsboro));
- border.SetValue(Border.PaddingProperty, new Thickness(4));
- border.SetValue(MarginProperty, new Thickness(0, 0, 1, 1));
- var img = new FrameworkElementFactory(typeof(Image));
- img.SetValue(Image.SourceProperty, image);
- border.AppendChild(img);
- template.VisualTree = border;
- headstyle.Setters.Add(new Setter(TemplateProperty, template));
- }
- }
- newcol.HeaderStyle = headstyle;
- DataGrid.Columns.Add(newcol);
- ColumnList.Add(column);
- }
- }
- }
- private bool CanSort()
- {
- return !IsSequenced;
- }
- private void ReloadColumns()
- {
- ConfigureColumns(MasterColumns /*, false */);
- VisibleColumns = LoadColumns();
- ConfigureColumns(VisibleColumns /*, true */);
- DataGrid.Columns.Suspend();
- ColumnList.Clear();
- DataGrid.Columns.Clear();
- DataGrid.TableSummaryRows.Clear();
- var Summaries = new ObservableCollection<ISummaryColumn>();
- gridRowResizingOptions.ExcludeColumns = new List<string>();
- LoadActionColumns(DynamicActionColumnPosition.Start);
- foreach (var column in VisibleColumns)
- {
- var filtering = true;
- IProperty? prop;
- try
- {
- prop = DatabaseSchema.Property(typeof(T), column.ColumnName);
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, ClientFactory.UserID,
- string.Format("Error constructing Column [{0}] : {1}\n{2}", column.ColumnName, e.Message, e.StackTrace));
- prop = null;
- }
- if (prop != null)
- {
- var scolname = column.ColumnName.Replace('.', '_');
- GridColumn newcol;
- if (prop.PropertyType.IsNumeric())
- {
- var digits = 0;
- var prefix = "N";
- if (column.Editor is CurrencyEditor currencyEditor)
- {
- var curcol = new GridCurrencyColumn();
- if (!prop.PropertyType.IsOrdinal())
- {
- var format = string.IsNullOrWhiteSpace(column.Format) ? "" : column.Format.Replace("C", "");
- if (!int.TryParse(format, out digits))
- digits = currencyEditor.Digits;
- }
- curcol.CurrencyDecimalDigits = digits;
- curcol.CurrencyGroupSeparator = ",";
- curcol.CurrencyGroupSizes = new Int32Collection(new[] { 3, 3, 3, 3, 3, 3 });
- prefix = "C";
- newcol = curcol;
- }
- else
- {
- var numcol = new GridNumericColumn();
- if (!prop.PropertyType.IsOrdinal())
- {
- var format = string.IsNullOrWhiteSpace(column.Format) ? "" : column.Format.Replace("F", "");
- if (!int.TryParse(format, out digits))
- digits = column.Editor is DoubleEditor doubleEditor ? doubleEditor.Digits : 0;
- numcol.NumberDecimalDigits = digits;
- numcol.NumberGroupSeparator = ",";
- numcol.NumberGroupSizes = new Int32Collection(new[] { 3, 3, 3, 3, 3, 3 });
- }
- else
- {
- numcol.NumberGroupSeparator = "";
- numcol.NumberDecimalDigits = 0;
- }
- prefix = "N";
- newcol = numcol;
- }
- if (prop.Editor.Summary != Summary.None)
- {
- var summary = new GridSummaryColumn
- {
- Name = scolname,
- Format = "{" + (prop.Editor.Summary == Summary.Sum ? "Sum" : "Count") + ":" +
- string.Format("{0}{1}", prefix, digits) +
- "}",
- MappingName = scolname,
- SummaryType = prop.Editor.Summary == Summary.Sum
- ? prop.PropertyType.IsOrdinal() ? SummaryType.Int32Aggregate : SummaryType.DoubleAggregate
- : SummaryType.CountAggregate
- };
- Summaries.Add(summary);
- }
- }
- else if (prop.PropertyType == typeof(DateTime))
- {
- newcol = new GridDateTimeColumn
- {
- CustomPattern = column.Format,
- Pattern = !string.IsNullOrWhiteSpace(column.Format) ? DateTimePattern.CustomPattern : DateTimePattern.ShortDate
- };
- }
- else if (prop.PropertyType == typeof(TimeSpan))
- {
- newcol = new GridTimeSpanColumn
- {
- DisplayBinding = new Binding
- {
- Path = new PropertyPath(scolname),
- Converter = new TimeSpanToStringConverter(column.Format)
- },
- Format = column.Format, //.Replace(":", "':'"),
- ShowArrowButtons = false
- };
- filtering = false;
- if (prop.Editor != null && prop.Editor.Summary != Summary.None)
- {
- var summary = new GridSummaryColumn
- {
- Name = scolname,
- Format = "{" + (prop.Editor.Summary == Summary.Sum
- ? "Sum" + (string.IsNullOrWhiteSpace(column.Format) ? "" : ":" + column.Format.Replace(":", "':'"))
- : prop.Editor.Summary == Summary.Count
- ? "Count"
- : "") + "}",
- MappingName = scolname,
- SummaryType = prop.Editor.Summary == Summary.Sum ? SummaryType.Custom : SummaryType.CountAggregate,
- CustomAggregate = new TimeSpanAggregate()
- };
- Summaries.Add(summary);
- }
- }
- else if (prop.PropertyType == typeof(bool))
- {
- if (Options.Contains(DynamicGridOption.DirectEdit))
- {
- var checkcol = new GridCheckBoxColumn
- {
- ValueBinding = new Binding
- {
- Path = new PropertyPath(scolname)
- },
- IsThreeState = false
- };
- newcol = checkcol;
- }
- else
- {
- var imgcol = new GridImageColumn
- {
- ValueBinding = new Binding
- {
- Path = new PropertyPath(scolname),
- Converter = new BoolToImageConverter()
- },
- ImageHeight = DataGrid.RowHeight - 8,
- ImageWidth = DataGrid.RowHeight - 8,
- Padding = new Thickness(4)
- };
- newcol = imgcol;
- }
- gridRowResizingOptions.ExcludeColumns.Add(scolname);
- filtering = false;
- }
- else if (prop.Editor is ColorEditor)
- {
- var imgcol = new GridImageColumn
- {
- ValueBinding = new Binding
- {
- Path = new PropertyPath(scolname),
- Converter = new StringToColorImageConverter(column.Width - 8, (int)DataGrid.RowHeight - 8)
- },
- ImageHeight = DataGrid.RowHeight - 8,
- ImageWidth = column.Width - 8,
- Padding = new Thickness(4)
- };
- gridRowResizingOptions.ExcludeColumns.Add(scolname);
- newcol = imgcol;
- filtering = false;
- }
- else if (prop.Editor is ILookupEditor lookupEditor)
- {
- var lookupcol = new GridComboBoxColumn();
- //var lookups = editor.Values(column.ColumnName).ToDictionary(column.ColumnName, "Display");
- //lookupcol.SelectedValuePath = "Key";
- //lookupcol.DisplayMemberPath = "Value";
- //lookupcol.ItemsSource = lookups;
- var table = lookupEditor.Values(column.ColumnName).ToDataTable();
- lookupcol.SelectedValuePath = table.Columns[0].ColumnName;
- lookupcol.DisplayMemberPath = "Display";
- lookupcol.ItemsSource = table.DefaultView;
- newcol = lookupcol;
- }
- else
- {
- var textcol = new GridTextColumn();
- if (!(prop.Editor is MemoEditor))
- gridRowResizingOptions.ExcludeColumns.Add(scolname);
- textcol.TextWrapping = TextWrapping.NoWrap;
- newcol = textcol;
- if (prop.PropertyType == typeof(string[]))
- newcol.DisplayBinding = new Binding { Path = new PropertyPath(scolname), Converter = new StringArrayConverter() };
- textcol.AllowEditing = Options.Contains(DynamicGridOption.DirectEdit);
- textcol.UpdateTrigger = UpdateSourceTrigger.PropertyChanged;
- }
- DataGrid.SummaryCalculationUnit = SummaryCalculationUnit.AllRows;
- DataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowSummaryUpdate;
- newcol.MappingName = scolname;
- newcol.Width = column.Width; // != 0 ? column.Width : double.NaN;
- newcol.ColumnSizer =
- GridLengthUnitType.None; //column.Width != 0 ? GridLengthUnitType.None : GridLengthUnitType.AutoWithLastColumnFill;
- newcol.HeaderText = string.IsNullOrWhiteSpace(column.Caption) ? column.ColumnName : column.Caption;
- newcol.TextAlignment = column.Alignment == Alignment.NotSet
- ? prop.PropertyType.IsNumeric() ? TextAlignment.Right : TextAlignment.Left
- : column.Alignment == Alignment.BottomLeft || column.Alignment == Alignment.MiddleLeft ||
- column.Alignment == Alignment.TopLeft
- ? TextAlignment.Left
- : column.Alignment == Alignment.BottomCenter || column.Alignment == Alignment.MiddleCenter ||
- column.Alignment == Alignment.TopCenter
- ? TextAlignment.Center
- : TextAlignment.Right;
- newcol.HorizontalHeaderContentAlignment = newcol.TextAlignment == TextAlignment.Left ? HorizontalAlignment.Left
- : newcol.TextAlignment == TextAlignment.Center ? HorizontalAlignment.Center
- : HorizontalAlignment.Right;
- var filterstyle = new Style();
- if (filtering)
- {
- filterstyle.Setters.Add(new Setter(BackgroundProperty, BaseDynamicGrid.FilterBackground));
- newcol.ImmediateUpdateColumnFilter = true;
- newcol.ColumnFilter = ColumnFilter.Value;
- newcol.FilterRowCondition = FilterRowCondition.Contains;
- newcol.FilterRowOptionsVisibility = Visibility.Collapsed;
- newcol.AllowBlankFilters = true;
- newcol.AllowSorting = CanSort();
- }
- else
- {
- filterstyle.Setters.Add(new Setter(BackgroundProperty, new SolidColorBrush(Colors.Gainsboro)));
- filterstyle.Setters.Add(new Setter(IsEnabledProperty, false));
- newcol.ColumnFilter = ColumnFilter.Value;
- newcol.AllowFiltering = false;
- newcol.AllowSorting = false;
- newcol.FilterRowEditorType = "TextBox";
- newcol.FilterRowOptionsVisibility = Visibility.Collapsed;
- }
- newcol.FilterRowCellStyle = filterstyle;
- var headstyle = new Style(typeof(GridHeaderCellControl));
- headstyle.Setters.Add(new Setter(BackgroundProperty, new SolidColorBrush(Colors.Gainsboro)));
- headstyle.Setters.Add(new Setter(ForegroundProperty, new SolidColorBrush(Colors.Black)));
- headstyle.Setters.Add(new Setter(FontSizeProperty, 12D));
- newcol.HeaderStyle = headstyle;
- var cellstyle = new Style();
- if (Options.Contains(DynamicGridOption.DirectEdit))
- {
- if (prop.Editor is null || prop.Editor.Editable != Editable.Enabled)
- {
- cellstyle.Setters.Add(new Setter(BackgroundProperty, new SolidColorBrush(Colors.WhiteSmoke)));
- newcol.AllowEditing = false;
- }
- else
- {
- cellstyle.Setters.Add(new Setter(BackgroundProperty, new SolidColorBrush(Colors.LightYellow)));
- newcol.AllowEditing = true;
- }
- cellstyle.Setters.Add(new Setter(ForegroundProperty, new SolidColorBrush(Colors.Black)));
- newcol.CellStyle = cellstyle;
- }
- DataGrid.Columns.Add(newcol);
- ColumnList.Add(column);
- }
- }
- LoadActionColumns(DynamicActionColumnPosition.End);
- if (Summaries.Any())
- {
- DataGrid.CellRenderers.Remove("TableSummary");
- DataGrid.CellRenderers.Add("TableSummary", new TimeSpanAggregateRenderer());
- DataGrid.TableSummaryRows.Add(new GridTableSummaryRow
- {
- ShowSummaryInRow = false,
- Position = TableSummaryRowPosition.Bottom,
- SummaryColumns = Summaries
- });
- }
- DataGrid.Columns.Resume();
- DataGrid.RefreshColumns();
-
- foreach (var key in _filterpredicates.Keys.ToArray())
- if (DataGrid.Columns.Any(x => string.Equals(x.MappingName, key)))
- {
- var predicates = Serialization.Deserialize<List<FilterPredicate>>(_filterpredicates[key]);
- foreach (var predicate in predicates)
- {
- DataGrid.Columns[key].FilterPredicates.Add(predicate);
- DataGrid.Columns[key].FilteredFrom = FilteredFrom.FilterRow;
- }
- }
- else
- {
- _filterpredicates.Remove(key);
- }
- ResizeColumns(DataGrid, DataGrid.ActualWidth - 2, DataGrid.ActualHeight - 2);
- }
- #endregion
- #region Refresh / Reload
- protected abstract void Reload(Filters<T> criteria, Columns<T> columns, ref SortOrder<T>? sort, Action<CoreTable?, Exception?> action);
- protected virtual bool FilterRecord(CoreRow row)
- {
- var bOK = true;
- foreach (var column in ActionColumns.Where(x => x.FilterRecord != null && x.SelectedFilters != null && x.SelectedFilters.Any()))
- bOK = bOK && column.FilterRecord.Invoke(row, column.SelectedFilters);
- if (bOK && OnFilterRecord is not null)
- bOK = OnFilterRecord(row);
- return bOK;
- }
- public override void Refresh(bool reloadcolumns, bool reloaddata)
- {
- //DataGrid.View.Filter = DoFilterRecord;
- if (bRefreshing)
- return;
-
- DataGrid.SelectionForegroundBrush = BaseDynamicGrid.SelectionForeground;
- DataGrid.RowSelectionBrush = BaseDynamicGrid.SelectionBackground;
- var cursor = UseWaitCursor ? new WaitCursor() : null;
- Loading.Visibility = Visibility.Visible;
- double opacity = 1.0F;
- var bFading = true;
- var timer = (DispatcherTimer)Loading.Tag;
- Loading.Tag = timer;
- timer.Tick += (o, e) =>
- {
- if (bFading)
- opacity -= 0.05F;
- else
- opacity += 0.05F;
- if (opacity >= 1.0F)
- {
- opacity = 1.0F;
- bFading = true;
- }
- else if (opacity <= 0.2F)
- {
- opacity = 0.2F;
- bFading = false;
- }
- Loading.Opacity = opacity;
- };
- timer.IsEnabled = true;
- bRefreshing = true;
- // Yo, please don't remove this.
- // The issue was when we were dynamically adding ActionColumns, and if we had to remove and then re-add them, we were getting massive performance hits
- // for no reason. I think perhaps the image columns were trying to refer to data that didn't exist anymore when calling DataGrid.Columns.Refresh(),
- // and thus some mega problems (perhaps even exceptions within Syncfusion) were occurring, and this seems to fix it.
- // I don't pretend to know why it works; this is probably the strangest problem I've ever come across.
- DataGrid.ItemsSource = null;
- //using (var d = Dispatcher.DisableProcessing())
- {
- if (reloadcolumns)
- ReloadColumns();
- if (reloaddata)
- {
- _lookupcache.Clear();
- var criteria = new Filters<T>();
- var filter = DefineFilter();
- if (filter != null)
- criteria.Add(filter);
- var columns = DataColumns();
- var sort = LookupFactory.DefineSort<T>();
- if (sort == null && IsSequenced)
- sort = new SortOrder<T>("Sequence");
- Reload(
- criteria
- , columns
- , ref sort
- , (table, exception) =>
- {
- if (exception != null)
- {
- Dispatcher.Invoke(() =>
- {
- MessageBox.Show(String.Format("Error: {0}", exception.Message));
- });
- }
- else if(table is not null)
- {
- MasterData = table;
- Dispatcher.Invoke(() =>
- {
- ProcessData(reloadcolumns, reloaddata);
- DoAfterReload();
- });
- }
- }
- );
- }
- else
- {
- ProcessData(reloadcolumns, reloaddata);
- DoAfterReload();
- }
- }
- bRefreshing = false;
- IsReady = true;
- if (cursor != null)
- {
- cursor.Dispose();
- cursor = null;
- }
- }
- public Columns<T> DataColumns()
- {
- var columns = new Columns<T>();
- foreach (var column in VisibleColumns)
- columns.Add(column.ColumnName);
- foreach (var column in HiddenColumns)
- columns.Add(column);
- return columns;
- }
- private void ProcessData(bool reloadcolumns, bool reloaddata)
- {
- Data.Columns.Clear();
- if (MasterData != null)
- foreach (var column in MasterData.Columns)
- Data.Columns.Add(column);
- FilterRows();
- }
- private readonly Dictionary<CoreRow, CoreRow> _recordmap = new();
- public override void UpdateRow<TRow, TType>(CoreRow row, Expression<Func<TRow, TType>> column, TType value, bool refresh = true)
- {
- row.Set(column, value);
- _recordmap[row].Set(column, value);
- if (refresh)
- InvalidateRow(row);
- }
- public override void UpdateRow<TType>(CoreRow row, string column, TType value, bool refresh = true)
- {
- row.Set(column, value);
- _recordmap[row].Set(column, value);
- if (refresh)
- InvalidateRow(row);
- }
- public void AddRow(CoreRow row)
- {
- if (MasterData is null) return;
- var masterrow = MasterData.NewRow();
- MasterData.LoadRow(masterrow, row);
- Refresh(false, false);
- }
- public void AddRow(T data)
- {
- if (MasterData is null) return;
- var masterrow = MasterData.NewRow();
- MasterData.LoadRow(masterrow, data);
- MasterData.Rows.Add(masterrow);
- Refresh(false, false);
- }
- public void DeleteRow(CoreRow row)
- {
- if (MasterData is null) return;
- var masterrow = _recordmap[row];
- MasterData.Rows.Remove(masterrow);
- Refresh(false, false);
- }
- private void FilterRows()
- {
- ResetClipBuffer();
- Data.Rows.Clear();
- _recordmap.Clear();
- if (MasterData is null)
- return;
- foreach (var row in MasterData.Rows)
- if (FilterRecord(row))
- {
- var newrow = Data.NewRow();
- for (var i = 0; i < Data.Columns.Count; i++)
- {
- var value = i < row.Values.Count ? row.Values[i] : null;
- if (Data.Columns[i].DataType.IsNumeric())
- value = Data.Columns[i].DataType.IsDefault(value) ? null : value;
- //else if (Data.Columns[i].DataType == typeof(String[]))
- // value = String.Join("\n", value as String[]);
- newrow.Values.Add(value);
- }
- //newrow.Values.AddRange(row.Values);
- //if ((OnFilterRecord == null) || (OnFilterRecord(row)))
- Data.Rows.Add(newrow);
- _recordmap[newrow] = row;
- }
- InvalidateGrid();
- //ScrollBar.Value = _CurrentRow <= 0 ? 0 : _CurrentRow;
- SelectedRows = new CoreRow[] { };
- }
- //IncrementalList<T> _data = null;
- private void InvalidateRow(CoreRow row)
- {
- var rowdata = new List<object?>(row.Values);
- foreach (var ac in ActionColumns)
- rowdata.Add(ac.Image.Invoke(row));
- var datarow = DataGridItems.Rows[row.Index];
- for (var i = 0; i < rowdata.Count; i++)
- datarow[i] = rowdata[i] ?? DBNull.Value;
- //datarow.ItemArray = rowdata.ToArray();
- }
- private void InvalidateGrid()
- {
- var defaults = new List<object>();
- var result = new DataTable();
- foreach (var column in Data.Columns)
- {
- var colname = column.ColumnName.Replace('.', '_');
- if (!result.Columns.Contains(colname))
- {
- result.Columns.Add(colname, column.DataType);
- if (!Options.Contains(DynamicGridOption.DirectEdit))
- defaults.Add(column.DataType.GetDefault());
- }
- }
- for (var i = 0; i < ActionColumns.Count; i++)
- result.Columns.Add(string.Format("ActionColumn{0}", i), typeof(BitmapImage));
- foreach (var row in Data.Rows)
- {
- var newrow = result.NewRow();
- CoreRowToDataRow(newrow, row, defaults);
- result.Rows.Add(newrow);
- }
- if (StyleSelector != null)
- StyleSelector.Data = Data;
- //int rowIndex = DataGrid.SelectionController.CurrentCellManager.CurrentRowColumnIndex.RowIndex;
- //int columnIndex = DataGrid.SelectionController.CurrentCellManager.CurrentRowColumnIndex.ColumnIndex;
- //int scrollRowIndex = DataGrid.GetVisualContainer().ScrollRows.LastBodyVisibleLineIndex;
- DataGrid.ItemsSource = result;
- //this.DataGrid.ScrollInView(new Syncfusion.UI.Xaml.ScrollAxis.RowColumnIndex(scrollRowIndex, columnIndex));
- ResizeColumns(DataGrid, DataGrid.ActualWidth - 1, DataGrid.ActualHeight);
- UpdateRecordCount();
- Loading.Visibility = Visibility.Collapsed;
- var timer = (DispatcherTimer)Loading.Tag;
- timer.IsEnabled = false;
- }
- private void UpdateRecordCount()
- {
- var count = DataGrid.View != null ? DataGrid.View.Records.Count : Data.Rows.Count;
- Count.Content = string.Format("{0} Records", count);
- //Count.Visibility = _Options.Contains(DynamicGridOptions.RecordCount) && (count > 0) ? Visibility.Visible : Visibility.Collapsed;
- }
- public IList<CoreRow> FilteredRows()
- {
- var result = new List<CoreRow>();
- var table = DataGridItems;
- var rows = DataGrid.View.Records.Select(x => (x.Data as DataRowView)!).ToList();
- foreach (var row in rows)
- {
- var iRow = table.Rows.IndexOf(row.Row);
- result.Add(Data.Rows[iRow]);
- }
- return result;
- }
- // Doesn't appear to be used - removed 19/12/2022
- /*private object?[] CreateRowValues(CoreRow row, List<object> defaults)
- {
- var rowdata = new List<object?>(row.Values);
- foreach (var ac in ActionColumns)
- rowdata.Add(ac.Image.Invoke(row));
- var result = ProcessRow(rowdata, defaults);
- return result.ToArray();
- }*/
- private void CoreRowToDataRow(DataRow newrow, CoreRow row, List<object> defaults)
- {
- var rowdata = new List<object?>(row.Values);
- foreach (var ac in ActionColumns)
- rowdata.Add(ac.Image.Invoke(row));
- try
- {
- var data = ProcessRow(rowdata, defaults).ToArray();
- newrow.ItemArray = data;
- }
- catch (Exception)
- {
- throw;
- }
- }
- private static IEnumerable<object?> ProcessRow(List<object?> values, List<object> defaults)
- {
- if (defaults == null || !defaults.Any())
- return values;
- var result = new List<object?>();
- for (var i = 0; i < values.Count; i++)
- {
- var value = values[i];
- var defaultvalue = i < defaults.Count ? defaults[i] : null;
- result.Add(value == null || (value.Equals(defaultvalue) && !value.GetType().IsEnum) ? null : value);
- }
- return result;
- }
- //private void LoadMoreItems(uint count, int from)
- //{
- // var rows = Data.Rows.Skip(from).AsQueryable().Take(50);
- // _data.LoadItems(rows.Select(x => x.ToObject<T>()));
- // //var list = _orders.Skip(baseIndex).Take(50).ToList();
- // //IncrementalItemsSource.LoadItems(list);
- //}
- public override void AddVisualFilter(string column, string value)
- {
- if (!string.IsNullOrWhiteSpace(value))
- {
- DataGrid.Columns[column].FilterPredicates.Add(new FilterPredicate { FilterType = FilterType.Contains, FilterValue = value });
- }
- }
- #endregion
- #region Item Manipulation
- protected virtual T[] LoadItems(CoreRow[] rows)
- {
- var result = new List<T>();
- foreach (var row in rows)
- {
- var index = Data.Rows.IndexOf(row);
- result.Add(LoadItem(row));
- }
- return result.ToArray();
- }
- protected abstract T LoadItem(CoreRow row);
- protected abstract void SaveItem(T item);
- protected virtual void SaveItems(T[] items)
- {
- foreach (var item in items)
- SaveItem(item);
- }
- protected virtual bool CanDeleteItems(params CoreRow[] rows)
- {
- return true;
- }
- protected abstract void DeleteItems(params CoreRow[] rows);
- protected virtual void DoDelete()
- {
- var rows = SelectedRows.ToArray();
- if (rows.Any())
- if (CanDeleteItems(rows))
- if (MessageBox.Show("Are you sure you wish to delete the selected records?", "Confirm Delete", MessageBoxButton.YesNo) ==
- MessageBoxResult.Yes)
- {
- DeleteItems(rows);
- SelectedRows = Array.Empty<CoreRow>();
- OnChanged?.Invoke(this);
- Refresh(false, true);
- SelectItems(null);
- }
- }
- private void Delete_Click(object sender, RoutedEventArgs e)
- {
- DoDelete();
- }
- protected virtual void DoEdit()
- {
- if (!SelectedRows.Any())
- return;
- var sel = SelectedRows.ToArray();
- if (AddEditClick(SelectedRows))
- {
- InvalidateGrid();
- SelectedRows = sel;
- SelectItems(SelectedRows);
- }
- }
- private void Edit_Click(object sender, RoutedEventArgs e)
- {
- DoEdit();
- }
- private void MultiEdit_Click(object sender, RoutedEventArgs e)
- {
- using (new WaitCursor())
- {
- var criteria = new Filters<T>();
- var columns = new Columns<T>();
- columns.Add("ID");
- var iprops = DatabaseSchema.Properties(typeof(T)).Where(x => x.Editor is not NullEditor);
- foreach (var iprop in iprops)
- columns.Add(iprop.Name);
- var sort = LookupFactory.DefineSort<T>();
- Reload(
- criteria,
- columns,
- ref sort,
- (table, exception) =>
- {
- if(table is not null)
- {
- Dispatcher.Invoke(() => { DirectEdit(table); });
- }
- else if(exception is not null)
- {
- Logger.Send(LogType.Error, "", $"Error in MultiEdit: {CoreUtils.FormatException(exception)}");
- MessageBox.Show(exception.Message);
- }
- }
- );
- }
- }
- public override bool DirectEdit(CoreTable data)
- {
- var window = new DynamicEditWindow<T>();
- window.OnCreateItem += () => CreateItem();
- window.OnCustomiseColumns += (o, c) =>
- {
- ConfigureColumns(MasterColumns);
- if (OnCustomiseColumns != null)
- return OnCustomiseColumns(this, MasterColumns);
- return MasterColumns;
- };
- window.OnGetEditor += c =>
- {
- var result = GetEditor(this, c)?.CloneEditor();
- if (result == null)
- return null;
- OnCustomiseEditor?.Invoke(window, null, c, result);
- return result;
- };
- window.OnGetSequence += c =>
- {
- decimal result = 0.0M;
- var customprop = DatabaseSchema.Property(typeof(T), c.ColumnName);
- if (customprop != null && customprop is CustomProperty)
- {
- result = customprop.Sequence;
- }
- else
- {
- var bits = c.ColumnName.Split('.');
- for (var i = 0; i < bits.Length; i++)
- {
- var sProp = string.Join(".", bits.Take(bits.Length - i));
- PropertyInfo? prop;
- try
- {
- prop = CoreUtils.GetProperty(typeof(T), sProp);
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
- prop = null;
- }
- if (prop != null)
- {
- result = prop.GetSequence() + result / 1000.0M;
- }
- else
- {
- var cprop = DatabaseSchema.Property(typeof(T), sProp);
- if (cprop != null)
- result = cprop.Sequence;
- else
- result /= 1000.0M;
- }
- }
- }
- return result;
- };
- window.Load(data);
- if (window.ShowDialog() == true)
- {
- SaveItems(window.Updates);
- return true;
- }
- return false;
- }
- protected virtual void ShowHelp(string slug)
- {
- Process.Start(new ProcessStartInfo("https://prs-software.com.au/wiki/index.php/" + slug) { UseShellExecute = true });
- }
- protected virtual void DoAdd()
- {
- //CoreRow row = (SelectedRow > -1) && (SelectedRow < Data.Rows.Count) ? Data.Rows[this.SelectedRow] : null;
- if (AddEditClick(null))
- {
- Refresh(false, true);
- OnChanged?.Invoke(this);
- }
- }
- private void Add_Click(object sender, RoutedEventArgs e)
- {
- DoAdd();
- }
- protected void ReloadForms<TTargetType, TTargetForm, TSourceForm>(DynamicEditorForm editor, TTargetType item,
- Expression<Func<TSourceForm, object?>> sourcekey, Guid sourceid)
- where TTargetType : Entity, new()
- where TTargetForm : Entity, IRemotable, IPersistent, IDigitalFormInstance, new()
- where TSourceForm : Entity, IRemotable, IPersistent, IDigitalForm<TTargetType>, new()
- {
- var type = typeof(IDynamicOneToManyGrid<,>).MakeGenericType(typeof(TTargetType), typeof(TTargetForm));
- var page =
- editor.Pages.FirstOrDefault(x => x.GetType().GetInterfaces().Contains(type)) as IDynamicOneToManyGrid<TTargetType, TTargetForm>;
- if (page != null && item != null)
- {
- if (!page.Ready)
- page.Load(item, null);
- CoreTable table;
- if (sourceid == Guid.Empty)
- {
- table = new CoreTable();
- table.LoadColumns(typeof(TSourceForm));
- }
- else
- {
- table = new Client<TSourceForm>().Query(
- new Filter<TSourceForm>(sourcekey).IsEqualTo(sourceid).And(x => x.Form.AppliesTo)
- .IsEqualTo(typeof(TTargetType).EntityName().Split('.').Last())
- );
- }
- var newforms = new List<TTargetForm>();
- foreach (var row in table.Rows)
- {
- var sourceform = row.ToObject<TSourceForm>();
- var targetform = new TTargetForm();
- targetform.Form.ID = sourceform.Form.ID;
- targetform.Form.Synchronise(sourceform.Form);
- newforms.Add(targetform);
- }
- page.Items.Clear();
- page.LoadItems(newforms.ToArray());
- }
- }
- #region ClipBuffer
- private Tuple<ClipAction, CoreRow[]>? ClipBuffer;
- protected void ResetClipBuffer()
- {
- ClipBuffer = null;
- }
- protected void SetClipBuffer(ClipAction action, CoreRow[] rows)
- {
- ClipBuffer = new Tuple<ClipAction, CoreRow[]>(action, rows);
- }
- private void CutToClipBuffer()
- {
- SetClipBuffer(ClipAction.Cut, SelectedRows);
- InvalidateGrid();
- }
- private void CopyToClipBuffer()
- {
- SetClipBuffer(ClipAction.Copy, SelectedRows);
- InvalidateGrid();
- }
- private void PasteFromClipBuffer()
- {
- if (ClipBuffer == null)
- return;
- if (!IsSequenced)
- return;
- using (new WaitCursor())
- {
- var updates = ClipBuffer.Item2.Select(x => x.ToObject<T>()).ToList();
- if (BeforePaste(updates, ClipBuffer.Item1))
- {
- var currow = SelectedRows.FirstOrDefault()
- ?? Data.Rows.LastOrDefault();
- var sequence = currow != null ? currow.Get<T, long>(c => ((ISequenceable)c).Sequence) : 0;
- var postrows = Data.Rows.Where(r => !ClipBuffer.Item2.Contains(r) && r.Get<ISequenceable, long>(x => x.Sequence) >= sequence);
- updates.AddRange(LoadItems(postrows.ToArray()));
- foreach (var update in updates)
- {
- sequence++;
- ((ISequenceable)update).Sequence = sequence;
- }
- }
- if (updates.Any())
- {
- SaveItems(updates.ToArray());
- Refresh(false, true);
- }
- }
- }
- protected virtual bool BeforePaste(IEnumerable<T> items, ClipAction action)
- {
- return true;
- }
- #endregion
- private void Cut_Click(object sender, RoutedEventArgs e)
- {
- CutToClipBuffer();
- }
- private void Copy_Click(object sender, RoutedEventArgs e)
- {
- CopyToClipBuffer();
- }
- private void Paste_Click(object sender, RoutedEventArgs e)
- {
- PasteFromClipBuffer();
- }
- public virtual DynamicEditorPages LoadEditorPages(T item)
- {
- DynamicEditorPages pages = new DynamicEditorPages();
- DynamicGridUtils.LoadOneToManyPages(typeof(T), pages);
- DynamicGridUtils.LoadEnclosedListPages(typeof(T), pages);
- DynamicGridUtils.LoadManyToManyPages(typeof(T), pages);
- DynamicGridUtils.LoadCustomEditorPages(typeof(T), pages);
- foreach (var page in pages)
- page.Ready = false;
- return pages;
- }
- public virtual void LoadEditorButtons(T item, DynamicEditorButtons buttons)
- {
- buttons.Add(
- "",
- Properties.Resources.help.AsBitmapImage(),
- item,
- (f, i) =>
- {
- Process.Start(new ProcessStartInfo("https://prs-software.com.au/wiki/index.php/" + typeof(T).Name.SplitCamelCase().Replace(" ", "_"))
- { UseShellExecute = true });
- }
- );
- }
- protected virtual void CustomiseEditorForm(DynamicEditorForm form)
- {
- }
- public override bool EditItems(T[] items, Func<Type, CoreTable>? PageDataHandler = null, bool PreloadPages = false)
- {
- var cursor = new WaitCursor();
- var pages = items.Length == 1 ? LoadEditorPages(items.First()) : new DynamicEditorPages();
-
- var buttons = new DynamicEditorButtons();
- if (items.Length == 1)
- LoadEditorButtons(items.First(), buttons);
-
- var editor = new DynamicEditorForm(items.Any() ? items.First().GetType() : typeof(T), pages, buttons, PageDataHandler, PreloadPages);
- editor.SetValue(Panel.ZIndexProperty, 999);
-
- editor.OnCustomiseColumns += (o, c) =>
- {
- ConfigureColumns(MasterColumns /*, true */);
- return MasterColumns;
- };
- editor.OnDefineEditor += (o, c) =>
- {
- var result = GetEditor(o, c);
- if (result != null)
- result = result.CloneEditor();
- return result;
- };
- editor.OnFormCustomiseEditor += (o, i, c, e) => OnCustomiseEditor?.Invoke(o, (T[])i, c, e);
- editor.OnDefineFilter += (sender, type) => { return DefineFilter(type, items); };
- //editor.OnDefineFilter += (o, e) => { return DefineFilter(items, e); };
- editor.OnDefineLookups += sender => { DefineLookups(sender, items); };
- editor.OnLookupsDefined += sender => { LookupsDefined(sender, items); };
- editor.OnEditorValueChanged += (s, n, v) => { return EditorValueChanged(editor, items, n, v); };
- editor.ReconfigureEditors += g => { ReconfigureEditors(g, items); };
- editor.OnValidateData += (o, i) => { return ValidateData(items); };
- editor.OnSelectPage += SelectPage;
- editor.OnGetDocument += LoadDocument;
- editor.OnFindDocument += FindDocument;
- editor.OnSaveDocument += SaveDocument;
- editor.OnSaveItem += (o, e) =>
- {
- try
- {
- using var Wait = new WaitCursor();
- OnBeforeSave?.Invoke(editor, items);
- if (items.Length == 1)
- editor.UnloadEditorPages(pages, items.First(), false);
- foreach (var item in items)
- SaveItem(item);
- if (items.Length == 1)
- editor.UnloadEditorPages(pages, items.First(), true);
- OnAfterSave?.Invoke(editor, items);
- }
- catch (Exception err)
- {
- MessageBox.Show(err.Message);
- e.Cancel = true;
- }
- };
- CustomiseEditorForm(editor);
- editor.Items = items;
- AfterLoad(editor, items);
- cursor.Dispose();
- return editor.ShowDialog() == true;
- }
-
- private void UpdateEditor(DynamicEditorGrid grid, Expression<Func<IDimensioned, object?>> property, bool enabled)
- {
- var editor = grid.FindEditor(new Column<IDimensioned>(property).Property);
- if (editor == null)
- return;
- editor.IsEnabled = enabled;
- if (!enabled)
- editor.SetValue(0D);
- else
- {
- var value = editor.GetValue();
- editor.SetValue(value);
- }
- }
- protected virtual void ReconfigureEditors(DynamicEditorGrid grid, T[] items)
- {
- if (items.First() is IDimensioned dimensioned)
- {
- UpdateEditor(grid,x=>x.Dimensions.Quantity, dimensioned.Dimensions.GetUnit().HasQuantity);
- UpdateEditor(grid,x=>x.Dimensions.Length, dimensioned.Dimensions.GetUnit().HasLength);
- UpdateEditor(grid,x=>x.Dimensions.Width, dimensioned.Dimensions.GetUnit().HasWidth);
- UpdateEditor(grid,x=>x.Dimensions.Height, dimensioned.Dimensions.GetUnit().HasHeight);
- UpdateEditor(grid,x=>x.Dimensions.Weight, dimensioned.Dimensions.GetUnit().HasWeight);
- }
- }
- private string[]? ValidateData(T[] items)
- {
- var errors = new List<string>();
- DoValidate(items, errors);
- OnValidate?.Invoke(this, items, errors);
- return errors.Any() ? errors.ToArray() : null;
- }
- protected virtual void DoValidate(T[] items, List<string> errors)
- {
- }
-
- protected virtual void AfterLoad(DynamicEditorForm editor, T[] items)
- {
- }
- protected virtual void SelectPage(object sender, BaseObject[] items)
- {
- }
- protected virtual Dictionary<string, object?> EditorValueChanged(DynamicEditorForm editor, T[] items, string name, object value)
- {
- var result = DynamicGridUtils.UpdateEditorValue(items, name, value);
- if (OnEditorValueChanged != null)
- {
- var newchanges = OnEditorValueChanged(editor, name, value);
- foreach (var key in newchanges.Keys)
- result[key] = newchanges[key];
- }
-
- return result;
- }
- private readonly Dictionary<Tuple<Type, Type>, Dictionary<object, object>> _lookupcache = new();
- protected virtual void LookupsDefined(ILookupEditorControl sender, T[] items)
- {
- }
- protected virtual void DefineLookups(ILookupEditorControl sender, T[] items)
- {
- if (sender.EditorDefinition is not ILookupEditor editor)
- return;
- var colname = sender.ColumnName;
- //Logger.Send(LogType.Information, typeof(T).Name, "Into Define Lookups: " + colname);
- Task.Run(() =>
- {
- try
- {
- var values = editor.Values(colname, items);
- Dispatcher.Invoke(
- () =>
- {
- try
- {
- //Logger.Send(LogType.Information, typeof(T).Name, "Dispatching Results" + colname);
- sender.LoadLookups(values);
- }
- catch (Exception e2)
- {
- Logger.Send(LogType.Information, typeof(T).Name,
- "Exception (2) in LoadLookups: " + e2.Message + "\n" + e2.StackTrace);
- }
- }
- );
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Information, typeof(T).Name, "Exception (1) in LoadLookups: " + e.Message + "\n" + e.StackTrace);
- }
- });
- }
- /// <summary>
- /// Retrieves an editor to display for the given column of <paramref name="item"/>.
- /// </summary>
- /// <param name="item">The object being edited.</param>
- /// <param name="column">The column of the editor.</param>
- /// <returns>A new editor, or <see langword="null"/> if no editor defined and no sensible default exists.</returns>
- protected virtual BaseEditor? GetEditor(object item, DynamicGridColumn column)
- {
- return column.Editor ?? CoreUtils.GetProperty(item.GetType(), column.ColumnName).GetEditor();
- }
- protected object DefineFilter(Type type, T[] items)
- {
- return LookupFactory.DefineFilter(items, type);
- }
- protected virtual void SetEditorValue(object item, string name, object value)
- {
- try
- {
- CoreUtils.SetPropertyValue(item, name, value);
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
- }
- }
- protected virtual object? GetEditorValue(object item, string name)
- {
- return CoreUtils.GetPropertyValue(item, name);
- }
- protected virtual Document? LoadDocument(Guid id)
- {
- return null;
- }
- protected virtual Document? FindDocument(string filename)
- {
- return null;
- }
- protected virtual void SaveDocument(Document document)
- {
- }
- private bool AddEditClick(CoreRow[]? rows)
- {
- if (!IsEnabled || bRefreshing)
- return false;
- if (rows == null || !rows.Any())
- {
- var item = CreateItem();
- // Yea, and this won't work, because we're actually usually showing the description of a linked item,
- // not the id of the link, and we need to set the ID to have it work properly :-(
- //foreach (String key in VisualFilters.Keys)
- // CoreUtils.SetPropertyValue(item, key, VisualFilters[key]);
- if (EditItems(new[] { item }))
- {
- //_CurrentRow = Data.Rows.Count;
- var row = Data.NewRow();
- ObjectToRow(item, row);
- Data.Rows.Add(row);
- InvalidateGrid();
- SelectedRows = new[] { row };
- OnChanged?.Invoke(this);
- return true;
- }
- return false;
- }
- var items = Array.Empty<T>();
- using (new WaitCursor())
- {
- Stopwatch sw = new Stopwatch();
- sw.Start();
- items = LoadItems(rows);
- //Logger.Send(LogType.Information, "DG:LoadItems", String.Format("Loaded Items: {0}ms", sw.ElapsedMilliseconds));
- sw.Stop();
- }
- if (items.Any())
- {
- var sel = SelectedRows;
- if (EditItems(items))
- {
- for (var i = 0; i < items.Length; i++)
- ObjectToRow(items[i], rows[i]);
- InvalidateGrid();
- SelectedRows = sel;
- OnChanged?.Invoke(this);
- return true;
- }
- return false;
- }
- return false;
- }
- protected virtual void ObjectToRow(T obj, CoreRow row)
- {
- Data.LoadRow(row, obj);
- }
- protected virtual Guid GetImportID()
- {
- return Guid.Empty;
- }
- protected virtual bool CustomiseImportItem(T item)
- {
- if (IsSequenced)
- ((ISequenceable)item).Sequence = CoreUtils.GenerateSequence();
- return true;
- }
- protected virtual string CustomiseImportFileName(string filename)
- {
- return filename;
- }
- private void Import_Click(object sender, RoutedEventArgs e)
- {
- var list = new DynamicImportList(
- typeof(T),
- GetImportID()
- );
- list.OnImportItem += o => { return CustomiseImportItem((T)o); };
- list.OnCustomiseImport += (o, args) => { args.FileName = CustomiseImportFileName(args.FileName); };
- list.ShowDialog();
- Refresh(false, true);
- }
- protected virtual void CustomiseExportColumns(List<string> columnnames)
- {
- }
- protected virtual string CustomiseExportFileName(string filename)
- {
- return filename;
- }
- protected virtual void CustomiseExportFilters(Filters<T> filters, CoreRow[] visiblerows)
- {
- }
- protected virtual void ApplyExportFilter(CoreTable table, object data)
- {
- }
- private void Export_Click(object sender, RoutedEventArgs e)
- {
- var columnnames = VisibleColumns.Select(x => x.ColumnName).ToList();
- CustomiseExportColumns(columnnames);
- var form = new DynamicExportForm(typeof(T), columnnames);
- if (form.ShowDialog() != true)
- return;
- var filters = new Filters<T>();
- filters.Add(DefineFilter());
- var visiblerows = GetVisibleRows();
- CustomiseExportFilters(filters, visiblerows);
- var columns = new Columns<T>(form.Fields);
- var otherColumns = form.GetChildFields()
- .Select(x => new Tuple<Type, IColumns>(
- x.Key,
- (Activator.CreateInstance(typeof(Columns<>).MakeGenericType(x.Key), new object[] { x.Value }) as IColumns)!))
- .Where(x => x.Item2.ColumnNames().Any()).ToList();
- var sort = LookupFactory.DefineSort<T>();
- Reload(filters, columns, ref sort, (data, err) => Dispatcher.Invoke(() => {
- if(data is not null)
- {
- var list = new List<Tuple<Type?, CoreTable>>() { new(typeof(T), data) };
- list.AddRange(LoadExportTables(filters, otherColumns));
- DoExport(list);
- }
- else if (err is not null)
- {
- Logger.Send(LogType.Error, "", $"Error in export: {CoreUtils.FormatException(err)}");
- MessageBox.Show(err.Message);
- }
- }));
- }
- /// <summary>
- /// Loads the child tables for an export, based on the filter of the parent table.
- /// </summary>
- /// <remarks>
- /// If not overriden, defaults to creating empty tables with no records.
- /// </remarks>
- /// <param name="filter">Filter for the parent table.</param>
- /// <param name="tableColumns">A list of the child table types, with columns to load for each</param>
- /// <returns>A list of tables, in the same order as they came in <paramref name="tableColumns"/></returns>
- protected virtual IEnumerable<Tuple<Type?, CoreTable>> LoadExportTables(Filters<T> filter, IEnumerable<Tuple<Type, IColumns>> tableColumns)
- {
- return tableColumns.Select(x => {
- var table = new CoreTable();
- table.LoadColumns(x.Item2);
- return new Tuple<Type?, CoreTable>(x.Item1, table);
- });
- }
- private void DoExport(List<Tuple<Type?, CoreTable>> data)
- {
- var filename = CustomiseExportFileName(typeof(T).EntityName().Split('.').Last());
- ExcelExporter.DoExport(data, filename);
- }
- public void ScrollIntoView(CoreRow row)
- {
- DataGrid.ScrollInView(new RowColumnIndex(row.Index + 1, 0));
- }
- #endregion
- #region Custom Buttons
- private Button CreateButton(BitmapImage? image = null, string? text = null, string? tooltip = null)
- {
- var button = new Button();
- button.SetValue(BorderBrushProperty, new SolidColorBrush(Colors.Gray));
- button.SetValue(BorderThicknessProperty, new Thickness(0.75));
- button.Height = 30;
- UpdateButton(button, image, text, tooltip);
- return button;
- }
- protected void UpdateButton(Button button, BitmapImage? image, string? text, string? tooltip = null)
- {
- var stackPnl = new StackPanel();
- stackPnl.Orientation = Orientation.Horizontal;
- //stackPnl.Margin = new Thickness(2);
- if (image != null)
- {
- var img = new Image();
- img.Source = image;
- img.Margin = new Thickness(2);
- img.ToolTip = tooltip;
- stackPnl.Children.Add(img);
- }
- if (!string.IsNullOrEmpty(text))
- {
- var lbl = new Label();
- lbl.Content = text;
- lbl.VerticalAlignment = VerticalAlignment.Stretch;
- lbl.VerticalContentAlignment = VerticalAlignment.Center;
- lbl.Margin = new Thickness(2, 0, 5, 0);
- lbl.ToolTip = ToolTip;
- stackPnl.Children.Add(lbl);
- }
- button.Content = stackPnl;
- button.ToolTip = tooltip;
- }
- private bool bFirstButtonAdded = true;
- private bool AnyButtonsVisible()
- {
- if (Add.Visibility != Visibility.Collapsed)
- return true;
- if (Edit.Visibility != Visibility.Collapsed)
- return true;
- if (MultiEdit.Visibility != Visibility.Collapsed)
- return true;
- if (Export.Visibility != Visibility.Collapsed)
- return true;
- return false;
- }
- public Button AddButton(string caption, BitmapImage? image, string? tooltip, Func<Button, CoreRow[], bool> action)
- {
- var button = CreateButton(image, caption, tooltip);
- button.Margin = new Thickness(bFirstButtonAdded && AnyButtonsVisible() ? /* 10 */ 0 : 0, 2, 2, 0);
- button.Padding = new Thickness(5, 0, 5, 0);
- button.Tag = action;
- button.Click += Button_Click;
- Stack.Children.Add(button);
- bFirstButtonAdded = false;
- return button;
- }
- public Button AddButton(string caption, BitmapImage? image, Func<Button, CoreRow[], bool> action)
- {
- var result = AddButton(caption, image, null, action);
- return result;
- }
- private void Button_Click(object sender, RoutedEventArgs e)
- {
- var button = (Button)sender;
- var action = (Func<Button, CoreRow[], bool>)button.Tag;
- //CoreRow row = (CurrentRow > -1) && (CurrentRow < Data.Rows.Count) ? Data.Rows[this.CurrentRow] : null;
- if (action.Invoke(button, SelectedRows))
- Refresh(false, true);
- }
- #endregion
- #region Header Actions
- private void SelectColumnsClick(object sender, RoutedEventArgs e)
- {
- var editor = new DynamicGridColumnsEditor(typeof(T));
- editor.DirectEdit = Options.Contains(DynamicGridOption.DirectEdit);
- editor.Columns.AddRange(VisibleColumns);
- if (editor.ShowDialog().Equals(true))
- {
- VisibleColumns.Clear();
- VisibleColumns.AddRange(editor.Columns);
- SaveColumns(VisibleColumns);
- //OnSaveColumns?.Invoke(this, editor.Columns);
- Refresh(true, true);
- }
- }
- #endregion
- /* Removed as appears unused; removed as of 19/12/2022
- #region CellRendering
- private void PopulateDynamicActionCell(DynamicActionColumn column, int rowIndex, int columnIndex, GridStyleInfo style)
- {
- style.CellType = "ImageCell";
- var bi = column.Image?.Invoke(rowIndex < 0 ? null : Data.Rows[rowIndex]);
- if (bi != null)
- {
- style.CellValue = bi;
- style.BorderMargins = new CellMarginsInfo(4.0F);
- }
- }
- //bool rowstylehelperinitialised = false;
- //protected virtual void ProcessCellStyle(CoreRow row, int column, GridStyleInfo style)
- //{
- // if (!rowstylehelperinitialised)
- // {
- // Script stylescript = new Client<Script>().Load(new Filter<Script>(x => x.Section).IsEqualTo(typeof(T).EntityName()).And(x => x.ScriptType).IsEqualTo(ScriptType.RowStyle)).FirstOrDefault(); ;
- // if (stylescript != null)
- // {
- // rowstylehelper = new ScriptDocument(stylescript.Code);
- // if (!rowstylehelper.Compile())
- // {
- // MessageBox.Show("Unable to Load Row Style Helper!\r\n\r\n" + rowstylehelper.Result);
- // rowstylehelper = null;
- // }
- // }
- // rowstylehelperinitialised = true;
- // }
- // if (rowstylehelper != null)
- // {
- // try
- // {
- // rowstylehelper.SetValue("Row", row);
- // rowstylehelper.SetValue("Column", Data.Columns[column].ColumnName);
- // rowstylehelper.SetValue("Background", style.Background);
- // rowstylehelper.SetValue("Foreground", style.Foreground);
- // rowstylehelper.SetValue("Style", style.Font.FontStyle);
- // rowstylehelper.SetValue("Weight", style.Font.FontWeight);
- // if (rowstylehelper.Execute())
- // {
- // style.Background = (System.Windows.Media.Brush)rowstylehelper.GetValue("Background");
- // style.Foreground = (System.Windows.Media.Brush)rowstylehelper.GetValue("Foreground");
- // style.Font.FontStyle = (FontStyle)rowstylehelper.GetValue("Style");
- // style.Font.FontWeight = (FontWeight)rowstylehelper.GetValue("Weight");
- // }
- // }
- // catch (Exception e)
- // {
- // //MessageBox.Show("Unable to Invoke Row Style Helper!\r\n\r\n" + e.Message);
- // }
- // }
- //}
- private readonly Dictionary<string, BaseEditor> editorcache = new();
- private void PopulateDataCell(int rowIndex, int columnIndex, GridStyleInfo style)
- {
- if (columnIndex > -1 && columnIndex < ColumnList.Count)
- {
- var o = ColumnList[columnIndex];
- if (o is DynamicActionColumn)
- {
- PopulateDynamicActionCell((DynamicActionColumn)o, rowIndex, columnIndex, style);
- }
- else
- {
- var dgc = (DynamicGridColumn)o;
- var dc = Data.Columns.FirstOrDefault(x => x.ColumnName.Equals(dgc.ColumnName));
- var fmt = string.IsNullOrWhiteSpace(dgc.Format) ? "{0}" : "{0:" + dgc.Format.Replace("\\:", ":").Replace(":", "\\:") + "}";
- object? val = null;
- if (rowIndex < Data.Rows.Count)
- val = Data.Rows[rowIndex][dgc.ColumnName];
- if (val != null && dgc.Lookups.ContainsKey(val))
- val = dgc.Lookups[val];
- if (dc != null)
- {
- if(!editorcache.TryGetValue(dc.ColumnName, out var editor))
- {
- var prop = DatabaseSchema.Property(typeof(T), dc.ColumnName);
- if (prop != null)
- editor = prop.Editor;
- else
- editor = EditorUtils.GetEditor(dc.DataType) ?? new NullEditor();
- editorcache[dc.ColumnName] = editor;
- }
- if (editor is CheckBoxEditor)
- {
- style.CellType = "CheckBox";
- style.CellValue = val;
- style.HorizontalAlignment = dc == null ? HorizontalAlignment.Left : dgc.HorizontalAlignment(dc.DataType);
- style.VerticalAlignment = dgc.VerticalAlignment();
- style.TextMargins = new CellMarginsInfo(2.0F);
- }
- else if (editor is ColorEditor)
- {
- style.CellType = "ImageCell";
- var str = val?.ToString();
- if (!string.IsNullOrWhiteSpace(str))
- {
- var color = ColorTranslator.FromHtml(str); // System.Drawing.Color.FromName(val.ToString());
- var bitmap = ImageUtils.BitmapFromColor(color, (int)style.GridModel.ColumnWidths[columnIndex],
- (int)style.GridModel.RowHeights[rowIndex], Color.Black);
- //bitmap.Save(val.ToString().Replace("#","") + ".png");
- style.CellValue = bitmap.AsBitmapImage(false);
- style.BorderMargins = new CellMarginsInfo(4.0F);
- }
- }
- else
- {
- string value;
- try
- {
- if(val is null)
- {
- value = "";
- }
- else if (val.GetType().IsEnum)
- {
- value = val.ToString()!;
- }
- else if (val.GetType().IsDefault(val))
- {
- value = "";
- }
- else
- {
- value = string.Format(new TimeSpanFormatter(), fmt, val);
- }
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
- value = val?.ToString() ?? "";
- }
- if (editor is PasswordEditor)
- style.CellValue = "".PadLeft(value.Length, '●');
- else
- style.CellValue = value;
- style.HorizontalAlignment = dc == null ? HorizontalAlignment.Left : dgc.HorizontalAlignment(dc.DataType);
- style.VerticalAlignment = dgc.VerticalAlignment();
- style.CellType = "Static";
- style.TextMargins = new CellMarginsInfo(2.0F);
- }
- }
- }
- }
- }
- private void PopulateHeaderCell(int columnIndex, GridStyleInfo style)
- {
- if (columnIndex > -1 && columnIndex < ColumnList.Count)
- {
- var o = ColumnList[columnIndex];
- if (o is DynamicActionColumn)
- {
- PopulateDynamicActionCell((DynamicActionColumn)o, -1, columnIndex, style);
- }
- else
- {
- var dgc = (DynamicGridColumn)o;
- if (Data != null)
- {
- var dc = Data.Columns.FirstOrDefault(x => x.ColumnName.Equals(dgc.ColumnName));
- style.HorizontalAlignment = dc != null ? dgc.HorizontalAlignment(dc.DataType) : HorizontalAlignment.Left;
- }
- style.CellValue = string.IsNullOrWhiteSpace(dgc.Caption) ? dgc.ColumnName : dgc.Caption;
- style.VerticalAlignment = dgc.VerticalAlignment();
- style.CellType = "Static";
- style.TextMargins = new CellMarginsInfo(2.0F);
- }
- }
- }
- #endregion
- */
- /* Removed as appears unused; removed as of 19/12/2022
- #region Drag and Drop
- private Point startpoint;
- private void CheckPreviewMouseDown(object sender, MouseButtonEventArgs e)
- {
- if (!Options.Contains(DynamicGridOption.DragSource))
- return;
- if (e.LeftButton == MouseButtonState.Pressed)
- {
- Logger.Send(LogType.Information, GetType().EntityName(), "Initiating Start Point");
- startpoint = e.GetPosition(DataGrid);
- }
- }
- //private void CheckPreviewMouseMove(object sender, MouseEventArgs e)
- //{
- // Logger.Send(LogType.Information, this.GetType().EntityName(), String.Format("Checking Mouse Move: StartPoint = {0},{1}", startpoint.X, startpoint.Y));
- // if (!_Options.Contains(DynamicGridOptions.DragSource))
- // return;
- // Vector diff = startpoint - e.GetPosition(null);
- // Logger.Send(LogType.Information, this.GetType().EntityName(), String.Format("Checking Mouse Move: StartPoint = {0},{1} Diff = {2},{3}", startpoint.X, startpoint.Y, diff.X, diff.Y));
- // if ( (startpoint.X != 0) && (startpoint.Y != 0))
- // {
- // if ((Math.Abs(diff.X) > SystemParameters.MinimumHorizontalDragDistance) || (Math.Abs(diff.Y) > SystemParameters.MinimumVerticalDragDistance))
- // {
- // Logger.Send(LogType.Information, this.GetType().EntityName(), "Starting Drag Drop Operation");
- // DataObject dragData = new DataObject(typeof(T).EntityName(), SelectedRows);
- // DragDrop.DoDragDrop(DataGrid, dragData, DragDropEffects.Copy);
- // }
- // }
- //}
- private void CheckPreviewMouseUp(object sender, MouseButtonEventArgs e)
- {
- if (!Options.Contains(DynamicGridOption.DragSource))
- return;
- Logger.Send(LogType.Information, GetType().EntityName(), "Clearing Start Point");
- startpoint = new Point();
- }
- #endregion
- */
- }
- }
|