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 | 232 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 232 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index ce9f9e8..c48fad7 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -137,6 +137,238 @@
createTableHasUnit("case_clue");
m_itemAndTable["妗堜欢绾跨储"] = "case_clue";
+ // 鍗曚綅鐨勬墍鏈変俊鎭〃 鍒涘缓
+ 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,\
+ 瀹ｈ疮鍩硅 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();
+ }
+
+}
+
+// 鍗曚綅淇℃伅琛� 鍏�
+void SearchInfo::createTableAllComInfo(QString tableName){
+ QString sql = QString("CREATE TABLE %1 (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ name VARCHAR (30),\
+ code VARCHAR (30),\
+ 鏈烘瀯绫诲瀷 TEXT,\
+ 涓昏涓氬姟娲诲姩 TEXT,\
+ 琛屼笟浠ｇ爜 TEXT,\
+ 鍗曚綅娉ㄥ唽鍦板強鍖哄煙 TEXT,\
+ 鍖哄煙浠ｇ爜 TEXT,\
+ 鍩庝埂浠ｇ爜 TEXT,\
+ 鍗曚綅瑙勬ā TEXT,\
+ 浠庝笟鏈熸湯浜烘暟 TEXT,\
+ 娉曞畾浠ｈ〃浜� TEXT,\
+ 鎵ц浼氳鏍囧噯绫诲埆 TEXT,\
+ 闀块�斿尯鍙� TEXT,\
+ 鍥哄畾鐢佃瘽 TEXT,\
+ 閭斂缂栫爜 TEXT,\
+ 鐢靛瓙閭 TEXT,\
+ 缃戝潃 TEXT,\
+ 鏄惁鏈変笂涓�绾ф硶浜� TEXT,\
+ 涓婁竴绾х粺淇′唬鐮� TEXT,\
+ 鍘熺粍缁囦唬鐮� TEXT,\
+ 涓婄骇鍗曚綅鍚嶇О TEXT,\
+ 鏄惁璁剧疆鎬诲璁″笀 TEXT,\
+ 鎬诲璁″笀鑱屼綅灞傜骇 TEXT,\
+ 鎬诲浠昏亴鏂瑰紡 TEXT,\
+ 鏄惁璁剧疆鍐呭鏈烘瀯 TEXT,\
+ 鍐呭鏈烘瀯鍚嶇О TEXT,\
+ 棰嗗鏈烘瀯 TEXT,\
+ 鏄惁鐙珛璁剧疆鍐呭鏈烘瀯 TEXT,\
+ 璐㈠姟閮ㄩ棬 INTEGER,\
+ 娉曞姟閮ㄩ棬 INTEGER,\
+ 鍐呴儴鎺у埗閮ㄩ棬 INTEGER,\
+ 绾閮ㄩ棬 INTEGER,\
+ 鍏朵粬閮ㄩ棬 INTEGER,\
+ 鍐呭灞傜骇 TEXT,\
+ 缂栧埗鏁伴噺 INTEGER,\
+ 瀹炴湁浜烘暟閲� INTEGER,\
+ 涓撹亴浜哄憳鏁伴噺 INTEGER,\
+ 鎷ユ湁CIA浜烘暟 INTEGER,\
+ 纭曞＋瀛﹀巻浠ヤ笂浜烘暟 INTEGER,\
+ 鏈浜烘暟 INTEGER,\
+ 涓撶鍙婁互涓嬩汉鏁� INTEGER,\
+ 楂樼骇鑱岀О浜烘暟 INTEGER,\
+ 涓骇鑱岀О浜烘暟 INTEGER,\
+ 鍒濈骇鑱岀О浜烘暟 INTEGER,\
+ 鏃犺亴绉颁汉鏁� INTEGER,\
+ 浜斿崄宀佷互涓婁汉鏁� INTEGER,\
+ 涓夊崄鑷充簲鍗佸瞾宀佷汉鏁� INTEGER,\
+ 涓夊崄宀佷互涓嬩汉鏁� INTEGER,\
+ 瀹¤鏁伴噺 INTEGER,\
+ 浼氳鏁伴噺 INTEGER,\
+ 缁忔祹鏁伴噺 INTEGER,\
+ 娉曞緥鏁伴噺 INTEGER,\
+ 绠＄悊鏁伴噺 INTEGER,\
+ 淇℃伅鎶�鏈暟閲� INTEGER,\
+ 宸ョ▼鏁伴噺 INTEGER,\
+ 鍏朵粬鏁伴噺 INTEGER,\
+ 缁熻璐熻矗浜� 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::createTableHasEvidences(QString tableName)
--
Gitblit v1.8.0