public void LoadSchema(OPS.Components.Data.Database d)
{
standardOrderByField = _standardOrderByField;
standardOrderByAsc = _standardOrderByAsc;
standardTableName = _standardTableName;
stValidDeleted.Clear();
standardFields.Clear();
standardPks.Clear();
standardRelationTables.Clear();
standardRelationFields.Clear();
standardRelationKeys.Clear();
standardRelationShowns.Clear();
standardRelationTranslate.Clear();
for (int aux = 0; aux < _stValidDeleted.Length; aux++)
{
stValidDeleted.Add(_stValidDeleted[aux]);
}
// When we have the table described in the UserSchema, we must load
// its settings for the fields/columns of the table from there.
if (d.UserSchema[standardTableName] != null)
{
ArrayList _array = (ArrayList)d.UserSchema[standardTableName];
string[] _newStandardFields = new string[_array.Count];
// Creates an enumerator and get all elements
IEnumerator myEnumerator = _array.GetEnumerator();
while (myEnumerator.MoveNext())
{
// XNA_08_10_2007
TableUserSchemaInfo currentTUSI = (TableUserSchemaInfo)myEnumerator.Current;
standardWhere = currentTUSI.Where;
IEnumerator enumTables = currentTUSI.TableFieldUserSchemaInfo.GetEnumerator();
while (enumTables.MoveNext())
{
FieldUserSchemaInfo currentFUSI = (FieldUserSchemaInfo)enumTables.Current;
if (currentFUSI.FieldVisible)
{
standardFields.Add(currentFUSI.FieldName);
if (currentFUSI.FieldPrimaryKey)
{
standardPks.Add(currentFUSI.FieldName);
standardFields.Remove(currentFUSI.FieldName);
standardFields.Insert(0, currentFUSI.FieldName);
}
if (currentFUSI.FieldRelTable.Length > 0)
{
standardRelationTables.Add(TranslateTable2Component(currentFUSI.FieldRelTable));
standardRelationFields.Add(currentFUSI.FieldName);
standardRelationKeys.Add(currentFUSI.FieldRelField);
standardRelationShowns.Add(currentFUSI.FieldRelShown);
standardRelationTranslate.Add(currentFUSI.FieldRelTranslate);
}
if (currentFUSI.FieldReadOnly)
{
m_bPKReadOnly = true;
}
else
{
m_bPKReadOnly = false;
}
}
}
// XNA_08_10_2007
}
}
// In case schema does not contain information about fields, We get standard.
else
{
for (int aux = 0; aux < _standardFields.Length; aux++)
{
standardFields.Add(_standardFields[aux]);
}
for (int aux = 0; aux < _standardPks.Length; aux++)
{
standardPks.Add(_standardPks[aux]);
}
for (int aux = 0; aux < _standardRelationFileds.Length; aux++)
{
standardRelationFields.Add(_standardRelationFileds[aux]);
}
for (int aux = 0; aux < _standardRelationTables.Length; aux++)
{
standardRelationTables.Add(_standardRelationTables[aux]);
}
}
IEnumerator mEnumerator = null;
int contador = 0;
mEnumerator = standardFields.GetEnumerator();
contador = 0;
sstandardFields = new string[standardFields.Count];
while (mEnumerator.MoveNext())
{
sstandardFields[contador] = mEnumerator.Current.ToString();
contador++;
}
mEnumerator = standardPks.GetEnumerator();
contador = 0;
sstandardPks = new string[standardPks.Count];
while (mEnumerator.MoveNext())
{
sstandardPks[contador] = mEnumerator.Current.ToString();
contador++;
}
mEnumerator = standardRelationTables.GetEnumerator();
contador = 0;
sstandardRelationTables = new string[standardRelationTables.Count];
while (mEnumerator.MoveNext())
{
sstandardRelationTables[contador] = mEnumerator.Current.ToString();
contador++;
}
mEnumerator = standardRelationFields.GetEnumerator();
contador = 0;
sstandardRelationFields = new string[standardRelationFields.Count];
while (mEnumerator.MoveNext())
{
sstandardRelationFields[contador] = mEnumerator.Current.ToString();
contador++;
}
mEnumerator = standardRelationKeys.GetEnumerator();
contador = 0;
sstandardRelationKeys = new string[standardRelationKeys.Count];
while (mEnumerator.MoveNext())
{
sstandardRelationKeys[contador] = mEnumerator.Current.ToString();
contador++;
}
mEnumerator = standardRelationShowns.GetEnumerator();
contador = 0;
sstandardRelationShowns = new string[standardRelationShowns.Count];
while (mEnumerator.MoveNext())
{
sstandardRelationShowns[contador] = mEnumerator.Current.ToString();
contador++;
}
mEnumerator = standardRelationTranslate.GetEnumerator();
contador = 0;
sstandardRelationTranslate = new bool[standardRelationTranslate.Count];
while (mEnumerator.MoveNext())
{
sstandardRelationTranslate[contador] = bool.Parse(mEnumerator.Current.ToString());
contador++;
}
mEnumerator = stValidDeleted.GetEnumerator();
contador = 0;
sstValidDeleted = new string[stValidDeleted.Count];
if (stValidDeleted.Count > 0)
{
while (mEnumerator.MoveNext())
{
sstValidDeleted[contador] = mEnumerator.Current.ToString();
contador++;
}
}
}
