<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="DictionariesMapper">
<resultMap type="Dictionaries" id="dictResultMap">
<id column="DICTIONARIES_ID" property="DICTIONARIES_ID"/>
<result column="NAME" property="NAME"/>
<result column="PARENT_ID" property="PARENT_ID"/>
</resultMap>
<!--表名 -->
<sql id="tableName">
SYS_DICTIONARIES
</sql>
<!-- 字段 -->
<sql id="Field">
DICTIONARIES_ID,
NAME,
NAME_TW,
NAME_EN,
NAME_JA,
NAME_MY,
BIANMA,
ORDER_BY,
PARENT_ID,
BZ,
ICON,
TBSNAME,
STATE
</sql>
<!-- 字段值 -->
<sql id="FieldValue">
#{DICTIONARIES_ID},
#{NAME},
#{NAME_TW},
#{NAME_EN},
#{NAME_JA},
#{NAME_MY},
#{BIANMA},
#{ORDER_BY},
#{PARENT_ID},
#{BZ},
#{ICON},
#{TBSNAME},
#{STATE}
</sql>
<!-- 新增-->
<insert id="save" parameterType="pd">
insert into
<include refid="tableName"></include>
(
<include refid="Field"></include>
) values (
<include refid="FieldValue"></include>
)
</insert>
<!-- 删除-->
<delete id="delete" parameterType="pd">
delete from
<include refid="tableName"></include>
where
DICTIONARIES_ID = #{DICTIONARIES_ID}
</delete>
<!-- 修改 -->
<update id="edit" parameterType="pd">
update
<include refid="tableName"></include>
set
NAME = #{NAME},
NAME_TW = #{NAME_TW},
NAME_EN = #{NAME_EN},
NAME_JA = #{NAME_JA},
NAME_MY = #{NAME_MY},
ORDER_BY = #{ORDER_BY},
BZ = #{BZ},
ICON = #{ICON},
TBSNAME = #{TBSNAME},
STATE = #{STATE},
DICTIONARIES_ID = DICTIONARIES_ID
where
DICTIONARIES_ID = #{DICTIONARIES_ID}
</update>
<!-- 通过ID获取数据 -->
<select id="findById" parameterType="pd" resultType="pd">
select
<include refid="Field"></include>
from
<include refid="tableName"></include>
where
DICTIONARIES_ID = #{DICTIONARIES_ID}
</select>
<!-- 通过编码获取数据 -->
<select id="findByBianma" parameterType="pd" resultType="pd">
select
<include refid="Field"></include>
from
<include refid="tableName"></include>
where
BIANMA = #{BIANMA}
</select>
<!-- 列表 -->
<select id="datalistPage" parameterType="page" resultType="pd">
select
<include refid="Field"></include>
from
<include refid="tableName"></include>
where
1=1
<if test="pd.DICTIONARIES_ID!= null and pd.DICTIONARIES_ID != ''"><!-- 检索 -->
and PARENT_ID = #{pd.DICTIONARIES_ID}
</if>
<if test="pd.keywords != null and pd.keywords != ''"><!-- 关键词检索 -->
and
(
NAME LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%')
or
NAME_TW LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%')
or
NAME_EN LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%')
or
NAME_JA LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%')
or
NAME_MY LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%')
or
BIANMA LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%')
)
</if>
order by ORDER_BY
</select>
<!-- 通过ID获取其子级列表 -->
<select id="listSubDictByParentId" parameterType="String" resultMap="dictResultMap">
select
<include refid="Field"></include>
from
<include refid="tableName"></include>
where
PARENT_ID = #{parentId} order by ORDER_BY
</select>
<!-- 排查表检查是否被占用 -->
<select id="findFromTbs" parameterType="pd" resultType="pd">
select
count(1) zs
from
${thisTable}
where
BIANMA = #{BIANMA}
</select>
<!-- 通过编码获取其子级列表 -->
<select id="findChildByBianmalistPage" parameterType="page"
resultType="pd">
select
<include refid="Field"></include>
from
<include refid="tableName"></include>
where
PARENT_ID = (select DICTIONARIES_ID from
<include refid="tableName"></include>
where
BIANMA = #{pd.BIANMA})
<if test="pd.STATE == 'null'">
and STATE is null
</if>
<if test="pd.STATE == 'notnull'">
and STATE is not null
</if>
order by ORDER_BY
</select>
</mapper>
system4
最新推荐文章于 2024-01-06 16:54:37 发布