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 | 44 +++++++++++++++++++++++++++++++++-----------
1 files changed, 33 insertions(+), 11 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index b0aa27e..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,13 +18,16 @@
// 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);
ui->tableView->setModel(m_model);
ui->tableView->verticalHeader()->setVisible(false); // 闅愯棌琛屽ご
m_model->setColumnCount(5);
QStringList labels;
- labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿";
+ labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿";
m_model->setHorizontalHeaderLabels(labels);
if(QSqlDatabase::contains("qt_sql_default_connection")){
m_db = QSqlDatabase::addDatabase("qt_sql_default_connection");
@@ -143,7 +147,8 @@
code TEXT,\
num INTEGER,\
evidences TEXT,\
- com_id INTEGER\
+ com_id INTEGER,\
+ time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -161,7 +166,8 @@
kpi_name TEXT,\
code TEXT,\
num INTEGER,\
- com_id INTEGER\
+ com_id INTEGER,\
+ time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -180,7 +186,8 @@
code TEXT,\
unit TEXT,\
num INTEGER,\
- com_id INTEGER\
+ com_id INTEGER,\
+ time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -229,9 +236,9 @@
void SearchInfo::setLabels()
{
QStringList labels,labels2,labels3;
- labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿"<<" ";
- labels2<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鍗曚綅"<<"鏁伴噺"<<"鍏徃缂栧彿";
- labels3<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"浣愯瘉"<<"鍏徃缂栧彿";
+ labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿"<<" ";
+ labels2<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鍗曚綅"<<"鏁伴噺"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿";
+ labels3<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"浣愯瘉"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿";
m_labels["瀹¤椤圭洰"] = labels;
m_labels["鍐呭宸ヤ綔閲�"] = labels;
m_labels["闂閲戦"] = labels3;
@@ -248,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)){
@@ -258,7 +270,7 @@
rowCnt++;
m_model->setRowCount(rowCnt);
qDebug()<<query.value(0).toInt();
- for(int i=0;i<6;++i){
+ for(int i=0;i<7;++i){
if(query.value(i).isValid()){
m_model->setItem(rowCnt-1,i,new QStandardItem(query.value(i).toString()));
}
@@ -420,8 +432,7 @@
void SearchInfo::on_comboBox_currentIndexChanged(const QString &arg1)
{
- m_model->setHorizontalHeaderLabels(m_labels[arg1]);
-
+ m_model->setHorizontalHeaderLabels(m_labels[arg1]);
}
void SearchInfo::on_toolButton_seleceExcel_clicked()
@@ -450,3 +461,14 @@
{
ui->comboBox_company->addItem(name);
}
+
+void SearchInfo::on_checkBox_clicked()
+{
+ if(ui->checkBox->isChecked()){
+ ui->dateEdit_begin->setEnabled(true);
+ ui->dateEdit_end->setEnabled(true);
+ }else{
+ ui->dateEdit_begin->setEnabled(false);
+ ui->dateEdit_end->setEnabled(false);
+ }
+}
--
Gitblit v1.8.0