private void QueryComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
SQLTextBox.Clear();
//should be a reference to a member of the "savedProc" list
var proc = (SavedProc)QueryComboBox.SelectedItem;
SQLTextBox.Text = proc.proc;
}
private void PUButton_Click_17(object sender, RoutedEventArgs e)
{
int i = SQLTextBox.SelectionStart;
string s = SQLTextBox.Text;
s = s.Insert(i, " NULL ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 6, 0);
}
/// <summary>
/// 选择字段名
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AttrListView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (AttrListView.SelectedIndex == -1)
{
return;
}
int i = SQLTextBox.SelectionStart;
string s = SQLTextBox.Text;
string name = FldsNames[AttrListView.SelectedIndex];
s = s.Insert(i, name);
SQLTextBox.Text = s;
AttrListView.SelectedIndex = -1;
SQLTextBox.Focus();
SQLTextBox.Select(i + name.Length, 0);
}
private void SQLTabItem_GotFocus(object sender, RoutedEventArgs e)
{
SQLTextBox.Focus();
}
/// <summary>
/// 使用函数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void PUComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int i = 0;
string s = "";
switch (FuncComboBox.SelectedIndex)
{
case -1:
break;
case 0:
i = SQLTextBox.SelectionStart;
s = SQLTextBox.Text;
s = s.Insert(i, " abs() ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 5, 0);
FuncComboBox.SelectedIndex = -1;
break;
case 1:
i = SQLTextBox.SelectionStart;
s = SQLTextBox.Text;
s = s.Insert(i, " Max() ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 5, 0);
FuncComboBox.SelectedIndex = -1;
break;
case 2:
i = SQLTextBox.SelectionStart;
s = SQLTextBox.Text;
s = s.Insert(i, " Min() ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 5, 0);
FuncComboBox.SelectedIndex = -1;
break;
case 3:
i = SQLTextBox.SelectionStart;
s = SQLTextBox.Text;
s = s.Insert(i, " Round() ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 7, 0);
FuncComboBox.SelectedIndex = -1;
break;
case 4:
i = SQLTextBox.SelectionStart;
s = SQLTextBox.Text;
s = s.Insert(i, " Lower() ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 7, 0);
FuncComboBox.SelectedIndex = -1;
break;
case 5:
i = SQLTextBox.SelectionStart;
s = SQLTextBox.Text;
s = s.Insert(i, " Upper() ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 7, 0);
FuncComboBox.SelectedIndex = -1;
break;
case 6:
i = SQLTextBox.SelectionStart;
s = SQLTextBox.Text;
s = s.Insert(i, " Substr() ");
SQLTextBox.Text = s;
SQLTextBox.Focus();
SQLTextBox.Select(i + 8, 0);
FuncComboBox.SelectedIndex = -1;
break;
default:
break;
}
}
