Ejemplo n.º 1
0
        public IEnumerable aMBomCostSummary(RollupSettings _setting, IQueryable <AMBomItem> _bomItem)
        {
            // Delete All Data By User
            PXDatabase.Delete <AMBomCost>(new PXDataFieldRestrict <AMBomCost.userID>(Accessinfo.UserID));

            // Get All BOM Data
            int    count    = 0;
            string errorMsg = string.Empty;

            Settings.Current = _setting.DeepClone();
            List <object> result = new List <object>();

            foreach (var _bom in _bomItem)
            {
                try
                {
                    result.Add(DoingCostRoll(_bom));
                }
                catch (Exception ex)
                {
                    errorMsg += $"Error:{ex.Message} BOMID:{_bom.BOMID} Revision:{_bom.RevisionID}\n";
                }
            }
            // write Error Msg
            if (string.IsNullOrEmpty(errorMsg))
            {
                PXProcessing.SetWarning(errorMsg);
            }

            BomCostRecs.Cache.Clear();
            result.ForEach(x => { BomCostRecs.Cache.Insert(x); });
            Actions.PressSave();
            return(null);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Override the parent method to add additional conditions to control the cost round-up logic.
        /// </summary>
        public override List <AMMultiLevelBomData> RollCostUpdate(List <AMMultiLevelBomData> multiLevelBomRecs)
        {
            List <AMMultiLevelBomData> list = new List <AMMultiLevelBomData>();
            RollBomList      rollBomList    = new RollBomList();
            HashSet <string> hashSet        = new HashSet <string>();

            using (List <AMMultiLevelBomData> .Enumerator enumerator = multiLevelBomRecs.GetEnumerator())
            {
                for (; ;)
                {
                    AMMultiLevelBomData ammultiLevelBomData;
                    if (4 != 0)
                    {
                        if (!enumerator.MoveNext())
                        {
                            break;
                        }
                        ammultiLevelBomData = enumerator.Current;
                        string item = string.Join(":", new string[]
                        {
                            ammultiLevelBomData.LineBOMID,
                            ammultiLevelBomData.LineRevisionID
                        });
                        if (!hashSet.Add(item))
                        {
                            continue;
                        }
                    }
                    bool?isHeaderRecord = ammultiLevelBomData.IsHeaderRecord;
                    bool flag           = true;
                    bool flag2          = isHeaderRecord.GetValueOrDefault() == flag & isHeaderRecord != null;
                    while (!flag2 && ammultiLevelBomData.InventoryID != null)
                    {
                        AMBomItem ambomItem = (AMBomItem)this.Caches <AMBomItem>().Locate(new AMBomItem
                        {
                            BOMID      = ammultiLevelBomData.LineBOMID,
                            RevisionID = ammultiLevelBomData.LineRevisionID
                        });
                        if (ambomItem == null)
                        {
                            if (false)
                            {
                                goto IL_136;
                            }
                            ambomItem = PXSelect <AMBomItem, Where <AMBomItem.bOMID, Equal <Required <AMBomItem.bOMID> >,
                                                                    And <AMBomItem.revisionID, Equal <Required <AMBomItem.revisionID> > > > > .Select(this, new object[] {
                                ammultiLevelBomData.LineBOMID,
                                ammultiLevelBomData.LineRevisionID
                            });
                        }
                        flag2 = rollBomList.Add(ambomItem, ammultiLevelBomData.Level.GetValueOrDefault(), false);
                        if (!false)
                        {
                            break;
                        }
                    }
                }
                IL_136 :;
            }
            LumCostRoll bomcostRoll = PXGraph.CreateInstance <LumCostRoll>();

            RollupSettings value = new RollupSettings
            {
                SnglMlti                  = "M",
                SiteID                    = null,
                InventoryID               = this.Filter.Current.InventoryID,
                SubItemID                 = null,
                BOMID                     = this.Filter.Current.BOMID,
                RevisionID                = this.Filter.Current.RevisionID,
                EffectiveDate             = this.Filter.Current.BOMDate,
                IncMatScrp                = new bool?(true),
                IncFixed                  = new bool?(true),
                UpdateMaterial            = new bool?(false),
                UsePending                = new bool?(false),
                IgnoreMinMaxLotSizeValues = this.Filter.Current.IgnoreMinMaxLotSizeValues
            };

            bomcostRoll.Settings.Current = value;
            bomcostRoll.RollCosts(rollBomList, Filter.Current.GetExtension <AMMultiLevelBomFilterExt>().UsrEnblItemRoundUp.GetValueOrDefault());

            foreach (AMMultiLevelBomData ammultiLevelBomData2 in multiLevelBomRecs)
            {
                AMBomCost bomCostRec = null;
                if (!string.IsNullOrWhiteSpace(ammultiLevelBomData2.ManufacturingBOMID) && (6 == 0 || !string.IsNullOrWhiteSpace(ammultiLevelBomData2.ManufacturingRevisionID)))
                {
                    bomCostRec = (AMBomCost)bomcostRoll.Caches <AMBomCost>().Locate(new AMBomCost
                    {
                        BOMID      = ammultiLevelBomData2.ManufacturingBOMID,
                        RevisionID = ammultiLevelBomData2.ManufacturingRevisionID,
                        UserID     = new Guid?(bomcostRoll.Accessinfo.UserID)
                    });
                }
                AMMultiLevelBomData ammultiLevelBomData3 = this.RollCostUpdate(ammultiLevelBomData2, bomCostRec);

                if (ammultiLevelBomData3 != null)
                {
                    list.Add(ammultiLevelBomData3);
                }
            }
            return(list);
        }
Ejemplo n.º 3
0
        public virtual List <LUMStdBomCost> RollCostUpdate(List <LUMStdBomCost> multiLevelBomRecs)
        {
            var       newMultiLevelBomRecs = new List <LUMStdBomCost>();
            var       rollBomList          = new RollBomList();
            var       uniqueBoms           = new HashSet <string>();
            AMBomItem bomItem;

            foreach (var multiLevelRecord in multiLevelBomRecs)
            {
                var bomKey = string.Join(":", multiLevelRecord.LineBOMID, multiLevelRecord.LineRevisionID);

                if (!uniqueBoms.Add(bomKey) || multiLevelRecord.IsHeaderRecord == true || multiLevelRecord.InventoryID == null)
                {
                                        //Repeat bom/rev
                                        continue;
                }

                bomItem = (AMBomItem)this.Caches <AMBomItem>().Locate(new AMBomItem {
                    BOMID = multiLevelRecord.LineBOMID, RevisionID = multiLevelRecord.LineRevisionID
                });
                if (bomItem == null)
                {
                    bomItem = PXSelect <AMBomItem, Where <AMBomItem.bOMID, Equal <Required <AMBomItem.bOMID> >,
                                                          And <AMBomItem.revisionID, Equal <Required <AMBomItem.revisionID> > > > > .Select(this, multiLevelRecord.LineBOMID, multiLevelRecord.LineRevisionID);
                }

                rollBomList.Add(bomItem, multiLevelRecord.Level.GetValueOrDefault(), false);
            }

            var costRollGraph  = CreateInstance <LumCostRoll>();
            var costRollFilter = new RollupSettings
            {
                SnglMlti                  = "M",
                SiteID                    = null,
                InventoryID               = Filter.Current.InventoryID,
                SubItemID                 = null,
                BOMID                     = Filter.Current.BOMID,
                RevisionID                = Filter.Current.RevisionID,
                EffectiveDate             = Filter.Current.BOMDate,
                IncMatScrp                = true,
                IncFixed                  = true,
                UpdateMaterial            = false,
                UsePending                = false,
                IgnoreMinMaxLotSizeValues = Filter.Current.IgnoreMinMaxLotSizeValues
            };

            costRollGraph.Settings.Current = costRollFilter;
            costRollGraph.RollCosts(rollBomList, Filter.Current.GetExtension <AMMultiLevelBomFilterExt>().UsrEnblItemRoundUp.GetValueOrDefault());

            foreach (var mutliLevelRecord in multiLevelBomRecs)
            {
                AMBomCost bomCostRec = null;

                if (!string.IsNullOrWhiteSpace(mutliLevelRecord.ManufBOMID) && !string.IsNullOrWhiteSpace(mutliLevelRecord.ManufRevisionID))
                {
                    bomCostRec = (AMBomCost)costRollGraph.Caches <AMBomCost>().Locate(new AMBomCost
                    {
                        BOMID      = mutliLevelRecord.ManufBOMID,
                        RevisionID = mutliLevelRecord.ManufRevisionID,
                        UserID     = costRollGraph.Accessinfo.UserID
                    });
                }

                var row = RollCostUpdate(mutliLevelRecord, bomCostRec);

                if (row == null)
                {
                    continue;
                }

                newMultiLevelBomRecs.Add(row);
            }
            return(newMultiLevelBomRecs);
        }