public List <MenuTableMap> MenuTables()
{
var userId = mContext["UserId"].ToString();
var userName = mContext["UserName"].ToString();
if (userName == "admin")
{
return(AllMenuTables());
}
else
{
var sql = string.Format(@"select menu.* from _MenuTableMap menu right join _AccessRight access on menu._group = access._group and menu._name = access._name
where access._id = {0} and access._mask > 0 order by _group,_index", userId);
var dt = DBHelper.GetInstance(mContext).ExecuteDt(sql);
var lst = EntityConvertor <MenuTableMap> .ToList(dt);
return(lst);
}
}
