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); } }