package com.chinaztt.mes.warehouse.mapper;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.chinaztt.mes.warehouse.dto.JoinStockOrderDTO;
|
import com.chinaztt.mes.warehouse.entity.JoinStockOrder;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
|
/**
|
* 客户订单库存预留表
|
*
|
* @author cxf
|
* @date 2021-07-21 15:36:57
|
*/
|
@Mapper
|
public interface JoinStockOrderMapper extends BaseMapper<JoinStockOrder> {
|
/**
|
* 分页查询
|
*
|
* @param page
|
* @param gen
|
* @return
|
*/
|
IPage<JoinStockOrderDTO> getJoinStockOrderPage(Page page, @Param("ew") QueryWrapper<JoinStockOrderDTO> gen);
|
|
/**
|
* 刷新客户订单的已预留数量
|
*
|
* @param id
|
* @param total
|
* @return
|
*/
|
int updateOrderById(@Param("id") Long id, @Param("total") BigDecimal total);
|
|
/**
|
* 刷新工单的已预留数量
|
*
|
* @param id
|
* @param total
|
* @return
|
*/
|
int updateOperationTaskId(@Param("id") Long id, @Param("total") BigDecimal total);
|
|
/**
|
* 将当前工单下的所需物料的已预留数量置空
|
*
|
* @param id
|
* @return
|
*/
|
void updateOperationTaskMaterial(Long id);
|
|
/**
|
* 更新工单下的所需物料的已预留数量
|
*
|
* @param id
|
* @param number
|
* @param partId
|
* @return
|
*/
|
void updateOperationTaskMaterialById(@Param("id") Long id, @Param("number") BigDecimal number, @Param("partId") Long partId);
|
|
/**
|
* 查找发货绑定的客户订单的GSM的合同产品id
|
*
|
* @param stockOrderId
|
* @return
|
*/
|
Long selectCustomerOrder(Long stockOrderId);
|
|
/**
|
* 根据stockId查询预留总数量
|
*
|
* @param stockId
|
* @return
|
*/
|
BigDecimal selectTotalQuantityByStockId(@Param("stockId") Long stockId);
|
|
JoinStockOrderDTO getStockOrderById(Long id);
|
}
|
