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