/// <summary>
/// 获取某菜单的子级菜单
/// </summary>
/// <param name="MenuId">菜单Id</param>
/// <returns>返回菜单集合</returns>
public List<Menu> GetChildMenu(int MenuId)
{
List<Menu> list = new List<Menu>();
try
{
string sql = "select * from Menu where ParentMenuId =@MenuId";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@MenuId",MenuId)
};
using (SqlDataReader reder = db.GetReader(sql, sp))
{
while (reder.Read())
{
Menu me = new Menu((int)reder["MenuId"], (int)reder["ParentMenuId"], reder["MenuName"].ToString(), reder["MenuURL"].ToString());
list.Add(me);
}
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
return list;
}
/// <summary>
/// 获取所有菜单
/// </summary>
/// <returns>返回菜单集合</returns>
public List<Menu> GetAllMenu()
{
List<Menu> list = new List<Menu>();
try
{
string sql = "select * from Menu";
using (SqlDataReader reder = db.GetReader(sql))
{
while (reder.Read())
{
Menu me = new Menu((int)reder["MenuId"], (int)reder["ParentMenuId"], reder["MenuName"].ToString(), reder["MenuURL"].ToString());
list.Add(me);
}
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
return list;
}
/// <summary>
/// 获取菜单
/// </summary>
/// <param name="RoleId">权限组Id</param>
/// <returns>返回菜单集合</returns>
public List<Menu> GetAllMenu(int RoleId)
{
List<Menu> list = new List<Menu>();
try
{
string sql = "select * from vw_RoleCompetence where MenuId>0 and RoleId =" + RoleId;
using (SqlDataReader reder = db.GetReader(sql))
{
while (reder.Read())
{
Menu c = new Menu((int)reder["MenuId"], (int)reder["ParentMenuId"], reder["MenuName"].ToString(), reder["MenuURL"].ToString());
list.Add(c);
}
}
return list;
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
