public bool GetTable()
{
var result = false;
while (true)
{
m_sysTable = null;
var sql = string.Format("SELECT {0}, {1} FROM information_schema.tables WHERE table_schema='{2}'",
table_name, table_comment, m_schema_table);
sql += string.Format(" and `{0}`='{1}'", table_name, m_table);
if (!FindRow(sql))
{
break;
}
m_sysTable = new sys_table();
m_sysTable.table_name = m_table;
// comment
var comment = YoConvert.Text2Json(m_dataRow[table_comment] as string);
if (comment != null)
{
// title
var title = comment[nameof(m_sysTable.title)];
if (title != null)
{
m_sysTable.title = title.ToString();
}
}
// get refer
var refer = (new MetaRefer(m_table)).GetReferTables();
m_sysTable.refer = string.Join(",", refer);
result = true;
break;
}
return(result);
}
public ColumnListLogic(int tableId)
{
m_sysTable = (new TableModel()).FindRow(tableId);
}
