feat(production): 添加查询的排序

liyong

2 天以前 1a63cb713ae5a547109e7c22b59cb3691d99d686

feat(production): 添加查询的排序

 src/main/resources/mapper/basic/ProductModelMapper.xml

@@ -29,6 +29,7 @@
                and pm.speculative_trading_name like  concat('%',#{c.speculativeTradingName},'%')
            </if>
        </where>
        order by  pm.id
    </select>



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

@@ -24,7 +24,6 @@
                left join process_route pr on pr.id = pri.route_id
        where
            pri.route_id = #{c.routeId}


        order by pri.id
    </select>
</mapper>

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

@@ -21,5 +21,6 @@
                and pm.speculative_trading_name like concat('%',#{c.speculativeTradingName},'%')
            </if>
        </where>
        order by ps.id asc
    </select>
</mapper>

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

@@ -18,6 +18,6 @@
                AND  p.no LIKE CONCAT('%',#{productProcessDto.no},'%')
            </if>
        </where>
        order by p.id desc
        order by p.id asc
    </select>
</mapper>

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

@@ -24,5 +24,6 @@
        left join product_model pm on ps.product_model_id = pm.id
        left join product_process pp on ps.process_id = pp.id
        where pm.id = #{productId}
        order by ps.id
    </select>
</mapper>