diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.h b/softwareDirectory/AutoVerScheme/my_tasks_serve.h new file mode 100644 index 0000000..4cf2f9d --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.h @@ -0,0 +1,33 @@ +#ifndef MYTASKS_H +#define MYTASKS_H +#include +#include +#include +#include "QList" +//我的任务 +class MyTask +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString require_over_time; + QString is_urgent; +}; + + + +class MyTasks +{ +public: + MyTasks(); + QList getMyTasks(QString id); + +}; + +#endif // MYTASKS_H diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.h b/softwareDirectory/AutoVerScheme/my_tasks_serve.h new file mode 100644 index 0000000..4cf2f9d --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.h @@ -0,0 +1,33 @@ +#ifndef MYTASKS_H +#define MYTASKS_H +#include +#include +#include +#include "QList" +//我的任务 +class MyTask +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString require_over_time; + QString is_urgent; +}; + + + +class MyTasks +{ +public: + MyTasks(); + QList getMyTasks(QString id); + +}; + +#endif // MYTASKS_H diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.cpp b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp new file mode 100644 index 0000000..aef57f1 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp @@ -0,0 +1,31 @@ +#include "technique_file_serve.h" + +Technique_File_Serve::Technique_File_Serve() +{ + +} +QList Technique_File_Serve::getTechnique_File() +{ + QList result; + QSqlQuery query; + query.exec("SELECT brtf.file_distribute_no ,brtf.file_name ,brtf.version_no ,brtf.active_date ,brtf.remark " + " FROM biz_resource_technique_file brtf"); + + if (query.exec()) { + while (query.next()) { + Technique_File file; + file.file_distribute_no = query.value("file_distribute_no").toString(); + file.file_name = query.value("file_name").toString(); + file.version_no = query.value("version_no").toString(); + file.active_date = query.value("active_date").toString(); + file.remark = query.value("remark").toString(); + + result.append(file); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; + +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.h b/softwareDirectory/AutoVerScheme/my_tasks_serve.h new file mode 100644 index 0000000..4cf2f9d --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.h @@ -0,0 +1,33 @@ +#ifndef MYTASKS_H +#define MYTASKS_H +#include +#include +#include +#include "QList" +//我的任务 +class MyTask +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString require_over_time; + QString is_urgent; +}; + + + +class MyTasks +{ +public: + MyTasks(); + QList getMyTasks(QString id); + +}; + +#endif // MYTASKS_H diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.cpp b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp new file mode 100644 index 0000000..aef57f1 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp @@ -0,0 +1,31 @@ +#include "technique_file_serve.h" + +Technique_File_Serve::Technique_File_Serve() +{ + +} +QList Technique_File_Serve::getTechnique_File() +{ + QList result; + QSqlQuery query; + query.exec("SELECT brtf.file_distribute_no ,brtf.file_name ,brtf.version_no ,brtf.active_date ,brtf.remark " + " FROM biz_resource_technique_file brtf"); + + if (query.exec()) { + while (query.next()) { + Technique_File file; + file.file_distribute_no = query.value("file_distribute_no").toString(); + file.file_name = query.value("file_name").toString(); + file.version_no = query.value("version_no").toString(); + file.active_date = query.value("active_date").toString(); + file.remark = query.value("remark").toString(); + + result.append(file); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; + +} diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.h b/softwareDirectory/AutoVerScheme/technique_file_serve.h new file mode 100644 index 0000000..181b69c --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.h @@ -0,0 +1,26 @@ +#ifndef TECHNIQUE_FILE_SERVE_H +#define TECHNIQUE_FILE_SERVE_H +#include +#include +#include +#include "QList" + +//技术文件 +class Technique_File +{ +public: + QString file_distribute_no; + QString file_name; + QString version_no; + QString active_date; + QString remark; +}; + +class Technique_File_Serve +{ +public: + Technique_File_Serve(); + QList getTechnique_File(); +}; + +#endif // TECHNIQUE_FILE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.h b/softwareDirectory/AutoVerScheme/my_tasks_serve.h new file mode 100644 index 0000000..4cf2f9d --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.h @@ -0,0 +1,33 @@ +#ifndef MYTASKS_H +#define MYTASKS_H +#include +#include +#include +#include "QList" +//我的任务 +class MyTask +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString require_over_time; + QString is_urgent; +}; + + + +class MyTasks +{ +public: + MyTasks(); + QList getMyTasks(QString id); + +}; + +#endif // MYTASKS_H diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.cpp b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp new file mode 100644 index 0000000..aef57f1 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp @@ -0,0 +1,31 @@ +#include "technique_file_serve.h" + +Technique_File_Serve::Technique_File_Serve() +{ + +} +QList Technique_File_Serve::getTechnique_File() +{ + QList result; + QSqlQuery query; + query.exec("SELECT brtf.file_distribute_no ,brtf.file_name ,brtf.version_no ,brtf.active_date ,brtf.remark " + " FROM biz_resource_technique_file brtf"); + + if (query.exec()) { + while (query.next()) { + Technique_File file; + file.file_distribute_no = query.value("file_distribute_no").toString(); + file.file_name = query.value("file_name").toString(); + file.version_no = query.value("version_no").toString(); + file.active_date = query.value("active_date").toString(); + file.remark = query.value("remark").toString(); + + result.append(file); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; + +} diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.h b/softwareDirectory/AutoVerScheme/technique_file_serve.h new file mode 100644 index 0000000..181b69c --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.h @@ -0,0 +1,26 @@ +#ifndef TECHNIQUE_FILE_SERVE_H +#define TECHNIQUE_FILE_SERVE_H +#include +#include +#include +#include "QList" + +//技术文件 +class Technique_File +{ +public: + QString file_distribute_no; + QString file_name; + QString version_no; + QString active_date; + QString remark; +}; + +class Technique_File_Serve +{ +public: + Technique_File_Serve(); + QList getTechnique_File(); +}; + +#endif // TECHNIQUE_FILE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp new file mode 100644 index 0000000..ed5cade --- /dev/null +++ b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp @@ -0,0 +1,137 @@ +#include "tested_device_manage_serve.h" +#include +#include +#include +#include "QList" + +TestedDeviceManage::TestedDeviceManage() +{ + +} + // 被检设备管理 +QList TestedDeviceManage::getTestedDevice() +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + if (query.exec()) { + while (query.next()) { + TestedDevice testedDevice; + testedDevice.id = query.value("id").toString(); + testedDevice.equipment_name = query.value("equipment_name").toString(); + testedDevice.model = query.value("model").toString(); + testedDevice.help_instruction = query.value("help_instruction").toString(); + testedDevice.manufacture_no = query.value("manufacture_no").toString(); + testedDevice.manufacturer = query.value("manufacturer").toString(); + testedDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedDevice.meter_identify = query.value("meter_identify").toString(); + testedDevice.check_cycle = query.value("check_cycle").toString(); + testedDevice.certificate_valid = query.value("certificate_valid").toString(); + + result.append(testedDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + // 被检设备管理查看设备信息 +QList TestedDeviceManage::getTestedCatDevice(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + TestedCatDevice testedCatDevice; + testedCatDevice.equipment_name = query.value("equipment_name").toString(); + testedCatDevice.model = query.value("model").toString(); + testedCatDevice.help_instruction = query.value("help_instruction").toString(); + testedCatDevice.manufacture_no = query.value("manufacture_no").toString(); + testedCatDevice.product_country = query.value("product_country").toString(); + testedCatDevice.manufacturer = query.value("manufacturer").toString(); + testedCatDevice.product_date = query.value("product_date").toString(); + testedCatDevice.purchase_date = query.value("purchase_date").toString(); + testedCatDevice.unit_price = query.value("unit_price").toString(); + testedCatDevice.usage_status = query.value("usage_status").toString(); + testedCatDevice.quality_condition = query.value("quality_condition").toString(); + testedCatDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedCatDevice.category = query.value("category").toString(); + testedCatDevice.check_cycle = query.value("check_cycle").toString(); + testedCatDevice.level = query.value("level").toString(); + testedCatDevice.remark = query.value("remark").toString(); + + result.append(testedCatDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} +//判断 哪个 装置表 +QList TestedDeviceManage::getJudgeCalibrationTable(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT item_category_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 "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + JudgeCalibrationTable calibration; + calibration.item_category_id = query.value("item_category_id").toString(); + calibration.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + //被检设备管理-检定项目及检定点-多功能校准源 +QList TestedDeviceManage::getVerMultiCal(QString itemId) +{ + QList result; + QSqlQuery query; + query.exec("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.bindValue(":itemId", itemId); + + if (query.exec()) { + while (query.next()) { + VerMultiCal calibration; + calibration.id = query.value("id").toString(); + calibration.params = query.value("params").toString(); + calibration.capacity = query.value("capacity").toString(); + calibration.unit = query.value("unit").toString(); + calibration.frequency = query.value("frequency").toString(); + calibration.range_range = query.value("range_range").toString(); + calibration.standard_value = query.value("standard_value").toString(); + calibration.resolution = query.value("resolution").toString(); + calibration.maximum_error = query.value("maximum_error").toString(); + calibration.error_param_a = query.value("error_param_a").toString(); + calibration.error_param_b = query.value("error_param_b").toString(); + + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.h b/softwareDirectory/AutoVerScheme/my_tasks_serve.h new file mode 100644 index 0000000..4cf2f9d --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.h @@ -0,0 +1,33 @@ +#ifndef MYTASKS_H +#define MYTASKS_H +#include +#include +#include +#include "QList" +//我的任务 +class MyTask +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString require_over_time; + QString is_urgent; +}; + + + +class MyTasks +{ +public: + MyTasks(); + QList getMyTasks(QString id); + +}; + +#endif // MYTASKS_H diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.cpp b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp new file mode 100644 index 0000000..aef57f1 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp @@ -0,0 +1,31 @@ +#include "technique_file_serve.h" + +Technique_File_Serve::Technique_File_Serve() +{ + +} +QList Technique_File_Serve::getTechnique_File() +{ + QList result; + QSqlQuery query; + query.exec("SELECT brtf.file_distribute_no ,brtf.file_name ,brtf.version_no ,brtf.active_date ,brtf.remark " + " FROM biz_resource_technique_file brtf"); + + if (query.exec()) { + while (query.next()) { + Technique_File file; + file.file_distribute_no = query.value("file_distribute_no").toString(); + file.file_name = query.value("file_name").toString(); + file.version_no = query.value("version_no").toString(); + file.active_date = query.value("active_date").toString(); + file.remark = query.value("remark").toString(); + + result.append(file); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; + +} diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.h b/softwareDirectory/AutoVerScheme/technique_file_serve.h new file mode 100644 index 0000000..181b69c --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.h @@ -0,0 +1,26 @@ +#ifndef TECHNIQUE_FILE_SERVE_H +#define TECHNIQUE_FILE_SERVE_H +#include +#include +#include +#include "QList" + +//技术文件 +class Technique_File +{ +public: + QString file_distribute_no; + QString file_name; + QString version_no; + QString active_date; + QString remark; +}; + +class Technique_File_Serve +{ +public: + Technique_File_Serve(); + QList getTechnique_File(); +}; + +#endif // TECHNIQUE_FILE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp new file mode 100644 index 0000000..ed5cade --- /dev/null +++ b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp @@ -0,0 +1,137 @@ +#include "tested_device_manage_serve.h" +#include +#include +#include +#include "QList" + +TestedDeviceManage::TestedDeviceManage() +{ + +} + // 被检设备管理 +QList TestedDeviceManage::getTestedDevice() +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + if (query.exec()) { + while (query.next()) { + TestedDevice testedDevice; + testedDevice.id = query.value("id").toString(); + testedDevice.equipment_name = query.value("equipment_name").toString(); + testedDevice.model = query.value("model").toString(); + testedDevice.help_instruction = query.value("help_instruction").toString(); + testedDevice.manufacture_no = query.value("manufacture_no").toString(); + testedDevice.manufacturer = query.value("manufacturer").toString(); + testedDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedDevice.meter_identify = query.value("meter_identify").toString(); + testedDevice.check_cycle = query.value("check_cycle").toString(); + testedDevice.certificate_valid = query.value("certificate_valid").toString(); + + result.append(testedDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + // 被检设备管理查看设备信息 +QList TestedDeviceManage::getTestedCatDevice(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + TestedCatDevice testedCatDevice; + testedCatDevice.equipment_name = query.value("equipment_name").toString(); + testedCatDevice.model = query.value("model").toString(); + testedCatDevice.help_instruction = query.value("help_instruction").toString(); + testedCatDevice.manufacture_no = query.value("manufacture_no").toString(); + testedCatDevice.product_country = query.value("product_country").toString(); + testedCatDevice.manufacturer = query.value("manufacturer").toString(); + testedCatDevice.product_date = query.value("product_date").toString(); + testedCatDevice.purchase_date = query.value("purchase_date").toString(); + testedCatDevice.unit_price = query.value("unit_price").toString(); + testedCatDevice.usage_status = query.value("usage_status").toString(); + testedCatDevice.quality_condition = query.value("quality_condition").toString(); + testedCatDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedCatDevice.category = query.value("category").toString(); + testedCatDevice.check_cycle = query.value("check_cycle").toString(); + testedCatDevice.level = query.value("level").toString(); + testedCatDevice.remark = query.value("remark").toString(); + + result.append(testedCatDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} +//判断 哪个 装置表 +QList TestedDeviceManage::getJudgeCalibrationTable(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT item_category_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 "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + JudgeCalibrationTable calibration; + calibration.item_category_id = query.value("item_category_id").toString(); + calibration.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + //被检设备管理-检定项目及检定点-多功能校准源 +QList TestedDeviceManage::getVerMultiCal(QString itemId) +{ + QList result; + QSqlQuery query; + query.exec("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.bindValue(":itemId", itemId); + + if (query.exec()) { + while (query.next()) { + VerMultiCal calibration; + calibration.id = query.value("id").toString(); + calibration.params = query.value("params").toString(); + calibration.capacity = query.value("capacity").toString(); + calibration.unit = query.value("unit").toString(); + calibration.frequency = query.value("frequency").toString(); + calibration.range_range = query.value("range_range").toString(); + calibration.standard_value = query.value("standard_value").toString(); + calibration.resolution = query.value("resolution").toString(); + calibration.maximum_error = query.value("maximum_error").toString(); + calibration.error_param_a = query.value("error_param_a").toString(); + calibration.error_param_b = query.value("error_param_b").toString(); + + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + diff --git a/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h new file mode 100644 index 0000000..cfa71ee --- /dev/null +++ b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h @@ -0,0 +1,80 @@ +#ifndef TESTEDDEVICEMANAGE_H +#define TESTEDDEVICEMANAGE_H +#include +#include +#include +#include "QList" +//被检设备管理 +class TestedDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString FULL_NAME; + QString meter_identify; + QString check_cycle; + QString certificate_valid; +}; +//被检设备管理-查看设备 +class TestedCatDevice +{ +public: + QString equipment_name; + QString model; + QString help_instruction; + QString manufacture_no; + QString product_country; + QString manufacturer; + QString product_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_condition; + QString FULL_NAME; + QString category; + QString check_cycle; + QString level; + QString remark; +}; +//判断 哪个 装置表 +class JudgeCalibrationTable +{ +public: + QString item_category_id; + QString belong_standard_equipment; +}; + + +//被检设备管理-检定项目及检定点-检定项多功能校准源 +class VerMultiCal +{ +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; +}; + + +class TestedDeviceManage +{ +public: + TestedDeviceManage(); + QList getTestedDevice(); + QList getTestedCatDevice(QString id); + QList getJudgeCalibrationTable(QString id); + QList getVerMultiCal(QString itemId); +}; + +#endif // TESTEDDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.h b/softwareDirectory/AutoVerScheme/my_tasks_serve.h new file mode 100644 index 0000000..4cf2f9d --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.h @@ -0,0 +1,33 @@ +#ifndef MYTASKS_H +#define MYTASKS_H +#include +#include +#include +#include "QList" +//我的任务 +class MyTask +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString require_over_time; + QString is_urgent; +}; + + + +class MyTasks +{ +public: + MyTasks(); + QList getMyTasks(QString id); + +}; + +#endif // MYTASKS_H diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.cpp b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp new file mode 100644 index 0000000..aef57f1 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp @@ -0,0 +1,31 @@ +#include "technique_file_serve.h" + +Technique_File_Serve::Technique_File_Serve() +{ + +} +QList Technique_File_Serve::getTechnique_File() +{ + QList result; + QSqlQuery query; + query.exec("SELECT brtf.file_distribute_no ,brtf.file_name ,brtf.version_no ,brtf.active_date ,brtf.remark " + " FROM biz_resource_technique_file brtf"); + + if (query.exec()) { + while (query.next()) { + Technique_File file; + file.file_distribute_no = query.value("file_distribute_no").toString(); + file.file_name = query.value("file_name").toString(); + file.version_no = query.value("version_no").toString(); + file.active_date = query.value("active_date").toString(); + file.remark = query.value("remark").toString(); + + result.append(file); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; + +} diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.h b/softwareDirectory/AutoVerScheme/technique_file_serve.h new file mode 100644 index 0000000..181b69c --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.h @@ -0,0 +1,26 @@ +#ifndef TECHNIQUE_FILE_SERVE_H +#define TECHNIQUE_FILE_SERVE_H +#include +#include +#include +#include "QList" + +//技术文件 +class Technique_File +{ +public: + QString file_distribute_no; + QString file_name; + QString version_no; + QString active_date; + QString remark; +}; + +class Technique_File_Serve +{ +public: + Technique_File_Serve(); + QList getTechnique_File(); +}; + +#endif // TECHNIQUE_FILE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp new file mode 100644 index 0000000..ed5cade --- /dev/null +++ b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp @@ -0,0 +1,137 @@ +#include "tested_device_manage_serve.h" +#include +#include +#include +#include "QList" + +TestedDeviceManage::TestedDeviceManage() +{ + +} + // 被检设备管理 +QList TestedDeviceManage::getTestedDevice() +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + if (query.exec()) { + while (query.next()) { + TestedDevice testedDevice; + testedDevice.id = query.value("id").toString(); + testedDevice.equipment_name = query.value("equipment_name").toString(); + testedDevice.model = query.value("model").toString(); + testedDevice.help_instruction = query.value("help_instruction").toString(); + testedDevice.manufacture_no = query.value("manufacture_no").toString(); + testedDevice.manufacturer = query.value("manufacturer").toString(); + testedDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedDevice.meter_identify = query.value("meter_identify").toString(); + testedDevice.check_cycle = query.value("check_cycle").toString(); + testedDevice.certificate_valid = query.value("certificate_valid").toString(); + + result.append(testedDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + // 被检设备管理查看设备信息 +QList TestedDeviceManage::getTestedCatDevice(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + TestedCatDevice testedCatDevice; + testedCatDevice.equipment_name = query.value("equipment_name").toString(); + testedCatDevice.model = query.value("model").toString(); + testedCatDevice.help_instruction = query.value("help_instruction").toString(); + testedCatDevice.manufacture_no = query.value("manufacture_no").toString(); + testedCatDevice.product_country = query.value("product_country").toString(); + testedCatDevice.manufacturer = query.value("manufacturer").toString(); + testedCatDevice.product_date = query.value("product_date").toString(); + testedCatDevice.purchase_date = query.value("purchase_date").toString(); + testedCatDevice.unit_price = query.value("unit_price").toString(); + testedCatDevice.usage_status = query.value("usage_status").toString(); + testedCatDevice.quality_condition = query.value("quality_condition").toString(); + testedCatDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedCatDevice.category = query.value("category").toString(); + testedCatDevice.check_cycle = query.value("check_cycle").toString(); + testedCatDevice.level = query.value("level").toString(); + testedCatDevice.remark = query.value("remark").toString(); + + result.append(testedCatDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} +//判断 哪个 装置表 +QList TestedDeviceManage::getJudgeCalibrationTable(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT item_category_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 "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + JudgeCalibrationTable calibration; + calibration.item_category_id = query.value("item_category_id").toString(); + calibration.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + //被检设备管理-检定项目及检定点-多功能校准源 +QList TestedDeviceManage::getVerMultiCal(QString itemId) +{ + QList result; + QSqlQuery query; + query.exec("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.bindValue(":itemId", itemId); + + if (query.exec()) { + while (query.next()) { + VerMultiCal calibration; + calibration.id = query.value("id").toString(); + calibration.params = query.value("params").toString(); + calibration.capacity = query.value("capacity").toString(); + calibration.unit = query.value("unit").toString(); + calibration.frequency = query.value("frequency").toString(); + calibration.range_range = query.value("range_range").toString(); + calibration.standard_value = query.value("standard_value").toString(); + calibration.resolution = query.value("resolution").toString(); + calibration.maximum_error = query.value("maximum_error").toString(); + calibration.error_param_a = query.value("error_param_a").toString(); + calibration.error_param_b = query.value("error_param_b").toString(); + + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + diff --git a/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h new file mode 100644 index 0000000..cfa71ee --- /dev/null +++ b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h @@ -0,0 +1,80 @@ +#ifndef TESTEDDEVICEMANAGE_H +#define TESTEDDEVICEMANAGE_H +#include +#include +#include +#include "QList" +//被检设备管理 +class TestedDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString FULL_NAME; + QString meter_identify; + QString check_cycle; + QString certificate_valid; +}; +//被检设备管理-查看设备 +class TestedCatDevice +{ +public: + QString equipment_name; + QString model; + QString help_instruction; + QString manufacture_no; + QString product_country; + QString manufacturer; + QString product_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_condition; + QString FULL_NAME; + QString category; + QString check_cycle; + QString level; + QString remark; +}; +//判断 哪个 装置表 +class JudgeCalibrationTable +{ +public: + QString item_category_id; + QString belong_standard_equipment; +}; + + +//被检设备管理-检定项目及检定点-检定项多功能校准源 +class VerMultiCal +{ +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; +}; + + +class TestedDeviceManage +{ +public: + TestedDeviceManage(); + QList getTestedDevice(); + QList getTestedCatDevice(QString id); + QList getJudgeCalibrationTable(QString id); + QList getVerMultiCal(QString itemId); +}; + +#endif // TESTEDDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/verification_data_management_serve.cpp b/softwareDirectory/AutoVerScheme/verification_data_management_serve.cpp new file mode 100644 index 0000000..0f6b2af --- /dev/null +++ b/softwareDirectory/AutoVerScheme/verification_data_management_serve.cpp @@ -0,0 +1,122 @@ +#include "verification_data_management_serve.h" + +Verification_Data_Management_Serve::Verification_Data_Management_Serve() +{ + +} + //检定数据管理 +QList Verification_Data_Management_Serve::getVerificationData() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bbdmi.id , bbdmi.sample_name ,bbdmi.model ,eei.help_instruction ,bbdmi.manufacture_no ," + "bbdmi.manufacturer , bboi.customer_name , dept.FULL_NAME , _user.NAME , bbdmi.trace_date ," + "bbdmi.measure_valid_date , eei.meter_identify , bbdmi.restriction_instruction " + "FROM biz_business_device_measure_info bbdmi LEFT JOIN eqpt_equipment_info eei ON bbdmi.sample_id = eei.id " + " LEFT JOIN biz_business_order_info bboi ON bbdmi.order_id = bboi.id LEFT JOIN sys_dept dept ON eei.dept_id = dept.ID " + " LEFT JOIN sys_user _user ON bbdmi.create_user_id = _user.id"); + + if (query.exec()) { + while (query.next()) { + VerificationData verificationData; + verificationData.id = query.value("id").toString(); + verificationData.sample_name = query.value("sample_name").toString(); + verificationData.model = query.value("model").toString(); + verificationData.help_instruction = query.value("help_instruction").toString(); + verificationData.manufacture_no = query.value("manufacture_no").toString(); + verificationData.manufacturer = query.value("manufacturer").toString(); + verificationData.FULL_NAME = query.value("FULL_NAME").toString(); + verificationData.NAME = query.value("NAME").toString(); + verificationData.trace_date = query.value("trace_date").toString(); + verificationData.measure_valid_date = query.value("measure_valid_date").toString(); + verificationData.meter_identify = query.value("meter_identify").toString(); + verificationData.restriction_instruction = query.value("restriction_instruction").toString(); + + result.append(verificationData); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} +//检定数据管理-检定基本信息 +QList Verification_Data_Management_Serve::getVerificationBasicDataDetails(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bbdmi.sample_name ,bbdmi.model ,eei.help_instruction ,bbdmi.manufacture_no ,bbdmi.manufacturer ," + " bboi.customer_name, eemtte.based_documents, bbdmi.trace_date , bbdmi.temperature , bbdmi.humidity ," + "bbdmi.measure_address , bbdmi.measure_valid_date , _user.NAME , bbdmi.conclusion , bbdmi.restriction_instruction " + "FROM biz_business_device_measure_info bbdmi LEFT JOIN eqpt_equipment_info eei ON bbdmi.sample_id = eei.id " + " LEFT JOIN biz_business_order_info bboi ON bbdmi.order_id = bboi.id " + " LEFT JOIN biz_business_device_measure_item_info bbdmii ON bbdmi.item_id = bbdmii.id " + " LEFT JOIN eqpt_equipment_model_technical_target eemtte ON bbdmii.device_model_id = eemtte.model_id " + " LEFT JOIN sys_user _user ON bbdmi.create_user_id = _user.id WHERE bbdmi.id = :id "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + VerificationBasicDataDetails dataDetails; + dataDetails.sample_name = query.value("sample_name").toString(); + dataDetails.model = query.value("model").toString(); + dataDetails.help_instruction = query.value("help_instruction").toString(); + dataDetails.manufacture_no = query.value("manufacture_no").toString(); + dataDetails.manufacturer = query.value("manufacturer").toString(); + dataDetails.customer_name = query.value("customer_name").toString(); + dataDetails.trace_date = query.value("trace_date").toString(); + dataDetails.temperature = query.value("temperature").toString(); + dataDetails.humidity = query.value("humidity").toString(); + dataDetails.measure_address = query.value("measure_address").toString(); + dataDetails.measure_valid_date = query.value("measure_valid_date").toString(); + dataDetails.based_documents = query.value("based_documents").toString(); + dataDetails.NAME = query.value("NAME").toString(); + dataDetails.conclusion = query.value("conclusion").toString(); + dataDetails.restriction_instruction = query.value("restriction_instruction").toString(); + + result.append(dataDetails); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //检定数据管理-检定结果信息 +QList Verification_Data_Management_Serve::getVerificationResultData(QString sampleId) +{ + QList result; + QSqlQuery query; + query.exec("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 ,bbdmi.other_outcome " + " FROM biz_business_device_measure_item_data_calibrator bbdmidc " + " LEFT JOIN biz_business_device_measure_info bbdmi ON bbdmi.item_id = bbdmidc.item_id " + "WHERE bbdmidc.item_id = (SELECT CONVERT(item_id USING utf8mb4) COLLATE utf8mb4_0900_ai_ci FROM biz_business_device_measure_info bbdmi " + " WHERE sample_id = :sampleId )"); + // 将参数绑定到占位符 + query.bindValue(":sampleId", sampleId); + if (query.exec()) { + while (query.next()) { + VerificationResultData resultData; + resultData.id = query.value("id").toString(); + resultData.params = query.value("params").toString(); + resultData.capacity = query.value("capacity").toString(); + resultData.unit = query.value("unit").toString(); + resultData.frequency = query.value("frequency").toString(); + resultData.range_range = query.value("range_range").toString(); + resultData.standard_value = query.value("standard_value").toString(); + resultData.resolution = query.value("resolution").toString(); + resultData.maximum_error = query.value("maximum_error").toString(); + resultData.error_param_a = query.value("error_param_a").toString(); + resultData.error_param_b = query.value("error_param_b").toString(); + resultData.other_outcome = query.value("other_outcome").toString(); + + result.append(resultData); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp new file mode 100644 index 0000000..60486b4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.cpp @@ -0,0 +1,127 @@ +#include "biz_device_manage_serve.h" + +BizDeviceManage::BizDeviceManage() +{ + +} +QListBizDeviceManage::getBizDeviceManage() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.id ,bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.manufacturer FROM biz_equipment_info bei"); + if (query.exec()) { + while (query.next()) { + BizDevice 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; +} +QListBizDeviceManage::getCatDeviceInfor(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bei.equipment_name ,bei.model ,bei.manufacture_no ,bei.measure_valid_date ," + "bei.product_country , bei.manufacturer , bei.produce_date, bei.purchase_date ,bei.unit_price , bei.usage_status , bei.quality_status , " + "bei.dept_name , bei.director_name , bei.supplier_name , bei.location , bei.type , bei.standard_type , bei.category , bei.level , " + "bei.measure_cycle , bei.unpack_record_name , bei.remark FROM biz_equipment_info bei WHERE bei.id = :id"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + CatDeviceInfor device; + device.equipment_name = query.value("equipment_name").toString(); + device.model = query.value("model").toString(); + device.manufacture_no = query.value("manufacture_no").toString(); + device.measure_valid_date = query.value("measure_valid_date").toString(); + device.product_country = query.value("product_country").toString(); + device.manufacturer = query.value("manufacturer").toString(); + device.produce_date = query.value("produce_date").toString(); + device.purchase_date = query.value("purchase_date").toString(); + device.unit_price = query.value("unit_price").toString(); + device.usage_status = query.value("usage_status").toString(); + device.quality_status = query.value("quality_status").toString(); + device.dept_name = query.value("dept_name").toString(); + device.director_name = query.value("director_name").toString(); + device.supplier_name = query.value("supplier_name").toString(); + device.location = query.value("location").toString(); + device.type = query.value("type").toString(); + device.standard_type = query.value("standard_type").toString(); + device.category = query.value("category").toString(); + device.level = query.value("level").toString(); + device.measure_cycle = query.value("measure_cycle").toString(); + device.unpack_record_name = query.value("unpack_record_name").toString(); + device.remark = query.value("remark").toString(); + + result.append(device); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + + //直流稳压电源检定装置 +QListBizDeviceManage::getCheckDCPower(QString item_category_id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT besciddp.id ,besciddp.params,besciddp.unit,resolution,besciddp.urel,besciddp.check_type,datum_point,cycle_number" + ", datum_point, resistance_value, resistance_value_unit, remark FROM biz_equipment_standard_check_item_data_dc_power besciddp WHERE item_category_id = (SELECT bescic.id FROM biz_equipment_standard_check_item_category bescic WHERE bescic.belong_standard_equipment_name = :item_category_id))"); + // 将参数绑定到占位符 + query.bindValue(":item_category_id", item_category_id); + if (query.exec()) { + while (query.next()) { + CheckDCPower checkDCPower; + checkDCPower.id = query.value("id").toString(); + checkDCPower.params = query.value("params").toString(); + checkDCPower.check_point = query.value("check_point").toString(); + checkDCPower.unit = query.value("unit").toString(); + checkDCPower.resolution = query.value("resolution").toString(); + checkDCPower.urel = query.value("urel").toString(); + checkDCPower.check_type = query.value("check_type").toString(); + checkDCPower.datum_point = query.value("datum_point").toString(); + checkDCPower.cycle_number = query.value("cycle_number").toString(); + checkDCPower.resistance_value = query.value("resistance_value").toString(); + checkDCPower.resistance_value_unit = query.value("resistance_value_unit").toString(); + checkDCPower.remark = query.value("remark").toString(); + + result.append(checkDCPower); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //根据id获取装置名称 +QString BizDeviceManage::getApparatus(QString id) const +{ + QString result; + QSqlQuery query; + query.exec("SELECT besi.standard_name FROM biz_equipment_standard_info besi WHERE besi.id = ( " + "SELECT bei.meter_standard_id FROM biz_equipment_info bei WHERE bei.id = :id )"); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + result = query.value("standard_name").toString(); + } + } else { + // 如果没有找到对应记录，可以设置一个默认值或者抛出异常 + result = "Not Found"; + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h new file mode 100644 index 0000000..6c95bed --- /dev/null +++ b/softwareDirectory/AutoVerScheme/biz_device_manage_serve.h @@ -0,0 +1,74 @@ +#ifndef BIZDEVICEMANAGE_H +#define BIZDEVICEMANAGE_H + +#include +#include +#include +#include "QList" +//标准设备管理 +class BizDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; +}; +//标准设备管理-查看设备信息 +class CatDeviceInfor +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString measure_valid_date; + QString product_country; + QString manufacturer; + QString produce_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_status; + QString dept_name; + QString director_name; + QString supplier_name; + QString location; + QString type; + QString standard_type; + QString category; + QString level; + QString measure_cycle; + QString unpack_record_name; + QString remark; + +}; +//标准设备管理-核查项目及核查点-直流稳压电源检定装置 +class CheckDCPower +{ +public: + QString id; + QString params; + QString check_point; + QString unit; + QString resolution; + QString urel; + QString check_type; + QString datum_point; + QString cycle_number; + QString resistance_value; + QString resistance_value_unit; + QString remark; +}; + +class BizDeviceManage +{ +public: + BizDeviceManage(); + QListgetBizDeviceManage(); + QListgetCatDeviceInfor(QString id); + virtual QString getApparatus(QString id) const = 0; + QListgetCheckDCPower(QString item_category_id); +}; + +#endif // BIZDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/check_data_manage_serve.h b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h new file mode 100644 index 0000000..cdf9587 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/check_data_manage_serve.h @@ -0,0 +1,65 @@ +#ifndef CHECK_DATA_MANAGE_SERVE_H +#define CHECK_DATA_MANAGE_SERVE_H + +#include +#include +#include +#include "QList" + +//核查数据管理 +class CheckData +{ +public: + QString id; + QString equipment_name; + QString model; + QString manufacture_no; + QString meter_standard_name; + QString meter_standard_id; + QString create_user_name; + QString check_date; + QString dept_name; +}; +//核查数据管理-核查基本信息 +class CheckDataManageBasicInfo +{ +public: + QString equipment_name; + QString model; + QString manufacture_no; + QString manufacturer; + QString temperature; + QString humidity; + QString 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; + QString check_date; + QString urel; + QString tfer; + QString dccp; + QString flit; +}; + + +class Check_Data_Manage_Serve +{ +public: + Check_Data_Manage_Serve(); + QList getCheckData(); + QList getCheckDataManageBasicInfo(QString id); + QList getCheckDataManageResultManageMult(QString equipment_id); +}; + +#endif // CHECK_DATA_MANAGE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp new file mode 100644 index 0000000..102b773 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.cpp @@ -0,0 +1,95 @@ +#include "create_tasks_serve.h" + +CreateTasks::CreateTasks() +{ + +} +QListCreateTasks::getCreateTaskList(){ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id,bi.order_no ,bi.customer_name ,dept.FULL_NAME ," + "bi.require_over_time , bi.deliverer ,bi.is_urgent FROM biz_business_order_info bi,sys_dept dept WHERE bi.customer_id = dept.ID"); + if (query.exec()) { + while (query.next()) { + CreateTaskList task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} + +QListCreateTasks::getCatTask(QString orderNo) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bi.id, bi.order_no, bi.customer_name, dept.FULL_NAME, bi.require_over_time," + "bi.deliverer, bi.deliverer_tel, bi.undertaker_name, bi.undertake_time, bi.is_urgent," + "bi.receive_illustrate FROM biz_business_order_info bi LEFT JOIN sys_dept dept ON bi.customer_id = dept.ID" + " WHERE bi.order_no = :order_no"); + + // 将参数绑定到占位符 + query.bindValue(":order_no", orderNo); + if (query.exec()) { + while (query.next()) { + CatTask task; + task.id = query.value("id").toString(); + task.order_no = query.value("order_no").toString(); + task.customer_name = query.value("customer_name").toString(); + task.DEPT_FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.deliverer = query.value("deliverer").toString(); + task.deliverer_tel = query.value("deliverer_tel").toString(); + task.undertaker_name = query.value("undertaker_name").toString(); + task.undertake_time = query.value("undertake_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + task.receive_illustrate = query.value("receive_illustrate").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + +QListCreateTasks::getCatTaskList(QString orderId) +{ + QList result; + QSqlQuery query; + query.exec("SELECT br.id , br.sample_name ,br.sample_model ,ei.manufacture_no,ei.manufacturer ,br.appendix_descn ," + "br.special_require ,br.measure_complete_time ,bbdmi.conclusion ,ei.limit_instruction FROM biz_business_order_sample_relation br" + " Left JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no " + "Left JOIN biz_business_device_measure_info bbdmi ON br.order_id = bbdmi.order_id " + "WHERE br.order_id = :order_id"); + // 将参数绑定到占位符 + query.bindValue(":order_id", orderId); + if (query.exec()) { + while (query.next()) { + CatTaskList task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.appendix_descn = query.value("appendix_descn").toString(); + task.special_require = query.value("special_require").toString(); + task.measure_complete_time = query.value("measure_complete_time").toString(); + task.conclusion = query.value("conclusion").toString(); + task.limit_instruction = query.value("limit_instruction").toString(); + result.append(task); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/create_tasks_serve.h b/softwareDirectory/AutoVerScheme/create_tasks_serve.h new file mode 100644 index 0000000..3114433 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/create_tasks_serve.h @@ -0,0 +1,60 @@ +#ifndef CREATETASKS_H +#define CREATETASKS_H +#include +#include +#include +#include "QList" +//创建任务单-首页 +class CreateTaskList +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString is_urgent; +}; +//创建任务单-查看任务单 +class CatTask +{ +public: + QString id; + QString order_no; + QString customer_name; + QString DEPT_FULL_NAME; + QString require_over_time; + QString deliverer; + QString deliverer_tel; + QString undertaker_name; + QString undertake_time; + QString is_urgent; + QString receive_illustrate; +}; +class CatTaskList +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString manufacture_no; + QString manufacturer; + QString appendix_descn; + QString special_require; + QString measure_complete_time; + QString conclusion; + QString limit_instruction; +}; + + +class CreateTasks +{ +public: + CreateTasks(); + QListgetCreateTaskList(); + QListgetCatTask(QString orderNo); + QListgetCatTaskList(QString orderId); +}; + +#endif // CREATETASKS_H diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp new file mode 100644 index 0000000..a705164 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.cpp @@ -0,0 +1,28 @@ +#include "data_base_connect_serve.h" + +DatabaseConnection::DatabaseConnection() +{ + // 连接数据库 + db = QSqlDatabase::addDatabase("QODBC"); + db.setHostName("127.0.0.1"); + db.setPort(3306); + db.setDatabaseName("trigger_2"); + db.setUserName("root"); + db.setPassword("123456"); + +} +DatabaseConnection::~DatabaseConnection() { + // 在析构函数中关闭数据库连接 + close(); +} +bool DatabaseConnection::open() { + return db.open(); +} + +void DatabaseConnection::close() { + db.close(); +} + +QSqlDatabase& DatabaseConnection::getDatabase() { + return db; +} diff --git a/softwareDirectory/AutoVerScheme/data_base_connect_serve.h b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h new file mode 100644 index 0000000..8930b6b --- /dev/null +++ b/softwareDirectory/AutoVerScheme/data_base_connect_serve.h @@ -0,0 +1,17 @@ +#ifndef DATABASECONNECTION_H +#define DATABASECONNECTION_H +#include + +class DatabaseConnection +{ +public: + DatabaseConnection(); + ~DatabaseConnection(); + bool open(); + void close(); + QSqlDatabase& getDatabase(); +private: + QSqlDatabase db; +}; + +#endif // DATABASECONNECTION_H diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp new file mode 100644 index 0000000..05c2ac4 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.cpp @@ -0,0 +1,41 @@ +#include "my_tasks_serve.h" + +MyTasks::MyTasks() +{ + +} +QList MyTasks::getMyTasks(QString id){ + QList result; + QSqlQuery query; + query.exec("SELECT " + "bi.id, br.sample_name, br.sample_model, ei.help_instruction, ei.manufacture_no," + "ei.manufacturer, bi.customer_name," + "dept.FULL_NAME, bi.require_over_time," + "bi.is_urgent FROM biz_business_order_info bi" + " LEfT JOIN biz_business_order_sample_relation br ON bi.id = br.order_id" + " LEfT JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEfT JOIN " + "sys_dept dept ON ei.dept_id = dept.ID WHERE bi.create_user_id = :user_id"); + + // 将参数绑定到占位符 + query.bindValue(":user_id", id); +if (query.exec()) { + while (query.next()) { + MyTask task; + task.id = query.value("id").toString(); + task.sample_name = query.value("sample_name").toString(); + task.sample_model = query.value("sample_model").toString(); + task.help_instruction = query.value("help_instruction").toString(); + task.manufacture_no = query.value("manufacture_no").toString(); + task.manufacturer = query.value("manufacturer").toString(); + task.customer_name = query.value("customer_name").toString(); + task.FULL_NAME = query.value("FULL_NAME").toString(); + task.require_over_time = query.value("require_over_time").toString(); + task.is_urgent = query.value("is_urgent").toString(); + result.append(task); + } +} +else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + return result; +} diff --git a/softwareDirectory/AutoVerScheme/my_tasks_serve.h b/softwareDirectory/AutoVerScheme/my_tasks_serve.h new file mode 100644 index 0000000..4cf2f9d --- /dev/null +++ b/softwareDirectory/AutoVerScheme/my_tasks_serve.h @@ -0,0 +1,33 @@ +#ifndef MYTASKS_H +#define MYTASKS_H +#include +#include +#include +#include "QList" +//我的任务 +class MyTask +{ +public: + QString id; + QString sample_name; + QString sample_model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString require_over_time; + QString is_urgent; +}; + + + +class MyTasks +{ +public: + MyTasks(); + QList getMyTasks(QString id); + +}; + +#endif // MYTASKS_H diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.cpp b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp new file mode 100644 index 0000000..aef57f1 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.cpp @@ -0,0 +1,31 @@ +#include "technique_file_serve.h" + +Technique_File_Serve::Technique_File_Serve() +{ + +} +QList Technique_File_Serve::getTechnique_File() +{ + QList result; + QSqlQuery query; + query.exec("SELECT brtf.file_distribute_no ,brtf.file_name ,brtf.version_no ,brtf.active_date ,brtf.remark " + " FROM biz_resource_technique_file brtf"); + + if (query.exec()) { + while (query.next()) { + Technique_File file; + file.file_distribute_no = query.value("file_distribute_no").toString(); + file.file_name = query.value("file_name").toString(); + file.version_no = query.value("version_no").toString(); + file.active_date = query.value("active_date").toString(); + file.remark = query.value("remark").toString(); + + result.append(file); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; + +} diff --git a/softwareDirectory/AutoVerScheme/technique_file_serve.h b/softwareDirectory/AutoVerScheme/technique_file_serve.h new file mode 100644 index 0000000..181b69c --- /dev/null +++ b/softwareDirectory/AutoVerScheme/technique_file_serve.h @@ -0,0 +1,26 @@ +#ifndef TECHNIQUE_FILE_SERVE_H +#define TECHNIQUE_FILE_SERVE_H +#include +#include +#include +#include "QList" + +//技术文件 +class Technique_File +{ +public: + QString file_distribute_no; + QString file_name; + QString version_no; + QString active_date; + QString remark; +}; + +class Technique_File_Serve +{ +public: + Technique_File_Serve(); + QList getTechnique_File(); +}; + +#endif // TECHNIQUE_FILE_SERVE_H diff --git a/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp new file mode 100644 index 0000000..ed5cade --- /dev/null +++ b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.cpp @@ -0,0 +1,137 @@ +#include "tested_device_manage_serve.h" +#include +#include +#include +#include "QList" + +TestedDeviceManage::TestedDeviceManage() +{ + +} + // 被检设备管理 +QList TestedDeviceManage::getTestedDevice() +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + if (query.exec()) { + while (query.next()) { + TestedDevice testedDevice; + testedDevice.id = query.value("id").toString(); + testedDevice.equipment_name = query.value("equipment_name").toString(); + testedDevice.model = query.value("model").toString(); + testedDevice.help_instruction = query.value("help_instruction").toString(); + testedDevice.manufacture_no = query.value("manufacture_no").toString(); + testedDevice.manufacturer = query.value("manufacturer").toString(); + testedDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedDevice.meter_identify = query.value("meter_identify").toString(); + testedDevice.check_cycle = query.value("check_cycle").toString(); + testedDevice.certificate_valid = query.value("certificate_valid").toString(); + + result.append(testedDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + // 被检设备管理查看设备信息 +QList TestedDeviceManage::getTestedCatDevice(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ," + "eei.category , eei.check_cycle ,eei.level , eei.remark from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + TestedCatDevice testedCatDevice; + testedCatDevice.equipment_name = query.value("equipment_name").toString(); + testedCatDevice.model = query.value("model").toString(); + testedCatDevice.help_instruction = query.value("help_instruction").toString(); + testedCatDevice.manufacture_no = query.value("manufacture_no").toString(); + testedCatDevice.product_country = query.value("product_country").toString(); + testedCatDevice.manufacturer = query.value("manufacturer").toString(); + testedCatDevice.product_date = query.value("product_date").toString(); + testedCatDevice.purchase_date = query.value("purchase_date").toString(); + testedCatDevice.unit_price = query.value("unit_price").toString(); + testedCatDevice.usage_status = query.value("usage_status").toString(); + testedCatDevice.quality_condition = query.value("quality_condition").toString(); + testedCatDevice.FULL_NAME = query.value("FULL_NAME").toString(); + testedCatDevice.category = query.value("category").toString(); + testedCatDevice.check_cycle = query.value("check_cycle").toString(); + testedCatDevice.level = query.value("level").toString(); + testedCatDevice.remark = query.value("remark").toString(); + + result.append(testedCatDevice); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} +//判断 哪个 装置表 +QList TestedDeviceManage::getJudgeCalibrationTable(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT item_category_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 "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + JudgeCalibrationTable calibration; + calibration.item_category_id = query.value("item_category_id").toString(); + calibration.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + //被检设备管理-检定项目及检定点-多功能校准源 +QList TestedDeviceManage::getVerMultiCal(QString itemId) +{ + QList result; + QSqlQuery query; + query.exec("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.bindValue(":itemId", itemId); + + if (query.exec()) { + while (query.next()) { + VerMultiCal calibration; + calibration.id = query.value("id").toString(); + calibration.params = query.value("params").toString(); + calibration.capacity = query.value("capacity").toString(); + calibration.unit = query.value("unit").toString(); + calibration.frequency = query.value("frequency").toString(); + calibration.range_range = query.value("range_range").toString(); + calibration.standard_value = query.value("standard_value").toString(); + calibration.resolution = query.value("resolution").toString(); + calibration.maximum_error = query.value("maximum_error").toString(); + calibration.error_param_a = query.value("error_param_a").toString(); + calibration.error_param_b = query.value("error_param_b").toString(); + + result.append(calibration); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + diff --git a/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h new file mode 100644 index 0000000..cfa71ee --- /dev/null +++ b/softwareDirectory/AutoVerScheme/tested_device_manage_serve.h @@ -0,0 +1,80 @@ +#ifndef TESTEDDEVICEMANAGE_H +#define TESTEDDEVICEMANAGE_H +#include +#include +#include +#include "QList" +//被检设备管理 +class TestedDevice +{ +public: + QString id; + QString equipment_name; + QString model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString FULL_NAME; + QString meter_identify; + QString check_cycle; + QString certificate_valid; +}; +//被检设备管理-查看设备 +class TestedCatDevice +{ +public: + QString equipment_name; + QString model; + QString help_instruction; + QString manufacture_no; + QString product_country; + QString manufacturer; + QString product_date; + QString purchase_date; + QString unit_price; + QString usage_status; + QString quality_condition; + QString FULL_NAME; + QString category; + QString check_cycle; + QString level; + QString remark; +}; +//判断 哪个 装置表 +class JudgeCalibrationTable +{ +public: + QString item_category_id; + QString belong_standard_equipment; +}; + + +//被检设备管理-检定项目及检定点-检定项多功能校准源 +class VerMultiCal +{ +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; +}; + + +class TestedDeviceManage +{ +public: + TestedDeviceManage(); + QList getTestedDevice(); + QList getTestedCatDevice(QString id); + QList getJudgeCalibrationTable(QString id); + QList getVerMultiCal(QString itemId); +}; + +#endif // TESTEDDEVICEMANAGE_H diff --git a/softwareDirectory/AutoVerScheme/verification_data_management_serve.cpp b/softwareDirectory/AutoVerScheme/verification_data_management_serve.cpp new file mode 100644 index 0000000..0f6b2af --- /dev/null +++ b/softwareDirectory/AutoVerScheme/verification_data_management_serve.cpp @@ -0,0 +1,122 @@ +#include "verification_data_management_serve.h" + +Verification_Data_Management_Serve::Verification_Data_Management_Serve() +{ + +} + //检定数据管理 +QList Verification_Data_Management_Serve::getVerificationData() +{ + QList result; + QSqlQuery query; + query.exec("SELECT bbdmi.id , bbdmi.sample_name ,bbdmi.model ,eei.help_instruction ,bbdmi.manufacture_no ," + "bbdmi.manufacturer , bboi.customer_name , dept.FULL_NAME , _user.NAME , bbdmi.trace_date ," + "bbdmi.measure_valid_date , eei.meter_identify , bbdmi.restriction_instruction " + "FROM biz_business_device_measure_info bbdmi LEFT JOIN eqpt_equipment_info eei ON bbdmi.sample_id = eei.id " + " LEFT JOIN biz_business_order_info bboi ON bbdmi.order_id = bboi.id LEFT JOIN sys_dept dept ON eei.dept_id = dept.ID " + " LEFT JOIN sys_user _user ON bbdmi.create_user_id = _user.id"); + + if (query.exec()) { + while (query.next()) { + VerificationData verificationData; + verificationData.id = query.value("id").toString(); + verificationData.sample_name = query.value("sample_name").toString(); + verificationData.model = query.value("model").toString(); + verificationData.help_instruction = query.value("help_instruction").toString(); + verificationData.manufacture_no = query.value("manufacture_no").toString(); + verificationData.manufacturer = query.value("manufacturer").toString(); + verificationData.FULL_NAME = query.value("FULL_NAME").toString(); + verificationData.NAME = query.value("NAME").toString(); + verificationData.trace_date = query.value("trace_date").toString(); + verificationData.measure_valid_date = query.value("measure_valid_date").toString(); + verificationData.meter_identify = query.value("meter_identify").toString(); + verificationData.restriction_instruction = query.value("restriction_instruction").toString(); + + result.append(verificationData); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} +//检定数据管理-检定基本信息 +QList Verification_Data_Management_Serve::getVerificationBasicDataDetails(QString id) +{ + QList result; + QSqlQuery query; + query.exec("SELECT bbdmi.sample_name ,bbdmi.model ,eei.help_instruction ,bbdmi.manufacture_no ,bbdmi.manufacturer ," + " bboi.customer_name, eemtte.based_documents, bbdmi.trace_date , bbdmi.temperature , bbdmi.humidity ," + "bbdmi.measure_address , bbdmi.measure_valid_date , _user.NAME , bbdmi.conclusion , bbdmi.restriction_instruction " + "FROM biz_business_device_measure_info bbdmi LEFT JOIN eqpt_equipment_info eei ON bbdmi.sample_id = eei.id " + " LEFT JOIN biz_business_order_info bboi ON bbdmi.order_id = bboi.id " + " LEFT JOIN biz_business_device_measure_item_info bbdmii ON bbdmi.item_id = bbdmii.id " + " LEFT JOIN eqpt_equipment_model_technical_target eemtte ON bbdmii.device_model_id = eemtte.model_id " + " LEFT JOIN sys_user _user ON bbdmi.create_user_id = _user.id WHERE bbdmi.id = :id "); + // 将参数绑定到占位符 + query.bindValue(":id", id); + if (query.exec()) { + while (query.next()) { + VerificationBasicDataDetails dataDetails; + dataDetails.sample_name = query.value("sample_name").toString(); + dataDetails.model = query.value("model").toString(); + dataDetails.help_instruction = query.value("help_instruction").toString(); + dataDetails.manufacture_no = query.value("manufacture_no").toString(); + dataDetails.manufacturer = query.value("manufacturer").toString(); + dataDetails.customer_name = query.value("customer_name").toString(); + dataDetails.trace_date = query.value("trace_date").toString(); + dataDetails.temperature = query.value("temperature").toString(); + dataDetails.humidity = query.value("humidity").toString(); + dataDetails.measure_address = query.value("measure_address").toString(); + dataDetails.measure_valid_date = query.value("measure_valid_date").toString(); + dataDetails.based_documents = query.value("based_documents").toString(); + dataDetails.NAME = query.value("NAME").toString(); + dataDetails.conclusion = query.value("conclusion").toString(); + dataDetails.restriction_instruction = query.value("restriction_instruction").toString(); + + result.append(dataDetails); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + //检定数据管理-检定结果信息 +QList Verification_Data_Management_Serve::getVerificationResultData(QString sampleId) +{ + QList result; + QSqlQuery query; + query.exec("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 ,bbdmi.other_outcome " + " FROM biz_business_device_measure_item_data_calibrator bbdmidc " + " LEFT JOIN biz_business_device_measure_info bbdmi ON bbdmi.item_id = bbdmidc.item_id " + "WHERE bbdmidc.item_id = (SELECT CONVERT(item_id USING utf8mb4) COLLATE utf8mb4_0900_ai_ci FROM biz_business_device_measure_info bbdmi " + " WHERE sample_id = :sampleId )"); + // 将参数绑定到占位符 + query.bindValue(":sampleId", sampleId); + if (query.exec()) { + while (query.next()) { + VerificationResultData resultData; + resultData.id = query.value("id").toString(); + resultData.params = query.value("params").toString(); + resultData.capacity = query.value("capacity").toString(); + resultData.unit = query.value("unit").toString(); + resultData.frequency = query.value("frequency").toString(); + resultData.range_range = query.value("range_range").toString(); + resultData.standard_value = query.value("standard_value").toString(); + resultData.resolution = query.value("resolution").toString(); + resultData.maximum_error = query.value("maximum_error").toString(); + resultData.error_param_a = query.value("error_param_a").toString(); + resultData.error_param_b = query.value("error_param_b").toString(); + resultData.other_outcome = query.value("other_outcome").toString(); + + result.append(resultData); + } + } else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/verification_data_management_serve.h b/softwareDirectory/AutoVerScheme/verification_data_management_serve.h new file mode 100644 index 0000000..b7a92d8 --- /dev/null +++ b/softwareDirectory/AutoVerScheme/verification_data_management_serve.h @@ -0,0 +1,74 @@ +#ifndef VERIFICATION_DATA_MANAGEMENT_SERVE_H +#define VERIFICATION_DATA_MANAGEMENT_SERVE_H + +#include +#include +#include +#include "QList" + //检定数据管理 +class VerificationData +{ +public: + QString id; + QString sample_name; + QString model; + QString help_instruction; + QString manufacture_no; + QString manufacturer; + QString customer_name; + QString FULL_NAME; + QString NAME; + QString trace_date; + QString 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; + QString trace_date; + QString temperature; + QString humidity; + QString measure_address; + QString 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; +}; + + +class Verification_Data_Management_Serve +{ +public: + Verification_Data_Management_Serve(); + QList getVerificationData(); + QList getVerificationBasicDataDetails(QString id); + QList getVerificationResultData(QString sampleId); +}; + +#endif // VERIFICATION_DATA_MANAGEMENT_SERVE_H