/// <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(); }