diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 23a675e..da45a7e 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -6493,9 +6493,9 @@ //核查程序管理-核查设置-多功能校准源 参数设备id 同信息管理-标准设备管理-核查项及核查点 -QMap> BaseCommonApi::getStandardCheckItemDataCalibrator(QString equipment_id,QMap *headList) +QMap>> BaseCommonApi::getStandardCheckItemDataCalibrator(QString equipment_id,QMap> *headList) { - QMap> DataMapList; + QMap>> DataMapList; QList resultData; QStringList result; resultData.clear(); @@ -6536,23 +6536,31 @@ return DataMapList; }; //【查询】核查项-多功能校准源 -QMap> BaseCommonApi::GetDataReturnItemListByCheckItemDataCalibrator(QList ResultData,QMap> DataMapList,QMap *headList) +QMap>> BaseCommonApi::GetDataReturnItemListByCheckItemDataCalibrator(QList ResultData,QMap>> DataMapList,QMap> *headList) { - QMap> result; + QMap>> result; + QMap> resultMap; QList DCVList; QList ACVList; QList DCIList; QList ACIList; QList RList; + QList DCVStableList; + QList ACVStableList; + QList DCIStableList; + QList ACIStableList; + QList RStableList; + QMap headerMap; for(const QStringList &row : ResultData){ QString VerificationItem=NULL; - if (!row.isEmpty() && row[5] == "DCV") { + if (!row.isEmpty() && row[5] == "DCV" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6571,13 +6579,16 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 DCVList.append(Data); - }else if (!row.isEmpty() && row[5] == "ACV") { + resultMap.insert("重复性",DCVList); +// resultMap.insert() + }else if (!row.isEmpty() && row[5] == "ACV"&& row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6596,13 +6607,15 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 ACVList.append(Data); - }else if (!row.isEmpty() && row[5] == "DCI" ) { + resultMap.insert("重复性",ACVList); + }else if (!row.isEmpty() && row[5] == "DCI" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6621,13 +6634,15 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 DCIList.append(Data); - }else if (!row.isEmpty() && row[5] == "ACI") { + resultMap.insert("重复性",DCIList); + }else if (!row.isEmpty() && row[5] == "ACI" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6646,13 +6661,15 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 ACIList.append(Data); - }else if (!row.isEmpty() && row[5] == "R") { + resultMap.insert("重复性",ACIList); + }else if (!row.isEmpty() && row[5] == "R" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6671,13 +6688,161 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 RList.append(Data); + resultMap.insert("重复性",RList); + } + if (!row.isEmpty() && row[5] == "DCV" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + DCVStableList.append(Data); + resultMap.insert("稳定性",DCVStableList); + }else if (!row.isEmpty() && row[5] == "ACV"&& row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + ACVStableList.append(Data); + resultMap.insert("稳定性",ACVStableList); + }else if (!row.isEmpty() && row[5] == "DCI" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + DCIStableList.append(Data); + resultMap.insert("稳定性",DCIStableList); + }else if (!row.isEmpty() && row[5] == "ACI" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + ACIStableList.append(Data); + resultMap.insert("稳定性",ACIStableList); + }else if (!row.isEmpty() && row[5] == "R" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + RStableList.append(Data); + resultMap.insert("稳定性",RStableList); } } - result.insert("DCV",DCVList); - result.insert("ACV",ACVList); - result.insert("DCI",DCIList); - result.insert("ACI",ACIList); - result.insert("R",RList); + + result.insert("ACV",resultMap); + result.insert("DCI",resultMap); + result.insert("ACI",resultMap); + result.insert("R",resultMap); + result.insert("DCV",resultMap); return result; } //【保存】核查数据-多功能校准源 @@ -6760,3 +6925,30 @@ } return isSuccess; } +//核查程序-标准装置-分类 +QList getStandardCheckItemCategory(QString item) +{ + QList result; + QSqlQuery query; + if(item == "") + query.prepare("SELECT * FROM biz_equipment_standard_check_item_category"); + else { + query.prepare("SELECT * FROM biz_equipment_standard_check_item_category WHERE belong_standard_equipment = :item "); + } + query.bindValue(":item",item); + if (query.exec()) { + while (query.next()) { + StandardCheckItemCategory category; + category.id = query.value("id").toString(); + category.category_no = query.value("category_no").toString(); + category.category_name = query.value("category_name").toString(); + category.equipment_type = query.value("equipment_type").toString(); + category.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + category.belong_standard_equipment_name = query.value("belong_standard_equipment_name").toString(); + result.append(category); + } + }else { + qDebug()<> BaseCommonApi::getStandardCheckItemDataCalibrator(QString equipment_id,QMap *headList) +QMap>> BaseCommonApi::getStandardCheckItemDataCalibrator(QString equipment_id,QMap> *headList) { - QMap> DataMapList; + QMap>> DataMapList; QList resultData; QStringList result; resultData.clear(); @@ -6536,23 +6536,31 @@ return DataMapList; }; //【查询】核查项-多功能校准源 -QMap> BaseCommonApi::GetDataReturnItemListByCheckItemDataCalibrator(QList ResultData,QMap> DataMapList,QMap *headList) +QMap>> BaseCommonApi::GetDataReturnItemListByCheckItemDataCalibrator(QList ResultData,QMap>> DataMapList,QMap> *headList) { - QMap> result; + QMap>> result; + QMap> resultMap; QList DCVList; QList ACVList; QList DCIList; QList ACIList; QList RList; + QList DCVStableList; + QList ACVStableList; + QList DCIStableList; + QList ACIStableList; + QList RStableList; + QMap headerMap; for(const QStringList &row : ResultData){ QString VerificationItem=NULL; - if (!row.isEmpty() && row[5] == "DCV") { + if (!row.isEmpty() && row[5] == "DCV" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6571,13 +6579,16 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 DCVList.append(Data); - }else if (!row.isEmpty() && row[5] == "ACV") { + resultMap.insert("重复性",DCVList); +// resultMap.insert() + }else if (!row.isEmpty() && row[5] == "ACV"&& row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6596,13 +6607,15 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 ACVList.append(Data); - }else if (!row.isEmpty() && row[5] == "DCI" ) { + resultMap.insert("重复性",ACVList); + }else if (!row.isEmpty() && row[5] == "DCI" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6621,13 +6634,15 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 DCIList.append(Data); - }else if (!row.isEmpty() && row[5] == "ACI") { + resultMap.insert("重复性",DCIList); + }else if (!row.isEmpty() && row[5] == "ACI" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6646,13 +6661,15 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 ACIList.append(Data); - }else if (!row.isEmpty() && row[5] == "R") { + resultMap.insert("重复性",ACIList); + }else if (!row.isEmpty() && row[5] == "R" && row[3].contains("重复性")) { VerificationItem = row[5]; //添加列头 QStringList head; head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5"<<"示值6"<<"算数平均值" <<"标准偏差S(X)"<<"相对重复性" ; - headList->insert(VerificationItem,head); + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); //添加数据 QStringList Data; Data.append(row[0]); //ID @@ -6671,13 +6688,161 @@ Data.append("");//标准偏差S(X) Data.append("");//相对重复性 RList.append(Data); + resultMap.insert("重复性",RList); + } + if (!row.isEmpty() && row[5] == "DCV" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + DCVStableList.append(Data); + resultMap.insert("稳定性",DCVStableList); + }else if (!row.isEmpty() && row[5] == "ACV"&& row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + ACVStableList.append(Data); + resultMap.insert("稳定性",ACVStableList); + }else if (!row.isEmpty() && row[5] == "DCI" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + DCIStableList.append(Data); + resultMap.insert("稳定性",DCIStableList); + }else if (!row.isEmpty() && row[5] == "ACI" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + ACIStableList.append(Data); + resultMap.insert("稳定性",ACIStableList); + }else if (!row.isEmpty() && row[5] == "R" && row[3].contains("稳定性")) { + VerificationItem = row[5]; + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + <<"标准偏差S(X)"<<"相对重复性" <<"Urel"<<"相对重复性是否小于相对扩展不确定度Urel"; + headerMap.insert(row[3],head); + headList->insert(row[5],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(VerificationItem); //检定项目 + Data.append(row[9]);//核查点 + Data.append(row[3]);//核查类型 + Data.append(row[4]);//核查点类型 + Data.append(row[10] + row[7]);//单位(频率) + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");// + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + Data.append(row[12]);//Urel + Data.append("");//相对重复性是否小于相对扩展不确定度Urel + RStableList.append(Data); + resultMap.insert("稳定性",RStableList); } } - result.insert("DCV",DCVList); - result.insert("ACV",ACVList); - result.insert("DCI",DCIList); - result.insert("ACI",ACIList); - result.insert("R",RList); + + result.insert("ACV",resultMap); + result.insert("DCI",resultMap); + result.insert("ACI",resultMap); + result.insert("R",resultMap); + result.insert("DCV",resultMap); return result; } //【保存】核查数据-多功能校准源 @@ -6760,3 +6925,30 @@ } return isSuccess; } +//核查程序-标准装置-分类 +QList getStandardCheckItemCategory(QString item) +{ + QList result; + QSqlQuery query; + if(item == "") + query.prepare("SELECT * FROM biz_equipment_standard_check_item_category"); + else { + query.prepare("SELECT * FROM biz_equipment_standard_check_item_category WHERE belong_standard_equipment = :item "); + } + query.bindValue(":item",item); + if (query.exec()) { + while (query.next()) { + StandardCheckItemCategory category; + category.id = query.value("id").toString(); + category.category_no = query.value("category_no").toString(); + category.category_name = query.value("category_name").toString(); + category.equipment_type = query.value("equipment_type").toString(); + category.belong_standard_equipment = query.value("belong_standard_equipment").toString(); + category.belong_standard_equipment_name = query.value("belong_standard_equipment_name").toString(); + result.append(category); + } + }else { + qDebug()< getStandardCheckItemCategory(QString item); @@ -1707,8 +1721,8 @@ //【保存】核查基本信息 static bool InsertStandardCheckInfo(StandardCheckInfo info); //【查询】核查项-多功能校准源 - static QMap> getStandardCheckItemDataCalibrator(QString equipment_id,QMap *headList); - static QMap> GetDataReturnItemListByCheckItemDataCalibrator(QList ResultData,QMap> DataMapList,QMap *headList); + static QMap>> getStandardCheckItemDataCalibrator(QString equipment_id,QMap> *headList); + static QMap>> GetDataReturnItemListByCheckItemDataCalibrator(QList ResultData,QMap>> DataMapList,QMap> *headList); //【保存】核查数据-多功能校准源 static bool InsertStandardCheckDataCalibrator(StandardCheckDataCalibrator calibrator); };