| | |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.platform.mapper.CheckTemplateMapper"> |
| | | |
| | | |
| | | <resultMap type="com.ycl.platform.domain.entity.CheckTemplate" id="CheckTemplateResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="templateName" column="template_name" /> |
| | |
| | | </where> |
| | | order by examine_tag DESC, examine_category , create_time |
| | | </select> |
| | | |
| | | |
| | | <select id="selectCheckTemplateById" resultMap="CheckTemplateResult"> |
| | | <include refid="selectCheckTemplateVo"/> |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | |
| | | <insert id="insertCheckTemplate" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into t_check_template |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | |
| | | where id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteCheckTemplateById" parameterType="Long"> |
| | | delete from t_check_template where id = #{id} |
| | | </delete> |
| | | <update id="deleteCheckTemplateById"> |
| | | update t_check_template set deleted = 1 where id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteCheckTemplateByIds" parameterType="String"> |
| | | delete from t_check_template where id in |
| | |
| | | </delete> |
| | | |
| | | |
| | | </mapper> |
| | | </mapper> |