From 1a63cb713ae5a547109e7c22b59cb3691d99d686 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期二, 23 十二月 2025 14:48:49 +0800
Subject: [PATCH] feat(production): 添加查询的排序
---
src/main/resources/mapper/production/ProcessRouteMapper.xml | 1 +
src/main/resources/mapper/basic/ProductModelMapper.xml | 1 +
src/main/resources/mapper/production/ProductProcessMapper.xml | 2 +-
src/main/resources/mapper/production/ProductStructureMapper.xml | 1 +
src/main/resources/mapper/production/ProcessRouteItemMapper.xml | 3 +--
5 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/src/main/resources/mapper/basic/ProductModelMapper.xml b/src/main/resources/mapper/basic/ProductModelMapper.xml
index ef786c4..799257d 100644
--- a/src/main/resources/mapper/basic/ProductModelMapper.xml
+++ b/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>
diff --git a/src/main/resources/mapper/production/ProcessRouteItemMapper.xml b/src/main/resources/mapper/production/ProcessRouteItemMapper.xml
index 54a5e04..017e523 100644
--- a/src/main/resources/mapper/production/ProcessRouteItemMapper.xml
+++ b/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>
diff --git a/src/main/resources/mapper/production/ProcessRouteMapper.xml b/src/main/resources/mapper/production/ProcessRouteMapper.xml
index 058faf3..b71d4d8 100644
--- a/src/main/resources/mapper/production/ProcessRouteMapper.xml
+++ b/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>
diff --git a/src/main/resources/mapper/production/ProductProcessMapper.xml b/src/main/resources/mapper/production/ProductProcessMapper.xml
index 5ab3631..525287a 100644
--- a/src/main/resources/mapper/production/ProductProcessMapper.xml
+++ b/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>
diff --git a/src/main/resources/mapper/production/ProductStructureMapper.xml b/src/main/resources/mapper/production/ProductStructureMapper.xml
index 995be50..35d89cf 100644
--- a/src/main/resources/mapper/production/ProductStructureMapper.xml
+++ b/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>
--
Gitblit v1.9.3