diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 47ee4da..f65fe8b 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -1859,29 +1859,86 @@ saveInfo.data_no=TaskManager::getsaveResultdatano(); QSqlQuery query; - query.prepare("INSERT INTO biz_business_device_measure_info " - " (id,data_no,order_id,sample_id,item_id," - " trace_date,measure_valid_date,measure_address,temperature,humidity,data_source," - " outcome,create_time,update_time) " - " VALUES " - " (" - ":id,:data_no,:order_id,:sample_id,:item_id,:trace_date,:measure_valid_date," - ":measure_address,:temperature,:humidity,:data_source,:outcome,:create_time,:update_time" - ")"); + query.prepare("INSERT INTO biz_business_device_measure_info ( " + " id, data_no, measure_category, order_id, sample_id, sample_name, model, " + " manufacture_no, manufacturer, item_id, trace_date, measure_valid_date, " + " measure_address, temperature, humidity, data_source, ipri, ipri_unit, " + " isec, isec_unit, vpri, vpri_unit, vsec, vsec_unit, appearance_function_check, " + " appearance, appearance_remark, pointer_deflection_stability, " + " pointer_deflection_stability_remark, tightness, tightness_remark," + " insulation_resistance, insulation_resistance_remark, measure_medium," + " division, zero_drift_result, work_line_equation, sealing_test, " + " insulation_resistance_value, angle_adjust_error, actual_division_value," + " actual_division_value_unit, conclusion, restriction_instruction, outcome," + " other_outcome, remark, other_remark, create_user_id, measure_person_id," + " create_user_name, create_time, update_time " + " ) VALUES ( " + " :id, :data_no, :measure_category, :order_id, :sample_id, :sample_name, :model, " + " :manufacture_no, :manufacturer, :item_id, :trace_date, :measure_valid_date, " + " :measure_address, :temperature, :humidity, :data_source, :ipri, :ipri_unit, " + " :isec, :isec_unit, :vpri, :vpri_unit, :vsec, :vsec_unit, :appearance_function_check, " + " :appearance, :appearance_remark, :pointer_deflection_stability, " + " :pointer_deflection_stability_remark, :tightness, :tightness_remark, " + " :insulation_resistance, :insulation_resistance_remark, :measure_medium, " + " :division, :zero_drift_result, :work_line_equation, :sealing_test, " + " :insulation_resistance_value, :angle_adjust_error, :actual_division_value, " + " :actual_division_value_unit, :conclusion, :restriction_instruction, :outcome, " + " :other_outcome, :remark, :other_remark, :create_user_id, :measure_person_id, " + " :create_user_name, :create_time, :update_time);"); QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id", saveInfo.id); //id 自动生成 + query.bindValue(":id", saveInfo.id); query.bindValue(":data_no", saveInfo.data_no); + query.bindValue(":measure_category", saveInfo.measure_category); query.bindValue(":order_id", saveInfo.order_id); query.bindValue(":sample_id", saveInfo.sample_id); + query.bindValue(":sample_name", saveInfo.sample_name); + query.bindValue(":model", saveInfo.model); + query.bindValue(":manufacture_no", saveInfo.manufacture_no); + query.bindValue(":manufacturer", saveInfo.manufacturer); query.bindValue(":item_id", saveInfo.item_id); - query.bindValue(":trace_date", saveInfo.trace_date); - query.bindValue(":measure_valid_date", saveInfo.measure_valid_date); + query.bindValue(":trace_date", saveInfo.trace_date.toString("yyyy-MM-dd")); // 根据数据库实际日期格式转换 + query.bindValue(":measure_valid_date", saveInfo.measure_valid_date.toString("yyyy-MM-dd")); query.bindValue(":measure_address", saveInfo.measure_address); query.bindValue(":temperature", saveInfo.temperature); query.bindValue(":humidity", saveInfo.humidity); query.bindValue(":data_source", saveInfo.data_source); + query.bindValue(":ipri", saveInfo.ipri); + query.bindValue(":ipri_unit", saveInfo.ipri_unit); + query.bindValue(":isec", saveInfo.isec); + query.bindValue(":isec_unit", saveInfo.isec_unit); + query.bindValue(":vpri", saveInfo.vpri); + query.bindValue(":vpri_unit", saveInfo.vpri_unit); + query.bindValue(":vsec", saveInfo.vsec); + query.bindValue(":vsec_unit", saveInfo.vsec_unit); + query.bindValue(":appearance_function_check", saveInfo.appearance_function_check); + query.bindValue(":appearance", saveInfo.appearance); + query.bindValue(":appearance_remark", saveInfo.appearance_remark); + query.bindValue(":pointer_deflection_stability", saveInfo.pointer_deflection_stability); + query.bindValue(":pointer_deflection_stability_remark", saveInfo.pointer_deflection_stability_remark); + query.bindValue(":tightness", saveInfo.tightness); + query.bindValue(":tightness_remark", saveInfo.tightness_remark); + query.bindValue(":insulation_resistance", saveInfo.insulation_resistance); + query.bindValue(":insulation_resistance_remark", saveInfo.insulation_resistance_remark); + query.bindValue(":measure_medium", saveInfo.measure_medium); + query.bindValue(":division", saveInfo.division); + query.bindValue(":zero_drift_result", saveInfo.zero_drift_result); + query.bindValue(":work_line_equation", saveInfo.work_line_equation); + query.bindValue(":sealing_test", saveInfo.sealing_test); + query.bindValue(":insulation_resistance_value", saveInfo.insulation_resistance_value); + query.bindValue(":angle_adjust_error", saveInfo.angle_adjust_error); + query.bindValue(":actual_division_value", saveInfo.actual_division_value); + query.bindValue(":actual_division_value_unit", saveInfo.actual_division_value_unit); + query.bindValue(":conclusion", saveInfo.conclusion); + query.bindValue(":restriction_instruction", saveInfo.restriction_instruction); query.bindValue(":outcome", saveInfo.outcome); + query.bindValue(":other_outcome", saveInfo.other_outcome); + query.bindValue(":remark", saveInfo.remark); + query.bindValue(":other_remark", saveInfo.other_remark); + query.bindValue(":create_user_id", saveInfo.create_user_id); + query.bindValue(":measure_person_id", saveInfo.measure_person_id); + query.bindValue(":create_user_name", saveInfo.create_user_name); query.bindValue(":create_time", currentDateTime); query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); @@ -1942,7 +1999,7 @@ 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(":indicating_value",measureCalibrator.measure_indication_value); // 暂时改为被检表示值2024年3月27日09:43:27 待修改 query.bindValue(":maximum_error",measureCalibrator.maximum_error); query.bindValue(":absolute_error",measureCalibrator.absolute_error); query.bindValue(":resolution",measureCalibrator.resolution); @@ -1960,6 +2017,7 @@ query.bindValue(":create_time",currentDateTime); query.bindValue(":update_time",currentDateTime); bool isSuccess = query.exec(); + qDebug()<<"保存的示值为:"<