| | |
|---|
| | | @Select("select distinct lev1 from asr_loc_mast where row1=#{row1} order by lev1 desc") |
|---|
| | | public List<String> getViewLocLevCount(@Param("row1") int row1); |
|---|
| | | // |
|---|
| | | @Select("select loc_no as locNo, bay1,loc_sts as locSts from asr_loc_mast where row1=#{row1} and lev1=#{lev1} order by bay1") |
|---|
| | | @Select("select loc_no as locNo, bay1,loc_sts as locSts from asr_loc_mast where row1=#{row1} and lev1=#{lev1} and status=0 order by bay1") |
|---|
| | | public List<ViewLocMapDto> getViewLocBays(@Param("row1") int row1, @Param("lev1") int lev1); |
|---|
| | | |
|---|
| | | // 库位Map |
|---|
| | |
|---|
| | | public int getViewWorkOutCount(ViewWorkInBean viewWorkOut); |
|---|
| | | //不分页查询所有信息，用于excel导出 |
|---|
| | | public List<ViewWorkInBean> getViewWorkOutAll(ViewWorkInBean viewWorkOut); |
|---|
| | | //不分页查询所有信息，ERP调用 |
|---|
| | | public List<ViewWorkInBean> getViewWorkOutERP(); |
|---|
| | | |
|---|
| | | |
|---|
| | | // ------图表 |
|---|
