diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index b5b55d0..afda56b 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -1584,6 +1584,39 @@ return result; } +//查询检定项分类 +QList getitemCategoryList(QString item) +{ + QList result; + QSqlQuery query; + if(item.isEmpty() || item.isNull()){ + query.prepare("SELECT * FROM biz_business_device_measure_item_category"); + }else { + query.prepare("SELECT * FROM biz_business_device_measure_item_category WHERE belong_standard_equipment = :item "); + } + if (query.exec()) { + while (query.next()) { + itemCategory category; + category.id = query.value("id").toString(); + category.category_no = query.value("category_no").toString(); + category.category_name = query.value("category_name").toString(); + category.create_time = query.value("create_time").toDateTime(); + category.device_type = query.value("device_type").toString(); + category.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + category.measure_category = query.value("measure_category").toString(); + category.technology_file = query.value("technology_file").toString(); + category.update_time = query.value("update_time").toDateTime(); + category.lab_x = query.value("lab_x").toString(); + category.lab_h = query.value("lab_h").toString(); + category.wiring_diagram = query.value("wiring_diagram").toString(); + result.append(category); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + //检定程序管理-编辑 查询 VerificationProgramInfo BaseCommonApi::getVerificationProgramInfo(QString id) diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index b5b55d0..afda56b 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -1584,6 +1584,39 @@ return result; } +//查询检定项分类 +QList getitemCategoryList(QString item) +{ + QList result; + QSqlQuery query; + if(item.isEmpty() || item.isNull()){ + query.prepare("SELECT * FROM biz_business_device_measure_item_category"); + }else { + query.prepare("SELECT * FROM biz_business_device_measure_item_category WHERE belong_standard_equipment = :item "); + } + if (query.exec()) { + while (query.next()) { + itemCategory category; + category.id = query.value("id").toString(); + category.category_no = query.value("category_no").toString(); + category.category_name = query.value("category_name").toString(); + category.create_time = query.value("create_time").toDateTime(); + category.device_type = query.value("device_type").toString(); + category.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + category.measure_category = query.value("measure_category").toString(); + category.technology_file = query.value("technology_file").toString(); + category.update_time = query.value("update_time").toDateTime(); + category.lab_x = query.value("lab_x").toString(); + category.lab_h = query.value("lab_h").toString(); + category.wiring_diagram = query.value("wiring_diagram").toString(); + result.append(category); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + //检定程序管理-编辑 查询 VerificationProgramInfo BaseCommonApi::getVerificationProgramInfo(QString id) diff --git a/softwareDirectory/AutoVerScheme/indexwindow.ui b/softwareDirectory/AutoVerScheme/indexwindow.ui index 2c36717..0528404 100644 --- a/softwareDirectory/AutoVerScheme/indexwindow.ui +++ b/softwareDirectory/AutoVerScheme/indexwindow.ui @@ -97,7 +97,7 @@ QFrame::Plain - 自动检定系统(计准仪器) + 自动检定系统 Qt::AutoText