zhangback
21 小时以前 ba87fd72f14c5ed0caf14e9d8ff116d254a8c113
tms/src/main/java/com/ruoyi/tms/mapper/TmsQuoteItemMapper.java
@@ -3,6 +3,8 @@
import java.util.List;
import com.ruoyi.tms.domain.TmsQuoteItem;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
/**
@@ -37,6 +39,12 @@
     */
    public List<TmsQuoteItem> selectTmsQuoteItemList(TmsQuoteItem tmsQuoteItem);
    @Select("select DISTINCT tqi.* from tms_quote_item tqi " +
            "JOIN tms_quote_plan tqp on tqi.quote_plan_id = tqp.id " +
            "where tqi.free = #{free}  and tqp.provider_id = #{providerId} and tqp.provider_type = #{providerType} and plan_type = 1")
    public TmsQuoteItem selectTmsQuoteItemByQuoteId(@Param("free") Integer free,@Param("providerType") Integer providerType,@Param("providerId") Integer providerId);
    /**
     * 新增报价项目
     *