DM-ROW 接口文档

Appearance

POST /dm-device/deviceType/page ​

Content-Type: application/json

触发按钮：getPageListAjax

入参 ​

传递对象：DeviceTypeQueryVo

字段类型必填多选校验规则说明
fieldString否否--
orderString否否--
factoryNoString否否--
deviceTypeNameString否否-设备种类
deviceClassifyInteger否否-设备分类
deviceNameString否否-设备名称
deviceModelString否否-设备型号
typeInteger否否-查询类型，1/其他 设备种类(去重)/根据条件查询
partCodeString否否-物料编码
deviceCodeString否否--
deptNameString否否--
productLineNosList<String>否是-产品线集合
partNoString否否--
deptNoListList<String>否是--

实际入参:

json
{
    "pageSize": 10,
    "pageNum": 1,
    "deviceTypeName": "",
    "deviceClassify": 3,
    "deviceName": "22",
    "deviceModel": "222"
}

出参 ​

传递对象：ResultData，前端实际消费的是 data 中的 rows / total。<rows + total>

json
{
  "code": 200,
  "msg": "success",
  "data": {
    "records": [
      {
        "id": 633,
        "createTime": "2024-12-06 16:45:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-06 16:45:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20241207000001",
        "deviceTypeName": "99-REVISIONES",
        "deviceClassify": 3,
        "deviceName": "REVISION DE LINEA",
        "deviceModel": "REVISION SEMANAL",
        "deviceOrigin": null,
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": null,
        "deviceSpecification": "A0399001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 632,
        "createTime": "2024-12-03 09:21:32",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-06 16:35:29",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20241203000026",
        "deviceTypeName": "54-LINE_05",
        "deviceClassify": 3,
        "deviceName": "B2-LINEA UNO",
        "deviceModel": "B2-LINEA UNO",
        "deviceOrigin": "B2-LINEA UNO",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "B2-LINEA UNO\n",
        "deviceSpecification": "A0354001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 631,
        "createTime": "2024-12-03 09:21:11",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 09:21:11",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20241203000025",
        "deviceTypeName": "53-LINE_04",
        "deviceClassify": 3,
        "deviceName": "B2-LINEA DOS",
        "deviceModel": "B2-LINEA DOS",
        "deviceOrigin": "B2-LINEA DOS",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "B2-LINEA DOS\n",
        "deviceSpecification": "A0353001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 630,
        "createTime": "2024-12-03 09:17:07",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 09:17:07",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20241203000024",
        "deviceTypeName": "52-LINE_03",
        "deviceClassify": 3,
        "deviceName": "B2-ENS.STREAM LINE 03",
        "deviceModel": "B2-STREAM LINE 03",
        "deviceOrigin": "B2-STREAM LINE 03",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "B2-ENS.STREAM LINE 03\n",
        "deviceSpecification": "A0352001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 629,
        "createTime": "2024-12-03 09:16:31",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 09:16:31",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20241203000023",
        "deviceTypeName": "51-LINE-02",
        "deviceClassify": 3,
        "deviceName": "B2-ENS.STREAM LINE 02",
        "deviceModel": "B2-STREAM LINE 02",
        "deviceOrigin": "B2-STREAM LINE 02",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "B2-ENS.STREAM LINE 02\n",
        "deviceSpecification": "A0351001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 628,
        "createTime": "2024-12-03 09:14:53",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 09:14:53",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20241203000022",
        "deviceTypeName": "50-LINE-01",
        "deviceClassify": 3,
        "deviceName": "B2-ENS.STREAM LINE 01",
        "deviceModel": "B2-STREAM LINE 01",
        "deviceOrigin": "B2-STREAM LINE 01",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "B2-ENS.STREAM LINE 01",
        "deviceSpecification": "A0350001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 627,
        "createTime": "2024-12-02 15:07:55",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-02 15:07:55",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20241203000008",
        "deviceTypeName": "29-MLINE-80",
        "deviceClassify": 3,
        "deviceName": "B1-ENS.STREAM LINE 3.5",
        "deviceModel": "B1-STREAM LINE 3.5",
        "deviceOrigin": "B1",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "SL3.5 ENSAMBLE",
        "deviceSpecification": "A0329001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 577,
        "createTime": "2024-09-20 10:25:47",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-20 10:25:47",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20240921000013",
        "deviceTypeName": "28-LINE_005",
        "deviceClassify": 3,
        "deviceName": "LINEA LINEA DOS",
        "deviceModel": "LINEA DOS",
        "deviceOrigin": "B2",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "LINEA LINEA DOS\n",
        "deviceSpecification": "A0328001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 576,
        "createTime": "2024-09-20 10:25:03",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-20 10:25:03",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20240921000012",
        "deviceTypeName": "27-LINE_004",
        "deviceClassify": 3,
        "deviceName": "LINEA LINEA UNO",
        "deviceModel": "LINEA UNO",
        "deviceOrigin": "B2",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "LINEA LINEA UNO\n",
        "deviceSpecification": "A0327001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      },
      {
        "id": 575,
        "createTime": "2024-09-20 10:24:32",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-20 10:24:32",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": "20240921000011",
        "deviceTypeName": "26-LINE_003",
        "deviceClassify": 3,
        "deviceName": "LINEA STREAM LINE 03",
        "deviceModel": "STREAM LINE 3",
        "deviceOrigin": "B2",
        "deviceManufacturer": null,
        "devicePartImg": null,
        "devicePartImgUrl": null,
        "devicePartFile": null,
        "description": "LINEA STREAM LINE 03\n",
        "deviceSpecification": "A0326001",
        "meterConfigList": null,
        "safetyTipsList": null,
        "specificationParameterList": null,
        "consumablePartList": null,
        "sparePartList": null,
        "isSyncPart": 0,
        "children": null,
        "name": null,
        "value": null,
        "classId": null,
        "typeId": null
      }
    ],
    "total": 35,
    "size": 10,
    "current": 1,
    "pages": 4
  }
}

前端校验规则 ​

权限校验
├── 查询按钮权限
│   └── v-auth: 'information:deviceType:search:popup'
├── 新增按钮权限
│   └── v-auth: 'information:deviceType:add:new'
├── 删除按钮权限
│   └── v-auth: 'information:deviceType:delete:popup'
├── 编辑操作权限
│   └── code: 'information:deviceType:edit:new'
└── 删除操作权限
    └── code: 'information:deviceType:delete:popup'

后端逻辑 ​

业务流程：按条件筛选设备类型 -> 查询未删除记录 -> 按更新时间倒序返回分页结果

└── 分页查询设备类型
    ├── 分页查询:DeviceTypeServiceImpl.pages :90-93
    └── 查询未删除设备类型:DeviceTypeMapper.selectPage :5-26
        ├── 条件
        │   ├── is_delete = 0
        │   ├── deviceTypeName 模糊匹配
        │   ├── deviceClassify 精确匹配
        │   ├── deviceName 模糊匹配
        │   └── deviceModel 模糊匹配
        └── 排序
            └── update_time DESC, create_time DESC

后端校验规则 ​

无

涉及数据库表 ​

库名.表名mapper.statement描述
device_typeDeviceTypeMapper.selectPage按筛选条件分页查询deviceType数据
device_type_mapperdeviceTypeMapper.selectPagedeviceTypeMapper