/// <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"];
}