void LoadT_c_station_action(string C_STATION_ACTION_ID, OleExec SFCDB)
{
T_c_station_action TCSA = new T_c_station_action(SFCDB, DB_TYPE_ENUM.Oracle);
Row_c_station_action RCSA = (Row_c_station_action)TCSA.GetObjByID(C_STATION_ACTION_ID, SFCDB);
CAction = RCSA.GetDataObject();
}
public void AddCStationAcation(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string InsertSql = "";
T_c_station_action stationaction;
string ActionType = Data["ActionType"].ToString().Trim();
string ActionName = Data["ActionName"].ToString().Trim();
string DllName = Data["DllName"].ToString().Trim();
string ClassName = Data["ClassName"].ToString();
string FunctionName = Data["FunName"].ToString();
string Desc = Data["Desc"].ToString();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
stationaction = new T_c_station_action(sfcdb, DBTYPE);
if (stationaction.CheckDataExist(FunctionName, sfcdb))
{
Row_c_station_action row = (Row_c_station_action)stationaction.NewRow();
row.ID = stationaction.GetNewID(BU, sfcdb);
row.ACTION_TYPE = ActionType;
row.ACTION_NAME = ActionName;
row.DLL_NAME = DllName;
row.CLASS_NAME = ClassName;
row.FUNCTION_NAME = FunctionName;
row.DESCRIPTION = Desc;
row.EDIT_EMP = LoginUser.EMP_NO;
row.EDIT_TIME = GetDBDateTime();
InsertSql = row.GetInsertString(DBTYPE);
sfcdb.ExecSQL(InsertSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = row.ID;
StationReturn.MessageCode = "MES00000002";
this.DBPools["SFCDB"].Return(sfcdb);
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000005";
}
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void DeleteCStationAcation(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string DeleteSql = "";
string StrID = "";
T_c_station_action stationaction;
T_R_Station_Action saction;
Newtonsoft.Json.Linq.JArray ID = (Newtonsoft.Json.Linq.JArray)Data["ID"];
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.BeginTrain();
stationaction = new T_c_station_action(sfcdb, DBTYPE);
saction = new T_R_Station_Action(sfcdb, DBTYPE);
for (int i = 0; i < ID.Count; i++)
{
StrID = ID[i].ToString();
if (saction.CheckExistByCSActionID(StrID, sfcdb))
{
Row_c_station_action row = (Row_c_station_action)stationaction.GetObjByID(StrID, sfcdb);
DeleteSql = row.GetDeleteString(DBTYPE);
sfcdb.ExecSQL(DeleteSql);
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000113";
sfcdb.RollbackTrain();
this.DBPools["SFCDB"].Return(sfcdb);
return;
}
}
sfcdb.CommitTrain();
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000004";
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
sfcdb.RollbackTrain();
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// 更新標簽顯示語言數據
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void UpdateCStationAcation(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string UpdateSql = "";
T_c_station_action stationaction;
string ID = Data["ID"].ToString().Trim();
string ActionType = Data["ActionType"].ToString().Trim();
string ActionName = Data["ActionName"].ToString().Trim();
string DllName = Data["DllName"].ToString().Trim();
string ClassName = Data["ClassName"].ToString();
string FunctionName = Data["FunName"].ToString();
string Desc = Data["Desc"].ToString();
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
stationaction = new T_c_station_action(sfcdb, DBTYPE);
Row_c_station_action row = (Row_c_station_action)stationaction.GetObjByID(Data["ID"].ToString().Trim(), sfcdb);
row.ACTION_TYPE = ActionType;
row.ACTION_NAME = ActionName;
row.DLL_NAME = DllName;
row.CLASS_NAME = ClassName;
row.FUNCTION_NAME = FunctionName;
row.DESCRIPTION = Desc;
row.EDIT_EMP = LoginUser.EMP_NO;
row.EDIT_TIME = GetDBDateTime();
UpdateSql = row.GetUpdateString(DBTYPE);
sfcdb.ExecSQL(UpdateSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000003";
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
