From 12cba7f5737b02992f783164d902c2a52e9b1aab Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期四, 28 十二月 2023 23:45:50 +0800
Subject: [PATCH] 1228
---
internal_system_v1/searchinfo.cpp | 40 ++++++++++++++++++++++++++++++----------
1 files changed, 30 insertions(+), 10 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index b0aa27e..95fb771 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -18,12 +18,14 @@
// ui->dateTimeEdit->hide();
// ui->dateTimeEdit_2->hide();
+ 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 +145,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 +164,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 +184,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 +234,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 +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)){
@@ -258,7 +268,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 +430,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 +459,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