/// <summary>
/// 窗体初始化加载数据
/// </summary>
private void LoadData(string strXType)
{
lvSelectList.Items.Clear();
lvNotSelectList.Items.Clear();
DataTable _tables = SQLServerDBHelper.GetTables(selectConnectionString, strXType);
foreach (DataRow _tableNameRow in _tables.Rows)
{
string _tableName = _tableNameRow["name"].ToString();
ListViewItem lvi = new ListViewItem(_tableName);
lvi.Tag = _tableNameRow["xtype"];
lvNotSelectList.Items.Add(lvi);
}
}
/// <summary>
/// 数据库选择改变发生
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cboDataBase_TextChanged(object sender, EventArgs e)
{
lvSelectList.Items.Clear();
lvNotSelectList.Items.Clear();
foreach (DBConfig _DBConfig in DBSettings.DataBaseConfigList)
{
if (_DBConfig.DataBase == cboDataBase.Text)
{
selectDataBase = _DBConfig.DataBase;
selectConnectionString = _DBConfig.ConString;
}
}
DataTable _tables = SQLServerDBHelper.GetTables(selectConnectionString, "U");
foreach (DataRow _tableNameRow in _tables.Rows)
{
string _tableName = _tableNameRow["name"].ToString();
ListViewItem lvi = new ListViewItem(_tableName);
lvNotSelectList.Items.Add(lvi);
}
}
/// <summary>
/// 读取数据库
/// </summary>
/// <param name="_DBConfig"></param>
/// <returns></returns>
public TreeNode LoadDataBase(DBConfig _DBConfig)
{
TreeNode tn = new TreeNode();
tn.Text = _DBConfig.DataBase;
tn.ImageIndex = 1;
tn.Tag = "DataBase";
//tn.ContextMenuStrip = cmsForDataBase;
TreeNode tnDataTables = new TreeNode();
tnDataTables.Text = "数据表";
tnDataTables.ImageIndex = 2;
tnDataTables.Tag = "DataTables";
DataTable dtTables = new DataTable();
dtTables = SQLServerDBHelper.GetTables(_DBConfig.ConString, "U");
for (int i = 0; i < dtTables.Rows.Count; i++)
{
DataRow tableRow = dtTables.Rows[i];
TreeNode tnTable = new TreeNode();
tnTable.Text = tableRow[0].ToString();
tnTable.ImageIndex = 3;
tnTable.Tag = "Table|" + _DBConfig.ConString;
//tnTable.ContextMenuStrip = cmsForTable;
tnDataTables.Nodes.Add(tnTable);
}
TreeNode tnDataView = new TreeNode("视图");
//tnDataView.Nodes[0].show
tnDataView.ImageIndex = 2;
tnDataView.Tag = "DataViews";
//tnDataView.
DataTable dtViews = new DataTable();
dtViews = SQLServerDBHelper.GetTables(_DBConfig.ConString, "V");
for (int j = 0; j < dtViews.Rows.Count; j++)
{
DataRow viewRow = dtViews.Rows[j];
TreeNode tnView = new TreeNode();
tnView.Text = viewRow[0].ToString();
tnView.ImageIndex = 4;
tnView.Tag = "View";
//tnView.ContextMenuStrip = cmsForView;
tnDataView.Nodes.Add(tnView);
//HideCheckBox(tnView);
}
TreeNode tnDataProc = new TreeNode("存储过程");
tnDataProc.ImageIndex = 2;
tnDataProc.Tag = "DataProcs";
DataTable dtProcs = new DataTable();
dtProcs = SQLServerDBHelper.GetTables(_DBConfig.ConString, "P");
for (int k = 0; k < dtProcs.Rows.Count; k++)
{
DataRow procRow = dtProcs.Rows[k];
TreeNode tnProc = new TreeNode();
tnProc.Text = procRow[0].ToString();
tnProc.ImageIndex = 5;
tnProc.Tag = "Proc";
//tnProc.ContextMenuStrip = cmsForProc;
tnDataProc.Nodes.Add(tnProc);
//HideCheckBox(tnProc);
}
tn.Nodes.Add(tnDataTables);
tn.Nodes.Add(tnDataView);
tn.Nodes.Add(tnDataProc);
return(tn);
}