| | |
| | | <result property="palyMoney" column="paly_money" /> |
| | | <result property="creationTime" column="creation_time" /> |
| | | <result property="updateTime" column="update_time" /> |
| | | <result property="abolishTime" column="abolish_time" /> |
| | | </resultMap> |
| | | |
| | | <!-- 分页查询 --> |
| | |
| | | jso.cancel_type, |
| | | jso.update_time, |
| | | jso.cancel_time, |
| | | jso.abolish_time, |
| | | jso.paly_money |
| | | from jinhui_shopping_order as jso |
| | | LEFT JOIN sys_user su ON jso.user_id = su.user_id |
| | |
| | | jso.cancel_type, |
| | | jso.update_time, |
| | | jso.cancel_time, |
| | | jso.abolish_time, |
| | | jso.paly_money |
| | | from jinhui_shopping_order as jso |
| | | LEFT JOIN sys_user su ON jso.user_id = su.user_id |
| | |
| | | <if test="item.cancelType != null and item.cancelType != '' "> |
| | | cancel_type, |
| | | </if> |
| | | <if test="item.cancelTime != null and item.cancelTime != '' "> |
| | | <if test="item.cancelTime != null "> |
| | | cancel_time, |
| | | </if> |
| | | <if test="item.palyMoney != null and item.palyMoney != '' "> |
| | | paly_money, |
| | | </if> |
| | | <if test="item.abolishTime != null"> |
| | | abolish_time, |
| | | </if> |
| | | creation_time |
| | | </trim> |
| | |
| | | <if test="item.cancelType != null and item.cancelType != '' "> |
| | | #{item.cancelType}, |
| | | </if> |
| | | <if test="item.cancelTime != null and item.cancelTime != '' "> |
| | | <if test="item.cancelTime != null "> |
| | | #{item.cancelTime}, |
| | | </if> |
| | | <if test="item.palyMoney != null and item.palyMoney != '' "> |
| | | #{item.palyMoney}, |
| | | </if> |
| | | <if test="item.abolishTime != null"> |
| | | #{item.abolishTime}, |
| | | </if> |
| | | sysdate() |
| | | </trim> |
| | |
| | | <if test="item.cancelType != null and item.cancelType != '' "> |
| | | cancel_type=#{item.cancelType}, |
| | | </if> |
| | | <if test="item.cancelTime != null and item.cancelTime != '' "> |
| | | <if test="item.cancelTime != null "> |
| | | cancel_time=#{item.cancelTime}, |
| | | </if> |
| | | <if test="item.palyMoney != null and item.palyMoney != '' "> |
| | | paly_money=#{item.palyMoney}, |
| | | </if> |
| | | <if test="item.abolishTime != null"> |
| | | abolish_time=#{item.abolishTime}, |
| | | </if> |
| | | update_time=sysdate() |
| | | </set> |
| | | where id = #{item.id} |