/// <summary>
/// 所有权限配置同时带页面对象(包含隐藏页面)<para/>
/// 隐藏页面的权限为父级页面的权限
/// </summary>
/// <returns></returns>
public IList <MR_PageInfo> GetAllList()
{
var dt = SQLHelpers.TcAdmin().ExecuteFillDataTable(@"
SELECT r.AID,r.BtnRightExp,p.* FROM R_AdminRight r
left join R_PageInfo p on p.PID=r.PID
union all
SELECT r.AID,r.BtnRightExp,p.* FROM R_AdminRight r
left join R_PageParent pp on r.PID=pp.ParentID
left join R_PageInfo p on pp.PID=p.PID
where pp.ParentID is not null
");
return(ModelConvertHelper <MR_PageInfo> .ToModels(dt));
}
public List <SelectItem> GetList(string sqlcomand, SqlConnection con)
{
SqlCommand cmd = new SqlCommand(sqlcomand, con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);//填充数据
if (ds.Tables[0] != null)
{
return(ModelConvertHelper <SelectItem> .ToModels(ds.Tables[0]) as List <SelectItem>);
}
else
{
return(null);
}
}
