<?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.rongwei.bscommon.sys.dao.QuShiftDao">
    <resultMap id="BaseResultMap" type="com.rongwei.bsentity.domin.QuShiftDo">
        <id column="ID" jdbcType="VARCHAR" property="id"/>
        <result column="TENANTID" jdbcType="VARCHAR" property="tenantid"/>
        <result column="ROPTION" jdbcType="VARCHAR" property="roption"/>
        <result column="DELETED" jdbcType="VARCHAR" property="deleted"/>
        <result column="REMARK" jdbcType="VARCHAR" property="remark"/>
        <result column="CREATEDATE" jdbcType="TIMESTAMP" property="createdate"/>
        <result column="CREATEUSERID" jdbcType="VARCHAR" property="createuserid"/>
        <result column="MODIFYDATE" jdbcType="TIMESTAMP" property="modifydate"/>
        <result column="MODIFYUSERID" jdbcType="VARCHAR" property="modifyuserid"/>
        <result column="CREATEUSERNAME" jdbcType="VARCHAR" property="createusername"/>
        <result column="MODIFYUSERNAME" jdbcType="VARCHAR" property="modifyusername"/>
        <result column="WORKSHOP" jdbcType="VARCHAR" property="workshop"/>
        <result column="SECTION" jdbcType="VARCHAR" property="section"/>
        <result column="YEARNUM" jdbcType="INTEGER" property="yearnum"/>
        <result column="MONTHNUM" jdbcType="INTEGER" property="monthnum"/>
    </resultMap>
    <sql id="Base_Column_List">
        ID, TENANTID, ROPTION, DELETED, REMARK, CREATEDATE, CREATEUSERID, MODIFYDATE, MODIFYUSERID,
    CREATEUSERNAME, MODIFYUSERNAME, WORKSHOP, `SECTION`, YEARNUM, MONTHNUM
    </sql>

    <delete id="deleteByIds">
        delete from qu_shift
        <where>
            <if test="idList != null and idList.size() >0">
                ID IN
                <foreach collection="idList" item="id" separator="," open="(" close=")">
                    #{id}
                </foreach>
            </if>
        </where>
    </delete>
</mapper>
