private void GetCtData() { var prodList = new ReqRptCommonProductQuerier(6).Prods; DevCatcher.Conditions = string.Format("where prodspec_id in ('{0}')", string.Join("','", prodList)); DevCatcher.GetEntities(); CtTotal = DevCatcher.entities.EntityList.Sum(s => s.Total_CT); }
private void Initialize() { //DB2Helper db2 = new DB2Helper(); //string sql = "select d_thesystemkey from smview.fbprod where prodcat_ident = 'Production' and mainpd_id = 'APAA'"; //db2.GetSomeData(sql); //foreach (DataRow dr in db2.dt.Rows) //{ // TableEntities.Add(new ReqRpt025TableEntity(dr[0].ToString())); //} var productQuerier = new ReqRptCommonProductQuerier(6); foreach (var prod in productQuerier.Prods) { TableEntities.Add(new ReqRpt025TableEntity(prod)); } DB2DataCatcher <RPT_RealTime_Lin> db2Catcher = new DB2DataCatcher <RPT_RealTime_Lin>("ISTRPT.RPT_RealTime_Lin"); db2Catcher.Conditions = string.Format("where start_time>='{0}' and start_time <'{1}' ", strSelecedFrom, strSelectedTo); var list = db2Catcher.GetEntities().EntityList; foreach (var item in TableEntities) { var rowList = list.Where(w => w.Product_ID == item.ProductID); var rowList_Fab = rowList.Where(w => w.PartName == "FAB"); var rowList_Wat = rowList.Where(w => w.PartName == "WAT"); if (rowList_Fab.Count() > 0) { item.FAB_PassQty = rowList_Fab.Sum(w => w.MoveQty); item.FAB_ScrapQty = rowList_Fab.Sum(w => w.ScrappedQty); } if (rowList_Wat.Count() > 0) { item.WAT_PassQty = rowList_Wat.Sum(s => s.MoveQty); item.WAT_ScrapQty = rowList_Wat.Sum(s => s.ScrappedQty); } } }
private void Initialize() { Products = new ReqRptCommonProductQuerier(6).Prods; string month = Date.ToString("yyyy-MM"); var model = new ReqRpt011TableDataBuilder(month, Products); var lineYieldPostModel = new ReqRpt025PostModel() { FromCategory = "day", ToCategory = "day", FromDate = Date.ToString("yyyy-MM") + "-01", ToDate = Date.AddDays(1).ToString("yyyy-MM-dd") }; var lineYiledDataModel = new ReqRpt025TableViewModel(lineYieldPostModel); foreach (var prod in Products) { var outSource = model.WipEntities.Where(w => w.ProductID == prod); var outEntity = new ReqRpt002WaferOutEntity() { Product = prod }; outEntity.OutSourceAccActual = outSource.Any() ? outSource.First().Plans.Take(Date.Day).Sum(s => s.Actual) : 0; outEntity.OutSourceAccTarget = outSource.Any() ? outSource.First().Plans.Take(Date.Day).Sum(s => s.Target) : 0; var waferOut = model.ShipEntities.Where(w => w.ProductID == prod); outEntity.WFOutAccActual = waferOut.Any() ? waferOut.First().Plans.Take(Date.Day).Sum(s => s.Actual) : 0; outEntity.WFOutAccTarget = waferOut.Any() ? waferOut.First().Plans.Take(Date.Day).Sum(s => s.Target) : 0; var yieldFindList = lineYiledDataModel.TableEntities.Where(w => w.ProductID == prod); outEntity.WFOutYield = yieldFindList.Any() ? yieldFindList.First().Yield : 0; WaferOutEntities.Add(outEntity); } WaferOutTotalEntity.Product = "Total"; WaferOutTotalEntity.OutSourceAccActual = WaferOutEntities.Sum(s => s.OutSourceAccActual); WaferOutTotalEntity.OutSourceAccTarget = WaferOutEntities.Sum(s => s.OutSourceAccTarget); WaferOutTotalEntity.WFOutAccActual = WaferOutEntities.Sum(s => s.WFOutAccActual); WaferOutTotalEntity.WFOutAccTarget = WaferOutEntities.Sum(s => s.WFOutAccTarget); var fab_pass = lineYiledDataModel.TableEntities.Sum(s => s.FAB_PassQty); var fab_scrap = lineYiledDataModel.TableEntities.Sum(s => s.FAB_ScrapQty); var wat_pass = lineYiledDataModel.TableEntities.Sum(s => s.WAT_PassQty); var wat_scrap = lineYiledDataModel.TableEntities.Sum(s => s.WAT_ScrapQty); var fab_yield = fab_pass + fab_scrap == 0 ? 0 : fab_pass * 1.0 / (fab_pass + fab_scrap); var wat_yield = wat_pass + wat_scrap == 0 ? 0 : wat_pass * 1.0 / (wat_pass + wat_scrap); WaferOutTotalEntity.WFOutYield = fab_yield * wat_yield; }