mes-processes/mes-plcSend/src/main/java/com/mes/device/mapper/DeviceGlassInfoMapper.java
@@ -42,5 +42,14 @@ */ @Select("SELECT * FROM glass_info WHERE status = #{status} AND is_deleted = 0 ORDER BY created_time DESC") List<GlassInfo> selectByStatus(@Param("status") String status); /** * 根据工程号查询玻璃ID列表 * * @param engineeringId 工程号 * @return 玻璃信息列表 */ @Select("SELECT * FROM glass_info WHERE engineering_id = #{engineeringId} AND is_deleted = 0") List<GlassInfo> selectByEngineeringId(@Param("engineeringId") String engineeringId); }