From e3de6abd10702b84cc995dcc3c9426baf4377e18 Mon Sep 17 00:00:00 2001
From: 艾金辉 <1144154118@qq.com>
Date: 星期五, 21 七月 2023 16:14:57 +0800
Subject: [PATCH] 根据用户名获取三一列表
---
ard-work/src/main/java/com/ruoyi/sy/mapper/ArdSyUserMapper.java | 2 +-
ard-work/src/main/java/com/ruoyi/sy/service/impl/SysParaServiceImpl.java | 6 +++---
ard-work/src/main/resources/mapper/sy/SysParaMapper.xml | 12 ++----------
ard-work/src/main/resources/mapper/sy/ArdSyUserMapper.xml | 10 +++++-----
ard-work/src/main/java/com/ruoyi/sy/mapper/SysParaMapper.java | 2 +-
5 files changed, 12 insertions(+), 20 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdSyUserMapper.java b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdSyUserMapper.java
index 51ba900..9c823c7 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdSyUserMapper.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdSyUserMapper.java
@@ -76,5 +76,5 @@
*/
public List<SysUser> getSysUserNoSY();
- Map<String,Object> selectArdSyUserByUsersId(Integer usersId);
+ public Map<String,Object> selectArdSyUserByUsersId(Integer usersId);
}
diff --git a/ard-work/src/main/java/com/ruoyi/sy/mapper/SysParaMapper.java b/ard-work/src/main/java/com/ruoyi/sy/mapper/SysParaMapper.java
index 1c85d44..fbdb80d 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/mapper/SysParaMapper.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/mapper/SysParaMapper.java
@@ -11,6 +11,6 @@
@DS("slave")
public interface SysParaMapper {
- public List<SysPara> selectByExample(SysParaExample example);
+ List<SysPara> selectByExample(String sysType);
}
diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/impl/SysParaServiceImpl.java b/ard-work/src/main/java/com/ruoyi/sy/service/impl/SysParaServiceImpl.java
index ee91c6b..e96131b 100644
--- a/ard-work/src/main/java/com/ruoyi/sy/service/impl/SysParaServiceImpl.java
+++ b/ard-work/src/main/java/com/ruoyi/sy/service/impl/SysParaServiceImpl.java
@@ -21,9 +21,9 @@
@Override
public String getSYURL() {
- SysParaExample example = new SysParaExample();
- example.createCriteria().andSysTypeEqualTo("syCarPT");
- List<SysPara> result = sysParaMapper.selectByExample(example);
+// SysParaExample example = new SysParaExample();
+// example.createCriteria().andSysTypeEqualTo("syCarPT");
+ List<SysPara> result = sysParaMapper.selectByExample("syCarPT");
if(result.size() > 0){
String SYURL = result.get(0).getSysContent();
return SYURL;
diff --git a/ard-work/src/main/resources/mapper/sy/ArdSyUserMapper.xml b/ard-work/src/main/resources/mapper/sy/ArdSyUserMapper.xml
index ff96ba8..249ef50 100644
--- a/ard-work/src/main/resources/mapper/sy/ArdSyUserMapper.xml
+++ b/ard-work/src/main/resources/mapper/sy/ArdSyUserMapper.xml
@@ -126,10 +126,10 @@
</select>
<select id="selectArdSyUserByUsersId" resultType="java.util.Map" parameterType="java.lang.Integer" >
- select asu.id,asu.user_id as userId,asu.password,
- aus.users_id as usersId,au.name from ard_sy_user asu
- inner join ard_users_sy aus on asu.id = aus.sy_user_id
- inner join ard_users au on aus.users_id = au.id
- where aus.users_id = #{usersId}
+ select asu.id,asu.user_id as userId,asu.password,
+ aus.users_id as usersId,au.name from ard_sy_user asu
+ inner join ard_users_sy aus on asu.id = aus.sy_user_id
+ inner join ard_users au on aus.users_id = au.id
+ where aus.users_id = #{usersId}
</select>
</mapper>
\ No newline at end of file
diff --git a/ard-work/src/main/resources/mapper/sy/SysParaMapper.xml b/ard-work/src/main/resources/mapper/sy/SysParaMapper.xml
index 4c7618b..3da8fbb 100644
--- a/ard-work/src/main/resources/mapper/sy/SysParaMapper.xml
+++ b/ard-work/src/main/resources/mapper/sy/SysParaMapper.xml
@@ -39,19 +39,11 @@
<sql id="Base_Column_List" >
sys_id, sys_name, sys_type, sys_content
</sql>
- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.ruoyi.sy.domain.SysParaExample" >
+ <select id="selectByExample" parameterType="String" resultMap="BaseResultMap">
select
- <if test="distinct" >
- distinct
- </if>
<include refid="Base_Column_List" />
from sys_para
- <if test="_parameter != null" >
- <include refid="Example_Where_Clause" />
- </if>
- <if test="orderByClause != null" >
- order by ${orderByClause}
- </if>
+ where sys_type = #{sys_type}
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3