diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 111e8d4..266ed67 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,13 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + biz_device_manage_serve.cpp \ + check_data_manage_serve.cpp \ + create_tasks_serve.cpp \ + my_tasks_serve.cpp \ + technique_file_serve.cpp \ + tested_device_manage_serve.cpp \ + verification_data_management_serve.cpp \ beexamined_deviceitem.cpp \ checkmethodmanage.cpp \ checkwindow.cpp \ @@ -41,6 +48,13 @@ verifywindow.cpp HEADERS += \ + biz_device_manage_serve.h \ + check_data_manage_serve.h \ + create_tasks_serve.h \ + my_tasks_serve.h \ + technique_file_serve.h \ + tested_device_manage_serve.h \ + verification_data_management_serve.h \ InfoBase.h \ beexamined_deviceitem.h \ checkmethodmanage.h \ diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 111e8d4..266ed67 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,13 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + biz_device_manage_serve.cpp \ + check_data_manage_serve.cpp \ + create_tasks_serve.cpp \ + my_tasks_serve.cpp \ + technique_file_serve.cpp \ + tested_device_manage_serve.cpp \ + verification_data_management_serve.cpp \ beexamined_deviceitem.cpp \ checkmethodmanage.cpp \ checkwindow.cpp \ @@ -41,6 +48,13 @@ verifywindow.cpp HEADERS += \ + biz_device_manage_serve.h \ + check_data_manage_serve.h \ + create_tasks_serve.h \ + my_tasks_serve.h \ + technique_file_serve.h \ + tested_device_manage_serve.h \ + verification_data_management_serve.h \ InfoBase.h \ beexamined_deviceitem.h \ checkmethodmanage.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/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 111e8d4..266ed67 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,13 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + biz_device_manage_serve.cpp \ + check_data_manage_serve.cpp \ + create_tasks_serve.cpp \ + my_tasks_serve.cpp \ + technique_file_serve.cpp \ + tested_device_manage_serve.cpp \ + verification_data_management_serve.cpp \ beexamined_deviceitem.cpp \ checkmethodmanage.cpp \ checkwindow.cpp \ @@ -41,6 +48,13 @@ verifywindow.cpp HEADERS += \ + biz_device_manage_serve.h \ + check_data_manage_serve.h \ + create_tasks_serve.h \ + my_tasks_serve.h \ + technique_file_serve.h \ + tested_device_manage_serve.h \ + verification_data_management_serve.h \ InfoBase.h \ beexamined_deviceitem.h \ checkmethodmanage.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