Qt智能家居灯光控制系统的设计与实现

#include 'lights.h'
#include 'ui_lights.h'
#include 'switchform.h'
#include 'sqlite.h'
#include <QSqlQuery>
#include <QSqlDatabase>
#include <QSqlError>
#include <QCloseEvent>
#include <QDebug>

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(flag)
        {
            QString brighteness = QString::number(ui->ctrlform->getValue());
            qDebug()<<brighteness<<userid;
            updateSmartHomeStatus(userid,QString('智能灯'),QString('开启'),brighteness);
        }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()<<this->userid;
    QString brightness = getLastBrightness(this->userid);
    qDebug()<<brightness;
    if (brightness.toInt() > 0)
    {
        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 brightness = QString::number(ui->ctrlform->getValue());
    updateLastBrightness(this->userid, brightness);
}


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