static void SetValidateColumnsForXamDataGrid(XamDataGrid dataGrid, DataTableEx userTable)
{
var hierObjectStyle = dataGrid.FindResource("HierObjectStyle") as Style;
var hTemplate = dataGrid.FindResource("HierarchyObjectTemplate") as DataTemplate;
var chTemplate = dataGrid.FindResource("ChannelTemplate") as DataTemplate;
var fFlagStyle = dataGrid.FindResource("FFlagStyle") as Style;
dataGrid.FieldSettings.LabelPresenterStyle = dataGrid.FindResource("ValidLabelStyle") as Style;
// dataGrid.BeginInit();
//var leftHorizontalStyle = dataGrid.FindResource("FastHorizontalLeftCellValuePresenterStyle") as Style;
var fieldLayout = dataGrid.FieldLayouts[0];
var fields = fieldLayout.Fields;
//var field = fieldLayout.Fields["NameTI"] as TemplateField;
try
{
fields.BeginUpdate();
#region Вспомогательные поля
var comparer = new IFreeHierarchyObjectComparer();
var tiFld = new Field
{
Name = "NameTI",
DataType = typeof(IFreeHierarchyObject),
Label = "Объект",
Width = new FieldLength(200),
FixedLocation = FixedFieldLocation.FixedToNearEdge,
//FixedLocation = FixedFieldLocation.FixedToNearEdge,
Settings =
{
AllowGroupBy = true,
GroupByComparer = comparer,
SortComparer = comparer,
FilterComparer = comparer,
CellVisibilityWhenGrouped = Visibility.Collapsed,
FilterOperandUIType = FilterOperandUIType.DropDownList,
AllowFixing = AllowFieldFixing.Near,
AllowEdit = false,
EditorStyle = null,
AllowRecordFiltering = true,
CellValuePresenterStyle = hierObjectStyle,
},
HorizontalContentAlignment = System.Windows.HorizontalAlignment.Left,
VerticalContentAlignment = VerticalAlignment.Center,
};
//if (leftHorizontalStyle != null)
//{
// //Это
// tiFld.Settings.CellValuePresenterStyle = leftHorizontalStyle;
//}
fields.Add(tiFld);
fields.Add(new TemplateField
{
Name = "Channel",
Label = "К",
DataType = typeof(object),
DisplayTemplate = chTemplate,
Width = new FieldLength(30),
FixedLocation = FixedFieldLocation.FixedToNearEdge,
Settings = { FilterOperandUIType = FilterOperandUIType.None,
AllowFixing = AllowFieldFixing.Near,
AllowEdit = false,
EditorStyle = null, },
});
//fieldLayout.Fields.Add(new TemplateField
//{
// Name = "DataSource",
// Label = "Источник данных",
// Width = new FieldLength(130),
//});
var fld = new Field
{
Name = "Parent",
DataType = typeof(IFreeHierarchyObject),
Label = "Родитель",
Width = new FieldLength(160),
AllowFixing = AllowFieldFixing.Near,
//FixedLocation = FixedFieldLocation.FixedToNearEdge,
Settings =
{
//GroupByMode = FieldGroupByMode.Value,
AllowGroupBy = true,
GroupByComparer = comparer,
SortComparer = comparer,
FilterComparer = comparer,
CellVisibilityWhenGrouped = Visibility.Collapsed,
FilterOperandUIType = FilterOperandUIType.DropDownList,
AllowFixing = AllowFieldFixing.Near,
AllowEdit = false,
EditorStyle = null,
AllowRecordFiltering = true,
CellValuePresenterStyle = hierObjectStyle,
},
HorizontalContentAlignment = System.Windows.HorizontalAlignment.Left,
VerticalContentAlignment = VerticalAlignment.Center,
};
fields.Add(fld);
var fsd = new FieldSortDescription("Parent", ListSortDirection.Ascending, true);
fieldLayout.SortedFields.Add(fsd);
#endregion
// var flagStyle = XamDataGridHelper.DataTemplateSelectorToCellEditorStyle(flagTemplateSelector, null);
var width = new FieldLength(32);
var height = new FieldLength(20);
foreach (DataColumn col in userTable.Columns)
{
//var column = fieldLayout.Fields.FirstOrDefault(c => string.Equals(c.Name, "Valid" + i)) as TemplateField;
//if (column == null) return;
var isValid = col.ColumnName.IndexOf("Valid") >= 0;
if (isValid || col.ColumnName.IndexOf("TotalFlag") >= 0)
{
fields.Add(new Field
{
Name = col.ColumnName,
DataType = col.DataType,
ToolTip = col.Caption,
Label = col.Caption,
Visibility = isValid ? Visibility.Visible : Visibility.Collapsed,
Width = width,
Height = height,
AllowFixing = AllowFieldFixing.No,
AllowResize = false,
Settings =
{
SummaryUIType = SummaryUIType.MultiSelect,
FilterOperandUIType = FilterOperandUIType.Combo,
FilterOperatorDropDownItems = ComparisonOperatorFlags.None,
CellValuePresenterStyle = fFlagStyle,
AllowEdit = false,
AllowRecordFiltering = true,
//CellValuePresenterStyle = fFlagStyle,
},
});
}
}
}
finally
{
fieldLayout.Fields.EndUpdate();
}
//XamDataGridHelper.ConfigureGrid(dataGrid, false, true, false, true, false);
// раскрываем первую группу
dataGrid.RecordsInViewChanged += ExpandFirstRecord;
}
public static void ConfigureGridDailyIntegrals(XamDataGrid dataGrid, DataTableEx userTable, bool useLossesCoefficient)
{
if (dataGrid == null || userTable == null)
{
return;
}
try
{
var labelStyle = dataGrid.FindResource("LabelObjectStyle") as Style;
dataGrid.FieldSettings.LabelPresenterStyle = labelStyle;
}
catch
{
}
var view = userTable.DefaultView;
#if DEBUG
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
#endif
try
{
var hierObjectStyle = dataGrid.FindResource("HierObjectStyle") as Style;
var chTemplate = dataGrid.FindResource("ChannelTemplate") as DataTemplate;
var fValueStyle = dataGrid.FindResource("FValueStyle") as Style;
var fValueNoFlagStyle = dataGrid.FindResource("FValueNoFlagStyle") as Style;
var widthValue = new FieldLength(105);
dataGrid.BeginInit();
var fieldLayout = dataGrid.FieldLayouts[0];
var fields = fieldLayout.Fields;
try
{
fields.BeginUpdate();
#region Создаем основные колонки
var comparer = new IFreeHierarchyObjectComparer();
fields.Add(new Field
{
Name = "Parent",
DataType = typeof(IFreeHierarchyObject),
Label = "Объект",
Width = new FieldLength(160),
AllowFixing = AllowFieldFixing.Near,
//FixedLocation = FixedFieldLocation.FixedToNearEdge,
Settings =
{
//GroupByMode = FieldGroupByMode.Value,
AllowGroupBy = true,
GroupByComparer = comparer,
SortComparer = comparer,
FilterComparer = comparer,
CellVisibilityWhenGrouped = Visibility.Collapsed,
FilterOperandUIType = FilterOperandUIType.DropDownList,
AllowFixing = AllowFieldFixing.Near,
AllowEdit = false,
EditorStyle = null,
AllowRecordFiltering = true,
CellValuePresenterStyle = hierObjectStyle,
},
HorizontalContentAlignment = HorizontalAlignment.Left,
VerticalContentAlignment = VerticalAlignment.Center,
});
fields.Add(new Field
{
Name = "NameTI",
DataType = typeof(IFreeHierarchyObject),
Label = "ТИ",
Width = new FieldLength(200),
AllowFixing = AllowFieldFixing.Near,
//FixedLocation = FixedFieldLocation.FixedToNearEdge,
Settings =
{
AllowGroupBy = true,
GroupByComparer = comparer,
SortComparer = comparer,
FilterComparer = comparer,
CellVisibilityWhenGrouped = Visibility.Collapsed,
FilterOperandUIType = FilterOperandUIType.DropDownList,
AllowFixing = AllowFieldFixing.Near,
AllowEdit = false,
EditorStyle = null,
AllowRecordFiltering = true,
CellValuePresenterStyle = hierObjectStyle,
},
HorizontalContentAlignment = HorizontalAlignment.Left,
VerticalContentAlignment = VerticalAlignment.Center,
});
fields.Add(new TemplateField
{
Name = "Channel",
Label = "К",
DataType = typeof(object),
DisplayTemplate = chTemplate,
Width = new FieldLength(40),
AllowFixing = AllowFieldFixing.Near,
//FixedLocation = FixedFieldLocation.FixedToNearEdge,
Settings =
{
AllowGroupBy = true,
FilterOperandUIType = FilterOperandUIType.DropDownList,
AllowFixing = AllowFieldFixing.Near,
AllowEdit = false,
EditorStyle = null,
AllowRecordFiltering = true,
},
});
fieldLayout.Fields.Add(new Field
{
Name = "DataSource",
Label = "Источник данных",
Width = new FieldLength(100),
AllowFixing = AllowFieldFixing.Near,
Settings =
{
AllowGroupBy = true,
FilterOperandUIType = FilterOperandUIType.DropDownList,
AllowFixing = AllowFieldFixing.Near,
AllowEdit = false,
EditorStyle = null,
AllowRecordFiltering = true,
},
});
fields.Add(new Field
{
Name = "Coeff",
DataType = typeof(double),
Width = widthValue,
Label = "Коэфф. тр.",
Format = "#0",
AllowFixing = AllowFieldFixing.Near,
Settings =
{
AllowGroupBy = true,
AutoSizeOptions = FieldAutoSizeOptions.None,
Width = widthValue,
SummaryUIType = SummaryUIType.MultiSelect,
AllowEdit = false,
EditorStyle = null,
FilterOperandUIType = FilterOperandUIType.Combo,
AllowRecordFiltering = true,
},
HorizontalContentAlignment = HorizontalAlignment.Right,
VerticalContentAlignment = VerticalAlignment.Center,
});
if (useLossesCoefficient)
{
fields.Add(new Field
{
Name = "CoeffLosses",
DataType = typeof(double),
Width = widthValue,
Label = "Коэфф. потерь",
Format = "#0.###",
AllowFixing = AllowFieldFixing.Near,
Settings =
{
AllowGroupBy = true,
AutoSizeOptions = FieldAutoSizeOptions.None,
Width = widthValue,
SummaryUIType = SummaryUIType.MultiSelect,
AllowEdit = false,
EditorStyle = null,
FilterOperandUIType = FilterOperandUIType.Combo,
AllowRecordFiltering = true,
},
HorizontalContentAlignment = HorizontalAlignment.Right,
VerticalContentAlignment = VerticalAlignment.Center,
});
}
#endregion
#region Посуточные колонки
var counter = 0;
FieldGroup fieldGroup = null;
foreach (var col in userTable.Columns.OfType <DataColumnEx>())
{
if (col == null)
{
continue;
}
if (counter == 0)
{
fieldGroup = new FieldGroup
{
Label = col.GroupName,
};
fieldLayout.FieldItems.Add(fieldGroup);
}
var fld = AddFValueField(col.ColumnName, col.DataType, widthValue, col.IsFValue ? fValueStyle : fValueNoFlagStyle, null);
fld.Label = col.Caption;
//if (!col.IsFValue)
//{
// fld.Format = "##0.######";
//}
fieldGroup.Children.Add(fld);
if (++counter == 3)
{
counter = 0;
}
}
#endregion
}
finally
{
fieldLayout.Fields.EndUpdate();
}
dataGrid.RecordsInViewChanged += ExpandFirstRecord;
}
finally
{
dataGrid.DataSource = view;
dataGrid.EndInit();
}
#if DEBUG
sw.Stop();
Console.WriteLine("ConfigureGridDailyIntegrals - > {0} млс", sw.ElapsedMilliseconds);
#endif
}
