| | |
|---|
| | | int updateOrderNo(@Param("orderNo")String orderNo, @Param("wrkNo")Integer wrkNo, @Param("matnr")String matnr, @Param("batch")String batch); |
|---|
| | | |
|---|
| | | int updateWrkNo1(@Param("wrk_no")Integer wrkNo, @Param("supp_code")String barcode, @Param("matnr")String matnr, @Param("three_code")String threeCode); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT sum(d.anfme) from agv_wrk_detl d ,agv_wrk_mast m where d.wrk_no=m.wrk_no and m.io_type in (101,103,53) and d.matnr = #{matnr} AND d.three_code = #{threeCode} AND d.order_no = #{orderNo} AND d.process_sts != 1") |
|---|
| | | Double sumAnfmeByMatnr(@Param("matnr") String matnr, @Param("threeCode") String threeCode, @Param("orderNo") String orderNo); |
|---|
| | | |
|---|
| | | } |
|---|
