/// <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); }