DAL-DAZHOU-JOIN-API/src/main/java/com/steerinfo/dil/mapper/AmsSaleOrderMapper.java

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.AmsSaleOrder;
import com.steerinfo.framework.mapper.IBaseMapper;
import java.math.*;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface AmsSaleOrderMapper extends IBaseMapper<AmsSaleOrder, BigDecimal> {
    // 得到销售订单信息
    Map<String, Object> getSaleOrderMessage(BigDecimal saleOrderId);

    // 得到销售订单下的所有车序号
    List<Map<String, Object>> getMaterialMessages(BigDecimal saleOrderId);

    // 得到销售订单主键
    @Select("select seq_AMS_SALE_ORDER.nextval from dual")
    BigDecimal getSaleOrderId();

    // 查询收货单位
    BigDecimal getReceiveId(String receiveUnit);

    // 查询发货单位
    BigDecimal getShipperId(String shipperUnit);
    // 关闭未进厂的订单
    int closeOrderNotIn(BigDecimal saleOrderId);
    // 得到仓库集合
    List<Map<String,Object>> getWareHouse(BigDecimal saleOrderId);
    // 将不可作业的运输订单改为已接收状态
    int updateTruckOrderStatus(BigDecimal saleOrderId);

    String getWithdrawal(BigDecimal saleOrderMaterialId);

    BigDecimal selectAmsSaleOrderNum(String saleNumber);

    List<Map<String, Object>>  selectSaleSteelOrder(Map<String,Object> map);

    //根据物资id查找炉批号
    List<Map<String,Object>> selectMaterialFurnaceNumber(BigDecimal materialId,BigDecimal orderId);

    //查找销售订单所有实绩id，没有下游单据的
    List<Map<String,Object>> selectAmssaleOrderId(String saleNumber);


    //判断数据是否于AMS_SALE_ORDER_MATERIAL
    BigDecimal selectAreadyUse(String saleNumber);


    int uncloseOrderNotIn(BigDecimal saleOrderId);

}