Qt 智能家居系统：模式切换实时更新设备状态

#include 'userswidget.h' #include 'ui_userswidget.h' #include 'sqlite.h' #include 'lights.h' #include 'aircondition.h' #include 'curtains.h' #include 'humidiffer.h' #include 'information.h' #include 'procession.h' #include 'QCloseEvent' #include 'QComboBox' #include 'QMessageBox'

UsersWidget::UsersWidget(int userid,QWidget *parent) : QWidget(parent), ui(new Ui::UsersWidget) { ui->setupUi(this); displayUsersWidget(); connect(ui->lights,&QToolButton::clicked,this,[=]{ Lights *w = new Lights(userid); w->show();}); connect(ui->air_condition,&QToolButton::clicked,this,[=]{ AirCondition *w = new AirCondition(userid); w->show();}); connect(ui->curtains,&QToolButton::clicked,this,[=]{ Curtains *w = new Curtains(userid); w->show();}); connect(ui->humidifiers,&QToolButton::clicked,this,[=]{ Humidiffer *w = new Humidiffer(userid); w->show();}); connect(ui->tables,&QToolButton::clicked,this,[=]{ Information *w = new Information; w->show();}); connect(ui->wifi,&QToolButton::clicked,this,[=]{ Procession *w = new Procession; w->show();}); connect(ui->mode, QOverload<const QString&>::of(&QComboBox::currentIndexChanged), this, [this](const QString& mode){ on_modeComboBox_currentIndexChanged(mode); }); connect(ui->mode, QOverload::of(&QComboBox::currentIndexChanged), this, [this](int index){ on_modeComboBox_currentIndexChanged(index); }); }

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

void UsersWidget::displayUsersWidget() { setWindowTitle('智能家居总览图'); setFixedSize(900,600);

}

void UsersWidget::on_modeComboBox_currentIndexChanged(const QString &mode) { if (mode == '睡眠模式') { updateSmartHomeStatus(userid, '智能灯', '开启', '20'); updateSmartHomeStatus(userid, '空调', '开启', '27'); updateSmartHomeStatus(userid, '加湿器', '开启', '50'); updateSmartHomeStatus(userid, '窗帘', '开启', '100');

} else if (mode == '日常模式') {
    updateSmartHomeStatus(userid, '智能灯', '开启', '80');
    updateSmartHomeStatus(userid, '空调', '开启', '25');
    updateSmartHomeStatus(userid, '加湿器', '开启', '60');
    updateSmartHomeStatus(userid, '窗帘', '开启', '50');
} else if (mode == '节能模式') {
    updateSmartHomeStatus(userid, '智能灯', '开启', '50');
    updateSmartHomeStatus(userid, '空调', '开启', '26');
    updateSmartHomeStatus(userid, '加湿器', '开启', '40');
    updateSmartHomeStatus(userid, '窗帘', '开启', '30');
}

}

void UsersWidget::on_modeComboBox_currentIndexChanged(int index) { if (index == 0) { updateSmartHomeStatus(userid, '智能灯', '开启', '20'); updateSmartHomeStatus(userid, '空调', '开启', '27'); updateSmartHomeStatus(userid, '加湿器', '开启', '50'); updateSmartHomeStatus(userid, '窗帘', '开启', '100');

} else if (index == 1) {
    updateSmartHomeStatus(userid, '智能灯', '开启', '80');
    updateSmartHomeStatus(userid, '空调', '开启', '25');
    updateSmartHomeStatus(userid, '加湿器', '开启', '60');
    updateSmartHomeStatus(userid, '窗帘', '开启', '50');
} else if (index == 2) {
    updateSmartHomeStatus(userid, '智能灯', '开启', '50');
    updateSmartHomeStatus(userid, '空调', '开启', '26');
    updateSmartHomeStatus(userid, '加湿器', '开启', '40');
    updateSmartHomeStatus(userid, '窗帘', '开启', '30');
}

}

void UsersWidget::closeEvent(QCloseEvent *e) { if(e->spontaneous()) { //窗口关闭时弹出的提示窗口 QMessageBox::StandardButton reply;

    reply = QMessageBox::information(this,'提示','确认退出智能管家系统？',QMessageBox::Yes|QMessageBox::No);
    if(reply == QMessageBox::Yes){
        //若用户点击确认，则接收这个事件,当前窗口会关闭
        e->accept();
     }else{
        //若用户点击取消，则忽略这个事件，当前窗口不会关闭
        e->ignore();
    }
}

}

#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 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()<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->checked() && state == '关闭') {
        updateSmartHomeStatus(userid, QString('智能灯'), QString('开启'), brightness);
    }

}

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

// 如果界面上显示关闭状态，但存入数据库的设备状态为开启，则更新数据库中的状态为关闭
    if (!ui->SwitchStatus->checked()) {
        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 brightness) { Sqlite::sqlite_init(); QString queryStr = QString('UPDATE Status SET value = %1 WHERE uid = %3 AND device_name = '智能灯'').arg(brightness).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 ''; } }

-- 创建智能家居状态表 CREATE TABLE IF NOT EXISTS Status ( sid INTEGER PRIMARY KEY AUTOINCREMENT, uid INTEGER , device_name varchar(10), device_state varchar(10), value varchar(10), mode varchar(10), FOREIGN KEY (uid) REFERENCES users (uid) );

SELECT device_state FROM Status WHERE uid = 123 AND device_name = '智能灯'; SELECT device_state FROM Status WHERE uid = 123 AND device_name = '智能灯' ORDER BY sid DESC LIMIT 1; UPDATE Status SET value = '12' , device_state = '开启' WHERE uid = 123 AND device_name = '智能灯';