private string CalculateMyPreviewText(int rowHandle)
{
if (rowHandle == int.MinValue || rowHandle == -2147483646)
{
return(string.Empty);
}
int dataSourceRowIndex = this.gridView1.GetDataSourceRowIndex(rowHandle);
BindingList <ColumnQN> dsList = this.gridView1.DataSource as BindingList <ColumnQN>;
if (dsList == null)
{
return(string.Empty);
}
ColumnQN col = dsList[rowHandle];
if (string.IsNullOrEmpty(col.Remarks))
{
return($"{col}");
}
return(col.Remarks);
}
} // buildBindingList(...)
private void TreatField(MetadataItem mdi)
{
MetadataField mdf = mdi as MetadataField;
if (mdf == null)
{
return;
}
//
ColumnQN colQN = new ColumnQN();
colQN.IsSystem = mdi.System;
colQN.IsDefault = mdi.Default;
colQN.ObjectType = Enum.GetName(typeof(MetadataType), mdi.Type);
if (mdi.Parent != null)
{
colQN.ParentType = Enum.GetName(typeof(MetadataType), mdi.Parent.Type);
}
colQN.Remarks = mdf.Description;
#region --- Server.Database.Schema.Object.Column Names ---
if (mdf.Server != null)
{
MetadataNamespace srv = mdf.Server;
colQN.ServerAltName = srv.AltName;
colQN.ServerName = srv.Name;
colQN.ServerNameFull = srv.NameFull;
colQN.ServerNameQuoted = srv.NameQuoted;
}
if (mdf.Database != null)
{
MetadataNamespace database = mdf.Database;
colQN.DatabaseAltName = database.AltName;
colQN.DatabaseName = database.Name;
colQN.DatabaseNameFull = database.NameFull;
colQN.DatabaseNameQuoted = database.NameQuoted;
}
if (mdf.Schema != null)
{
MetadataNamespace schema = mdf.Schema;
colQN.SchemaAltName = schema.AltName;
colQN.SchemaName = schema.Name;
colQN.SchemaNameFull = schema.NameFull;
colQN.SchemaNameQuoted = schema.NameQuoted;
}
if (mdf.Object != null)
{
MetadataObject obj = mdf.Object;
colQN.ParentAltName = obj.AltName;
colQN.ParentName = obj.Name;
colQN.ParentNameFull = obj.NameFull;
colQN.ParentNameQuoted = obj.NameQuoted;
}
{
colQN.AltName = mdf.AltName;
colQN.Name = mdf.Name;
colQN.NameFull = mdf.NameFull;
colQN.NameQuoted = mdf.NameQuoted;
}
#endregion
string idescription = mdi.Description;
object itag = mdi.Tag;
string iuserData = mdi.UserData;
MetadataNamespace package = mdf.Package;
//string writeXMLNode = WriteXMLNode(mdf);
//
{
colQN.DatabaseTypeName = mdf.FieldTypeName;
colQN.StorageTypeName = Enum.GetName(typeof(DbType), mdf.FieldType);
colQN.Size = mdf.Size;
colQN.Precision = mdf.Precision;
colQN.Scale = mdf.Scale;
colQN.IsPrimaryKey = mdf.PrimaryKey;
colQN.IsNullable = mdf.Nullable;
colQN.IsReadOnly = mdf.ReadOnly;
{
colQN.IsVirtual = mdf.IsVirtual();
colQN.Expression = mdf.Expression;
}
// string writeXMLNode = WriteXMLNode(mdf);
}
//
// colQN.Serialize(@"D:\TEMP\CS\QWERTY.XML");
//
this._colQnBindingList.Add(colQN);
}
