int GetSortByColumnIndex(PivotGridCustomFieldSortEventArgs e)
{
if (sortInfo.Conditions.Count == 0)
{
for (int i = pivotData.ColumnCount - 1; i >= 0; i--)
{
FieldValue value = pivotData.GetFieldValue(true, i);
if (value.ValueType == PivotGridValueType.GrandTotal && value.DataField == sortInfo.DataField)
{
return(i);
}
}
}
else
{
for (int i = 0; i < pivotData.ColumnCount; i++)
{
FieldValue value = pivotData.GetFieldValue(true, i);
if (IsValueFit(value, sortInfo.Conditions, sortInfo.DataField))
{
return(i);
}
}
}
return(-1);
}
void FillFieldValues(bool isColumn, int count, List <PivotGridField> fields, PivotData data)
{
for (int i = 0; i < count; i++)
{
FieldValue value = data.GetFieldValue(isColumn, i);
value.ValueType = pivotGridControl1.GetFieldValueType(isColumn, i);
value.DataField = pivotGridControl1.Cells.GetCellInfo(isColumn ? i : 0, isColumn ? 0 : i).DataField;
for (int j = 0; j < fields.Count; j++)
{
value.SetValue(j, pivotGridControl1.GetFieldValue(fields[j], i), fields[j]);
}
}
}
