diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index d3d341b..63fcb02 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -831,12 +831,12 @@ return result; } -//核查数据管理-核查结果信息-核查项多功能校准源数据 +//核查数据管理-核查结果信息-核查项多功能校准源数据 待修改2024年3月18日13:05:42 QList BaseCommonApi::getCheckDataManageResultManageMult(QString equipment_id) { QList result; QSqlQuery query; - query.prepare("SELECT bescidc.id , bescidc.check_type ,bescidc.params ,bescidc.unit ,bescidc.frequency ,bescidc.check_point ,besci.check_date ,bescidc.urel ," + query.prepare("SELECT DISTINCT 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 " @@ -1002,7 +1002,7 @@ -//新建检定程序 +//新建检定程序 增加更新时间 2024年3月18日13:28:13 待修改 bool BaseCommonApi::InsertVerificationProgramInfo(VerificationProgramInfo verInfo) { QSqlQuery query; @@ -1049,17 +1049,16 @@ return isSuccess; } -//更新检定程序 +//更新检定程序 更新时间 2024年3月18日13:28:34 增加字段 待修改 bool BaseCommonApi::UpdateVerificationProgramInfo(VerificationProgramInfo verInfo) { QSqlQuery query; query.prepare("UPDATE zd_verification_program_info " " 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 " + "remark = :remark,img_path = :img_path,tested_device_id = :tested_device_id,standard_device_id = :standard_device_id " "WHERE id = :id;"); 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); @@ -1254,5 +1253,167 @@ //核查程序管理-编辑查询单个 CheckProgramManage BaseCommonApi::getCheckProgramManageById(QString id) { - + CheckProgramManage result; + QSqlQuery query; + query.prepare("SELECT id,check_name,create_name,create_time,remark,img_path,standard_device_id,verification_documents_id,update_time " + "FROM zd_verification_program_manage where id = :id "); + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CheckProgramManage programInfo; + programInfo.id = query.value("id").toString(); + programInfo.check_name = query.value("check_name").toString(); + programInfo.create_name = query.value("create_name").toString(); + programInfo.create_time = query.value("create_time").toDateTime(); + programInfo.remark = query.value("remark").toString(); + programInfo.img_path = query.value("img_path").toString(); + programInfo.standard_device_id = query.value("standard_device_id").toString(); + programInfo.verification_documents_id = query.value("verification_documents_id").toString(); + programInfo.update_time = query.value("update_time").toDateTime(); + result = programInfo; + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; } + //核查程序管理-编辑查询 选择设备 选择标准 +QList BaseCommonApi::getCheckDeviceList() +{ + QList result; + QSqlQuery query; + bool isSuccess = query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei "); + if (isSuccess) { + while (query.next()) { + CheckAndTestedDevice device; + device.id = query.value("id").toString(); + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.manufacturer = query.value("manufacturer").toString(); + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} +//核查程序管理-编辑查询 选择设备 选择核查件 为标准和被检的并集 +QList BaseCommonApi::getCheckAndTestedDeviceList() +{ + QList result; + QSqlQuery query; + bool isSuccess = query.exec("SELECT " + " bei.id , bei.equipment_name , bei.model , bei.manufacture_no , bei.manufacturer " + " FROM biz_equipment_info bei UNION ALL SELECT " + " eei.id , eei.equipment_name , eei.model , eei.manufacture_no , eei.manufacturer " + " FROM eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id;"); + if (isSuccess) { + while (query.next()) { + CheckAndTestedDevice device; + device.id = query.value("id").toString(); + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.manufacturer = query.value("manufacturer").toString(); + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + //核查程序管理-核查设置-多功能校准源 参数设备id +QList BaseCommonApi::getVerificationItemsMultiList(QString deviceId) +{ + QList 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" + "from biz_equipment_standard_check_item_data_calibrator bescidc WHERE bescidc.equipment_id = '1692808528303013889' "); + query.bindValue(":deviceId", deviceId); + 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); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +//新增核查程序 +bool BaseCommonApi::InsertCheckProgramManage(CheckProgramManage check) +{ + QSqlQuery query; + query.prepare("INSERT INTO zd_verification_program_manage " + " (id,check_name,create_name,create_time,remark,img_path,standard_device_id,verification_documents_id,update_time) " + " VALUES (:id,:check_name,:create_name,:create_time,:remark,:img_path,:standard_device_id, " + " :verification_documents_id,:update_time)"); + QString formattedDateTime = check.create_time.toString("yyyy-MM-dd HH:mm:ss"); + query.bindValue(":id", check.id); + query.bindValue(":check_name", check.check_name); + query.bindValue(":create_name", check.create_name); + query.bindValue(":create_time", formattedDateTime); + 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); + + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); + } + + return isSuccess; +} + +//更新核查程序 +bool BaseCommonApi::UpdateCheckProgramManage(CheckProgramManage check) +{ + QSqlQuery query; + 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"); + 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(":id", check.id); + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertOrderSampleRelation query failed: " << query.lastError().text(); + } + return isSuccess; +} +//删除核查程序 +bool DeleteCheckProgramManage(QString id) +{ + QSqlQuery query; + query.prepare("DELETE FROM zd_verification_program_manage WHERE id = :id"); + query.bindValue(":id", id); + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertOrderSampleRelation query failed: " << query.lastError().text(); + } + return isSuccess; +} + diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index d3d341b..63fcb02 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -831,12 +831,12 @@ return result; } -//核查数据管理-核查结果信息-核查项多功能校准源数据 +//核查数据管理-核查结果信息-核查项多功能校准源数据 待修改2024年3月18日13:05:42 QList BaseCommonApi::getCheckDataManageResultManageMult(QString equipment_id) { QList result; QSqlQuery query; - query.prepare("SELECT bescidc.id , bescidc.check_type ,bescidc.params ,bescidc.unit ,bescidc.frequency ,bescidc.check_point ,besci.check_date ,bescidc.urel ," + query.prepare("SELECT DISTINCT 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 " @@ -1002,7 +1002,7 @@ -//新建检定程序 +//新建检定程序 增加更新时间 2024年3月18日13:28:13 待修改 bool BaseCommonApi::InsertVerificationProgramInfo(VerificationProgramInfo verInfo) { QSqlQuery query; @@ -1049,17 +1049,16 @@ return isSuccess; } -//更新检定程序 +//更新检定程序 更新时间 2024年3月18日13:28:34 增加字段 待修改 bool BaseCommonApi::UpdateVerificationProgramInfo(VerificationProgramInfo verInfo) { QSqlQuery query; query.prepare("UPDATE zd_verification_program_info " " 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 " + "remark = :remark,img_path = :img_path,tested_device_id = :tested_device_id,standard_device_id = :standard_device_id " "WHERE id = :id;"); 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); @@ -1254,5 +1253,167 @@ //核查程序管理-编辑查询单个 CheckProgramManage BaseCommonApi::getCheckProgramManageById(QString id) { - + CheckProgramManage result; + QSqlQuery query; + query.prepare("SELECT id,check_name,create_name,create_time,remark,img_path,standard_device_id,verification_documents_id,update_time " + "FROM zd_verification_program_manage where id = :id "); + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CheckProgramManage programInfo; + programInfo.id = query.value("id").toString(); + programInfo.check_name = query.value("check_name").toString(); + programInfo.create_name = query.value("create_name").toString(); + programInfo.create_time = query.value("create_time").toDateTime(); + programInfo.remark = query.value("remark").toString(); + programInfo.img_path = query.value("img_path").toString(); + programInfo.standard_device_id = query.value("standard_device_id").toString(); + programInfo.verification_documents_id = query.value("verification_documents_id").toString(); + programInfo.update_time = query.value("update_time").toDateTime(); + result = programInfo; + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; } + //核查程序管理-编辑查询 选择设备 选择标准 +QList BaseCommonApi::getCheckDeviceList() +{ + QList result; + QSqlQuery query; + bool isSuccess = query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei "); + if (isSuccess) { + while (query.next()) { + CheckAndTestedDevice device; + device.id = query.value("id").toString(); + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.manufacturer = query.value("manufacturer").toString(); + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} +//核查程序管理-编辑查询 选择设备 选择核查件 为标准和被检的并集 +QList BaseCommonApi::getCheckAndTestedDeviceList() +{ + QList result; + QSqlQuery query; + bool isSuccess = query.exec("SELECT " + " bei.id , bei.equipment_name , bei.model , bei.manufacture_no , bei.manufacturer " + " FROM biz_equipment_info bei UNION ALL SELECT " + " eei.id , eei.equipment_name , eei.model , eei.manufacture_no , eei.manufacturer " + " FROM eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id;"); + if (isSuccess) { + while (query.next()) { + CheckAndTestedDevice device; + device.id = query.value("id").toString(); + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.manufacturer = query.value("manufacturer").toString(); + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + //核查程序管理-核查设置-多功能校准源 参数设备id +QList BaseCommonApi::getVerificationItemsMultiList(QString deviceId) +{ + QList 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" + "from biz_equipment_standard_check_item_data_calibrator bescidc WHERE bescidc.equipment_id = '1692808528303013889' "); + query.bindValue(":deviceId", deviceId); + 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); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +//新增核查程序 +bool BaseCommonApi::InsertCheckProgramManage(CheckProgramManage check) +{ + QSqlQuery query; + query.prepare("INSERT INTO zd_verification_program_manage " + " (id,check_name,create_name,create_time,remark,img_path,standard_device_id,verification_documents_id,update_time) " + " VALUES (:id,:check_name,:create_name,:create_time,:remark,:img_path,:standard_device_id, " + " :verification_documents_id,:update_time)"); + QString formattedDateTime = check.create_time.toString("yyyy-MM-dd HH:mm:ss"); + query.bindValue(":id", check.id); + query.bindValue(":check_name", check.check_name); + query.bindValue(":create_name", check.create_name); + query.bindValue(":create_time", formattedDateTime); + 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); + + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertTaskBasic query failed: " << query.lastError().text(); + } + + return isSuccess; +} + +//更新核查程序 +bool BaseCommonApi::UpdateCheckProgramManage(CheckProgramManage check) +{ + QSqlQuery query; + 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"); + 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(":id", check.id); + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertOrderSampleRelation query failed: " << query.lastError().text(); + } + return isSuccess; +} +//删除核查程序 +bool DeleteCheckProgramManage(QString id) +{ + QSqlQuery query; + query.prepare("DELETE FROM zd_verification_program_manage WHERE id = :id"); + query.bindValue(":id", id); + bool isSuccess = query.exec(); + if (!isSuccess) { + qDebug() << "InsertOrderSampleRelation query failed: " << query.lastError().text(); + } + return isSuccess; +} + diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.h b/softwareDirectory/AutoVerScheme/basecommonapi.h index 39dbeeb..3a18225 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.h +++ b/softwareDirectory/AutoVerScheme/basecommonapi.h @@ -265,55 +265,55 @@ { public: QString id; -QString sample_name; -QString model; -QString help_instruction; -QString manufacture_no; -QString manufacturer; -QString customer_name; -QString FULL_NAME; -QString NAME; -QDate trace_date; -QDateTime measure_valid_date; -QString meter_identify; -QString restriction_instruction; +QString sample_name;//设备名称 +QString model;//型号规格 +QString help_instruction;//辅助字段 +QString manufacture_no;//出厂编号 +QString manufacturer;//生产厂家 +QString customer_name;//委托单位 +QString FULL_NAME;//使用部门 +QString NAME;//检定员 +QDate trace_date;//检定时间 +QDateTime measure_valid_date;//检定有效期 +QString meter_identify;//计量标识 +QString restriction_instruction;//限用说明 }; //检定数据管理-检定基本信息 class VerificationBasicDataDetails { public: -QString sample_name; -QString model; -QString help_instruction; -QString manufacture_no; -QString manufacturer; -QString customer_name; -QString based_documents; -QDate trace_date; -QString temperature; -QString humidity; -QString measure_address; -QDateTime measure_valid_date; -QString NAME; -QString conclusion; -QString restriction_instruction; +QString sample_name;//设备名称 +QString model;//型号规格 +QString help_instruction;//辅助字段 +QString manufacture_no;//出厂编号 +QString manufacturer;//生产厂家 +QString customer_name;//委托单位 +QString based_documents;//依据技术文件 +QDate trace_date;//检定日期 +QString temperature;//环境温度 +QString humidity;//环境湿度 +QString measure_address;//检定地点 +QDateTime measure_valid_date;//检定有效期 +QString NAME;//检定员 +QString conclusion;//结论 +QString restriction_instruction;//限用说明 }; //检定数据管理-检定结果信息 class VerificationResultData { public: QString id; -QString params; -QString capacity; -QString unit; -QString frequency; -QString range_range; -QString standard_value; -QString resolution; -QString maximum_error; -QString error_param_a; -QString error_param_b; -QString other_outcome; +QString params;//检定项目 即参数 +QString capacity;//量 +QString unit;//单位 +QString frequency;//频率 +QString range_range;//量程 +QString standard_value;//标准值 +QString resolution;//示值 +QString maximum_error;//最大允许误差 +QString error_param_a;//误差参数a +QString error_param_b;//误差参数b +QString other_outcome;//合格率 }; //核查数据管理 首页 @@ -321,57 +321,57 @@ { public: QString id; - QString equipment_name; - QString model; - QString manufacture_no; - QString meter_standard_name; - QString meter_standard_id; - QString create_user_name; - QDate check_date; - QString dept_name; + QString equipment_name;//设备名称 + QString model;//型号规格 + QString manufacture_no;//出厂编号 + QString meter_standard_name;//核查件 + QString meter_standard_id;//核查件编号 + QString create_user_name;//核查员 + QDate check_date;//核查日期 + QString dept_name;//部门 }; //核查数据管理-核查基本信息 class CheckDataManageBasicInfo { public: - QString equipment_name; - QString model; - QString manufacture_no; - QString manufacturer; - QString temperature; - QString humidity; - QDate check_date; - QString check_address; - QString create_user_name; - QString conclusion; + QString equipment_name;//设备名称 + QString model;//型号规格 + QString manufacture_no;//出厂编号 + QString manufacturer;//生产厂家 + QString temperature;//温度 + QString humidity;//湿度 + QDate check_date;//核查日期 + QString check_address;//核查地点 + QString create_user_name;//核查员 + QString conclusion;//结论 }; //核查数据管理-核查结果信息-核查项多功能校准源数据 class CheckDataManageResultManageMult { public: - QString id; - QString check_type; - QString params; - QString unit; - QString frequency; - QString check_point; - QDate check_date; - QString urel; - QString tfer; - QString dccp; - QString flit; + QString id;//序号 + QString check_type;//核查类型 + QString params;//参数 + QString unit;//单位 + QString frequency;//频率 + QString check_point;//核查点 + QDate check_date;//核查日期 + QString urel;//Urel + QString tfer;//tfer + QString dccp;//dccp + QString flit;//flit }; //技术文件 class Technique_File { public: - QString id; - QString file_distribute_no; - QString file_name; - QString version_no; - QDateTime active_date; - QString remark; + QString id;//id + QString file_distribute_no;//文件号 + QString file_name;//文件名 + QString version_no;//版本号 + QDateTime active_date;//颁布时间 + QString remark;//备注 }; //-------------------------- //检定程序管理 @@ -379,10 +379,10 @@ { public: QString id; - QString program_name; - QString create_name; + QString program_name; //程序名称 + QString create_name;//创建人 QDateTime create_time; - QString remark; + QString remark;// 说明 QString img_path; //连接图片地址 QString tested_device_id; //被检设备id QString standard_device_id; //标准设备id @@ -391,7 +391,7 @@ }; -//检定程序管理-检定配置查询 +//检定程序管理-检定配置查询 废弃 //class VerificationProgramConfig //{ //public: @@ -424,13 +424,13 @@ { public: QString id; - QString device_id; - QString device_name; - QString instruct_config; - QString instruct_read; - QString type; - QString belong_vername; - QString belong_checkname; + QString device_id;//设备id + QString device_name;//指令名称 + QString instruct_config;//配置指令 + QString instruct_read;//读数指令 + QString type;//区分被检和标准设备 0 & 1 + QString belong_vername; //检定项名称 + QString belong_checkname; //核查项名称 QDateTime create_time; QDateTime update_time; }; @@ -479,6 +479,33 @@ QString verification_documents_id;//核查件设备id QDateTime update_time;//更新时间 }; +//核查程序管理-编辑查询 选择设备 +class CheckAndTestedDevice +{ +public: + QString id; + QString equipment_name; //设备名称 + QString model;//型号规格 + QString manufacture_no;//出厂编号 + QString manufacturer;//生产厂家 +}; +// 核查项及核查点--多功能校准源 biz_equipment_standard_check_item_data_calibrator +class VerificationItemsMulti +{ +public: + QString id; + QString check_type; //核查类型 + QString unit;// 单位 + QString frequency;//频率 + QString check_point;//核查点 + QString resolution;//分辨力 + QString cycle_number;//循环次数 + QString urel;//urel + QString thoroughfare;//通道 + QString tfer;//tfer + QString dccp;//dccp + QString flit;//flit +}; @@ -584,6 +611,18 @@ static QList getCheckProgramManage(); //核查程序管理-编辑查询单个 static CheckProgramManage getCheckProgramManageById(QString id); + //核查程序管理-编辑查询 选择设备 选择标准 + static QList getCheckDeviceList(); + //核查程序管理-编辑查询 选择设备 选择核查件 为标准和被检的并集 + static QList getCheckAndTestedDeviceList(); + //核查程序管理-核查设置-多功能校准源 参数设备id + static QList getVerificationItemsMultiList(QString deviceId); + //新增核查程序 + static bool InsertCheckProgramManage(CheckProgramManage check); + //更新核查程序 参数核查程序的id + static bool UpdateCheckProgramManage(CheckProgramManage check); + //删除核查程序 参数核查程序的id + static bool DeleteCheckProgramManage(QString id); };