From 20ffcfb5507daf34f81346ca3dfa4c031e7b2fe3 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期日, 27 四月 2025 22:13:53 +0800
Subject: [PATCH] 0427
---
internal_system_v1/searchinfo.cpp | 73 +++++++++++++++++++++++++++++++++++-
1 files changed, 70 insertions(+), 3 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index d476404..09ed7fd 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -9,6 +9,8 @@
#include <QFileDialog>
#include <QCalendarWidget>
+#pragma execution_character_set("utf-8")
+
SearchInfo::SearchInfo(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::SearchInfo)
@@ -149,6 +151,9 @@
// 缁煎悎褰曞叆淇℃伅琛� 鍒涘缓
createTableComprehensiveEntryInfo("comprehensive_entry_info");
+ // 鏁存敼鍙拌处淇℃伅琛� 鍒涘缓
+ createTableStandingBook("standing_book_info");
+
}
// 缁煎悎褰曞叆淇℃伅琛� 浠ョ紪鐮佷綔涓烘寚鏍囧悕
@@ -185,8 +190,8 @@
_030257 TEXT,\
_030258 TEXT,\
_030260 TEXT,\
- _030300 TEXT,\
- _030301 TEXT,\
+_030300 TEXT,\
+_030301 TEXT,\
_030302 TEXT,\
_030303 TEXT,\
_030304 TEXT,\
@@ -232,7 +237,8 @@
_030903 TEXT,\
_031000 TEXT,\
_031001 TEXT,\
- company_type TEXT)").arg(tableName);
+ company_type TEXT,\
+ year TEXT)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
{
@@ -361,6 +367,66 @@
濉〃浜� TEXT,\
鑱旂郴鐢佃瘽 TEXT,\
濉姤鏃ユ湡 TEXT\
+ )").arg(tableName);
+ QSqlQuery query;
+ if(query.exec(sql))
+ {
+ qDebug()<<QString("create %1 ok...").arg(tableName);
+ }else{
+ qDebug()<<QString("create %1 fail...").arg(tableName)<<query.lastError().text();
+ }
+}
+
+// 鏁存敼鍙拌处
+void SearchInfo::createTableStandingBook(QString tableName){
+ QString sql = QString("CREATE TABLE %1 (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ 瀹¤绫诲埆 TEXT,\
+ 瀹¤骞村害 TEXT,\
+ 瀹¤鍗曚綅 TEXT,\
+ 瀹¤鏂瑰紡 TEXT,\
+ 璐ｄ换涓讳綋鍚嶇О TEXT,\
+ 瀹¤椤圭洰 TEXT,\
+ 瀹¤椤圭洰鍚嶇О TEXT,\
+ 闂绫诲埆 TEXT,\
+ 闂瀹氭�� TEXT,\
+ 闂鎻忚堪 TEXT,\
+ 闂瀹氭�ф硶瑙勪緷鎹� TEXT,\
+瀹¤鍙戠幇闂閲戦瀹氭�� TEXT,\
+瀹¤鍙戠幇闂涓暟瀹氭�� TEXT,\
+ 娑夊強閲戦 REAL,\
+ 闂鎻忚堪浣愯瘉璧勬枡 TEXT,\
+ 瀹¤鏈熼棿宸叉暣鏀� TEXT,\
+ 鏁存敼閲戦 REAL,\
+ 鏁存敼鎯呭喌1 TEXT,\
+ 鏁存敼鎯呭喌浣愯瘉璧勬枡1 TEXT,\
+ 鏁存敼缁撴灉 TEXT,\
+ 鏁存敼瀹屾垚鏃堕棿 TEXT,\
+ 灏氭湭鏁存敼鍒颁綅鐨勫師鍥� TEXT,\
+ 鏁存敼棰勮瀹屾垚鏃堕棿 TEXT,\
+ 鏁存敼鎯呭喌2 TEXT,\
+ 鏁存敼鎯呭喌浣愯瘉璧勬枡2 TEXT,\
+澶勫垎绫诲瀷 TEXT,\
+澶勫垎浜烘暟 INTEGER,\
+绉婚�佽缁嗕俊鎭� TEXT,\
+澶勭悊缁撴灉 TEXT,\
+娑夋浜哄憳 INTEGER,\
+ 鏁存敼妫�鏌ョ粨鏋淿妫�鏌ユ椂闂� TEXT,\
+ 鏁存敼妫�鏌ョ粨鏋淿妫�鏌ユ柟寮� TEXT,\
+ 鏁存敼妫�鏌ョ粨鏋淿妫�鏌ョ粨鏋� TEXT,\
+ 宸叉暣鏀筥绾犳闂 TEXT,\
+ 宸叉暣鏀筥瀹屽杽鍒跺害 TEXT,\
+ 宸叉暣鏀筥瀹屾垚鏃堕棿 TEXT,\
+ 姝ｅ湪鏁存敼_涓昏鍘熷洜 TEXT,\
+ 姝ｅ湪鏁存敼_瀹屾垚鏃堕檺 TEXT,\
+ 灏氭湭鏁存敼_涓昏鍘熷洜 TEXT,\
+ 灏氭湭鏁存敼_璐ｄ换閮ㄩ棬鎴栬矗浠讳汉 TEXT,\
+ 灏氭湭鏁存敼_瀹屾垚鏃堕檺 TEXT,\
+ 鏁存敼鎴愭灉_閲戦绫绘暣鏀规垚鏋� TEXT,\
+ 鏁存敼鎴愭灉_閲戦 REAL,\
+ 鏁存敼鎴愭灉_闈為噾棰濈被鏁存敼鎴愭灉 TEXT,\
+ 鏁存敼鎴愭灉_鏁伴噺 INTEGER,\
+ log_time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -674,6 +740,7 @@
return;
}
QString path = QFileDialog::getOpenFileName(this,"閫夋嫨琛ㄦ牸妯℃澘:鍗曚綅鍐呴儴瀹¤涓氬姟鎯呭喌琛�","./","excel(*鍗曚綅鍐呴儴瀹¤涓氬姟鎯呭喌琛�.xls)");
+ if(path.isNull()) return;
ui->label_excel_path->setText(path);
QStringList paths = path.split(".");
QString newPath = paths.at(0)+"_"+ui->comboBox_company->currentText()+"."+paths.at(1);
--
Gitblit v1.8.0