public void Process(BoilerWaterCoolingEvent _event)
{
try
{
this._Module._Heat.BoilerWaterCoolingHistory.Add(_event);
}
catch {}
}
private bool InsertOrUpdateTrends(BoilerWaterCoolingEvent evt)
{
var sql = CheckInsert("TREND_OFFGAS", evt.iCnvNr, evt.Time)
? "UPDATE TREND_OFFGAS " +
"SET TEMPONEXIT = :TEMPONEXIT, TEMPPRECOLLING = :TEMPPRECOLLING, TEMPSTEP1 = :TEMPSTEP1, TEMPSTEP2 = :TEMPSTEP2 " +
"WHERE CNV_NO = :CNV_NO AND INSERTTIME = :INSERTTIME "
: "INSERT INTO TREND_OFFGAS(TEMPONEXIT, TEMPPRECOLLING, TEMPSTEP1, TEMPSTEP2, CNV_NO, INSERTTIME) " +
"VALUES (:TEMPONEXIT, :TEMPPRECOLLING, :TEMPSTEP1, :TEMPSTEP2, :CNV_NO, :INSERTTIME) ";
var parametres = new List<OracleParameter>
{
SetParams("TEMPONEXIT", evt.GasTemperatureOnExit),
SetParams("TEMPPRECOLLING", evt.PrecollingGasTemperature),
SetParams("TEMPSTEP1", evt.GasTemperatureAfter1Step),
SetParams("TEMPSTEP2", evt.GasTemperatureAfter2Step)
};
parametres.AddRange(MandatoryParams(evt.iCnvNr, evt.Time));
return ExecuteNonQuery(sql, parametres);
}