| | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.jeecg.modules.lsw.entity.LswMaterialInventory; |
| | | import org.jeecg.modules.lsw.vo.LswMaterialInventoryVo; |
| | | import org.jeecg.modules.lsw.vo.MaterialInventoryStatisticsVO; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | */ |
| | | public interface LswMaterialInventoryMapper extends BaseMapper<LswMaterialInventory> { |
| | | |
| | | /** |
| | | * 通过主表id删除子表数据 |
| | | * |
| | | * @param mainId 主表id |
| | | * @return boolean |
| | | */ |
| | | public boolean deleteByMainId(@Param("mainId") String mainId); |
| | | |
| | | /** |
| | | * 通过主表id查询子表数据 |
| | | * |
| | | * @param mainId 主表id |
| | | * @return List<LswMaterialInventory> |
| | | */ |
| | | public List<LswMaterialInventory> selectByMainId(@Param("mainId") String mainId); |
| | | |
| | | List<LswMaterialInventoryVo> selectLineSideMaterialInventoryByMaterialNumber(@Param("materialNumberList") List<String> bomMaterialNumberList, |
| | | @Param("factoryId") String factoryId); |
| | | |
| | | /** |
| | | * 库存统计 |
| | | * @param materialId |
| | | * @return |
| | | */ |
| | | List<MaterialInventoryStatisticsVO> statisticsInventory(@Param("materialId") String materialId); |
| | | } |