public List<LeftNavMenuDataModel> GetLeftNavMenuDataModels(LeftNavMenuParameter parameter) { //需要联查权限表 this.ExecuteSQL = "SELECT * FROM menu WHERE IsEnabled=1 /*AND UserID=@UserID*/ ORDER BY classid ASC"; this.DataParameter = new IDbDataParameter[] { new SqlParameter("@UserID", parameter.UserID) }; return this.ExecuteReadSqlToLeftNavMenuDataModelList(); }
public List <RespondPanelViewModel> GetLeftNavMenuDataModels() { var parameter = new LeftNavMenuParameter { UserID = this.mSigninUser.UserID }; //TODO 配置菜单权限是需要清除当前的用户的菜单缓存 return(MemcacheHelper.Get(new RequestMemcacheParameter <List <RespondPanelViewModel> > { CacheKey = string.Format(PRE_CACHE_KEY, "GetLeftNavMenuDataModels"), #region =============================== CallBackFunc = () => { var dataModels = this.mLeftNavMenuDataAccess.GetLeftNavMenuDataModels(parameter); var viewModels = dataModels .Where(dataModel => dataModel.parentid == "000001") .Select(dataModel => new RespondPanelViewModel { IconCls = dataModel.iconcls, Title = dataModel.title, Menus = dataModels .Where(_dataModel => _dataModel.parentid == dataModel.classid) .Select(_dataModel => new RespondMenuViewModel { IconCls = _dataModel.iconcls, Title = _dataModel.title, Url = _dataModel.url, ButtonID = _dataModel.buttonid, MenuID = _dataModel.menuid, ClassID = _dataModel.classid, }) .ToList() }).ToList(); return viewModels; }, #endregion ExpiresAt = DateTime.Now.AddMinutes(30), ManageCacheKeyForKey = THISSERVICE_PRE_CACHE_KEY_MANAGE, ParamsKeys = new object[] { this.mSigninUser.UserID } })); }