server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwMaterialServiceImpl.java
@@ -221,6 +221,8 @@ .like(StringUtils.isNotBlank(model.getAttr()),YwMaterial::getAttr,model.getAttr()) .eq(Objects.nonNull(model.getProjectId()),YwRoom::getProjectId,model.getProjectId()) .eq(Objects.nonNull(model.getRoomId()),YwMaterial::getRoomId,model.getRoomId()) .eq(Objects.nonNull(model.getFloorId()),YwRoom::getFloor,model.getFloorId()) .eq(Objects.nonNull(model.getBuildingId()),YwRoom::getBuildingId,model.getBuildingId()) .eq(YwMaterial::getIsdeleted,Constants.ZERO) .orderByAsc(YwMaterial::getCode) ;