IWmspRestackScanResultService.java 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. package com.steerinfo.dil.service;
  2. import com.steerinfo.dil.model.WmspRestackScanResult;
  3. import java.math.BigDecimal;
  4. import java.util.List;
  5. import java.util.Map;
  6. /**
  7. * WmspRestackScanResult服务接口:
  8. * @author generator
  9. * @version 1.0-SNAPSHORT 2021-09-10 10:11
  10. * 类描述
  11. * 修订历史:
  12. * 日期:2021-09-10
  13. * 作者:generator
  14. * 参考:
  15. * 描述:WmspRestackScanResult服务接口
  16. * @see null
  17. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  18. */
  19. public interface IWmspRestackScanResultService {
  20. int insertselective(WmspRestackScanResult wmspRestackScanResult);
  21. // 根据条件查找信息进行判断
  22. List<Map<String,Object>> selectByLoaderId(Map<String,Object> mapval);
  23. //获取最大id
  24. BigDecimal selectMaxId();
  25. //稽核倒垛单列表
  26. Integer selectRestackAudit(String materialCode);
  27. // 更新
  28. int updateByPrimaryKeySelective(WmspRestackScanResult wmspRestackScanResult);
  29. //根据稽核结果统计订单数量
  30. int CountByAuditResult(Integer resultId);
  31. int selectNumber(Integer stackingId1);
  32. //稽核阶段,根据物资id查找物资id
  33. Map<String,Object> selectListByAuditResult(Integer mateialId);
  34. //稽核阶段,根据实绩id查找物资id
  35. List<Map<String,Object>> selectMaterialIdByResultId(Integer resultId);
  36. //根据实绩id查找倒垛后的仓库id和垛位id
  37. Map<String,Object> selectWarehouseIdAndStakingId(Integer resultId);
  38. Integer selectGridIdByStakingNoAndGrandationnumber(Map<String,Object> map);
  39. //根据扫描结果查询是否存在
  40. Integer selectResultScanTag(String resultScanTag);
  41. //根据网格id和物资id查找主键id
  42. Integer selectGmIdByGridIdAndMaterialId(Integer gridId,Integer materialId);
  43. //根据网格id查找物资id
  44. Integer selectMaterialIdByGridId(Integer gridId);
  45. //根据物资id查找倒垛前的仓储网格
  46. Integer selectGridIdByResultId(Integer resultId);
  47. //根据实绩id查找扫描结果
  48. List<Map<String,Object>> selectTagByResultId(Integer resultId);
  49. WmspRestackScanResult insertWmspRestackScanResult(String restackMake, String context);
  50. }