new">
ORG_ID = #{orgId}
|
|
|
43
|
<foreach collection="dataList" item="item" separator=",">
|
|
|
44
|
OUT_DATE = #{item.outDate},
|
|
|
45
|
DONE_DATE = #{item.doneDate},
|
|
|
46
|
OP_ID = #{item.opId},
|
|
|
47
|
ORG_ID = #{item.orgId}
|
|
|
48
|
</foreach>
|
|
47
|
49
|
</set>
|
|
48
|
50
|
|
|
49
|
51
|
WHERE RECORD_ID IN
|
|
50
|
|
<foreach collection="recordIdList" index="index" item="item" separator="," open="(" close=")">
|
|
51
|
|
#{item,jdbcType=BIGINT}
|
|
|
52
|
|
|
|
53
|
<foreach collection="dataList" item="item" separator="," open="(" close=")">
|
|
|
54
|
#{item.recordId}
|
|
52
|
55
|
</foreach>
|
|
53
|
56
|
</update>
|
|
54
|
57
|
]]>
|
|
55
|
58
|
</sql>
|
|
56
|
59
|
|
|
57
|
|
<sql name="testInsert">
|
|
58
|
|
<![CDATA[
|
|
59
|
|
<insert id="testInsert" parameterType="java.util.Map" useGeneratedKeys="true" keyProperty="RECORD_ID">
|
|
60
|
|
|
|
61
|
|
INSERT INTO LR_AREA_IN_OUT_RECORD (
|
|
62
|
|
MAP_TAG_ID,EMPLOYEE_ID,DEVICE_ID
|
|
63
|
|
) VALUES
|
|
64
|
|
<foreach collection="dataList" item="item" separator=",">
|
|
65
|
|
(
|
|
66
|
|
#{item.mapTagId},
|
|
67
|
|
#{item.employeeId},
|
|
68
|
|
#{item.deviceId}
|
|
69
|
|
|
|
70
|
|
)
|
|
71
|
|
</foreach>
|
|
72
|
|
|
|
73
|
|
</insert>
|
|
74
|
|
]]>
|
|
75
|
|
</sql>
|
|
76
|
60
|
</sqls>
|