public void insert(RqGasInfo gas) { OracleParameter[] parms = GetAdapterParameters(); SetAdapterParameters(parms, gas); try { OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionStringOrderDistributedTransaction, CommandType.Text, SQL_INSERT_RQGAS, parms); } catch (Exception e) { throw (e); } }
/// <summary> /// A method to insert a new Adapter /// </summary> /// <param name="gas">An adapter entity with information about the new adapter</param> public void insert(RqGasInfo gas) { // Validate input if (gas.DBID <= 0) { return; } if (string.IsNullOrEmpty(gas.DEVID)) { return; } IRqGas dal = SensorHub.DALFactory.RqGas.Create(); dal.insert(gas); }
/// <summary> /// An internal function to bind values parameters for insert /// </summary> /// <param name="parms">Database parameters</param> /// <param name="gas">Values to bind to parameters</param> private void SetAdapterParameters(OracleParameter[] parms, RqGasInfo gas) { parms[0].Value = gas.DBID; parms[1].Value = gas.DEVID; if (null != gas.LEAKDATA) { parms[2].Value = gas.LEAKDATA; } else { parms[2].Value = DBNull.Value; } if (null != gas.INPRESS) { parms[3].Value = gas.INPRESS; } else { parms[3].Value = DBNull.Value; } if (null != gas.OUTPRESS) { parms[4].Value = gas.OUTPRESS; } else { parms[4].Value = DBNull.Value; } if (null != gas.TEMPGAS) { parms[5].Value = gas.TEMPGAS; } else { parms[5].Value = DBNull.Value; } if (null != gas.TEMPROOM) { parms[6].Value = gas.TEMPROOM; } else { parms[6].Value = DBNull.Value; } if (null != gas.CELLPOWER) { parms[7].Value = gas.CELLPOWER; } else { parms[7].Value = DBNull.Value; } if (null != gas.RECORDTIME) { parms[8].Value = gas.RECORDTIME; } else { parms[8].Value = DBNull.Value; } }