public void Update(NpgsqlConnection connection, AlarmSampleId[] alarms, DateTime acknowledgeTime, long? userId)
{
var query = _npgQueryHelper.UpdateWhere(
_tableName,
new And(
new Or(alarms.Select(a => new And(new Eq(DbStr.StartTime, a.StartTime.Ticks), new Eq(DbStr.AlarmId, a.AlarmId))).Cast<IWhereOp>().ToArray()),
new IsNull(DbStr.AcknowledgeTime)),
new[] { DbStr.AcknowledgeTime, DbStr.UserId },
new object[] { acknowledgeTime.Ticks, userId });
_npgHelper.ExecuteNonQuery(connection, query);
}
public void Update(NpgsqlConnection connection, AlarmSampleId[] alarms, DateTime endTime)
{
var query = _npgQueryHelper.UpdateWhere(
_tableName,
new Or(alarms.Select(a =>
new And(new Eq(DbStr.StartTime, a.StartTime.Ticks), new Eq(DbStr.AlarmId, a.AlarmId)))
.Cast<IWhereOp>().ToArray()),
new[] {DbStr.EndTime},
new object[] {endTime.Ticks});
_npgHelper.ExecuteNonQuery(connection, query);
}
