public bool IsScheduleReadyBySequencingStationId(int id) { PartSequencingDataContext dbSeq = new PartSequencingDataContext(); SequencingScheduleFactory maker = new SequencingScheduleFactory(); MesDataContext dbMes = new MesDataContext(); var seqStations = dbSeq.SequencingStationSettings.Where(i => i.SequencingLocationId == id).ToList(); if (seqStations.Count() > 0) { var seqStation = seqStations.FirstOrDefault(); if (seqStation != null) { var station = maker.UpdateNextBoxBySequencingId(seqStation.Id); if (!station.Status) { if (station.ItemsWaiting != 0) return false; } var scheduleStatus = dbSeq.SequencingStationLookups.Where(s => s.SequenceStationSettingsId == station.Id).FirstOrDefault(); var tokens = MessageTokensCacheManager.MessageTokens.Where(s => s.LineId == station.Line.Id || s.LineId == 4).ToList(); var lineBuffer = maker.GetSequencingBuffer(station); SequencingTrackingItem lastItem = null; var tracking = maker.GetSequencingHistory(station); if (tracking.Any()) lastItem = tracking.OrderByDescending(i => i.OrderId).First(); var lastJobId = Int32.MinValue; if (lastItem != null) lastJobId = lastItem.OrderId; if (lineBuffer != null) { var itemsinbox = station.PartsPerBox; var boxperschedule = station.BoxPerSchedule; var itemsinschedule = itemsinbox * boxperschedule; var jobs = lineBuffer.Where(i => i.OrderId >= station.NextBox.OrderId).Take(itemsinschedule).ToList(); if (itemsinschedule == jobs.Count()) return true; } } } return false; }
public TrimScheduleInfo GetTrimScheduleHistoryDetail(int locationId, int scheduleNum) { PartSequencingDataContext dbSeq = new PartSequencingDataContext(); ItemDetailsModel itemDetailsModel = new ItemDetailsModel(); SequencingScheduleFactory factory = new SequencingScheduleFactory(); var seqStation = dbSeq.SequencingStationSettings.Where(i => i.SequencingLocationId == locationId).FirstOrDefault(); var tokens = MessageTokensCacheManager.MessageTokens.Where(s => s.LineId == seqStation.LineId || s.LineId == 4).ToList(); var station = factory.UpdateNextBoxBySequencingId(seqStation.Id); TrimScheduleInfo trimHistorySchedule = null; if (station != null) { SequencingTrackingItem lastItem = null; var tracking = factory.GetSequencingHistory(station); if (tracking.Any()) { lastItem = tracking.OrderByDescending(i => i.OrderId).First(); if (lastItem != null) { var historyjobs = (from t in dbSeq.IWS_GetSequencingDetailHistoryBySeqSettingsIdAndScheduleNum(station.Id, scheduleNum) select new Seat { ScheduleNum = t.ScheduleNum, BoxNum = t.BoxNum, Complete = false, TrimStyle = GetOptionValue(t.ItemNumber.Trim(), 100), Colour = GetOptionValue(t.ItemNumber.Trim(), 101), ItemNumber = t.ItemNumber.Trim(), ItemType = t.ItemType.Trim(), DescLine1 = t.ItemNumber.Trim(), DescLine2 = factory.GetSequencingMessage(station, t.ItemNumber.Trim(), tokens), OrderId = t.OrderId, Item = itemDetailsModel.GetItemInfoByLineId(t.ItemNumber.Trim(), station.Line.Id) }).ToList(); //var historyjobs = (from t in tracking // select new Seat // { // Complete = false, // TrimStyle = GetOptionValue(t.ItemNumber.Trim(), 100), // Colour = GetOptionValue(t.ItemNumber.Trim(), 101), // ItemNumber = t.ItemNumber.Trim(), // ItemType = t.ItemType.Trim(), // DescLine1 = t.ItemNumber.Trim(), // DescLine2 = factory.GetSequencingMessage(station, t.ItemNumber.Trim(), tokens), // JobId = (int)t.JobId, // OrderId = t.OrderId, // Item = itemDetailsModel.GetItemInfoByLineId(t.ItemNumber.Trim(), station.Line.Id) // }).ToList(); var firstItem = historyjobs.FirstOrDefault(); trimHistorySchedule = new TrimScheduleInfo { Complete = true, ScheduleStatus = new TrimScheduleStatus { CurrentBoxNumber = firstItem == null ? 0 : firstItem.BoxNum, CurrentScheduleNumber = firstItem == null ? 0 : firstItem.ScheduleNum }, SeatSchedule = historyjobs, SummaryList = GetSummaryHeaderItems(historyjobs, station.Line.Id), }; return trimHistorySchedule; } } } return trimHistorySchedule; }
public TrimSchedule GetTrimSchedule(int id) { PartSequencingDataContext dbSeq = new PartSequencingDataContext(); SequencingScheduleFactory factory = new SequencingScheduleFactory(); MesDataContext dbMes = new MesDataContext(); ItemDetailsModel itemDetailsModel = new ItemDetailsModel(); TrimSchedule trimSchedule = null; List<Seat> offsetSeats = null; List<Seat> currentjobs = null; var seqStations = dbSeq.SequencingStationSettings.Where(i => i.SequencingLocationId == id).ToList(); if (seqStations.Count() > 0) { var seqStation = seqStations.FirstOrDefault(); if (seqStation != null) { var station = factory.UpdateNextBoxBySequencingId(seqStation.Id); var scheduleStatus = dbSeq.SequencingStationLookups.Where(s => s.SequenceStationSettingsId == station.Id).FirstOrDefault(); var tokens = MessageTokensCacheManager.MessageTokens.Where(s => s.LineId == station.Line.Id || s.LineId == 4).ToList(); var lineBuffer = factory.GetSequencingBuffer(station); if (lineBuffer != null) { var itemsinbox = station.PartsPerBox; var boxperschedule = station.BoxPerSchedule; var itemsinschedule = itemsinbox * boxperschedule; var boxqty = station.BoxQty; trimSchedule = new TrimSchedule { }; //trimSchedule.PreviousSchedule = new TrimScheduleInfo(); //SequencingTrackingItem lastItem = null; //var tracking = factory.GetSequencingHistory(station); //if (tracking.Any()) //{ // lastItem = tracking.OrderByDescending(i => i.OrderId).First(); // if (lastItem != null) // { // int previousScheduleNum = lastItem.ScheduleNum; // var previousjobs = (from t in tracking.Where(i=>i.ScheduleNum == previousScheduleNum) // select new Seat { // OrderNumber = t.OrderNumber, // OrderStatus = t.OrderStatus, // Complete = false, // TrimStyle = GetOptionValue(t.ItemNumber.Trim(), 100), // Colour = GetOptionValue(t.ItemNumber.Trim(), 101), // ItemNumber = t.ItemNumber.Trim(), // ItemType = t.ItemType.Trim(), // DescLine1 = t.ItemNumber.Trim(), // DescLine2 = factory.GetSequencingMessage(station, t.ItemNumber.Trim(), tokens), // JobId = (int)t.JobId, // OrderId = t.OrderId, // Item = itemDetailsModel.GetItemInfoByLineId(t.ItemNumber.Trim(), station.Line.Id) // }).ToList(); // trimSchedule.PreviousSchedule.SeatSchedule = previousjobs; // trimSchedule.PreviousSchedule.SummaryList = GetSummaryHeaderItems(previousjobs, station.Line.Id); // trimSchedule.PreviousSchedule.ScheduleStatus = new TrimScheduleStatus // { // CurrentBoxNumber = lastItem.BoxNum, // CurrentScheduleNumber = lastItem.ScheduleNum // }; // } //} //else //{ // trimSchedule.PreviousSchedule = null; //} var tracking = factory.GetSequencingHistory(station); if (tracking.Any()) { var lastTrackItem = tracking.LastOrDefault(); if (lastTrackItem != null) { if (lastTrackItem.Type == 2) { var lastRealJob = tracking.Where(o => o.OrderId < lastTrackItem.OrderId).OrderByDescending(f => f.OrderId).Where(x => x.ScheduleNum > 0).FirstOrDefault(); if (lastRealJob != null) { var unassignedBuffer = tracking.Where(o => o.OrderId <= lastTrackItem.OrderId && o.OrderId >lastRealJob.OrderId).OrderBy(f => f.OrderId).ToList(); if (unassignedBuffer.Count() > 0) { var offsetjobs = (from j in unassignedBuffer select new Seat { OrderStatus = (int)j.OrderStatus, Complete = false, TrimStyle = GetOptionValue(j.ItemNumber.Trim(), 100), Colour = GetOptionValue(j.ItemNumber.Trim(), 101), OrderNumber = j.OrderNumber == null ? "" : j.OrderNumber.Trim(), ItemNumber = j.ItemNumber.Trim(), ItemType = j.ItemType.Trim(), DescLine1 = j.ItemNumber.Trim(), DescLine2 = factory.GetSequencingMessage(station, j.ItemNumber.Trim(), tokens), JobId = (int)j.JobId, OrderId = j.OrderId, Item = itemDetailsModel.GetItemInfoByLineId(j.ItemNumber.Trim(), station.Line.Id) }).ToList(); offsetSeats = offsetjobs; } } } } } if (station.SequencingLocation.ParentId == null) { currentjobs = (from j in lineBuffer.Where(i => i.OrderId >= station.NextBox.OrderId).Take(itemsinschedule).ToList() select new Seat { OrderStatus = (int)j.OrderStatus, Complete = false, TrimStyle = GetOptionValue(j.ItemNumber.Trim(), 100), Colour = GetOptionValue(j.ItemNumber.Trim(), 101), OrderNumber = j.OrderNumber == null ? "" : j.OrderNumber.Trim(), ItemNumber = j.ItemNumber.Trim(), ItemType = j.ItemType.Trim(), DescLine1 = j.ItemNumber.Trim(), DescLine2 = factory.GetSequencingMessage(station, j.ItemNumber.Trim(), tokens), JobId = (int)j.JobId, OrderId = j.OrderId, Item = itemDetailsModel.GetItemInfoByLineId(j.ItemNumber.Trim(), station.Line.Id), }).OrderBy(s => s.OrderId).ToList(); } else //from queue { currentjobs = (from j in lineBuffer.Where(i => i.OrderId >= station.NextBox.OrderId).Take(itemsinschedule).ToList() select new Seat { ScheduleNum = j.ScheduleNum, BoxNum = j.BoxNum, OrderStatus = (int)j.OrderStatus, Complete = false, TrimStyle = GetOptionValue(j.ItemNumber.Trim(), 100), Colour = GetOptionValue(j.ItemNumber.Trim(), 101), OrderNumber = j.OrderNumber == null ? "" : j.OrderNumber.Trim(), ItemNumber = j.ItemNumber.Trim(), ItemType = j.ItemType.Trim(), DescLine1 = j.ItemNumber.Trim(), DescLine2 = factory.GetSequencingMessage(station, j.ItemNumber.Trim(), tokens), JobId = (int)j.JobId, OrderId = j.OrderId, Item = itemDetailsModel.GetItemInfoByLineId(j.ItemNumber.Trim(), station.Line.Id), }).OrderBy(s => s.OrderId).ToList(); } //var currentjobs = (from j in lineBuffer.Where(i => i.OrderId >= station.NextBox.OrderId).Take(itemsinschedule).ToList() // select new Seat { // OrderStatus = (int)j.OrderStatus, // Complete = false, // TrimStyle = GetOptionValue(j.ItemNumber.Trim(), 100), // Colour = GetOptionValue(j.ItemNumber.Trim(), 101), // OrderNumber = j.OrderNumber == null ? "" : j.OrderNumber.Trim(), // ItemNumber = j.ItemNumber.Trim(), // ItemType = j.ItemType.Trim(), // DescLine1 = j.ItemNumber.Trim(), // DescLine2 = factory.GetSequencingMessage(station, j.ItemNumber.Trim(), tokens), // JobId = (int)j.JobId, // OrderId = j.OrderId, // Item = itemDetailsModel.GetItemInfoByLineId(j.ItemNumber.Trim(), station.Line.Id), // }).OrderBy(s=>s.OrderId).ToList(); if (currentjobs.Count() != itemsinschedule) return null; //var lastcurrentjob = currentjobs.Last(); //var nextjobs = (from j in lineBuffer.Where(i => i.OrderId > lastcurrentjob.OrderId).Take(itemsinschedule).ToList() // select new Seat // { // OrderStatus = (int)j.OrderStatus, // Complete = false, // TrimStyle = GetOptionValue(j.ItemNumber.Trim(), 100), // Colour = GetOptionValue(j.ItemNumber.Trim(), 101), // OrderNumber = j.OrderNumber == null ? "" : j.OrderNumber.Trim(), // ItemNumber = j.ItemNumber.Trim(), // ItemType = j.ItemType.Trim(), // DescLine1 = j.ItemNumber.Trim(), // DescLine2 = factory.GetSequencingMessage(station, j.ItemNumber.Trim(), tokens), // JobId = (int)j.JobId, // OrderId = j.OrderId, // Item = itemDetailsModel.GetItemInfoByLineId(j.ItemNumber.Trim(), station.Line.Id) // }).OrderBy(s => s.OrderId).ToList(); //if (nextjobs.Count() == itemsinschedule) //{ // trimSchedule.NextSchedule = new TrimScheduleInfo // { // Complete = false, // SeatSchedule = nextjobs, // SummaryList = GetSummaryHeaderItems(nextjobs, station.Line.Id), // ScheduleStatus = new TrimScheduleStatus // { // CurrentBoxNumber = (scheduleStatus.NextBoxNum + 1) > boxqty ? 1 : scheduleStatus.NextBoxNum + 1, // CurrentScheduleNumber = scheduleStatus.NextScheduleNum + 1 // } // }; //} //else //{ // trimSchedule.NextSchedule = null; //} //for (int i = 0; i < nextjobs.Count(); i++) // nextjobs[i].Index = i; for(int i=0; i<currentjobs.Count(); i++) currentjobs[i].Index = i; trimSchedule.CurrentSchedule = new TrimScheduleInfo { Complete = false, SeatSchedule = currentjobs, SummaryList = GetSummaryHeaderItems(currentjobs, station.Line.Id), ScheduleStatus = GetTrimScheduleStatus(station, scheduleStatus, currentjobs), OffsetSeats = offsetSeats }; return trimSchedule; } } } return null; }