/// <summary> /// 檢查輸入的Action_code是否存在 /// </summary> /// <param name="Station"></param> /// <param name="Input"></param> /// <param name="Paras"></param> public static void ActionCodeDataChecker(MESPubLab.MESStation.MESStationBase Station, MESPubLab.MESStation.MESStationInput Input, List <MESDataObject.Module.R_Station_Action_Para> Paras) { if (Paras.Count != 1) { throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000050")); } string ActionCodeInput = ""; MESStationSession sessionActionCode = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY); if (sessionActionCode == null) { throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE + Paras[0].SESSION_KEY })); } if (sessionActionCode.Value == null) { throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE + Paras[0].SESSION_KEY })); } try { T_C_ACTION_CODE t_c_action_code = new T_C_ACTION_CODE(Station.SFCDB, Station.DBType); C_ACTION_CODE c_action_code = new C_ACTION_CODE(); c_action_code = t_c_action_code.GetByActionCode(sessionActionCode.Value.ToString(), Station.SFCDB); if (c_action_code == null) { throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000007", new string[] { "ActionCode", ActionCodeInput })); } Station.AddMessage("MES00000026", new string[] { }, MESPubLab.MESStation.MESReturnView.Station.StationMessageState.Pass); } catch (Exception ex) { throw ex; } }
public void DeleteActionCodeById(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); string strId = Data["Id"].ToString().Trim(); T_C_ACTION_CODE TC_ACTION_CODE = new T_C_ACTION_CODE(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle); C_ACTION_CODE SelectActionCode = new C_ACTION_CODE(); SelectActionCode = TC_ACTION_CODE.GetByid(strId, sfcdb); if (SelectActionCode == null) { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000007"; StationReturn.MessagePara.Add(strId); } else { int result = TC_ACTION_CODE.DeleteById(strId, sfcdb); if (result > 0) { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; } else { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000023"; StationReturn.MessagePara.Add(strId); } } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception ex) { if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(ex.Message); } }
public void GetByActionCode(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_ACTION_CODE TC_ACTION_CODE = new T_C_ACTION_CODE(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle); C_ACTION_CODE SelectActionCode = new C_ACTION_CODE(); string ActionCode = Data["ActionCode"].ToString(); SelectActionCode = TC_ACTION_CODE.GetByActionCode(ActionCode, sfcdb); if (SelectActionCode != null) { StationReturn.Data = SelectActionCode; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; } else { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000007"; StationReturn.MessagePara.Add(ActionCode); } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception ex) { if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(ex.Message); } }
public void UpdateActionCodeById(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); T_C_ACTION_CODE TC_ACTION_CODE = new T_C_ACTION_CODE(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle); C_ACTION_CODE SelectActionCode = new C_ACTION_CODE(); string strId = Data["Id"].ToString().Trim(); string ActionCode = Data["ActionCode"].ToString().Trim(); string EDescription = Data["EnglishDescription"].ToString().Trim(); string CDescription = Data["ChineseDescription"].ToString().Trim(); if (ActionCode.Length <= 0) { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("ActionCode"); this.DBPools["SFCDB"].Return(sfcdb); return; } if (EDescription.Length <= 0) { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("EnglishDescription"); this.DBPools["SFCDB"].Return(sfcdb); return; } if (CDescription.Length <= 0) { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("ChineseDescription"); this.DBPools["SFCDB"].Return(sfcdb); return; } SelectActionCode = TC_ACTION_CODE.GetByid(strId, sfcdb); if (SelectActionCode == null) { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000007"; StationReturn.MessagePara.Add("Id:" + strId); this.DBPools["SFCDB"].Return(sfcdb); return; } SelectActionCode = TC_ACTION_CODE.GetByActionCode(ActionCode, sfcdb); if (SelectActionCode != null && SelectActionCode.ID != strId) { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000008"; StationReturn.MessagePara.Add(ActionCode); this.DBPools["SFCDB"].Return(sfcdb); return; } C_ACTION_CODE NewActionCode = new C_ACTION_CODE(); NewActionCode.ID = strId; NewActionCode.ACTION_CODE = ActionCode; NewActionCode.ENGLISH_DESCRIPTION = EDescription; NewActionCode.CHINESE_DESCRIPTION = CDescription; NewActionCode.EDIT_EMP = LoginUser.EMP_NO; NewActionCode.EDIT_TIME = GetDBDateTime(); int result = TC_ACTION_CODE.UpdateById(NewActionCode, sfcdb); if (result > 0) { StationReturn.Data = NewActionCode; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; } else { StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000025"; StationReturn.MessagePara.Add(ActionCode); } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception ex) { if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } StationReturn.Data = ""; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(ex.Message); } }