数据库存储过程调用广法

本文链接：https://blog.csdn.net/sscsgss/article/details/4833135

/// <summary>
/// 读出菜单　

   /// </summary>
        /// <param name="_username">用户</param>
        /// <returns>菜单</returns>
        public DataTable getMenu(string _username)
        {
            OracleConnection orcn = new OracleConnection(PConn);

            orcn.Open();
            OracleTransaction trans = orcn.BeginTransaction();
            //OracleCommand cmd = new OracleCommand("p_getusrallmnulst", orcn);
            OracleCommand cmd = new OracleCommand("p_getusermenulist", orcn);
            cmd.Transaction = trans;
            cmd.CommandType = CommandType.StoredProcedure;

            OracleParameter p_menuid = new OracleParameter("p_menuid", OracleType.VarChar);
            p_menuid.Direction = ParameterDirection.Input;
            p_menuid.Value = "0.0001";
            cmd.Parameters.Add(p_menuid);

            OracleParameter p_username = new OracleParameter("p_username", OracleType.VarChar);
            p_username.Direction = ParameterDirection.Input;
            p_username.Value = _username;
            cmd.Parameters.Add(p_username);

            //OracleParameter p_statue = new OracleParameter("p_statue", OracleType.VarChar);
            //p_statue.Direction = ParameterDirection.Input;
            //p_statue.Value = "2";
            //cmd.Parameters.Add(p_statue);

            20090219 add by ted
            //if (DNET.conifgs.portal == "2")
            //{
            //    OracleParameter p_isweb = new OracleParameter("p_isweb", OracleType.VarChar);
            //    p_isweb.Direction = ParameterDirection.Input;
            //    p_isweb.Value = "1";
            //    cmd.Parameters.Add(p_isweb);
            //}
            20090219 add by ted

            OracleParameter out_presult = new OracleParameter("out_presult", OracleType.Cursor);
            out_presult.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(out_presult);

OracleDataAdapter da = new OracleDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds, "T_MENU");

trans.Commit();
da.Dispose();

            cmd.Dispose();
            orcn.Close();
            return ds.Tables["T_MENU"];
        }