//给外部调用
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);
}
}
