代码改错#include lightsh#include ui_lightsh#include switchformh#include sqliteh#include QSqlQuery#include QSqlDatabase#include QSqlError#include QCloseEvent#include QDebugLightsLightsint useridQWidget par

#include "lights.h" #include "ui_lights.h" #include "switchform.h" #include "sqlite.h" #include #include #include #include #include

Lights::Lights(int userid,QWidget *parent) : QWidget(parent), ui(new Ui::Lights), userid(userid)//保证userid无变化 { ui->setupUi(this); lightsWidget(); //连接开关组件的信号和自定义的槽函数 connect(ui->SwitchStatus,&SwitchForm::statusChanged,this,&Lights::switchButton_status);

// 连接完成按钮的clicked信号和自定义的槽函数
connect(ui->Finished, &QPushButton::clicked, this,[=]{
    if(ui->SwitchStatus->checked())
    {
        QString brightness = QString::number(ui->ctrlform->getValue());
        qDebug()<<brightness<<userid;
        updateSmartHomeStatus(userid,QString("智能灯"),QString("开启"),brightness);
    }else
    {
        qDebug()<<"智能灯未打开！";
        updateSmartHomeStatus(userid,QString("智能灯"),QString("关闭"),QString("0"));
    }
});
// 加载上次更改的状态
loadLastStatus();

}

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

void Lights::lightsWidget() { setWindowTitle("智能灯设置"); //设置ui组件背景 setAutoFillBackground(true); QPalette palette=this->palette(); QPixmap pixmap(":/user/image/image/light.jpg"); palette.setBrush(QPalette::Window, QBrush(pixmap)); setPalette(palette); setFixedSize(600,400); }

bool Lights::switchButton_status(bool checked) { qDebug()<<checked; flag=checked; return flag; }

void Lights::showEvent(QShowEvent *event) { // 当页面显示时，加载上次更改的状态 loadLastStatus(); event->accept(); }

void Lights::hideEvent(QHideEvent *event) { saveLastStatus(); event->accept(); }

void Lights::closeEvent(QCloseEvent *event) { // 隐藏窗口而不是关闭 hide(); event->ignore(); }

void Lights::loadLastStatus() { qDebug()<userid; QString state = getLastState(this->userid); QString brightness = getLastBrightness(this->userid); qDebug()<<brightness; if (state=="开启") { ui->SwitchStatus->setChecked(true); ui->ctrlform->setValue(brightness.toInt()); } else { ui->SwitchStatus->setChecked(false); ui->ctrlform->setValue(0); } qDebug()<<brightness.toInt();

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

}

void Lights::saveLastStatus() { qDebug()<userid; QString state = QString(flag); QString brightness = QString::number(ui->ctrlform->getValue()); updateLastBrightness(this->userid,state, brightness);

// 如果界面上显示关闭状态，但存入数据库的设备状态为开启，则更新数据库中的状态为关闭
if (!ui->SwitchStatus->isChecked() && state == "开启") {
    updateSmartHomeStatus(userid, QString("智能灯"), QString("关闭"), QString("0"));
}

}

QString Lights::getLastBrightness(int userid) { Sqlite::sqlite_init(); 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 Lights::updateLastBrightness(int userid,QString state,QString brightness) { Sqlite::sqlite_init(); QString queryStr = QString("UPDATE Status SET value = '%1' , device_state = '%2' WHERE uid = %3 AND device_name = '智能灯'").arg(brightness).arg(state).arg(userid); QSqlQuery query; if (!query.exec(queryStr)) { qDebug() << "更新亮度失败: " << query.lastError().text(); } }

QString Lights::getLastState(int userid) { Sqlite::sqlite_init(); 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 ""; }