/// <summary>
/// InitializeMapForDev
/// </summary>
/// <param name="dm"></param>
void InitializeMapForDev(DataTableMapMsx dm)
{
QueryTable qt = null;
QueryColumn qc = null;
string alias = "";
string colName = "";
if (dm.ColumnMapCollection != null && dm.ColumnMapCollection.Count > 0)
{
return;
}
dm.ColumnMapCollection = new ColumnMapCollection();
DataTableMsx dt = SVP.Doc.DataManager.TableCollection[0];
dm.SpotfireDataTable = dt;
foreach (DataColumnMsx dc in dt.Columns)
{
colName = dc.Name;
int i1 = colName.IndexOf(".");
if (i1 <= 0 || i1 + 1 >= colName.Length) // name without alias
{
alias = "T1";
}
else
{
alias = colName.Substring(0, i1);
colName = colName.Substring(i1 + 1);
}
int qti = Query.GetQueryTableIndexByAlias(alias);
if (qti < 0)
{
continue;
}
qt = Query.Tables[qti];
qc = qt.GetQueryColumnByLabel(colName);
if (qc == null)
{
continue;
}
ColumnMapMsx cm = new ColumnMapMsx();
cm.QueryColumn = qc;
cm.SpotfireColumn = dc;
cm.SpotfireColumnName = dc.Name;
cm.Role = dc.Name;
dm.ColumnMapCollection.Add(cm);
}
return;
}