| | |
| | | @ApiModelProperty(value = "设备名称") |
| | | @TableField(exist = false) |
| | | private String equipmentName; |
| | | @ApiModelProperty(value = "安装位置") |
| | | @TableField(exist = false) |
| | | private String installationPosition; |
| | | } |
| | |
| | | private String equipmentCode; |
| | | @TableField(exist = false) |
| | | private String equipmentName; |
| | | @ApiModelProperty(value = "安装位置") |
| | | @TableField(exist = false) |
| | | private String installationPosition; |
| | | } |
| | |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamInspectionOrderMapper"> |
| | | |
| | | <select id="queryPageList" resultType="org.jeecg.modules.eam.entity.EamInspectionOrder"> |
| | | select wmo.*, e.equipment_code, e.equipment_name |
| | | select wmo.*, e.equipment_code, e.equipment_name, e.installation_position |
| | | from eam_inspection_order wmo |
| | | inner join eam_equipment e |
| | | on wmo.equipment_id = e.id |
| | |
| | | <mapper namespace="org.jeecg.modules.eam.mapper.EamWeekMaintenanceOrderMapper"> |
| | | |
| | | <select id="queryPageList" resultType="org.jeecg.modules.eam.entity.EamWeekMaintenanceOrder"> |
| | | select wmo.*, e.equipment_code, e.equipment_name |
| | | select wmo.*, e.equipment_code, e.equipment_name, e.installation_position |
| | | from eam_week_maintenance_order wmo |
| | | inner join eam_equipment e |
| | | on wmo.equipment_id = e.id |