空调设置组件 - Qt 代码优化与 SEO 优化

#include 'aircondition.h' #include 'ui_aircondition.h' #include 'switchform.h' #include 'lcdform.h' #include 'sqlite.h' #include #include #include #include #include #include

AirCondition::AirCondition(int userid,QWidget parent) : QWidget(parent), ui(new Ui::AirCondition), userid(userid) { ui->setupUi(this); airConditionWidget(); //连接开关组件的信号和自定义的槽函数 connect(ui->SwitchStatus,&SwitchForm::statusChanged,this,&AirCondition::switchButton_status); connect(ui->temperature->findChild<QDoubleSpinBox>('doubleSpinBox'), QOverload::of(&QDoubleSpinBox::valueChanged), this, &AirCondition::temperature_changed); // 加载上次更改的状态 loadLastStatus(); ui->SwitchStatus->setEnabled(true); // 设置开关按钮为可用状态 }

AirCondition::~AirCondition() { delete ui; }

void AirCondition::airConditionWidget() { setWindowTitle('空调设置'); //设置ui组件背景 setAutoFillBackground(true); QPalette palette=this->palette(); QPixmap pixmap(':/user/image/image/aircondition.jpg'); palette.setBrush(QPalette::Window, QBrush(pixmap)); setPalette(palette); setFixedSize(600,400); }

bool AirCondition::switchButton_status(bool checked) { // 更新状态到数据库 QString value = ui->SwitchStatus->checked() ? QString::number(ui->temperature->getValue()) : '0'; if (ui->SwitchStatus->checked()) { updateSmartHomeStatus(userid, QString('空调'), QString('开启'), value); ui->temperature->setEnabled(true); } else { updateSmartHomeStatus(userid, QString('空调'), QString('关闭'), value); ui->temperature->setEnabled(false); } return checked; }

void AirCondition::temperature_changed(double value) { // 更新状态到数据库 QString temp = ui->SwitchStatus->checked() ? QString::number(value) : '0'; updateSmartHomeStatus(userid, QString('空调'), ui->SwitchStatus->checked() ? QString('开启') : QString('关闭'), temp); }

void AirCondition::loadLastStatus() { qDebug() << this->userid; QString state = getLastState(this->userid); QString temp = getLastTemperature(this->userid); qDebug() << state; if (state == '开启') { ui->temperature->setEnabled(true); ui->SwitchStatus->setChecked(true); ui->temperature->setValue(temp.toInt()); } else { ui->SwitchStatus->setChecked(false); ui->temperature->setValue(0);

}
qDebug() << temp.toInt();

// 如果界面上显示开启状态，但存入数据库的设备状态为关闭，则更新数据库中的状态为开启
if (ui->SwitchStatus->checked() && state == '关闭') {
    updateSmartHomeStatus(userid, QString('空调'), QString('开启'), temp);
}

}

void AirCondition::saveLastStatus() { qDebug()<userid; QString temperature = QString::number(ui->temperature->getValue()); updateLastTemperature(this->userid,temperature);

// 如果界面上显示关闭状态，但存入数据库的设备状态为开启，则更新数据库中的状态为关闭
if (!ui->SwitchStatus->checked()) {
    updateSmartHomeStatus(userid, QString('空调'), QString('关闭'), QString('0'));
}

}

QString AirCondition::getLastTemperature(int userid) { QString queryStr = QString('SELECT value FROM Status WHERE uid = %1 AND device_name = '空调' ORDER BY sid DESC LIMIT 1').arg(userid); qDebug()<<queryStr<<userid; QSqlQuery query; qDebug ()<<query.exec(queryStr); if (query.exec(queryStr) && query.next()) { return query.value(0).toString(); } else { qDebug() << '未得到上一次温度: ' << query.lastError().text(); return ''; } }

void AirCondition::updateLastTemperature(int userid, QString temperature) { Sqlite::sqlite_init(); QString queryStr = QString('UPDATE Status SET value = '%1' WHERE uid = %2 AND device_name = '空调' AND sid = (SELECT MAX(sid) FROM Status WHERE uid = %2)').arg(temperature).arg(userid); QSqlQuery query; if (!query.exec(queryStr)) { qDebug() << '更新温度失败: ' << query.lastError().text(); } }

QString AirCondition::getLastState(int userid) { QString queryStr = QString('SELECT device_state FROM Status WHERE uid = %1 AND device_name = '空调' ORDER BY sid DESC LIMIT 1').arg(userid); qDebug()<<queryStr<<userid; QSqlQuery query; qDebug ()<<query.exec(queryStr); if (query.exec(queryStr) && query.next()) { return query.value(0).toString(); } else { qDebug() << '未得到上一次状态: ' << query.lastError().text(); return ''; } }