public Meter[] GetMetersByTcpIPGUID(Guid guid_tcpip) { string query = "SELECT meters.guid, name, address, password, password_type_hex, factory_number_manual, factory_number_readed, is_factory_numbers_equal, dt_install, dt_last_read, guid_types_meters, meters.guid_meters, time_delay_current FROM meters " + "JOIN link_meters_tcpip_settings ON link_meters_tcpip_settings.guid_tcpip_settings ='" + guid_tcpip.ToString() + "' " + "WHERE meters.guid = link_meters_tcpip_settings.guid_meters"; List<Object> list = GetRecordsFromReader(query, RetrieveMeter); Meter[] result = new Meter[list.Count]; for (int i = 0; i < list.Count; i++) { result[i] = (Meter)list[i]; } list.Clear(); return result; }
public Meter[] GetMetersHavingTakenParam() { string query = "SELECT guid, name, address, password, password_type_hex, factory_number_manual, factory_number_readed, is_factory_numbers_equal, dt_install, dt_last_read, guid_types_meters, guid_meters, time_delay_current FROM meters " + "GROUP BY guid HAVING (SELECT COUNT(*) FROM taken_params WHERE taken_params.guid_meters = meters.guid) > 0"; List<Object> list = GetRecordsFromReader(query, RetrieveMeter); Meter[] result = new Meter[list.Count]; for (int i = 0; i < list.Count; i++) { result[i] = (Meter)list[i]; } list.Clear(); return result; }
public Meter[] GetMeters() { string query = "SELECT guid, name, address, password, password_type_hex, factory_number_manual, factory_number_readed, is_factory_numbers_equal, dt_install, dt_last_read, guid_types_meters, guid_meters, time_delay_current FROM meters"; List<Object> list = GetRecordsFromReader(query, RetrieveMeter); Meter[] result = new Meter[list.Count]; for (int i = 0; i < list.Count; i++) { result[i] = (Meter)list[i]; } list.Clear(); return result; }