| | |
|---|
| | | @ResultType(Map.class)
|
|---|
| | | List<Map<String, Object>> getflowCardId();
|
|---|
| | |
|
|---|
| | | @Update("UPDATE down_workstation SET flow_card_id = NULL, total_quantity = NULL, racks_number = NULL WHERE workstation_id = #{workstationId}")
|
|---|
| | | @Update("UPDATE down_workstation SET flow_card_id = NULL, total_quantity = 0, racks_number = 0 WHERE workstation_id = #{workstationId}")
|
|---|
| | | void clearFlowCardInfoByWorkstationId(@Param("workstationId") int workstationId);
|
|---|
| | |
|
|---|
| | | // 获取总数量
|
|---|
| | | @Select("SELECT total_quantity FROM down_workstation WHERE workstation_id = #{workstationId}")
|
|---|
| | | int getTotalQuantity(@Param("workstationId") int workstationId);
|
|---|
| | |
|
|---|
| | | // 获取落架数量
|
|---|
| | | @Select("SELECT racks_number FROM down_workstation WHERE workstation_id = #{workstationId}")
|
|---|
| | | int getRacksNumber(@Param("workstationId") int workstationId);
|
|---|
| | |
|
|---|
| | | }
|
|---|
