From 31ed29f804a6850ef9a8f60326f4da603e7c8a39 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期一, 04 三月 2024 22:55:48 +0800
Subject: [PATCH] 0304
---
internal_system_v1/searchinfo.cpp | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 59 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 3612669..47a40e2 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -140,6 +140,65 @@
// 鍗曚綅鐨勬墍鏈変俊鎭〃 鍒涘缓
createTableAllComInfo("all_company_info");
+ // 鏁存敼缁撴灉淇℃伅琛� 鍒涘缓
+ createTableRectifyResultInfo("rectify_result_info");
+
+ // 闂娓呭崟淇℃伅琛� 鍒涘缓
+ createTableProblemListInfo("problem_list_info");
+
+}
+
+// 鏁存敼缁撴灉淇℃伅琛�
+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();
+ }
}
--
Gitblit v1.8.0