From 7dd76d103a351caae20261fc7bb67d01bd66e906 Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期三, 28 二月 2024 23:52:02 +0800 Subject: [PATCH] 0228 --- internal_system_v1/searchinfo.cpp | 11 +++++++++-- 1 files changed, 9 insertions(+), 2 deletions(-) diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp index 2dbe44a..ce9f9e8 100644 --- a/internal_system_v1/searchinfo.cpp +++ b/internal_system_v1/searchinfo.cpp @@ -1,4 +1,4 @@ -#include "searchinfo.h" +锘�#include "searchinfo.h" #include "ui_searchinfo.h" #include <QAxObject> #include <QDebug> @@ -7,6 +7,7 @@ #include <QSqlQuery> #include <QMessageBox> #include <QFileDialog> +#include <QCalendarWidget> SearchInfo::SearchInfo(QWidget *parent) : QMainWindow(parent), @@ -17,7 +18,8 @@ // ui->label_3->hide(); // ui->dateTimeEdit->hide(); // ui->dateTimeEdit_2->hide(); - + ui->dateEdit_begin->calendarWidget()->setStyleSheet("background-color:#deab8a"); + ui->dateEdit_end->calendarWidget()->setStyleSheet("background-color:pink"); ui->dateEdit_end->setDate(QDate::currentDate()); m_model = new QStandardItemModel(this); @@ -253,6 +255,11 @@ QString item = ui->comboBox->currentText(); QString comName = ui->comboBox_company->currentText(); QString sql = QString("select * from %1 where com_id=%2").arg(m_itemAndTable[item]).arg(m_comInfo[comName]); + if(ui->checkBox->isChecked()){ // 鍕鹃�変箣鍚� + sql = QString("select * from %1 where com_id=%2 and time between '%3' and '%4'").arg(m_itemAndTable[item]).arg(m_comInfo[comName]) + .arg(ui->dateEdit_begin->date().toString("yyyy-MM-dd")) + .arg(ui->dateEdit_end->date().toString("yyyy-MM-dd")); + } qDebug()<<__FUNCTION__<<sql; QSqlQuery query; if(query.exec(sql)){ -- Gitblit v1.8.0