//根据用户的查看权限显示菜单标题栏
private void MenuRole()
{
string strSql = "SELECT rp.SUB_ID,s.SUB_NAME,s.SUB_FATHER_ID " +
"FROM sys_sub s ,sys_rolepermission rp , sys_client_user u " +
"WHERE s.SUB_ID = rp.SUB_ID " +
"AND rp.ROLE_ID = u.ROLE_ID " +
"AND u.RECO_PKID = " + (Application.Current.Resources["User"] as UserInfo).ID +
" order by rp.SUB_ID";
DataTable table = dbHelper.GetDataSet(strSql).Tables[0];
subList.Clear();
for (int i = 0; i < table.Rows.Count; i++)
{
SubInfo info = new SubInfo();
info.SubId = table.Rows[i][0].ToString();
info.SubName = table.Rows[i][1].ToString();
info.SubFatherId = table.Rows[i][2].ToString();
subList.Add(info);
}
//第一层菜单
var subFatherArray = (from c in subList where (c.SubFatherId == '0'.ToString())select new { c.SubId, c.SubName }).ToArray();
for (int i = 0; i < subFatherArray.Length; i++)
{
string subid = subFatherArray[i].SubId;
//第二层菜单
subChildList = (from t in subList where (t.SubFatherId == subid.ToString()) select t.SubName).ToList();
FatherMenuTitle fathermenu = new FatherMenuTitle(subFatherArray[i].SubName, subChildList);
menuTitles.Add(fathermenu);
}
}
//根据用户的查看权限显示菜单标题栏
private void MenuRole()
{
string strSql = "SELECT rp.SUB_ID,s.SUB_NAME,s.SUB_FATHER_ID " +
"FROM sys_sub s ,sys_rolepermission rp , sys_client_user u "+
"WHERE s.SUB_ID = rp.SUB_ID " +
"AND rp.ROLE_ID = u.ROLE_ID " +
"AND u.RECO_PKID = " + (Application.Current.Resources["User"] as UserInfo).ID +
" order by rp.SUB_ID";
DataTable table = dbHelper.GetDataSet(strSql).Tables[0];
subList.Clear();
for (int i = 0; i < table.Rows.Count; i++)
{
SubInfo info = new SubInfo();
info.SubId = table.Rows[i][0].ToString();
info.SubName = table.Rows[i][1].ToString();
info.SubFatherId = table.Rows[i][2].ToString();
subList.Add(info);
}
//第一层菜单
var subFatherArray = (from c in subList where (c.SubFatherId == '0'.ToString()) select new { c.SubId, c.SubName }).ToArray();
for (int i = 0; i < subFatherArray.Length; i++)
{
string subid = subFatherArray[i].SubId;
//第二层菜单
subChildList = (from t in subList where (t.SubFatherId == subid.ToString()) select t.SubName).ToList();
FatherMenuTitle fathermenu = new FatherMenuTitle(subFatherArray[i].SubName,subChildList);
menuTitles.Add(fathermenu);
}
}
