static void OnPivotFieldAreaChanging(object sender, PivotFieldAreaChangingEventArgs e)
{
PivotGridField field = e.Field;
if (field == null ||
field.Parent as PivotGridControl == null ||
((PivotGridControl)field.Parent).OlapConnectionString != null ||
field.UnboundType != FieldUnboundColumnType.Bound)
{
return;
}
if (field.Area == FieldArea.DataArea)
{
if (e.NewArea != FieldArea.DataArea)
{
e.Allow = false;
}
}
else
{
if (e.NewArea == FieldArea.DataArea)
{
e.Allow = false;
}
}
}
private static void PivotGridControlModifiedFieldAreaChanging(object sender, PivotFieldAreaChangingEventArgs e)
{
//if (e.Field.FieldName.Contains("SUPPLIER") || e.Field.FieldName.Contains("SOURCEMETHOD") || e.Field.FieldName.Contains("ORDERPLACE") || e.Field.FieldName.Contains("SOURCEWH"))
if (e.Field.FieldName.Contains("NEW"))
{
if (e.NewArea == FieldArea.RowArea || e.NewArea == FieldArea.ColumnArea || e.NewArea == FieldArea.FilterArea)
{
e.Allow = false;
}
}
else if (e.Field.FieldName.Contains("ITEMLOC"))
{
//if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea)
//{
// e.Allow = false;
//}
}
else if (e.Field.FieldName.Contains("ITEM"))
{
if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea)
{
e.Allow = false;
}
}
else if (e.Field.FieldName.Contains("LOC"))
{
if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea)
{
e.Allow = false;
}
}
else if (e.Field.FieldName.Contains("MEASURE"))
{
e.Allow = false;
}
}
private static void PivotGridControlModifiedFieldAreaChanging(object sender, PivotFieldAreaChangingEventArgs e)
{
//if (e.Field.FilterValues.ValuesExcluded.Count() != 0)
//{
// e.Allow = e.NewArea == FieldArea.FilterArea;
// //e.Field.AllowDrop = true;
//}
if (e.Field.FieldName.Contains("ITEMLOC"))
{
e.Allow = true;
}
else if (e.Field.FieldName.Contains("ITEM"))
{
if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.ColumnArea)
{
e.Allow = false;
}
}
else if (e.Field.FieldName.Contains("LOC"))
{
if (e.NewArea == FieldArea.DataArea || e.NewArea == FieldArea.RowArea)
{
e.Allow = false;
}
}
else if (e.Field.FieldName.Contains("MEASURE"))
{
if (e.NewArea == FieldArea.ColumnArea || e.NewArea == FieldArea.RowArea)
{
e.Allow = false;
}
}
}
