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; }
internal static void SetupGridView(DataGridView grdQuery) { foreach (DataGridViewColumn dd in grdQuery.Columns) { DataGridViewColumnHeaderCheckBoxCell cb = new DataGridViewColumnHeaderCheckBoxCell(); cb.CheckBoxAlignment = HorizontalAlignment.Left; cb.Checked = true; dd.HeaderCell = cb; } }
public override object Clone() { DataGridViewColumnHeaderCheckBoxCell cell = base.Clone() as DataGridViewColumnHeaderCheckBoxCell; if (cell != null) { cell.Checked = this.Checked; } return(cell); }
internal static ReportItemCollection ExtractSelectedItems(ReportItemCollection sourceItems, DataGridViewColumn[] displayCols) { var 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); } } return(destItems); }
private void SetupGrid() { 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; } }
/* * 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; }
// only checked columns are use in the report private ReportItemCollection CreateItemsCollection(DataGridViewColumn[] displayCols) { ReportItemCollection items = new ReportItemCollection(); foreach (DataGridViewColumn cc in displayCols) { DataGridViewColumnHeaderCheckBoxCell hc = (DataGridViewColumnHeaderCheckBoxCell)cc.HeaderCell; if (hc.Checked) { AbstractColumn ac = this.abstractColumns.Find(cc.HeaderText); ICSharpCode.Reports.Core.BaseDataItem br = new ICSharpCode.Reports.Core.BaseDataItem(); br.Name = ac.ColumnName; br.ColumnName = ac.ColumnName; br.DataType = ac.DataTypeName; br.DBValue = ac.ColumnName; items.Add(br); } } return(items); }
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.AvailableFieldsCollection(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; }
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); }
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; }