/// <summary>
/// 取得table/view
/// </summary>
/// <param name="dbconnName"></param>
/// <returns></returns>
public DataTable getTables(string dbconnName, string dbName, DBConn engine)
{
GlobalClass.debugLog("TableInfoAssistant", string.Format("getTables, dbconnName={0}, dbName={1}, dbstr={2}", dbconnName, dbName, engine.Dbstr));
CodeRefresh cr = new CodeRefresh();
cr.refreshTableInfo(dbconnName, dbName, engine);
// 取得local儲存的table
string sql = string.Format(@"select TableName from TableInfo
where DBConnName = '{0}' and DBName = '{1}' order by Favorite desc, TableName asc ",
dbconnName, dbName);
Reader r = _db.getDataReader(sql);
DataTable dt = new DataTable();
dt.Columns.Add("TableName");
while (r.Read())
{
DataRow dr = dt.NewRow();
dr["TableName"] = r[0].ToString();
dt.Rows.Add(dr);
}
dt.AcceptChanges();
return(dt);
}
protected override void OnClosed(EventArgs e)
{
base.OnClosed(e);
CodeRefresh.close();
if (GlobalClass.dblist == null)
{
return;
}
GlobalClass.closeAllConnection();
}
