| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public YwRoom findById(Integer id) { |
|---|
| | | return ywRoomMapper.selectById(id); |
|---|
| | | MPJLambdaWrapper<YwRoom> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | queryWrapper.selectAll(YwRoom.class ) |
|---|
| | | .selectAs(YwProject::getName,YwRoom::getProjectName) |
|---|
| | | .selectAs(YwFloor::getName,YwRoom::getFloorName) |
|---|
| | | .selectAs(YwBuilding::getName,YwRoom::getBuildingName) |
|---|
| | | .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId) |
|---|
| | | .leftJoin(YwBuilding.class,YwBuilding::getId,YwRoom::getBuildingId) |
|---|
| | | .leftJoin(YwFloor.class,YwFloor::getId,YwRoom::getFloor) |
|---|
| | | .eq(YwRoom::getId,id) |
|---|
| | | .last(" limit 1 ") |
|---|
| | | ; |
|---|
| | | YwRoom ywRoom = ywRoomMapper.selectJoinOne(YwRoom.class,queryWrapper); |
|---|
| | | return ywRoom; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
