private static Field AddFieldAndSummary(DataColumn col, FieldLength?width, IFValueComparer comparer, bool useMeasureModule, bool isCumulateDrums, SummaryCalculator statType, string stringFormat, out SummaryDefinition summaryDefinition, Style fValueStyle) { var fld = AddFValueField(col.ColumnName, col.DataType, width, fValueStyle, _comparer); if (!isCumulateDrums) { summaryDefinition = new FValueSummaryDefinition { SourceFieldName = fld.Name, Calculator = statType, StringFormat = stringFormat, UseMeasureModule = useMeasureModule, }; //fieldLayout.SummaryDefinitions.Add(sd); } else { summaryDefinition = null; } return(fld); }
static void SetHalfhoursColumnsForXamDataGrid(XamDataGrid dataGrid, DataTableEx userTable, enumTimeDiscreteType discreteType, enumTypeInformation typeInformation, string format, bool isCumulateDrums , bool isDateTimeGroupingGridControlXam, bool useBindedConverter) { //var nameStyle = dataGrid.FindResource("TIChanelName") as Style; ////Style labelStyle = null; try { var labelStyle = dataGrid.FindResource("LabelObjectStyle") as Style; dataGrid.FieldSettings.LabelPresenterStyle = labelStyle; } catch { } //var vTemplate = dataGrid.FindResource("FValueTemplate") as DataTemplate; var fValueNoBindMeasureStyle = dataGrid.FindResource("FValueNoBindMeasureStyle") as Style; var vFreeHierarchyObjectTemplate = Application.Current.FindResource("FreeHierarchyObjectTemlate") as DataTemplate; var fValueStyle = useBindedConverter ? dataGrid.FindResource("FValueStyle") as Style : fValueNoBindMeasureStyle; var widthValue = new FieldLength(105); var widthFreeHier = new FieldLength(270); var comparer = new IFValueComparer(); var measure = dataGrid.FindParent <IMeasure>(); dataGrid.Resources["IMeasure"] = measure; //var fConverter = new FValueConverter //{ // FParameter = new FValueParameter // { // Measure = measure, // } //}; var fieldLayout = dataGrid.FieldLayouts[0]; var fields = fieldLayout.Fields; try { fields.BeginUpdate(); //fieldLayout.SortedFields.BeginUpdate(); var dtCol = userTable.Columns["EventDateTime"]; var dtField = new TemplateField { Name = dtCol.ColumnName, DataType = dtCol.DataType, Label = dtCol.Caption, Width = new FieldLength(95), AllowFixing = AllowFieldFixing.Default, FixedLocation = FixedFieldLocation.FixedToNearEdge, Settings = { LabelPresenterStyle = dataGrid.FindResource("TimeStyle") as Style } }; fields.Add(dtField); if (isCumulateDrums) { //dtField.Settings.CellValuePresenterStyle = // XamDataGridHelper.DataTemplateToCellValuePresenterStyle(ConstantHelper.DateTimeTemplateName); dtField.DisplayTemplate = Application.Current.Resources[ConstantHelper.DateTimeTemplateName] as DataTemplate; } else { string dataTemplateToCellValuePresenterStyleName; //------------------------------- switch (discreteType) { case enumTimeDiscreteType.DBHalfHours: dataTemplateToCellValuePresenterStyleName = ConstantHelper.HalfHourstoRangeTimeTemplateName; break; case enumTimeDiscreteType.DBHours: dataTemplateToCellValuePresenterStyleName = ConstantHelper.HourstoRangeTimeTemplateName; break; case enumTimeDiscreteType.DB24Hour: dataTemplateToCellValuePresenterStyleName = ConstantHelper.DateTemplateName; break; case enumTimeDiscreteType.DBMonth: dataTemplateToCellValuePresenterStyleName = ConstantHelper.MonthName; break; default: dataTemplateToCellValuePresenterStyleName = ConstantHelper.DateTimeTemplateName; break; } dtField.Tag = dataTemplateToCellValuePresenterStyleName; //Это нужно для форматирования при выгрузке в Excel dtField.DisplayTemplate = Application.Current.Resources[dataTemplateToCellValuePresenterStyleName] as DataTemplate; //dtField.Settings.CellValuePresenterStyle = // XamDataGridHelper.DataTemplateToCellValuePresenterStyle( // dataTemplateToCellValuePresenterStyleName); } dtField.Label = "Время"; if (discreteType == enumTimeDiscreteType.DB24Hour) { dtField.Settings.GroupByMode = FieldGroupByMode.Month; dtField.Settings.GroupByRecordPresenterStyle = Application.Current.FindResource("MonthYearXamDataGridStyle") as Style; } else { dtField.Settings.GroupByMode = FieldGroupByMode.Date; } SummaryCalculator statType; string prefix; if (typeInformation == enumTypeInformation.Power) { statType = new FValueAvgCalculator(format); prefix = "Сред:"; } else { statType = new FValueSumCalculator(format); prefix = "Сум:"; } var stringFormat = prefix + " {0:" + format + "}"; var dfc = new DetailFieldInfoEqualityComparer(); //FieldGroup fieldGroupByObject = null; //FieldGroup fieldGroupByMeasureCategory = null; //EnumMeasureUnitCategory? previousMeasureCategory = null; //Для определения групповать или нет по категории foreach (var colGroupByObject in userTable.Columns .Cast <DataColumn>() .Where(c => c.ColumnName != "EventDateTime") .Select(c => { DetailFieldInfo fieldInfo; userTable.TryGetIndexByItemName(c.ColumnName, out fieldInfo); return(new Tuple <DetailFieldInfo, DataColumn>(fieldInfo, c)); }) .GroupBy(c => c.Item1, dfc)) { if (colGroupByObject.Key == null || (colGroupByObject.Key.ChannelType == 0 && colGroupByObject.Key.ColumnType == EnumColumnType.None)) { //Группировать не нужно foreach (var colByObject in colGroupByObject) { DetailFieldInfo fieldInfo; userTable.ItemsIndexesDict.TryGetValue(colByObject.Item2.ColumnName, out fieldInfo); SummaryDefinition summaryDefinition; var fld = AddFieldAndSummary(colByObject.Item2, widthValue, comparer, fieldInfo != null && fieldInfo.UseMeasureModule, isCumulateDrums, statType, stringFormat, out summaryDefinition, fValueStyle); fld.Label = fieldInfo == null ? colByObject.Item2.Caption : (object)colByObject.Item1; fields.Add(fld); if (summaryDefinition != null) { fieldLayout.SummaryDefinitions.Add(summaryDefinition); } } } //else if () //{ // //Группируем по типу // foreach (var colByObjectByColumnType in colGroupByObject.GroupBy(c => c.Item1.ColumnType)) // { // foreach (var colByObject in colByObjectByColumnType) // { // DetailFieldInfo fieldInfo; // if (!userTable.ItemsIndexesDict.TryGetValue(colByObject.Item2.ColumnName, out fieldInfo)) continue; // FValueSummaryDefinition summaryDefinition; // var fld = AddFieldAndSummary(colByObject.Item2, widthValue, comparer, fieldInfo != null && fieldInfo.UseMeasureModule, // isCumulateDrums, statType, stringFormat, out summaryDefinition, fValueStyle); // fld.Label = fieldInfo == null ? colByObject.Item2.Caption : (object)colByObject.Item1; // fields.Add(fld); // if (summaryDefinition != null) // { // fieldLayout.SummaryDefinitions.Add(summaryDefinition); // } // } // } //} else { var fieldInfo = colGroupByObject.Key; var fieldGroupByObject = new FieldGroup { Label = fieldInfo.Id, }; fieldLayout.FieldItems.Add(fieldGroupByObject); //Группируем по ед.измерения foreach (var colGroupByMeasureCategory in colGroupByObject.GroupBy(c => c.Item1.MeasureUnitUn.SubstringQuantityUn())) { var colGroupByMeasureCategoryList = colGroupByMeasureCategory.ToList(); if (!string.IsNullOrEmpty(colGroupByMeasureCategory.Key) && colGroupByMeasureCategoryList.Count > 1) { //Есть категории ед. измерения и их несколько var fieldGroupByMeasureCategory = new FieldGroup { Label = new LabelMeasureQuantity { MeasureQuantityType_UN = colGroupByMeasureCategory.Key, }, }; fieldGroupByObject.Children.Add(fieldGroupByMeasureCategory); foreach (var colByMeasure in colGroupByMeasureCategoryList) { SummaryDefinition summaryDefinition; var fld = AddFieldAndSummary(colByMeasure.Item2, widthValue, comparer, fieldInfo.UseMeasureModule, isCumulateDrums, statType, stringFormat, out summaryDefinition, fValueStyle); fld.Label = colByMeasure.Item1; fieldGroupByMeasureCategory.Children.Add(fld); if (summaryDefinition != null) { fieldLayout.SummaryDefinitions.Add(summaryDefinition); } } } else { var fielgGroupByReplacedTiDict = new Dictionary <string, FieldGroup>(); //Нет категорий, или она одна foreach (var colByMeasure in colGroupByMeasureCategoryList) { if (colByMeasure.Item2.ColumnName.StartsWith("ovInfo")) { var hoc = new HierObjectsConverterComparer(); //var fld = AddField(colByMeasure.Item2, widthFreeHier, hoc, fieldInfo.UseMeasureModule, // vFreeHierarchyObjectTemplate, // vFreeHierarchyObjectTemplate, new HierObjectsConverter(), null); var fld = new TemplateField { Name = colByMeasure.Item2.ColumnName, DataType = colByMeasure.Item2.DataType, Width = widthFreeHier, AllowFixing = AllowFieldFixing.No, DisplayTemplate = vFreeHierarchyObjectTemplate, Settings = { AutoSizeOptions = FieldAutoSizeOptions.None, Width = widthFreeHier, SummaryUIType = SummaryUIType.MultiSelect, FilterComparer = hoc, FilterOperandUIType = FilterOperandUIType.Combo, AllowRecordFiltering = true, }, HorizontalContentAlignment = HorizontalAlignment.Stretch, VerticalContentAlignment = VerticalAlignment.Stretch, }; fld.Label = "Замещаемые ТИ"; fld.Settings.FilterOperandUIType = FilterOperandUIType.DropDownList; fld.Settings.FilterLabelIconDropDownType = FilterLabelIconDropDownType.MultiSelectExcelStyle; fld.Settings.GroupByComparer = hoc; //fld.ValueToTextConverter = new HierObjectsConverter(); fld.Settings.FilterComparer = new HierObjectsConverterComparer(); fieldGroupByObject.Children.Add(fld); } else { FieldGroup fielgGroupByReplacedTi = null; //Группируем по замещаемой ТИ if (colByMeasure.Item2.ColumnName.StartsWith("ovValue") && !fielgGroupByReplacedTiDict.TryGetValue( colByMeasure.Item1.GroupByReplacedTiName, out fielgGroupByReplacedTi)) { fielgGroupByReplacedTi = new FieldGroup { Label = colByMeasure.Item1.ReplacedId, }; fielgGroupByReplacedTiDict[colByMeasure.Item1.GroupByReplacedTiName] = fielgGroupByReplacedTi; } SummaryDefinition summaryDefinition; Field fld; if (!string.IsNullOrEmpty(colByMeasure.Item1.MeasureUnitUn) && colByMeasure.Item1.MeasureUnitUn.IndexOf("RatioUnit") > -1) { //Это %, нужно усреднять fld = AddFieldAndSummary(colByMeasure.Item2, widthValue, comparer, colByMeasure.Item1.UseMeasureModule, isCumulateDrums, new FValueAvgCalculator(format), "Сред: {0:" + format + "}", out summaryDefinition, fValueNoBindMeasureStyle); } else { fld = AddFieldAndSummary(colByMeasure.Item2, widthValue, comparer, useBindedConverter && colByMeasure.Item1.UseMeasureModule, isCumulateDrums, statType, stringFormat, out summaryDefinition, fValueStyle); } fld.Label = colByMeasure.Item1; if (fielgGroupByReplacedTi != null) { fielgGroupByReplacedTi.Children.Add(fld); } else { fieldGroupByObject.Children.Add(fld); } if (summaryDefinition != null) { fieldLayout.SummaryDefinitions.Add(summaryDefinition); } if (colByMeasure.Item1.IsOv) { //Если это ОВ, добавляем суммарную информацию о неразнесенных значениях var unWritedOvs = new FValueSummaryDefinition { SourceFieldName = colByMeasure.Item2.ColumnName, Calculator = new FValueSumUnreplacedCalculator(format), StringFormat = stringFormat, UseMeasureModule = fieldInfo.UseMeasureModule, }; fieldLayout.SummaryDefinitions.Add(unWritedOvs); } } } if (fielgGroupByReplacedTiDict.Count > 0) { fieldGroupByObject.Children.AddRange(fielgGroupByReplacedTiDict.Values); } } } } } if (isDateTimeGroupingGridControlXam) { //dtField.Settings.AllowSummaries = false; dtField.Settings.AllowGroupBy = true; fieldLayout.SortedFields.Add(new FieldSortDescription("EventDateTime", ListSortDirection.Ascending, true)); } else if (discreteType != enumTimeDiscreteType.DBMonth && discreteType != enumTimeDiscreteType.DB24Hour) { dtField.DisplayTemplate = Application.Current.Resources[ConstantHelper.DateTimeTemplateName] as DataTemplate; } //var consumptionScheduleField = fields.FirstOrDefault(ff => ff.Name == "ConsumptionSchedule"); //if (consumptionScheduleField != null) //{ // consumptionScheduleField.Label = "Тип. потр."; //} //var consumptionSchedulePercentField = fields.FirstOrDefault(ff => ff.Name == "ConsumptionSchedulePercent"); //if (consumptionSchedulePercentField != null) //{ // consumptionSchedulePercentField.Label = "Тип. потр. %"; //} } finally { // fieldLayout.SortedFields.EndUpdate(); fields.EndUpdate(); } //XamDataGridHelper.ConfigureGrid(dataGrid, true, false, true, true, true); dataGrid.FieldLayoutSettings.FixedFieldUIType = FixedFieldUIType.Splitter; dataGrid.FieldSettings.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed; if (userTable.Columns.Count < 20) { //из-за того что тормоза ограничиваем //dataGrid.FieldSettings.SummaryDisplayArea = dataGrid.FieldSettings.SummaryDisplayArea | SummaryDisplayAreas.InGroupByRecords; } if (userTable.Columns.Count < 1000) { dataGrid.RecordsInViewChanged += ExpandFirstRecord; } }