private void updateRemState(int state)
{
btnGood.Checked = (state == 1);
btnBad.Checked = (state == 2);
SQLiteCommand cmd = new SQLiteCommand("UPDATE words SET `state`=@state WHERE `id`=@id", Gib.con);
cmd.Parameters.AddWithValue("@state", state);
cmd.Parameters.AddWithValue("@id", words[cur].id);
cmd.ExecuteNonQuery();
Gib.Word item = words[cur];
item.state = state;
words[cur] = item;
refreshGoodBadCount();
}
public void getWordList()
{
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM words WHERE `group`=@group", Gib.con);
// ORDER BY `word`
cmd.Parameters.AddWithValue("@group", Gib.curGroup);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read()) {
Gib.Word item = new Gib.Word();
item.id = Convert.ToInt32(reader["id"]);
item.word = reader["word"].ToString();
item.trans = reader["trans"].ToString();
item.state = Convert.ToInt32(reader["state"]);
words.Add(item);
}
}
public void getWordList()
{
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM words WHERE `group`=@group", Gib.con);
// ORDER BY `word`
cmd.Parameters.AddWithValue("@group", Gib.curGroup);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Gib.Word item = new Gib.Word();
item.id = Convert.ToInt32(reader["id"]);
item.word = reader["word"].ToString();
item.trans = reader["trans"].ToString();
item.state = Convert.ToInt32(reader["state"]);
words.Add(item);
}
}
