public void PlainConstructor() { AbstractColumn ab = new AbstractColumn(); Assert.AreEqual(typeof(string), ab.DataType); Assert.AreEqual(String.Empty, ab.ColumnName); }
/// <summary> /// Compile a single column clause /// </summary> /// <param name="context"></param> /// <param name="column"></param> /// <returns></returns> public virtual string CompileColumn(SqlResult context, AbstractColumn column) { if (column is RawColumn raw) { context.Bindings.AddRange(raw.Bindings); return(wrapper.WrapIdentifiers(raw.Expression)); } if (column is QueryColumn queryColumn) { string alias = ""; if (!string.IsNullOrWhiteSpace(queryColumn.Query.QueryAlias)) { alias = $" {wrapper.ColumnAsKeyword}{wrapper.WrapValue(queryColumn.Query.QueryAlias)}"; } SqlResult subContext = CompileSelectQuery(queryColumn.Query); context.Bindings.AddRange(subContext.Bindings); return("(" + subContext.RawSql + $"){alias}"); } return(wrapper.Wrap((column as Column).Name)); }
public void FindWithNameNotExist() { ColumnCollection cc = new ColumnCollection(); AbstractColumn c = cc.Find("noexist"); Assert.IsNull(c, "Column should be 'null'"); }
public void SetDataTypeName() { string dtn = "System.Int32"; AbstractColumn ab = new AbstractColumn(); ab.DataTypeName = dtn; Assert.AreEqual(typeof(int),ab.DataType); }
public void SetColumnName() { string cn = "AbstractColumn"; AbstractColumn ab = new AbstractColumn(); ab.ColumnName = cn; Assert.AreEqual(cn,ab.ColumnName); }
public void SetDataType() { AbstractColumn ab = new AbstractColumn(); ab.DataType = typeof(int); Assert.AreEqual(typeof(int), ab.DataType); }
public void ConstructorColumnNameAndType() { string cn = "AbstractColumn"; AbstractColumn ab = new AbstractColumn(cn,typeof(int)); Assert.AreEqual(typeof(int),ab.DataType); Assert.AreEqual(cn,ab.ColumnName); }
public void PlainCollectionFind() { this.itemCollection = this.PlainCollection(); AbstractColumn r = itemCollection.Find("t2"); Assert.AreEqual("t2", r.ColumnName); }
public void GetDataTypeName() { AbstractColumn ab = new AbstractColumn(); ab.DataType = typeof(int); Assert.AreEqual("System.Int32", ab.DataTypeName); }
public void FindKeyNotExist() { this.itemCollection = this.PlainCollection(); AbstractColumn r = itemCollection.Find("t5"); Assert.IsNull(r); }
private void CreateRelationColumns(IRelation relation) { EntityInfo relationInfo = CacheManager.GetEntityInfo(relation.RelatedObjectType); while (relationInfo != null) { ICollection <IColumn> relationKeys = relationInfo.GetKeys(); foreach (IColumn relationKey in relationKeys) { RelationColumnMapping matchingMapping = null; foreach (RelationColumnMapping mapping in relation.TableColumnMappings) { if (mapping.ToField.Equals(relationKey.AttributeName, StringComparison.InvariantCultureIgnoreCase)) { matchingMapping = mapping; break; } } IColumn cloned = relationKey.Clone(); cloned.Key = false; if (matchingMapping != null) { cloned.AttributeName = matchingMapping.FromField; cloned.ColumnName = AbstractColumn.PredictColumnName(matchingMapping.FromField); } cloned.Nullable = relation.Nullable; _columns.Add(cloned); _relationColumnInfoList.Add(new EntityRelationColumnInfo(cloned, relation, matchingMapping)); } relationInfo = relationInfo.SuperEntityInfo; } }
/// <summary> /// Compile a single column clause /// </summary> /// <param name="ctx"></param> /// <param name="column"></param> /// <returns></returns> public virtual string CompileColumn(SqlResult ctx, AbstractColumn column) { if (column is RawColumn raw) { ctx.Bindings.AddRange(raw.Bindings); return(WrapIdentifiers(raw.Expression)); } if (column is QueryColumn queryColumn) { var alias = ""; if (!string.IsNullOrWhiteSpace(queryColumn.Query.QueryAlias)) { alias = $" {ColumnAsKeyword}{WrapValue(queryColumn.Query.QueryAlias)}"; } var subCtx = CompileSelectQuery(queryColumn.Query); ctx.Bindings.AddRange(subCtx.Bindings); return("(" + subCtx.RawSql + $"){alias}"); } return(Wrap((column as Column).Name)); }
public void SetColumnName() { string cn = "AbstractColumn"; AbstractColumn ab = new AbstractColumn(); ab.ColumnName = cn; Assert.AreEqual(cn, ab.ColumnName); }
private void SetAvailableFields(AbstractColumn af) { ColumnNode node = new ColumnNode(af.ColumnName, columnIcon); node.Tag = this.nodeAvailableFields; node.SelectedImageIndex = columnIcon; this.nodeAvailableFields.Nodes.Add(node); }
public void SetDataTypeName() { string dtn = "System.Int32"; AbstractColumn ab = new AbstractColumn(); ab.DataTypeName = dtn; Assert.AreEqual(typeof(int), ab.DataType); }
public void FindSecondElement() { ColumnCollection cc = CollectionWith2Columns(); AbstractColumn c = cc.Find("Column2"); Assert.IsNotNull(c, "Should not be 'null'"); Assert.That(c, Is.InstanceOf(typeof(SortColumn))); }
public void ConstructorColumnNameAndType() { string cn = "AbstractColumn"; AbstractColumn ab = new AbstractColumn(cn, typeof(int)); Assert.AreEqual(typeof(int), ab.DataType); Assert.AreEqual(cn, ab.ColumnName); }
public void FindFirstElement() { ColumnCollection cc = CollectionWith2Columns(); AbstractColumn c = cc.Find("Column1"); Assert.IsNotNull(c); Assert.That(c, Is.InstanceOf(typeof(SortColumn))); }
object ExtractColumnValue(DataRow row, ColumnCollection col, int criteriaIndex) { AbstractColumn c = (AbstractColumn)col[criteriaIndex]; object val = null; val = DBValueFromRow(row, c.ColumnName); // if (!(val is IComparable)){ // throw new InvalidOperationException(val.ToString()); // } return(val); }
private AvailableFieldsCollection AvailableFieldsCollectionFromTable(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); }
private AvailableFieldsCollection PlainCollection() { AvailableFieldsCollection ri = new AvailableFieldsCollection(); AbstractColumn t1 = new AbstractColumn(); t1.ColumnName = "t1"; ri.Add(t1); t1 = new AbstractColumn(); t1.ColumnName = "t2"; ri.Add(t1); t1 = new AbstractColumn(); t1.ColumnName = "t3"; ri.Add(t1); return ri; }
public void RemoveGroupNode() { if (this.SelectedNode != null) { AbstractColumn abstr = this.reportModel.ReportSettings.GroupColumnsCollection.Find(this.SelectedNode.Text); if (abstr != null) { this.reportModel.ReportSettings.GroupColumnsCollection.Remove(abstr as GroupColumn); TreeNode parent = this.SelectedNode.Parent; this.SelectedNode.Remove(); this.SelectedNode = parent; this.OnPropertyChanged("RemoveGroupNode"); } } }
private AvailableFieldsCollection PlainCollection() { AvailableFieldsCollection ri = new AvailableFieldsCollection(); AbstractColumn t1 = new AbstractColumn(); t1.ColumnName = "t1"; ri.Add(t1); t1 = new AbstractColumn(); t1.ColumnName = "t2"; ri.Add(t1); t1 = new AbstractColumn(); t1.ColumnName = "t3"; ri.Add(t1); return(ri); }
/// <summary> /// Compile a single column clause /// </summary> /// <param name="columns"></param> /// <returns></returns> public string CompileColumn(AbstractColumn column) { if (column is RawColumn rawColumn) { return(WrapIdentifiers(rawColumn.Expression)); } if (column is QueryColumn queryColumn) { var alias = string.IsNullOrWhiteSpace(queryColumn.Query.QueryAlias) ? "" : $" AS {WrapValue(queryColumn.Query.QueryAlias)}"; return("(" + CompileSelect(queryColumn.Query) + $"){alias}"); } return(Wrap((column as Column).Name)); }
public static ReportModel CreateModel(string reportName, bool createGrouping) { ReportStructure structure = CreateReportStructure(reportName); AvailableFieldsCollection abstractColumns = new AvailableFieldsCollection(); AbstractColumn a1 = new AbstractColumn("Field1", typeof(System.String)); structure.AvailableFieldsCollection.Add(a1); ICSharpCode.Reports.Core.BaseDataItem bri = new ICSharpCode.Reports.Core.BaseDataItem(); bri.Name = "Field1"; structure.ReportItemCollection.Add(bri); if (createGrouping) { structure.Grouping = "group"; } ReportModel m = structure.CreateAndFillReportModel(); ICSharpCode.Core.Properties customizer = new ICSharpCode.Core.Properties(); customizer.Set("Generator", structure); customizer.Set("ReportLayout", GlobalEnums.ReportLayout.ListLayout); IReportGenerator generator = new GeneratePushDataReport(m, customizer); generator.GenerateReport(); ReportLoader rl = new ReportLoader(); object root = rl.Load(generator.XmlReport.DocumentElement); ReportModel model = root as ReportModel; if (model != null) { model.ReportSettings.FileName = GlobalValues.PlainFileName; FilePathConverter.AdjustReportName(model); } else { throw new InvalidReportModelException(); } return(model); }
public PushDataReport() { InitializeComponent(); items = new List <AbstractColumn>(); _DataGrid.ItemsSource = items; this.context = new PushModelContext(); var data = new AbstractColumn("MyColumn", typeof(string)); items.Add(data); cboType.ItemsSource = GlobalLists.DataTypeList(); var definitions = GetTypeDefinitions(); if (definitions != null) { _cboTypes.Visibility = System.Windows.Visibility.Visible; _cboTypes.ItemsSource = definitions; _cboTypes.SelectedIndex = 0; } }
private void SetSortColumns(AbstractColumn column) { SortColumn sortColumn = column as SortColumn; if (sortColumn != null) { var sortColumnNode = new SortColumnNode(sortColumn.ColumnName, sortColumnMenuPath); if (sortColumn.SortDirection == ListSortDirection.Ascending) { sortColumnNode.ImageIndex = ascendingIcon; } else { sortColumnNode.ImageIndex = descendingIcon; } this.nodeSorting.Nodes.Add(sortColumnNode); } }
// 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 _pro_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { SelectedProject = (IProject)e.AddedItems[0]; var definitions = GetTypeDefinitions(); if (definitions.Any()) { _cboTypes.Visibility = System.Windows.Visibility.Visible; _availTxt.Visibility = System.Windows.Visibility.Visible; _projTxt.Visibility = System.Windows.Visibility.Visible; _cboTypes.ItemsSource = definitions; _cboTypes.SelectedIndex = 0; } else { var data = new AbstractColumn("MyColumn", typeof(string)); items.Add(data); _projTxt.Text = ResourceService.GetString("SharpReport.Wizard.PushModel.NoProject"); } }
public PushDataReport() { InitializeComponent(); items = new List <AbstractColumn>(); _DataGrid.ItemsSource = items; this.context = new PushModelContext(); cboType.ItemsSource = GlobalLists.DataTypeList(); var definitions = GetTypeDefinitions(); if (definitions.Any()) { _cboTypes.Visibility = System.Windows.Visibility.Visible; _availTxt.Visibility = System.Windows.Visibility.Visible; _cboTypes.ItemsSource = definitions; _cboTypes.SelectedIndex = 0; } else { var data = new AbstractColumn("MyColumn", typeof(string)); items.Add(data); _projTxt.Text = ResourceService.GetString("SharpReport.Wizard.PushModel.NoProject"); } }
public void PlainConstructor() { AbstractColumn ab = new AbstractColumn(); Assert.AreEqual(typeof(string),ab.DataType); Assert.AreEqual(String.Empty,ab.ColumnName); }
public void SetDataType() { AbstractColumn ab = new AbstractColumn(); ab.DataType = typeof(int); Assert.AreEqual(typeof(int),ab.DataType); }
public void GetDataTypeName() { AbstractColumn ab = new AbstractColumn(); ab.DataType = typeof(int); Assert.AreEqual("System.Int32",ab.DataTypeName); }
public void FindWithNameIsNull() { itemCollection = this.PlainCollection(); AbstractColumn r = itemCollection.Find(null); }
public void FindWithNameIsEmpty() { itemCollection = this.PlainCollection(); AbstractColumn r = itemCollection.Find(String.Empty); }
public void FindWithNameIsNull() { ColumnCollection cc = new ColumnCollection(); AbstractColumn c = cc.Find(null); }
public void FindWithNameIsEmpty() { ColumnCollection cc = new ColumnCollection(); AbstractColumn c = cc.Find(String.Empty); }