public void addRecord(string w, float error) { print("save score:" + Word.getScore(error)); database.addRecord(new writeRecord(w, Word.getScore(error), database.getTime())); if (_wordRecord != null) { foreach (wordRecord word in _wordRecord) { if (word.word == w) { word.addRecord(Word.getScore(error), database.getTime()); print(word.records.Count); return; } } wordRecord wr = new wordRecord(w); wr.addRecord(Word.getScore(error), database.getTime()); wordRecord[] nRecords = new wordRecord[_wordRecord.Length + 1]; _wordRecord.CopyTo(nRecords, 0); nRecords[_wordRecord.Length] = wr; _wordRecord = nRecords; } }
public wordRecord getOrderedRecords(string r, int limit) { if (r == null) { return(null); } string query = "SELECT * FROM history WHERE word='" + r + "' ORDER BY time DESC"; if (limit != 0) { query += " LIMIT " + limit; } try { dbcmd = dbcon.CreateCommand(); dbcmd.CommandText = query; reader = dbcmd.ExecuteReader(); } catch (Exception e) { Debug.Log(e); errMsg = e.ToString(); return(null); } wordRecord record = new wordRecord(r); while (reader.Read()) { float score = reader.GetFloat(1); System.DateTime time = (System.DateTime)reader.GetValue(2); record.addRecord(score, time); } return(record); }