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