diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 79dc7c5..1152057 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -1,4 +1,5 @@ #include "basecommonapi.h" +#include BaseCommonApi::BaseCommonApi() { @@ -463,13 +464,11 @@ } - - - //核查直流稳压电源检定装置 + //核查直流稳压电源检定装置 待修改 禁用 2024年3月20日13:55:12 查询的不对 QListBaseCommonApi::getCheckDCPower(QString equipment_id,QStringList *headList) { - equipment_id="1693435753272557570"; +// equipment_id="1693435753272557570"; QList result; QSqlQuery query; query.prepare("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number " @@ -593,10 +592,36 @@ return result; } -//判断 哪个 装置表 传参 设备id +//核查 判断哪个装置表 +JudgeCalibrationTable BaseCommonApi::getJudgeVerifyTable(QString deviceId) +{ + JudgeCalibrationTable result; + QSqlQuery query; + query.prepare("SELECT besi.standard_name,bescic.belong_standard_equipment FROM biz_equipment_standard_info besi " + " JOIN biz_equipment_standard_check_item_category bescic ON bescic.belong_standard_equipment_name = besi.standard_name " + " WHERE besi.id = ( SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :deviceId )"); + // 将参数绑定到占位符 '1692796512381222914' + query.bindValue(":deviceId", deviceId); + if (query.exec()) { + while (query.next()) { + JudgeCalibrationTable calibration; + calibration.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + // QString equipmentValue = query.value("belong_standard_equipment").toString(); + + result = calibration; + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + + return result; +} + +//判断 检定 哪个装置表 传参 设备id QList BaseCommonApi::getJudgeCalibrationTable(QString id) { - id="1716997603953311746"; +// id="1716997603953311746"; QList result; QSqlQuery query; query.prepare("SELECT id,belong_standard_equipment FROM biz_business_device_measure_item_info bbdmii WHERE bbdmii.device_model_id =(SELECT eei.model_id from eqpt_equipment_info eei WHERE eei.id = :id )"); @@ -605,9 +630,9 @@ if (query.exec()) { while (query.next()) { JudgeCalibrationTable calibration; - calibration.item_category_id = query.value("item_category_id").toString(); + calibration.id = query.value("id").toString(); calibration.belong_standard_equipment = query.value("belong_standard_equipment").toString(); - QString equipmentValue = query.value("belong_standard_equipment").toString(); +// QString equipmentValue = query.value("belong_standard_equipment").toString(); result.append(calibration); } @@ -642,7 +667,6 @@ */ //根据被检设备ID获取当前设备的 核查项目及核查点 - QList BaseCommonApi::Search_CalibrationTable(QString DeiverId,QStringList *HeadList) { @@ -653,16 +677,37 @@ switch (CliTable[0].belong_standard_equipment.toInt()) { case 1: - +<<<<<<< .mine //CliTable[0].id + //1717086652508487681 + DataList=BaseCommonApi::getVerMultiCal(CliTable[0].id,HeadList); +======= //Clable[0].item_category_idiT //1717086652508487681 后面替换为 Clable[0].item_category_id DataList=BaseCommonApi::getVerMultiCal("1717086652508487681",HeadList); - break; +>>>>>>> .theirs break; } return DataList; } +//查找设备对应的装置表 传参设备id +QList BaseCommonApi::Search_VerifyTable(QString DeiverId,QStringList *HeadList ) +{ + QList DataList; + JudgeCalibrationTable CliTable=BaseCommonApi::getJudgeVerifyTable(DeiverId); + if(CliTable.belong_standard_equipment.isEmpty() || CliTable.belong_standard_equipment.isNull()) return DataList; + switch(CliTable.belong_standard_equipment.toInt()) + { + case 1: //多功能校准源 + DataList = BaseCommonApi::getVerificationItemsMultiList(DeiverId,HeadList); + break; + } + return DataList; +} + + + + //被检设备管理-检定项目及检定点-多功能校准源 QList BaseCommonApi::getVerMultiCal(QString itemId,QStringList *headList) @@ -672,32 +717,42 @@ resultData.clear(); QSqlQuery query; - query.prepare("SELECT bbdmidc.id ,bbdmidc.params ,bbdmidc.capacity ,bbdmidc.unit ,bbdmidc.frequency , bbdmidc.range_range , bbdmidc.standard_value , bbdmidc.resolution , bbdmidc.maximum_error , bbdmidc.error_param_a , bbdmidc.error_param_b " - " FROM biz_business_device_measure_item_data_calibrator bbdmidc WHERE item_id = :itemId "); + query.prepare("SELECT * FROM biz_business_device_measure_item_data_calibrator bbdmidc WHERE item_id = :itemId "); // 将参数绑定到占位符 query.bindValue(":itemId", itemId); - - if (query.exec()) { while (query.next()) { result.clear(); result.append(query.value("id").toString()); + result.append(query.value("item_id").toString()); result.append(query.value("params").toString()); result.append(query.value("capacity").toString()); result.append(query.value("unit").toString()); result.append(query.value("frequency").toString()); + result.append(query.value("frequency_unit").toString()); result.append(query.value("range_range").toString()); result.append(query.value("standard_value").toString()); result.append(query.value("resolution").toString()); result.append(query.value("maximum_error").toString()); result.append(query.value("error_param_a").toString()); result.append(query.value("error_param_b").toString()); + result.append(query.value("line_mode").toString()); + result.append(query.value("coil_enlarge").toString()); + result.append(query.value("indicating_value").toString()); + result.append(query.value("accuracy_a").toString()); + result.append(query.value("full_scale_value").toString()); + result.append(query.value("full_scale_value_unit").toString()); + result.append(query.value("measure_indication_value").toString()); + result.append(query.value("accuracy_level").toString()); + result.append(query.value("create_time").toString()); + result.append(query.value("update_time").toString()); resultData.append(result); } } else { qDebug() << "Query execution failed: " << query.lastError().text(); } - *headList<<"序号"<<"参数"<<"量"<<"单位"<<"频率"<<"量程"<<"标准值"<<"分辨力"<<"最大允许误差"<<"误差参数a"<<"误差参数b"; + *headList<<"序号"<<"检定项id"<<"参数"<<"量"<<"单位"<<"频率"<<"频率单位"<<"量程"<<"标准值"<<"分辨力"<<"最大允许误差(公式)"<<"误差参数a"<<"误差参数b" + <<"两线/四线模式"<<"线圈放大"<<"示值"<<"准确度a"<<"指针式仪表满量程值"<<"指针式仪表满量程值单位"<<"被检表示值"<<"准确度等级"<<"创建时间"<<"更新时间"; return resultData; } @@ -1059,13 +1114,13 @@ -//新建检定程序 增加更新时间 2024年3月18日13:28:13 待修改 +//新建检定程序 增加更新时间 2024年3月18日13:28:13 修改完毕2024年3月20日14:49:00 bool BaseCommonApi::InsertVerificationProgramInfo(VerificationProgramInfo verInfo) { QSqlQuery query; - query.prepare("INSERT INTO zd_verification_program_info (id, program_name, create_name, create_time, remark, img_path, tested_device_id, standard_device_id)" + query.prepare("INSERT INTO zd_verification_program_info (id, program_name, create_name, create_time, remark, img_path, tested_device_id, standard_device_id,update_time)" - " VALUES (:id, :program_name, :create_name, :create_time, :remark, :img_path, :tested_device_id, :standard_device_id);"); + " VALUES (:id, :program_name, :create_name, :create_time, :remark, :img_path, :tested_device_id, :standard_device_id,:update_time);"); QString formattedDateTime = verInfo.create_time.toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id", verInfo.id); query.bindValue(":program_name", verInfo.program_name); @@ -1075,6 +1130,7 @@ query.bindValue(":img_path", verInfo.img_path); query.bindValue(":tested_device_id", verInfo.tested_device_id); query.bindValue(":standard_device_id", verInfo.standard_device_id); + query.bindValue(":update_time",formattedDateTime); bool isSuccess = query.exec(); if (!isSuccess) { @@ -1106,16 +1162,20 @@ return isSuccess; } -//更新检定程序 更新时间 2024年3月18日13:28:34 增加字段 待修改 + +//更新检定程序 更新时间 2024年3月18日13:28:34 增加更新 修改完成 2024年3月20日14:50:45 bool BaseCommonApi::UpdateVerificationProgramInfo(VerificationProgramInfo verInfo) { QSqlQuery query; query.prepare("UPDATE zd_verification_program_info " - " SET program_name = :program_name,create_name = :create_name, " - "remark = :remark,img_path = :img_path,tested_device_id = :tested_device_id,standard_device_id = :standard_device_id " + " SET program_name = :program_name,create_name = :create_name, create_time = :create_time" + "remark = :remark,img_path = :img_path,tested_device_id = :tested_device_id,standard_device_id = :standard_device_id ,update_time = :update_time" "WHERE id = :id;"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); + query.bindValue(":update_time",currentDateTime); query.bindValue(":program_name", verInfo.program_name); query.bindValue(":create_name", verInfo.create_name); + query.bindValue(":create_time", verInfo.create_time); query.bindValue(":remark", verInfo.remark); query.bindValue(":img_path", verInfo.img_path); query.bindValue(":tested_device_id", verInfo.tested_device_id); @@ -1164,10 +1224,9 @@ bool BaseCommonApi::InsertInstructionLib(InstructionLib instructionLib) { QSqlQuery query; - query.prepare("INSERT INTO zd_instruction_library (id,device_id,device_name,instruct_config,instruct_read,type,belong_vername,belong_checkname,create_time,update_time) " + query.prepare("INSERT INTO zd_instruction_library (id,device_id,device_name,instruct_config,instruct_read,type,verification_id,check_id,create_time,update_time) " " VALUES (:id,:device_id,:device_name,:instruct_config,:instruct_read,:type,:belong_vername,:belong_checkname,:create_time,:update_time)"); - QString formattedCreateDateTime = instructionLib.create_time.toString("yyyy-MM-dd HH:mm:ss"); - QString formattedUpdateDateTime = instructionLib.update_time.toString("yyyy-MM-dd HH:mm:ss"); + query.bindValue(":id", instructionLib.id); query.bindValue(":device_id", instructionLib.device_id); query.bindValue(":device_name", instructionLib.device_name); @@ -1176,8 +1235,8 @@ query.bindValue(":type", instructionLib.type); query.bindValue(":belong_vername", instructionLib.belong_vername); query.bindValue(":belong_checkname", instructionLib.belong_checkname); - query.bindValue(":create_time", formattedCreateDateTime); - query.bindValue(":update_time", formattedUpdateDateTime); + query.bindValue(":create_time", instructionLib.create_time); + query.bindValue(":update_time", instructionLib.update_time); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -1272,23 +1331,48 @@ } //自动检定-结果保存-检定数据管理多功能校准源数据(自动检定输出或业务创建) -bool BaseCommonApi::UpdateVerMultiCal(SaveDeviceMeasureCalibrator measureCalibrator) +bool BaseCommonApi::InsertVerMultiCal(SaveDeviceMeasureCalibrator measureCalibrator) { QSqlQuery query; - query.prepare("UPDATE biz_business_device_measure_item_data_calibrator" - " SET indicating_value = :indicating_value," - " SET absolute_error = :absolute_error," - " SET update_time = :update_time," - " SET remark = :remark " - " WHERE id = :id;"); + query.prepare("INSERT INTO biz_business_device_measure_data_calibrator " + " (id,data_id,item_data_id,maximum_error_formula,error_param_a,error_param_b,params,capacity,unit,frequency,frequency_unit," + "range_range,standard_value,indicating_value,maximum_error,absolute_error,resolution,line_mode,remark,an,bn,cn,delta_an," + "delta_bn,delta_cn,measure_indication_value,standard_value_upper_limit,accuracy_level,create_time,update_time) " + " VALUES " + " (:id,:data_id,:item_data_id,:maximum_error_formula,:error_param_a,:error_param_b,:params,:capacity,:unit,:frequency,:frequency_unit,:range_range,:standard_value,:indicating_value,:maximum_error,:absolute_error,:resolution,:line_mode,:remark,:an,:bn,:cn,:delta_an,:delta_bn,:delta_cn,:measure_indication_value,:standard_value_upper_limit,:accuracy_level,:create_time,:update_time);"); - QString formattedUpdateDateTime = measureCalibrator.update_time.toString("yyyy-MM-dd HH:mm:ss"); - query.bindValue(":indicating_value", measureCalibrator.indicating_value); - query.bindValue(":absolute_error", measureCalibrator.absolute_error); - query.bindValue(":remark", measureCalibrator.remark); - query.bindValue(":update_time", formattedUpdateDateTime); - query.bindValue(":id",measureCalibrator.id); + QString formattedUpdateDateTime = measureCalibrator.create_time.toString("yyyy-MM-dd HH:mm:ss"); + query.bindValue(":id",measureCalibrator.id); + query.bindValue(":data_id",measureCalibrator.data_id); + query.bindValue(":item_data_id",measureCalibrator.item_data_id); + query.bindValue(":maximum_error_formula",measureCalibrator.maximum_error_formula); + query.bindValue(":error_param_a",measureCalibrator.error_param_a); + query.bindValue(":error_param_b",measureCalibrator.error_param_b); + query.bindValue(":params",measureCalibrator.params); + query.bindValue(":capacity",measureCalibrator.capacity); + query.bindValue(":unit",measureCalibrator.unit); + query.bindValue(":frequency",measureCalibrator.frequency); + query.bindValue(":frequency_unit",measureCalibrator.frequency_unit); + query.bindValue(":range_range",measureCalibrator.range_range); + query.bindValue(":standard_value",measureCalibrator.standard_value); + query.bindValue(":indicating_value",measureCalibrator.indicating_value); + query.bindValue(":maximum_error",measureCalibrator.maximum_error); + query.bindValue(":absolute_error",measureCalibrator.absolute_error); + query.bindValue(":resolution",measureCalibrator.resolution); + query.bindValue(":line_mode",measureCalibrator.line_mode); + query.bindValue(":remark",measureCalibrator.remark); + query.bindValue(":an",measureCalibrator.an); + query.bindValue(":bn",measureCalibrator.bn); + query.bindValue(":cn",measureCalibrator.cn); + query.bindValue(":delta_an",measureCalibrator.delta_an); + query.bindValue(":delta_bn",measureCalibrator.delta_bn); + query.bindValue(":delta_cn",measureCalibrator.delta_cn); + query.bindValue(":measure_indication_value",measureCalibrator.measure_indication_value); + query.bindValue(":standard_value_upper_limit",measureCalibrator.standard_value_upper_limit); + query.bindValue(":accuracy_level",measureCalibrator.accuracy_level); + query.bindValue(":create_time",formattedUpdateDateTime); + query.bindValue(":update_time",formattedUpdateDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertOrderSampleRelation query failed: " << query.lastError().text(); @@ -1390,36 +1474,46 @@ } return result; } - //核查程序管理-核查设置-多功能校准源 参数设备id -QList BaseCommonApi::getVerificationItemsMultiList(QString deviceId) + //核查程序管理-核查设置-多功能校准源 参数设备id 同信息管理-标准设备管理-核查项及核查点 +QList BaseCommonApi::getVerificationItemsMultiList(QString equipment_id,QStringList *headList) { - QList result; + QList resultData; + QStringList result; QSqlQuery query; - query.prepare("SELECT bescidc.id,bescidc.check_type,bescidc.unit ,bescidc.frequency ,bescidc.check_point ," - "bescidc.resolution ,bescidc.cycle_number ,bescidc.urel ,bescidc.thoroughfare ,bescidc.tfer " - ",bescidc.dccp,bescidc.flit " - "from biz_equipment_standard_check_item_data_calibrator bescidc WHERE bescidc.equipment_id = :deviceId" + query.prepare("SELECT * " + " from biz_equipment_standard_check_item_data_calibrator bescidc WHERE bescidc.equipment_id = :equipment_id" "from biz_equipment_standard_check_item_data_calibrator bescidc WHERE bescidc.equipment_id = '1692808528303013889' "); - query.bindValue(":deviceId", deviceId); + query.bindValue(":equipment_id", equipment_id); if (query.exec()) { while (query.next()) { - VerificationItemsMulti item; - item.id = query.value("id").toString(); - item.check_type = query.value("check_type").toString(); - item.unit = query.value("unit").toString(); - item.frequency = query.value("frequency").toString(); - item.check_point = query.value("check_point").toString(); - item.resolution = query.value("resolution").toString(); - item.cycle_number = query.value("cycle_number").toString(); - item.urel = query.value("urel").toString(); - item.thoroughfare = query.value("thoroughfare").toString(); - item.tfer = query.value("tfer").toString(); - result.append(item); + result.clear(); + result.append( query.value("id").toString()); + result.append( query.value("item_category_id").toString()); + result.append( query.value("equipment_id").toString()); + result.append( query.value("check_type").toString()); + result.append( query.value("test_type").toString()); + result.append( query.value("params").toString()); + result.append( query.value("unit").toString()); + result.append( query.value("frequency").toString()); + result.append( query.value("check_point").toString()); + result.append( query.value("resolution").toString()); + result.append( query.value("cycle_number").toString()); + result.append( query.value("frequency_unit").toString()); + result.append( query.value("urel").toString()); + result.append( query.value("thoroughfare").toString()); + result.append( query.value("dccp").toString()); + result.append( query.value("flit").toString()); + result.append( query.value("remark").toString()); + result.append( query.value("create_time").toString()); + result.append( query.value("update_time").toString()); + resultData.append(result); } } else { qDebug() << "Query execution failed: " << query.lastError().text(); } - return result; + *headList <<"id"<<"核查项分类id"<<"配套设备id"<<"核查类型"<<"核查点类型"<<"核查项目"<<"单位"<<"频率"<<"分辨力"<<"核查点" + <<"频率单位"<<"循环次数"<<"Urel"<<"通道"<<"TFER"<<"DCCP"<<"FLIT"<<"核查项备注"<<"创建时间"<<"更新时间"; + return resultData; } //新增核查程序 @@ -1483,4 +1577,219 @@ } return isSuccess; } +//自动核查-结果保存- + //自动核查-结果保存-设备与装置-标准装置管理-核查数据管理0.02级活塞式压力计数据表 +bool BaseCommonApi::InsertStandardCheckDatePistonGauge(StandardCheckDatePistonGauge gauge) +{ + QSqlQuery query; + query.prepare("INSERT INTO biz_equipment_standard_check_data_piston_gauge " + " (id,data_id,unit,check_point,first_forward_stroke,first_reverse_stroke,second_forward_stroke,second_reverse_stroke,third_forward_stroke,third_reverse_stroke,average_value," + "average_average_value,max_indicating_error,max_return_error,params,test_value_one,measure_value_one,test_value_two,measure_value_two,test_value_three,measure_value_three," + "test_value_four,measure_value_four,test_value_five,measure_value_five,test_value_six,measure_value_six,maximum_error,create_time,update_time) " + " VALUES " + " (:id,:data_id,:unit,:check_point,:first_forward_stroke,:first_reverse_stroke,:second_forward_stroke,:second_reverse_stroke,:third_forward_stroke,:third_reverse_stroke,:average_value,:average_average_value,:max_indicating_error,:max_return_error,:params,:test_value_one,:measure_value_one,:test_value_two,:measure_value_two,:test_value_three,:measure_value_three,:test_value_four,:measure_value_four,:test_value_five,:measure_value_five,:test_value_six,:measure_value_six,:maximum_error,:create_time,:update_time) "); + QString formattedDateTime = gauge.create_time.toString("yyyy-MM-dd HH:mm:ss"); + query.bindValue(":id",gauge.id); + query.bindValue(":data_id",gauge.data_id); + query.bindValue(":unit",gauge.unit); + query.bindValue(":check_point",gauge.check_point); + query.bindValue(":first_forward_stroke",gauge.first_forward_stroke); + query.bindValue(":first_reverse_stroke",gauge.first_reverse_stroke); + query.bindValue(":second_forward_stroke",gauge.second_forward_stroke); + query.bindValue(":second_reverse_stroke",gauge.second_reverse_stroke); + query.bindValue(":third_forward_stroke",gauge.third_forward_stroke); + query.bindValue(":third_reverse_stroke",gauge.third_reverse_stroke); + query.bindValue(":average_value",gauge.average_value); + query.bindValue(":average_average_value",gauge.average_average_value); + query.bindValue(":max_indicating_error",gauge.max_indicating_error); + query.bindValue(":max_return_error",gauge.max_return_error); + query.bindValue(":params",gauge.params); + query.bindValue(":test_value_one",gauge.test_value_one); + query.bindValue(":measure_value_one",gauge.measure_value_one); + query.bindValue(":test_value_two",gauge.test_value_two); + query.bindValue(":measure_value_two",gauge.measure_value_two); + query.bindValue(":test_value_three",gauge.test_value_three); + query.bindValue(":measure_value_three",gauge.measure_value_three); + query.bindValue(":test_value_four",gauge.test_value_four); + query.bindValue(":measure_value_four",gauge.measure_value_four); + query.bindValue(":test_value_five",gauge.test_value_five); + query.bindValue(":measure_value_five",gauge.measure_value_five); + query.bindValue(":test_value_six",gauge.test_value_six); + query.bindValue(":measure_value_six",gauge.measure_value_six); + query.bindValue(":maximum_error",gauge.maximum_error); + query.bindValue(":create_time",formattedDateTime); + query.bindValue(":update_time",formattedDateTime); + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); + } + + return isSuccess; + +} + //自动核查-结果保存-基本信息 +bool BaseCommonApi::InsertCheckDataManageBasicInfo(CheckDataManageBasicInfo baseInfo) +{ + QSqlQuery query; + query.prepare("INSERT INTO biz_equipment_standard_check_info " + " (id,data_no,check_date,check_address,temperature,humidity,check_accord,stability_examine,standard_equipment_id" + ",equipment_id,item_category_id,conclusion,remark,create_user_id,create_user_name,create_time,update_time) " + " VALUES " + " (:id,:data_no,:check_date,:check_address,:temperature,:humidity,:check_accord,:stability_examine,:standard_equipment_id," + ":equipment_id,:item_category_id,:conclusion,:remark,:create_user_id,:create_user_name,:create_time,:update_time) "); + QString checkData = baseInfo.check_date.toString("yyyy-MM-dd"); + QString formattedDateTime = baseInfo.create_time.toString("yyyy-MM-dd HH:mm:ss"); + query.bindValue(":id",baseInfo.id); + query.bindValue(":data_no",baseInfo.data_no); + query.bindValue(":check_date",checkData); + query.bindValue(":check_address",baseInfo.check_address); + query.bindValue(":temperature",baseInfo.temperature); + query.bindValue(":humidity",baseInfo.humidity); + query.bindValue(":check_accord",baseInfo.check_accord); + query.bindValue(":stability_examine",baseInfo.stability_examine); + query.bindValue(":standard_equipment_id",baseInfo.standard_equipment_id); + query.bindValue(":equipment_id",baseInfo.equipment_id); + query.bindValue(":item_category_id",baseInfo.item_category_id); + query.bindValue(":conclusion",baseInfo.conclusion); + query.bindValue(":remark",baseInfo.remark); + query.bindValue(":create_user_id",baseInfo.create_user_id); + query.bindValue(":create_user_name",baseInfo.create_user_name); + query.bindValue(":create_time",formattedDateTime); + query.bindValue(":update_time",formattedDateTime); + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); + } + + return isSuccess; +} + //自动检定和自动核查 查询实验室及温湿度 最新的1条 TODO 待修改 查指定表的地点或者介质 +LocationInfo BaseCommonApi::getLocationInfo() +{ + LocationInfo result; + QSqlQuery query; + bool isSuccess = query.exec("SELECT * FROM env_location_info eli LEFT JOIN ( SELECT temperature, humidity, location_id AS locationId " + " FROM env_environment_record_data ) ethd ON ethd.locationId = eli.id " + " ORDER BY update_time DESC LIMIT 1"); + if (isSuccess) { + while (query.next()) { + LocationInfo info; + info.id = query.value("id").toString(); + info.location_no = query.value("location_no").toString(); + info.location_name = query.value("location_name").toString(); + info.location_position = query.value("location_position").toString(); + info.create_user_id = query.value("create_user_id").toString(); + info.create_user = query.value("create_user").toString(); + info.create_time = query.value("create_time").toDateTime(); + info.update_time = query.value("update_time").toDateTime(); + info.location_lab = query.value("location_lab").toString(); + info.temperature = query.value("temperature").toString(); + info.humidity = query.value("humidity").toString(); + info.location_id = query.value("location_id").toString(); + result = info; + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + //查询出所有实验室地点，用于自动检定/核查 结果保存 地点下拉框查询 +QList BaseCommonApi::getLocationInfoList() +{ + QList result; + QSqlQuery query; + bool isSuccess = query.exec("SELECT * FROM env_location_info"); + if (isSuccess) { + while (query.next()) { + LocationInfo info; + info.id = query.value("id").toString(); + info.location_no = query.value("location_no").toString(); + info.location_name = query.value("location_name").toString(); + info.location_position = query.value("location_position").toString(); + info.create_user_id = query.value("create_user_id").toString(); + info.create_user = query.value("create_user").toString(); + info.create_time = query.value("create_time").toDateTime(); + info.update_time = query.value("update_time").toDateTime(); + info.location_lab = query.value("location_lab").toString(); + result.append(info); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + //查询所有用户，用于自动检定/核查 结果保存 地点下拉框查询 +QList BaseCommonApi::getUser() +{ + QList result; + QSqlQuery query; + bool isSuccess = query.exec("SELECT * FROM sys_user"); + if (isSuccess) { + while (query.next()) { + User user; + user.ID = query.value("ID").toString(); + user.NAME = query.value("NAME").toString(); + user.DEPT_ID = query.value("DEPT_ID").toString(); + + result.append(user); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} +//自动核查--结果保存-设备与装置-标准装置管理-核查数据管理多功能校准源数据表 +bool BaseCommonApi::InsertStandCheckDataCalibrator(StandCheckDataCalibrator calibrator) +{ + QSqlQuery query; + query.prepare("INSERT INTO biz_equipment_standard_check_data_calibrator " + "(id, data_id, check_type, test_type, params, unit, frequency, frequency_unit, check_point, " + "test_value_one_date, test_value_one, test_value_two_date, test_value_two, " + "test_value_three_date, test_value_three, test_value_four_date, test_value_four, " + "test_value_five_date, test_value_five, test_value_six_date, test_value_six, average_value, " + "standard_deviation, relative_repeatability, urel, less_than, qualified, create_time, update_time) " + "VALUES " + "(:id, :data_id, :check_type, :test_type, :params, :unit, :frequency, :frequency_unit, :check_point, " + ":test_value_one_date, :test_value_one, :test_value_two_date, :test_value_two, " + ":test_value_three_date, :test_value_three, :test_value_four_date, :test_value_four, " + ":test_value_five_date, :test_value_five, :test_value_six_date, :test_value_six, :average_value, " + ":standard_deviation, :relative_repeatability, :urel, :less_than, :qualified, :create_time, :update_time)"); + QString formattedDateTime = calibrator.create_time.toString("yyyy-MM-dd HH:mm:ss"); + // 绑定所有值 + query.bindValue(":id", calibrator.id); + query.bindValue(":data_id", calibrator.data_id); + query.bindValue(":check_type", calibrator.check_type); + query.bindValue(":test_type", calibrator.test_type); + query.bindValue(":params", calibrator.params); + query.bindValue(":unit", calibrator.unit); + query.bindValue(":frequency", calibrator.frequency); + query.bindValue(":frequency_unit", calibrator.frequency_unit); + query.bindValue(":check_point", calibrator.check_point); + query.bindValue(":test_value_one_date", calibrator.test_value_one_date.toString("yyyy-MM-dd")); + query.bindValue(":test_value_one", calibrator.test_value_one); + query.bindValue(":test_value_two_date", calibrator.test_value_two_date.toString("yyyy-MM-dd")); + query.bindValue(":test_value_two", calibrator.test_value_two); + query.bindValue(":test_value_three_date", calibrator.test_value_three_date.toString("yyyy-MM-dd")); + query.bindValue(":test_value_three", calibrator.test_value_three); + query.bindValue(":test_value_four_date", calibrator.test_value_four_date.toString("yyyy-MM-dd")); + query.bindValue(":test_value_four", calibrator.test_value_four); + query.bindValue(":test_value_five_date", calibrator.test_value_five_date.toString("yyyy-MM-dd")); + query.bindValue(":test_value_five", calibrator.test_value_five); + query.bindValue(":test_value_six_date", calibrator.test_value_six_date.toString("yyyy-MM-dd")); + query.bindValue(":test_value_six", calibrator.test_value_six); + query.bindValue(":average_value", calibrator.average_value); + query.bindValue(":standard_deviation", calibrator.standard_deviation); + query.bindValue(":relative_repeatability", calibrator.relative_repeatability); + query.bindValue(":urel", calibrator.urel); + query.bindValue(":less_than", calibrator.less_than); + query.bindValue(":qualified", calibrator.qualified); + query.bindValue(":create_time", formattedDateTime); + query.bindValue(":update_time", formattedDateTime); + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); + } + + return isSuccess; +}