private void 刷新ToolStripMenuItem1_Click(object sender, EventArgs e)
{
if (!String.IsNullOrWhiteSpace(txtWhereStr.Text))
{
whereString = "Where " + txtWhereStr.Text.Trim();
}
else
{
whereString = "";
}
txtScript.Text = "";
if (treeView.SelectedNode != null)
{
if (treeView.SelectedNode.Level == 2)
{
statusString = "正在查询...";
SetParentInfo.SetStatusString(mainForm, statusString);
string dbName = treeView.SelectedNode.Parent.Text;
string tableName = treeView.SelectedNode.Text;
txtScript.Text = getInsertScript(dbName, tableName);
SetParentInfo.SetStatusString(mainForm, statusString);
}
}
else
{
MessageBox.Show("未连接数据库");
}
}
/// <summary>
/// 选中事件
/// </summary>
private void treeView_AfterSelect(object sender, TreeViewEventArgs e)
{
txtWhereStr.Text = "";
whereString = "";
if (treeView.SelectedNode != null && treeView.SelectedNode.Level == 2)
{
生成清库语句ToolStripMenuItem.Enabled = false;
try
{
txtScript.Clear();
statusString = "正在查询...";
SetParentInfo.SetStatusString(mainForm, statusString);
string dbName = treeView.SelectedNode.Parent.Text;
string tableName = treeView.SelectedNode.Text;
txtScript.Text = getInsertScript(dbName, tableName);
SetParentInfo.SetStatusString(mainForm, statusString);
}
finally
{
GC.Collect();
}
}
else if (treeView.SelectedNode != null && treeView.SelectedNode.Level == 1)
{
生成清库语句ToolStripMenuItem.Enabled = true;
}
else
{
生成清库语句ToolStripMenuItem.Enabled = false;
}
}