From 2a6c60a34a892b1a7296535952d86a9d6b195d64 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期二, 05 三月 2024 23:40:07 +0800
Subject: [PATCH] 0305

---
 internal_system_v1/searchinfo.cpp |  154 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 154 insertions(+), 0 deletions(-)

diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 3612669..c48fad7 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,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+_030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     TEXT,\
+                          _030222     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,\
+            瀹h疮鍩硅     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,\
+            璐d换閮ㄩ棬鎴栬矗浠讳汉     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