public void RemoveLabelConfig(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_SKU_Label TCSL = new T_C_SKU_Label(db, DB_TYPE_ENUM.Oracle);
for (int i = 0; i < OBJ.Count(); i++)
{
Row_C_SKU_Label RCKL = (Row_C_SKU_Label)TCSL.GetObjByID(OBJ[i].ToString(), db);
db.ExecSQL(RCKL.GetDeleteString(DB_TYPE_ENUM.Oracle));
}
StationReturn.Status = StationReturnStatusValue.Pass;
}
catch
{
}
finally
{
DBPools["SFCDB"].Return(db);
}
}
public void AlertLabelConfig(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec db = DBPools["SFCDB"].Borrow();
try
{
JToken OBJ = Data["LabelObject"];
//T_C_PACKING TCP = new T_C_PACKING(db, DB_TYPE_ENUM.Oracle);
T_C_SKU_Label TCSL = new T_C_SKU_Label(db, DB_TYPE_ENUM.Oracle);
//判斷ID如果為空則插入,如果不為空則更新
if (OBJ["ID"].ToString() == "")
{
Row_C_SKU_Label RCKL = (Row_C_SKU_Label)TCSL.NewRow();
RCKL.SKUNO = OBJ["SKUNO"].ToString();
RCKL.STATION = OBJ["STATION"].ToString();
RCKL.SEQ = double.Parse(OBJ["SEQ"].ToString());
RCKL.QTY = double.Parse(OBJ["QTY"].ToString());
RCKL.LABELNAME = OBJ["LABELNAME"].ToString();
RCKL.LABELTYPE = OBJ["LABELTYPE"].ToString();
RCKL.EDIT_EMP = LoginUser.EMP_NO;
RCKL.EDIT_TIME = DateTime.Now;
RCKL.ID = TCSL.GetNewID(BU, db);
db.ExecSQL(RCKL.GetInsertString(DB_TYPE_ENUM.Oracle));
}
else
{
Row_C_SKU_Label RCKL = (Row_C_SKU_Label)TCSL.GetObjByID(OBJ["ID"].ToString(), db);
RCKL.SKUNO = OBJ["SKUNO"].ToString();
RCKL.STATION = OBJ["STATION"].ToString();
RCKL.SEQ = double.Parse(OBJ["SEQ"].ToString());
RCKL.QTY = double.Parse(OBJ["QTY"].ToString());
RCKL.LABELNAME = OBJ["LABELNAME"].ToString();
RCKL.LABELTYPE = OBJ["LABELTYPE"].ToString();
RCKL.EDIT_EMP = LoginUser.EMP_NO;
RCKL.EDIT_TIME = DateTime.Now;
RCKL.ID = TCSL.GetNewID(BU, db);
db.ExecSQL(RCKL.GetUpdateString(DB_TYPE_ENUM.Oracle));
}
}
catch
{
}
finally
{
DBPools["SFCDB"].Return(db);
}
}
