public static List <ForceSensorRFD> SelectAll(bool dbconOpened) { openIfNeeded(dbconOpened); dbcmd.CommandText = "SELECT * FROM " + table + " WHERE code != \"I\""; LogB.SQL(dbcmd.CommandText.ToString()); dbcmd.ExecuteNonQuery(); SqliteDataReader reader = dbcmd.ExecuteReader(); List <ForceSensorRFD> l = new List <ForceSensorRFD>(); while (reader.Read()) { ForceSensorRFD rfd = new ForceSensorRFD( reader[0].ToString(), //code Util.IntToBool(Convert.ToInt32(reader[1])), //active (ForceSensorRFD.Functions)Enum.Parse( typeof(ForceSensorRFD.Functions), reader[2].ToString()), //function (ForceSensorRFD.Types)Enum.Parse( typeof(ForceSensorRFD.Types), reader[3].ToString()), //type Convert.ToInt32(reader[4]), //num1 Convert.ToInt32(reader[5]) //num2 ); l.Add(rfd); } reader.Close(); closeIfNeeded(dbconOpened); return(l); }
public static void Insert(bool dbconOpened, ForceSensorRFD rfd) { openIfNeeded(dbconOpened); dbcmd.CommandText = "INSERT INTO " + table + " (code, active, function, type, num1, num2) VALUES (" + rfd.ToSQLInsertString() + ")"; LogB.SQL(dbcmd.CommandText.ToString()); dbcmd.ExecuteNonQuery(); closeIfNeeded(dbconOpened); }
public bool Changed(ForceSensorRFD newRFD) { if ( code == newRFD.code && active == newRFD.active && function == newRFD.function && type == newRFD.type && num1 == newRFD.num1 && num2 == newRFD.num2) { return(false); } return(true); }
public static void Update(bool dbconOpened, ForceSensorRFD rfd) { openIfNeeded(dbconOpened); dbcmd.CommandText = "UPDATE " + table + " SET " + " active = " + Util.BoolToInt(rfd.active).ToString() + "," + " function = \"" + rfd.function.ToString() + "\"" + "," + " type = \"" + rfd.type.ToString() + "\"" + "," + " num1 = " + rfd.num1.ToString() + "," + " num2 = " + rfd.num2.ToString() + " WHERE code = \"" + rfd.code + "\""; LogB.SQL(dbcmd.CommandText.ToString()); dbcmd.ExecuteNonQuery(); closeIfNeeded(dbconOpened); }