public MQCItemSummary GetMQCItemSummary(DateTime from, DateTime to, string site, string process) { MQCItemSummary itemSummary = new MQCItemSummary(); try { LoadDataMQC dataMQC = new LoadDataMQC(); List <MQCDataItems> mQCDataItems = dataMQC.listMQCDataItemsbySite(from, to, site, process); //Nhom theo san pham var ListItemsData = mQCDataItems .GroupBy(u => u.item) .Select(grp => grp.ToList()) .ToList(); var ListItemsTime = mQCDataItems .GroupBy(u => u.inspecttime) .ToList(); itemSummary.product = ""; itemSummary.defectItems = new List <DefectItem>(); //Khi thay doi ngay can phai chinh lai thoi gian itemSummary.Time_from = mQCDataItems.Min(d => d.inspecttime).ToString(); itemSummary.Time_To = mQCDataItems.Max(d => d.inspecttime).ToString(); foreach (var itemData in ListItemsData) { if (itemData[0].remark == "OP") { itemSummary.OutputQty = itemData.Select(d => d.data).Sum(); } else if (itemData[0].remark == "NG") { DefectItem item = new DefectItem(); item.DefectCode = itemData[0].item; item.Quantity = itemData.Select(d => d.data).Sum(); LoadDefectMapping defectMapping = new LoadDefectMapping(); NGItemsMapping nGItemsMapping = defectMapping.GetNGMapping(site, process, item.DefectCode); item.DefectSFT = nGItemsMapping.NGCode_SFT; item.DefectSFTName = nGItemsMapping.NGCodeName_SFT; itemSummary.defectItems.Add(item); itemSummary.NGQty += item.Quantity; } } itemSummary.QuantityTotal = itemSummary.OutputQty + itemSummary.NGQty; itemSummary.DefectRate = (itemSummary.QuantityTotal != 0) ? (itemSummary.NGQty / itemSummary.QuantityTotal) : 0; } catch (Exception ex) { Log.Logfile.Output(Log.StatusLog.Error, "GetMQCItemSummaries(DateTime from, DateTime to, string site, string process)", ex.Message); } return(itemSummary); }
public List <MQCItemSummary> GetMQCItemSummariesFromTo(DateTime from, DateTime to, string site, string process) { List <MQCItemSummary> qCItemSummaries = new List <MQCItemSummary>(); try { LoadDataMQC dataMQC = new LoadDataMQC(); List <MQCDataItems> mQCDataItems = dataMQC.listMQCDataItemsbySite(from, to, site, process); //Nhom theo san pham var ListMQCbyProduct = mQCDataItems .OrderBy(d => d.line) .GroupBy(u => u.lot) .Select(grp => grp.ToList()) .ToList(); foreach (var qCDataItems in ListMQCbyProduct) { MQCItemSummary itemSummary = new MQCItemSummary(); itemSummary.product = qCDataItems[0].model; itemSummary.defectItems = new List <DefectItem>(); itemSummary.ReworkItems = new List <DefectItem>(); var ListItemsData = qCDataItems .GroupBy(u => u.item) .Select(grp => grp.ToList()) .ToList(); itemSummary.Time_from = dataMQC.GetMinTimeProductionOfProduct(itemSummary.product, from, to); itemSummary.Time_To = dataMQC.GetMaxTimeProductionOfProduct(itemSummary.product, from, to); //Khi thay doi ngay can phai chinh lai thoi gian foreach (var itemData in ListItemsData) { itemSummary.product = itemData[0].model; itemSummary.Line = itemData[0].line; itemSummary.Lot = itemData[0].lot; if (itemData[0].remark == "OP") { itemSummary.OutputQty = itemData.Select(d => d.data).Sum(); } else if (itemData[0].remark == "NG") { DefectItem item = new DefectItem(); item.DefectCode = itemData[0].item; item.Quantity = itemData.Select(d => d.data).Sum(); LoadDefectMapping defectMapping = new LoadDefectMapping(); NGItemsMapping nGItemsMapping = defectMapping.GetNGMapping(site, process, item.DefectCode); item.DefectSFT = nGItemsMapping.NGCode_SFT; item.DefectSFTName = nGItemsMapping.NGCodeName_SFT; itemSummary.defectItems.Add(item); itemSummary.NGQty += item.Quantity; } else if (itemData[0].remark == "RW") { DefectItem item = new DefectItem(); item.DefectCode = itemData[0].item; item.Quantity = itemData.Select(d => d.data).Sum(); LoadDefectMapping defectMapping = new LoadDefectMapping(); NGItemsMapping nGItemsMapping = defectMapping.GetNGMapping(site, process, item.DefectCode.Replace("RW", "NG")); item.DefectSFT = nGItemsMapping.NGCode_SFT; item.DefectSFTName = nGItemsMapping.NGCodeName_SFT; itemSummary.ReworkItems.Add(item); itemSummary.ReworkQty += item.Quantity; } } itemSummary.QuantityTotal = itemSummary.OutputQty + itemSummary.NGQty /*+ itemSummary.ReworkQty*/; itemSummary.DefectRate = (itemSummary.QuantityTotal != 0) ? (itemSummary.NGQty / itemSummary.QuantityTotal) : 0; itemSummary.ReworkRate = (itemSummary.QuantityTotal != 0) ? (itemSummary.ReworkQty / itemSummary.QuantityTotal) : 0; qCItemSummaries.Add(itemSummary); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetMQCItemSummaries(DateTime from, DateTime to, string site, string process)", ex.Message); } return(qCItemSummaries); }
public List <MQCItemSummary> GetMQCSummarybyYear(DateTime from, DateTime to, string site, string process) { // DateTime from = new DateTime(); DateTime to = new DateTime(); // DateTimeControl.ReturnDateTimePeriodProduction(period, ref from, ref to); string date = from.ToString("yyyy-MM-dd"); string time = from.ToString("HH:mm:ss"); List <MQCItemSummary> qCItemSummaries = new List <MQCItemSummary>(); try { LoadDataMQC dataMQC = new LoadDataMQC(); List <MQCDataItems> mQCDataItems = dataMQC.listMQCDataItemsbySite(from, to, site, process); //Nhom theo san pham var ListMQCbyProduct = mQCDataItems .OrderBy(d => d.inspectdate) .GroupBy(u => u.inspectdate) .Select(grp => grp.ToList()) .ToList(); foreach (var qCDataItems in ListMQCbyProduct) { MQCItemSummary itemSummary = new MQCItemSummary(); //DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo; //Calendar cal = dfi.Calendar; //int WeekNo = cal.GetWeekOfYear(qCDataItems[0].inspectdate, CalendarWeekRule.FirstDay, DayOfWeek.Monday); itemSummary.Time_from = qCDataItems[0].inspectdate.ToString("yyyy"); itemSummary.defectItems = new List <DefectItem>(); var ListItemsData = qCDataItems .GroupBy(u => u.item) .Select(grp => grp.ToList()) .ToList(); //Khi thay doi ngay can phai chinh lai thoi gian foreach (var itemData in ListItemsData) { itemSummary.product = itemData[0].model; itemSummary.Line = itemData[0].line; itemSummary.Lot = itemData[0].lot; if (itemData[0].remark == "OP") { itemSummary.OutputQty = itemData.Select(d => d.data).Sum(); } else if (itemData[0].remark == "NG") { DefectItem item = new DefectItem(); item.DefectCode = itemData[0].item; item.Quantity = itemData.Select(d => d.data).Sum(); LoadDefectMapping defectMapping = new LoadDefectMapping(); NGItemsMapping nGItemsMapping = defectMapping.GetNGMapping(site, process, item.DefectCode); if (nGItemsMapping != null) { item.DefectSFT = nGItemsMapping.NGCode_SFT; item.DefectSFTName = nGItemsMapping.NGCodeName_SFT; itemSummary.defectItems.Add(item); itemSummary.NGQty += item.Quantity; } } else if (itemData[0].remark == "RW") { DefectItem item = new DefectItem(); item.DefectCode = itemData[0].item; item.Quantity = itemData.Select(d => d.data).Sum(); itemSummary.ReworkQty += item.Quantity; } } itemSummary.QuantityTotal = itemSummary.OutputQty + itemSummary.NGQty /*+ itemSummary.ReworkQty*/; itemSummary.OutputRate = (itemSummary.QuantityTotal != 0) ? (itemSummary.OutputQty / itemSummary.QuantityTotal) : 0; itemSummary.DefectRate = (itemSummary.QuantityTotal != 0) ? (itemSummary.NGQty / itemSummary.QuantityTotal) : 0; itemSummary.ReworkRate = (itemSummary.QuantityTotal != 0) ? (itemSummary.ReworkQty / itemSummary.QuantityTotal) : 0; qCItemSummaries.Add(itemSummary); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetMQCItemSummaries(DateTime from, DateTime to, string site, string process)", ex.Message); } return(qCItemSummaries); }