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