private void OperateConfig_Load(object sender, EventArgs e)
{
nud_condition.Value = 0;
nud_condition.Value = 0;
cb_can_click.SelectedIndex = 0;
panel3.Visible = false;
cb_condition_oprator.SelectedIndex = 0;
ComBoxBinding(cb_db, SQL_DATABASE.ExecuteQuery().
Select(row => row[0]));
UpdateOutPut(sender, e);
}
private void tv_dataBase_AfterExpand(object sender, TreeViewEventArgs e)
{
//清空孩子
e.Node.Nodes.Clear();
//判断层级
if (e.Node.Level == 0)
{
e.Node.Nodes.AddRange(
NewNodesWithEmptyChild(SQL_DATABASE.ExecuteQuery().
Where(a => cbItems.Contains(a[0])).
Select(row
=> row[0]).OrderBy(o => o).ToArray()));
//MessageBox.Show("正在获取数据库"+e.Node.Text + e.Action.ToString());
}
if (e.Node.Level == 1)
{
//防止垮裤
var brothers = e.Node.Parent.Nodes;
foreach (TreeNode item in brothers)
{
if (item.FullPath != e.Node.FullPath)
{
//折叠节点
item.Collapse(false);
//清空listView
lv_colums.Clear();
}
else
{
DbName = e.Node.Text;
// TipInfo("已更换数据库" + dbName);
}
}
e.Node.Nodes.AddRange(
NewNodesWithEmptyChild(SQL_TABLE().ExecuteQuery(e.Node.Text).
Select(row
=> row[0]).OrderBy(o => o).ToArray()));
// MessageBox.Show("正在获取数据表" + e.Node.Text + e.Action.ToString());
}
if (e.Node.Level == 2)
{
var connStr = ConnectionString(e.Node.Parent.Text);
if (connStr.HasValue())
{
e.Node.Nodes.AddRange(
NewNodes(SQL_TABLECOLUMN(e.Node.Text).ExecuteReader2(connStr).
Select(row
=> new string[] { row[1],
string.Format("{0};{1};{2};{3};{4};{5};{6}", DateTime.Now.Random(), row[1], row[2], row[3], row[4], row[10], row[11]) }).ToArray()));
}
// MessageBox.Show("正在获字段列表" + e.Node.Text + e.Action.ToString());
}
}
private void tv_dataBase_AfterExpand(object sender, TreeViewEventArgs e)
{
//清空孩子
e.Node.Nodes.Clear();
//判断层级
if (e.Node.Level == 0)
{
e.Node.Nodes.AddRange(
NewNodesWithEmptyChild(SQL_DATABASE.ExecuteQuery().
Select(row
=> row[0]).ToArray()));
//MessageBox.Show("正在获取数据库"+e.Node.Text + e.Action.ToString());
}
if (e.Node.Level == 1)
{
e.Node.Nodes.AddRange(
NewNodesWithEmptyChild(SQL_TABLE().ExecuteQuery(e.Node.Text).
Select(row
=> row[0]).ToArray()));
// MessageBox.Show("正在获取数据表" + e.Node.Text + e.Action.ToString());
}
if (e.Node.Level == 2)
{
var connStr = ConnectionString(e.Node.Parent.Text);
if (connStr.HasValue())
{
e.Node.Nodes.AddRange(
NewNodes(SQL_TABLECOLUMN(e.Node.Text).ExecuteReader2(connStr).
Select(row
=> new string[] { row[1],
string.Format("{0};{1};{2};{3};{4};", DateTime.Now.Random(), row[1], row[2], row[3], row[4]) }).ToArray()));
}
// MessageBox.Show("正在获字段列表" + e.Node.Text + e.Action.ToString());
}
}
private void tv_dataBase_AfterExpand(object sender, TreeViewEventArgs e)
{
//清空孩子
e.Node.Nodes.Clear();
//判断层级
if (e.Node.Level == 0)
{
e.Node.Nodes.AddRange(
NewNodesWithEmptyChild(SQL_DATABASE.ExecuteQuery().
// Where(a => cbItems.Contains(a[0])).
Select(row
=> row[0]).ToArray()));
}
if (e.Node.Level == 1)
{
//防止垮裤
var brothers = e.Node.Parent.Nodes;
foreach (TreeNode item in brothers)
{
if (item.FullPath != e.Node.FullPath)
{
//折叠节点
item.Collapse(false);
//清空listView
lv_colums.Clear();
}
else
{
DbName = e.Node.Text;
// TipInfo("已更换数据库" + DbName);
}
}
var temp = SQL_TABLE().ExecuteQuery(e.Node.Text).
Select(row
=> new { name = row[0], note = row[1] }).ToList();
if (temp.Any())
{
_cfg = new Config();
var _t = temp.FirstOrDefault();
_cfg.table_name = _t.name;
_cfg.table_note = _t.note;
e.Node.Nodes.AddRange(
NewNodesWithEmptyChild(temp.Select(a => a.note.HasValue()?a.name: a.name + "#").ToArray()));
}
}
if (e.Node.Level == 2)
{
var connStr = ConnectionString(e.Node.Parent.Text);
if (connStr.HasValue())
{
e.Node.Nodes.AddRange(
NewNodes(SQL_TABLECOLUMN(e.Node.Text).ExecuteReader2(connStr).
Select(row
=> new string[]
{
row[2].HasValue()?row[1]:row[1] + "#",
string.Format("{0};{1};{2};{3};{4};{5};{6};{7};{8};{9};{10};{11}",
DateTime.Now.Random(),
row[1], row[2], row[3],
row[4], row[5], row[6],
row[7], row[8], row[9],
row[10], row[11])
}).ToArray()));
}
}
}
