public PalletChange GetPalletChange(int palletId) { DispositionDataContext db = new DispositionDataContext(); IntegramMESDataContext trackDb = new IntegramMESDataContext(); MesDataContext dbMes = new MesDataContext(); ItemDetailsModel itemDetailModel = new ItemDetailsModel(); ReworkFactory reworkFactory = new ReworkFactory(); var palletHdr = (from p in dbMes.PalletInfos where p.PalletNbr == palletId && (p.Pallet_Type == "S1" || p.Pallet_Type == "S2") select p).FirstOrDefault(); if (palletHdr == null) return null; var jobInfo = (from j in dbMes.MasterJobTables where j.Job_ID == palletHdr.Job_ID select j).FirstOrDefault(); if (jobInfo == null) return null; var item = itemDetailModel.GetItemInfo(jobInfo.SKU); var convertSkuInfo = reworkFactory.GetSkuInfo(item).OrderBy(s=>s.PartIndex).ToList(); var palletChangeHistory = trackDb.PalletChangeHistories.Where(p => p.JobId == jobInfo.Job_ID).ToList(); PalletChange palletChange = new PalletChange { PalletId = palletId, Sku = jobInfo.SKU, JobId = jobInfo.Job_ID, OrderNumber = jobInfo.Order_Nbr, SkuInfo = convertSkuInfo, FinishDTM = (DateTime)jobInfo.FinishBld_DTTM, PalletChangeHistory = palletChangeHistory }; return palletChange; }
public List<SkuInfo> GetSkuInfo(string sku) { ItemDetailsModel itemDetailModel = new ItemDetailsModel(); ReworkFactory reworkFactory = new ReworkFactory(); var item = itemDetailModel.GetItemInfo(sku); if (item == null) return null; var convertSkuInfo = reworkFactory.GetSkuInfo(item).OrderBy(s => s.PartIndex).ToList(); return convertSkuInfo; }
private PalletHistoryInfo GetPalletInfo(MasterJobTable jobInfo) { ReworkFactory reworkFactory = new ReworkFactory(); RepairFaults faults = new RepairFaults(); DispositionDataContext db = new DispositionDataContext(); REWORK_REPORTINGEntities reworkEntities = new REWORK_REPORTINGEntities(); MesDataContext dbMes = new MesDataContext(); ItemDetailsModel itemDetailModel = new ItemDetailsModel(); var item = itemDetailModel.GetItemInfo(jobInfo.SKU); var convertSkuInfo = reworkFactory.GetSkuInfo(item).OrderBy(x => x.PartIndex).ToList(); var lineInfos = reworkFactory.GetLineInfo(jobInfo); //RepairTorqueDetails = Count = 0 reworkEntities.Configuration.ProxyCreationEnabled = false; reworkEntities.Configuration.LazyLoadingEnabled = false; var repairHistory = reworkEntities.RepairHistories .Include("RepairFaultXrefRepairHistories") .Include("RepairFaultXrefRepairHistories.RepairFault") .Include("RepairFaultXrefRepairHistories.RepairFault.FaultType") .Include("RepairFaultXrefRepairHistories.RepairFault.RepairFaultDetails") .Include("RepairFaultXrefRepairHistories.RepairFault.RepairDispositionDetails") .Include("RepairFaultXrefRepairHistories.RepairFault.RepairRecipes") //.Include("RepairFaultXrefRepairHistories.RepairFault.RepairRecipes.RepairBarcodeDetails") //.Include("RepairFaultXrefRepairHistories.RepairFault.RepairRecipes.RepairTorqueDetails") .Include("RepairTestRequirements") .Include("RepairTestRequirements.RepairTestRequirementDetails") .Where(r => r.JobId == jobInfo.Job_ID) .Select(i => new { i.ArriveDtm, i.CompletedDtm, i.EmployeeId, i.EmployeeName, i.JobId, i.PalletId, RepairFaultXrefRepairHistories = i.RepairFaultXrefRepairHistories.Select(j => new { RepairFault = new { FaultType = j.RepairFault.FaultType, RepairDispositionDetails = j.RepairFault.RepairDispositionDetails, RepairFaultDetails = j.RepairFault.RepairFaultDetails, RepairRecipes = j.RepairFault.RepairRecipes } }).ToList(), RepairTestRequirements = i.RepairTestRequirements.Select(k => new { k.TestId, k.TestName, k.TestResult, k.TestStatus, k.Buildcode, RepairTestRequirementDetails = k.RepairTestRequirementDetails }).ToList(), }).ToList(); dynamic extract = new List<dynamic>(); foreach (var j in repairHistory) { dynamic onejob = new { PalletId = j.PalletId, JobId = j.JobId, CompletedDtm = j.CompletedDtm, EmployeeName = j.EmployeeName, RepairTestRequirements = (from t in j.RepairTestRequirements select new { TestId = t.TestId, TestName = t.TestName, TestResult = t.TestResult, TestStatus = t.TestStatus, Buildcode = t.Buildcode, RepairTestRequirementDetails = (from d in t.RepairTestRequirementDetails select new { BitNo = d.BitNo, Description = d.Description, Result = d.Result }).ToList(), }).ToList(), RepairFaultXrefRepairHistories = from s in j.RepairFaultXrefRepairHistories select new { RepairFault = new { FaultType = new { Id = s.RepairFault.FaultType.Id, Description = s.RepairFault.FaultType.Description, }, RepairRecipes = from r in s.RepairFault.RepairRecipes select new { Description = r.Description, RepairBarcodeDetails = (from b in r.RepairBarcodeDetails select new { Description = b.Description, OriginalBarcode = b.OriginalBarcode, ReplaceBarcode = b.ReplaceBarcode }).ToList(), RepairTorqueDetails = (from t in r.RepairTorqueDetails select new { Angle = t.Angle, AngleStatus = t.AngleStatus, CompletedDTM = t.CompletedDTM, ControllerName = t.ControllerName, Pset = t.Pset, TighteningID = t.TighteningID, TighteningStatus = t.TighteningStatus, Torque = t.Torque, TorqueStatus = t.TorqueStatus }).ToList(), }, RepairFaultDetails = (from d in s.RepairFault.RepairFaultDetails select new { Station = d.Station, Description = d.Description }).ToList(), RepairDispositionDetails = (from disp in s.RepairFault.RepairDispositionDetails select new { Type = disp.Type, Side = disp.Side, SeatPortion = disp.SeatPortion, Commodity = disp.Commodity, Defect = disp.Defect, DefectDetail = disp.DefectDetail, Responsibility = disp.Responsibility }).ToList() } } }; extract.Add(onejob); } PalletHistoryInfo palletInfo = new PalletHistoryInfo { OrderNumber = jobInfo.Order_Nbr, FinishDTM = (DateTime)jobInfo.FinishBld_DTTM, JobId = jobInfo.Job_ID, Sku = jobInfo.SKU, PalletId = (int)jobInfo.Ship_Pallet, SkuInfo = convertSkuInfo, LineInfo = lineInfos, RepairHistory = extract }; return palletInfo; }