登录文件合并

wu

2024-04-10 321c0a50fdfa52d7d2da52dfb4fa74adff1c0f39

 LoadGlassModule/src/main/java/com/mes/mapper/LoadGlassMapper.java

@@ -9,11 +9,11 @@
    @Select("SELECT * FROM up_workstation")
    List<UpWorkstation> selectALL();
    //删除工位的玻璃信息
    @Delete("DELETE FROM up_workstation where  workstation_id=#{id}")
    @Update("UPDATE `hangzhoumes`.`up_workstation` SET   `pattern_width` =NULL, `pattern_heigth` = NULL, `pattern_thickness` = NULL, `films_id` = NULL, `number` = NULL WHERE `workstation_id`=#{id}")
    void deleteGlass(int id );
    //增加上片信息
    @Insert ("INSERT INTO up_workstation (pattern_width,pattern_heigth,pattern_thickness,films_id,number,workstationid)value(#{upwork.patternwidth},#{upwork.patternheigth},#{upwork.patternthickness},#{upwork.filmsid},#{upwork.number},#{upwork.workstationid) ")
    void insertGlass(UpWorkstation upwork,Double patternwidth,Double patternheigth,Double patternthickness,int workstationid,String filmsid,int number);
    @Update ("UPDATE `hangzhoumes`.`up_workstation` SET   `pattern_width` = #{upwork.patternwidth}, `pattern_heigth` = #{upwork.patternheigth}, `pattern_thickness` =#{upwork.patternthickness}, `films_id` =#{upwork.filmsid}, `number` = #{upwork.number} WHERE `id` = #{upwork.workstationid}; ")
    void insertGlass(UpWorkstation upwork);
    //是否发起吸片
    @Select("SELECT * FROM up_workstation where  workstation_id=#{id}")
    UpWorkstation selectAdd(int id);