private void loadAuxiliaryMaterialTable()
{
string sql = "SELECT [PKEY],[NODE_NAME],[TABLE_NAME] FROM [dbo].[BASE_AUXILIARY_MATERIAL] ORDER BY PKEY";
m_auxiliaryMaterialList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
AuxiliaryMaterialTable record = new AuxiliaryMaterialTable();
record.pkey = DbDataConvert.ToInt32(row[0]);
record.nodeName = DbDataConvert.ToString(row[1]);
record.tableName = DbDataConvert.ToString(row[2]);
m_auxiliaryMaterialList.Add(m_auxiliaryMaterialList.Count, record);
}
}
}
public string getAuxiliaryMaterialTableNameFromPkey(int pkey)
{
if (m_auxiliaryMaterialList.Count == 0)
{
loadAuxiliaryMaterialTable();
}
string tableName = "";
foreach (KeyValuePair <int, AuxiliaryMaterialTable> index in m_auxiliaryMaterialList)
{
AuxiliaryMaterialTable record = new AuxiliaryMaterialTable();
record = index.Value;
if (record.pkey == pkey)
{
tableName = record.tableName;
break;
}
}
return(tableName);
}