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);
}
