| | |
|---|
| | | |
|---|
| | | Integer getStockOutPageCount(Map<String, Object> map); |
|---|
| | | |
|---|
| | | @Update("update asr_loc_detl set qty=#{qty}, modi_time = getDate() where loc_no = #{locNo} and mat_no = #{matNo}") |
|---|
| | | int updateAnfme(Double qty, String locNo, String matNo); |
|---|
| | | @Update("update asr_loc_detl set qty=#{qty}, modi_time = getDate(),all_weight=#{weight},all_qty=#{allQty} where loc_no = #{locNo} and mat_no = #{matNo}") |
|---|
| | | int updateAnfme(Double qty, String locNo, String matNo,Double weight,Double allQty); |
|---|
| | | |
|---|
| | | @Update("update asr_loc_detl set loc_no = #{newLocNo}, modi_time=getDate() where loc_no = #{oldLocNo}") |
|---|
| | | int updateLocNo(String newLocNo, String oldLocNo); |
|---|
| | |
|---|
| | | */ |
|---|
| | | @Select("select mat_no,mat_name,sum(qty) qty from asr_loc_detl group by mat_no,mat_name") |
|---|
| | | List<LocDetl> getStockSum(); |
|---|
| | | |
|---|
| | | } |
|---|
