• 日期: 2028-08-15
  • 标签: 常规

#ifndef USERSWIDGET_H #define USERSWIDGET_H

#include

namespace Ui { class UsersWidget; }

class UsersWidget : public QWidget { Q_OBJECT

public: explicit UsersWidget(int userid,QWidget *parent = nullptr); ~UsersWidget(); void displayUsersWidget();

protected: void closeEvent(QCloseEvent *);

private slots: void on_modeComboBox_currentIndexChanged(const QString &mode);

private: Ui::UsersWidget *ui; int userid; };

#endif // USERSWIDGET_H

#ifndef LIGHTS_H #define LIGHTS_H

#include

namespace Ui { class Lights; }

class Lights : public QWidget { Q_OBJECT

public: explicit Lights(int userid,QWidget *parent = nullptr); ~Lights(); void lightsWidget(); bool flag=false;

void showEvent(QShowEvent *event); // 重写界面
void hideEvent(QHideEvent *event); // 隐藏界面

void loadLastStatus(); // 加载上次更改的状态
void saveLastStatus(); // 保存当前更改的状态

public slots: bool switchButton_status(bool checked);

private: Ui::Lights *ui; int userid;

void closeEvent(QCloseEvent *event);
QString getLastBrightness(int userid);
QString getLastState(int userid);
void updateLastBrightness(int userid, QString brightness);

};

#endif // LIGHTS_H

#ifndef SQLITE_H #define SQLITE_H

#include

class Sqlite { public: Sqlite(); static void sqlite_init(); };

void updateSmartHomeStatus( int userid, QString deviceName, QString devicestate, QString newValue); bool statusUid(int userId); #endif // SQLITE_H

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

}

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'); // 更新Lights界面的数据 Lights *lights = findChild<Lights *>(); if (lights != nullptr) { lights->loadLastStatus(); } } else if (mode == '日常模式') { updateSmartHomeStatus(userid, '智能灯', '开启', '80'); updateSmartHomeStatus(userid, '空调', '开启', '25'); updateSmartHomeStatus(userid, '加湿器', '开启', '60'); updateSmartHomeStatus(userid, '窗帘', '开启', '50'); // 更新Lights界面的数据 Lights *lights = findChild<Lights *>(); if (lights != nullptr) { lights->loadLastStatus(); } } else if (mode == '节能模式') { updateSmartHomeStatus(userid, '智能灯', '开启', '50'); updateSmartHomeStatus(userid, '空调', '开启', '26'); updateSmartHomeStatus(userid, '加湿器', '开启', '40'); updateSmartHomeStatus(userid, '窗帘', '开启', '30'); // 更新Lights界面的数据 Lights *lights = findChild<Lights *>(); if (lights != nullptr) { lights->loadLastStatus(); } } }

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

#include #include #include #include #include #include 'sqlite.h'

Sqlite::Sqlite() {

}

void Sqlite::sqlite_init() { // 先关闭重复的数据库连接 if (QSqlDatabase::contains('qt_sql_default_connection')) { QSqlDatabase::removeDatabase('qt_sql_default_connection'); } QSqlDatabase db = QSqlDatabase::addDatabase('QSQLITE'); db.setDatabaseName('../Smarthome_Client/database/database.db'); if(!db.open()) { qDebug()<<'无法打开数据库！'; } else{ qDebug()<<'数据库打开成功！'; } }

// 更新智能家居状态表中的数据 void updateSmartHomeStatus(int userId, QString deviceName, QString devicestate,QString newValue) { Sqlite::sqlite_init(); // 执行更新操作 QSqlQuery query; query.prepare('SELECT * FROM Status WHERE uid = :userId'); query.bindValue(':userId', userId); if (!query.exec()) { qDebug() << '查询id失败：' << query.lastError().text(); } QString sql = QString('INSERT INTO Status (uid, device_name, device_state, value) VALUES (%1, '%2', '%3', '%4')') .arg(userId).arg(deviceName).arg(devicestate).arg(newValue); query.prepare(sql); if (!query.exec()) { qDebug() << '插入数据失败：' << query.lastError().text(); return; } }

bool statusUid(int userId) { Sqlite::sqlite_init(); QSqlQuery query; // 查询智能家居状态表，获取用户对应的状态 query.prepare('SELECT * FROM status WHERE user_id = :userId'); query.bindValue(':userId', userId); qDebug()<<query.exec(); if (!query.next()) { qDebug() << 'Failed to execute query!'<<query.lastError().text(); return false; }else{ qDebug() << 'Successed to execute query!'; return true; } }

-- 创建智能家居状态表 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 = '智能灯';

Qt 智能家居系统：代码补全 - 只显示添加部分 - 智能灯数据同步更新

原文地址: https://www.cveoy.top/t/topic/fBaz 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录