智能灯设置界面 - Qt 界面开发
#include 'lights.h'
#include 'ui_lights.h'
#include 'switchform.h'
#include 'sqlite.h'
#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()<
// 如果界面上显示开启状态，但存入数据库的设备状态为关闭，则更新数据库中的状态为开启
if (ui->SwitchStatus->checked() && state == '关闭') {
updateSmartHomeStatus(userid, QString('智能灯'), QString('开启'), brightness);
}
}
void Lights::saveLastStatus()
{
qDebug()<
// 如果界面上显示关闭状态，但存入数据库的设备状态为开启，则更新数据库中的状态为关闭
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 '';
}
}
点击主界面的QCombobox，将亮度信息存入数据库，打开由上述代码组成另一个界面，该界面通过从数据库获得最新的device_state和brighteness来更新该界面组件状态内容：#include 'switchform.h'
#include 'sqlite.h'
#include
SwitchForm::SwitchForm(QWidget *parent) : QWidget(parent), ui(new Ui::SwitchForm) { ui->setupUi(this); // 连接滑动条的valueChanged信号和自定义的槽函数 connect(ui->slider, &QSlider::valueChanged, this, &SwitchForm::slider_valueChanged); }
SwitchForm::~SwitchForm() { delete ui; }
void SwitchForm::setValue(int value) { ui->slider->setValue(value); }
int SwitchForm::getValue() { return ui->slider->value(); }
void SwitchForm::slider_valueChanged(int value) { emit statusChanged(value > 0); // 发送状态改变的信号，参数为滑动条的值是否大于0 }
void SwitchForm::showEvent(QShowEvent *event) { // 当页面显示时，加载最新的设备状态和亮度 loadLastStatus(); event->accept(); }
void SwitchForm::hideEvent(QHideEvent *event) { saveLastStatus(); event->accept(); }
void SwitchForm::loadLastStatus() { QString state = getLastState(); int brightness = getLastBrightness(); if (state == '开启') { ui->switchButton->setChecked(true); ui->slider->setValue(brightness); } else { ui->switchButton->setChecked(false); ui->slider->setValue(0); }
// 如果界面上显示开启状态，但存入数据库的设备状态为关闭，则更新数据库中的状态为开启
if (ui->switchButton->isChecked() && state == '关闭') {
updateSmartHomeStatus(QString('智能灯'), QString('开启'), brightness);
}
}
void SwitchForm::saveLastStatus() { int brightness = ui->slider->value(); updateLastBrightness(brightness);
// 如果界面上显示关闭状态，但存入数据库的设备状态为开启，则更新数据库中的状态为关闭
if (!ui->switchButton->isChecked()) {
updateSmartHomeStatus(QString('智能灯'), QString('关闭'), 0);
}
}
QString SwitchForm::getLastState() { QString queryStr = 'SELECT device_state FROM Status WHERE device_name = '智能灯' ORDER BY sid DESC LIMIT 1'; QSqlQuery query; if (query.exec(queryStr) && query.next()) { return query.value(0).toString(); } else { qDebug() << '得到上一次状态错误: ' << query.lastError().text(); return ''; } }
void SwitchForm::updateLastBrightness(int brightness) { QString queryStr = QString('UPDATE Status SET value = %1 WHERE device_name = '智能灯'').arg(brightness); QSqlQuery query; if (!query.exec(queryStr)) { qDebug() << '更新亮度失败: ' << query.lastError().text(); } }
int SwitchForm::getLastBrightness() { QString queryStr = 'SELECT value FROM Status WHERE device_name = '智能灯' ORDER BY sid DESC LIMIT 1'; QSqlQuery query; if (query.exec(queryStr) && query.next()) { return query.value(0).toInt(); } else { qDebug() << '得到上一次亮度错误: ' << query.lastError().text(); return 0; } }
void SwitchForm::updateSmartHomeStatus(const QString &deviceName, const QString &state, int brightness) { QString queryStr = QString('INSERT INTO Status (device_name, device_state, value) VALUES ('%1', '%2', %3)').arg(deviceName).arg(state).arg(brightness); QSqlQuery query; if (!query.exec(queryStr)) { qDebug() << '更新设备状态失败: ' << query.lastError().text(); } }
原文地址: https://www.cveoy.top/t/topic/fBiC 著作权归作者所有。请勿转载和采集!