//给外部调用 public List <Chamber_SingleLine> GetChamberLists() { List <Chamber_SingleLine> lines = new List <Chamber_SingleLine>(); foreach (ChamberDBEntity dBEntity in ChamberDBEntities) { Chamber_SingleLine singleLine = new Chamber_SingleLine(); singleLine.Lot = dBEntity.Lot_ID; singleLine.Wafer = dBEntity.Wafer_ID.Substring(dBEntity.Wafer_ID.Length - 2, 2); singleLine.Scribe = dBEntity.Wafer_ID; singleLine.Equipment = dBEntity.Eqp_ID; singleLine.Route = dBEntity.MainPD_ID.Split('.')[0]; singleLine.RouteVersion = dBEntity.MainPD_ID.Split('.').Length == 2? dBEntity.MainPD_ID.Split('.')[1]:""; singleLine.DateTimeList = dBEntity.strProcTime; singleLine.ChamberList = dBEntity.Procrsc_ID; var item = ChamberOphsEntities.Where(w => w.Eqp_ID == dBEntity.Eqp_ID && w.MainPD_ID == dBEntity.MainPD_ID && w.Ope_No == dBEntity.Ope_No && w.Ope_Pass_Count == dBEntity.Ope_Pass_Count).OrderBy(o => o.Claim_Time).FirstOrDefault(); if (item is null) { continue; } singleLine.Step = item.PD_ID.Split('.')[0]; singleLine.StepVersion = item.PD_ID.Split('.').Length == 2?dBEntity.MainPD_ID.Split('.')[1]:""; singleLine.RecipeList = item.Recipe_ID; lines.Add(singleLine); } return(lines); }
//为ChamberOphsEntities赋值 public void GetData() { DB2Helper dB2 = new DB2Helper(); dB2.GetSomeData(Sql_chamber); if (dB2.dt.Rows.Count == 0) { throw new NoQueryDataException("没有新的Chamber数据产生"); } foreach (DataRow dr in dB2.dt.Rows) { ChamberDBEntity chamberDB = new ChamberDBEntity() { Eqp_ID = dr["Eqp_ID"].ToString(), Lot_ID = dr["Lot_ID"].ToString(), MainPD_ID = dr["MainPD_ID"].ToString(), Ope_No = dr["Ope_NO"].ToString(), Ope_Pass_Count = (int)dr["Ope_Pass_Count"], Procrsc_ID = dr["Procrsc_ID"].ToString(), Proc_Time = (DateTime)dr["Proc_Time"], Wafer_ID = dr["Wafer_ID"].ToString() }; ChamberDBEntities.Add(chamberDB); } dB2.GetSomeData(Sql_History); foreach (DataRow dr in dB2.dt.Rows) { ChamberOphsEntity chamberOphs = new ChamberOphsEntity() { Claim_Time = (DateTime)dr["Claim_Time"], Eqp_ID = dr["Eqp_ID"].ToString(), Lot_ID = dr["Lot_ID"].ToString(), MainPD_ID = dr["MainPD_ID"].ToString(), Ope_No = dr["Ope_NO"].ToString(), Ope_Pass_Count = (int)dr["Ope_Pass_Count"], Recipe_ID = dr["Recipe_ID"].ToString(), PD_ID = dr["PD_ID"].ToString() }; ChamberOphsEntities.Add(chamberOphs); } }