public void DeleteMESMessageByID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec Sfcdb = null;
T_C_MES_MESSAGE C_Mes_Message = null;
Row_C_MES_MESSAGE Row_C_Mes_Message = null;
string DeleteSql = "";
try
{
string ID = Data["ID"].ToString();
Sfcdb = this.DBPools["SFCDB"].Borrow();
C_Mes_Message = new T_C_MES_MESSAGE(Sfcdb, DBTYPE);
Row_C_Mes_Message = (Row_C_MES_MESSAGE)C_Mes_Message.GetObjByID(ID, Sfcdb);
DeleteSql = Row_C_Mes_Message.GetDeleteString(DBTYPE);
Sfcdb.ExecSQL(DeleteSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000004";
StationReturn.Message = "By ID刪除Message OK!";
this.DBPools["SFCDB"].Return(Sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(Sfcdb);
throw (e);
}
}
public void AddMESMessage(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec Sfcdb = null;
T_C_MES_MESSAGE C_Mes_Message = null;
Row_C_MES_MESSAGE Row_C_Mes_Message = null;
string InsertSql = "";
try
{
string MessageCode = Data["MessageCode"].ToString();
string Chinese = Data["Chinese"].ToString();
string English = Data["English"].ToString();
string Chinese_TW = Data["Chinese_TW"].ToString();
Sfcdb = this.DBPools["SFCDB"].Borrow();
//GET MESSAGE CODE TEST
//string MessageCode = new T_C_SEQNO(Sfcdb, DB_TYPE_ENUM.Oracle).GetLotno("MESMSGCODE", Sfcdb);
C_Mes_Message = new T_C_MES_MESSAGE(Sfcdb, DBTYPE);
Row_C_Mes_Message = C_Mes_Message.GetMESMessageByMessageCode(MessageCode, Sfcdb, DBTYPE);
//
if (Row_C_Mes_Message != null)
{
this.DBPools["SFCDB"].Return(Sfcdb);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000005";
StationReturn.Message = "MessageCode已經存在!";
return;
}
//C_Mes_Message = new T_C_MES_MESSAGE(Sfcdb, DBTYPE);
Row_C_Mes_Message = (Row_C_MES_MESSAGE)C_Mes_Message.NewRow();
Row_C_Mes_Message.ID = C_Mes_Message.GetNewID(BU, Sfcdb);
Row_C_Mes_Message.MESSAGE_CODE = MessageCode;
Row_C_Mes_Message.CHINESE = Chinese;
Row_C_Mes_Message.ENGLISH = English;
Row_C_Mes_Message.CHINESE_TW = Chinese_TW;
Row_C_Mes_Message.EDIT_EMP = LoginUser.EMP_NO;
Row_C_Mes_Message.EDIT_TIME = GetDBDateTime();
InsertSql = Row_C_Mes_Message.GetInsertString(DBTYPE);
Sfcdb.ExecSQL(InsertSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000002";
StationReturn.Message = "新增MessageCode OK!";
this.DBPools["SFCDB"].Return(Sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(Sfcdb);
throw (e);
}
}
public void UpdateMESMessage(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec Sfcdb = null;
string UpdateSql = "";
T_C_MES_MESSAGE C_Mes_Message = null;
Row_C_MES_MESSAGE Row_C_Mes_Message = null;
try
{
string ID = Data["ID"].ToString();
string MessageCode = Data["MessageCode"].ToString();
string Chinese = Data["Chinese"].ToString();
string English = Data["English"].ToString();
string Chinese_TW = Data["Chinese_TW"].ToString();
Sfcdb = this.DBPools["SFCDB"].Borrow();
C_Mes_Message = new T_C_MES_MESSAGE(Sfcdb, DBTYPE);
Row_C_Mes_Message = (Row_C_MES_MESSAGE)C_Mes_Message.GetObjByID(Data["ID"].ToString(), Sfcdb);
if (Row_C_Mes_Message == null)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000007";
StationReturn.MessagePara = new List <object>()
{
MessageCode
};
return;
}
Row_C_Mes_Message.ID = ID;
Row_C_Mes_Message.MESSAGE_CODE = MessageCode;
Row_C_Mes_Message.CHINESE = Chinese;
Row_C_Mes_Message.ENGLISH = English;
Row_C_Mes_Message.CHINESE_TW = Chinese_TW;
UpdateSql = Row_C_Mes_Message.GetUpdateString(DBTYPE);
Sfcdb.ExecSQL(UpdateSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000003";
StationReturn.Message = "MessageCode更新OK!";
this.DBPools["SFCDB"].Return(Sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(Sfcdb);
throw (e);
}
}
