diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 4873dc0..7c8a278 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,7 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + basecommonapi.cpp \ biz_device_manage_serve.cpp \ check_data_manage_serve.cpp \ create_tasks_serve.cpp \ @@ -51,6 +52,7 @@ verifywindow.cpp HEADERS += \ + basecommonapi.h \ biz_device_manage_serve.h \ check_data_manage_serve.h \ create_tasks_serve.h \ diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 4873dc0..7c8a278 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,7 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + basecommonapi.cpp \ biz_device_manage_serve.cpp \ check_data_manage_serve.cpp \ create_tasks_serve.cpp \ @@ -51,6 +52,7 @@ verifywindow.cpp HEADERS += \ + basecommonapi.h \ biz_device_manage_serve.h \ check_data_manage_serve.h \ create_tasks_serve.h \ diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user index 1e5887b..643d68a 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user @@ -1,18 +1,10 @@ -<<<<<<< HEAD - + EnvironmentId {2746248a-b112-4e0f-9ae0-9e61f2a42309} -======= - - - - EnvironmentId - {94e4c4a1-54d4-412c-b108-da01d63f0d97} ->>>>>>> origin/master ProjectExplorer.Project.ActiveTarget @@ -72,18 +64,14 @@ ProjectExplorer.Project.Target.0 - Desktop Qt 5.14.2 MinGW 32-bit - Desktop Qt 5.14.2 MinGW 32-bit - qt.qt5.5142.win32_mingw73_kit + Desktop Qt 5.14.2 MinGW 64-bit + Desktop Qt 5.14.2 MinGW 64-bit + qt.qt5.5142.win64_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug true @@ -131,11 +119,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release true @@ -183,11 +167,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile true @@ -307,13 +287,8 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - Qt4ProjectManager.Qt4RunConfiguration:D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro - D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro ->>>>>>> origin/master false @@ -324,11 +299,7 @@ false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug 1 @@ -336,18 +307,14 @@ ProjectExplorer.Project.Target.1 - Desktop Qt 5.14.2 MinGW 64-bit - Desktop Qt 5.14.2 MinGW 64-bit - qt.qt5.5142.win64_mingw73_kit + Desktop Qt 5.14.2 MinGW 32-bit + Desktop Qt 5.14.2 MinGW 32-bit + qt.qt5.5142.win32_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug true @@ -395,11 +362,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release true @@ -447,11 +410,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile true @@ -571,28 +530,19 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - - ProjectExplorer.CustomExecutableRunConfiguration - ->>>>>>> origin/master false false true + true false false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= ->>>>>>> origin/master 1 diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 4873dc0..7c8a278 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,7 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + basecommonapi.cpp \ biz_device_manage_serve.cpp \ check_data_manage_serve.cpp \ create_tasks_serve.cpp \ @@ -51,6 +52,7 @@ verifywindow.cpp HEADERS += \ + basecommonapi.h \ biz_device_manage_serve.h \ check_data_manage_serve.h \ create_tasks_serve.h \ diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user index 1e5887b..643d68a 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user @@ -1,18 +1,10 @@ -<<<<<<< HEAD - + EnvironmentId {2746248a-b112-4e0f-9ae0-9e61f2a42309} -======= - - - - EnvironmentId - {94e4c4a1-54d4-412c-b108-da01d63f0d97} ->>>>>>> origin/master ProjectExplorer.Project.ActiveTarget @@ -72,18 +64,14 @@ ProjectExplorer.Project.Target.0 - Desktop Qt 5.14.2 MinGW 32-bit - Desktop Qt 5.14.2 MinGW 32-bit - qt.qt5.5142.win32_mingw73_kit + Desktop Qt 5.14.2 MinGW 64-bit + Desktop Qt 5.14.2 MinGW 64-bit + qt.qt5.5142.win64_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug true @@ -131,11 +119,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release true @@ -183,11 +167,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile true @@ -307,13 +287,8 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - Qt4ProjectManager.Qt4RunConfiguration:D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro - D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro ->>>>>>> origin/master false @@ -324,11 +299,7 @@ false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug 1 @@ -336,18 +307,14 @@ ProjectExplorer.Project.Target.1 - Desktop Qt 5.14.2 MinGW 64-bit - Desktop Qt 5.14.2 MinGW 64-bit - qt.qt5.5142.win64_mingw73_kit + Desktop Qt 5.14.2 MinGW 32-bit + Desktop Qt 5.14.2 MinGW 32-bit + qt.qt5.5142.win32_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug true @@ -395,11 +362,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release true @@ -447,11 +410,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile true @@ -571,28 +530,19 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - - ProjectExplorer.CustomExecutableRunConfiguration - ->>>>>>> origin/master false false true + true false false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= ->>>>>>> origin/master 1 diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp new file mode 100644 index 0000000..4c41c4e --- /dev/null +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -0,0 +1,34 @@ +#include "basecommonapi.h" + +BaseCommonApi::BaseCommonApi() +{ + +} + +//获取部门任务数据 +QList BaseCommonApi::getAllData() { + QList result; + + DatabaseConnection *Conn=DatabaseConnection::getInstance(); + QSqlQuery query(Conn->getDatabase()); + //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 LEft JOIN sys_user user ON user.ID = bi.create_user_id"); + + while (query.next()) { + Dept Dept; + Dept.id = query.value("id").toString(); + Dept.sample_name = query.value("sample_name").toString(); + Dept.sample_model = query.value("sample_model").toString(); + Dept.help_instruction = query.value("help_instruction").toString(); + Dept.manufacture_no = query.value("manufacture_no").toString(); + Dept.manufacturer = query.value("manufacturer").toString(); + Dept.customer_name = query.value("customer_name").toString(); + Dept.FULL_NAME = query.value("FULL_NAME").toString(); + Dept.require_over_time = query.value("require_over_time").toString(); + Dept.is_urgent = query.value("is_urgent").toString(); + result.append(Dept); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 4873dc0..7c8a278 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,7 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + basecommonapi.cpp \ biz_device_manage_serve.cpp \ check_data_manage_serve.cpp \ create_tasks_serve.cpp \ @@ -51,6 +52,7 @@ verifywindow.cpp HEADERS += \ + basecommonapi.h \ biz_device_manage_serve.h \ check_data_manage_serve.h \ create_tasks_serve.h \ diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user index 1e5887b..643d68a 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user @@ -1,18 +1,10 @@ -<<<<<<< HEAD - + EnvironmentId {2746248a-b112-4e0f-9ae0-9e61f2a42309} -======= - - - - EnvironmentId - {94e4c4a1-54d4-412c-b108-da01d63f0d97} ->>>>>>> origin/master ProjectExplorer.Project.ActiveTarget @@ -72,18 +64,14 @@ ProjectExplorer.Project.Target.0 - Desktop Qt 5.14.2 MinGW 32-bit - Desktop Qt 5.14.2 MinGW 32-bit - qt.qt5.5142.win32_mingw73_kit + Desktop Qt 5.14.2 MinGW 64-bit + Desktop Qt 5.14.2 MinGW 64-bit + qt.qt5.5142.win64_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug true @@ -131,11 +119,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release true @@ -183,11 +167,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile true @@ -307,13 +287,8 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - Qt4ProjectManager.Qt4RunConfiguration:D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro - D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro ->>>>>>> origin/master false @@ -324,11 +299,7 @@ false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug 1 @@ -336,18 +307,14 @@ ProjectExplorer.Project.Target.1 - Desktop Qt 5.14.2 MinGW 64-bit - Desktop Qt 5.14.2 MinGW 64-bit - qt.qt5.5142.win64_mingw73_kit + Desktop Qt 5.14.2 MinGW 32-bit + Desktop Qt 5.14.2 MinGW 32-bit + qt.qt5.5142.win32_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug true @@ -395,11 +362,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release true @@ -447,11 +410,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile true @@ -571,28 +530,19 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - - ProjectExplorer.CustomExecutableRunConfiguration - ->>>>>>> origin/master false false true + true false false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= ->>>>>>> origin/master 1 diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp new file mode 100644 index 0000000..4c41c4e --- /dev/null +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -0,0 +1,34 @@ +#include "basecommonapi.h" + +BaseCommonApi::BaseCommonApi() +{ + +} + +//获取部门任务数据 +QList BaseCommonApi::getAllData() { + QList result; + + DatabaseConnection *Conn=DatabaseConnection::getInstance(); + QSqlQuery query(Conn->getDatabase()); + //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 LEft JOIN sys_user user ON user.ID = bi.create_user_id"); + + while (query.next()) { + Dept Dept; + Dept.id = query.value("id").toString(); + Dept.sample_name = query.value("sample_name").toString(); + Dept.sample_model = query.value("sample_model").toString(); + Dept.help_instruction = query.value("help_instruction").toString(); + Dept.manufacture_no = query.value("manufacture_no").toString(); + Dept.manufacturer = query.value("manufacturer").toString(); + Dept.customer_name = query.value("customer_name").toString(); + Dept.FULL_NAME = query.value("FULL_NAME").toString(); + Dept.require_over_time = query.value("require_over_time").toString(); + Dept.is_urgent = query.value("is_urgent").toString(); + result.append(Dept); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.h b/softwareDirectory/AutoVerScheme/basecommonapi.h new file mode 100644 index 0000000..0da7c9a --- /dev/null +++ b/softwareDirectory/AutoVerScheme/basecommonapi.h @@ -0,0 +1,32 @@ +#ifndef BASECOMMONAPI_H +#define BASECOMMONAPI_H +#include +#include +#include +#include +#include "QList" +#include "databaseconnection.h" + +class Dept { +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 BaseCommonApi +{ +public: + BaseCommonApi(); + + static QList getAllData(); +}; + +#endif // BASECOMMONAPI_H diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro index 4873dc0..7c8a278 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro @@ -18,6 +18,7 @@ #DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0 SOURCES += \ + basecommonapi.cpp \ biz_device_manage_serve.cpp \ check_data_manage_serve.cpp \ create_tasks_serve.cpp \ @@ -51,6 +52,7 @@ verifywindow.cpp HEADERS += \ + basecommonapi.h \ biz_device_manage_serve.h \ check_data_manage_serve.h \ create_tasks_serve.h \ diff --git a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user index 1e5887b..643d68a 100644 --- a/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user +++ b/softwareDirectory/AutoVerScheme/AutoVerScheme.pro.user @@ -1,18 +1,10 @@ -<<<<<<< HEAD - + EnvironmentId {2746248a-b112-4e0f-9ae0-9e61f2a42309} -======= - - - - EnvironmentId - {94e4c4a1-54d4-412c-b108-da01d63f0d97} ->>>>>>> origin/master ProjectExplorer.Project.ActiveTarget @@ -72,18 +64,14 @@ ProjectExplorer.Project.Target.0 - Desktop Qt 5.14.2 MinGW 32-bit - Desktop Qt 5.14.2 MinGW 32-bit - qt.qt5.5142.win32_mingw73_kit + Desktop Qt 5.14.2 MinGW 64-bit + Desktop Qt 5.14.2 MinGW 64-bit + qt.qt5.5142.win64_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug true @@ -131,11 +119,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release true @@ -183,11 +167,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile true @@ -307,13 +287,8 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - Qt4ProjectManager.Qt4RunConfiguration:D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro - D:/work/code/BJJZ/svntest/softwareDirectory/AutoVerScheme/AutoVerScheme.pro ->>>>>>> origin/master false @@ -324,11 +299,7 @@ false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug 1 @@ -336,18 +307,14 @@ ProjectExplorer.Project.Target.1 - Desktop Qt 5.14.2 MinGW 64-bit - Desktop Qt 5.14.2 MinGW 64-bit - qt.qt5.5142.win64_mingw73_kit + Desktop Qt 5.14.2 MinGW 32-bit + Desktop Qt 5.14.2 MinGW 32-bit + qt.qt5.5142.win32_mingw73_kit 0 0 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Debug true @@ -395,11 +362,7 @@ 2 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Release ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Release true @@ -447,11 +410,7 @@ 0 -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile -======= - D:/work/code/BJJZ/svntest/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Profile ->>>>>>> origin/master + D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_32_bit-Profile true @@ -571,28 +530,19 @@ 2 -<<<<<<< HEAD Qt4ProjectManager.Qt4RunConfiguration:D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro D:/dev/software/softwareDirectory/AutoVerScheme/AutoVerScheme.pro -======= - - ProjectExplorer.CustomExecutableRunConfiguration - ->>>>>>> origin/master false false true + true false false true -<<<<<<< HEAD - D:/dev/software/softwareDirectory/build-AutoVerScheme-Desktop_Qt_5_14_2_MinGW_64_bit-Debug -======= ->>>>>>> origin/master 1 diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp new file mode 100644 index 0000000..4c41c4e --- /dev/null +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -0,0 +1,34 @@ +#include "basecommonapi.h" + +BaseCommonApi::BaseCommonApi() +{ + +} + +//获取部门任务数据 +QList BaseCommonApi::getAllData() { + QList result; + + DatabaseConnection *Conn=DatabaseConnection::getInstance(); + QSqlQuery query(Conn->getDatabase()); + //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 LEft JOIN sys_user user ON user.ID = bi.create_user_id"); + + while (query.next()) { + Dept Dept; + Dept.id = query.value("id").toString(); + Dept.sample_name = query.value("sample_name").toString(); + Dept.sample_model = query.value("sample_model").toString(); + Dept.help_instruction = query.value("help_instruction").toString(); + Dept.manufacture_no = query.value("manufacture_no").toString(); + Dept.manufacturer = query.value("manufacturer").toString(); + Dept.customer_name = query.value("customer_name").toString(); + Dept.FULL_NAME = query.value("FULL_NAME").toString(); + Dept.require_over_time = query.value("require_over_time").toString(); + Dept.is_urgent = query.value("is_urgent").toString(); + result.append(Dept); + } + + return result; +} diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.h b/softwareDirectory/AutoVerScheme/basecommonapi.h new file mode 100644 index 0000000..0da7c9a --- /dev/null +++ b/softwareDirectory/AutoVerScheme/basecommonapi.h @@ -0,0 +1,32 @@ +#ifndef BASECOMMONAPI_H +#define BASECOMMONAPI_H +#include +#include +#include +#include +#include "QList" +#include "databaseconnection.h" + +class Dept { +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 BaseCommonApi +{ +public: + BaseCommonApi(); + + static QList getAllData(); +}; + +#endif // BASECOMMONAPI_H diff --git a/softwareDirectory/AutoVerScheme/depar_task.cpp b/softwareDirectory/AutoVerScheme/depar_task.cpp index ce3a5df..2e9af28 100644 --- a/softwareDirectory/AutoVerScheme/depar_task.cpp +++ b/softwareDirectory/AutoVerScheme/depar_task.cpp @@ -4,7 +4,8 @@ #include "InfoBase.h" #include "QStandardItemModel" //部门任务 -#include "depar_task_server.h" +//#include "depar_task_server.h" +#include "basecommonapi.h" Depar_Task::Depar_Task(QWidget *parent) : InfoBase(parent), @@ -69,12 +70,13 @@ void Depar_Task::Load() { //查询部门任务 获取DatabaseConnection对象 - DatabaseConnection *Conn=DatabaseConnection::getInstance(); - QSqlQuery query(Conn->getDatabase()); + //DatabaseConnection *Conn=DatabaseConnection::getInstance(); + //QSqlQuery query(Conn->getDatabase()); // 创建数据库管理器对象 - sloveCh dbManager; + //sloveCh dbManager; // 调用数据库管理器的函数获取数据 - QList data = dbManager.getAllData(); + //QList data = dbManager.getAllData(); + QList data = BaseCommonApi::getAllData(); int rowCount = 0; int row=0;