From dfef23453ad106efad95e40cbeaa191d8b3f6961 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期四, 21 九月 2023 23:07:45 +0800
Subject: [PATCH] 0921
---
internal_system_v1/searchinfo.cpp | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 2dbe44a..95fb771 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -253,6 +253,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