From e55e2ed1ceb92334c4f839642b3e68d8f4dceba6 Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期二, 19 九月 2023 00:16:13 +0800 Subject: [PATCH] 0919 --- internal_system_v1/searchinfo.h | 30 ++++++++++++++++++++++++++++++ 1 files changed, 30 insertions(+), 0 deletions(-) diff --git a/internal_system_v1/searchinfo.h b/internal_system_v1/searchinfo.h index 234b5b4..6513d12 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,35 @@ 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); 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