diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.cpp b/softwareDirectory/AutoVerScheme/check_data_manage_serve.cpp new file mode 100644 index 0000000..08ede8b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.cpp @@ -0,0 +1,107 @@ +#include "check_data_manage_serve.h" + +Check_Data_Manage_Serve::Check_Data_Manage_Serve() +{ + +} + //核查数据管理 +QList Check_Data_Manage_Serve::getCheckData() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id , bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.meter_standard_name ,bei.meter_standard_id ," + " besci.create_user_name , besci.check_date , bei.dept_name " + " FROM biz_equipment_info bei LEFT JOIN biz_equipment_standard_check_info besci ON besci.equipment_id = bei.id"); + if (query.exec()) { + while (query.next()) { + CheckData dataManage; + dataManage.id = query.value("id").toString(); + dataManage.equipment_name = query.value("equipment_name").toString(); + dataManage.model = query.value("model").toString(); + dataManage.manufacture_no = query.value("manufacture_no").toString(); + dataManage.meter_standard_name = query.value("meter_standard_name").toString(); + dataManage.meter_standard_id = query.value("meter_standard_id").toString(); + dataManage.create_user_name = query.value("create_user_name").toString(); + dataManage.check_date = query.value("check_date").toString(); + dataManage.dept_name = query.value("dept_name").toString(); + + result.append(dataManage); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //核查数据管理-核查基本信息 +QList Check_Data_Manage_Serve::getCheckDataManageBasicInfo(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer ,besci.temperature ,besci.humidity ,besci.check_date ," + " besci.check_address , besci.create_user_name , besci.conclusion " + "FROM biz_equipment_info bei LEFT JOIN biz_equipment_standard_check_info besci ON besci.equipment_id = bei.id " + " LEFT JOIN biz_equipment_standard_check_info_equipment bescie ON bei.id = bescie.check_equipment_id" + " WHERE bei.id = :id "); + + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CheckDataManageBasicInfo basicInfo; + basicInfo.equipment_name = query.value("equipment_name").toString(); + basicInfo.model = query.value("model").toString(); + basicInfo.manufacture_no = query.value("manufacture_no").toString(); + basicInfo.manufacturer = query.value("manufacturer").toString(); + basicInfo.temperature = query.value("temperature").toString(); + basicInfo.humidity = query.value("humidity").toString(); + basicInfo.check_date = query.value("check_date").toString(); + basicInfo.check_address = query.value("check_address").toString(); + basicInfo.create_user_name = query.value("create_user_name").toString(); + basicInfo.conclusion = query.value("conclusion").toString(); + + result.append(basicInfo); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} +//核查数据管理-核查结果信息-核查项多功能校准源数据 +QList getCheckDataManageResultManageMult(QString equipment_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bescidc.id , bescidc.check_type ,bescidc.params ,bescidc.unit ,bescidc.frequency ,bescidc.check_point ,besci.check_date ,bescidc.urel ," + " bescidc.tfer ,bescidc.dccp ,bescidc.flit " + " FROM biz_equipment_standard_check_item_data_calibrator bescidc " + " LEFT JOIN biz_equipment_standard_check_info besci ON besci.item_category_id = bescidc.item_category_id " + " WHERE bescidc.equipment_id = :equipment_id "); + + // 将参数绑定到占位符 '1692796512381222914' + query.bindValue(":equipment_id", equipment_id); + if (query.exec()) { + while (query.next()) { + CheckDataManageResultManageMult dataCalibrator; + dataCalibrator.id = query.value("id").toString(); + dataCalibrator.check_type = query.value("check_type").toString(); + dataCalibrator.params = query.value("params").toString(); + dataCalibrator.unit = query.value("unit").toString(); + dataCalibrator.frequency = query.value("frequency").toString(); + dataCalibrator.check_point = query.value("check_point").toString(); + dataCalibrator.check_date = query.value("check_date").toString(); + dataCalibrator.urel = query.value("urel").toString(); + dataCalibrator.tfer = query.value("tfer").toString(); + dataCalibrator.dccp = query.value("dccp").toString(); + dataCalibrator.flit = query.value("flit").toString(); + + result.append(dataCalibrator); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; + +}