| | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.mapper.BaseMapper; |
|---|
| | | import com.zy.asrs.entity.LocDetl; |
|---|
| | | import com.zy.asrs.entity.LocDetlWarningDTO; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | |
|---|
| | | @Select("select mat_no,mat_name,sum(qty) qty from asr_loc_detl group by mat_no,mat_name") |
|---|
| | | List<LocDetl> getStockSum(); |
|---|
| | | |
|---|
| | | List<LocDetlWarningDTO> selectAllWarning(LocDetlWarningDTO locDetlWarningDTO); |
|---|
| | | |
|---|
| | | int getAllWarningCount(LocDetlWarningDTO locDetlWarningDTO); |
|---|
| | | } |
|---|
