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