DIL-DAZHOU-WMS2/src/main/java/com/steerinfo/dil/mapper/WmspSendReceiveMapper.java

package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.WmspSendReceive;
import com.steerinfo.framework.mapper.IBaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

@Mapper
public interface WmspSendReceiveMapper extends IBaseMapper<WmspSendReceive, BigDecimal> {


    List<Map<String, Object>> selectWmspSendReceive(Map<String, Object> mapValue);

    @Select("select seq_WMSP_SEND_RECEIVE.nextval from dual")
    BigDecimal getSendReceiveId();

    //更改今天的入库
    int updateSendReceiveThisdayInbound(Map<String,Object> map);

    //查询昨天的库存
    BigDecimal getSendReceiveLastdayInventory(Map<String, Object> map);

    //更改今天出库
    int updateSendReceiveThisdayOutbound(Map<String, Object> map);
    //今天入库
    BigDecimal selectSendReceiveThisdayInbound(Map<String,Object> map);
    //今天出库
    BigDecimal selectSendReceiveThisdayOutbound(Map<String,Object> map);
    //根据物资钢材id查询物资大类id
    BigDecimal getMaterialId(BigDecimal materialSteelId);
    //实时更改库存
    int updateSendReceiveThisdayInventory(Map<String,Object> map);
    //统计前一天的入库总数
    BigDecimal countSndReceiveThisdayInbound(Map<String, Object> map2);
    //统计前一天的出库总数
    BigDecimal countSendReceiveThisdayOutbound(Map<String, Object> map2);

    int getTodaySendReceiveCount();
}