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