AmsSaleMaterialMapper.java 1.1 KB

1234567891011121314151617181920212223242526272829303132
  1. package com.steerinfo.dil.mapper;
  2. import com.steerinfo.dil.model.AmsSaleMaterial;
  3. import com.steerinfo.framework.mapper.IBaseMapper;
  4. import java.math.*;
  5. import java.util.List;
  6. import java.util.Map;
  7. import org.apache.ibatis.annotations.Mapper;
  8. import org.apache.ibatis.annotations.Select;
  9. @Mapper
  10. public interface AmsSaleMaterialMapper extends IBaseMapper<AmsSaleMaterial, BigDecimal> {
  11. @Select("select seq_AMS_SALE_MATERIAL.nextval from dual")
  12. BigDecimal selectMaxId();
  13. // 得到物资出现次数
  14. Integer getMaterialCount(BigDecimal materialId);
  15. // 根据路段顺序号逆序找到装货实际
  16. List<Map<String, Object>> findLoadIdList(BigDecimal saleOrderMaterialId);
  17. // 根据路段顺序号逆序找到计量实际
  18. List<Map<String, Object>> findWeightIdList(BigDecimal saleOrderMaterialId);
  19. //
  20. int deleteLoadResult(BigDecimal loadId);
  21. //
  22. int deleteWeightResult(BigDecimal weightId);
  23. int updateOrderMaterialToClose(Map<String, Object> mapValue);
  24. int deleteWmspOutResult(Map<String, Object> mapValue);
  25. // 开启所有的分录
  26. int openAllSaleMaterial(BigDecimal saleOrderId);
  27. }