private void Button_Click(object sender, RoutedEventArgs e)
{
if (sender is Control)
{
FieldValueItem fieldValueItem = ((sender as Control).DataContext) as FieldValueItem;
if (fieldValueItem != null && fieldValueItem.Field != null)
{
pivotGrid.ShowUnboundExpressionEditor(fieldValueItem.Field);
}
}
}
private void removeBonus_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
if (sender is BarButtonItem)
{
FieldValueItem fieldValueItem = ((sender as BarButtonItem).Tag) as FieldValueItem;
if (fieldValueItem != null && fieldValueItem.Field != null)
{
NamesController.UnRegisterAvailableName(fieldValueItem.Field.FieldName);
pivotGrid.Fields.Remove(fieldValueItem.Field);
}
}
}
void SetImageSource()
{
FieldValueItem item = this.DataContext as FieldValueItem;
if (item != null && !item.IsOthersRow && !string.IsNullOrEmpty(item.DisplayText))
{
ImageSource = CategoriesControl.GetImage(item.Value as string);
}
else
{
ImageSource = null;
}
}
object IValueConverter.Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
FieldValueItem item = value as FieldValueItem;
if (item == null || !(item.Value is MoonPhase))
{
return(null);
}
else
{
return(GetImage(item.Value.ToString()));
}
}
private void pivotGridControl1_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e)
{
FieldValueElement fvElement = e.TargetElement as FieldValueElement;
FieldValueItem fvItem = fvElement.Item;
if (fvItem.IsLastLevelItem)
{
string itemCaption = string.Format("Top 5 Values in this {0}", fvItem.IsColumn ? "Column" : "Row");
BarButtonItem item = new BarButtonItem {
Content = itemCaption
};
item.ItemClick += item_ItemClick;
item.Tag = fvItem;
e.Customizations.Add(new AddBarItemAction {
Item = item
});
}
}
void item_ItemClick(object sender, ItemClickEventArgs e)
{
FieldValueItem valueItem = e.Item.Tag as FieldValueItem;
valueItem.PivotGrid.BeginUpdate();
var sortConditions = valueItem.PivotGrid.GetFieldsByArea(valueItem.IsColumn ? FieldArea.ColumnArea : FieldArea.RowArea).
Where(f => f.AreaIndex <= valueItem.Field.AreaIndex).Select(f => new
{
Field = f,
Value = valueItem.PivotGrid.GetFieldValue(f, valueItem.MaxLastLevelIndex)
});
valueItem.PivotGrid.GetFieldsByArea(valueItem.IsColumn ? FieldArea.RowArea : FieldArea.ColumnArea).ForEach(f =>
{
f.SortOrder = FieldSortOrder.Descending;
f.SortByField = valueItem.DataField;
f.SortByConditions.Clear();
f.SortByConditions.AddRange(sortConditions.Select(c => new SortByCondition(c.Field, c.Value)));
f.TopValueCount = 5;
f.TopValueShowOthers = true;
});
valueItem.PivotGrid.EndUpdate();
}
object IValueConverter.Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
FieldValueItem item = (FieldValueItem)value;
return(item.Field != null && item.Field.Area == FieldArea.DataArea && item.Field.UnboundType != FieldUnboundColumnType.Bound);
}
