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