public static void SetVIEW_DataGridViewImageColumns_Headers(DataGrid dgvx, CodeTables.DBTableControl xdbTables,CodeTables.SQLTable tbl)
{
foreach (DataGridColumn col in dgvx.Columns)
{
Column c = FindColumn(tbl,(string)col.Header);
if (c != null)
{
col.Header = c.Name_in_language.s;
}
else
{
string sSeparator = SQLTable.VIEW_TableName2ColumnName_SEPARATOR;
int iSeparator_Length = sSeparator.Length;
string colName = (string)col.Header;
int iTableNameEnd = colName.IndexOf(sSeparator);
if (iTableNameEnd > 0)
{
string sTableName_Abbreviation = colName.Substring(0, iTableNameEnd);
string sColName = colName.Substring(iTableNameEnd + iSeparator_Length, colName.Length - iTableNameEnd - iSeparator_Length);
iSeparator_Length = SQLTable.VIEW_TableName_SEPARATOR.Length;
iTableNameEnd = sTableName_Abbreviation.LastIndexOf(SQLTable.VIEW_TableName_SEPARATOR);
if (iTableNameEnd > 0)
{
sTableName_Abbreviation = sTableName_Abbreviation.Substring(iTableNameEnd + iSeparator_Length, sTableName_Abbreviation.Length - iTableNameEnd - iSeparator_Length);
}
SQLTable xtbl = xdbTables.GetTable_from_TableName_Abbreviation(sTableName_Abbreviation);
if (xtbl != null)
{
Column cc = FindColumn(xtbl,sColName);
if (cc != null)
{
col.Header = cc.Name_in_language.s;
}
}
}
}
}
}
public void SetVIEW_DataGridViewImageColumns_Headers(DataGridView dgvx_Item, CodeTables.DBTableControl xdbTables)
{
foreach (DataGridViewColumn col in dgvx_Item.Columns)
{
Column c = this.FindColumn(col.Name);
if (c != null)
{
col.HeaderText = c.Name_in_language.s;
}
else
{
string sSeparator = VIEW_TableName2ColumnName_SEPARATOR;
int iSeparator_Length = sSeparator.Length;
int iTableNameEnd = col.Name.IndexOf(sSeparator);
if (iTableNameEnd > 0)
{
string sTableName = col.Name.Substring(0, iTableNameEnd);
string sColName = col.Name.Substring(iTableNameEnd + iSeparator_Length, col.Name.Length - iTableNameEnd - iSeparator_Length);
iSeparator_Length = VIEW_TableName_SEPARATOR.Length;
iTableNameEnd = sTableName.LastIndexOf(VIEW_TableName_SEPARATOR);
SQLTable tbl = null;
if (iTableNameEnd > 0)
{
sTableName = sTableName.Substring(iTableNameEnd + iSeparator_Length, sTableName.Length - iTableNameEnd - iSeparator_Length);
tbl = xdbTables.GetTable_from_TableName_Abbreviation(sTableName);
}
else
{
tbl = xdbTables.GetTable(sTableName);
}
if (tbl != null)
{
Column cc = tbl.FindColumn(sColName);
if (cc != null)
{
col.HeaderText = cc.Name_in_language.s;
}
}
}
}
}
}
