public void RemovePackConfig(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec db = DBPools["SFCDB"].Borrow();
try
{
JToken OBJ = Data["ID_LIST"];
//T_C_PACKING TCP = new T_C_PACKING(db, DB_TYPE_ENUM.Oracle);
T_C_PACKING TCP = new T_C_PACKING(db, DB_TYPE_ENUM.Oracle);
for (int i = 0; i < OBJ.Count(); i++)
{
Row_C_PACKING RCP = (Row_C_PACKING)TCP.GetObjByID(OBJ[i].ToString(), db);
db.ExecSQL(RCP.GetDeleteString(DB_TYPE_ENUM.Oracle));
}
StationReturn.Status = StationReturnStatusValue.Pass;
}
catch
{
}
finally
{
DBPools["SFCDB"].Return(db);
}
}
public void AlertPackConfig(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec db = DBPools["SFCDB"].Borrow();
try
{
JToken OBJ = Data["PackObj"];
T_C_PACKING TCP = new T_C_PACKING(db, DB_TYPE_ENUM.Oracle);
//判斷ID如果為空則插入,如果不為空則更新
if (OBJ["ID"].ToString() == "")
{
Row_C_PACKING RCP = (Row_C_PACKING)TCP.NewRow();
RCP.SKUNO = OBJ["SKUNO"].ToString();
RCP.PACK_TYPE = OBJ["PACK_TYPE"].ToString();
RCP.TRANSPORT_TYPE = OBJ["TRANSPORT_TYPE"].ToString();
RCP.INSIDE_PACK_TYPE = OBJ["INSIDE_PACK_TYPE"].ToString();
RCP.MAX_QTY = double.Parse(OBJ["MAX_QTY"].ToString());
RCP.DESCRIPTION = OBJ["DESCRIPTION"].ToString();
RCP.SN_RULE = OBJ["SN_RULE"].ToString();
RCP.EDIT_EMP = LoginUser.EMP_NO;
RCP.EDIT_TIME = DateTime.Now;
RCP.ID = TCP.GetNewID(BU, db);
db.ExecSQL(RCP.GetInsertString(DB_TYPE_ENUM.Oracle));
StationReturn.Status = StationReturnStatusValue.Pass;
}
else
{
Row_C_PACKING RCP = (Row_C_PACKING)TCP.GetObjByID(OBJ["ID"].ToString(), db);
RCP.SKUNO = OBJ["SKUNO"].ToString();
RCP.PACK_TYPE = OBJ["PACK_TYPE"].ToString();
RCP.TRANSPORT_TYPE = OBJ["TRANSPORT_TYPE"].ToString();
RCP.INSIDE_PACK_TYPE = OBJ["INSIDE_PACK_TYPE"].ToString();
RCP.MAX_QTY = double.Parse(OBJ["MAX_QTY"].ToString());
RCP.DESCRIPTION = OBJ["DESCRIPTION"].ToString();
RCP.SN_RULE = OBJ["SN_RULE"].ToString();
RCP.EDIT_EMP = LoginUser.EMP_NO;
RCP.EDIT_TIME = DateTime.Now;
db.ExecSQL(RCP.GetUpdateString(DB_TYPE_ENUM.Oracle));
StationReturn.Status = StationReturnStatusValue.Pass;
}
}
catch (Exception e)
{
throw e;
}
finally
{
DBPools["SFCDB"].Return(db);
}
}
