//获取in_time
private void GetInTime(RPT_WipChart_YSTD lot, string lot_id)
{
HSCatcher.Conditions = string.Format("where lot_id ='{0}'and claim_time <='{1} 08:00:00' and Ope_Category in ('OperationComplete','STB','Split') order by Claim_Time", lot_id, DateString);
HSCatcher.GetEntities();
var list = HSCatcher.entities.EntityList;
var list_findInOpe = list.Where(w => w.Lot_ID == lot_id && w.Ope_Category != "Split");
if (list_findInOpe.Any())
{
lot.In_Time = list.Last().Claim_Time;
}
else
{
//Split情况下获取Intime
HSCatcher.Conditions = string.Format("where lot_id like '{0}.%' and claim_time <='{1} 08:00:00' and Ope_Category in ('OperationComplete','STB','Split')", lot_id.Split('.')[0], DateString);
HSCatcher.GetEntities();
var splitList = HSCatcher.entities.EntityList.Where(w => w.Lot_ID == lot_id && w.Ope_Category == "Split");
if (!splitList.Any())
{
return;
}
DateTime splitTime = splitList.First().Claim_Time;
var momLot = HSCatcher.entities.EntityList.Where(w => w.Claim_Time == splitTime && w.Lot_ID != lot_id).First();
GetInTime(lot, momLot.Lot_ID);
}
}
private void GetDb2Datas()
{
CurStateCatcher.GetEntities();
HSCatcher.Conditions = string.Format("where lot_id {0} and Ope_Category in ('STB','OperationComplete','Split')", LotID.Split('.').Length > 1 ? "like '" + LotID.Split('.')[0] + ".%'" :"='" + LotID + "'");
HSCatcher.GetEntities();
RMKCatcher.Conditions = string.Format("where lot_id='{0}'", LotID);
RMKCatcher.GetEntities();
ForecastCatcher.Conditions = string.Format("where prodspec_id='{0}' order by ope_no", ProductID);
ForecastCatcher.GetEntities();
HoldHsCatcher.Conditions = string.Format("where lot_id ='{0}' and Ope_Category like '%Hold%'", LotID);
HoldHsCatcher.GetEntities();
CodeCatcher.GetEntities();
PmsCatcher.Conditions = " where next_late_date >= to_char( current Date,'yyyy-MM-dd')";
PmsCatcher.GetEntities();
PDCatcher.GetEntities();
}
private void Initialize()
{
HSCatcher.DB2.GetSomeData(DelOldRecords);
HSCatcher.GetEntities();
var HistoryList = HSCatcher.entities.EntityList;
if (HistoryList.Count() < 1)
{
throw new Exception("没有YSTD Record");
}
var lotList = HistoryList.Select(s => s.Lot_ID).Distinct();
foreach (var lot in lotList)
{
var hist = HistoryList.Where(w => w.Lot_ID == lot).First();
var entity = new RPT_WipChart_YSTD()
{
Lot_ID = hist.Lot_ID,
Claim_Time = hist.Claim_Time,
Cur_Wafer_Qty = hist.Cur_Wafer_Qty,
Hold_State = hist.Hold_State,
MainPD_ID = hist.MainPD_ID,
Ope_No = hist.Ope_No,
Priority_Class = hist.Priority_Class,
ProdSpec_ID = hist.ProdSpec_ID,
Ope_Category = hist.Ope_Category,
Bank_ID = hist.Bank_ID
};
GetInTime(entity, entity.Lot_ID);
if (entity.In_Time > DateTime.MinValue)
{
if (entity.Ope_Category == "OperationComplete")
{
GetPreOpeNoIfComplete(entity);
}
WipChartPusher.entities.EntityList.Add(entity);
}
}
WipChartPusher.PushEntities();
}