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