diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index f9ce34d..797b4bd 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -445,33 +445,20 @@ bool BaseCommonApi::DeleteTask(QString id) { QSqlQuery query; - //删除任务单表 - query.prepare("DELETE FROM biz_business_order_info WHERE id = :id"); - query.bindValue(":id", id); - - if (!query.exec()) { - qDebug() << "删除失败: " << query.lastError().text(); - return false; - } - - //删除任务单样品表 - query.prepare("DELETE FROM biz_business_order_sample_relation WHERE order_id = :id"); - query.bindValue(":id", id); - - if (!query.exec()) { - qDebug() << "删除失败: " << query.lastError().text(); - return false; - } - - query.prepare("DELETE FROM biz_business_lab_executive_info WHERE order_id = :id "); - query.bindValue(":id", id); - - if (!query.exec()) { - qDebug() << "删除失败 " << query.lastError().text(); - return false; - } - - return true; + bool allSuccessful = true; + // 定义一个删除函数,用于复用删除逻辑 + auto deleteRecord = [&](const QString& tableName) { + query.prepare("DELETE FROM " + tableName + " WHERE order_id = :id"); + query.bindValue(":id", id); + if (!query.exec()) { + qDebug() << "删除" << tableName << "表中的记录失败: " << query.lastError().text(); + allSuccessful = false; + } + }; + deleteRecord("biz_business_order_info"); + deleteRecord("biz_business_order_sample_relation"); + deleteRecord("biz_business_lab_executive_info"); + return allSuccessful; } //删除任务单内设备 bool BaseCommonApi::DeleteTaskDevice(QString id)