public void SETKCV(KCVVs input) { using (SQLiteTransaction tr = conn.BeginTransaction()) { SQLiteCommand cmd = new SQLiteCommand(conn); cmd.CommandText = "UPDATE KCV SET value = @value, open = @open where name = @name"; for (int i = 1; i <= 8; i++) { string key = "kcv" + i.ToString(); cmd.Parameters.AddWithValue("@value", input.KV[key]); cmd.Parameters.AddWithValue("@open", input.KC[key]); cmd.Parameters.AddWithValue("@name", key); cmd.ExecuteNonQuery(); } tr.Commit(); } }
public KCVVs ALLKCV() { KCVVs temp = new KCVVs(); temp.KC = new Dictionary <string, bool>(); temp.KV = new Dictionary <string, string>(); string sql = "SELECT * FROM KCV"; SQLiteCommand cmdQ = new SQLiteCommand(sql, this.conn); SQLiteDataReader reader = cmdQ.ExecuteReader(); while (reader.Read()) { string Name = reader.GetString(0); bool Open = reader.GetBoolean(1); string Value = reader.GetString(2); temp.KV[Name] = Value; temp.KC[Name] = Open; } return(temp); }