From 20a43d0e0ff9e9f6ee5349373fd810c6597abf00 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期一, 29 四月 2024 22:33:13 +0800
Subject: [PATCH] 0429
---
internal_system_v1/searchinfo.cpp | 162 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 158 insertions(+), 4 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index cf7616b..d476404 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -140,6 +140,160 @@
// 鍗曚綅鐨勬墍鏈変俊鎭〃 鍒涘缓
createTableAllComInfo("all_company_info");
+ // 鏁存敼缁撴灉淇℃伅琛� 鍒涘缓
+ createTableRectifyResultInfo("rectify_result_info");
+
+ // 闂娓呭崟淇℃伅琛� 鍒涘缓
+ createTableProblemListInfo("problem_list_info");
+
+ // 缁煎悎褰曞叆淇℃伅琛� 鍒涘缓
+ createTableComprehensiveEntryInfo("comprehensive_entry_info");
+
+}
+
+// 缁煎悎褰曞叆淇℃伅琛� 浠ョ紪鐮佷綔涓烘寚鏍囧悕
+void SearchInfo::createTableComprehensiveEntryInfo(QString tableName){
+ QString sql = QString("CREATE TABLE %1 (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ name VARCHAR (30),\
+ _030000 TEXT,\
+ _030001 TEXT,\
+ _030100 TEXT,\
+ _030101 TEXT,\
+ _030200 TEXT,\
+ _030210 TEXT,\
+ _030220 TEXT,\
+ _030221 TEXT,\
+ _030222 TEXT,\
+ _030223 TEXT,\
+ _030230 TEXT,\
+ _030231 TEXT,\
+ _030232 TEXT,\
+ _030233 TEXT,\
+ _030234 TEXT,\
+ _030240 TEXT,\
+ _030241 TEXT,\
+ _030242 TEXT,\
+ _030243 TEXT,\
+ _030250 TEXT,\
+ _030251 TEXT,\
+ _030252 TEXT,\
+ _030253 TEXT,\
+ _030254 TEXT,\
+ _030255 TEXT,\
+ _030256 TEXT,\
+ _030257 TEXT,\
+ _030258 TEXT,\
+ _030260 TEXT,\
+ _030300 TEXT,\
+ _030301 TEXT,\
+ _030302 TEXT,\
+ _030303 TEXT,\
+ _030304 TEXT,\
+ _030305 TEXT,\
+ _030306 TEXT,\
+ _030307 TEXT,\
+ _030308 TEXT,\
+ _030310 TEXT,\
+ _030400 TEXT,\
+ _030500 TEXT,\
+ _030510 TEXT,\
+ _030520 TEXT,\
+ _030521 TEXT,\
+ _030522 TEXT,\
+ _030523 TEXT,\
+ _030524 TEXT,\
+ _030525 TEXT,\
+ _030526 TEXT,\
+ _030527 TEXT,\
+ _030528 TEXT,\
+ _030600 TEXT,\
+ _030610 TEXT,\
+ _030620 TEXT,\
+ _030621 TEXT,\
+ _030622 TEXT,\
+ _030623 TEXT,\
+ _030624 TEXT,\
+ _030700 TEXT,\
+ _030701 TEXT,\
+ _030702 TEXT,\
+ _030703 TEXT,\
+ _030704 TEXT,\
+ _030705 TEXT,\
+ _030706 TEXT,\
+ _030800 TEXT,\
+ _030801 TEXT,\
+ _030802 TEXT,\
+ _030803 TEXT,\
+ _030804 TEXT,\
+ _030900 TEXT,\
+ _030901 TEXT,\
+ _030902 TEXT,\
+ _030903 TEXT,\
+ _031000 TEXT,\
+ _031001 TEXT,\
+ company_type 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::createTableRectifyResultInfo(QString tableName){
+ QString sql = QString("CREATE TABLE %1 (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ name VARCHAR (30),\
+ 淇鍒跺害 TEXT,\
+ 鏂板鍒跺害 TEXT,\
+ 鎸藉洖鎹熷け TEXT,\
+ 鍓旈櫎 TEXT,\
+ 瀹″噺 TEXT,\
+ 澶勭悊浜� TEXT,\
+ 瀹ｈ疮鍩硅 TEXT,\
+ 鍏朵粬 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::createTableProblemListInfo(QString tableName){
+ QString sql = QString("CREATE TABLE %1 (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ name VARCHAR (30),\
+ 搴忓彿 TEXT,\
+ 鎽樿 TEXT,\
+ 妫�鏌ユ椂闂� TEXT,\
+ 妫�鏌ユ柟寮� TEXT,\
+ 绾犳闂 TEXT,\
+ 瀹屽杽鍒跺害 TEXT,\
+ 瀹屾垚鏃堕棿 TEXT,\
+ 涓昏鍘熷洜 TEXT,\
+ 瀹屾垚鏃堕檺 TEXT,\
+ 涓昏鍘熷洜1 TEXT,\
+ 璐ｄ换閮ㄩ棬鎴栬矗浠讳汉 TEXT,\
+ 瀹屾垚鏃堕檺1 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();
+ }
}
@@ -192,9 +346,9 @@
涓骇鑱岀О浜烘暟 INTEGER,\
鍒濈骇鑱岀О浜烘暟 INTEGER,\
鏃犺亴绉颁汉鏁� INTEGER,\
- 50宀佷互涓婁汉鏁� INTEGER,\
- 30-50宀佸瞾浜烘暟 INTEGER,\
- 30宀佷互涓嬩汉鏁� INTEGER,\
+ 浜斿崄宀佷互涓婁汉鏁� INTEGER,\
+ 涓夊崄鑷充簲鍗佸瞾宀佷汉鏁� INTEGER,\
+ 涓夊崄宀佷互涓嬩汉鏁� INTEGER,\
瀹¤鏁伴噺 INTEGER,\
浼氳鏁伴噺 INTEGER,\
缁忔祹鏁伴噺 INTEGER,\
@@ -206,7 +360,7 @@
缁熻璐熻矗浜� TEXT,\
濉〃浜� TEXT,\
鑱旂郴鐢佃瘽 TEXT,\
- 濉姤鏃ユ湡 TEXT,\
+ 濉姤鏃ユ湡 TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
--
Gitblit v1.8.0