private TrimScheduleStatus GetTrimScheduleStatus(SequencingStation station, SequencingStationLookup lookup, List<Seat> seatSchedule) { TrimScheduleStatus status = new TrimScheduleStatus(); if (station.SequencingLocation.ParentId == null) { status.CurrentBoxNumber = lookup.NextBoxNum; status.CurrentScheduleNumber = lookup.NextScheduleNum; } else //from queue table { var firstjob = seatSchedule.FirstOrDefault(); if (firstjob != null) { status.CurrentBoxNumber = firstjob.BoxNum; status.CurrentScheduleNumber = firstjob.ScheduleNum; } else { status.CurrentBoxNumber = lookup.NextBoxNum; status.CurrentScheduleNumber = lookup.NextScheduleNum; } } return status; }
public SequencingStation UpdateNextBoxBySequencingId(int id) { PartSequencingDataContext dbSeq = new PartSequencingDataContext(); MesDataContext dbMes = new MesDataContext(); PlasticSeqDatabase dbPlasticSeq = new PlasticSeqDatabase(); SequencingTrackingItem lastItem = null; SequencingTrackingItem firstItem = null; var station = (from s in SequencingSettingsCacheManager.SequencingStationSettings where s.Obsolete == false && s.Id == id select new SequencingStation { Description = s.Description, ScheduleAvailable = false, ItemsWaiting = 0, ItemsWaitingPercentage = 0, Id = s.Id, SequencingLocation = dbSeq.SequencingLocations.Where(x => x.Id == s.SequencingLocationId).Single(), Line = dbSeq.Lines.Where(x => x.Id == s.LineId).Single(), Station = dbPlasticSeq.GetStation((int)s.StationId), StationOrder = (int)s.StationOrder, BoxPerSchedule = (int)s.BoxPerSchedule, BoxQty = (int)s.BoxQty, MessageFormat = s.MessageFormat, Obsolete = (bool)s.Obsolete, PartsPerBox = (int)s.PartsPerBox, SeatOptions = (int)s.SeatOptions, SeatOptions2Check = (int)s.SeatOptions2Check, BaseStation = SequencingSettingsCacheManager.SequencingStationSettings.Where(i=>i.Id == SequencingSettingsCacheManager.BaseSequencingStationOffsets.Where(x=>x.LineId == s.LineId).Single().SequencingStationSettingsId).Single(), Offset = (int)s.Offset, }).Single(); var tracking = GetSequencingHistory(station); var lineBuffer = GetSequencingBuffer(station); var minBuffer = lineBuffer.OrderBy(j => j.OrderId).FirstOrDefault(); var scheduleStatus = dbSeq.SequencingStationLookups.Where(s => s.SequenceStationSettingsId == station.Id).FirstOrDefault(); if (tracking.Any()) { lastItem = tracking.OrderByDescending(j => j.OrderId).First(); firstItem = tracking.OrderBy(j => j.OrderId).First(); } station.NextBox = new SequenceBox(); if (scheduleStatus == null) { int nextOrderId = Int16.MinValue; if (lineBuffer.Count() > 0) nextOrderId = lineBuffer.First().OrderId; if (lastItem != null) { if (lastItem.OrderId > nextOrderId) { nextOrderId = lastItem.OrderId + 1; } } scheduleStatus = new SequencingStationLookup { SequenceStationSettingsId = station.Id, NextBoxNum = 1, NextScheduleNum = 1, NextOrderId = nextOrderId }; station.NextBox.BoxNum = scheduleStatus.NextBoxNum; station.NextBox.OrderId = scheduleStatus.NextOrderId; station.NextBox.ScheduleNum = scheduleStatus.NextScheduleNum; SetScheduleAvailable(station, lineBuffer.Count()); dbSeq.SequencingStationLookups.InsertOnSubmit(scheduleStatus); dbSeq.SubmitChanges(); } else { if (lastItem != null) { if (lastItem.Type == 2) { var lastRealJob = tracking.Where(o => o.OrderId < lastItem.OrderId).OrderByDescending(f => f.OrderId).Where(x => x.ScheduleNum > 0).FirstOrDefault(); if (lastRealJob != null) { station.NextBox.ScheduleNum = lastRealJob.ScheduleNum + 1; station.NextBox.BoxNum = lastRealJob.BoxNum + 1; station.NextBox.OrderId = lastItem.OrderId + 1; } else { station.NextBox.ScheduleNum = scheduleStatus.NextScheduleNum; station.NextBox.BoxNum = scheduleStatus.NextBoxNum; station.NextBox.OrderId = lastItem.OrderId + 1; } } else { if ((lastItem.BoxNum + station.BoxPerSchedule) > station.BoxQty) station.NextBox.BoxNum = 1; else station.NextBox.BoxNum = (lastItem.BoxNum + 1); station.NextBox.ScheduleNum = lastItem.ScheduleNum + 1; station.NextBox.OrderId = lastItem.OrderId + 1; } } else { if (minBuffer != null) { station.NextBox.OrderId = minBuffer.OrderId; station.NextBox.BoxNum = 1; station.NextBox.ScheduleNum = 1; } else { station.NextBox.OrderId = scheduleStatus.NextOrderId; station.NextBox.BoxNum = scheduleStatus.NextBoxNum; station.NextBox.ScheduleNum = scheduleStatus.NextScheduleNum; } } scheduleStatus.NextBoxNum = station.NextBox.BoxNum; scheduleStatus.NextScheduleNum = station.NextBox.ScheduleNum; scheduleStatus.NextOrderId = station.NextBox.OrderId; dbSeq.SubmitChanges(); var validBuffer = (from l in lineBuffer where l.OrderId >= station.NextBox.OrderId select l).ToList(); SetScheduleAvailable(station, validBuffer.Count()); } return station; }