diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 6593d87..d9e4b28 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -15,6 +15,7 @@ const QString BaseCommonApi::measure_person_id="1695282436182188034"; static SyncRunStatus syncstate=SyncRunStatus::Stopped; +static QString loginUserId = nullptr; //sys_user表的id转换为measure_person_id 检定人id(meter_staff表id) StaffInfo BaseCommonApi::ConvertStaffInfo(QString userId) @@ -105,18 +106,19 @@ return outStr.trimmed(); } -bool BaseCommonApi::SysUserLogin(QString account,QString password){ +bool BaseCommonApi::SysUserLogin(QString account,QString password=nullptr){ QSqlQuery query; query.prepare("SELECT * FROM sys_user " - " WHERE ACCOUNT = :ACCOUNT AND PASSWORD = :PASSWORD "); + " WHERE ACCOUNT = :ACCOUNT "); query.bindValue(":ACCOUNT",account); - query.bindValue(":PASSWORD",password); +// query.bindValue(":PASSWORD",password); bool isSuccess = query.exec(); if(!isSuccess){ qDebug()<id +"'") - .arg("'" + deviceMeasureEquipment->data_id +"'") - .arg("'" + deviceMeasureEquipment->equipment_id +"'") + .arg(deviceMeasureEquipment->id) + .arg(deviceMeasureEquipment->data_id) + .arg(deviceMeasureEquipment->equipment_id) + .arg(deviceMeasureEquipment->standard_id) + .arg("'" + deviceMeasureEquipment->standard_name +"'") .arg("'" + currentDateTime + "'") .arg("'" + currentDateTime + "'"); } @@ -2657,8 +2667,10 @@ .arg("'" +deviceMeasureCalibrator->maximum_error+"'") .arg("'" +deviceMeasureCalibrator->absolute_error+"'") .arg("'" +deviceMeasureCalibrator->resolution+"'") - .arg("'" +deviceMeasureCalibrator->line_mode+"'") - .arg("'" +deviceMeasureCalibrator->remark+"'").arg("'" +deviceMeasureCalibrator->an+"'").arg("'" +deviceMeasureCalibrator->bn+"'") + .arg("'" +deviceMeasureCalibrator->line_mode == "" ? "/":deviceMeasureCalibrator->line_mode +"'") + .arg("'" +deviceMeasureCalibrator->remark+"'") + .arg("'" +deviceMeasureCalibrator->an+"'") + .arg("'" +deviceMeasureCalibrator->bn+"'") .arg("'" +deviceMeasureCalibrator->cn+"'") .arg("'" +deviceMeasureCalibrator->delta_an+"'") .arg("'" +deviceMeasureCalibrator->delta_bn+"'") .arg("'" +deviceMeasureCalibrator->delta_cn+"'") .arg("'" +deviceMeasureCalibrator->measure_indication_value+"'") .arg("'" +deviceMeasureCalibrator->standard_value_upper_limit+"'") .arg("'" +deviceMeasureCalibrator->accuracy_level+"'").arg("'" +currentDateTime+"'").arg("'" +currentDateTime+"'"); @@ -7371,12 +7383,6 @@ result.insert(row[5],resultMap); } } - - -// result.insert("DCI",resultMap); -// result.insert("ACI",resultMap); -// result.insert("R",resultMap); -// result.insert("DCV",resultMap); return result; } //【保存】核查数据-多功能校准源 diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 6593d87..d9e4b28 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -15,6 +15,7 @@ const QString BaseCommonApi::measure_person_id="1695282436182188034"; static SyncRunStatus syncstate=SyncRunStatus::Stopped; +static QString loginUserId = nullptr; //sys_user表的id转换为measure_person_id 检定人id(meter_staff表id) StaffInfo BaseCommonApi::ConvertStaffInfo(QString userId) @@ -105,18 +106,19 @@ return outStr.trimmed(); } -bool BaseCommonApi::SysUserLogin(QString account,QString password){ +bool BaseCommonApi::SysUserLogin(QString account,QString password=nullptr){ QSqlQuery query; query.prepare("SELECT * FROM sys_user " - " WHERE ACCOUNT = :ACCOUNT AND PASSWORD = :PASSWORD "); + " WHERE ACCOUNT = :ACCOUNT "); query.bindValue(":ACCOUNT",account); - query.bindValue(":PASSWORD",password); +// query.bindValue(":PASSWORD",password); bool isSuccess = query.exec(); if(!isSuccess){ qDebug()<id +"'") - .arg("'" + deviceMeasureEquipment->data_id +"'") - .arg("'" + deviceMeasureEquipment->equipment_id +"'") + .arg(deviceMeasureEquipment->id) + .arg(deviceMeasureEquipment->data_id) + .arg(deviceMeasureEquipment->equipment_id) + .arg(deviceMeasureEquipment->standard_id) + .arg("'" + deviceMeasureEquipment->standard_name +"'") .arg("'" + currentDateTime + "'") .arg("'" + currentDateTime + "'"); } @@ -2657,8 +2667,10 @@ .arg("'" +deviceMeasureCalibrator->maximum_error+"'") .arg("'" +deviceMeasureCalibrator->absolute_error+"'") .arg("'" +deviceMeasureCalibrator->resolution+"'") - .arg("'" +deviceMeasureCalibrator->line_mode+"'") - .arg("'" +deviceMeasureCalibrator->remark+"'").arg("'" +deviceMeasureCalibrator->an+"'").arg("'" +deviceMeasureCalibrator->bn+"'") + .arg("'" +deviceMeasureCalibrator->line_mode == "" ? "/":deviceMeasureCalibrator->line_mode +"'") + .arg("'" +deviceMeasureCalibrator->remark+"'") + .arg("'" +deviceMeasureCalibrator->an+"'") + .arg("'" +deviceMeasureCalibrator->bn+"'") .arg("'" +deviceMeasureCalibrator->cn+"'") .arg("'" +deviceMeasureCalibrator->delta_an+"'") .arg("'" +deviceMeasureCalibrator->delta_bn+"'") .arg("'" +deviceMeasureCalibrator->delta_cn+"'") .arg("'" +deviceMeasureCalibrator->measure_indication_value+"'") .arg("'" +deviceMeasureCalibrator->standard_value_upper_limit+"'") .arg("'" +deviceMeasureCalibrator->accuracy_level+"'").arg("'" +currentDateTime+"'").arg("'" +currentDateTime+"'"); @@ -7371,12 +7383,6 @@ result.insert(row[5],resultMap); } } - - -// result.insert("DCI",resultMap); -// result.insert("ACI",resultMap); -// result.insert("R",resultMap); -// result.insert("DCV",resultMap); return result; } //【保存】核查数据-多功能校准源 diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.h b/softwareDirectory/AutoVerScheme/basecommonapi.h index f4dffc8..d8a1f30 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.h +++ b/softwareDirectory/AutoVerScheme/basecommonapi.h @@ -35,6 +35,7 @@ QDateTime require_over_time; QString is_urgent; QString measure_status; + QString create_user_id; }; //我的任务 @@ -501,6 +502,8 @@ QString equipment_name;//设备名称 可为空 QString model;//型号规格 可为空 QString help_instruction;//辅助字段 可为空 + QString biz_standard_name;//标准器的装置名称按,分割 + QString biz_standard_id;//标准器的装置id按,分割 }; @@ -869,6 +872,8 @@ QString id; QString data_id;//检定数据管理基础信息表id QString equipment_id;//设备台账id + QString standard_id;//标准装置id + QString standard_name;//标准装置名称 QDateTime create_time; QDateTime update_time; };