internal static ReportItemCollection CreateItemsCollection(DataSet resultDataSet, DataGridViewColumn[] displayCols)
{
ReportItemCollection sourceItems = WizardHelper.ReportItemCollection(resultDataSet);
ReportItemCollection destItems = WizardHelper.ExtractSelectedItems(sourceItems, displayCols);
return(destItems);
}
private void WriteResult()
{
if (this.resultDataSet != null)
{
// check reordering of columns
DataGridViewColumn[] displayCols;
DataGridViewColumnCollection dc = this.grdQuery.Columns;
displayCols = new DataGridViewColumn[dc.Count];
for (int i = 0; i < dc.Count; i++)
{
if (dc[i].Visible)
{
displayCols[dc[i].DisplayIndex] = dc[i];
}
}
ReportItemCollection destItems = WizardHelper.CreateItemsCollection(this.resultDataSet, displayCols);
reportStructure.ReportItemCollection.Clear();
reportStructure.ReportItemCollection.AddRange(destItems);
var abstractColumns = WizardHelper.AvailableFieldsCollection(this.resultDataSet);
if (abstractColumns != null)
{
reportStructure.AvailableFieldsCollection.Clear();
reportStructure.AvailableFieldsCollection.AddRange(abstractColumns);
}
}
base.EnableNext = true;
base.EnableFinish = true;
}
private void WriteResult()
{
if (this.resultDataSet != null)
{
// check reordering of columns
DataGridViewColumn[] displayCols;
DataGridViewColumnCollection dc = this.grdQuery.Columns;
displayCols = new DataGridViewColumn[dc.Count];
for (int i = 0; i < dc.Count; i++)
{
if (dc[i].Visible)
{
displayCols[dc[i].DisplayIndex] = dc[i];
}
}
ReportItemCollection sourceItems = WizardHelper.ReportItemCollection(this.resultDataSet);
AvailableFieldsCollection abstractColumns = WizardHelper.AvailableFieldsCollection(this.resultDataSet);
ReportItemCollection destItems = new ReportItemCollection();
// only checked columns are used in the report
foreach (DataGridViewColumn cc in displayCols)
{
DataGridViewColumnHeaderCheckBoxCell hc = (DataGridViewColumnHeaderCheckBoxCell)cc.HeaderCell;
if (hc.Checked)
{
BaseReportItem br = (BaseReportItem)sourceItems.Find(cc.HeaderText);
destItems.Add(br);
}
}
reportStructure.ReportItemCollection.Clear();
reportStructure.ReportItemCollection.AddRange(destItems);
/*
* if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0)) {
* reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection);
* }
*/
if (abstractColumns != null)
{
reportStructure.AvailableFieldsCollection.Clear();
reportStructure.AvailableFieldsCollection.AddRange(abstractColumns);
}
/*
* if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0)) {
* reportStructure.SqlQueryParameters.Clear();
* reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection);
* }
*/
}
base.EnableNext = true;
base.EnableFinish = true;
}
public virtual void CreatePageFooter()
{
var textItem = WizardHelper.CreateTextItem("=Globals!PageNumber");
textItem.Name = "PageNumber1";
this.FixLayout(this.ReportModel.PageFooter, textItem, GlobalEnums.ItemsLayout.Right);
this.ReportModel.PageFooter.Items.Add(textItem);
}
public virtual void CreatePageFooter()
{
// ICSharpCode.Reports.Core.BaseTextItem a = WizardHelper.CreateTextItem(GlobalValues.FunctionStartTag + "=Globals!PageNumber" + GlobalValues.FunctionEndTag);
ICSharpCode.Reports.Core.BaseTextItem a = WizardHelper.CreateTextItem("=Globals!PageNumber");
a.Name = "PageNumber1";
this.FixLayout(this.reportModel.PageFooter, a, GlobalEnums.ItemsLayout.Right);
this.reportModel.PageFooter.Items.Add(a);
}
private void SetupGrid()
{
if (this.resultDataSet != null)
{
this.grdQuery.DataSource = this.resultDataSet.Tables[0];
WizardHelper.SetupGridView(this.grdQuery);
this.grdQuery.AllowUserToOrderColumns = true;
}
}
public virtual void CreateReportHeader()
{
string header = this.ReportModel.ReportSettings.ReportName;
var textItem = WizardHelper.CreateTextItem(header);
textItem.Name = header;
this.FixLayout(this.ReportModel.ReportHeader, textItem, GlobalEnums.ItemsLayout.Center);
this.ReportModel.ReportHeader.Items.Add(textItem);
}
void FillDataGrid(string fileName)
{
this.resultDataSet = new DataSet();
this.resultDataSet.Locale = CultureInfo.CurrentCulture;
resultDataSet.ReadXml(fileName);
this.grdQuery.DataSource = resultDataSet.Tables[0];
WizardHelper.SetupGridView(this.grdQuery);
grdQuery.AllowUserToOrderColumns = true;
base.EnableFinish = true;
}
public virtual void CreateReportHeader()
{
ICSharpCode.Reports.Core.BaseTextItem a;
string header = this.reportModel.ReportSettings.ReportName;
a = WizardHelper.CreateTextItem(header);
a.Name = header;
this.FixLayout(this.reportModel.ReportHeader, a, GlobalEnums.ItemsLayout.Center);
this.reportModel.ReportHeader.Items.Add(a);
}
/*
* private AvailableFieldsCollection ColumnsFromTable (DataTable table)
* {
* AvailableFieldsCollection av = new AvailableFieldsCollection();
* AbstractColumn ac = null;
* foreach (DataColumn dc in resultDataSet.Tables[0].Columns) {
* Console.WriteLine("{0} - {1}",dc.ColumnName,dc.DataType);
* ac = new AbstractColumn(dc.ColumnName,dc.DataType);
* av.Add(ac);
* }
* return av;
* }
*/
#region DataGridView
void FillDataGrid(string fileName)
{
this.resultDataSet = new DataSet();
this.resultDataSet.Locale = CultureInfo.CurrentCulture;
resultDataSet.ReadXml(fileName);
this.grdQuery.DataSource = resultDataSet.Tables[0];
this.abstractColumns = WizardHelper.AbstractColumnsFromDataSet(this.resultDataSet);
foreach (DataGridViewColumn dd in this.grdQuery.Columns)
{
DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell();
cb.CheckBoxAlignment = HorizontalAlignment.Left;
cb.Checked = true;
dd.HeaderCell = cb;
}
base.EnableFinish = true;
}
private static ReportItemCollection HeaderColumnsFromReportItems(ReportItemCollection reportItemCollection)
{
if (reportItemCollection == null)
{
throw new ArgumentNullException("reportItemCollection");
}
ReportItemCollection itemCol = new ReportItemCollection();
ICSharpCode.Reports.Core.BaseTextItem rItem;
int i = 1;
foreach (IDataRenderer dataRenderer in reportItemCollection)
{
rItem = WizardHelper.CreateTextItem(dataRenderer.ColumnName);
rItem.Name = rItem.Text + i.ToString(System.Globalization.CultureInfo.InvariantCulture);
itemCol.Add(rItem);
i++;
}
return(itemCol);
}
public override bool ReceiveDialogMessage(DialogMessage message)
{
if (customizer == null)
{
customizer = (Properties)base.CustomizationObject;
reportStructure = (ReportStructure)customizer.Get("Generator");
}
if (message == DialogMessage.Activated)
{
this.model = reportStructure.CreateAndFillReportModel();
this.resultDataSet = FillGrid();
if (this.resultDataSet != null)
{
this.grdQuery.DataSource = this.resultDataSet.Tables[0];
foreach (DataGridViewColumn dd in this.grdQuery.Columns)
{
DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell();
cb.CheckBoxAlignment = HorizontalAlignment.Right;
cb.Checked = true;
dd.HeaderCell = cb;
dd.SortMode = DataGridViewColumnSortMode.NotSortable;
}
this.grdQuery.AllowUserToOrderColumns = true;
}
base.EnableNext = true;
base.EnableFinish = true;
}
else if (message == DialogMessage.Finish)
{
if (this.resultDataSet != null)
{
// check reordering of columns
DataGridViewColumn[] displayCols;
DataGridViewColumnCollection dc = this.grdQuery.Columns;
displayCols = new DataGridViewColumn[dc.Count];
for (int i = 0; i < dc.Count; i++)
{
if (dc[i].Visible)
{
displayCols[dc[i].DisplayIndex] = dc[i];
}
}
// only checked columns are used in the report
ReportItemCollection sourceItems = WizardHelper.DataItemsFromDataSet(this.resultDataSet);
AvailableFieldsCollection abstractColumns = WizardHelper.AbstractColumnsFromDataSet(this.resultDataSet);
ReportItemCollection destItems = new ReportItemCollection();
foreach (DataGridViewColumn cc in displayCols)
{
DataGridViewColumnHeaderCheckBoxCell hc = (DataGridViewColumnHeaderCheckBoxCell)cc.HeaderCell;
if (hc.Checked)
{
BaseReportItem br = (BaseReportItem)sourceItems.Find(cc.HeaderText);
destItems.Add(br);
}
}
reportStructure.ReportItemCollection.AddRange(destItems);
if ((this.sqlParamsCollection != null) && (this.sqlParamsCollection.Count > 0))
{
reportStructure.SqlQueryParameters.AddRange(sqlParamsCollection);
}
if (abstractColumns != null)
{
reportStructure.AvailableFieldsCollection.AddRange(abstractColumns);
}
}
base.EnableNext = true;
base.EnableFinish = true;
}
return(true);
}
