diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 21f2e96..27d8249 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -108,7 +108,7 @@ bool SysUserLoginByCount(QString account,QString password=nullptr){ QSqlQuery query; - query.prepare("SELECT count(*) as num FROM sys_user" + query.prepare("SELECT count(*) as num FROM sys_user" " WHERE ACCOUNT = :account "); query.bindValue(":account",account); bool isSuccess = query.exec(); @@ -7310,7 +7310,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7340,7 +7340,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7370,7 +7370,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7400,7 +7400,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7876,6 +7876,12 @@ } QMap>> BaseCommonApi::GetDataReturnItemListByCheckItemDataDcPower(QList ResultData,QMap>> DataMapList,QMap> *headList) { + QString data6 = QDate::currentDate().addDays(-5).toString("yyyy年MM月dd日"); + QString data5 = QDate::currentDate().addDays(-4).toString("yyyy年MM月dd日"); + QString data4 = QDate::currentDate().addDays(-3).toString("yyyy年MM月dd日"); + QString data3 = QDate::currentDate().addDays(-2).toString("yyyy年MM月dd日"); + QString data2 = QDate::currentDate().addDays(-1).toString("yyyy年MM月dd日"); + QString data1 = QDate::currentDate().toString("yyyy年MM月dd日"); QMap>> result; QMap> resultMap; QList DCVoltageList; @@ -8031,8 +8037,7 @@ if (!row.isEmpty() && row[3] == "1" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("直流电压",headerMap); //添加数据 @@ -8059,8 +8064,7 @@ }else if (!row.isEmpty() && row[3] == "2" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("电源效应和负载效应",headerMap); //添加数据 @@ -8087,8 +8091,7 @@ }else if (!row.isEmpty() && row[3] == "3" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("直接电流(直接测量)",headerMap); //添加数据 @@ -8115,8 +8118,7 @@ }else if (!row.isEmpty() && row[3] == "4" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"电阻值"<<"核查参数"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"电阻值"<<"核查参数"<<"单位"<insert("直接电流(间接测量)",headerMap); //添加数据 @@ -8145,8 +8147,7 @@ }else if (!row.isEmpty() && row[3] == "5" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"频率"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"频率"<insert("纹波电压",headerMap); //添加数据 @@ -8235,3 +8236,560 @@ return isSuccess; } + +QMap>> BaseCommonApi::getStandardCheckItemDataSignalGenerator(QString equipment_id,QMap> *headList) +{ + QMap>> DataMapList; + QList resultData; + QStringList result; + resultData.clear(); + QSqlQuery query; + query.prepare("SELECT * FROM biz_equipment_standard_check_item_data_signal_generator " + " WHERE equipment_id = :equipment_id"); + query.bindValue(":equipment_id", equipment_id); + if (query.exec()) { + while (query.next()) { + result.clear(); + result.append(query.value("id").toString()); + result.append(query.value("item_category_id").toString());//核查项分类id(能够确定是哪个标准装置) + result.append(query.value("equipment_id").toString());//配套设备id + result.append(query.value("params").toString());//核查项目(直接存字典value) + result.append(query.value("check_point").toString());//频率点(字典value) + result.append(query.value("unit").toString());//频率点单位(字典value) + result.append(query.value("urel").toString());//U(k=2) + result.append(query.value("amplitude").toString());//幅度 + result.append(query.value("amplitude_unit").toString());//幅度单位(字典value) + result.append(query.value("power").toString());//功率(字典value) + result.append(query.value("power_unit").toString());//功率单位(字典value) 10 + result.append(query.value("relative_level").toString());//相对电平(字典value) + result.append(query.value("relative_level_unit").toString());//相对电平单位(字典value) + result.append(query.value("cycle_number").toString());//循环次数 + result.append(query.value("check_type").toString());//核查类型(字典value) + result.append(query.value("modulation").toString());//调幅度 15 + result.append(query.value("high_pass_filter").toString());//高通滤波 + result.append(query.value("high_pass_filter_unit").toString());//高通滤波单位 + result.append(query.value("lower_pass_filter").toString());//低通滤波 + result.append(query.value("lower_pass_filter_unit").toString());//低通滤波单位 + result.append(query.value("modulation_rate").toString());//调制速率 + result.append(query.value("modulation_rate_unit").toString());//调制速率单位 + result.append(query.value("frequency_deviation").toString());//调频频偏 + result.append(query.value("frequency_deviation_unit").toString());//调频频偏单位 + result.append(query.value("phase_deviation").toString());//调相相偏 + result.append(query.value("phase_deviation_unit").toString());//调相相偏单位 + result.append(query.value("rbw_value").toString());//RBW 26 + result.append(query.value("rbw_value_unit").toString());//RBW单位 + result.append(query.value("vbw_value").toString());//VBW + result.append(query.value("vbw_value_unit").toString());//VBW单位 + result.append(query.value("remark").toString());//核查项备注 + result.append(query.value("create_time").toString()); + result.append(query.value("update_time").toString()); + resultData.append(result); + } + }else { + qDebug()<>> BaseCommonApi::GetDataReturnItemListByCheckItemDataSignalGenerator(QList ResultData,QMap>> DataMapList,QMap> *headList) +{ + QString data = QDate::currentDate().toString("yyyy年MM月dd日"); + QMap>> result; + QMap> resultMap; + QList FrequencyList; + QList PowerList; + QList RelativeLevelList; + QList RangeList; + QList FrequencyOffsetList; + QList HarmonicList; + QList PhaseDeviationList; + QList FrequencyStableList; + QList PowerStableList; + QList RelativeLevelStableList; + QList RangeStableList; + QList FrequencyOffsetStableList; + QList HarmonicStableList; + QList PhaseDeviationStableList; + QMap headerMap; + for(const QStringList &row : ResultData){ + QString VerificationItem=NULL; + if (!row.isEmpty() && row[3] == "频率" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"幅度"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + FrequencyList.append(Data); + resultMap.insert("重复性",FrequencyList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "功率"&& row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"功率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[9] + row[10]);//功率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + PowerList.append(Data); + resultMap.insert("重复性",PowerList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "相对电平"&& row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"相对电平"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[11] + row[12]);//相对电平 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + RelativeLevelList.append(Data); + resultMap.insert("重复性",RelativeLevelList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调幅度" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调幅度"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[15]);//调幅度 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + RangeList.append(Data); + resultMap.insert("重复性",RangeList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调频频偏" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调频频偏"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[22] + row[23]);//调频频偏 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + FrequencyOffsetList.append(Data); + resultMap.insert("重复性",FrequencyOffsetList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "谐波" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"幅度"<<"RBW"<<"VBW"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[26] + row[27]);//RBW + Data.append(row[28] + row[29]);//VBW + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + HarmonicList.append(Data); + resultMap.insert("重复性",HarmonicList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调相相偏" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调相相偏"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[24] + row[25]);//调相相偏 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + PhaseDeviationList.append(Data); + resultMap.insert("重复性",PhaseDeviationList); + result.insert(row[3],resultMap); + } + if (!row.isEmpty() && row[3] == "频率" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + FrequencyStableList.append(Data); + resultMap.insert("稳定性",FrequencyStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "功率"&& row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"功率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[9] + row[10]);//功率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + PowerStableList.append(Data); + resultMap.insert("稳定性",PowerStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "相对电平"&& row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"相对电平"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[11] + row[12]);//相对电平 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + RelativeLevelStableList.append(Data); + resultMap.insert("稳定性",RelativeLevelStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调幅度" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调幅度"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[15]);//调幅度 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + RangeStableList.append(Data); + resultMap.insert("稳定性",RangeStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调频频偏" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调频频偏"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[22] + row[23]);//调频频偏 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + FrequencyOffsetStableList.append(Data); + resultMap.insert("稳定性",FrequencyOffsetStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "谐波" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + HarmonicStableList.append(Data); + resultMap.insert("稳定性",HarmonicStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调相相偏" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调相相偏"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[24] + row[25]);//调相相偏 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + PhaseDeviationStableList.append(Data); + resultMap.insert("稳定性",PhaseDeviationStableList); + result.insert(row[3],resultMap); + } + } + return result; +} +//【保存】核查数据-信号发生器 +bool InsertStandardCheckItemDataSignalGenerator(StandardCheckItemDataSignalGenerator signalGenerator) +{ + QSqlQuery query; + query.prepare("INSERT INTO biz_equipment_standard_check_data_signal_generator (" + " id, data_id, check_type, params, check_point, unit, power, power_unit, relative_level, relative_level_unit, " + " modulation, frequency_deviation, frequency_deviation_unit, phase_deviation, phase_deviation_unit, " + " average_value, test_value_one_date, test_value_one, test_value_two_date, test_value_two, " + " test_value_three_date, test_value_three, test_value_four_date, test_value_four, test_value_five_date," + " test_value_five, test_value_six_date, test_value_six, test_value_seven_date, test_value_seven, " + " test_value_eight_date, test_value_eight, test_value_nine_date, test_value_nine, test_value_ten_date, " + " test_value_ten, standard_deviation, urel, less_than, stability, qualified, create_time, update_time" + " ) VALUES ( :id, :data_id, :check_type, :params, :check_point, :unit, :power, :power_unit, :relative_level, " + " :relative_level_unit, :modulation, :frequency_deviation, :frequency_deviation_unit, :phase_deviation, " + " :phase_deviation_unit, :average_value, :test_value_one_date, :test_value_one, :test_value_two_date, " + " :test_value_two, :test_value_three_date, :test_value_three, :test_value_four_date, :test_value_four, " + " :test_value_five_date, :test_value_five, :test_value_six_date, :test_value_six, :test_value_seven_date, " + " :test_value_seven, :test_value_eight_date, :test_value_eight, :test_value_nine_date, :test_value_nine, " + " :test_value_ten_date, :test_value_ten, :standard_deviation, :urel, :less_than, :stability, :qualified, " + " :create_time, :update_time" + " );"); + query.bindValue(":id", signalGenerator.id); + query.bindValue(":data_id", signalGenerator.data_id); + query.bindValue(":check_type", signalGenerator.check_type); + query.bindValue(":params", signalGenerator.params); + query.bindValue(":check_point", signalGenerator.check_point); + query.bindValue(":unit", signalGenerator.unit); + query.bindValue(":power", signalGenerator.power); + query.bindValue(":power_unit", signalGenerator.power_unit); + query.bindValue(":relative_level", signalGenerator.relative_level); + query.bindValue(":relative_level_unit", signalGenerator.relative_level_unit); + query.bindValue(":modulation", signalGenerator.modulation); + query.bindValue(":frequency_deviation", signalGenerator.frequency_deviation); + query.bindValue(":frequency_deviation_unit", signalGenerator.frequency_deviation_unit); + query.bindValue(":phase_deviation", signalGenerator.phase_deviation); + query.bindValue(":phase_deviation_unit", signalGenerator.phase_deviation_unit); + query.bindValue(":average_value", signalGenerator.average_value); + query.bindValue(":test_value_one_date", signalGenerator.test_value_one_date); + query.bindValue(":test_value_one", signalGenerator.test_value_one); + query.bindValue(":test_value_two_date", signalGenerator.test_value_two_date); + query.bindValue(":test_value_two", signalGenerator.test_value_two); + query.bindValue(":test_value_three_date", signalGenerator.test_value_three_date); + query.bindValue(":test_value_three", signalGenerator.test_value_three); + query.bindValue(":test_value_four_date", signalGenerator.test_value_four_date); + query.bindValue(":test_value_four", signalGenerator.test_value_four); + query.bindValue(":test_value_five_date", signalGenerator.test_value_five_date); + query.bindValue(":test_value_five", signalGenerator.test_value_five); + query.bindValue(":test_value_six_date", signalGenerator.test_value_six_date); + query.bindValue(":test_value_six", signalGenerator.test_value_six); + query.bindValue(":test_value_seven_date", signalGenerator.test_value_seven_date); + query.bindValue(":test_value_seven", signalGenerator.test_value_seven); + query.bindValue(":test_value_eight_date", signalGenerator.test_value_eight_date); + query.bindValue(":test_value_eight", signalGenerator.test_value_eight); + query.bindValue(":test_value_nine_date", signalGenerator.test_value_nine_date); + query.bindValue(":test_value_nine", signalGenerator.test_value_nine); + query.bindValue(":test_value_ten_date", signalGenerator.test_value_ten_date); + query.bindValue(":test_value_ten", signalGenerator.test_value_ten); + query.bindValue(":standard_deviation", signalGenerator.standard_deviation); + query.bindValue(":urel", signalGenerator.urel); + query.bindValue(":less_than", signalGenerator.less_than); + query.bindValue(":stability", signalGenerator.stability); + query.bindValue(":qualified", signalGenerator.qualified); + query.bindValue(":create_time", signalGenerator.create_time); + query.bindValue(":update_time", signalGenerator.update_time); + bool isSuccess = query.exec(); + if(!isSuccess){ + qDebug()<insert(row[5],headerMap); @@ -7340,7 +7340,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7370,7 +7370,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7400,7 +7400,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7876,6 +7876,12 @@ } QMap>> BaseCommonApi::GetDataReturnItemListByCheckItemDataDcPower(QList ResultData,QMap>> DataMapList,QMap> *headList) { + QString data6 = QDate::currentDate().addDays(-5).toString("yyyy年MM月dd日"); + QString data5 = QDate::currentDate().addDays(-4).toString("yyyy年MM月dd日"); + QString data4 = QDate::currentDate().addDays(-3).toString("yyyy年MM月dd日"); + QString data3 = QDate::currentDate().addDays(-2).toString("yyyy年MM月dd日"); + QString data2 = QDate::currentDate().addDays(-1).toString("yyyy年MM月dd日"); + QString data1 = QDate::currentDate().toString("yyyy年MM月dd日"); QMap>> result; QMap> resultMap; QList DCVoltageList; @@ -8031,8 +8037,7 @@ if (!row.isEmpty() && row[3] == "1" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("直流电压",headerMap); //添加数据 @@ -8059,8 +8064,7 @@ }else if (!row.isEmpty() && row[3] == "2" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("电源效应和负载效应",headerMap); //添加数据 @@ -8087,8 +8091,7 @@ }else if (!row.isEmpty() && row[3] == "3" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("直接电流(直接测量)",headerMap); //添加数据 @@ -8115,8 +8118,7 @@ }else if (!row.isEmpty() && row[3] == "4" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"电阻值"<<"核查参数"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"电阻值"<<"核查参数"<<"单位"<insert("直接电流(间接测量)",headerMap); //添加数据 @@ -8145,8 +8147,7 @@ }else if (!row.isEmpty() && row[3] == "5" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"频率"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"频率"<insert("纹波电压",headerMap); //添加数据 @@ -8235,3 +8236,560 @@ return isSuccess; } + +QMap>> BaseCommonApi::getStandardCheckItemDataSignalGenerator(QString equipment_id,QMap> *headList) +{ + QMap>> DataMapList; + QList resultData; + QStringList result; + resultData.clear(); + QSqlQuery query; + query.prepare("SELECT * FROM biz_equipment_standard_check_item_data_signal_generator " + " WHERE equipment_id = :equipment_id"); + query.bindValue(":equipment_id", equipment_id); + if (query.exec()) { + while (query.next()) { + result.clear(); + result.append(query.value("id").toString()); + result.append(query.value("item_category_id").toString());//核查项分类id(能够确定是哪个标准装置) + result.append(query.value("equipment_id").toString());//配套设备id + result.append(query.value("params").toString());//核查项目(直接存字典value) + result.append(query.value("check_point").toString());//频率点(字典value) + result.append(query.value("unit").toString());//频率点单位(字典value) + result.append(query.value("urel").toString());//U(k=2) + result.append(query.value("amplitude").toString());//幅度 + result.append(query.value("amplitude_unit").toString());//幅度单位(字典value) + result.append(query.value("power").toString());//功率(字典value) + result.append(query.value("power_unit").toString());//功率单位(字典value) 10 + result.append(query.value("relative_level").toString());//相对电平(字典value) + result.append(query.value("relative_level_unit").toString());//相对电平单位(字典value) + result.append(query.value("cycle_number").toString());//循环次数 + result.append(query.value("check_type").toString());//核查类型(字典value) + result.append(query.value("modulation").toString());//调幅度 15 + result.append(query.value("high_pass_filter").toString());//高通滤波 + result.append(query.value("high_pass_filter_unit").toString());//高通滤波单位 + result.append(query.value("lower_pass_filter").toString());//低通滤波 + result.append(query.value("lower_pass_filter_unit").toString());//低通滤波单位 + result.append(query.value("modulation_rate").toString());//调制速率 + result.append(query.value("modulation_rate_unit").toString());//调制速率单位 + result.append(query.value("frequency_deviation").toString());//调频频偏 + result.append(query.value("frequency_deviation_unit").toString());//调频频偏单位 + result.append(query.value("phase_deviation").toString());//调相相偏 + result.append(query.value("phase_deviation_unit").toString());//调相相偏单位 + result.append(query.value("rbw_value").toString());//RBW 26 + result.append(query.value("rbw_value_unit").toString());//RBW单位 + result.append(query.value("vbw_value").toString());//VBW + result.append(query.value("vbw_value_unit").toString());//VBW单位 + result.append(query.value("remark").toString());//核查项备注 + result.append(query.value("create_time").toString()); + result.append(query.value("update_time").toString()); + resultData.append(result); + } + }else { + qDebug()<>> BaseCommonApi::GetDataReturnItemListByCheckItemDataSignalGenerator(QList ResultData,QMap>> DataMapList,QMap> *headList) +{ + QString data = QDate::currentDate().toString("yyyy年MM月dd日"); + QMap>> result; + QMap> resultMap; + QList FrequencyList; + QList PowerList; + QList RelativeLevelList; + QList RangeList; + QList FrequencyOffsetList; + QList HarmonicList; + QList PhaseDeviationList; + QList FrequencyStableList; + QList PowerStableList; + QList RelativeLevelStableList; + QList RangeStableList; + QList FrequencyOffsetStableList; + QList HarmonicStableList; + QList PhaseDeviationStableList; + QMap headerMap; + for(const QStringList &row : ResultData){ + QString VerificationItem=NULL; + if (!row.isEmpty() && row[3] == "频率" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"幅度"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + FrequencyList.append(Data); + resultMap.insert("重复性",FrequencyList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "功率"&& row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"功率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[9] + row[10]);//功率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + PowerList.append(Data); + resultMap.insert("重复性",PowerList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "相对电平"&& row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"相对电平"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[11] + row[12]);//相对电平 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + RelativeLevelList.append(Data); + resultMap.insert("重复性",RelativeLevelList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调幅度" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调幅度"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[15]);//调幅度 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + RangeList.append(Data); + resultMap.insert("重复性",RangeList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调频频偏" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调频频偏"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[22] + row[23]);//调频频偏 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + FrequencyOffsetList.append(Data); + resultMap.insert("重复性",FrequencyOffsetList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "谐波" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"幅度"<<"RBW"<<"VBW"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[26] + row[27]);//RBW + Data.append(row[28] + row[29]);//VBW + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + HarmonicList.append(Data); + resultMap.insert("重复性",HarmonicList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调相相偏" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调相相偏"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[24] + row[25]);//调相相偏 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + PhaseDeviationList.append(Data); + resultMap.insert("重复性",PhaseDeviationList); + result.insert(row[3],resultMap); + } + if (!row.isEmpty() && row[3] == "频率" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + FrequencyStableList.append(Data); + resultMap.insert("稳定性",FrequencyStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "功率"&& row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"功率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[9] + row[10]);//功率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + PowerStableList.append(Data); + resultMap.insert("稳定性",PowerStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "相对电平"&& row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"相对电平"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[11] + row[12]);//相对电平 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + RelativeLevelStableList.append(Data); + resultMap.insert("稳定性",RelativeLevelStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调幅度" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调幅度"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[15]);//调幅度 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + RangeStableList.append(Data); + resultMap.insert("稳定性",RangeStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调频频偏" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调频频偏"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[22] + row[23]);//调频频偏 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + FrequencyOffsetStableList.append(Data); + resultMap.insert("稳定性",FrequencyOffsetStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "谐波" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + HarmonicStableList.append(Data); + resultMap.insert("稳定性",HarmonicStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调相相偏" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调相相偏"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[24] + row[25]);//调相相偏 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + PhaseDeviationStableList.append(Data); + resultMap.insert("稳定性",PhaseDeviationStableList); + result.insert(row[3],resultMap); + } + } + return result; +} +//【保存】核查数据-信号发生器 +bool InsertStandardCheckItemDataSignalGenerator(StandardCheckItemDataSignalGenerator signalGenerator) +{ + QSqlQuery query; + query.prepare("INSERT INTO biz_equipment_standard_check_data_signal_generator (" + " id, data_id, check_type, params, check_point, unit, power, power_unit, relative_level, relative_level_unit, " + " modulation, frequency_deviation, frequency_deviation_unit, phase_deviation, phase_deviation_unit, " + " average_value, test_value_one_date, test_value_one, test_value_two_date, test_value_two, " + " test_value_three_date, test_value_three, test_value_four_date, test_value_four, test_value_five_date," + " test_value_five, test_value_six_date, test_value_six, test_value_seven_date, test_value_seven, " + " test_value_eight_date, test_value_eight, test_value_nine_date, test_value_nine, test_value_ten_date, " + " test_value_ten, standard_deviation, urel, less_than, stability, qualified, create_time, update_time" + " ) VALUES ( :id, :data_id, :check_type, :params, :check_point, :unit, :power, :power_unit, :relative_level, " + " :relative_level_unit, :modulation, :frequency_deviation, :frequency_deviation_unit, :phase_deviation, " + " :phase_deviation_unit, :average_value, :test_value_one_date, :test_value_one, :test_value_two_date, " + " :test_value_two, :test_value_three_date, :test_value_three, :test_value_four_date, :test_value_four, " + " :test_value_five_date, :test_value_five, :test_value_six_date, :test_value_six, :test_value_seven_date, " + " :test_value_seven, :test_value_eight_date, :test_value_eight, :test_value_nine_date, :test_value_nine, " + " :test_value_ten_date, :test_value_ten, :standard_deviation, :urel, :less_than, :stability, :qualified, " + " :create_time, :update_time" + " );"); + query.bindValue(":id", signalGenerator.id); + query.bindValue(":data_id", signalGenerator.data_id); + query.bindValue(":check_type", signalGenerator.check_type); + query.bindValue(":params", signalGenerator.params); + query.bindValue(":check_point", signalGenerator.check_point); + query.bindValue(":unit", signalGenerator.unit); + query.bindValue(":power", signalGenerator.power); + query.bindValue(":power_unit", signalGenerator.power_unit); + query.bindValue(":relative_level", signalGenerator.relative_level); + query.bindValue(":relative_level_unit", signalGenerator.relative_level_unit); + query.bindValue(":modulation", signalGenerator.modulation); + query.bindValue(":frequency_deviation", signalGenerator.frequency_deviation); + query.bindValue(":frequency_deviation_unit", signalGenerator.frequency_deviation_unit); + query.bindValue(":phase_deviation", signalGenerator.phase_deviation); + query.bindValue(":phase_deviation_unit", signalGenerator.phase_deviation_unit); + query.bindValue(":average_value", signalGenerator.average_value); + query.bindValue(":test_value_one_date", signalGenerator.test_value_one_date); + query.bindValue(":test_value_one", signalGenerator.test_value_one); + query.bindValue(":test_value_two_date", signalGenerator.test_value_two_date); + query.bindValue(":test_value_two", signalGenerator.test_value_two); + query.bindValue(":test_value_three_date", signalGenerator.test_value_three_date); + query.bindValue(":test_value_three", signalGenerator.test_value_three); + query.bindValue(":test_value_four_date", signalGenerator.test_value_four_date); + query.bindValue(":test_value_four", signalGenerator.test_value_four); + query.bindValue(":test_value_five_date", signalGenerator.test_value_five_date); + query.bindValue(":test_value_five", signalGenerator.test_value_five); + query.bindValue(":test_value_six_date", signalGenerator.test_value_six_date); + query.bindValue(":test_value_six", signalGenerator.test_value_six); + query.bindValue(":test_value_seven_date", signalGenerator.test_value_seven_date); + query.bindValue(":test_value_seven", signalGenerator.test_value_seven); + query.bindValue(":test_value_eight_date", signalGenerator.test_value_eight_date); + query.bindValue(":test_value_eight", signalGenerator.test_value_eight); + query.bindValue(":test_value_nine_date", signalGenerator.test_value_nine_date); + query.bindValue(":test_value_nine", signalGenerator.test_value_nine); + query.bindValue(":test_value_ten_date", signalGenerator.test_value_ten_date); + query.bindValue(":test_value_ten", signalGenerator.test_value_ten); + query.bindValue(":standard_deviation", signalGenerator.standard_deviation); + query.bindValue(":urel", signalGenerator.urel); + query.bindValue(":less_than", signalGenerator.less_than); + query.bindValue(":stability", signalGenerator.stability); + query.bindValue(":qualified", signalGenerator.qualified); + query.bindValue(":create_time", signalGenerator.create_time); + query.bindValue(":update_time", signalGenerator.update_time); + bool isSuccess = query.exec(); + if(!isSuccess){ + qDebug()<>> GetDataReturnItemListByCheckItemDataDcPower(QList ResultData,QMap>> DataMapList,QMap> *headList); //【保存】核查数据-直流稳压电源 static bool InsertStandardCheckItemDataDcPower(StandardCheckDataDcPower power); + + //【查询】核查项-信号发生器 + static QMap>> getStandardCheckItemDataSignalGenerator(QString equipment_id,QMap> *headList); + static QMap>> GetDataReturnItemListByCheckItemDataSignalGenerator(QList ResultData,QMap>> DataMapList,QMap> *headList); + //【保存】核查数据-信号发生器 + static bool InsertStandardCheckItemDataSignalGenerator(StandardCheckItemDataSignalGenerator signalGenerator); + //同步成功后更新检定项字段 static bool UpdateMeasureItemInfo(QString item_id); //配套设备关联表 diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 21f2e96..27d8249 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -108,7 +108,7 @@ bool SysUserLoginByCount(QString account,QString password=nullptr){ QSqlQuery query; - query.prepare("SELECT count(*) as num FROM sys_user" + query.prepare("SELECT count(*) as num FROM sys_user" " WHERE ACCOUNT = :account "); query.bindValue(":account",account); bool isSuccess = query.exec(); @@ -7310,7 +7310,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7340,7 +7340,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7370,7 +7370,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7400,7 +7400,7 @@ VerificationItem = row[5]; //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<<"示值"<<""<<""<<""<<""<<""<<"算数平均值" + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"核查点类型"<<"单位(频率)"<insert(row[5],headerMap); @@ -7876,6 +7876,12 @@ } QMap>> BaseCommonApi::GetDataReturnItemListByCheckItemDataDcPower(QList ResultData,QMap>> DataMapList,QMap> *headList) { + QString data6 = QDate::currentDate().addDays(-5).toString("yyyy年MM月dd日"); + QString data5 = QDate::currentDate().addDays(-4).toString("yyyy年MM月dd日"); + QString data4 = QDate::currentDate().addDays(-3).toString("yyyy年MM月dd日"); + QString data3 = QDate::currentDate().addDays(-2).toString("yyyy年MM月dd日"); + QString data2 = QDate::currentDate().addDays(-1).toString("yyyy年MM月dd日"); + QString data1 = QDate::currentDate().toString("yyyy年MM月dd日"); QMap>> result; QMap> resultMap; QList DCVoltageList; @@ -8031,8 +8037,7 @@ if (!row.isEmpty() && row[3] == "1" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("直流电压",headerMap); //添加数据 @@ -8059,8 +8064,7 @@ }else if (!row.isEmpty() && row[3] == "2" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("电源效应和负载效应",headerMap); //添加数据 @@ -8087,8 +8091,7 @@ }else if (!row.isEmpty() && row[3] == "3" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<insert("直接电流(直接测量)",headerMap); //添加数据 @@ -8115,8 +8118,7 @@ }else if (!row.isEmpty() && row[3] == "4" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"电阻值"<<"核查参数"<<"单位"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"电阻值"<<"核查参数"<<"单位"<insert("直接电流(间接测量)",headerMap); //添加数据 @@ -8145,8 +8147,7 @@ }else if (!row.isEmpty() && row[3] == "5" && row[9].contains("稳定性")) { //添加列头 QStringList head; - head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"频率"<<"示值1"<<"示值2"<<"示值3"<<"示值4"<<"示值5" - <<"示值6"<<"平均值"<<"标准偏差"<<"相对标准偏差"<<"相对扩展不确定度Urel"<<"相对标准偏差是否小于相对扩展不确定度Urel" ; + head <<"序号"<<"核查项目"<<"核查点"<<"核查类型"<<"单位"<<"频率"<insert("纹波电压",headerMap); //添加数据 @@ -8235,3 +8236,560 @@ return isSuccess; } + +QMap>> BaseCommonApi::getStandardCheckItemDataSignalGenerator(QString equipment_id,QMap> *headList) +{ + QMap>> DataMapList; + QList resultData; + QStringList result; + resultData.clear(); + QSqlQuery query; + query.prepare("SELECT * FROM biz_equipment_standard_check_item_data_signal_generator " + " WHERE equipment_id = :equipment_id"); + query.bindValue(":equipment_id", equipment_id); + if (query.exec()) { + while (query.next()) { + result.clear(); + result.append(query.value("id").toString()); + result.append(query.value("item_category_id").toString());//核查项分类id(能够确定是哪个标准装置) + result.append(query.value("equipment_id").toString());//配套设备id + result.append(query.value("params").toString());//核查项目(直接存字典value) + result.append(query.value("check_point").toString());//频率点(字典value) + result.append(query.value("unit").toString());//频率点单位(字典value) + result.append(query.value("urel").toString());//U(k=2) + result.append(query.value("amplitude").toString());//幅度 + result.append(query.value("amplitude_unit").toString());//幅度单位(字典value) + result.append(query.value("power").toString());//功率(字典value) + result.append(query.value("power_unit").toString());//功率单位(字典value) 10 + result.append(query.value("relative_level").toString());//相对电平(字典value) + result.append(query.value("relative_level_unit").toString());//相对电平单位(字典value) + result.append(query.value("cycle_number").toString());//循环次数 + result.append(query.value("check_type").toString());//核查类型(字典value) + result.append(query.value("modulation").toString());//调幅度 15 + result.append(query.value("high_pass_filter").toString());//高通滤波 + result.append(query.value("high_pass_filter_unit").toString());//高通滤波单位 + result.append(query.value("lower_pass_filter").toString());//低通滤波 + result.append(query.value("lower_pass_filter_unit").toString());//低通滤波单位 + result.append(query.value("modulation_rate").toString());//调制速率 + result.append(query.value("modulation_rate_unit").toString());//调制速率单位 + result.append(query.value("frequency_deviation").toString());//调频频偏 + result.append(query.value("frequency_deviation_unit").toString());//调频频偏单位 + result.append(query.value("phase_deviation").toString());//调相相偏 + result.append(query.value("phase_deviation_unit").toString());//调相相偏单位 + result.append(query.value("rbw_value").toString());//RBW 26 + result.append(query.value("rbw_value_unit").toString());//RBW单位 + result.append(query.value("vbw_value").toString());//VBW + result.append(query.value("vbw_value_unit").toString());//VBW单位 + result.append(query.value("remark").toString());//核查项备注 + result.append(query.value("create_time").toString()); + result.append(query.value("update_time").toString()); + resultData.append(result); + } + }else { + qDebug()<>> BaseCommonApi::GetDataReturnItemListByCheckItemDataSignalGenerator(QList ResultData,QMap>> DataMapList,QMap> *headList) +{ + QString data = QDate::currentDate().toString("yyyy年MM月dd日"); + QMap>> result; + QMap> resultMap; + QList FrequencyList; + QList PowerList; + QList RelativeLevelList; + QList RangeList; + QList FrequencyOffsetList; + QList HarmonicList; + QList PhaseDeviationList; + QList FrequencyStableList; + QList PowerStableList; + QList RelativeLevelStableList; + QList RangeStableList; + QList FrequencyOffsetStableList; + QList HarmonicStableList; + QList PhaseDeviationStableList; + QMap headerMap; + for(const QStringList &row : ResultData){ + QString VerificationItem=NULL; + if (!row.isEmpty() && row[3] == "频率" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"幅度"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + FrequencyList.append(Data); + resultMap.insert("重复性",FrequencyList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "功率"&& row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"功率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[9] + row[10]);//功率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + PowerList.append(Data); + resultMap.insert("重复性",PowerList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "相对电平"&& row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"相对电平"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[11] + row[12]);//相对电平 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + RelativeLevelList.append(Data); + resultMap.insert("重复性",RelativeLevelList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调幅度" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调幅度"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[15]);//调幅度 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + RangeList.append(Data); + resultMap.insert("重复性",RangeList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调频频偏" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调频频偏"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[22] + row[23]);//调频频偏 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + FrequencyOffsetList.append(Data); + resultMap.insert("重复性",FrequencyOffsetList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "谐波" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"幅度"<<"RBW"<<"VBW"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[26] + row[27]);//RBW + Data.append(row[28] + row[29]);//VBW + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//算数平均值 + Data.append("");//标准偏差S(X) + Data.append("");//相对重复性 + HarmonicList.append(Data); + resultMap.insert("重复性",HarmonicList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调相相偏" && row[14].contains("重复性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调相相偏"<<"幅度"<<"高通滤波"<<"低通滤波"<<"调制速率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<<"测量值6"<<"测量值7"<<"测量值8"<<"测量值9" + <<"测量值10"<<"平均值x"<<"重复性S(x)/x"; + headerMap.insert("重复性",head); + headList->insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[24] + row[25]);//调相相偏 + Data.append(row[7] + row[8]);//幅度 + Data.append(row[16] + row[17]);//高通滤波 + Data.append(row[18] + row[19]);//低通滤波 + Data.append(row[20] + row[21]);//调制速率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//测量值7 + Data.append("");//测量值8 + Data.append("");//测量值9 + Data.append("");//测量值10 + Data.append("");//平均值x + Data.append("");//重复性S(x)/x + PhaseDeviationList.append(Data); + resultMap.insert("重复性",PhaseDeviationList); + result.insert(row[3],resultMap); + } + if (!row.isEmpty() && row[3] == "频率" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + FrequencyStableList.append(Data); + resultMap.insert("稳定性",FrequencyStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "功率"&& row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"功率"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[9] + row[10]);//功率 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + PowerStableList.append(Data); + resultMap.insert("稳定性",PowerStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "相对电平"&& row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"相对电平"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[11] + row[12]);//相对电平 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + RelativeLevelStableList.append(Data); + resultMap.insert("稳定性",RelativeLevelStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调幅度" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调幅度"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[15]);//调幅度 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + RangeStableList.append(Data); + resultMap.insert("稳定性",RangeStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调频频偏" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调频频偏"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[22] + row[23]);//调频频偏 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + FrequencyOffsetStableList.append(Data); + resultMap.insert("稳定性",FrequencyOffsetStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "谐波" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + HarmonicStableList.append(Data); + resultMap.insert("稳定性",HarmonicStableList); + result.insert(row[3],resultMap); + }else if (!row.isEmpty() && row[3] == "调相相偏" && row[14].contains("稳定性")) { + //添加列头 + QStringList head; + head <<"序号"<<"核查项目"<<"频率点"<<"调相相偏"<<"核查类型"<<"测量值1"<<"测量值2"<<"测量值3"<<"测量值4"<<"测量值5"<insert(row[3],headerMap); + //添加数据 + QStringList Data; + Data.append(row[0]); //ID + Data.append(row[3]); //核查项目 + Data.append(row[4] + row[5]);//频率点 + Data.append(row[24] + row[25]);//调相相偏 + Data.append(row[14]); + Data.append("");//测量值1 + Data.append("");//测量值2 + Data.append("");//测量值3 + Data.append("");//测量值4 + Data.append("");//测量值5 + Data.append("");//测量值6 + Data.append("");//平均值 + Data.append("");//稳定性 + Data.append("");//U(k=2) + Data.append("");//结论 + PhaseDeviationStableList.append(Data); + resultMap.insert("稳定性",PhaseDeviationStableList); + result.insert(row[3],resultMap); + } + } + return result; +} +//【保存】核查数据-信号发生器 +bool InsertStandardCheckItemDataSignalGenerator(StandardCheckItemDataSignalGenerator signalGenerator) +{ + QSqlQuery query; + query.prepare("INSERT INTO biz_equipment_standard_check_data_signal_generator (" + " id, data_id, check_type, params, check_point, unit, power, power_unit, relative_level, relative_level_unit, " + " modulation, frequency_deviation, frequency_deviation_unit, phase_deviation, phase_deviation_unit, " + " average_value, test_value_one_date, test_value_one, test_value_two_date, test_value_two, " + " test_value_three_date, test_value_three, test_value_four_date, test_value_four, test_value_five_date," + " test_value_five, test_value_six_date, test_value_six, test_value_seven_date, test_value_seven, " + " test_value_eight_date, test_value_eight, test_value_nine_date, test_value_nine, test_value_ten_date, " + " test_value_ten, standard_deviation, urel, less_than, stability, qualified, create_time, update_time" + " ) VALUES ( :id, :data_id, :check_type, :params, :check_point, :unit, :power, :power_unit, :relative_level, " + " :relative_level_unit, :modulation, :frequency_deviation, :frequency_deviation_unit, :phase_deviation, " + " :phase_deviation_unit, :average_value, :test_value_one_date, :test_value_one, :test_value_two_date, " + " :test_value_two, :test_value_three_date, :test_value_three, :test_value_four_date, :test_value_four, " + " :test_value_five_date, :test_value_five, :test_value_six_date, :test_value_six, :test_value_seven_date, " + " :test_value_seven, :test_value_eight_date, :test_value_eight, :test_value_nine_date, :test_value_nine, " + " :test_value_ten_date, :test_value_ten, :standard_deviation, :urel, :less_than, :stability, :qualified, " + " :create_time, :update_time" + " );"); + query.bindValue(":id", signalGenerator.id); + query.bindValue(":data_id", signalGenerator.data_id); + query.bindValue(":check_type", signalGenerator.check_type); + query.bindValue(":params", signalGenerator.params); + query.bindValue(":check_point", signalGenerator.check_point); + query.bindValue(":unit", signalGenerator.unit); + query.bindValue(":power", signalGenerator.power); + query.bindValue(":power_unit", signalGenerator.power_unit); + query.bindValue(":relative_level", signalGenerator.relative_level); + query.bindValue(":relative_level_unit", signalGenerator.relative_level_unit); + query.bindValue(":modulation", signalGenerator.modulation); + query.bindValue(":frequency_deviation", signalGenerator.frequency_deviation); + query.bindValue(":frequency_deviation_unit", signalGenerator.frequency_deviation_unit); + query.bindValue(":phase_deviation", signalGenerator.phase_deviation); + query.bindValue(":phase_deviation_unit", signalGenerator.phase_deviation_unit); + query.bindValue(":average_value", signalGenerator.average_value); + query.bindValue(":test_value_one_date", signalGenerator.test_value_one_date); + query.bindValue(":test_value_one", signalGenerator.test_value_one); + query.bindValue(":test_value_two_date", signalGenerator.test_value_two_date); + query.bindValue(":test_value_two", signalGenerator.test_value_two); + query.bindValue(":test_value_three_date", signalGenerator.test_value_three_date); + query.bindValue(":test_value_three", signalGenerator.test_value_three); + query.bindValue(":test_value_four_date", signalGenerator.test_value_four_date); + query.bindValue(":test_value_four", signalGenerator.test_value_four); + query.bindValue(":test_value_five_date", signalGenerator.test_value_five_date); + query.bindValue(":test_value_five", signalGenerator.test_value_five); + query.bindValue(":test_value_six_date", signalGenerator.test_value_six_date); + query.bindValue(":test_value_six", signalGenerator.test_value_six); + query.bindValue(":test_value_seven_date", signalGenerator.test_value_seven_date); + query.bindValue(":test_value_seven", signalGenerator.test_value_seven); + query.bindValue(":test_value_eight_date", signalGenerator.test_value_eight_date); + query.bindValue(":test_value_eight", signalGenerator.test_value_eight); + query.bindValue(":test_value_nine_date", signalGenerator.test_value_nine_date); + query.bindValue(":test_value_nine", signalGenerator.test_value_nine); + query.bindValue(":test_value_ten_date", signalGenerator.test_value_ten_date); + query.bindValue(":test_value_ten", signalGenerator.test_value_ten); + query.bindValue(":standard_deviation", signalGenerator.standard_deviation); + query.bindValue(":urel", signalGenerator.urel); + query.bindValue(":less_than", signalGenerator.less_than); + query.bindValue(":stability", signalGenerator.stability); + query.bindValue(":qualified", signalGenerator.qualified); + query.bindValue(":create_time", signalGenerator.create_time); + query.bindValue(":update_time", signalGenerator.update_time); + bool isSuccess = query.exec(); + if(!isSuccess){ + qDebug()<>> GetDataReturnItemListByCheckItemDataDcPower(QList ResultData,QMap>> DataMapList,QMap> *headList); //【保存】核查数据-直流稳压电源 static bool InsertStandardCheckItemDataDcPower(StandardCheckDataDcPower power); + + //【查询】核查项-信号发生器 + static QMap>> getStandardCheckItemDataSignalGenerator(QString equipment_id,QMap> *headList); + static QMap>> GetDataReturnItemListByCheckItemDataSignalGenerator(QList ResultData,QMap>> DataMapList,QMap> *headList); + //【保存】核查数据-信号发生器 + static bool InsertStandardCheckItemDataSignalGenerator(StandardCheckItemDataSignalGenerator signalGenerator); + //同步成功后更新检定项字段 static bool UpdateMeasureItemInfo(QString item_id); //配套设备关联表 diff --git a/softwareDirectory/AutoVerScheme/indexwindow.cpp b/softwareDirectory/AutoVerScheme/indexwindow.cpp index e5b6727..3cd9a37 100644 --- a/softwareDirectory/AutoVerScheme/indexwindow.cpp +++ b/softwareDirectory/AutoVerScheme/indexwindow.cpp @@ -73,8 +73,9 @@ // ShowMessageBox("数据库连接","连接失败"); QMap>> a; QMap> headList; +// a = BaseCommonApi::getStandardCheckItemDataSignalGenerator("1752496970477416449",&headList); // a = BaseCommonApi::getStandardCheckItemDataCalibrator("1692808528303013889",&headList); - a = BaseCommonApi::getStandardCheckItemDataDcPower("1693435753272557570",&headList); +// a = BaseCommonApi::getStandardCheckItemDataDcPower("1693435753272557570",&headList); // qDebug()<<">"<> headList; // BaseCommonApi::getStandardCheckItemDataCalibrator("1748244089305845762",&headList);