protected TrackerPacketList GetPoint(CDatabase db) { TrackerPacket[] pt = new TrackerPacket[m_config.MaxPoints]; try { TrackerPacketList points = new TrackerPacketList(); if (points.Load(db, "SELECT TrackerID, Time, Lat, Lng,Alt,Speed,Status,IO,GSMInfo FROM lastpoint WHERE TrackerID=" + m_Tracker.m_nID + " and Time>0 and Time<=UNIX_TIMESTAMP(now()) and Lat>0" + pt.Length)) { return(points); } } catch (Exception ex) { m_Logger.Push(LogLevel.ERROR, 0, "Error while points query " + ex.ToString()); } return(null); }
protected TrackerPacketList GetPoint(CDatabase db) { TrackerPacket[] pt = new TrackerPacket[m_config.MaxPoints]; try { TrackerPacketList points = new TrackerPacketList(); if (points.Load(db, "SELECT TrackerID, Time, Lat, Lng, Alt, Speed, Status, IO, GSMInfo FROM curpos WHERE TrackerID=" + m_Tracker.m_nID + " order by Time desc LIMIT " + pt.Length)) { return(points); } } catch (Exception ex) { m_Logger.Push(LogLevel.ERROR, 0, "Error while points query " + ex.ToString()); } return(null); }
void Load() { List <TrackerPacket> newPackets = new List <TrackerPacket>(); try { using (CDatabase db = Configuration.inst().GetDB()) { if (!db.IsConnected()) { m_Logger.Push(LogLevel.ERROR, 0, "Could not connect to database"); return; } //загрузка точек TrackerPacketList list = new TrackerPacketList(); list.Load(db, "SELECT TrackerID, Time, Lat, Lng, Alt, Speed, Status, IO, GSMInfo FROM " + m_strTable); for (int i = 0; i < list.Count; i++) { TrackerPacket packet = list[i]; if (packet.IsValid()) { lock (m_Points) if (!m_Points.ContainsKey(packet.m_ID) || m_Points[packet.m_ID].m_Time != packet.m_Time) { m_Points[packet.m_ID] = packet; newPackets.Add(packet); } } } } for (int i = 0; i < newPackets.Count; i++) { OnCurPosChange(newPackets[i]); } } catch (Exception e) { m_Logger.Push(LogLevel.ERROR, 0, e.ToString()); } }