Пример #1
0
        protected IEnumerable items()
        {
            string actionName = CRMassProcessingAttribute.GetSelectedAction(Items.View);

            if (CRMergeAttribute.IsMergeAction(actionName))
            {
                return(new PXSelectJoin <CRContactBatch,
                                         LeftJoin <CRLeadBatch, On <CRLeadBatch.contactID, Equal <CRContactBatch.contactID> >,
                                                   LeftJoin <BAccount, On <CRContactBatch.bAccountID, Equal <BAccount.bAccountID> >,
                                                             LeftJoin <Address, On <Address.addressID, Equal <CRContactBatch.defAddressID> > > > >,
                                         Where <CRContactBatch.contactType, Equal <ContactTypes.person>,
                                                And <Where <CRContactBatch.bAccountID, NotEqual <Current <Company.bAccountID> >,
                                                            Or <CRContactBatch.bAccountID, IsNull> > > > >(this).Select());
            }
            if (CRUpdateAttribute.IsUpdateAction(actionName))
            {
                return(new PXSelectJoin <CRContactBatch,
                                         InnerJoin <CRLeadBatch, On <CRLeadBatch.contactID, Equal <CRContactBatch.contactID> >,
                                                    LeftJoin <Address, On <Address.addressID, Equal <CRLeadBatch.defAddressID> > > >,
                                         Where <CRLeadBatch.bAccountID, IsNull> >(this).Select());
            }
            if (actionName == ASSIGNLEADS_ACTIONNAME)
            {
                return(new PXSelectJoin <CRContactBatch,
                                         InnerJoin <CRLeadBatch, On <CRLeadBatch.contactID, Equal <CRContactBatch.contactID> >,
                                                    LeftJoin <Address, On <Address.addressID, Equal <CRLeadBatch.defAddressID> > > >,
                                         Where <CRLeadBatch.workgroupID, IsNull> >(this).Select());
            }
            return(new PXResultset <CRContactBatch, CRLeadBatch, BAccount, Address>());
        }
Пример #2
0
        protected IEnumerable leadItems()
        {
            string actionName = CRMassProcessingAttribute.GetSelectedAction(Items.View);

            if (CRMergeAttribute.IsMergeAction(actionName) || CRUpdateAttribute.IsUpdateAction(actionName))
            {
                return(new PXSelect <CRLeadBatch, Where <CRLeadBatch.bAccountID, IsNull> >(this).Select());
            }
            if (actionName == ASSIGNLEADS_ACTIONNAME)
            {
                return(new PXSelect <CRLeadBatch, Where <CRLeadBatch.workgroupID, IsNull> >(this).Select());
            }
            return(new PXResultset <CRLeadBatch>());
        }