| | |
| | | <resultMap type="com.smartor.domain.SvyTaskTemplateScript" id="SvyTaskTemplateScriptResult"> |
| | | <result property="id" column="id"/> |
| | | <result property="taskid" column="taskid"/> |
| | | <result property="ishide" column="ishide"/> |
| | | <result property="scriptno" column="scriptno"/> |
| | | <result property="templateID" column="templateID"/> |
| | | <result property="scriptid" column="scriptid"/> |
| | |
| | | <sql id="selectSvyTaskTemplateScriptVo"> |
| | | select id, |
| | | sort, |
| | | ishide, |
| | | prompt, |
| | | group_name, |
| | | branch_flag, |
| | |
| | | <include refid="selectSvyTaskTemplateScriptVo"/> |
| | | <where> |
| | | <if test="taskid != null ">and taskid = #{taskid}</if> |
| | | <if test="ishide != null ">and ishide = #{ishide}</if> |
| | | <if test="scriptno != null ">and scriptno = #{scriptno}</if> |
| | | <if test="templateID != null ">and templateID = #{templateID}</if> |
| | | <if test="scriptid != null ">and scriptid = #{scriptid}</if> |
| | |
| | | <if test="score != null ">score,</if> |
| | | <if test="prompt != null ">prompt,</if> |
| | | <if test="groupName != null ">group_name,</if> |
| | | <if test="ishide != null ">ishide,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="taskid != null">#{taskid},</if> |
| | |
| | | <if test="score != null ">#{score},</if> |
| | | <if test="prompt != null ">#{prompt},</if> |
| | | <if test="groupName != null ">#{groupName},</if> |
| | | <if test="ishide != null ">#{ishide},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | |
| | | <if test="score != null">score = #{score},</if> |
| | | <if test="prompt != null">prompt = #{prompt},</if> |
| | | <if test="groupName != null ">group_name = #{groupName},</if> |
| | | <if test="ishide != null ">ishide = #{ishide},</if> |
| | | </trim> |
| | | where id = #{d} |
| | | </update> |