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 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); }