代码修改只显示修改部分：用户点击Lights界面从数据库的Status表中得到最新的智能灯device_state和value更新在Lights页面当用户未对SwitchForm进行操作但对ctrlform更改时flag默认为FALSESwitchForm的状态是靠点击触发的但如果ui上显示开启状态true时却存入Status的device_state为关闭false出现错误如何解决#ifndef

以下是修改的代码部分：

void Lights::loadLastStatus()
{
    qDebug()<<this->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();
}

void Lights::saveLastStatus()
{
    qDebug()<<this->userid;
    QString state = ui->SwitchStatus->getstate() ? "开启" : "关闭";
    QString brightness = QString::number(ui->ctrlform->getValue());
    updateLastBrightness(this->userid, state, brightness);
}

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())
    {
        QString state = query.value(0).toString();
        if (state == "开启")
        {
            return "true";
        }
        else if (state == "关闭")
        {
            return "false";
        }
    }
    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();
    }
}

bool SwitchForm::getstate()
{
    return m_checked;
}

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

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

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