若依开发笔记1

1.id自增不连续问题

SET @i=0;
UPDATE `mbs_order` SET `id`=(@i:=@i+1);
ALTER TABLE `mbs_order` AUTO_INCREMENT=0;

2.逻辑删除问题

    <delete id="deletePendingWorklistById" parameterType="Long">
--         delete from pending_worklist where id = #{id}
        update pending_worklist set is_deleted = '2' where id = #{id}
    </delete>

    <delete id="deletePendingWorklistByIds" parameterType="String">
        update pending_worklist set is_deleted = '2' where id in
--         delete from pending_worklist where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>


  <select id="selectPendingWorklistList" parameterType="com.ruoyi.worklist.domain.PendingWorklistQuery" resultMap="PendingWorklistResult">
        <include refid="selectPendingWorklistVo"/>
        where is_deleted='0'

同时实体类增加is_deleted类