예제 #1
0
        /// <summary>
        /// 带参数的存储过程,返回DataTable
        /// </summary>
        /// <param name="ProcName">存储过程名称</param>
        /// <param name="parameters">参数集合</param>
        /// <returns>返回datatable对象</returns>
        public DataTable RunProcedure2DT(string ProcName, OracleParameter[] parameters)
        {
            DataTable    dt;
            Oracledbhelp db = new Oracledbhelp();

            try
            {
                DataSet da = db.RunProcedure(ProcName, parameters, "t1");

                dt = da.Tables["t1"];
            }
            catch (Exception e)
            {
                // HGERROR.log(e + "存储过程:" + ProcName);

                dt = null;
            }
            finally
            {
                db.Close();
                db = null;
            }
            if (dt == null)
            {
                dt = new DataTable();
            }
            return(dt);
        }
예제 #2
0
        /// <summary>
        /// 返回存储过程的输出字符串
        /// </summary>
        /// <param name="ProcName"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public string RunProcedure2OutString(string ProcName, OracleParameter[] parameters)
        {
            string       outpar = "";
            Oracledbhelp db     = new Oracledbhelp();

            try
            {
                db.RunProcedure(ProcName, parameters);
                outpar = (string)parameters[parameters.Length - 1].Value.ToString();
            }
            catch (Exception e)
            {
            }
            finally
            {
                db.Close();
                db = null;
            }
            return(outpar);
        }