C# 擷取 oracle 預存程序的 傳回值1

標籤：

/// <summary>        /// 返回對應表的類比自增欄位值        /// </summary>        /// <param name="tablename">表名</param>        /// <returns>表的類比自增欄位值</returns>        public decimal GetPKNum(string tablename)         {            switch (sqlType)            {                case "MSSQL2008":                    parameters = new List<DbParameter>();                    parameters.Add(new SqlParameter("@table_name", SqlDbType.VarChar, 50));                    parameters.Add(new SqlParameter("@key_value", SqlDbType.Decimal, 9));                    parameters[0].Value = tablename;                    parameters[1].Direction = ParameterDirection.Output;                    break;                case "Oracle":                    parameters = new List<DbParameter>();                    parameters.Add(new OracleParameter(":tb_name", Oracle.ManagedDataAccess.Client.OracleDbType.Varchar2, 50));                    parameters.Add(new OracleParameter(":key_value", Oracle.ManagedDataAccess.Client.OracleDbType.Decimal));                    parameters[0].Value = tablename;                    parameters[0].Direction = ParameterDirection.Input;                    parameters[1].Direction = ParameterDirection.Output;                    break;                default: break;            }            IDBHelper dbhelper = DBFactory.createDBHleper();            return dbhelper.RunProcedure(Utility.DB.PubConstant.ConnectionString,parameters, "up_get_table_key");        }

IDBHelper dbhelper = DBFactory.createDBHleper();是後台建立了一個dbhelp檔案，如果當時是Oracle資料庫  dbhelper 就為 OracleHelper檔案

此oracle 預存程序具有兩個參數，key_value 是返回參數out

Utility.DB.PubConstant.ConnectionString是資料庫連接字串

"up_get_table_key"為預存程序名稱

 

C# 擷取 oracle 預存程序的 傳回值1