public void Collection_Contains_Subclass() { var modifyedCollection = this.ModifyCollection(); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(modifyedCollection, new ReportSettings()); IDataNavigator dn = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem() { ColumnName = "DummyClass.DummyString" } ); searchCol.Add(new BaseDataItem() { Name = "GroupItem", ColumnName = "GroupItem" } ); dn.Reset(); dn.MoveNext(); while (dn.MoveNext()) { dn.Fill(searchCol); var a = (BaseDataItem)searchCol[0]; var b = (BaseDataItem)searchCol[1]; var c = modifyedCollection[dn.CurrentRow]; Assert.AreEqual(a.DBValue, c.DummyClass.DummyString); Assert.AreEqual(b.DBValue, c.GroupItem); } }
public void CollectionContainsSubclass() { var modifyedCollection = this.ModifyCollection(); GroupColumn gc = new GroupColumn("GroupItem", 1, ListSortDirection.Ascending); ReportSettings rs = new ReportSettings(); rs.GroupColumnsCollection.Add(gc); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(modifyedCollection, rs); IDataNavigator dataNavigator = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem() { ColumnName = "DummyClass.DummyString" } ); searchCol.Add(new BaseDataItem() { Name = "Last", ColumnName = "Last" } ); searchCol.Add(new BaseDataItem() { ColumnName = "GroupItem" } ); string compare = string.Empty; while (dataNavigator.MoveNext()) { dataNavigator.Fill(searchCol); var b1 = (BaseDataItem)searchCol[2]; var result = b1.DBValue; Assert.That(compare, Is.LessThan(result)); if (dataNavigator.HasChildren) { var childNavigator = dataNavigator.GetChildNavigator; do { childNavigator.Fill(searchCol); var itemDummy = (BaseDataItem)searchCol[0]; var itemLast = (BaseDataItem)searchCol[1]; var itemGroup = (BaseDataItem)searchCol[2]; Console.WriteLine("\t{0} - {1} - {2}", itemDummy.DBValue, itemLast.DBValue, itemGroup.DBValue); Assert.That(itemDummy.DBValue, Is.Not.Empty); Assert.That(itemLast.DBValue, Is.Not.Empty); Assert.That(itemGroup.DBValue, Is.Not.Empty); }while (childNavigator.MoveNext()); } compare = result; } }
public void SortChildrenDescending() { ReportSettings rs = new ReportSettings(); GroupColumn gc = new GroupColumn("GroupItem", 1, ListSortDirection.Ascending); rs.GroupColumnsCollection.Add(gc); SortColumn sc = new SortColumn("Last", ListSortDirection.Descending); rs.SortColumnsCollection.Add(sc); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.contributorCollection, rs); var dataNavigator = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem() { Name = "Last", ColumnName = "Last" } ); searchCol.Add(new BaseDataItem() { ColumnName = "GroupItem" } ); string compare = String.Empty; while (dataNavigator.MoveNext()) { dataNavigator.Fill(searchCol); var column = (BaseDataItem)searchCol[1]; var result = column.DBValue.ToString(); Assert.That(compare, Is.LessThan(result)); if (dataNavigator.HasChildren) { string compareChild = String.Empty; var childNavigator = dataNavigator.GetChildNavigator; do { childNavigator.Fill(searchCol); var childColumn = (BaseDataItem)searchCol[0]; var childResult = childColumn.DBValue.ToString(); // Console.WriteLine("\t{0}",childResult); if (!String.IsNullOrEmpty(compareChild)) { Assert.LessOrEqual(childResult, compareChild); } compareChild = childResult; }while (childNavigator.MoveNext()); } } }
private ReportItemCollection PlainCollection() { ReportItemCollection ri = new ReportItemCollection(); BaseTextItem t1 = new BaseTextItem(); t1.Name = "t1"; ri.Add(t1); t1 = new BaseTextItem(); t1.Name = "t2"; ri.Add(t1); t1 = new BaseTextItem(); t1.Name = "t3"; ri.Add(t1); return(ri); }
public void DateTimeCan_FillChild() { var dataNavigator = PrepareDateTimeGrouping(); ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem() { Name = "RandomDate", ColumnName = "Last" } ); var compare = System.DateTime.MinValue; while (dataNavigator.MoveNext()) { Contributor groupResult = dataNavigator.Current as Contributor; Assert.LessOrEqual(compare, groupResult.RandomDate); if (dataNavigator.HasChildren) { var childNavigator = dataNavigator.GetChildNavigator; do { Assert.That(dataNavigator.HasChildren, Is.True); // we know that current is a 'contributor' Contributor c = dataNavigator.Current as Contributor; Assert.IsNotNull(c); // string v2 = c.Last + " GroupVal :" + c.RandomDate; // Console.WriteLine(v2); }while (childNavigator.MoveNext()); } } }
public void Convert_SimpleItems_Should_Calculate_Correct_Locations() { ReportItemCollection ri = new ReportItemCollection(); Point itemLocation = new Point(10, 10); BaseReportItem r = new BaseTextItem() { Location = itemLocation, Size = new Size(20, 100) }; ri.Add(r); Point offset = new Point(20, 20); Rectangle parentRectangle = new Rectangle(50, 50, 700, 50); Sut.ParentRectangle = parentRectangle; ExporterCollection ec = Sut.ConvertSimpleItems(offset, ri); BaseExportColumn be = ec[0]; // this.ParentRectangle.Location.X + lineItem.StyleDecorator.Location.X, // lineItem.StyleDecorator.Location.Y + offset.Y); Point resultLocation = new Point(parentRectangle.Location.X + itemLocation.X, itemLocation.Y + offset.Y); Assert.AreEqual(resultLocation, be.StyleDecorator.Location); }
public void NullValue_In_Property_Should_Return_EmptyString() { ContributorsList contributorsList = new ContributorsList(); var contColl = contributorsList.ContributorCollection; foreach (Contributor element in contColl) { element.GroupItem = null; } IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(contColl, new ReportSettings()); IDataNavigator dataNav = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem() { Name = "GroupItem", ColumnName = "GroupItem" } ); dataNav.Reset(); dataNav.MoveNext(); do { dataNav.Fill(searchCol); BaseDataItem resultItem = searchCol[0] as BaseDataItem; Assert.That(resultItem.Name, Is.EqualTo("GroupItem")); Assert.That(resultItem.DBValue, Is.EqualTo(String.Empty)); }while (dataNav.MoveNext()); }
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 ReportItemCollection DataItemsFromDataSet(DataSet dataSet) { if (dataSet == null) { throw new ArgumentNullException("dataSet"); } if (dataSet.Tables.Count > 1) { string s = String.Format(System.Globalization.CultureInfo.InvariantCulture, "AutoBuildFromDataSet : at this time no more than one table is allowed <{0}>", dataSet.Tables.Count); ICSharpCode.Core.MessageService.ShowError(s); } ReportItemCollection itemCol = new ReportItemCollection(); foreach (DataTable tbl in dataSet.Tables) { foreach (DataColumn col in tbl.Columns) { if (col.DataType == typeof(System.Byte[])) { ICSharpCode.Reports.Core.BaseImageItem rItem = new ICSharpCode.Reports.Core.BaseImageItem(); rItem.ColumnName = col.ColumnName; rItem.BaseTableName = tbl.TableName; rItem.Name = col.ColumnName; rItem.ScaleImageToSize = false; itemCol.Add(rItem); } else { ICSharpCode.Reports.Core.BaseDataItem rItem = new ICSharpCode.Reports.Core.BaseDataItem(); rItem.ColumnName = col.ColumnName; rItem.DBValue = col.ColumnName; rItem.BaseTableName = tbl.TableName; rItem.DataType = col.DataType.ToString(); rItem.Name = col.ColumnName; rItem.Text = "=[" + col.ColumnName + "]"; itemCol.Add(rItem); } } } return(itemCol); }
public void Add() { var addView = new AddReportItemView(); if (addView.ShowDialog() == true) { _lookup.Add(addView.NewItem); _viewModel.Collection.Add(addView.NewItem); } }
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; }
public void FillCollection() { var dataNavigator = PrepareStringGrouping(); ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem () { Name ="Last", ColumnName ="Last" } ); searchCol.Add(new BaseDataItem () { ColumnName ="GroupItem" } ); dataNavigator.Reset(); dataNavigator.MoveNext(); do { if (dataNavigator.HasChildren) { dataNavigator.Fill(searchCol); var b = (BaseDataItem)searchCol[1]; // Console.WriteLine("-- <{0}>-",b.DBValue); var childNavigator = dataNavigator.GetChildNavigator; do { childNavigator.Fill(searchCol); var filledItem = (BaseDataItem)searchCol[0]; Assert.That(filledItem.DBValue,Is.Not.Empty); } while (childNavigator.MoveNext()); } } while (dataNavigator.MoveNext()); }
internal static ReportItemCollection CollectAll() { var dataTable = DatabaseController.ExecuteSelectQuery("SELECT * FROM " + TableName); var collection = new ReportItemCollection(); foreach (DataRow dataRow in dataTable.Rows) { var item = new ReportItem(); item.SetPropertiesFromDataRow(dataRow); collection.Add(item); } return(collection); }
internal static ReportItemCollection ReportItemCollection (DataSet dataSet) { if (dataSet == null) { throw new ArgumentNullException("dataSet"); } if (dataSet.Tables.Count > 1) { string s = String.Format(System.Globalization.CultureInfo.InvariantCulture, "AutoBuildFromDataSet : at this time no more than one table is allowed <{0}>",dataSet.Tables.Count); ICSharpCode.Core.MessageService.ShowError(s); } ReportItemCollection itemCol = new ReportItemCollection(); foreach (DataTable tbl in dataSet.Tables) { foreach (DataColumn col in tbl.Columns) { if (col.DataType == typeof(System.Byte[])) { ICSharpCode.Reports.Core.BaseImageItem rItem = new ICSharpCode.Reports.Core.BaseImageItem(); rItem.ColumnName = col.ColumnName; rItem.BaseTableName = tbl.TableName; rItem.Name = col.ColumnName; rItem.ScaleImageToSize = false; itemCol.Add (rItem); } else { ICSharpCode.Reports.Core.BaseDataItem rItem = new ICSharpCode.Reports.Core.BaseDataItem(); rItem.ColumnName = col.ColumnName; rItem.DBValue = col.ColumnName; rItem.BaseTableName = tbl.TableName; rItem.DataType = col.DataType.ToString(); rItem.Name = col.ColumnName; rItem.Text = "=[" + col.ColumnName + "]"; itemCol.Add (rItem); } } } return itemCol; }
public void DataNavigator_Return_ErrMessage_If_ColumnName_NotExist() { IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.contributorCollection as System.Collections.IList, new ReportSettings()); IDataNavigator dataNav = dm.GetNavigator; BaseDataItem item = new BaseDataItem(); item.ColumnName = "ColumnNotExist"; var items = new ReportItemCollection(); items.Add(item); dataNav.Fill(items); string str = "<" + item.ColumnName + ">"; Assert.That(item.DBValue.Contains(str)); }
public void FillCollection() { var dataNavigator = PrepareStringGrouping(); ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem() { Name = "Last", ColumnName = "Last" } ); searchCol.Add(new BaseDataItem() { ColumnName = "GroupItem" } ); dataNavigator.Reset(); dataNavigator.MoveNext(); do { if (dataNavigator.HasChildren) { dataNavigator.Fill(searchCol); var b = (BaseDataItem)searchCol[1]; // Console.WriteLine("-- <{0}>-",b.DBValue); var childNavigator = dataNavigator.GetChildNavigator; do { childNavigator.Fill(searchCol); var filledItem = (BaseDataItem)searchCol[0]; Assert.That(filledItem.DBValue, Is.Not.Empty); }while (childNavigator.MoveNext()); } }while (dataNavigator.MoveNext()); }
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); }
protected ReportItemCollection AddItemsToContainer() { int locationX = GlobalValues.ControlMargins.Left; var minCtrlWidth = CalculateControlWidth(Container, ReportItems); var col = new ReportItemCollection(); foreach (var ir in ReportItems) { ir.Location = new Point(locationX, GlobalValues.ControlMargins.Top); col.Add(ir); locationX += minCtrlWidth; } return(col); }
public override void DeserializeChildren(PersistenceReader ip) { while (ip.HasChild) { PersistableObject child = ip.GetChild(); if (child is ReportColumn) { m_Columns.Add((ReportColumn)child); } else if (child is ReportItem) { m_Items.Add((ReportItem)child); } } }
public void Convert_SimpleItems_Should_Return_Valid_Collection() { ReportItemCollection ri = new ReportItemCollection(); BaseReportItem r = new BaseTextItem() { Location = new Point(10, 10), Size = new Size(20, 100) }; ri.Add(r); IExportItemsConverter sut = new ExportItemsConverter(); ExporterCollection ec = sut.ConvertSimpleItems(new Point(10, 10), ri); Assert.IsNotNull(ec); Assert.AreEqual(1, ec.Count); }
// 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); }
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); }
internal static ReportItemCollection GetListByCategory(string category) { var sqlBuilder = new System.Text.StringBuilder(); sqlBuilder.AppendLine("SELECT * FROM"); sqlBuilder.AppendLine(TableName); sqlBuilder.AppendLine("WHERE Category = ?Category"); var param = new SqlParameter("?Category", category); DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder, param); var collection = new ReportItemCollection(); foreach (DataRow dataRow in dataTable.Rows) { var item = new ReportItem(); item.SetPropertiesFromDataRow(dataRow); collection.Add(item); } return(collection); }
/// <summary> /// /// </summary> /// <returns></returns> virtual public ReportItemCollection GetReportItems() { ReportItemCollection reportItems = new ReportItemCollection(); AttributePropertyInfoPairCollection attPropertyInfos = this.GetDeviceDataItemAttributes(); foreach (AttributePropertyInfoPair item in attPropertyInfos) { DataItemAttribute att = item.Attribute; PropertyInfo pi = item.PropertyInfo; object value = pi.GetValue(this, null); //if (!this.HideDataAttributeNames.Contains(att.Name)) if (!HideDataAttributeNameManager.Default.Contains(this.GetType().Name, att.Name)) { ReportItem reportItem = new ReportItem(att.Name, value, att.Unit, att.Format); reportItems.Add(reportItem); } } return(reportItems); }
public void SubPropertyName_Is_Wrong() { var modifyedCollection = this.ModifyCollection(); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(modifyedCollection, new ReportSettings()); IDataNavigator dn = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem() { Name = "GroupItem", ColumnName = "DummyClass.Wrong", DataType = "System.Int32" } ); dn.Reset(); dn.MoveNext(); while (dn.MoveNext()) { dn.Fill(searchCol); var a = (BaseDataItem)searchCol[0]; Assert.That(a.DBValue.StartsWith("Error")); } }
public void Expression_In_Text_Evaluate() { ReportSettings rs = new ReportSettings(); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.table, rs); DataNavigator dataNav = dm.GetNavigator; BaseDataItem bdi = new BaseDataItem() { Name = "MyDataItem", ColumnName = "last", Text = "=Substring(Fields!last,0,3)", Expression = "=Substring(Fields!last,0,3)" }; var ri = new ReportItemCollection(); ri.Add(bdi); while (dataNav.MoveNext()) { dataNav.Fill(ri); DataRow r = dataNav.Current as DataRow; string actual = r["last"].ToString(); Assert.That(actual.Substring(0, 3), Is.EqualTo(bdi.DBValue)); } }
// 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; }
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; }
private ReportItemCollection PlainCollection() { ReportItemCollection ri = new ReportItemCollection(); BaseTextItem t1 = new BaseTextItem(); t1.Name = "t1"; ri.Add(t1); t1 = new BaseTextItem(); t1.Name = "t2"; ri.Add(t1); t1 = new BaseTextItem(); t1.Name = "t3"; ri.Add(t1); return ri; }
public void DateTimeCan_FillChild() { var dataNavigator = PrepareDateTimeGrouping(); ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem () { Name ="RandomDate", ColumnName ="Last" } ); var compare = System.DateTime.MinValue; while (dataNavigator.MoveNext()) { Contributor groupResult = dataNavigator.Current as Contributor; Assert.LessOrEqual(compare,groupResult.RandomDate); if (dataNavigator.HasChildren) { var childNavigator = dataNavigator.GetChildNavigator; do { Assert.That(dataNavigator.HasChildren,Is.True); // we know that current is a 'contributor' Contributor c = dataNavigator.Current as Contributor; Assert.IsNotNull(c); // string v2 = c.Last + " GroupVal :" + c.RandomDate; // Console.WriteLine(v2); } while (childNavigator.MoveNext()); } } }
public void Collection_Contains_Subclass () { var modifyedCollection = this.ModifyCollection(); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(modifyedCollection,new ReportSettings()); IDataNavigator dn = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem () { ColumnName ="DummyClass.DummyString" } ); searchCol.Add(new BaseDataItem () { Name ="GroupItem", ColumnName ="GroupItem" } ); dn.Reset(); dn.MoveNext(); while (dn.MoveNext()) { dn.Fill(searchCol); var a = (BaseDataItem)searchCol[0]; var b = (BaseDataItem)searchCol[1]; var c = modifyedCollection[dn.CurrentRow]; Assert.AreEqual(a.DBValue,c.DummyClass.DummyString); Assert.AreEqual(b.DBValue,c.GroupItem); } }
public void NullValue_In_Property_Should_Return_EmptyString () { ContributorsList contributorsList = new ContributorsList(); var contColl = contributorsList.ContributorCollection; foreach (Contributor element in contColl) { element.GroupItem = null; } IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(contColl, new ReportSettings()); IDataNavigator dataNav = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem () { Name ="GroupItem", ColumnName ="GroupItem" } ); dataNav.Reset(); dataNav.MoveNext(); do { dataNav.Fill(searchCol); BaseDataItem resultItem = searchCol[0] as BaseDataItem; Assert.That (resultItem.Name,Is.EqualTo("GroupItem")); Assert.That(resultItem.DBValue,Is.EqualTo(String.Empty)); } while (dataNav.MoveNext()); }
private void SaveItem(ReportItemCollection items, string name) { Control container = this.report.MultiView; if (this.report.ItemIndexTable.Contains(name) && !this.report.ItemIndexTable[name].Equals(Guid.Empty)) { Guid id = (Guid)this.report.ItemIndexTable[name]; SaveItem(name, id); } items.Clear(); ListBox listboxItem = (ListBox)container.FindControl(string.Format("{0}{1}", LISTBOX_ITEM, name)); foreach (ListItem li in listboxItem.Items) { Guid id = new Guid(li.Value); byte[] value = (byte[])report.ItemTable[id]; ReportItem reportItem = (ReportItem)XmlConverter.ConvertTo(value); items.Add(reportItem); } }
public void SubPropertyName_Is_Wrong () { var modifyedCollection = this.ModifyCollection(); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(modifyedCollection,new ReportSettings()); IDataNavigator dn = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem () { Name ="GroupItem", ColumnName ="DummyClass.Wrong", DataType = "System.Int32" } ); dn.Reset(); dn.MoveNext(); while (dn.MoveNext()) { dn.Fill(searchCol); var a = (BaseDataItem)searchCol[0]; Assert.That(a.DBValue.StartsWith("Error")); } }
/// <summary> /// /// </summary> /// <returns></returns> public virtual ReportItemCollection GetReportItems() { ReportItemCollection reportItems = new ReportItemCollection(); AttributePropertyInfoPairCollection attPropertyInfos = this.GetDeviceDataItemAttributes(); foreach (AttributePropertyInfoPair item in attPropertyInfos) { DataItemAttribute att = item.Attribute; PropertyInfo pi = item.PropertyInfo; object value = pi.GetValue(this, null); ReportItem reportItem = new ReportItem(att.Name, value, att.Unit, att.Format); reportItems.Add(reportItem); } return reportItems; }
public void Expression_In_Text_Evaluate() { ReportSettings rs = new ReportSettings(); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.table,rs); DataNavigator dataNav = dm.GetNavigator; BaseDataItem bdi = new BaseDataItem(){ Name ="MyDataItem", ColumnName = "last", Text ="=Substring(Fields!last,0,3)", Expression ="=Substring(Fields!last,0,3)" }; var ri = new ReportItemCollection(); ri.Add(bdi); while (dataNav.MoveNext()) { dataNav.Fill(ri); DataRow r = dataNav.Current as DataRow; string actual = r["last"].ToString(); Assert.That(actual.Substring(0,3), Is.EqualTo(bdi.DBValue)); } }
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 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; }
public void SortChildrenDescending() { ReportSettings rs = new ReportSettings(); GroupColumn gc = new GroupColumn("GroupItem",1,ListSortDirection.Ascending); rs.GroupColumnsCollection.Add(gc); SortColumn sc = new SortColumn("Last",ListSortDirection.Descending); rs.SortColumnsCollection.Add(sc); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.contributorCollection,rs); var dataNavigator = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem () { Name ="Last", ColumnName ="Last" } ); searchCol.Add(new BaseDataItem () { ColumnName ="GroupItem" } ); string compare = String.Empty; while (dataNavigator.MoveNext()) { dataNavigator.Fill(searchCol); var column = (BaseDataItem)searchCol[1]; var result = column.DBValue.ToString(); Assert.That (compare,Is.LessThan(result)); if (dataNavigator.HasChildren) { string compareChild = String.Empty; var childNavigator = dataNavigator.GetChildNavigator; do { childNavigator.Fill(searchCol); var childColumn = (BaseDataItem)searchCol[0]; var childResult = childColumn.DBValue.ToString(); // Console.WriteLine("\t{0}",childResult); if (!String.IsNullOrEmpty(compareChild)) { Assert.LessOrEqual(childResult,compareChild); } compareChild = childResult; } while (childNavigator.MoveNext()); } } }
protected ReportItemCollection AddItemsToContainer (ReportItemCollection items) { int locationX = GlobalValues.ControlMargins.Left; var minCtrlWidth = CalculateControlWidth(ParentItem,items); var col = new ReportItemCollection(); foreach (var ir in items) { ir.Location = new Point(locationX,GlobalValues.ControlMargins.Top); col.Add(ir); locationX += minCtrlWidth; } return col; }
public void DataNavigator_Return_ErrMessage_If_ColumnName_NotExist () { IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(this.contributorCollection as System.Collections.IList,new ReportSettings()); IDataNavigator dataNav = dm.GetNavigator; BaseDataItem item = new BaseDataItem(); item.ColumnName = "ColumnNotExist"; var items = new ReportItemCollection(); items.Add(item); dataNav.Fill(items); string str = "<" + item.ColumnName +">"; Assert.That(item.DBValue.Contains(str)); }
public void CollectionContainsSubclass () { var modifyedCollection = this.ModifyCollection(); GroupColumn gc = new GroupColumn("GroupItem",1,ListSortDirection.Ascending); ReportSettings rs = new ReportSettings(); rs.GroupColumnsCollection.Add(gc); IDataManager dm = ICSharpCode.Reports.Core.DataManager.CreateInstance(modifyedCollection,rs); IDataNavigator dataNavigator = dm.GetNavigator; ReportItemCollection searchCol = new ReportItemCollection(); searchCol.Add(new BaseDataItem () { ColumnName ="DummyClass.DummyString" } ); searchCol.Add(new BaseDataItem () { Name ="Last", ColumnName ="Last" } ); searchCol.Add(new BaseDataItem () { ColumnName ="GroupItem" } ); string compare = string.Empty; while (dataNavigator.MoveNext()) { dataNavigator.Fill(searchCol); var b1 = (BaseDataItem)searchCol[2]; var result = b1.DBValue; Assert.That (compare,Is.LessThan(result)); if (dataNavigator.HasChildren) { var childNavigator = dataNavigator.GetChildNavigator; do { childNavigator.Fill(searchCol); var itemDummy = (BaseDataItem)searchCol[0]; var itemLast = (BaseDataItem)searchCol[1]; var itemGroup = (BaseDataItem)searchCol[2]; Console.WriteLine ("\t{0} - {1} - {2}",itemDummy.DBValue,itemLast.DBValue,itemGroup.DBValue); Assert.That(itemDummy.DBValue,Is.Not.Empty); Assert.That(itemLast.DBValue,Is.Not.Empty); Assert.That(itemGroup.DBValue,Is.Not.Empty); } while (childNavigator.MoveNext()); } compare = result; } }