From 10457ff67b999e9cc99624801c635e7f25e0d5ef Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期四, 31 八月 2023 23:36:05 +0800
Subject: [PATCH] 0831
---
internal_system_v1/searchinfo.cpp | 140 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 139 insertions(+), 1 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 52166f7..4b6e206 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -1,6 +1,8 @@
#include "searchinfo.h"
#include "ui_searchinfo.h"
#include <QDebug>
+#include <QSqlError>
+#include <QSqlQuery>
SearchInfo::SearchInfo(QWidget *parent) :
QMainWindow(parent),
@@ -15,7 +17,8 @@
m_db.setDatabaseName("sqlData.db");
if(m_db.open()){
qDebug()<<"db open ok";
- m_db.close();
+ createSqlite();
+ //m_db.close();
}else{
qDebug()<<"db open fail";
}
@@ -25,5 +28,140 @@
SearchInfo::~SearchInfo()
{
+ m_db.close();
delete ui;
}
+
+void SearchInfo::createSqlite()
+{
+ // 寤鸿〃
+ QString sql = "create table Internal_1 (id int primary key, name varchar(30), _020100 int)";
+ QSqlQuery query;
+ if(query.exec(sql))
+ {
+ qDebug()<<"create Internal_1 ok...";
+ }else{
+ qDebug()<<"create Internal_1 fail..."<<query.lastError().text();
+ }
+
+ sql = "CREATE TABLE file_up_info (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ name VARCHAR (30),\
+ code TEXT,\
+ up_time TEXT\
+ )";
+ if(query.exec(sql))
+ {
+ qDebug()<<"create file_up_info ok...";
+ }else{
+ qDebug()<<"create file_up_info fail..."<<query.lastError().text();
+ }
+
+ sql = "CREATE TABLE company_info (\
+ 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\
+ )";
+ if(query.exec(sql))
+ {
+ qDebug()<<"create company_info ok...";
+ }else{
+ qDebug()<<"create company_info fail..."<<query.lastError().text();
+ }
+
+ // 瀹¤椤圭洰琛�
+ createTableNoEvidences("audit_project");
+
+ // 鍐呭宸ヤ綔閲忚〃
+ createTableNoEvidences("audit_workload");
+
+ // 闂閲戦琛�
+ createTableHasEvidences("problem_money");
+
+ // 闂涓暟琛�
+ createTableHasEvidences("problem_count");
+
+ // 闂鏁存敼琛�
+ createTableHasEvidences("problem_rectification");
+
+ // 闂鏁存敼--闈為噾棰濊〃
+ createTableHasEvidences("problem_no_money");
+
+ // 澶勫垎琛�
+ createTableNoEvidences("punish");
+
+ // 妗堜欢绾跨储琛�
+ createTableHasUnit("case_clue");
+
+}
+
+void SearchInfo::createTableHasEvidences(QString tableName)
+{
+ QString sql =QString( "CREATE TABLE %1 ( \
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ kpi_name TEXT,\
+ code TEXT,\
+ num INTEGER,\
+ evidences TEXT,\
+ com_id INTEGER\
+ )").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::createTableNoEvidences(QString tableName)
+{
+ QString sql = QString("CREATE TABLE %1 (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ kpi_name TEXT,\
+ code TEXT,\
+ num INTEGER,\
+ com_id INTEGER\
+ )").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::createTableHasUnit(QString tableName)
+{
+ QString sql = QString("CREATE TABLE %1 (\
+ id INTEGER PRIMARY KEY AUTOINCREMENT,\
+ kpi_name TEXT,\
+ code TEXT,\
+ unit TEXT,\
+ num INTEGER,\
+ com_id INTEGER\
+ )").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