void initPivotGridButton_Click(object sender, RoutedEventArgs e)
{
// pivotGridControl.URL = WSDataUrl;
pivotGridControl.Connection = ConnectionStringId;
pivotGridControl.Query = tbMdxQuery.Text;
pivotGridControl.UpdateScript = tbUpdateScript.Text;
pivotGridControl.MembersViewMode = (Ranet.AgOlap.Controls.ViewModeTypes)cbMembersViewMode.SelectedIndex;
pivotGridControl.MemberVisualizationType = (Ranet.Olap.Core.Data.MemberVisualizationTypes)cbMemberVisualizationType.SelectedIndex;
pivotGridControl.DataReorganizationType = (Ranet.Olap.Core.Providers.DataReorganizationTypes)cbDataReorganizationType.SelectedIndex;
pivotGridControl.DefaultMemberAction = (Ranet.AgOlap.Controls.MemberClickBehaviorTypes)cbDefaultMemberAction.SelectedIndex;
pivotGridControl.ColumnTitleClickBehavior = (Ranet.AgOlap.Controls.ColumnTitleClickBehavior)cbColumnTitleClickBehavior.SelectedIndex;
pivotGridControl.DrillDownMode = (Ranet.AgOlap.Controls.DrillDownMode)cbDrillDownMode.SelectedIndex;
pivotGridControl.IsUpdateable = ckbIsUpdateable.IsChecked.Value;
pivotGridControl.AutoWidthColumns = ckbAutoWidthColumns.IsChecked.Value;
pivotGridControl.ColumnsIsInteractive = ckbColumnsIsInteractive.IsChecked.Value;
pivotGridControl.RowsIsInteractive = ckbRowsIsInteractive.IsChecked.Value;
pivotGridControl.UseColumnsAreaHint = ckbUseColumnsAreaHint.IsChecked.Value;
pivotGridControl.UseRowsAreaHint = ckbUseRowsAreaHint.IsChecked.Value;
pivotGridControl.UseCellsAreaHint = ckbUseCellsAreaHint.IsChecked.Value;
pivotGridControl.UseCellConditionsDesigner = ckbUseCellConditionsDesigner.IsChecked.Value;
if (!pivotGridControl.UseCellConditionsDesigner)
{
var conds = new CellConditionsDescriptor("[Measures].[Internet Sales Amount]");
var cellApp = new CellAppearanceObject(Colors.Cyan, Colors.Black, Colors.Black);
cellApp.Options.UseBackColor = true;
// cellApp.Options.UseBorderColor=true;
var cond = new CellCondition(CellConditionType.GreaterOrEqual, 1000000.0, 1000000.0, cellApp);
conds.Conditions.Add(cond);
pivotGridControl.CustomCellsConditions = new List<CellConditionsDescriptor>();
pivotGridControl.CustomCellsConditions.Add(conds);
}
pivotGridControl.Initialize();
}
public void Initialize(CellCondition condition)
{
m_Condition = condition;
IsEnabled = Condition != null;
ConditionTypeCombo.EditEnd -= new EventHandler(ConditionTypeCombo_EditEnd);
ConditionTypeCombo.ConditionType = Condition != null ? Condition.ConditionType : CellConditionType.None;
ConditionTypeCombo.Value1 = Condition != null ? Condition.Value1 : 0;
ConditionTypeCombo.Value2 = Condition != null ? Condition.Value2 : 0;
ConditionTypeCombo.EditEnd += new EventHandler(ConditionTypeCombo_EditEnd);
ShowValue.Checked -= new RoutedEventHandler(PropertyChecked);
ShowValue.Unchecked -= new RoutedEventHandler(PropertyChecked);
ShowValue.IsChecked = Condition != null ? Condition.Appearance.Options.ShowValue : false;
ShowValue.Checked += new RoutedEventHandler(PropertyChecked);
ShowValue.Unchecked += new RoutedEventHandler(PropertyChecked);
ShowImage.Checked -= new RoutedEventHandler(PropertyChecked);
ShowImage.Unchecked -= new RoutedEventHandler(PropertyChecked);
ShowImage.IsChecked = Condition != null ? Condition.Appearance.Options.UseImage : false;
ShowImage.Checked += new RoutedEventHandler(PropertyChecked);
ShowImage.Unchecked += new RoutedEventHandler(PropertyChecked);
UseBackColor.Checked -= new RoutedEventHandler(PropertyChecked);
UseBackColor.Unchecked -= new RoutedEventHandler(PropertyChecked);
UseBackColor.IsChecked = Condition != null ? Condition.Appearance.Options.UseBackColor : false;
UseBackColor.Checked += new RoutedEventHandler(PropertyChecked);
UseBackColor.Unchecked += new RoutedEventHandler(PropertyChecked);
UseForeColor.Checked -= new RoutedEventHandler(PropertyChecked);
UseForeColor.Unchecked -= new RoutedEventHandler(PropertyChecked);
UseForeColor.IsChecked = Condition != null ? Condition.Appearance.Options.UseForeColor : false;
UseForeColor.Checked += new RoutedEventHandler(PropertyChecked);
UseForeColor.Unchecked += new RoutedEventHandler(PropertyChecked);
UseAllOptions.Checked -= new RoutedEventHandler(PropertyChecked);
UseAllOptions.Unchecked -= new RoutedEventHandler(PropertyChecked);
UseAllOptions.IsChecked = Condition != null ? Condition.Appearance.Options.UseAllOptions : false;
UseAllOptions.Checked += new RoutedEventHandler(PropertyChecked);
UseAllOptions.Unchecked += new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.Checked -= new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.Unchecked -= new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.IsChecked = Condition != null ? Condition.Appearance.Options.IgnoreAllOptions : false;
IgnoreAllOptions.Checked += new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.Unchecked += new RoutedEventHandler(PropertyChecked);
ShowProgressBar.Checked -= new RoutedEventHandler(PropertyChecked);
ShowProgressBar.Unchecked -= new RoutedEventHandler(PropertyChecked);
ShowProgressBar.IsChecked = Condition != null ? Condition.Appearance.Options.UseProgressBar : false;
ShowProgressBar.Checked += new RoutedEventHandler(PropertyChecked);
ShowProgressBar.Unchecked += new RoutedEventHandler(PropertyChecked);
numMinValue.Value = Condition != null ? Condition.Appearance.ProgressBarOptions.MinValue : 0;
numMaxValue.Value = Condition != null ? Condition.Appearance.ProgressBarOptions.MaxValue : 1;
comboBackColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboBackColor.SelectItem(Condition != null ? Condition.Appearance.BackColor : Colors.Transparent);
comboBackColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboForeColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboForeColor.SelectItem(Condition != null ? Condition.Appearance.ForeColor : Colors.Transparent);
comboForeColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboBorderColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboBorderColor.SelectItem(Condition != null ? Condition.Appearance.BorderColor : Colors.Transparent);
comboBorderColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboStartColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboStartColor.SelectItem(Condition != null ? Condition.Appearance.ProgressBarOptions.StartColor : Colors.Transparent);
comboStartColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboEndColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboEndColor.SelectItem(Condition != null ? Condition.Appearance.ProgressBarOptions.EndColor : Colors.Transparent);
comboEndColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
try
{
imgCustomImage.Source = Condition != null ? new BitmapImage(new Uri(Condition.Appearance.CustomImageUri, UriKind.Relative)) : null;
}
catch { }
}
static CellConditionsDescriptor Deserialize(XmlReader reader)
{
if (reader != null)
{
try
{
CellConditionsDescriptor target = null;
if (!(reader.NodeType == XmlNodeType.Element &&
reader.Name == XML_CellConditionsDescriptor))
{
reader.ReadToFollowing(XML_CellConditionsDescriptor);
}
if (reader.NodeType == XmlNodeType.Element &&
reader.Name == XML_CellConditionsDescriptor)
{
target = new CellConditionsDescriptor();
reader.Read();
var data = Jayrock.Json.Conversion.JsonConvert.Import(reader.Value) as JsonArray;
target.MemberUniqueName = data[0] != null?CellSetData.ConvertFromJson(data[0]).ToString() : String.Empty;
var conditions = data.GetArray(1);
for (int i = 0; i < conditions.Length; i++)
{
var cond_data = conditions.GetArray(i);
CellCondition cond = new CellCondition();
String type = cond_data.GetValue(0) != null?cond_data.GetValue(0).ToString() : CellConditionType.None.ToString();
cond.ConditionType = (CellConditionType)(CellConditionType.Parse(typeof(CellConditionType), type, true));
cond.Value1 = Convert.ToDouble(cond_data.GetValue(1));
cond.Value2 = Convert.ToDouble(cond_data.GetValue(2));
var cellAppearance = cond_data.GetArray(3);
cond.Appearance.BackColor = FromJsonColor(cellAppearance.GetArray(0));
cond.Appearance.BorderColor = FromJsonColor(cellAppearance.GetArray(1));
cond.Appearance.ForeColor = FromJsonColor(cellAppearance.GetArray(2));
cond.Appearance.CustomImageUri = Convert.ToString(cellAppearance.GetValue(3));
var options = cellAppearance.GetArray(4);
cond.Appearance.Options.IgnoreAllOptions = Convert.ToBoolean(options[0]);
cond.Appearance.Options.ShowValue = Convert.ToBoolean(options[1]);
cond.Appearance.Options.UseAllOptions = Convert.ToBoolean(options[2]);
cond.Appearance.Options.UseBackColor = Convert.ToBoolean(options[3]);
cond.Appearance.Options.UseBorderColor = Convert.ToBoolean(options[4]);
cond.Appearance.Options.UseForeColor = Convert.ToBoolean(options[5]);
cond.Appearance.Options.UseImage = Convert.ToBoolean(options[6]);
cond.Appearance.Options.UseProgressBar = Convert.ToBoolean(options[7]);
var progressBarOptions = cellAppearance.GetArray(5);
cond.Appearance.ProgressBarOptions.StartColor = FromJsonColor(progressBarOptions.GetArray(0));
cond.Appearance.ProgressBarOptions.EndColor = FromJsonColor(progressBarOptions.GetArray(1));
cond.Appearance.ProgressBarOptions.MinValue = Convert.ToDouble(progressBarOptions.GetValue(2));
cond.Appearance.ProgressBarOptions.MaxValue = Convert.ToDouble(progressBarOptions.GetValue(3));
cond.Appearance.ProgressBarOptions.IsIndeterminate = Convert.ToBoolean(progressBarOptions.GetValue(4));
target.Conditions.Add(cond);
}
if (reader.NodeType == XmlNodeType.EndElement &&
reader.Name == XML_CellConditionsDescriptor)
{
reader.ReadEndElement();
}
}
return(target);
}
catch (XmlException ex)
{
throw ex;
//return null;
}
}
return(null);
}
public void Initialize(CellCondition condition)
{
m_Condition = condition;
IsEnabled = Condition != null;
ConditionTypeCombo.EditEnd -= new EventHandler(ConditionTypeCombo_EditEnd);
ConditionTypeCombo.ConditionType = Condition != null ? Condition.ConditionType : CellConditionType.None;
ConditionTypeCombo.Value1 = Condition != null ? Condition.Value1 : 0;
ConditionTypeCombo.Value2 = Condition != null ? Condition.Value2 : 0;
ConditionTypeCombo.EditEnd += new EventHandler(ConditionTypeCombo_EditEnd);
ShowValue.Checked -= new RoutedEventHandler(PropertyChecked);
ShowValue.Unchecked -= new RoutedEventHandler(PropertyChecked);
ShowValue.IsChecked = Condition != null ? Condition.Appearance.Options.ShowValue : false;
ShowValue.Checked += new RoutedEventHandler(PropertyChecked);
ShowValue.Unchecked += new RoutedEventHandler(PropertyChecked);
ShowImage.Checked -= new RoutedEventHandler(PropertyChecked);
ShowImage.Unchecked -= new RoutedEventHandler(PropertyChecked);
ShowImage.IsChecked = Condition != null ? Condition.Appearance.Options.UseImage : false;
ShowImage.Checked += new RoutedEventHandler(PropertyChecked);
ShowImage.Unchecked += new RoutedEventHandler(PropertyChecked);
UseBackColor.Checked -= new RoutedEventHandler(PropertyChecked);
UseBackColor.Unchecked -= new RoutedEventHandler(PropertyChecked);
UseBackColor.IsChecked = Condition != null ? Condition.Appearance.Options.UseBackColor : false;
UseBackColor.Checked += new RoutedEventHandler(PropertyChecked);
UseBackColor.Unchecked += new RoutedEventHandler(PropertyChecked);
UseForeColor.Checked -= new RoutedEventHandler(PropertyChecked);
UseForeColor.Unchecked -= new RoutedEventHandler(PropertyChecked);
UseForeColor.IsChecked = Condition != null ? Condition.Appearance.Options.UseForeColor : false;
UseForeColor.Checked += new RoutedEventHandler(PropertyChecked);
UseForeColor.Unchecked += new RoutedEventHandler(PropertyChecked);
UseAllOptions.Checked -= new RoutedEventHandler(PropertyChecked);
UseAllOptions.Unchecked -= new RoutedEventHandler(PropertyChecked);
UseAllOptions.IsChecked = Condition != null ? Condition.Appearance.Options.UseAllOptions : false;
UseAllOptions.Checked += new RoutedEventHandler(PropertyChecked);
UseAllOptions.Unchecked += new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.Checked -= new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.Unchecked -= new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.IsChecked = Condition != null ? Condition.Appearance.Options.IgnoreAllOptions : false;
IgnoreAllOptions.Checked += new RoutedEventHandler(PropertyChecked);
IgnoreAllOptions.Unchecked += new RoutedEventHandler(PropertyChecked);
ShowProgressBar.Checked -= new RoutedEventHandler(PropertyChecked);
ShowProgressBar.Unchecked -= new RoutedEventHandler(PropertyChecked);
ShowProgressBar.IsChecked = Condition != null ? Condition.Appearance.Options.UseProgressBar : false;
ShowProgressBar.Checked += new RoutedEventHandler(PropertyChecked);
ShowProgressBar.Unchecked += new RoutedEventHandler(PropertyChecked);
numMinValue.Value = Condition != null ? Condition.Appearance.ProgressBarOptions.MinValue : 0;
numMaxValue.Value = Condition != null ? Condition.Appearance.ProgressBarOptions.MaxValue : 1;
comboBackColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboBackColor.SelectItem(Condition != null ? Condition.Appearance.BackColor : Colors.Transparent);
comboBackColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboForeColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboForeColor.SelectItem(Condition != null ? Condition.Appearance.ForeColor : Colors.Transparent);
comboForeColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboBorderColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboBorderColor.SelectItem(Condition != null ? Condition.Appearance.BorderColor : Colors.Transparent);
comboBorderColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboStartColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboStartColor.SelectItem(Condition != null ? Condition.Appearance.ProgressBarOptions.StartColor : Colors.Transparent);
comboStartColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboEndColor.ColorsComboBox.SelectionChanged -= new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
comboEndColor.SelectItem(Condition != null ? Condition.Appearance.ProgressBarOptions.EndColor : Colors.Transparent);
comboEndColor.ColorsComboBox.SelectionChanged += new SelectionChangedEventHandler(ColorsComboBox_SelectionChanged);
try
{
imgCustomImage.Source = Condition != null ? new BitmapImage(new Uri(Condition.Appearance.CustomImageUri, UriKind.Relative)) : null;
}
catch { }
}
static CellConditionsDescriptor Deserialize(XmlReader reader)
{
if (reader != null)
{
try
{
CellConditionsDescriptor target = null;
if (!(reader.NodeType == XmlNodeType.Element &&
reader.Name == XML_CellConditionsDescriptor))
{
reader.ReadToFollowing(XML_CellConditionsDescriptor);
}
if (reader.NodeType == XmlNodeType.Element &&
reader.Name == XML_CellConditionsDescriptor)
{
target = new CellConditionsDescriptor();
reader.Read();
var data = Jayrock.Json.Conversion.JsonConvert.Import(reader.Value) as JsonArray;
target.MemberUniqueName = data[0] != null ? CellSetData.ConvertFromJson(data[0]).ToString() : String.Empty;
var conditions = data.GetArray(1);
for (int i = 0; i < conditions.Length; i++)
{
var cond_data = conditions.GetArray(i);
CellCondition cond = new CellCondition();
String type = cond_data.GetValue(0) != null ? cond_data.GetValue(0).ToString() : CellConditionType.None.ToString();
cond.ConditionType = (CellConditionType)(CellConditionType.Parse(typeof(CellConditionType), type, true));
cond.Value1 = Convert.ToDouble(cond_data.GetValue(1));
cond.Value2 = Convert.ToDouble(cond_data.GetValue(2));
var cellAppearance = cond_data.GetArray(3);
cond.Appearance.BackColor = FromJsonColor(cellAppearance.GetArray(0));
cond.Appearance.BorderColor = FromJsonColor(cellAppearance.GetArray(1));
cond.Appearance.ForeColor = FromJsonColor(cellAppearance.GetArray(2));
cond.Appearance.CustomImageUri = Convert.ToString(cellAppearance.GetValue(3));
var options = cellAppearance.GetArray(4);
cond.Appearance.Options.IgnoreAllOptions = Convert.ToBoolean(options[0]);
cond.Appearance.Options.ShowValue = Convert.ToBoolean(options[1]);
cond.Appearance.Options.UseAllOptions = Convert.ToBoolean(options[2]);
cond.Appearance.Options.UseBackColor = Convert.ToBoolean(options[3]);
cond.Appearance.Options.UseBorderColor = Convert.ToBoolean(options[4]);
cond.Appearance.Options.UseForeColor = Convert.ToBoolean(options[5]);
cond.Appearance.Options.UseImage = Convert.ToBoolean(options[6]);
cond.Appearance.Options.UseProgressBar = Convert.ToBoolean(options[7]);
var progressBarOptions = cellAppearance.GetArray(5);
cond.Appearance.ProgressBarOptions.StartColor = FromJsonColor(progressBarOptions.GetArray(0));
cond.Appearance.ProgressBarOptions.EndColor = FromJsonColor(progressBarOptions.GetArray(1));
cond.Appearance.ProgressBarOptions.MinValue = Convert.ToDouble(progressBarOptions.GetValue(2));
cond.Appearance.ProgressBarOptions.MaxValue = Convert.ToDouble(progressBarOptions.GetValue(3));
cond.Appearance.ProgressBarOptions.IsIndeterminate = Convert.ToBoolean(progressBarOptions.GetValue(4));
target.Conditions.Add(cond);
}
if (reader.NodeType == XmlNodeType.EndElement &&
reader.Name == XML_CellConditionsDescriptor)
{
reader.ReadEndElement();
}
}
return target;
}
catch (XmlException ex)
{
throw ex;
//return null;
}
}
return null;
}