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/converinfo2.cpp | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 57 insertions(+), 0 deletions(-)
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){
// 娣诲姞宸﹁竟鏍戝舰鍥剧浉鍏�
// 鑿滃崟鐩稿叧 褰撲笂绾у叕鍙镐负绌轰笂绾ф椂锛岃嚜宸卞綋鑷繁鐨勪笂绾э紝骞朵笖缃楀垪杩涘幓褰� 鏈骇
--
Gitblit v1.8.0