public void DeleteCAqltype(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_AQLTYPE cAqultype = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cAqultype = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);
Row_C_AQLTYPE r = (Row_C_AQLTYPE)cAqultype.GetObjByID((Data["ID"].ToString()).Trim(), sfcdb);
string strRet = sfcdb.ExecSQL(r.GetDeleteString(DB_TYPE_ENUM.Oracle));
if (Convert.ToInt32(strRet) > 0)
{
StationReturn.Message = "刪除成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = "";
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void AddCAqltype(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_AQLTYPE cAqultype = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cAqultype = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);
Row_C_AQLTYPE r = (Row_C_AQLTYPE)cAqultype.NewRow();
r.ID = cAqultype.GetNewID(this.BU, sfcdb);
r.AQL_TYPE = (Data["AQL_TYPE"].ToString()).Trim();
r.LOT_QTY = Convert.ToDouble((Data["LOT_QTY"].ToString()).Trim());
r.GL_LEVEL = (Data["GL_LEVEL"].ToString()).Trim();
r.SAMPLE_QTY = Convert.ToDouble((Data["SAMPLE_QTY"].ToString()).Trim());
r.ACCEPT_QTY = Convert.ToDouble((Data["ACCEPT_QTY"].ToString()).Trim());
r.REJECT_QTY = Convert.ToDouble((Data["REJECT_QTY"].ToString()).Trim());
r.EDIT_EMP = this.LoginUser.EMP_NO;
r.EDIT_TIME = GetDBDateTime();
string strRet = sfcdb.ExecSQL(r.GetInsertString(DB_TYPE_ENUM.Oracle));
if (Convert.ToInt32(strRet) > 0)
{
StationReturn.Message = "添加成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = "";
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
