private void buttonAdd_Click(object sender, EventArgs e) { try { Hubble.Core.BigTable.ServerInfo serverInfo = comboBoxBalanceServers.SelectedItem as Hubble.Core.BigTable.ServerInfo; if (serverInfo != null) { Hubble.Core.BigTable.ServerType serverType = radioButtonBalance.Checked ? Hubble.Core.BigTable.ServerType.Balance : Hubble.Core.BigTable.ServerType.Failover; foreach (string tableName in listBoxTable.SelectedItems) { _TempBigTableInfo.Add(tableName, serverType, serverInfo); } } _BigTableInfo.Tablets = _TempBigTableInfo.Tablets; _Result = DialogResult.OK; Close(); } catch (Exception ex) { QAMessageBox.ShowErrorMessage(ex); _TempBigTableInfo = _BigTableInfo.Clone(); } }
internal DialogResult ShowDialog(Hubble.Core.BigTable.ServerInfo serverInfo) { _ServerInfo = serverInfo.Clone(); labelServerName.Text = _ServerInfo.ServerName; textBoxConnectionString.Text = _ServerInfo.ConnectionString; checkBoxEnabled.Checked = _ServerInfo.Enabled; textBoxConnectionString.Select(); base.ShowDialog(); return(_Result); }
private void comboBoxBalanceServers_SelectedIndexChanged(object sender, EventArgs e) { Hubble.Core.BigTable.ServerInfo serverInfo = comboBoxBalanceServers.SelectedItem as Hubble.Core.BigTable.ServerInfo; if (serverInfo != null) { if (!ListTable(serverInfo)) { comboBoxBalanceServers.SelectedIndex = -1; } } }
private bool ListTable(Hubble.Core.BigTable.ServerInfo serverInfo) { try { listBoxTable.Items.Clear(); using (HubbleAsyncConnection conn = new HubbleAsyncConnection(serverInfo.ConnectionString)) { conn.Open(); HubbleCommand command = new HubbleCommand("exec sp_tablelist", conn); DataSet ds = command.Query(); foreach (DataRow row in ds.Tables[0].Rows) { if (!bool.Parse(row["IsBigTable"].ToString())) { string fullName = row["TableName"].ToString(); int index = fullName.IndexOf(conn.Database, 0, StringComparison.CurrentCultureIgnoreCase); if (index == 0) { index += conn.Database.Length; listBoxTable.Items.Add(fullName.Substring(index + 1, fullName.Length - index - 1)); } } } } return(true); } catch (Exception e) { QAMessageBox.ShowErrorMessage(e); return(false); } }