package cn.csbr.springboot.dao.mapper;

import cn.csbr.springboot.dao.model.Mfcubestockdetail;
import com.csbr.mybatis.MyMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface MfcubestockdetailMapper extends MyMapper<Mfcubestockdetail> {
    @Select("SELECT COUNT(1) from mfcubestockdetail where  depotGuid = #{orgid} and DATEDIFF(mfcubestockdetail.ExpireDate,NOW()) < #{youxqdays}")
    public int selectExpiredGoods(@Param("orgid") String orgid,@Param("youxqdays") int youxqdays);

    @Select("SELECT * FROM `mfcubestockdetail` WHERE LabGuid=#{labguid}")
    Mfcubestockdetail searchDetailByBarcode(@Param("labguid")String labguid);

    @Select("delete from mfcubestockdetail where LabGuid=#{LabGuid}")
    void mfcubestockdetaildel(@Param(value ="LabGuid")String LabGuid);
}