fix: 根据编号倒序

gongchunyi

5 天以前 65dcb16e025e2e7e155c9ea494a815935826d75f

fix: 根据编号倒序

 src/main/resources/mapper/production/ProcessRouteMapper.xml

@@ -23,6 +23,6 @@
                and pm.model like concat('%',#{c.model},'%')
            </if>
        </where>
        order by ps.id asc
        order by ps.process_route_code desc
    </select>
</mapper>

 src/main/resources/mapper/production/ProductBomMapper.xml

@@ -35,6 +35,7 @@
        <if test="c.version != null">
            and version = #{c.version}
        </if>
        order by pb.bom_no desc
    </select>
    <select id="getById" resultType="com.ruoyi.production.dto.ProductBomDto">
        select pb.*,

 src/main/resources/mapper/production/ProductOrderMapper.xml

@@ -64,6 +64,7 @@
                and po.create_time between #{c.startTime} and #{c.endTime}
            </if>
        </where>
        order by po.nps_no desc
    </select>
    <select id="listProcessRoute" resultType="com.ruoyi.production.pojo.ProcessRoute">
        select pr.*

 src/main/resources/mapper/production/ProductWorkOrderMapper.xml

@@ -61,6 +61,7 @@
        <if test="c.productOrderId != null and c.productOrderId != ''">
            and pwo.product_order_id = #{c.productOrderId}
        </if>
        order by pwo.work_order_no desc
    </select>

    <select id="getProductWorkOrderFlowCard" resultType="com.ruoyi.production.dto.ProductWorkOrderDto">