大淘客数据

yujian

2019-05-13 57eae580b2c282b85f8743d091c986e92c66db63

大淘客数据

 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/dataoke/DaTaoKeDetailMapper.java

@@ -58,4 +58,12 @@
    List<DaTaoKeDetail> getGoodsNotInList(@Param("cid") Long cid, @Param("list") List<Long> list, @Param("count") int count);


    /**
     * 根据标题查询
     * 
     * @param dtitle
     * @return
     */
    List<DaTaoKeDetail> listByDtitle(String dtitle);

}

 fanli/src/main/java/com/yeshi/fanli/mapping/taobao/dataoke/DaTaoKeDetailMapper.xml

@@ -72,7 +72,7 @@
    <select id="getGoodsNotInList" resultMap="BaseResultMap">
        SELECT * FROM `yeshi_ec_goods_dataoke` d
        WHERE 1=1 
            <if test="cid != null">
            <if test="cid != null and cid !=0">
                AND d.`cid` = #{cid}
            </if>
            <if test="list != null">
@@ -82,6 +82,16 @@
        ORDER BY RAND() LIMIT #{count}
    </select>


    <select id="listByDtitle" resultMap="BaseResultMap"
        parameterType="java.lang.String">
        select
        <include refid="Base_Column_List" />
        from yeshi_ec_goods_dataoke where d_title=#{0}
    </select>



    <delete id="deleteByIdList">
        delete from
        yeshi_ec_goods_dataoke where