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