private void InitTables()
{
string filter = string.Format("modelname_en = '{0}'", mModelName);
DataTable dt_mdl_def = Helper.GetDataTableProxy("sys_modl_def", filter, null, MainForm.conn);
int id = Convert.ToInt32(dt_mdl_def.Rows[0][0]);
filter = string.Format("modid = {0}", id);
DataTable dt_mdl_tbl = Helper.GetDataTableProxy("sys_modl_tab_def", filter, null, MainForm.conn);
filter = string.Empty;
foreach (DataRow dr in dt_mdl_tbl.Rows)
{
if (filter != string.Empty)
{
filter += " or ";
}
filter += string.Format("modtabid = {0}", dr["modtabid"]);
}
DataTable dt_meta_info = Helper.GetDataTableProxy("sys_meta_info", filter, null, MainForm.conn);
List <string> tblnames = new List <string>();
foreach (DataRow dr in dt_meta_info.Rows)
{
string name = dr["tablename"].ToString();
if (!tblnames.Contains(name))
{
tblnames.Add(name);
}
}
checkedListBox1.Items.Clear();
foreach (string name in tblnames)
{
checkedListBox1.Items.Add(name);
}
string dbname = Program.Database;
string[] dbs = mDataTableProxy.UTGetDatabases();
foreach (string db in dbs)
{
listViewEx2.Items.Add(db);
}
}
