From 0d672522085313c648c928d37fd53b25f4afd9cf Mon Sep 17 00:00:00 2001
From: gdg <764716047@qq.com>
Date: 星期四, 17 十二月 2020 16:10:20 +0800
Subject: [PATCH] 模块:试剂库 修改:价格排序 提出:区老师
---
src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml b/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml
index 9f73e83..682c9e2 100644
--- a/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml
+++ b/src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml
@@ -159,7 +159,7 @@
limit #{MaxSize}
</if>
) as reagent
- ORDER BY reagent.favortime DESC
+ ORDER BY reagent.favortime DESC,price asc
<if test="first != null and pageSize != null">
limit #{first}, #{pageSize}
</if>
--
Gitblit v1.9.2