internal bool GetJoin(Join_for_SQLView_InDataBase join, ref Join_for_SQLView_InDataBase refJoin)
{
foreach (Join_for_SQLView_InDataBase j in items)
{
if (j.TableName.Equals(join.TableName))
{
refJoin = j;
return true;
}
}
return false;
}
private void GetJoins(Column.nullTYPE nulltype, SQLTable pParentTable, string PreAliasTableName, string pParentTable_alias_table_name)
{
string alias_table_name = PreAliasTableName + SQLTable.VIEW_TableName_SEPARATOR + this.TableName_Abbreviation;
Join_for_SQLView_InDataBase join = new Join_for_SQLView_InDataBase(null, TableName,TableName_Abbreviation, alias_table_name, PreAliasTableName + "." + this.TableName + "_ID", alias_table_name + ".ID", nulltype);
Join_for_SQLView_InDataBase RefJoin = null;
join.tbl = this;
pParentTable.jList.items.Add(join);
foreach (Column col in Column)
{
if (!col.IsIdentity)
{
if (col.fKey != null)
{
if (col.fKey.fTable != null)
{
col.fKey.fTable.GetJoins(col.nulltype, this, alias_table_name, PreAliasTableName);
}
}
}
}
}