/// <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);
}
}
