private void btnExecuteDataSet_Click(object sender, EventArgs e)
{
Stopwatch watch = Stopwatch.StartNew();
try
{
ClearQueryresult();
string mdx = txtMdx.Text;
if (txtMdx.ActiveTextAreaControl.TextArea.SelectionManager.HasSomethingSelected)
{
mdx = txtMdx.ActiveTextAreaControl.TextArea.SelectionManager.SelectedText;
}
DataTable dt = MdxHelper.ExecuteDataTable(Connection, mdx);
watch.Stop();
this.ShowMessage("查询耗时{0}毫秒,", watch.ElapsedMilliseconds);
gvMdxresult.DataSource = dt;
ShowResult(gvMdxresult);
}
catch (Exception ex)
{
this.ShowMessage("Mdx查询出错{0},", ex.ToString());
}
finally
{
}
}
private void btnExecute_Click(object sender, EventArgs e)
{
Stopwatch watch = Stopwatch.StartNew();
try
{
ClearQueryresult();
string mdx = txtMdx.Text;
if (txtMdx.ActiveTextAreaControl.TextArea.SelectionManager.HasSomethingSelected)
{
mdx = txtMdx.ActiveTextAreaControl.TextArea.SelectionManager.SelectedText;
}
CellSet cst = MdxHelper.ExecuteCellSet(Connection, mdx);
watch.Stop();
this.ShowMessage("查询耗时{0}毫秒,", watch.ElapsedMilliseconds);
gvMdxresult.Tag = cst;
lastUseFormattedValue = sender == this.btnExecuteWithFormatted;
//DataTable dt = cst.ToDataTable2(lastUseFormattedValue);
BindCellSet(gvMdxresult, cst, lastUseFormattedValue);
//gvMdxresult.DataSource = dt;
ShowResult(gvMdxresult);
}
catch (AdomdException aex)
{
this.ShowMessage("Mdx查询出错{0},", aex.ToString());
}
catch (Exception ex)
{
this.ShowMessage("Mdx查询出错{0},", ex.ToString());
}
finally
{
}
}
public static IDbConnection GetConnection(SqlSyntax syntax, string connstr)
{
switch (syntax)
{
case SqlSyntax.MSSQL:
return(SqlHelper.GetConnection(connstr));
case SqlSyntax.Oracle:
return(OracleHelper.GetConnection(connstr));
case SqlSyntax.Mdx:
return(MdxHelper.GetConnection(connstr));
default: return(null);
}
}
public static object ExecuteScalar(IDbConnection conn, string sql, SqlSyntax syntax)
{
switch (syntax)
{
case SqlSyntax.MSSQL:
return(SqlHelper.ExecuteScalar((SqlConnection)conn, CommandType.Text, sql, null));
case SqlSyntax.Oracle:
return(OracleHelper.ExecuteScalar((OracleConnection)conn, CommandType.Text, sql, null));
case SqlSyntax.Mdx:
return(MdxHelper.ExecuteScalar((AdomdConnection)conn, sql));
default: return(null);
}
}
public static void ExecuteNonQuery(IDbConnection conn, string sql, SqlSyntax syntax)
{
switch (syntax)
{
case SqlSyntax.MSSQL:
SqlHelper.ExecuteNonQuery((SqlConnection)conn, CommandType.Text, sql, null);
break;
case SqlSyntax.Oracle:
break;
case SqlSyntax.Mdx:
MdxHelper.ExecuteNonQuery((AdomdConnection)conn, sql);
break;
}
}
public static DataTable ExecuteDataTable(IDbConnection conn, string sql, SqlSyntax syntax)
{
switch (syntax)
{
case SqlSyntax.MSSQL:
return(SqlHelper.ExecuteDataTable((SqlConnection)conn, CommandType.Text, sql, null));
case SqlSyntax.Oracle:
return(OracleHelper.ExecuteDataTable((OracleConnection)conn, CommandType.Text, sql, null));
case SqlSyntax.Mdx:
CellSet cellSet = MdxHelper.ExecuteCellSet((AdomdConnection)conn, sql);
if (cellSet != null)
{
return(cellSet.ToDataTable());
}
return(null);
default: return(null);
}
}
