package cn.csbr.springboot.dao.mapper;

import cn.csbr.springboot.dao.model.MfcubestockdetailOld2;
import com.csbr.mybatis.MyMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Author: Raymond
 * @Date: 2019/6/18 11:56
 * @Description:
 */
@Repository
@Mapper
public interface MfcubestockdetailOldMapper2 extends MyMapper<MfcubestockdetailOld2> {

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

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