예제 #1
0
        public string getDBType(string PID)
        {
            ExcelDataBase.Database db = DbFunction.GetDB("");

            return(db.DBType.Equals(DataBaseType.ORA) ? "ORA" : "MSS");

            //GS_PublicVar.Dev_LoginGS(PID);
            //return Convert.ToString(CommonFunction.GlobalVariable["Genersoft.BS.Public.DbType"]).Trim();
        }
예제 #2
0
        /// <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); 
        }
예제 #3
0
 /// <summary>
 /// 获取database对象
 /// </summary>
 /// <param name="dbname">database名称</param>
 /// <returns>数据库类型,MSS Ora等</returns>
 public static Database GetDB(string dbname)
 {
     if (string.IsNullOrEmpty(dbname)) dbname = DataBaseCache.DefDB;
     Database db =DataBaseCache.getCacheDB(dbname);
     return db;
 }
예제 #4
0
 /// <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); 
 }
예제 #5
0
 /// <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);
 }
예제 #6
0
        ///
        ///返回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);
        }
예제 #7
0
        /// <summary>
        ///执行存储过程或sql的datareader,自动创建conn,自动关闭conn
        /// </summary>
        /// <param name="text">sql 或proc</param>
        /// <param name="type">sql 或存储过程</param>
        /// <param name="param">参数</param>
        /// <param name="callback">代理方法</param>
        /// <returns>object基本类型</returns>
        public static object ExecuteRead(string dbname, string text, CommandType type, DbParam[] param, Database.DBCallback callback)
        {

            Database db = GetDB(dbname);
            return db.ExecuteRead(text, type, param, callback);
        }
예제 #8
0
        ///
        ///执行DataReader 返回object 需要代理调用,自动创建conn,自动关闭conn
        ///

        #region public static object ExecuteRead(string dbname,string sqltext,Genersoft.GSIDP.GSYS.Data.Database.DBCallback callback)

        /// <summary>
        /// 执行datareader,参数sql语句 和 delegate返回调用,自动创建conn,自动关闭conn
        /// </summary>
        /// <param name="sqltext">sql语句</param>
        /// <param name="callback"> delegate 方法</param>
        /// <returns>object类型,基本类型</returns>
        public static object ExecuteRead(string dbname, string sqltext, Database.DBCallback callback)
        {
            Database db = GetDB(dbname);
            return db.ExecuteRead(sqltext,callback);
        }
예제 #9
0
 /// <summary>
 /// 返回Dictionary 自动创建conn,自动关闭conn
 /// </summary>
 /// <param name="sql">sql或存储过程名</param>
 /// <param name="type">执行类型</param>
 /// <param name="param">参数</param>
 /// <returns>dict对象</returns>
 public static Dictionary<string, object> ExecuteReadDict(string dbname, string sql, CommandType type, DbParam[] param)
 {
     Database db = GetDB(dbname); 
     return db.ExecuteReadDict(sql,type, param);
 }
예제 #10
0
 /// <summary>
 /// 返回Dictionary 自动创建conn,自动关闭conn
 /// </summary>
 /// <param name="sql">sql</param>
 /// <returns>dict对象</returns>
 public static Dictionary<string, object> ExecuteReadDict(string dbname, string sql)
 {
     Database db = GetDB(dbname);
     return db.ExecuteReadDict(sql);
 }
예제 #11
0
        ///
        ///执行DataReader 返回Dictionary 自动创建conn,自动关闭conn
        /// 

        #region public static Dictionary<string,object> ExecuteReadDict(string sql)
        /// <summary>
        /// 返回Dictionary 自动创建conn,自动关闭conn
        /// </summary>
        /// <param name="sql">sql</param>
        /// <returns>dict对象</returns>
        public static Dictionary<string, object> ExecuteReadDict(string sql)
        {
            Database db = GetDB(DataBaseCache.DefDB);
            return db.ExecuteReadDict(sql);
        }
예제 #12
0
 /// <summary>
 /// 执行带参数的sql,自动创建并关闭conn
 /// </summary>
 /// <param name="dbname">数据库名</param>
 /// <param name="sql">sql 或 存储过程名</param>
 /// <param name="type">执行类型</param>
 /// <param name="param">参数</param>
 /// <returns>返回影响行数</returns>
 public static int ExecuteNonQuery(string dbname, string sql, CommandType type, DbParam[] param)
 {
     Database db = GetDB(dbname);
     return db.ExecuteNonQuery(sql, type, param);
 }
예제 #13
0
        /// <summary>
        /// 获取单值的函数,自动创建conn,自动关闭conn
        /// </summary>
        /// <param name="dbname">数据库名</param>
        /// <param name="text">sql语句或存储过程名</param>
        /// <param name="type">执行类型:sql或存储过程</param>
        /// <param name="param">参数</param>
        /// <returns>object类型</returns>
        public static object ExecuteScalar(string dbname, string sql, CommandType type, DbParam[] param)
        {

            Database db = GetDB(dbname);
            return db.ExecuteScalar(sql, type, param);
        }
예제 #14
0
        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);
        }