src/main/resources/mybatis/system/OaSysviolationtableMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.ruoyi.project.system.sysviolationtable.mapper.OaSysviolationtableMapper">
    
    <resultMap type="OaSysviolationtable" id="OaSysviolationtableResult">
        <result property="id"    column="id"    />
        <result property="orderNumber"    column="orderNumber"    />
        <result property="carNumber"    column="carNumber"    />
        <result property="custOmerName"    column="custOmerName"    />
        <result property="custOmerCard"    column="custOmerCard"    />
        <result property="customerPhone"    column="customerPhone"    />
        <result property="weiZhangTime"    column="weiZhangTime"    />
        <result property="vilationCount"    column="vilationCount"    />
        <result property="vilationKouFen"    column="vilationKouFen"    />
        <result property="vilationFaKuan"    column="vilationFaKuan"    />
        <result property="violationStatus"    column="violationStatus"    />
        <result property="operationTime"    column="operationTime"    />
        <result property="violationLocationName"    column="violationLocationName"    />
        <result property="violationPictures"    column="violationPictures"    />
        <result property="operationUser"    column="operationUser"    />
    </resultMap>

    <sql id="selectOaSysviolationtableVo">
        select id, orderNumber, carNumber, custOmerName, custOmerCard, customerPhone, weiZhangTime, vilationCount, vilationKouFen, vilationFaKuan, violationStatus, operationTime, violationLocationName, violationPictures, operationUser from oa_sysviolationtable
    </sql>

    <select id="selectOaSysviolationtableList" parameterType="OaSysviolationtable" resultMap="OaSysviolationtableResult">
        <include refid="selectOaSysviolationtableVo"/>
        <where>  
            <if test="carNumber != null  and carNumber != ''"> and carNumber like concat('%', #{carNumber}, '%')</if>
            <if test="custOmerName != null  and custOmerName != ''"> and custOmerName like concat('%', #{custOmerName}, '%')</if>
            <if test="customerPhone != null  and customerPhone != ''"> and customerPhone like concat('%', #{customerPhone}, '%')</if>
        </where>
    </select>
    
    <select id="selectOaSysviolationtableById" parameterType="Long" resultMap="OaSysviolationtableResult">
        <include refid="selectOaSysviolationtableVo"/>
        where id = #{id}
    </select>


    <insert id="insertOaSysviolationtable" parameterType="OaSysviolationtable" useGeneratedKeys="true" keyProperty="id">
        insert into oa_sysviolationtable
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="orderNumber != null">orderNumber,</if>
            <if test="carNumber != null">carNumber,</if>
            <if test="custOmerName != null">custOmerName,</if>
            <if test="custOmerCard != null">custOmerCard,</if>
            <if test="customerPhone != null">customerPhone,</if>
            <if test="weiZhangTime != null">weiZhangTime,</if>
            <if test="vilationCount != null">vilationCount,</if>
            <if test="vilationKouFen != null">vilationKouFen,</if>
            <if test="vilationFaKuan != null">vilationFaKuan,</if>
            <if test="violationStatus != null">violationStatus,</if>
            <if test="operationTime != null">operationTime,</if>
            <if test="violationLocationName != null">violationLocationName,</if>
            <if test="violationPictures != null">violationPictures,</if>
            <if test="operationUser != null">operationUser,</if>