private bool BuildExpByDataReader(string sfn, string sql)
{
var bRet = false;
switch (mConnectType.Type)
{
case DbType.SQLServer:
{
using (var dr = SqlServerHelper.ExecuteReader(mConnectType.ConnStr, sql, null))
{
bRet = EPPExcelHelper.BuilderExcel(sfn, dr);
}
}
break;
case DbType.Oracle:
{
using (var conn = new OracleConnection(mConnectType.ConnStr))
{
using (var dr = OraClientHelper.ExecuteReader(conn, CommandType.Text, sql, null))
{
bRet = EPPExcelHelper.BuilderExcel(sfn, dr);
}
}
}
break;
case DbType.MySql:
{
using (var conn = new MySqlConnection(mConnectType.ConnStr))
{
using (var dr = MySqlClientHelper.ExecuteReader(conn, CommandType.Text, sql, null))
{
bRet = EPPExcelHelper.BuilderExcel(sfn, dr);
}
}
}
break;
default: break;
}
return(bRet);
}
private bool QueryOracle(string sSql)
{
var bRet = false;
try
{
using (var conn = new OracleConnection(mConnectType.ConnStr))
{
using (var dr = OraClientHelper.ExecuteReader(conn, CommandType.Text, sSql, null))
{
mLastQuery.Load(dr);
}
}
bRet = true;
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
MessageBox.Show(ex.Message, "连接Oracle失败");
}
return(bRet);
}
private DataTable GetBaanData()
{
var sql = new StringBuilder();
sql.AppendFormat(@"
{0}
union
{1}
union
{2}
",
MakeSiteQuery("867"), MakeSiteQuery("878"), MakeSiteQuery("891"));
using (var conn = new OracleConnection(connectionString_Baan))
{
var dt = new DataTable();
using (OracleDataReader dr = OraClientHelper.ExecuteReader(conn, CommandType.Text, sql.ToString(), null))
{
dt.Load(dr);
}
return(dt);
}
}
