public static void SNLinkPassAction(MESPubLab.MESStation.MESStationBase Station, MESPubLab.MESStation.MESStationInput Input, List <R_Station_Action_Para> Paras)
{
string SubSn = "";
SN SubSNObj = new SN();
SN SnObj = new SN();
WorkOrder WO = new WorkOrder();
T_R_SN Table_R_SN = new T_R_SN(Station.SFCDB, Station.DBType);
T_R_SN_STATION_DETAIL Table_SnDetail = new T_R_SN_STATION_DETAIL(Station.SFCDB, Station.DBType);
T_R_SN_KEYPART_DETAIL Table_R_Keypart = new T_R_SN_KEYPART_DETAIL(Station.SFCDB, Station.DBType);
string ErrMessage = string.Empty;
List <C_KEYPART> SubKPList = new List <C_KEYPART>();
List <C_KEYPART> MainKPList = new List <C_KEYPART>();
string StrNextStation = "";
string Status = "";
R_SN R_Sn = null;
T_R_WO_BASE WoTable = null; //add by LLF
List <Dictionary <string, string> > KPList = new List <Dictionary <string, string> >();
string result = "";
if (Paras.Count == 0)
{
throw new Exception("參數數量不正確!");
}
MESStationSession SubSNSession = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY);
if (SubSNSession == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE + Paras[0].SESSION_KEY }));
}
MESStationSession SubKPSession = Station.StationSession.Find(t => t.MESDataType == Paras[1].SESSION_TYPE && t.SessionKey == Paras[1].SESSION_KEY);
if (SubKPSession == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[1].SESSION_TYPE + Paras[1].SESSION_KEY }));
}
MESStationSession MainKPSession = Station.StationSession.Find(t => t.MESDataType == Paras[2].SESSION_TYPE && t.SessionKey == Paras[2].SESSION_KEY);
if (MainKPSession == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[2].SESSION_TYPE + Paras[2].SESSION_KEY }));
}
MESStationSession KPListSession = Station.StationSession.Find(t => t.MESDataType == Paras[3].SESSION_TYPE && t.SessionKey == Paras[3].SESSION_KEY);
if (KPListSession == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[3].SESSION_TYPE + Paras[3].SESSION_KEY }));
}
MESStationSession WOSession = Station.StationSession.Find(t => t.MESDataType == Paras[4].SESSION_TYPE && t.SessionKey == Paras[4].SESSION_KEY);
if (WOSession == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[4].SESSION_TYPE + Paras[4].SESSION_KEY }));
}
MESStationSession NextStationSession = Station.StationSession.Find(t => t.MESDataType == Paras[5].SESSION_TYPE && t.SessionKey == Paras[5].SESSION_KEY);
if (NextStationSession == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[5].SESSION_TYPE + Paras[5].SESSION_KEY }));
}
MESStationSession StatusSession = Station.StationSession.Find(t => t.MESDataType == Paras[6].SESSION_TYPE && t.SessionKey == Paras[6].SESSION_KEY);
if (StatusSession == null)
{
StatusSession = new MESStationSession()
{
MESDataType = Paras[6].SESSION_TYPE, SessionKey = Paras[6].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(StatusSession);
if (string.IsNullOrEmpty(Paras[0].VALUE))
{
StatusSession.Value = "PASS";
}
}
Status = StatusSession.Value.ToString();
MESStationSession ClearFlagGSession = Station.StationSession.Find(t => t.MESDataType == Paras[7].SESSION_TYPE && t.SessionKey == Paras[7].SESSION_KEY);
if (ClearFlagGSession == null)
{
ClearFlagGSession = new MESStationSession()
{
MESDataType = Paras[7].SESSION_TYPE, SessionKey = Paras[7].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(ClearFlagGSession);
}
ClearFlagGSession.Value = "false";
StrNextStation = SnObj.StringListToString((List <string>)NextStationSession.Value);
//StrNextStation = NextStationSession.Value.ToString();
SubKPList = (List <C_KEYPART>)SubKPSession.Value;
MainKPList = (List <C_KEYPART>)MainKPSession.Value;
KPList = (List <Dictionary <string, string> >)KPListSession.Value;
SubSNObj = (SN)SubSNSession.Value;
WO = (WorkOrder)WOSession.Value;
SubSn = SubSNObj.SerialNo;
R_Sn = Table_R_SN.GetById(SubSNObj.ID, Station.SFCDB);
if (SubKPList.Count + MainKPList.Count == KPList.Count)
{
Table_R_SN.UpdateSNKeyparStatus(SubSNObj.ID, Station.LoginUser.EMP_NO, "0", Station.SFCDB);
Table_R_SN.InsertLinkSN(SubSn, WO.WorkorderNo, WO.SkuNO, WO.RouteID, WO.KP_LIST_ID, Station.StationName, StrNextStation, Station.LoginUser.EMP_NO, Station.BU, Station.SFCDB, SubSNObj.Plant);
//更新Main KP SN
foreach (Dictionary <string, string> DicMainKP in KPList)
{
int SeqNo = Convert.ToInt16(DicMainKP["SEQ_NO"]);
if (DicMainKP["KP_TYPE"] == "MAIN_SN")
{
Table_R_SN.UpdateSNKeyparStatus(DicMainKP["KP_SN_ID"], Station.LoginUser.EMP_NO, "1", Station.SFCDB);
}
//写KP
Table_R_Keypart.INSN_KEYPART_DETAIL(Station.SFCDB, Station.BU, SubSNObj.ID, DicMainKP["SN"], DicMainKP["KEYPART_SN"], Station.StationName, DicMainKP["PART_NO"], SeqNo, DicMainKP["CATEGORY_NAME"], DicMainKP["CATEGORY"], Station.LoginUser.EMP_NO);
}
//寫過站記錄
result = Table_R_SN.LinkPassStationDetail(R_Sn, WO.WorkorderNo, WO.SkuNO, WO.RouteID, Station.Line, Station.StationName, Station.StationName, Station.LoginUser.EMP_NO, Station.BU, Station.SFCDB);
if (Convert.ToInt32(result) <= 0)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000021", new string[] { "STATION DETAIL" }));
}
//add by LLF
WoTable = new T_R_WO_BASE(Station.SFCDB, Station.DBType);
result = WoTable.AddCountToWo(WO.WorkorderNo, 1, Station.SFCDB); // 更新 R_WO_BASE 中的數據
if (Convert.ToInt32(result) <= 0)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000025", new string[] { "WO QTY" }));
}
//寫良率，UPH
result = Table_R_SN.RecordUPH(WO.WorkorderNo, 1, SubSn, Status, Station.Line, Station.StationName, Station.LoginUser.EMP_NO, Station.BU, Station.SFCDB);
if (Convert.ToInt32(result) <= 0)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000021", new string[] { "UPH" }));
}
result = Table_R_SN.RecordYieldRate(WO.WorkorderNo, 1, SubSn, Status, Station.Line, Station.StationName, Station.LoginUser.EMP_NO, Station.BU, Station.SFCDB);
if (Convert.ToInt32(result) <= 0)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000021", new string[] { "YIELD" }));
}
KPListSession.Value = null;
ClearFlagGSession.Value = "true";
Station.AddMessage("MES00000195", new string[] { SubSn, StrNextStation }, StationMessageState.Pass);
}
}
/// <summary>
/// FQC Lot 過站
/// </summary>
/// <param name="SerialNo"></param>
/// <param name="LotNo"></param>
/// <param name="PassOrFail"></param>
/// <param name="EmpNo"></param>
/// <param name="Station"></param>
/// <param name="Line"></param>
/// <param name="BU"></param>
/// <param name="DB"></param>
/// <param name="FailInfos"></param>
public void LotPassStation(string SerialNo, string LotNo, string PassOrFail, string EmpNo, string Station, string DeviceName, string Line, string BU, OleExec DB, params string[] FailInfos)
{
bool PassedFlag = true;
string sql = string.Empty;
DataTable dt = new DataTable();
Row_R_LOT_STATUS StatusRow = (Row_R_LOT_STATUS)NewRow();
T_R_LOT_DETAIL DetailTable = new T_R_LOT_DETAIL(DB, this.DBType);
Row_R_LOT_DETAIL DetailRow = (Row_R_LOT_DETAIL)DetailTable.NewRow();
R_LOT_STATUS Status = null;
R_LOT_DETAIL Detail = null;
T_R_SN SnTable = new T_R_SN(DB, this.DBType);
List <string> LotsSN = new List <string>();
if (this.DBType == DB_TYPE_ENUM.Oracle)
{
PassedFlag = PassOrFail.ToUpper().Equals("PASS") ? true : false;
//sql = $@"SELECT * FROM R_LOT_STATUS WHERE LOT_NO='{LotNo}' AND SAMPLE_STATION='{Station}' AND LINE='{Line}'"; //判斷有沒有 LOT
sql = $@"SELECT * FROM R_LOT_STATUS WHERE LOT_NO='{LotNo}' AND SAMPLE_STATION='{Station}'"; //判斷有沒有 LOT
dt = DB.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
StatusRow.loadData(dt.Rows[0]);
Status = StatusRow.GetDataObject();
sql = $@"SELECT A.* FROM R_LOT_DETAIL A,R_SN B WHERE LOT_ID='{StatusRow.ID}' AND B.SN='{SerialNo}' AND A.SN=B.SN"; //判斷Lot中有沒有這個SN並且沒有被抽檢過
dt = DB.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
DetailRow.loadData(dt.Rows[0]);
Detail = DetailRow.GetDataObject();
if (Detail.SAMPLING.Equals("1"))
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000093", new string[] { SerialNo }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000094", new string[] { SerialNo, LotNo }));
}
if (Status.CLOSED_FLAG == "1") //Lot 關閉
{
if (PassedFlag)
{
//更新 R_LOT_DETAIL STATUS
Detail.STATUS = "1"; //1 表示抽檢通過
Detail.SAMPLING = "1"; //1 表示被抽檢了
//更新 R_LOT_STATUS PASS_QTY
Status.PASS_QTY++;
}
else
{
//更新 R_LOT_DETAIL STATUS ,FAIL_CODE,FAIL_LOCATION,DESCRIPTION
Detail.STATUS = "0"; //0 表示抽檢失敗
Detail.SAMPLING = "1"; //1 表示被抽檢了
if (FailInfos != null && FailInfos.Length == 3) //記錄失敗原因
{
Detail.FAIL_CODE = FailInfos[0];
Detail.FAIL_LOCATION = FailInfos[1];
Detail.DESCRIPTION = FailInfos[2];
}
//更新 R_LOT_STATUS FAIL_QTY
Status.FAIL_QTY++;
}
if (Status.FAIL_QTY >= Status.REJECT_QTY && Status.FAIL_QTY != 0)
{
//更新 R_LOT_STATUS 關閉，NG，
//Status.CLOSED_FLAG = "1";// 1 表示關閉Lot
Status.LOT_STATUS_FLAG = "2";// 2 表示整個 Lot 不良
//更新 R_LOT_DETAIL 鎖定LOT 中所有
Detail.EDIT_EMP = EmpNo;
Detail.EDIT_TIME = GetDBDateTime(DB);
DetailRow.ConstructRow(Detail);
DB.ExecSQL(DetailRow.GetUpdateString(this.DBType));
//該批次鎖定--add by Eden 2018-05-04
sql = $@"update r_lot_detail set sampling='4' where lot_id='{Detail.LOT_ID}'";
DB.ExecSQL(sql);
//DetailTable.LockLotBySn(SerialNo, EmpNo, DB);
}
else
{
if (Status.PASS_QTY + Status.FAIL_QTY >= Status.SAMPLE_QTY)
{
//更新 R_LOT_STATUS 關閉，OK
//Status.CLOSED_FLAG = "1";
Status.LOT_STATUS_FLAG = "1"; // 1 表示整個 Lot 正常
//更新 R_LOT_DETAIL 鎖定FAIL 的，其他的正常過站
//sql = $@"SELECT * FROM R_LOT_DETAIL WHERE LOT_ID='{StatusRow.ID}' AND STATUS='0'";
sql = $@"SELECT * FROM R_LOT_DETAIL WHERE LOT_ID='{StatusRow.ID}' AND ((SAMPLING='1' AND STATUS='1') OR (SAMPLING='0'))";
dt = DB.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
LotsSN.Add(dr["SN"].ToString());
}
SnTable.LotsPassStation(LotsSN, Line, Station, DeviceName, BU, PassOrFail, EmpNo, DB); // 過站
}
//記錄通過數 ,UPH
foreach (string SN in LotsSN)
{
SnTable.RecordYieldRate(Detail.WORKORDERNO, 1, SN, "PASS", Line, Station, EmpNo, BU, DB);
SnTable.RecordUPH(Detail.WORKORDERNO, 1, SN, "PASS", Line, Station, EmpNo, BU, DB);
}
}
Detail.EDIT_EMP = EmpNo;
Detail.EDIT_TIME = GetDBDateTime(DB);
DetailRow.ConstructRow(Detail);
DB.ExecSQL(DetailRow.GetUpdateString(this.DBType));
}
Status.EDIT_EMP = EmpNo;
Status.EDIT_TIME = GetDBDateTime(DB);
StatusRow.ConstructRow(Status);
DB.ExecSQL(StatusRow.GetUpdateString(this.DBType));
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000201", new string[] { LotNo }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000091", new string[] { LotNo }));
}
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
}
