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