package com.thhy.materials.modules.biz.pipeoutplan.mapper;
|
|
import com.thhy.materials.modules.biz.pipeoutplan.entity.PipeOutPlanEntity;
|
import com.thhy.materials.modules.biz.pipeoutplan.entity.PipeOutPlanMothEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Author QiuYuHao
|
* @CreateDate 2023-11-03 9:41:37
|
* 发运计划mapper
|
*/
|
@Mapper
|
public interface PipeOutPlanMapper {
|
|
/**
|
* 新增发运计划表
|
* @param pipeOutPlanEntity
|
*/
|
void insert(PipeOutPlanEntity pipeOutPlanEntity);
|
|
/**
|
* 新增发运计划月数表
|
* @param pipeOutPlanMothEntity
|
*/
|
void insertMoth(PipeOutPlanMothEntity pipeOutPlanMothEntity);
|
|
/**
|
* 删除发运计划表
|
* @param pipeNeedId
|
*/
|
void delete(String pipeNeedId);
|
|
/**
|
* 删除发运计划月数表
|
* @param pipeNeedId
|
*/
|
void deleteMoth(String pipeNeedId);
|
|
/**
|
* 更新发运计划表
|
* @param pipeOutPlanEntity
|
*/
|
void update(PipeOutPlanEntity pipeOutPlanEntity);
|
|
/**
|
* 查询单条发运计划表
|
* @param pipeNeedId
|
* @return
|
*/
|
PipeOutPlanEntity selectInfo(String pipeNeedId);
|
|
PipeOutPlanEntity selectInfoByProIdAndYear(
|
@Param("proId") String proId,
|
@Param("planYear") Integer year);
|
|
/**
|
* 查询发运计划列表
|
* @param map
|
* @return
|
*/
|
List<PipeOutPlanEntity> findAll(Map<String,Object> map);
|
|
/**
|
* 查询发运计划月数表
|
* @param pipeNeedId
|
* @return
|
*/
|
List<PipeOutPlanMothEntity> findMothList(String pipeNeedId);
|
|
/**
|
* 查询每月数量
|
* @param proId
|
* @param year
|
* @return
|
*/
|
List<PipeOutPlanMothEntity> findMothListByProIdAndYear(@Param("proId") String proId,
|
@Param("year") String year);
|
}
|
