diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index a3621d6..874b354 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -57,8 +57,10 @@ info.create_time = query.value("create_time").toDateTime(); info.update_time = query.value("update_time").toDateTime(); result=info; + } - }else { +// qDebug() << "sql代码: " << query.lastQuery(); + }else { qDebug() << "Query execution failed: " << query.lastError().text(); } @@ -122,6 +124,7 @@ " ORDER BY blei.update_time DESC"); // 将参数绑定到占位符 query.bindValue(":deptId", deptId); + if (query.exec()) { while (query.next()) { Dept Dept; @@ -1114,7 +1117,7 @@ result.append( query.value("error_param_b").toString()); result.append(query.value("other_outcome").toString()); - resultData.append(result); + resultData.append(result); } } else { qDebug() << "Query execution failed: " << query.lastError().text(); @@ -1476,9 +1479,9 @@ "standard_device_id = :standard_device_id ," "update_time = :update_time " " WHERE id = :id;"); - QString formattedDateTime = verInfo.create_time.toString("yyyy-MM-dd HH:mm:ss"); - QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); - query.bindValue(":update_time",currentDateTime); + QString formattedDateTime = verInfo.create_time.toString("yyyy-MM-dd HH:mm:ss"); + 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", formattedDateTime); @@ -1615,7 +1618,7 @@ " 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)"); - + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id", saveInfo.id); //id 自动生成 query.bindValue(":data_no", saveInfo.data_no); query.bindValue(":order_id", saveInfo.order_id); @@ -1628,8 +1631,8 @@ query.bindValue(":humidity", saveInfo.humidity); query.bindValue(":data_source", saveInfo.data_source); query.bindValue(":outcome", saveInfo.outcome); - query.bindValue(":create_time", saveInfo.create_time); - query.bindValue(":update_time", saveInfo.update_time); + query.bindValue(":create_time", currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -1645,12 +1648,13 @@ " (id,data_id,equipment_id,create_time,update_time) " " VALUES " " (:id,:data_id,:equipment_id,:create_time,:update_time)"); - QString createTime = deviceMeasure.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); +// QString createTime = deviceMeasure.create_time.toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id", deviceMeasure.id); query.bindValue(":data_id", deviceMeasure.data_id); query.bindValue(":equipment_id", deviceMeasure.equipment_id); - query.bindValue(":create_time", createTime); - query.bindValue(":update_time", createTime); + query.bindValue(":create_time", currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -1670,8 +1674,8 @@ " 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.create_time.toString("yyyy-MM-dd HH:mm:ss"); - +// QString formattedUpdateDateTime = measureCalibrator.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().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); @@ -1700,8 +1704,8 @@ 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); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time",currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertOrderSampleRelation query failed: " << query.lastError().text(); @@ -1879,14 +1883,14 @@ query.prepare("UPDATE zd_verification_program_manage SET check_name =:check_name," " create_name = :create_name, remark = :remark, img_path =:img_path, standard_device_id =:standard_device_id," " verification_documents_id=:verification_documents_id, update_time=:update_time WHERE id = :id;"); - QString formattedDateTime = check.update_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":check_name", check.check_name); query.bindValue(":create_name", check.create_name); query.bindValue(":remark", check.remark); query.bindValue(":img_path", check.img_path); query.bindValue(":standard_device_id", check.standard_device_id); query.bindValue(":verification_documents_id", check.verification_documents_id); - query.bindValue(":update_time",formattedDateTime); + query.bindValue(":update_time",currentDateTime); query.bindValue(":id", check.id); bool isSuccess = query.exec(); if (!isSuccess) { @@ -1943,7 +1947,7 @@ "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"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id",gauge.id); query.bindValue(":data_id",gauge.data_id); query.bindValue(":unit",gauge.unit); @@ -1972,8 +1976,8 @@ 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); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time",currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -1993,7 +1997,7 @@ " (: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"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id",baseInfo.id); query.bindValue(":data_no",baseInfo.data_no); query.bindValue(":check_date",checkData); @@ -2009,8 +2013,8 @@ 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); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time",currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -2102,8 +2106,8 @@ " VALUES " " (:id,:check_equipment_id,:data_id)"); query.bindValue(":id",equiment.id); - query.bindValue(":data_no",equiment.check_equipment_id); - query.bindValue(":check_date",equiment.data_id); + query.bindValue(":check_equipment_id",equiment.check_equipment_id); + query.bindValue(":data_id",equiment.data_id); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -2130,7 +2134,7 @@ ":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"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); // 绑定所有值 query.bindValue(":id", calibrator.id); query.bindValue(":data_id", calibrator.data_id); @@ -2159,8 +2163,8 @@ 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); + query.bindValue(":create_time", currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -2213,7 +2217,7 @@ query.prepare("INSERT INTO biz_business_device_measure_modify_record " " (id, data_id,source_system, modify_content, create_user_id, create_user_name, create_time,update_time ) " " VALUES (:id, :data_id, :source_system, :modify_content, :create_user_id, :create_user_name, :create_time, :update_time )"); - QString formattedDateTime = record.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); // 绑定所有值 query.bindValue(":id", record.id); query.bindValue(":data_id", record.data_id); @@ -2221,8 +2225,8 @@ query.bindValue(":modify_content", record.modify_content); query.bindValue(":create_user_id", record.create_user_id); query.bindValue(":create_user_name", record.create_user_name); - query.bindValue(":create_time",formattedDateTime); - query.bindValue(":update_time", formattedDateTime); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "Insert query failed: " << query.lastError().text(); @@ -2262,7 +2266,7 @@ query.prepare("INSERT INTO biz_equipment_standard_check_modify_record " " (id, data_id,source_system, modify_content, create_user_id, create_user_name, create_time,update_time ) " " VALUES (:id, :data_id, :source_system, :modify_content, :create_user_id, :create_user_name, :create_time, :update_time )"); - QString formattedDateTime = record.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); // 绑定所有值 query.bindValue(":id", record.id); query.bindValue(":data_id", record.data_id); @@ -2270,8 +2274,8 @@ query.bindValue(":modify_content", record.modify_content); query.bindValue(":create_user_id", record.create_user_id); query.bindValue(":create_user_name", record.create_user_name); - query.bindValue(":create_time",formattedDateTime); - query.bindValue(":update_time", formattedDateTime); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "Insert query failed: " << query.lastError().text(); diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index a3621d6..874b354 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -57,8 +57,10 @@ info.create_time = query.value("create_time").toDateTime(); info.update_time = query.value("update_time").toDateTime(); result=info; + } - }else { +// qDebug() << "sql代码: " << query.lastQuery(); + }else { qDebug() << "Query execution failed: " << query.lastError().text(); } @@ -122,6 +124,7 @@ " ORDER BY blei.update_time DESC"); // 将参数绑定到占位符 query.bindValue(":deptId", deptId); + if (query.exec()) { while (query.next()) { Dept Dept; @@ -1114,7 +1117,7 @@ result.append( query.value("error_param_b").toString()); result.append(query.value("other_outcome").toString()); - resultData.append(result); + resultData.append(result); } } else { qDebug() << "Query execution failed: " << query.lastError().text(); @@ -1476,9 +1479,9 @@ "standard_device_id = :standard_device_id ," "update_time = :update_time " " WHERE id = :id;"); - QString formattedDateTime = verInfo.create_time.toString("yyyy-MM-dd HH:mm:ss"); - QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); - query.bindValue(":update_time",currentDateTime); + QString formattedDateTime = verInfo.create_time.toString("yyyy-MM-dd HH:mm:ss"); + 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", formattedDateTime); @@ -1615,7 +1618,7 @@ " 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)"); - + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id", saveInfo.id); //id 自动生成 query.bindValue(":data_no", saveInfo.data_no); query.bindValue(":order_id", saveInfo.order_id); @@ -1628,8 +1631,8 @@ query.bindValue(":humidity", saveInfo.humidity); query.bindValue(":data_source", saveInfo.data_source); query.bindValue(":outcome", saveInfo.outcome); - query.bindValue(":create_time", saveInfo.create_time); - query.bindValue(":update_time", saveInfo.update_time); + query.bindValue(":create_time", currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -1645,12 +1648,13 @@ " (id,data_id,equipment_id,create_time,update_time) " " VALUES " " (:id,:data_id,:equipment_id,:create_time,:update_time)"); - QString createTime = deviceMeasure.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); +// QString createTime = deviceMeasure.create_time.toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id", deviceMeasure.id); query.bindValue(":data_id", deviceMeasure.data_id); query.bindValue(":equipment_id", deviceMeasure.equipment_id); - query.bindValue(":create_time", createTime); - query.bindValue(":update_time", createTime); + query.bindValue(":create_time", currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -1670,8 +1674,8 @@ " 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.create_time.toString("yyyy-MM-dd HH:mm:ss"); - +// QString formattedUpdateDateTime = measureCalibrator.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().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); @@ -1700,8 +1704,8 @@ 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); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time",currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertOrderSampleRelation query failed: " << query.lastError().text(); @@ -1879,14 +1883,14 @@ query.prepare("UPDATE zd_verification_program_manage SET check_name =:check_name," " create_name = :create_name, remark = :remark, img_path =:img_path, standard_device_id =:standard_device_id," " verification_documents_id=:verification_documents_id, update_time=:update_time WHERE id = :id;"); - QString formattedDateTime = check.update_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":check_name", check.check_name); query.bindValue(":create_name", check.create_name); query.bindValue(":remark", check.remark); query.bindValue(":img_path", check.img_path); query.bindValue(":standard_device_id", check.standard_device_id); query.bindValue(":verification_documents_id", check.verification_documents_id); - query.bindValue(":update_time",formattedDateTime); + query.bindValue(":update_time",currentDateTime); query.bindValue(":id", check.id); bool isSuccess = query.exec(); if (!isSuccess) { @@ -1943,7 +1947,7 @@ "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"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id",gauge.id); query.bindValue(":data_id",gauge.data_id); query.bindValue(":unit",gauge.unit); @@ -1972,8 +1976,8 @@ 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); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time",currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -1993,7 +1997,7 @@ " (: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"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":id",baseInfo.id); query.bindValue(":data_no",baseInfo.data_no); query.bindValue(":check_date",checkData); @@ -2009,8 +2013,8 @@ 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); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time",currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -2102,8 +2106,8 @@ " VALUES " " (:id,:check_equipment_id,:data_id)"); query.bindValue(":id",equiment.id); - query.bindValue(":data_no",equiment.check_equipment_id); - query.bindValue(":check_date",equiment.data_id); + query.bindValue(":check_equipment_id",equiment.check_equipment_id); + query.bindValue(":data_id",equiment.data_id); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -2130,7 +2134,7 @@ ":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"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); // 绑定所有值 query.bindValue(":id", calibrator.id); query.bindValue(":data_id", calibrator.data_id); @@ -2159,8 +2163,8 @@ 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); + query.bindValue(":create_time", currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); @@ -2213,7 +2217,7 @@ query.prepare("INSERT INTO biz_business_device_measure_modify_record " " (id, data_id,source_system, modify_content, create_user_id, create_user_name, create_time,update_time ) " " VALUES (:id, :data_id, :source_system, :modify_content, :create_user_id, :create_user_name, :create_time, :update_time )"); - QString formattedDateTime = record.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); // 绑定所有值 query.bindValue(":id", record.id); query.bindValue(":data_id", record.data_id); @@ -2221,8 +2225,8 @@ query.bindValue(":modify_content", record.modify_content); query.bindValue(":create_user_id", record.create_user_id); query.bindValue(":create_user_name", record.create_user_name); - query.bindValue(":create_time",formattedDateTime); - query.bindValue(":update_time", formattedDateTime); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "Insert query failed: " << query.lastError().text(); @@ -2262,7 +2266,7 @@ query.prepare("INSERT INTO biz_equipment_standard_check_modify_record " " (id, data_id,source_system, modify_content, create_user_id, create_user_name, create_time,update_time ) " " VALUES (:id, :data_id, :source_system, :modify_content, :create_user_id, :create_user_name, :create_time, :update_time )"); - QString formattedDateTime = record.create_time.toString("yyyy-MM-dd HH:mm:ss"); + QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); // 绑定所有值 query.bindValue(":id", record.id); query.bindValue(":data_id", record.data_id); @@ -2270,8 +2274,8 @@ query.bindValue(":modify_content", record.modify_content); query.bindValue(":create_user_id", record.create_user_id); query.bindValue(":create_user_name", record.create_user_name); - query.bindValue(":create_time",formattedDateTime); - query.bindValue(":update_time", formattedDateTime); + query.bindValue(":create_time",currentDateTime); + query.bindValue(":update_time", currentDateTime); bool isSuccess = query.exec(); if (!isSuccess) { qDebug() << "Insert query failed: " << query.lastError().text(); diff --git a/softwareDirectory/AutoVerScheme/databaseconnection.cpp b/softwareDirectory/AutoVerScheme/databaseconnection.cpp index 2adadd4..1d957d9 100644 --- a/softwareDirectory/AutoVerScheme/databaseconnection.cpp +++ b/softwareDirectory/AutoVerScheme/databaseconnection.cpp @@ -1,6 +1,8 @@ #include "databaseconnection.h" + + DatabaseConnection* DatabaseConnection::Connect = nullptr; QMutex DatabaseConnection::mutex;