2. AQL抽检数据
<p>[TOC]</p>
<h5>简要描述</h5>
<ul>
<li>AQL抽检数据</li>
</ul>
<h5>接口维护负责人：周智鸿</h5>
<h5>请求URL</h5>
<ul>
<li><code>http://172.17.10.52:8080/pyapi/AQL_list</code></li>
</ul>
<h5>请求方式</h5>
<ul>
<li>POST </li>
</ul>
<h5>请求参数</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th style="text-align: left;">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">CellNo</td>
<td style="text-align: left;">nvarhar</td>
<td style="text-align: left;">电芯条码</td>
</tr>
<tr>
<td style="text-align: left;">Mi</td>
<td style="text-align: left;">nvarhar</td>
<td style="text-align: left;">产品型号</td>
</tr>
<tr>
<td style="text-align: left;">ModelName</td>
<td style="text-align: left;">nvarchar</td>
<td style="text-align: left;">模型名称</td>
</tr>
<tr>
<td style="text-align: left;">StartDate</td>
<td style="text-align: left;">datetime</td>
<td style="text-align: left;">最小生产日期</td>
</tr>
<tr>
<td style="text-align: left;">EndDate</td>
<td style="text-align: left;">datetime</td>
<td style="text-align: left;">最大生产日期</td>
</tr>
<tr>
<td style="text-align: left;">OutPut</td>
<td style="text-align: left;">bool</td>
<td style="text-align: left;">是否导出接口</td>
</tr>
</tbody>
</table>
<h5>请求示例</h5>
<pre><code>{
"bar_code":"02KCBFN16050ECC8C2109988",
"Mi":"",
"ModelName":"PH_3950_ModelX",
"page":1,
"limit":10,
"StartDate":"",
"OutPut":false,
"EndDate":""
}</code></pre>
<h5>返回示例</h5>
<pre><code>{
"code": 200,
"data": [
{
"ActualCapacity": 3942,
"Capacity": 3946,
"CellNo": "DTM5I44080",
"CheckResult": "NG",
"DifferenceValue": 4,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": 0.001015,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3959,
"Capacity": 3959,
"CellNo": "DTM4E32944",
"CheckResult": "NG",
"DifferenceValue": 0,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": 0.0,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3954,
"Capacity": 3953,
"CellNo": "9TM6831660",
"CheckResult": "NG",
"DifferenceValue": -1,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": -0.000253,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3975,
"Capacity": 3973,
"CellNo": "9TM6902993",
"CheckResult": "NG",
"DifferenceValue": -2,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": -0.000503,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3946,
"Capacity": 3953,
"CellNo": "9TM6831880",
"CheckResult": "NG",
"DifferenceValue": 7,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": 0.001774,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3962,
"Capacity": 3964,
"CellNo": "DTM4E36552",
"CheckResult": "NG",
"DifferenceValue": 2,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": 0.000505,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3946,
"Capacity": 3945,
"CellNo": "9TM6831958",
"CheckResult": "NG",
"DifferenceValue": -1,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": -0.000253,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3952,
"Capacity": 3950,
"CellNo": "DTM4E36598",
"CheckResult": "NG",
"DifferenceValue": -2,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": -0.000506,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3964,
"Capacity": 3967,
"CellNo": "9TM6831145",
"CheckResult": "NG",
"DifferenceValue": 3,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": 0.000757,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
},
{
"ActualCapacity": 3945,
"Capacity": 3950,
"CellNo": "DTM5I44079",
"CheckResult": "NG",
"DifferenceValue": 5,
"EndTime": "2022-08-13 14:19:40",
"ErrorRate": 0.001267,
"Mi": "lou",
"ModelName": "sx_lousy_Mx0",
"StartTime": "2022-08-13 14:19:40"
}
],
"msg": "success",
"pageData": {
"page": 1,
"total": 3052
}
}</code></pre>
<h5>返回参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">CellNo</td>
<td style="text-align: left;">nvarchar</td>
<td>电芯条码</td>
</tr>
<tr>
<td style="text-align: left;">Mi</td>
<td style="text-align: left;">nvarchar</td>
<td>产品型号</td>
</tr>
<tr>
<td style="text-align: left;">ModelName</td>
<td style="text-align: left;">nvarchar</td>
<td>模型名称</td>
</tr>
<tr>
<td style="text-align: left;">CheckResult</td>
<td style="text-align: left;">nvarchar</td>
<td>是否异常</td>
</tr>
<tr>
<td style="text-align: left;">ActualCapacity</td>
<td style="text-align: left;">int</td>
<td>真实容量</td>
</tr>
<tr>
<td style="text-align: left;">Capacity</td>
<td style="text-align: left;">int</td>
<td>预测容量</td>
</tr>
<tr>
<td style="text-align: left;">DifferenceValue</td>
<td style="text-align: left;">int</td>
<td>预测误差</td>
</tr>
<tr>
<td style="text-align: left;">ErrorRate</td>
<td style="text-align: left;">float</td>
<td>误差率</td>
</tr>
<tr>
<td style="text-align: left;">StartTime</td>
<td style="text-align: left;">datetime</td>
<td>开始时间</td>
</tr>
<tr>
<td style="text-align: left;">EndTime</td>
<td style="text-align: left;">datetime</td>
<td>结束时间</td>
</tr>
</tbody>
</table>
<h5>备注</h5>