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 | 95 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 95 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 47a40e2..c48fad7 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -146,8 +146,103 @@
// 闂娓呭崟淇℃伅琛� 鍒涘缓
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 (\
--
Gitblit v1.8.0