diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.cpp b/softwareDirectory/AutoVerScheme/check_data_manage_serve.cpp deleted file mode 100644 index 08ede8b..0000000 --- a/softwareDirectory/AutoVerScheme/check_data_manage_serve.cpp +++ /dev/null @@ -1,107 +0,0 @@ -#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; - -}