internal bool DeleteRfDevice(RfClient dev) { string sql = string.Format("DELETE FROM rf_client where rfid = '{0}'", dev.rfid); int row = mSql.ExcuteSql(sql); return(row >= 1); }
public bool AddRfClient(RfClient rf) { string str = "INSERT INTO `rf_client`(`rfid`, `name`, `ip`, `conn_time`, `disconn_time`)" + " VALUES('{0}', '{1}', '{2}', {3}, {4})"; string sql = string.Format(@str, rf.rfid, rf.name, rf.ip, GetTimeOrNull(rf.conn_time), GetTimeOrNull(rf.disconn_time)); int row = mSql.ExcuteSql(sql); return(row >= 1); }
public bool EditRfDevice(RfClient rf) { string sql = "UPDATE `rf_client` SET `name` = '{0}', `ip` = '{1}', `conn_time` = {2}, `disconn_time` = {3} " + "WHERE `rfid` = '{4}';"; sql = string.Format(sql, rf.name, rf.ip, GetTimeOrNull(rf.conn_time), GetTimeOrNull(rf.disconn_time), rf.rfid); int row = mSql.ExcuteSql(sql); return(row >= 1); }