public void ShowPivotForm()
{
pivotGrid = new PivotGridControl();
pivotGrid.Dock = System.Windows.Forms.DockStyle.Fill;
pivotForm = new XtraForm();
pivotForm.Icon = Marbid.Module.Win.Properties.Resources.mareinico;
pivotForm.StartPosition = FormStartPosition.CenterScreen;
pivotForm.Text = "Pivot Grid: " + ReportName;
pivotForm.Controls.Add(pivotGrid);
DataRetrieval retrieval = new DataRetrieval();
pivotForm.Height = 768;
pivotForm.Width = 1024;
List <ParameterDictionary> paramDictionary;
if (ParameterDefinition.Count > 0)
{
ParameterForm parameterForm = new ParameterForm();
parameterForm.ParameterDefinition = ParameterDefinition;
if (parameterForm.ShowParameterDialog() == DialogResult.Cancel)
{
return;
}
paramDictionary = parameterForm.ParameterDictionary;
retrieval.Parameters = paramDictionary;
}
retrieval.ConnectionString = ConnectionString;
retrieval.QueryString = QueryString;
DataSet dataSet = new DataSet();
SplashScreenManager.ShowForm(typeof(WaitForm1));
try
{
dataSet = retrieval.GetDataSet("ReportData", dataSet);
}
finally
{
SplashScreenManager.CloseForm(false);
}
pivotGrid.OptionsMenu.EnableFormatRulesMenu = true;
pivotGrid.DataSource = dataSet.Tables["ReportData"];
pivotGrid.PopupMenuShowing += PivotGrid_PopupMenuShowing;
pivotGrid.CellDoubleClick += PivotGrid_CellDoubleClick;
if (!String.IsNullOrWhiteSpace(LayoutData))
{
MemoryStream stream = new MemoryStream();
StreamWriter writer = new StreamWriter(stream);
writer.Write(LayoutData);
writer.Flush();
stream.Position = 0;
pivotGrid.RestoreLayoutFromStream(stream, opt);
}
else
{
pivotGrid.RetrieveFields();
foreach (PivotGridField field in pivotGrid.Fields)
{
if (field.DataType == typeof(System.Double) || field.DataType == typeof(System.Decimal))
{
field.CellFormat.FormatType = FormatType.Numeric;
field.CellFormat.FormatString = "n2";
field.AllowedAreas = PivotGridAllowedAreas.DataArea;
}
else
{
field.SummaryType = DevExpress.Data.PivotGrid.PivotSummaryType.Count;
}
}
}
pivotForm.Show();
}
public void ShowGridForm()
{
gridView = new GridView();
gridControl = new GridControl();
form = new XtraForm();
form.Icon = Marbid.Module.Win.Properties.Resources.mareinico;
form.StartPosition = FormStartPosition.CenterScreen;
form.Text = ReportName;
gridControl.ViewCollection.Add(gridView);
gridControl.Dock = DockStyle.Fill;
DataSet dataSet = new DataSet();
DataRetrieval retrieval = new DataRetrieval();
List <ParameterDictionary> paramDictionary;
if (parameterDefinition.Count > 0)
{
ParameterForm parameterForm = new ParameterForm();
parameterForm.ParameterDefinition = parameterDefinition;
if (parameterForm.ShowParameterDialog() == DialogResult.Cancel)
{
return;
}
paramDictionary = parameterForm.ParameterDictionary;
retrieval.Parameters = paramDictionary;
}
retrieval.ConnectionString = connectionString;
retrieval.QueryString = queryString;
SplashScreenManager.ShowForm(typeof(WaitForm1));
try
{
dataSet = retrieval.GetDataSet("ReportData", dataSet);
}
finally
{
//Close Wait Form
SplashScreenManager.CloseForm(false);
}
gridControl.DataSource = dataSet.Tables["ReportData"];
gridView.PopulateColumns();
gridControl.ForceInitialize();
form.Controls.Add(gridControl);
form.Shown += GridForm_Shown;
GridView view = (GridView)gridControl.MainView;
foreach (GridColumn col in view.Columns)
{
col.OptionsColumn.ReadOnly = true;
if (col.ColumnType == typeof(System.Decimal) || col.ColumnType == typeof(System.Double))
{
col.DisplayFormat.FormatType = FormatType.Numeric;
col.DisplayFormat.FormatString = "n2";
col.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
}
}
form.Height = 768;
form.Width = 1024;
view.PopupMenuShowing += GridView_PopupMenuShowing;
SplashScreenManager.CloseForm(false);
form.Show();
}
public DialogResult ShowParameterDialog()
{
DataRetrieval retrieval = new DataRetrieval();
XtraForm form = new XtraForm();
form.Icon = Marbid.Module.Win.Properties.Resources.mareinico;
form.Text = "Parameters";
LayoutControl layout = new LayoutControl()
{
Name = "layout",
};
layout.Root.BeginUpdate();
foreach (ParameterDefinition definition in parameterDefinition)
{
LayoutControlItem itemLayout;
switch (definition.ParameterPropertyType)
{
case ParameterPropertyType.DataSource:
string paramQuery = definition.ParameterQueryString;
string paramConnection = definition.ParameterConnection;
DataSet paramDataSet = new DataSet();
paramDataSet = retrieval.GetDataSet("ParamData", paramQuery, paramConnection, paramDataSet);
LookUpEdit lookUpEdit = new LookUpEdit();
lookUpEdit.Properties.DataSource = paramDataSet.Tables[0];
lookUpEdit.Properties.ValueMember = paramDataSet.Tables[0].Columns[0].ColumnName;
lookUpEdit.Properties.DisplayMember = paramDataSet.Tables[0].Columns[1].ColumnName;
lookUpEdit.EditValue = definition.ParameterDefaultValue;
itemLayout = layout.AddItem(definition.ParameterCaption, lookUpEdit);
itemLayout.OptionsTableLayoutItem.RowIndex = definition.ParameterIndex;
itemLayout.Name = definition.ParameterName;
lookUpEdit.EditValue = definition.ParameterDefaultValue;
break;
case BusinessObjects.ParameterPropertyType.DateTime:
DateEdit dateEdit = new DateEdit()
{
DateTime = DateTime.Now,
Name = definition.ParameterName,
EditValue = definition.ParameterDefaultValue
};
itemLayout = layout.AddItem(definition.ParameterCaption, dateEdit);
itemLayout.Name = definition.ParameterName;
itemLayout.OptionsTableLayoutItem.RowIndex = definition.ParameterIndex;
break;
case BusinessObjects.ParameterPropertyType.String:
TextEdit textEdit = new TextEdit()
{
Name = definition.ParameterName
};
itemLayout = layout.AddItem(definition.ParameterCaption, textEdit);
itemLayout.Name = definition.ParameterName;
itemLayout.OptionsTableLayoutItem.RowIndex = definition.ParameterIndex;
break;
case BusinessObjects.ParameterPropertyType.Integer:
SpinEdit spinEdit = new SpinEdit()
{
Name = definition.ParameterName
};
itemLayout = layout.AddItem(definition.ParameterCaption, spinEdit);
itemLayout.Name = definition.ParameterName;
itemLayout.OptionsTableLayoutItem.RowIndex = definition.ParameterIndex;
break;
case BusinessObjects.ParameterPropertyType.Numeric:
CalcEdit calcEdit = new CalcEdit()
{
Name = definition.ParameterName
};
itemLayout = layout.AddItem(definition.ParameterCaption, calcEdit);
itemLayout.Name = definition.ParameterName;
itemLayout.OptionsTableLayoutItem.RowIndex = definition.ParameterIndex;
break;
}
}
SimpleButton buttonOK = new SimpleButton()
{
Name = "ButtonOK",
DialogResult = DialogResult.OK,
Text = "OK"
};
SimpleButton buttonCancel = new SimpleButton()
{
Name = "ButtonCancel",
DialogResult = DialogResult.Cancel,
Text = "Cancel"
};
LayoutControlItem btn = layout.AddItem("OK", buttonOK);
btn.TextVisible = false;
form.AcceptButton = buttonOK;
btn = layout.AddItem("Cancel", buttonCancel);
btn.TextVisible = false;
form.CancelButton = buttonCancel;
layout.Root.EndUpdate();
layout.Dock = DockStyle.Fill;
form.Controls.Add(layout);
form.StartPosition = FormStartPosition.CenterScreen;
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
foreach (BaseLayoutItem item in layout.Items)
{
if (item is LayoutControlItem)
{
LayoutControlItem controlItem = (LayoutControlItem)item;
if (((LayoutControlItem)item).Control.GetType() == typeof(SpinEdit))
{
var paramData = new ParameterDictionary()
{
ParameterName = item.Name, ParameterValue = ((SpinEdit)controlItem.Control).Value
};
parameterDictionary.Add(paramData);
}
if (((LayoutControlItem)item).Control.GetType() == typeof(CalcEdit))
{
var paramData = new ParameterDictionary()
{
ParameterName = item.Name, ParameterValue = ((CalcEdit)controlItem.Control).Value
};
parameterDictionary.Add(paramData);
}
if (((LayoutControlItem)item).Control.GetType() == typeof(DateEdit))
{
var paramData = new ParameterDictionary()
{
ParameterName = item.Name, ParameterValue = ((DateEdit)controlItem.Control).DateTime
};
parameterDictionary.Add(paramData);
}
if (((LayoutControlItem)item).Control.GetType() == typeof(TextEdit))
{
var paramData = new ParameterDictionary()
{
ParameterName = item.Name, ParameterValue = ((TextEdit)controlItem.Control).Text
};
parameterDictionary.Add(paramData);
}
if (((LayoutControlItem)item).Control.GetType() == typeof(LookUpEdit))
{
var paramData = new ParameterDictionary()
{
ParameterName = item.Name, ParameterValue = ((LookUpEdit)controlItem.Control).EditValue
};
parameterDictionary.Add(paramData);
}
}
}
}
return(result);
}
