/// <summary>
/// 获取dataset，关闭conn
/// </summary>
/// <param name="text">sql语句或存储过程名</param>
/// <param name="type">执行类型：sql或存储过程</param>
/// <param name="param">参数</param>
/// <returns>DataSet类型</returns>
public static DataSet ExecuteDataSet(string dbname, string text, CommandType type, DbParam[] param)
{
Database db = GetDB(dbname);
return db.ExecuteDataSet(text, type, param);
}
/// <summary>
/// 获取dataset，关闭conn
/// </summary>
/// <param name="sql">存储过程名</param>
/// <param name="param">参数</param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string dbname, string sql, DbParam[] param)
{
Database db = GetDB(dbname);
return db.ExecuteDataSet(sql, param);
}
///
///返回dataset，自动创建conn 执行结束关闭conn
///
#region public static DataSet ExecuteDataSet(string text)
/// <summary>
/// 从DataBaseCache.DefDB获取Dataset ，关闭conn
/// </summary>
/// <param name="text">sql语句</param>
/// <returns>DataSet类型的对象</returns>
public static DataSet ExecuteDataSet(string text)
{
Database db = GetDB(DataBaseCache.DefDB);
return db.ExecuteDataSet(text);
}
/// <summary>
/// 获取Dataset ，关闭conn
/// </summary>
/// <param name="text">sql语句</param>
/// <returns>DataSet类型的对象</returns>
public static DataSet ExecuteDataSet(string dbname, string text)
{
Database db = GetDB(dbname);
return db.ExecuteDataSet(text);
}
public DataSet getDataSetProc(string processID, string ProcName, string[] paramArr, string[] valueArr)
{
DataSet ds = new DataSet();
// Database db = DataBaseManager.GetDB();
ExcelDataBase.Database db = DbFunction.GetDB("");
try
{
int paramLen = 0;
DbParam[] myParam = null;
if (paramArr != null)
{
paramLen = paramArr.Length;
}
if (db.DBType == DataBaseType.ORA)
{
paramLen = paramLen + 1;
}
if (paramLen > 0)
{
myParam = new DbParam[paramLen];
}
if (paramArr != null)
{
for (int i = 0; i < paramArr.Length; i++)
{
DbParam vsparam = new DbParam();
vsparam.dataType = DataType.VarChar;
vsparam.paramDirct = ParameterDirection.Input;
vsparam.paramName = paramArr[i];
vsparam.paramValue = valueArr[i];
vsparam.sqlType = SqlType.Proc;
myParam[i] = vsparam;
}
}
if (db.DBType == DataBaseType.ORA)
{
DbParam vsparam = new DbParam();
vsparam.dataType = DataType.Cursor;
vsparam.paramDirct = ParameterDirection.Output;
vsparam.paramName = "Re_CURSOR";
vsparam.paramValue = "";
vsparam.sqlType = SqlType.Proc;
myParam[myParam.Length - 1] = vsparam;
}
ds = db.ExecuteDataSet(ProcName, myParam);
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}