From 1bb61da9f048f9f86b412479e3f4d18adb1876f2 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期五, 13 十二月 2024 23:39:41 +0800
Subject: [PATCH] 1213
---
internal_system_v1/threemergeproblemlist.cpp | 17 +++++++-
internal_system_v1/clientmainwindow.ui | 2
internal_system_v1/converinfo2.h | 3 +
internal_system_v1/converinfo2.cpp | 57 ++++++++++++++++++++++++++++
4 files changed, 75 insertions(+), 4 deletions(-)
diff --git a/internal_system_v1/clientmainwindow.ui b/internal_system_v1/clientmainwindow.ui
index babc988..873e317 100644
--- a/internal_system_v1/clientmainwindow.ui
+++ b/internal_system_v1/clientmainwindow.ui
@@ -18,7 +18,7 @@
<item row="0" column="0">
<widget class="QTabWidget" name="tabWidget">
<property name="currentIndex">
- <number>0</number>
+ <number>2</number>
</property>
<widget class="QWidget" name="tab">
<attribute name="title">
diff --git a/internal_system_v1/converinfo2.cpp b/internal_system_v1/converinfo2.cpp
index 6344e08..31a3900 100644
--- a/internal_system_v1/converinfo2.cpp
+++ b/internal_system_v1/converinfo2.cpp
@@ -103,6 +103,29 @@
auto resList = m_curItem->takeChildren();
qDebug()<<"鍒犻櫎鏁伴噺:"<<resList.size();
+
+ // 鍒犻櫎鏁版嵁搴撹〃閲岄潰瀵瑰簲鐨勫叕鍙镐俊鎭紝骞朵笖鍐嶆鍒锋柊涓嬫媺妗嗗拰鏍戠姸鍥�
+
+ // 鏁版嵁搴撹〃鏈夛細灏侀潰淇℃伅琛� all_company_info 缁煎悎淇℃伅琛� comprehensive_entry_info 涓夊悎涓�鐨勮〃 standing_book_info
+ QString name = m_curItem->text(0);
+ QStringList sp = name.split("(鏈骇)");
+ QStringList sp2 = name.split("涓嬬骇鏁�");
+ qDebug()<<"鎷嗗紑:"<<sp<<"姹囨��:"<<sp2;
+ if(sp.size() == 2){
+ name = sp.at(0);
+ }
+ if(sp2.size() == 2){ // 寰楅�掑綊鍒犻櫎搴曚笅鐨勬墍鏈夊崟浣�
+ name = sp2.at(0);
+ }
+ // 鍒犻櫎鎵�鏈夎〃涓繖涓悕瀛�
+ deleteAllByName(name);
+
+ // 鍒犻櫎瀹屼簡锛岃繕寰楀幓鍒锋柊涓嬫媺妗�
+
+ // 鍘诲埛鏂版爲褰㈠浘
+
+
+
}
void ConverInfo2::saveInfo()
@@ -1926,6 +1949,40 @@
qDebug()<<"rowCnt:"<<rowCnt;
}
}
+
+void ConverInfo2::deleteAllByName(QString name)
+{
+ // 鏁版嵁搴撹〃鏈夛細灏侀潰淇℃伅琛� all_company_info
+ // 缁煎悎淇℃伅琛� comprehensive_entry_info
+ // 涓夊悎涓�鐨勮〃 standing_book_info
+
+ QString first_sql = QString("delete from all_company_info where name='%1'").arg(name);
+ qDebug()<<"first_sql:"<<first_sql;
+
+ QString second_sql = QString("delete from comprehensive_entry_info where name='%1'").arg(name);
+ qDebug()<<"second_sql:"<<second_sql;
+
+ QString three_sql = QString("delete from standing_book_info where 璐ｄ换涓讳綋鍚嶇О='%1'").arg(name);
+ qDebug()<<"three_sql:"<<three_sql;
+
+
+ QSqlQuery query;
+ if(query.exec(first_sql))
+ {
+ qDebug()<<"first_sql run ok";
+ }
+ if(query.exec(second_sql))
+ {
+ qDebug()<<"second_sql run ok";
+ }
+ if(query.exec(three_sql))
+ {
+ qDebug()<<"three_sql run ok";
+ }
+
+
+
+}
void ConverInfo2::addTreeWidgetNode(QVariant upName,QVariant name){
// 娣诲姞宸﹁竟鏍戝舰鍥剧浉鍏�
// 鑿滃崟鐩稿叧 褰撲笂绾у叕鍙镐负绌轰笂绾ф椂锛岃嚜宸卞綋鑷繁鐨勪笂绾э紝骞朵笖缃楀垪杩涘幓褰� 鏈骇
diff --git a/internal_system_v1/converinfo2.h b/internal_system_v1/converinfo2.h
index 4256570..bbfe8f3 100644
--- a/internal_system_v1/converinfo2.h
+++ b/internal_system_v1/converinfo2.h
@@ -37,6 +37,9 @@
void saveToSQL(ComInfo &info);
void readAllSQLData(); // 灏嗘暟鎹簱琛ㄤ腑鐨勬暟鎹鍑烘潵鏀惧埌2涓猰ap涓紝涓�涓槸鏁版嵁map锛屼竴涓槸鍗曚綅鏍憁ap
+ // 鍒犻櫎鎸囧畾鍏徃鍚嶅湪鎵�鏈夎〃涓殑淇℃伅
+ void deleteAllByName(QString name);
+
signals:
void loadFinished(); // 鍔犺浇瀹屾垚鐨勪俊鍙�
void loadProgress(int); // 鍔犺浇杩涘害
diff --git a/internal_system_v1/threemergeproblemlist.cpp b/internal_system_v1/threemergeproblemlist.cpp
index 7a94827..72b25cd 100644
--- a/internal_system_v1/threemergeproblemlist.cpp
+++ b/internal_system_v1/threemergeproblemlist.cpp
@@ -6,6 +6,9 @@
#include <QMessageBox>
#include <QDir>
#include <QFileDevice>
+#include <QDesktopServices>
+#include <QFileDialog>
+
#include "noedititemdelegate.h"
#pragma execution_character_set("utf-8")
@@ -967,9 +970,9 @@
hasContentRow++;
// 闇�瑕佸皢鏂囦欢鎷疯礉鍒癷d鐩綍
- QString fpath = ui->tableWidget->item(i,13)->text();
- QString spath = ui->tableWidget->item(i,17)->text();
- QString tpath = ui->tableWidget->item(i,23)->text();
+ QString fpath = ui->tableWidget->item(i,13+2)->text();
+ QString spath = ui->tableWidget->item(i,17+2)->text();
+ QString tpath = ui->tableWidget->item(i,23+2)->text();
QString fid = ui->tableWidget->item(i,0)->text();
QString proName = ui->tableWidget->item(i,7)->text(); // 椤圭洰鍚嶇О
qDebug()<<"鎷疯礉鏂囦欢:"<<fid<<proName<<fpath;
@@ -1138,6 +1141,14 @@
qDebug()<<item_23->text();
}
}
+
+ // 浠ョ郴缁熼粯璁ょ殑鏂瑰紡鎵撳紑鎸囧畾鐨勬枃浠�
+ QUrl file_path = QFileDialog::getOpenFileUrl();
+ if(QDesktopServices::openUrl(file_path)){
+ qDebug()<<"open ok:"<<file_path;
+ }else{
+ qDebug()<<"open fail:"<<file_path;
+ }
}
void ThreeMergeProblemList::updateComboList(QMap<QString, ComInfo> & nameAndComInfos)
--
Gitblit v1.8.0