private void HandleValueMouseClick(PivotFieldValueEventArgs e) { PivotGridField[] higherFields = e.GetHigherLevelFields(); object[] higherValues = new object[higherFields.Length]; for (int i = 0; i < higherFields.Length; i++) { higherValues[i] = e.GetHigherLevelFieldValue(higherFields[i]); } pivotGridControl1.BeginUpdate(); PivotArea otherArea = GetOtherArea(e); List <PivotGridField> otherFields = pivotGridControl1.GetFieldsByArea(otherArea); for (int i = 0; i < otherFields.Count; i++) { otherFields[i].SortBySummaryInfo.Field = e.DataField; otherFields[i].SortBySummaryInfo.Conditions.Clear(); for (int j = 0; j < higherFields.Length; j++) { otherFields[i].SortBySummaryInfo.Conditions.Add(new PivotGridFieldSortCondition(higherFields[j], higherValues[j])); } if (e.Field != null && e.Field.Area != PivotArea.DataArea) { otherFields[i].SortBySummaryInfo.Conditions.Add(new PivotGridFieldSortCondition(e.Field, e.Value)); } } pivotGridControl1.EndUpdate(); }
protected void ASPxPivotGrid1_CustomCallback(object sender, PivotGridCustomCallbackEventArgs e) { ASPxPivotGrid pivot = (ASPxPivotGrid)sender; pivot.JSProperties["cpAlertMessage"] = null; string[] parameters = e.Parameters.Split(new char[] { '|' }); if (parameters.Length == 5 && parameters[0] == "MenuItemClick") { if (parameters[1] == "hideValue") { bool isColumn = parameters[4] == "ColumnArea"; PivotFieldValueEventArgs fieldValueInfo = pivot.GetFieldValueInfo(isColumn, Convert.ToInt32(parameters[3])); if (isColumn) { pivot.JSProperties["cpAlertMessage"] = string.Format("Cannot hide the {0} column", fieldValueInfo.Value); } else { if (fieldValueInfo.Field != null) { fieldValueInfo.Field.FilterValues.Add(fieldValueInfo.Value); } } } } }
void ApplySortByValue(PivotFieldValueEventArgs valueInfo) { if (valueInfo.DataField != valueInfo.Field) { return; } SortInfo sortInfo = new SortInfo(); sortInfo.DataField = valueInfo.DataField; PivotGridField[] fields = valueInfo.GetHigherLevelFields(); for (int i = 0; i < fields.Length; i++) { sortInfo.Conditions.Add(new PivotGridFieldSortCondition(fields[i], valueInfo.GetFieldValue(fields[i], valueInfo.MinIndex))); } this.sortInfo = sortInfo; pivotGridControl1.RefreshData(); }
public void InstantiateIn(Control container) { PivotGridFieldValueTemplateContainer c = (PivotGridFieldValueTemplateContainer)container; PivotGridFieldValueHtmlCell cell = c.CreateFieldValue(); PivotFieldValueItem valueItem = c.ValueItem; PivotFieldValueEventArgs helperArgs = new PivotFieldValueEventArgs(valueItem); PivotGridField[] fields = helperArgs.GetHigherLevelFields(); List <object> fieldValues = new List <object>(); foreach (PivotGridField field in fields) { object currentValue = helperArgs.GetHigherLevelFieldValue(field); if (currentValue != null) { fieldValues.Add(currentValue); } } cell.Controls.AddAt(cell.Controls.IndexOf(cell.TextControl), new MyLink(c.Text, fieldValues)); cell.Controls.Remove(cell.TextControl); c.Controls.Add(cell); }
private PivotArea GetOtherArea(PivotFieldValueEventArgs e) { return(e.IsColumn ? PivotArea.RowArea : PivotArea.ColumnArea); }
private void pivotGridControl1_FieldValueCollapsed(object sender, PivotFieldValueEventArgs e) { TransferData(currentChartDataSourceType); }