private void FrmTableRelationView_Load(object sender, EventArgs e)
{
IDBHelper helper = DataBaseManager.GetDbHelper(SqlType.SqlServer, GlobalHelp.ConfigConn);
helper.CreateCommand("Select * from TableView order by ParentID");
DataTable dt = helper.ExecuteQuery();
dataGridView1.DataSource = dt;
if (dt.Rows.Count == null || dt.Rows.Count == 0)
{
return;
}
cTreeView1.DrawStyle = CTreeViewDrawStyle.VerticalDiagram;
cTreeView1.ShowRootLines = false;
DataTable dtParent = dt.Select("ParentId=0").CopyToDataTable();
for (int i = 0; i < dtParent.Rows.Count; i++)
{
CTreeNode treeNode = new CTreeNode(new Label());
((Label)treeNode.Control).Text = dtParent.Rows[i]["TableName"].ToString();
((Label)treeNode.Control).Width = 100;
((Label)treeNode.Control).AutoSize = true;
((Label)treeNode.Control).TextAlign = ContentAlignment.MiddleCenter;
cTreeView1.Nodes.Add(treeNode);
AddNode(dt, int.Parse(dtParent.Rows[i]["Id"].ToString()), treeNode);
}
//cTreeView1.Nodes.Add(new CTreeNode(new Label()));
//((Label)cTreeView1.Nodes[0].Control).Text = "附属设施关系";
//((Label)cTreeView1.Nodes[0].Control).Width = 100;
//((Label)cTreeView1.Nodes[0].Control).AutoSize = true;
//((Label)cTreeView1.Nodes[0].Control).TextAlign = ContentAlignment.MiddleCenter;
//cTreeView1.Nodes[0].Nodes.Add(new CTreeNode(new Label()));
//((Label)cTreeView1.Nodes[0].Nodes[0].Control).Text = "RuleId_DetailId";
//((Label)cTreeView1.Nodes[0].Nodes[0].Control).Width = 100;
//((Label)cTreeView1.Nodes[0].Nodes[0].Control).AutoSize = true;
//((Label)cTreeView1.Nodes[0].Nodes[0].Control).TextAlign = ContentAlignment.MiddleCenter;
////下面添加两个GridView
//cTreeView1.Nodes[0].Nodes[0].Nodes.Add(new CTreeNode(new DataGridView()));
//((DataGridView)cTreeView1.Nodes[0].Nodes[0].Nodes[0].Control).Columns.Add("1", "1");
//((DataGridView)cTreeView1.Nodes[0].Nodes[0].Nodes[0].Control).Columns.Add("2", "2");
//((DataGridView)cTreeView1.Nodes[0].Nodes[0].Nodes[0].Control).Rows.Add(new string[] { "a", "b" });
//cTreeView1.Nodes[0].Nodes[0].Nodes.Add(new CTreeNode(new DataGridView()));
//((DataGridView)cTreeView1.Nodes[0].Nodes[0].Nodes[1].Control).Columns.Add("1", "1");
//((DataGridView)cTreeView1.Nodes[0].Nodes[0].Nodes[1].Control).Columns.Add("2", "2");
//((DataGridView)cTreeView1.Nodes[0].Nodes[0].Nodes[1].Control).Rows.Add(new string[] { "a", "b" });
//cTreeView1.Nodes[0].Nodes[0].Nodes[1].Nodes.Add(new CTreeNode(new Label()));
//((Label)cTreeView1.Nodes[0].Nodes[0].Nodes[1].Nodes[0].Control).Text = "RuleId_DetailId";
//((Label)cTreeView1.Nodes[0].Nodes[0].Nodes[1].Nodes[0].Control).Width = 100;
//((Label)cTreeView1.Nodes[0].Nodes[0].Nodes[1].Nodes[0].Control).AutoSize = true;
//((Label)cTreeView1.Nodes[0].Nodes[0].Nodes[1].Nodes[0].Control).TextAlign = ContentAlignment.MiddleCenter;
}
private DataSet Run(DatabaseSchema dbSchema, string strSql)
{
string strConn = dbSchema.ConnectionString;
m_dbHelper = DataBaseManager.GetDbHelper(m_serverTag.DBType, strConn);
m_dbHelper.CreateCommand(strSql);
DataSet ds = m_ds = m_dbHelper.ExecuteQueryDataSet();
return(ds);
}
/// <summary>测试连接
/// 测试连接
/// </summary>
/// <param name="strType">strType</param>
/// <returns>bool</returns>
private bool TestConn(SqlType dbType)
{
bool blnIsConnect = false;
string strConn = txtPath.Text.Trim();
IDBHelper dbHelper = DataBaseManager.GetDbHelper(dbType, strConn);
if (dbHelper != null)
{
blnIsConnect = dbHelper.TestConn();
}
return(blnIsConnect);
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="strServer">服务器名称</param>
/// <param name="strDbName">数据库名称</param>
/// <param name="strTableName">数据库表名</param>
/// <param name="dbType">类型</param>
public FrmTableView(ServerTag serverTag, string strDbName, string strTableName)
{
InitializeComponent();
m_strTableName = strTableName;
m_strServer = serverTag.Server;
m_strDbName = strDbName;
m_dbType = serverTag.DBType;
grdTable.EditMode = DataGridViewEditMode.EditOnEnter;
this.Text = "打开表" + "_" + m_strServer + "_" + m_strDbName + "_" + m_strTableName;
m_databaseSchema = GlobalHelp.GetDatabaseSchema(serverTag.DBType, serverTag.Server, strDbName);
m_dbHelper = DataBaseManager.GetDbHelper(m_dbType, m_databaseSchema.ConnectionString);
m_lstCopyRow = new List <DataRow>();
BindGrid(m_strTableName);
}
/// <summary>
/// 构造函数 构造函数
/// </summary>
/// <param name="strServer">服务器名称</param>
/// <param name="strDbName">数据库名称</param>
/// <param name="strTableName">数据库表名</param>
/// <param name="dbType">类型</param>
/// <param name="blnNew">是否新增表，true 新增表，false，设计表</param>
public FrmTableNew(ServerTag serverTag, string strDbName, string strTableName, SqlType dbType, bool blnNew)
{
InitializeComponent();
m_dal = new Bse_DataDictionaryDAL();
m_strTableName = strTableName;
m_strServer = serverTag.Server;
m_strDbName = strDbName;
m_dbType = dbType;
grdTable.EditMode = DataGridViewEditMode.EditOnEnter;
grdTable.AutoGenerateColumns = false;
m_databaseSchema = GlobalHelp.GetDatabaseSchema(serverTag.DBType, serverTag.Server, strDbName);
m_dbHelper = DataBaseManager.GetDbHelper(m_dbType, m_databaseSchema.ConnectionString);
m_sqlTasks = new SqlTasks(m_dbType);
m_blnNew = blnNew;
}
private void btnRun_Click(object sender, EventArgs e)
{
if (cboServer.Text == string.Empty)
{
MessageBox.Show("请选择要执行的服务器");
return;
}
if (txtSql.Text.Trim() == string.Empty)
{
MessageBox.Show("请选择要执行的语句");
return;
}
TreeNode treeNode = tvwAnalyze.SelectedNode;
DataRow dr = treeNode.Tag as DataRow;
if (dr != null)
{
string strDbType = dr["DbType"].ToString();
string strExcuteType = dr["ExcuteType"].ToString();
TreeNode treeNodeFind = FindTreeNodeByName(cboServer.Text.Trim());
ServerTag serverTag = treeNodeFind.Tag as ServerTag;
if (serverTag != null)
{
SqlType dbType = GetSqlType(strDbType);
if (serverTag.DBType != dbType)
{
MessageBox.Show("选中的语句不支持在" + serverTag.DBType + "服务器下执行");
return;
}
IDBHelper dbHelper = DataBaseManager.GetDbHelper(dbType, serverTag.MasterConn);
switch (strExcuteType)
{
case "SQL语句":
dbHelper.CreateCommand(txtSql.Text.Trim());
break;
case "存储过程":
dbHelper.CreateStoredCommand(txtSql.Text.Trim());
break;
}
DataSet ds = dbHelper.ExecuteQueryDataSet();
if (ds.Tables.Count > 0)
{
grdResult.DataSource = ds.Tables[0];
}
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtDbName.Text.Trim() == string.Empty)
{
MessageBox.Show(@"请输入数据库名称");
txtDbName.Select();
return;
}
if (txtPath.Text.Trim() == string.Empty)
{
MessageBox.Show(@"请选择路径");
btnSelectPath_Click(null, null);
return;
}
CreateDatabaseScript = DataBaseManager.GenCreateDatabaseScripts(m_dbType, txtDbName.Text.Trim(), txtPath.Text.Trim());
this.DialogResult = DialogResult.OK;
}
private void btnSelectDB_Click(object sender, EventArgs e)
{
if (m_ServerDB == null || m_ServerDB.Rows.Count == 0)
{
m_ServerDB = DataBaseManager.GetDataBase(dbType, BuildConn(this.dbType));
}
FrmSelectDataBases frmSelectDb = new FrmSelectDataBases(m_ServerDB);
if (frmSelectDb.ShowDialog() == DialogResult.OK)
{
LoadDatabase = frmSelectDb.LoadDataBase;
foreach (DataRow dr in LoadDatabase.Rows)
{
txtDB.Text += dr[0] + @",";
}
txtDB.Text = txtDB.Text.TrimEnd(',');
}
}
private DataSet Run(List <TreeNode> lstTreeNodeDb, string strSql)
{
foreach (TreeNode item in lstTreeNodeDb)
{
string strConn = item.Tag.ToString();
var serverTag = item.Parent.Tag as ServerTag;
if (serverTag != null)
{
m_dbHelper = DataBaseManager.GetDbHelper(serverTag.DBType, strConn);
}
m_dbHelper.CreateCommand(strSql);
DataSet ds = m_dbHelper.ExecuteQueryDataSet();
foreach (DataTable dt in ds.Tables)
{
if (dt != null)
{
DataTable dtNew = dt.Copy();
dtNew.TableName = Guid.NewGuid().ToString();
m_ds.Tables.Add(dtNew);
}
}
}
return(m_ds);
}
/// <summary>连接
/// 连接
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOK_Click(object sender, EventArgs e)
{
if (!CheckInput())
{
return;
}
#if !DEBUG
if (txtDB.Text.Trim() == string.Empty)
{
m_ServerDB = DataBaseManager.GetDataBase(dbType, BuildConn(this.dbType));
if (m_ServerDB.Rows.Count > 5)
{
dialog = MessageBox.Show(@"一共需要加载【" + m_ServerDB.Rows.Count + "】个数据库，需要时间较长，建议按需加载", "提示", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
btnSelectDB_Click(null, null);
return;
}
}
}
#endif
#if DEBUG
LoadDatabase = new DataTable();
LoadDatabase.Columns.Add("name", typeof(string));
DataRow dr = LoadDatabase.NewRow();
dr["name"] = GlobalHelp.DefauleDatabase;
LoadDatabase.Rows.Add(dr);
#endif
bool flag = TestConn(this.dbType);
if (flag)
{
if (chkRem.Checked)
{
DataSet ds = m_dalConn.GetList("IP='" + cboServer.Text.Trim() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
m_dalConn.DeleteByCond("IP='" + cboServer.Text.Trim() + "'");
}
DbConnect model = new DbConnect
{
IP = cboServer.Text.Trim(),
Pwd = DESEncryptHelper.Encrypt(txtPassword.Text.Trim(), "test332211"),
User = cboUser.Text.Trim(),
Remark = this.dbType.ToString(),
CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
};
m_dalConn.Add(model);
}
DBConn = BuildConn(this.dbType);
Server = cboServer.Text.Trim();
UID = cboUser.Text.Trim();
PWD = txtPassword.Text.Trim();
if (this.dbType == SqlType.MySql)
{
Port = cboLogin.Text.Trim();
}
List <string> lstLoadType = new List <string>();
foreach (CCBoxItem item in chkAllowType.CheckedItems)
{
lstLoadType.Add(item.Name);
}
LoadType = lstLoadType;
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show(@"连接失败");
}
}
