public FrmDataBaseQuery(ServerTag serverTag, string strDbName, string strDefaultSql, bool blnAutoRun)
{
InitializeComponent();
txtSql.ShowEOLMarkers = false;
txtSql.ShowHRuler = false;
txtSql.ShowInvalidLines = false;
txtSql.ShowMatchingBracket = true;
txtSql.ShowSpaces = false;
txtSql.ShowTabs = false;
txtSql.ShowVRuler = false;
txtSql.AllowCaretBeyondEOL = false;
txtSql.Document.HighlightingStrategy = HighlightingStrategyFactory.CreateHighlightingStrategy("SQL");
txtSql.Encoding = Encoding.GetEncoding("GB2312");
bckWorker.WorkerReportsProgress = true;
this.m_dtDbName = serverTag.ServerDBNames;
this.m_strServer = serverTag.Server;
this.m_strDbName = strDbName;
this.m_serverTag = serverTag;
this.Text = m_strDbName + @"查询";
ComboboxHelper.BindCombobox(cboDbName, serverTag.ServerDBNames, "name", "name", false);
this.cboDbName.Text = m_strDbName;
cboDbName.SelectedIndexChanged += cboDbName_SelectedIndexChanged;
if (strDefaultSql != string.Empty)
{
txtSql.Text = strDefaultSql;
if (blnAutoRun)
{
cmdRun_Click(null, null);
}
}
}
/// <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];
}
}
}
}