diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 805a395..3cc5c67 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -7,6 +7,59 @@ } QString BaseCommonApi::temporary_user_id="1640229293790650370"; QString BaseCommonApi::temporary_costomer_id="1692432193177047042"; + + +//sys_user表的id转换为measure_person_id 检定人id(meter_staff表id) +StaffInfo BaseCommonApi::ConvertStaffInfo(QString userId) +{ + StaffInfo result; + QSqlQuery query; + query.prepare("SELECT brsi.* from biz_resource_staff_info brsi " + " JOIN sys_user ON sys_user.ACCOUNT = brsi.account " + " WHERE sys_user.id = :userId "); + + query.bindValue(":userId", userId); + if (query.exec()) { + while (query.next()) { + StaffInfo info; + info.id = query.value("id").toString(); + info.account = query.value("account").toString(); + info.staff_no = query.value("staff_no").toString(); + info.staff_name = query.value("staff_name").toString(); + info.picture_file = query.value("picture_file").toString(); + info.id_card = query.value("id_card").toString(); + info.birthday = query.value("birthday").toString(); + info.native_place = query.value("native_place").toString(); + info.education = query.value("education").toString(); + info.record_date = query.value("record_date").toString(); + info.officer_no = query.value("officer_no").toString(); + info.gender = query.value("gender").toString(); + info.graduation_date = query.value("graduation_date").toString(); + info.nation = query.value("nation").toString(); + info.degree = query.value("degree").toString(); + info.dept_id = query.value("dept_id").toString(); + info.dept_name = query.value("dept_name").toString(); + info.station = query.value("station").toString(); + info.major = query.value("major").toString(); + info.certificate_number = query.value("certificate_number").toString(); + info.engage_date = query.value("engage_date").toString(); + info.working_age = query.value("working_age").toString(); + info.title_initial_date = query.value("title_initial_date").toString(); + info.remark = query.value("remark").toString(); + info.create_time = query.value("create_time").toDateTime(); + info.update_time = query.value("update_time").toDateTime(); + result=info; + } + }else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + //获取部门任务数据 QList BaseCommonApi::getAllData(QString deptId,QString status) { QList result; diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 805a395..3cc5c67 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -7,6 +7,59 @@ } QString BaseCommonApi::temporary_user_id="1640229293790650370"; QString BaseCommonApi::temporary_costomer_id="1692432193177047042"; + + +//sys_user表的id转换为measure_person_id 检定人id(meter_staff表id) +StaffInfo BaseCommonApi::ConvertStaffInfo(QString userId) +{ + StaffInfo result; + QSqlQuery query; + query.prepare("SELECT brsi.* from biz_resource_staff_info brsi " + " JOIN sys_user ON sys_user.ACCOUNT = brsi.account " + " WHERE sys_user.id = :userId "); + + query.bindValue(":userId", userId); + if (query.exec()) { + while (query.next()) { + StaffInfo info; + info.id = query.value("id").toString(); + info.account = query.value("account").toString(); + info.staff_no = query.value("staff_no").toString(); + info.staff_name = query.value("staff_name").toString(); + info.picture_file = query.value("picture_file").toString(); + info.id_card = query.value("id_card").toString(); + info.birthday = query.value("birthday").toString(); + info.native_place = query.value("native_place").toString(); + info.education = query.value("education").toString(); + info.record_date = query.value("record_date").toString(); + info.officer_no = query.value("officer_no").toString(); + info.gender = query.value("gender").toString(); + info.graduation_date = query.value("graduation_date").toString(); + info.nation = query.value("nation").toString(); + info.degree = query.value("degree").toString(); + info.dept_id = query.value("dept_id").toString(); + info.dept_name = query.value("dept_name").toString(); + info.station = query.value("station").toString(); + info.major = query.value("major").toString(); + info.certificate_number = query.value("certificate_number").toString(); + info.engage_date = query.value("engage_date").toString(); + info.working_age = query.value("working_age").toString(); + info.title_initial_date = query.value("title_initial_date").toString(); + info.remark = query.value("remark").toString(); + info.create_time = query.value("create_time").toDateTime(); + info.update_time = query.value("update_time").toDateTime(); + result=info; + } + }else { + qDebug() << "Query execution failed: " << query.lastError().text(); + } + + return result; +} + + + + //获取部门任务数据 QList BaseCommonApi::getAllData(QString deptId,QString status) { QList result; diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.h b/softwareDirectory/AutoVerScheme/basecommonapi.h index f5b81e4..74943d4 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.h +++ b/softwareDirectory/AutoVerScheme/basecommonapi.h @@ -761,6 +761,37 @@ QDateTime create_time; QDateTime update_time; }; +//资源管理-人员管理基础信息 +class StaffInfo +{ +public: + QString id; + QString account;//登录账号 + QString staff_no;//人员编号 + QString staff_name;//姓名 + QString picture_file;//照片 + QString id_card;//身份证 + QString birthday;//生日 + QString native_place;//籍贯 + QString education;//学历 + QString record_date;//建档时间 + QString officer_no;//军官证号 + QString gender;//新别 + QString graduation_date;//毕业时间 + QString nation;//民族 + QString degree;//学位 + QString dept_id;//部门id + QString dept_name;//部门名字 + QString station;//岗位 + QString major;//计量专业 + QString certificate_number;//证号 + QString engage_date;//从事时间 + QString working_age;//干龄 + QString title_initial_date;//职称 初评 + QString remark;//备注 + QDateTime create_time; + QDateTime update_time; +}; @@ -785,6 +816,10 @@ //判断核查数据管理 结果信息表 static QList Search_VerifyDataTable(QString DeiverId,QString dataId,QStringList *HeadList); + //sys_user表的id转换为measure_person_id 检定人id(meter_staff表id) + static StaffInfo ConvertStaffInfo(QString userId); + + //部门任务 废弃 // static QList getAllData();