private void BTnEditInsetTable_Click(object sender, System.EventArgs e)
{
if (this.checkedListTable.SelectedItem == null)
{
return;
}
TableExpression tableExpression = this.checkedListTable.SelectedItem as TableExpression;
FrmTableExpression frmtableExpression = new FrmTableExpression(this.AvaliableConnecton, this.GetTablelist(), tableExpression);
ArrayList expressionTableList = new ArrayList();
foreach (TableExpression item in this.checkedListTable.Items)
{
if (item != tableExpression)
{
expressionTableList.Add(item.TableName);
}
}
int index = this.checkedListTable.SelectedIndex;
this.checkedListTable.SelectedIndex = -1;
frmtableExpression.SetTablename(expressionTableList);
if (frmtableExpression.ShowDialog() == DialogResult.OK)
{
this.checkedListTable.Refresh();
this.checkedListTable.SelectedIndex = index;
}
}
private void BtnNewTable_Click(object sender, System.EventArgs e)
{
if (this.checkedListTable.Items.Count == 0)
{
return;
}
ArrayList tablesList = this.GetTablelist();
FrmTableExpression frmtableExpression = new FrmTableExpression(this.AvaliableConnecton, tablesList);
ArrayList expressionTableList = new ArrayList();
foreach (TableExpression item in this.checkedListTable.Items)
{
expressionTableList.Add(item.TableName);
}
frmtableExpression.SetTablename(expressionTableList);
if (frmtableExpression.ShowDialog() == DialogResult.OK)
{
this.checkedListTable.Items.Add(frmtableExpression.tableExpression, true);
int index = this.checkedListTable.FindString(frmtableExpression.tableExpression.ToString());
this.checkedListTable.SelectedIndex = index;
this.SetSQLText();
}
}
