protected IEnumerable allannouncementsgrid()
 {
     return(PXSelectJoinOrderBy <CRAnnouncement,
                                 LeftJoin <EPView, On <EPView.noteID, Equal <CRAnnouncement.noteID>,
                                                       And <EPView.status, Equal <EPViewStatusAttribute.Viewed>,
                                                            And <EPView.userID, Equal <Current <AccessInfo.userID> > > > > >,
                                 OrderBy <Asc <EPView.userID, Desc <EPActivity.createdDateTime> > > > .SelectWindowed(this, 0, 5));
 }
Exemplo n.º 2
0
        protected virtual IEnumerable scenarios()
        {
            foreach (PXResult <WZScenario, SiteMap> result in PXSelectJoinOrderBy
                     <WZScenario, LeftJoin <SiteMap, On <WZScenario.nodeID, Equal <SiteMap.nodeID> > >,
                      OrderBy <Asc <WZScenario.scenarioOrder> > > .Select(this))
            {
                WZScenario scenario = result;
                SiteMap    siteMap  = result;
                if (scenario.NodeID != null && siteMap.NodeID == null)
                {
                    siteMap.NodeID = scenario.NodeID;
                    WZScenario parentScenario =
                        PXSelect <WZScenario, Where <WZScenario.scenarioID, Equal <Required <WZScenario.scenarioID> > > >
                        .Select(this, scenario.NodeID);

                    if (parentScenario != null)
                    {
                        siteMap.Title = parentScenario.Name;
                    }
                }

                yield return(new PXResult <WZScenario, SiteMap>(scenario, siteMap));;
            }
        }