/// <summary> /// 重新加载 TRSN 的数量并进行判断 /// </summary> /// <param name="Station"></param> /// <param name="Input"></param> /// <param name="Paras"></param> public static void TRInputResetAction(MESStation.BaseClass.MESStationBase Station, MESStation.BaseClass.MESStationInput Input, List <MESDataObject.Module.R_Station_Action_Para> Paras) { //獲取TR_SN string TRSN = string.Empty; if (Paras.Count != 2) { throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000050")); } TRSN = Paras[1].VALUE.ToString(); //使用 TRSN 重新加載 TRSNWIP,目前不存在 DataLoader 來根據 TRSN 加載 TRSNWIP 信息 MESStationSession TRSNWip = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY); if (TRSNWip == null) { TRSNWip = new MESStationSession() { MESDataType = Paras[0].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[0].SESSION_KEY, ResetInput = Input }; Station.StationSession.Add(TRSNWip); } double ExtQty = ((DataRow)TRSNWip.Value)["EXT_QTY"] == null?0.0d:double.Parse(((DataRow)TRSNWip.Value)["EXT_QTY"].ToString()); TRSN = ((DataRow)TRSNWip.Value)["TR_SN"] == null?"": ((DataRow)TRSNWip.Value)["TR_SN"].ToString(); if (ExtQty <= 0) { MESStationInput input = Station.FindInputByName("TRSN"); input.Enable = true; Station.NextInput = input; Station.AddMessage("MES00000039", new string[] { TRSN }, MESReturnView.Station.StationMessageState.Message); } else { TRSNWip.Value = ExtQty--; MESStationInput input = Station.FindInputByName("NEW_SN"); } }
public static void HWDBIPSNFailAction(MESStation.BaseClass.MESStationBase Station, MESStation.BaseClass.MESStationInput Input, List <R_Station_Action_Para> Paras) { string ErrMessage = ""; string StrSn = ""; string APVirtualSn = ""; string VirtualSn = ""; AP_DLL APObj = new AP_DLL(); OleExec APDB = null; R_PANEL_SN PANELObj = null; Int16 FailCount = 0; List <Dictionary <string, string> > FailList = null; string R_SN_STATION_DETAIL_ID = ""; StringBuilder ReturnMessage = new StringBuilder(); string RepairmainID = "";//add by LLF 2018-04-12 if (Paras.Count < 5) { throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000050")); } MESStationSession SNSession = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY); if (SNSession == null) { ErrMessage = MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE + Paras[0].SESSION_KEY }); throw new MESReturnMessage(ErrMessage); } MESStationSession FailCountSession = Station.StationSession.Find(t => t.MESDataType == Paras[1].SESSION_TYPE && t.SessionKey == Paras[1].SESSION_KEY); if (FailCountSession == null) { ErrMessage = MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[1].SESSION_TYPE + Paras[1].SESSION_KEY }); throw new MESReturnMessage(ErrMessage); } MESStationSession FailListSession = Station.StationSession.Find(t => t.MESDataType == Paras[2].SESSION_TYPE && t.SessionKey == Paras[2].SESSION_KEY); if (FailListSession == null) { ErrMessage = MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[2].SESSION_TYPE + Paras[2].SESSION_KEY }); throw new MESReturnMessage(ErrMessage); } MESStationSession PanelVitualSNSession = Station.StationSession.Find(t => t.MESDataType == Paras[3].SESSION_TYPE && t.SessionKey == Paras[3].SESSION_KEY); if (PanelVitualSNSession == null) { ErrMessage = MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[3].SESSION_TYPE + Paras[3].SESSION_KEY }); throw new MESReturnMessage(ErrMessage); } MESStationSession StatusSession = Station.StationSession.Find(t => t.MESDataType == Paras[4].SESSION_TYPE && t.SessionKey == Paras[4].SESSION_KEY); if (StatusSession == null) { StatusSession = new MESStationSession() { MESDataType = Paras[4].SESSION_TYPE, InputValue = Input.Value.ToString(), Value = Paras[4].VALUE, SessionKey = Paras[4].SESSION_KEY, ResetInput = Input }; Station.StationSession.Add(StatusSession); if (StatusSession.Value.ToString() == "") { StatusSession.Value = "FAIL"; } } MESStationSession ClearInputSession = null; if (Paras.Count >= 6) { ClearInputSession = Station.StationSession.Find(t => t.MESDataType.Equals(Paras[5].SESSION_TYPE) && t.SessionKey.Equals(Paras[5].SESSION_KEY)); if (ClearInputSession == null) { ClearInputSession = new MESStationSession() { MESDataType = Paras[5].SESSION_TYPE, SessionKey = Paras[5].SESSION_KEY }; Station.StationSession.Add(ClearInputSession); } } FailCount = Convert.ToInt16(FailCountSession.Value.ToString()); FailList = (List <Dictionary <string, string> >)FailListSession.Value; T_R_SN rSn = new T_R_SN(Station.SFCDB, DB_TYPE_ENUM.Oracle); DateTime FailTime = rSn.GetDBDateTime(Station.SFCDB); StrSn = SNSession.Value.ToString(); if (FailList.Count >= FailCount && FailCount != 0) //允許掃描多個Fail { #region 業務邏輯 OleExec oleDB = null; oleDB = Station.SFCDB; //oleDB = this.DBPools["SFCDB"].Borrow(); //oleDB.BeginTrain(); //OleExecPool APDBPool = Station.DBS["APDB"]; //APDB = APDBPool.Borrow(); //APDB.BeginTrain(); APDB = Station.APDB; try { Row_R_SN rrSn = (Row_R_SN)rSn.NewRow(); for (int i = 0; i < FailList.Count; i++) { //獲取頁面傳過來的數據 string failCode = FailList[i]["FailCode"].ToString(); string failLocation = FailList[i]["FailLocation"].ToString(); string failProcess = FailList[i]["FailProcess"].ToString(); string failDescription = FailList[i]["FailDesc"].ToString(); //黃楊盛 2018年4月24日14:14:28 模擬自動做維修的動作,修正時間 //更新R_SN REPAIR_FAILED_FLAG=’1’ //modify by ZGJ 2018-03-22 BIP Fail 的產品自動清除待維修狀態,但是記錄不良 PANELObj = (R_PANEL_SN)PanelVitualSNSession.Value; if (i == 0) { VirtualSn = PANELObj.SN.ToString(); R_SN r = rSn.GetDetailBySN(VirtualSn, Station.SFCDB); rrSn = (Row_R_SN)rSn.GetObjByID(r.ID, Station.SFCDB); //rrSn.REPAIR_FAILED_FLAG = "0"; rrSn.REPAIR_FAILED_FLAG = "1"; rrSn.SN = StrSn; rrSn.EDIT_EMP = Station.LoginUser.EMP_NO; //add by LLF 2018-03-17 rrSn.EDIT_TIME = FailTime; //add by LLF 2018-03-17 string strRet = (Station.SFCDB).ExecSQL(rrSn.GetUpdateString(DB_TYPE_ENUM.Oracle)); if (!(Convert.ToInt32(strRet) > 0)) { throw new MESReturnMessage("update repair failed flag error!"); } // Update R_PANEL_SN T_R_PANEL_SN RPanelSN = new T_R_PANEL_SN(Station.SFCDB, DB_TYPE_ENUM.Oracle); Row_R_PANEL_SN Row_Panel = (Row_R_PANEL_SN)RPanelSN.NewRow(); Row_Panel = (Row_R_PANEL_SN)RPanelSN.GetObjByID(PANELObj.ID, Station.SFCDB); Row_Panel.SN = StrSn; strRet = (Station.SFCDB).ExecSQL(Row_Panel.GetUpdateString(DB_TYPE_ENUM.Oracle)); if (!(Convert.ToInt32(strRet) > 0)) { throw new MESReturnMessage("update r_panel_sn error!"); } //Update AP //黄杨盛 2018年4月14日09:10:50 修正不能超过9连板的情况.同时加上不支持3位数连板的约束 //APVirtualSn = PANELObj.PANEL + "0" + PANELObj.SEQ_NO.ToString(); if (PANELObj.SEQ_NO > 99) { throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000226", new string[] { DB_TYPE_ENUM.Oracle.ToString() })); } APVirtualSn = PANELObj.PANEL + Convert.ToInt16(PANELObj.SEQ_NO).ToString("00"); string result = APObj.APUpdatePanlSN(APVirtualSn, StrSn, APDB); //APDBPool.Return(APDB); if (!result.Equals("OK")) { //2018年4月24日13:56:14 黃楊盛 //throw new MESReturnMessage("already be binded to other serial number"); throw new MESReturnMessage(result); } //新增一筆FAIL記錄到R_SN_STATION_DETAIL T_R_SN_STATION_DETAIL rSnStationDetail = new T_R_SN_STATION_DETAIL(Station.SFCDB, DB_TYPE_ENUM.Oracle); //Add by LLF 2018-03-19 R_SN_STATION_DETAIL_ID = rSnStationDetail.GetNewID(Station.BU, Station.SFCDB); //string detailResult = rSnStationDetail.AddDetailToRSnStationDetail(R_SN_STATION_DETAIL_ID,rrSn.GetDataObject(), Station.Line, Station.StationName, Station.StationName, Station.SFCDB); string detailResult = rSnStationDetail.AddDetailToBipStationFailDetail( R_SN_STATION_DETAIL_ID, rrSn.GetDataObject(), Station.Line, Station.StationName, Station.StationName, Station.SFCDB, "1"); if (!(Convert.ToInt32(detailResult) > 0)) { throw new MESReturnMessage("Insert sn station detail error!"); } //update R_SN_STATION_DETAIL rSnStationDetail.UpdateRSnStationDetailBySNID(StrSn, PANELObj.SN, Station.SFCDB); //新增一筆到R_REPAIR_MAIN T_R_REPAIR_MAIN tRepairMain = new T_R_REPAIR_MAIN(Station.SFCDB, DB_TYPE_ENUM.Oracle); Row_R_REPAIR_MAIN rRepairMain = (Row_R_REPAIR_MAIN)tRepairMain.NewRow(); RepairmainID = tRepairMain.GetNewID(Station.BU, Station.SFCDB); //rRepairMain.ID = tRepairMain.GetNewID(Station.BU, Station.SFCDB); rRepairMain.ID = RepairmainID; rRepairMain.SN = StrSn; rRepairMain.WORKORDERNO = rrSn.WORKORDERNO; rRepairMain.SKUNO = rrSn.SKUNO; rRepairMain.FAIL_LINE = Station.Line; rRepairMain.FAIL_STATION = Station.StationName; rRepairMain.FAIL_EMP = Station.LoginUser.EMP_NO; //rRepairMain.FAIL_TIME = Station.GetDBDateTime();//Modify by LLF 2018-03-17 rRepairMain.FAIL_TIME = FailTime; //Modify by LLF 2018-03-17 rRepairMain.EDIT_EMP = Station.LoginUser.EMP_NO; rRepairMain.EDIT_TIME = Station.GetDBDateTime(); rRepairMain.CLOSED_FLAG = "1"; string insertResult = (Station.SFCDB).ExecSQL(rRepairMain.GetInsertString(DB_TYPE_ENUM.Oracle)); if (!(Convert.ToInt32(insertResult) > 0)) { throw new Exception("Insert repair main error!"); } } //新增一筆到R_REPAIR_FAILCODE T_R_REPAIR_FAILCODE tRepairFailCode = new T_R_REPAIR_FAILCODE(Station.SFCDB, DB_TYPE_ENUM.Oracle); Row_R_REPAIR_FAILCODE rRepairFailCode = (Row_R_REPAIR_FAILCODE)tRepairFailCode.NewRow(); rRepairFailCode.ID = tRepairFailCode.GetNewID(Station.BU, Station.SFCDB); //rRepairFailCode.REPAIR_MAIN_ID = rRepairMain.ID; //Modify by LLF 2018-04-11 多筆FAIL 取1一個RepairMainID rRepairFailCode.REPAIR_MAIN_ID = RepairmainID; rRepairFailCode.SN = StrSn; rRepairFailCode.FAIL_CODE = failCode; rRepairFailCode.FAIL_EMP = Station.LoginUser.EMP_NO; rRepairFailCode.FAIL_TIME = FailTime; rRepairFailCode.FAIL_CATEGORY = "SYMPTOM"; rRepairFailCode.FAIL_LOCATION = failLocation; rRepairFailCode.FAIL_PROCESS = failProcess; rRepairFailCode.DESCRIPTION = failDescription; rRepairFailCode.REPAIR_FLAG = "1"; rRepairFailCode.EDIT_EMP = Station.LoginUser.EMP_NO; rRepairFailCode.EDIT_TIME = Station.GetDBDateTime(); string strResult = (Station.SFCDB).ExecSQL(rRepairFailCode.GetInsertString(DB_TYPE_ENUM.Oracle)); if (!(Convert.ToInt32(strResult) > 0)) { throw new MESReturnMessage("Insert repair failcode error!"); } //oleDB.CommitTrain(); ReturnMessage.Append(failDescription).Append("|"); } //黃楊盛 2018年4月24日14:11:42 做一筆出來的記錄 R_SN snOut = rSn.GetDetailBySN(StrSn, Station.SFCDB); rrSn = (Row_R_SN)rSn.GetObjByID(snOut.ID, Station.SFCDB); rrSn.CURRENT_STATION = rrSn.NEXT_STATION; rrSn.NEXT_STATION = rSn.GetNextStation(snOut.ROUTE_ID, snOut.NEXT_STATION, oleDB); rrSn.REPAIR_FAILED_FLAG = "0"; rrSn.SN = StrSn; rrSn.EDIT_EMP = Station.LoginUser.EMP_NO; rrSn.EDIT_TIME = FailTime; var count = (Station.SFCDB).ExecSQL(rrSn.GetUpdateString(DB_TYPE_ENUM.Oracle)); if (!(Convert.ToInt32(count) > 0)) { throw new MESReturnMessage("update rsn failed flag error!"); } // 方國剛 2018.05.02 11:45:30 // 因拋賬計算過站數量時,不計算REPAIR_FAILED_FLAG=1的數量,故BIP Fail 的產品自動清除待維修狀態后再在過站記錄表記錄一筆REPAIR_FAILED_FLAG=0的記錄 T_R_SN_STATION_DETAIL rSnStationDetailRepaired = new T_R_SN_STATION_DETAIL(Station.SFCDB, DB_TYPE_ENUM.Oracle); R_SN_STATION_DETAIL_ID = rSnStationDetailRepaired.GetNewID(Station.BU, Station.SFCDB); string detailResultRepaired = rSnStationDetailRepaired.AddDetailToBipStationFailDetail( R_SN_STATION_DETAIL_ID, rrSn.GetDataObject(), Station.Line, Station.StationName, Station.StationName, Station.SFCDB, "0"); if (!(Convert.ToInt32(detailResultRepaired) > 0)) { throw new MESReturnMessage("Insert sn station detail error!"); } } catch (Exception e) { try { //APDB.RollbackTrain(); //oleDB.RollbackTrain(); } catch (Exception x) { ; } throw new MESReturnMessage(e.Message + e.StackTrace); } finally { //APDBPool.Return(APDB); } #endregion //add by zgj 2018-03-14 //當記錄完當前 SN 不良後,清除保存在 session 中的不良信息 //((List<Dictionary<string, string>>)FailListSession.Value).Clear(); if (ClearInputSession != null) { ClearInputSession.Value = "true"; } ReturnMessage.Remove(ReturnMessage.Length - 1, 1); Station.NextInput = Station.FindInputByName("PanelSn"); Station.AddMessage("MES00000158", new string[] { StrSn, ReturnMessage.ToString() }, MESReturnView.Station.StationMessageState.Pass); } else { Station.NextInput = Station.FindInputByName("Location"); Station.AddMessage("MES00000162", new string[] { StrSn, FailCount.ToString(), FailList.Count.ToString() }, MESReturnView.Station.StationMessageState.Message); } }
public static void WOInputResetAction(MESStation.BaseClass.MESStationBase Station, MESStation.BaseClass.MESStationInput Input, List <R_Station_Action_Para> Paras) { MESStationInput input = null; WorkOrder wo = null; double? TargetQty = 0.0d; double InputQty = 0.0d; if (Paras.Count != 2) { throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000050")); } //準備數據 begin MESStationSession WoCount = new MESStationSession(); WoCount.SessionKey = "1"; WoCount.MESDataType = "COUNT"; WoCount.Value = "100"; Station.StationSession.Add(WoCount); WorkOrder workorder = new WorkOrder(); workorder.Init(Input.Value.ToString(), Station.SFCDB); MESStationSession Wo = new MESStationSession(); Wo.SessionKey = "1"; Wo.MESDataType = "WO"; Wo.Value = workorder; Station.StationSession.Add(Wo); //準備數據 end MESStationSession WoInputCount = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY); if (WoInputCount == null) { //WoInputCount = new MESStationSession() { MESDataType = Paras[0].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[0].SESSION_KEY, ResetInput = Input }; //Station.StationSession.Add(WoInputCount); //throw new Exception("無法獲取工單投入總量,請確認"); throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE })); } MESStationSession WoInput = Station.StationSession.Find(t => t.MESDataType == Paras[1].SESSION_TYPE && t.SessionKey == Paras[1].SESSION_KEY); if (WoInput == null) { //WoInput = new MESStationSession() { MESDataType = Paras[1].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[1].SESSION_KEY, ResetInput = Input }; //Station.StationSession.Add(WoInput); //throw new Exception("無法獲取工單信息,請確認"); throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[1].SESSION_TYPE })); } wo = (WorkOrder)WoInput.Value; TargetQty = wo.WORKORDER_QTY; InputQty = double.Parse(WoInputCount.Value.ToString()); if (TargetQty <= InputQty) { input = Station.FindInputByName("WO"); if (input != null) { input.Enable = true; Station.NextInput = input; WoInputCount.InputValue = "0"; } Station.AddMessage( "MES00000030", new string[] { wo.WorkorderNo.ToString(), TargetQty.ToString(), WoInputCount.Value.ToString() }, MESReturnView.Station.StationMessageState.Message); } else { input = Station.FindInputByName("NEW_SN"); if (input != null) { Station.NextInput = input; WoInputCount.InputValue = InputQty++.ToString(); } } }