<?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="com.casking.ccss.modules.qm.dao.QuestionDetailDao">
<sql id="questionDetailColumns">
C_Q_D_ID AS "dId",
C_Q_ID AS "qId",
C_Q_D_NAME AS "dName",
C_Q_D_VALUE AS "dValue",
C_Q_D_ORDER AS "order"
</sql>
<!-- findList2 -->
<select id="findList" resultType="QuestionDetail">
SELECT
<include refid="questionDetailColumns"/>
FROM C_QUESTION_DETAILS A
WHERE 1 = 1
<if test="qId != null">
AND A.C_Q_ID = #{qId}
</if>
</select>
<!-- <insert id="insertListByqId">
INSERT All
<foreach collection="list" item="item" index="index" separator="union all">
INTO C_QUESTION_DETAILS(
C_Q_D_ID,
C_Q_ID,
C_Q_D_NAME,
C_Q_D_VALUE,
C_Q_D_ORDER
)Values
(
'a',
'a',
'a',
'a',
'a'
#{list.qId},
#{list.dId},
#{list.dName},
#{list.dValue},
#{list.qOrder}
)
</foreach>
SELECT 1 FROM DUAL
</insert> -->
<insert id="insertListByqId" parameterType="ArrayList" >
INSERT INTO C_QUESTION_DETAILS(
C_Q_D_ID,
C_Q_ID,
C_Q_D_NAME,
C_Q_D_VALUE,
C_Q_D_ORDER
)
<foreach collection="list" item="item" index="index" separator="union all">
select
sys_guid(),
#{item.qId},
#{item.dName},
#{item.dValue},
#{item.order}
FROM dual
</foreach>
</insert>
<delete id="delete">
delete from C_QUESTION_DETAILS where C_Q_ID=#{qId}
</delete>
<delete id="updateOptionsByqId" parameterType="ArrayList">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
UPDATE C_QUESTION_DETAILS
set C_Q_D_NAME=#{item.dName},C_Q_D_VALUE=#{item.dValue},C_Q_D_ORDER=#{item.order}
where
C_Q_D_ID= #{item.dId}
</foreach>
</delete>
</mapper>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.casking.ccss.modules.qm.dao.QuestionDetailDao">
<sql id="questionDetailColumns">
C_Q_D_ID AS "dId",
C_Q_ID AS "qId",
C_Q_D_NAME AS "dName",
C_Q_D_VALUE AS "dValue",
C_Q_D_ORDER AS "order"
</sql>
<!-- findList2 -->
<select id="findList" resultType="QuestionDetail">
SELECT
<include refid="questionDetailColumns"/>
FROM C_QUESTION_DETAILS A
WHERE 1 = 1
<if test="qId != null">
AND A.C_Q_ID = #{qId}
</if>
</select>
<!-- <insert id="insertListByqId">
INSERT All
<foreach collection="list" item="item" index="index" separator="union all">
INTO C_QUESTION_DETAILS(
C_Q_D_ID,
C_Q_ID,
C_Q_D_NAME,
C_Q_D_VALUE,
C_Q_D_ORDER
)Values
(
'a',
'a',
'a',
'a',
'a'
#{list.qId},
#{list.dId},
#{list.dName},
#{list.dValue},
#{list.qOrder}
)
</foreach>
SELECT 1 FROM DUAL
</insert> -->
<insert id="insertListByqId" parameterType="ArrayList" >
INSERT INTO C_QUESTION_DETAILS(
C_Q_D_ID,
C_Q_ID,
C_Q_D_NAME,
C_Q_D_VALUE,
C_Q_D_ORDER
)
<foreach collection="list" item="item" index="index" separator="union all">
select
sys_guid(),
#{item.qId},
#{item.dName},
#{item.dValue},
#{item.order}
FROM dual
</foreach>
</insert>
<delete id="delete">
delete from C_QUESTION_DETAILS where C_Q_ID=#{qId}
</delete>
<delete id="updateOptionsByqId" parameterType="ArrayList">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
UPDATE C_QUESTION_DETAILS
set C_Q_D_NAME=#{item.dName},C_Q_D_VALUE=#{item.dValue},C_Q_D_ORDER=#{item.order}
where
C_Q_D_ID= #{item.dId}
</foreach>
</delete>
</mapper>