/// <summary>
/// Helper method for GetFirstUnprocessedKwsEvent() and GetLastKwsEvent().
/// </summary>
private AnpMsg GetKwsEventFromQuery(String s)
{
Object res = m_db.GetCmd(s).ExecuteScalar();
if (res == null) return null;
AnpMsg m = new AnpMsg();
m.FromByteArray((byte[])res);
return m;
}
public AnpMsg[] GetNewKwsEvent(UInt64 kwsID, UInt64 evtID)
{
String s = "SELECT evt_data FROM kws_events WHERE kws_id = " + kwsID +
" AND evt_id > " + evtID + " ORDER BY evt_id;";
List<AnpMsg> res = new List<AnpMsg>();
DbDataReader reader = m_db.GetCmd(s).ExecuteReader();
if (reader == null) return null;
long buflength = 1024;
byte[] buf = new byte[buflength];
do
{
AnpMsg m = new AnpMsg();
m.FromByteArray((byte[])reader.GetValue(0));
res.Add(m);
} while (reader.Read());
return res.ToArray();
}