/// <summary>
/// 获取所有权限
/// </summary>
/// <returns>返回权限集合</returns>
public List<Competence> GetAllCompetence()
{
List<Competence> list = new List<Competence>();
try
{
string sql = "select * from Competence";
using (SqlDataReader reder = db.GetReader(sql))
{
while (reder.Read())
{
Competence c = new Competence((int)reder["CompetenceId"], (int)reder["ParentCompetenceId"], reder["CompetenceName"].ToString(), (int)reder["CompetenceMenu"]);
list.Add(c);
}
}
return list;
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
/// <summary>
/// 获取权限组的所有权限
/// </summary>
/// <param name="CompetenceId">权限组Id</param>
/// <param name="RoleId">权限组</param>
/// <returns>返回权限集合</returns>
public List<Competence> GetChildrenCompetence(int CompetenceId, int RoleId)
{
List<Competence> list = new List<Competence>();
try
{
string sql = "select * from vw_RoleCompetence where ParentCompetenceId=@CompetenceId and RoleId=@RoleId";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@CompetenceId", CompetenceId),
new SqlParameter("@RoleId", RoleId)
};
using (SqlDataReader reder = db.GetReader(sql, sp))
{
while (reder.Read())
{
Competence c = new Competence((int)reder["CompetenceId"], (int)reder["ParentCompetenceId"], reder["CompetenceName"].ToString(), (int)reder["MenuId"]);
list.Add(c);
}
}
return list;
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}