From d64822b8be629c4592da0b9c3eabed4500174752 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期一, 13 五月 2024 00:50:27 +0800
Subject: [PATCH] 0512
---
internal_system_v1/searchinfo.cpp | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 58 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index d476404..113389f 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -149,6 +149,9 @@
// 缁煎悎褰曞叆淇℃伅琛� 鍒涘缓
createTableComprehensiveEntryInfo("comprehensive_entry_info");
+ // 鏁存敼鍙拌处淇℃伅琛� 鍒涘缓
+ createTableStandingBook("standing_book_info");
+
}
// 缁煎悎褰曞叆淇℃伅琛� 浠ョ紪鐮佷綔涓烘寚鏍囧悕
@@ -361,6 +364,60 @@
濉〃浜� 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,\
+ 瀹¤鏈熼棿宸叉暣鏀� TEXT,\
+ 鏁存敼閲戦 TEXT,\
+ 鏁存敼鎯呭喌1 TEXT,\
+ 鏁存敼鎯呭喌浣愯瘉璧勬枡1 TEXT,\
+ 鏁存敼缁撴灉 TEXT,\
+ 鏁存敼瀹屾垚鏃堕棿 TEXT,\
+ 灏氭湭鏁存敼鍒颁綅鐨勫師鍥� TEXT,\
+ 鏁存敼棰勮瀹屾垚鏃堕棿 TEXT,\
+ 鏁存敼鎯呭喌2 TEXT,\
+ 鏁存敼鎯呭喌浣愯瘉璧勬枡2 TEXT,\
+ 鏁存敼妫�鏌ョ粨鏋淿妫�鏌ユ椂闂� TEXT,\
+ 鏁存敼妫�鏌ョ粨鏋淿妫�鏌ユ柟寮� TEXT,\
+ 鏁存敼妫�鏌ョ粨鏋淿妫�鏌ョ粨鏋� TEXT,\
+ 宸叉暣鏀筥绾犳闂 TEXT,\
+ 宸叉暣鏀筥瀹屽杽鍒跺害 TEXT,\
+ 宸叉暣鏀筥瀹屾垚鏃堕棿 TEXT,\
+ 姝ｅ湪鏁存敼_涓昏鍘熷洜 TEXT,\
+ 姝ｅ湪鏁存敼_瀹屾垚鏃堕檺 TEXT,\
+ 灏氭湭鏁存敼_涓昏鍘熷洜 TEXT,\
+ 灏氭湭鏁存敼_璐ｄ换閮ㄩ棬鎴栬矗浠讳汉 TEXT,\
+ 灏氭湭鏁存敼_瀹屾垚鏃堕檺 TEXT,\
+ 鍒跺害寤鸿_淇鍒跺害 TEXT,\
+ 鍒跺害寤鸿_鏂板鍒跺害 TEXT,\
+ 璧勯噾鏀跺洖_鎸藉洖鎹熷け TEXT,\
+ 璧勯噾鏀跺洖_鍏朵粬 TEXT,\
+ 璧勯噾鏀跺洖_瀹″噺 TEXT,\
+ log_time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -674,6 +731,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