最新订单号

yujian

2020-05-18 106a09463e66ffe39383bdab28f501ec47b5fcc4

最新订单号

 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderMapper.java

@@ -417,4 +417,10 @@
     */
    Long countOrderByUidAndSettled(@Param("uid") Long uid, @Param("payment") BigDecimal payment);
    
    /**
     * 获取最新的淘宝订单号
     * @return
     */
    String getNewestOrderNoByTaoBao();
	
}

 fanli/src/main/java/com/yeshi/fanli/mapping/order/CommonOrderMapper.xml

@@ -1205,4 +1205,12 @@
        #{uid} AND d.`co_settle_time` IS NOT NULL AND d.`co_payment` >=
        #{payment}
    </select>
	
    <select id="getNewestOrderNoByTaoBao" resultType="String">
        SELECT d.`co_order_no` FROM `yeshi_ec_common_order` d
        WHERE d.`co_source_type` = 1
        ORDER BY d.`co_id` DESC
        LIMIT 1
    </select>
	
</mapper>

 fanli/src/main/java/com/yeshi/fanli/service/inter/order/CommonOrderService.java

@@ -434,4 +434,10 @@
     */
    public long countOrderByUidAndSettled(Long uid, BigDecimal payment);

    /**
     * 获取最新的淘宝订单号
     * @return
     */
    public String getNewestOrderNoByTaoBao();

}