| | |
|---|
| | | |
|---|
| | | 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); |
|---|
| | |
|---|
| | | |
|---|
| | | Integer getStockStatisCount(Map<String, Object> condition); |
|---|
| | | |
|---|
| | | List<LocDetl> getStockStatisExcel(); |
|---|
| | | List<LocDetl> getStockStatisExcel(LocDetl locDetl); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 库存上报ERP时，根据物料汇总查询库存总量 |
|---|
