Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes

wuyouming666

2024-04-18 e8d3676793d4194485afec7940aaf355af594901

 UnLoadGlassModule/src/main/java/com/mes/mapper/DownWorkstationMapper.java

@@ -1,6 +1,5 @@
package com.mes.mapper;



import com.baomidou.dynamic.datasource.annotation.DS;

import com.baomidou.mybatisplus.annotation.InterceptorIgnore;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.mes.entity.DownGlassInfo;

@@ -16,7 +15,6 @@
@Component

@Repository

@InterceptorIgnore(tenantLine = "true")

@DS("hangzhoumes") // 指定使用 hangzhoumes 数据源

public interface DownWorkstationMapper extends BaseMapper<DownWorkstation> {

//根据工位ID和设备ID更新工位状态

    @Update("UPDATE down_workstation SET work_state = #{workState} " +

@@ -82,7 +80,15 @@
    @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);



}