src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -38,4 +38,11 @@ Integer getStockStatisCount(Map<String, Object> condition); List<LocDetl> getStockStatisExcel(); /** * 库存上报ERP时,根据物料汇总查询库存总量 * @return */ @Select("select mat_no,mat_name,sum(qty) qty from asr_loc_detl group by mat_no,mat_name") List<LocDetl> getStockSum(); }