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 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();
}