<update id="LockOrders" parameterClass="java.util.HashMap"> UPDATE orders$routeTableNameSuffix$ SET UPDATEDATE=now(), Executor=#executor#, state = (case when state >= 100 then state else state + 100 end) WHERE id in <iterate property="orderIdList" open="(" close=")" conjunction=","> #orderIdList[]# </iterate> <![CDATA[ and splittype != -1]]> and yn=1 and ( (state=0 or state=100) or ((state=5) or (state=105)) or ((state=6 and state2=9) or (state=106 and state2=9)) or ((state=6 and state2=0) or (state=106 and state2=0)) or (state=8 or state=108) or ((state=7 and state2=9 and printx=1) or (state=107 and state2=9 and printx=1)) or ((state=7 and state2=9 and printx=4) or (state=107 and state2=9 and printx=4)) or ((state=7 and state2=9 and printx=3) or (state=107 and state2=9 and printx=3)) ) </update>
动态设置
最新推荐文章于 2021-04-26 16:59:43 发布