建表
5_EOL_20210712.csv
"sid","des","value"
"name","名称","EOL1"
"sn","编号","eol1"
"k1","产线编码","line"
"k2","pack编码","psn"
"k3","设备编码","esn"
"k4","用户标识","usn"
"k5","条码","BoxCode"
"k6","测试结果","TestResult"
"k7","工站名","StationID"
"k8","开始时间","StartDate"
"k9","结束时间","EndDate"
"k10","测试步骤","Step"
"k11","测试项名称","Instructions"
"k12","测试值","Value"
"k13","判断标准","Judgment"
"k14","判断结果","Ispass"
"k15","单位","Unit"
5_EOL_直接保存到线级MES
{
"psn": "psn001",
"wsn": "wsn001",
"usn": "rp888",
"esn001.eol1": [{
"BoxCode": "08IPBBC002FD9AB6L0100011",
"TestResult": "FAIL",
"StationID": "OP210-1",
"StartDate": "20210710143747",
"EndDate": "20210710143815",
"Step": "002.继电器功能检测",
"Instructions": "继电器U1",
"Value": "0.00",
"Judgment": "(U1<=1)",
"Ispass": "PASS",
"Unit": "V"
}, {
"BoxCode": "08IPBBC002FD9AB6L0100011",
"TestResult": "FAIL",
"StationID": "OP210-1",
"StartDate": "20210710143747",
"EndDate": "20210710143815",
"Step": "002.继电器功能检测",
"Instructions": "继电器U2",
"Value": "0.00",
"Judgment": "(U2>=320)",
"Ispass": "FAIL[0.0004185642>=320]",
"Unit": "V"
}]
}
保存成功
下面写接口
eol 1
{
"BoxCode": "08IPBBC002FD9AB6L0100011",
"TestResult": "FAIL",
"StationID": "OP210-1",
"StartDate": "20210710143747",
"EndDate": "20210710143815",
"Dlist": [{
"Step": "002.继电器功能检测",
"Instructions": "继电器U1",
"Value": "0.00",
"Judgment": "(U1<=1)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "002.继电器功能检测",
"Instructions": "继电器U2",
"Value": "0.00",
"Judgment": "(U2>=320)",
"Ispass": "FAIL[0.0004185642>=320]",
"Unit": "V"
}]
}
eol 2
{
"BoxCode": "08IPBN80021E4AB5F0100003",
"TestResult": "PASS",
"StationID": "OP100",
"StartDate": "20210602194655",
"EndDate": "20210602195003",
"Dlist": [{
"Step": "004.BMS绝缘检测",
"Instructions": "BMS绝缘阻值",
"Value": "60.127",
"Judgment": "(BMS绝缘阻值>=2)",
"Ispass": "PASS",
"Unit": "MΩ"
}, {
"Step": "004.BMS绝缘检测",
"Instructions": "BMS绝缘阻值",
"Value": "0.988",
"Judgment": "(BMS绝缘阻值>=0.9 && BMS绝缘阻值<=1.1)",
"Ispass": "PASS",
"Unit": "MΩ"
}, {
"Step": "005.等电位测试",
"Instructions": "R",
"Value": "0.02",
"Judgment": "(查询测试电阻结果<=0.1)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "006.高压互锁检测",
"Instructions": "MBCU_Err_HVIL_A",
"Value": "1",
"Judgment": "(MBCU_Err_HVIL_A=1)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "006.高压互锁检测",
"Instructions": "MBCU_Err_HVIL_A",
"Value": "0",
"Judgment": "(MBCU_Err_HVIL_A=0)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "007.唤醒检测",
"Instructions": "ON档唤醒MBCU_KeyFlag",
"Value": "2",
"Judgment": "(MBCU_KeyFlag=2)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "007.唤醒检测",
"Instructions": "快充唤醒MBCU_KeyFlag",
"Value": "6",
"Judgment": "(MBCU_KeyFlag>=4)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "008.CC2通讯检测",
"Instructions": "低压电U1",
"Value": "11.5011713",
"Judgment": "(U>=10.8 && U<=13.2)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "009.CAN通讯检测",
"Instructions": "BMS_Voltage",
"Value": "330",
"Judgment": "(BMS_Voltage>280)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "009.CAN通讯检测",
"Instructions": "MBCU_Bcu_Temper1",
"Value": "25.0",
"Judgment": "(MBCU_Bcu_Temper1>=24 && MBCU_Bcu_Temper1<=27)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "009.CAN通讯检测",
"Instructions": "cc2",
"Value": "1",
"Judgment": "(cc2>0)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "010.继电器功能检测",
"Instructions": "继电器U1",
"Value": "0.11",
"Judgment": "(U1<=1)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "010.继电器功能检测",
"Instructions": "继电器U2",
"Value": "329.95",
"Judgment": "(U2>=320)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "010.继电器功能检测",
"Instructions": "继电器U3",
"Value": "329.97",
"Judgment": "(U3>=320)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "011.快充继电器控制检测",
"Instructions": "快充继电器U1",
"Value": "-0.05",
"Judgment": "(U1<=1 && U1>=-1)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "011.快充继电器控制检测",
"Instructions": "快充继电器U2",
"Value": "11.51",
"Judgment": "(U2>=10.8 && U2<=13.2)",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "012.碰撞信号检测",
"Instructions": "MBCU_Ctr_DI3",
"Value": "0",
"Judgment": "(MBCU_Ctr_DI3=0)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "012.碰撞信号检测",
"Instructions": "MBCU_Ctr_DI3",
"Value": "1",
"Judgment": "(MBCU_Ctr_DI3=1)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "013.电芯电压",
"Instructions": "电芯数量",
"Value": "100",
"Judgment": "(电芯数量=100)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "013.电芯电压",
"Instructions": "MaxCellV",
"Value": "3.301",
"Judgment": "",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "013.电芯电压",
"Instructions": "MinCellV",
"Value": "3.297",
"Judgment": "",
"Ispass": "PASS",
"Unit": "V"
}, {
"Step": "013.电芯电压",
"Instructions": "电芯压差",
"Value": "4.0",
"Judgment": "(电芯压差<=5)",
"Ispass": "PASS",
"Unit": "mv"
}, {
"Step": "014.电芯温度",
"Instructions": "Tamb",
"Value": "23.1",
"Judgment": "(温度>=10 && 温度<=35)",
"Ispass": "PASS",
"Unit": "℃"
}, {
"Step": "014.电芯温度",
"Instructions": "温感数量",
"Value": "40",
"Judgment": "(温感数量=40)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "014.电芯温度",
"Instructions": "Tmax",
"Value": "25.0",
"Judgment": "(BMS_MaxBattTemp>=10 && BMS_MaxBattTemp<=35)",
"Ispass": "PASS",
"Unit": "℃"
}, {
"Step": "014.电芯温度",
"Instructions": "Tmin",
"Value": "25.0",
"Judgment": "(BMS_MinBattTemp>=10 && BMS_MinBattTemp<=35)",
"Ispass": "PASS",
"Unit": "℃"
}, {
"Step": "014.电芯温度",
"Instructions": "电芯温差",
"Value": "0",
"Judgment": "(电芯温差<=2)",
"Ispass": "PASS",
"Unit": "℃"
}, {
"Step": "014.电芯温度",
"Instructions": "最高与环境温度差",
"Value": "1.9",
"Judgment": "(最高与环境温度差<=2)",
"Ispass": "PASS",
"Unit": "℃"
}, {
"Step": "014.电芯温度",
"Instructions": "最低与环境温度差",
"Value": "1.9",
"Judgment": "(最低与环境温度差<=2)",
"Ispass": "PASS",
"Unit": "℃"
}, {
"Step": "015.充电座温度",
"Instructions": "T1",
"Value": "25",
"Judgment": "(MBCU_Bcu_Temper1>=24 && MBCU_Bcu_Temper1<=26)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "015.充电座温度",
"Instructions": "T2",
"Value": "25",
"Judgment": "(MBCU_Bcu_Temper2>=24 && MBCU_Bcu_Temper2<=26)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "015.充电座温度",
"Instructions": "T3",
"Value": "-40",
"Judgment": "(MBCU_Bcu_Temper1=-40)",
"Ispass": "PASS",
"Unit": ""
}, {
"Step": "015.充电座温度",
"Instructions": "T4",
"Value": "-40",
"Judgment": "(MBCU_Bcu_Temper2=-40)",
"Ispass": "PASS",
"Unit": ""
}]
}