public MenuRightCheckDataModel CheckMenuRightByMenuID(MenuRightCheckParameter parameter) { this.ExecuteSQL = "SELECT CASE WHEN COUNT(1)>0 THEN TRUE ELSE FALSE END HaveRight FROM userright WHERE menuid=@MenuID AND userid=@UserID"; this.DataParameter = new IDbDataParameter[] { new SqlParameter("@UserID", parameter.UserID), new SqlParameter("@MenuID", parameter.MenuID) }; return(this.ExecuteReadSqlToMenuRightCheckDataModel()); }
public RespondMenuRightCheckViewModel CheckMenuRightByMenuID(RequestMenuRightCheckViewModel request) { var user = CPSSAuthenticate.GetCurrentUser(); return(MemcacheHelper.Get(() => { var parameter = new MenuRightCheckParameter { MenuID = request.MenuID, UserID = user.UserID }; var dataModel = this.mMenuRightCheckDataAccess.CheckMenuRightByMenuID(parameter); var result = new RespondMenuRightCheckViewModel { HaveRight = dataModel != null && dataModel.HaveRight }; return result; }, string.Format(preCacheKey, "CheckMenuRightByMenuID"), false, request.MenuID , user.UserID)); }