/// <summary> /// 初始化工站時加載出默認的維修大項,維修小項LIST /// </summary> /// <param name="Station"></param> /// <param name="Input">RootCause輸入值轉換為大寫</param> /// <param name="Paras">ErrorCode</param> public static void RepairItemsInitDataloader(MESStation.BaseClass.MESStationBase Station, MESStation.BaseClass.MESStationInput Input, List <MESDataObject.Module.R_Station_Action_Para> Paras) { T_C_REPAIR_ITEMS RepairItems = new T_C_REPAIR_ITEMS(Station.SFCDB, Station.DBType); Row_C_REPAIR_ITEMS RowItems; T_C_REPAIR_ITEMS_SON RepairItemsSon = new T_C_REPAIR_ITEMS_SON(Station.SFCDB, Station.DBType); List <string> RepairItemsSonList = new List <string>(); List <string> RepairItemsList = new List <string>(); T_C_REPAIR_ITEMS TC_REPAIR_ITEM = new T_C_REPAIR_ITEMS(Station.SFCDB, MESDataObject.DB_TYPE_ENUM.Oracle); string ITEM_NAME = Input.Value.ToString(); MESStationInput I = Station.Inputs.Find(t => t.DisplayName == "Son_Items"); try { Input.DataForUse.Clear(); //RepairItemsList = TC_REPAIR_ITEM.GetRepairItemsList(ITEM_NAME, Station.SFCDB); //Input.DataForUse.Add(RepairItemsList);//初始化維修大項 RowItems = RepairItems.GetIDByItemName(ITEM_NAME, Station.SFCDB); RepairItemsSonList = RepairItemsSon.GetRepairItemsSonList(RowItems.ID, Station.SFCDB); Input.DataForUse.Add(RepairItemsSonList); //初始化維修小項 Station.AddMessage("MES00000001", new string[] { }, MESReturnView.Station.StationMessageState.Message); } catch (Exception ex) { string msgCode = ex.Message; throw ex; } }
// <summary> ///獲取C_REPAIR_ITEMS_SON的維修小項信息 /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void GetRepairItemsSon(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn) { OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); string ITEMS_SON = Data["ItemSon"].ToString(); List <string> RepairItemsSonList = new List <string>(); T_C_REPAIR_ITEMS_SON TC_REPAIR_ITEM_SON = new T_C_REPAIR_ITEMS_SON(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle); T_C_REPAIR_ITEMS RepairItems = new T_C_REPAIR_ITEMS(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle); Row_C_REPAIR_ITEMS RowItems; RowItems = RepairItems.GetIDByItemName(ITEMS_SON, sfcdb); RepairItemsSonList = TC_REPAIR_ITEM_SON.GetRepairItemsSonList(RowItems.ID, sfcdb); StationReturn.Data = RepairItemsSonList; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; 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); } }