From e77bddbba9af4535e0c51058c1708987a5512f0c Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期二, 19 九月 2023 23:21:11 +0800 Subject: [PATCH] 0919-2 --- internal_system_v1/searchinfo.h | 32 ++++++++++++++++++++++++++++++++ 1 files changed, 32 insertions(+), 0 deletions(-) diff --git a/internal_system_v1/searchinfo.h b/internal_system_v1/searchinfo.h index 234b5b4..134aafb 100644 --- a/internal_system_v1/searchinfo.h +++ b/internal_system_v1/searchinfo.h @@ -2,6 +2,10 @@ #define SEARCHINFO_H #include <QMainWindow> +#include <QMap> +#include "QSqlDatabase" +#include <QStandardItemModel> + namespace Ui { class SearchInfo; @@ -14,9 +18,37 @@ public: explicit SearchInfo(QWidget *parent = 0); ~SearchInfo(); + void createSqlite(); + void createTableHasEvidences(QString tableName); // 鏈変綈璇佺殑琛� + void createTableNoEvidences(QString tableName); // 鏃犱綈璇佺殑琛� + void createTableHasUnit(QString tableName); // 鏃犱綈璇佺殑琛ㄤ笖鏈夎閲忓崟浣嶇殑琛� + void searchComName(); + QVector<QVector<QString>> getResult(QString &sql,int colCnt); + void setLabels(); + +private slots: + void on_pushButton_search_clicked(); + + void on_pushButton_export_clicked(); + + void on_comboBox_currentIndexChanged(const QString &arg1); + + void on_toolButton_seleceExcel_clicked(); + + void on_comboBox_company_currentIndexChanged(const QString &arg1); + + void addComName(QString name); + + void on_checkBox_clicked(); private: Ui::SearchInfo *ui; + QSqlDatabase m_db; + QMap<QString,int> m_comInfo; + QMap<QString,QString> m_comCode; + QMap<QString,QString> m_itemAndTable; + QStandardItemModel *m_model; + QMap<QString,QStringList> m_labels; }; #endif // SEARCHINFO_H -- Gitblit v1.8.0