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