From adf588cd4322f705cfa06d87e18a4075709df16f Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期二, 19 三月 2024 16:49:11 +0800
Subject: [PATCH] 卡口过车数据一致性

---
 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java             |  143 ++++++++++++++
 ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java            |   62 ++++++
 ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java         |   62 ++++++
 ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java    |   91 +++++++++
 ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java |   91 +++++++++
 ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml                    |  103 ++++++++++
 6 files changed, 552 insertions(+), 0 deletions(-)

diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java
new file mode 100644
index 0000000..9ad0356
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/VehicleDataMonitor.java
@@ -0,0 +1,143 @@
+package com.ycl.platform.domain.entity;
+
+import annotation.Excel;
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import com.ycl.system.entity.BaseEntity;
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+
+/**
+ * 鍗″彛杩囪溅鏁版嵁涓�鑷存�у璞� t_vehicle_data_monitor
+ *
+ * @author gonghl
+ * @date 2024-03-19
+ */
+public class VehicleDataMonitor extends BaseEntity {
+    private static final long serialVersionUID = 1L;
+
+    /**
+     * $column.columnComment
+     */
+    private Integer id;
+
+    /**
+     * 鍦板尯缂栫爜
+     */
+    private String regionCode;
+
+    /**
+     * 鍗″彛鍚嶇О
+     */
+    @Excel(name = "鍗″彛鍚嶇О")
+    private String bayonetName;
+
+    /**
+     * 鍗″彛缂栧彿
+     */
+    @Excel(name = "鍗″彛缂栧彿")
+    private String bayonetNumber;
+
+    /**
+     * 杩囪溅鏁版嵁閲�
+     */
+    @Excel(name = "杩囪溅鏁版嵁閲�")
+    private Integer vehicleDataNumber;
+
+    /**
+     * 涓嶅敮涓�鏁版嵁
+     */
+    @Excel(name = "涓嶅敮涓�鏁版嵁 ")
+    private Integer notUniqueData;
+
+    /**
+     * 涓嶅敮涓�鏁版嵁閲�
+     */
+    @Excel(name = "涓嶅敮涓�鏁版嵁閲�")
+    private Integer notUniqueDataNumber;
+
+    /**
+     * 閫昏緫鍒犻櫎
+     */
+    @TableLogic
+    private String deleted;
+
+    public void setId(Integer id) {
+        this.id = id;
+    }
+
+    public Integer getId() {
+        return id;
+    }
+
+    public void setRegionCode(String regionCode) {
+        this.regionCode = regionCode;
+    }
+
+    public String getRegionCode() {
+        return regionCode;
+    }
+
+    public void setBayonetName(String bayonetName) {
+        this.bayonetName = bayonetName;
+    }
+
+    public String getBayonetName() {
+        return bayonetName;
+    }
+
+    public void setBayonetNumber(String bayonetNumber) {
+        this.bayonetNumber = bayonetNumber;
+    }
+
+    public String getBayonetNumber() {
+        return bayonetNumber;
+    }
+
+    public void setVehicleDataNumber(Integer vehicleDataNumber) {
+        this.vehicleDataNumber = vehicleDataNumber;
+    }
+
+    public Integer getVehicleDataNumber() {
+        return vehicleDataNumber;
+    }
+
+    public void setNotUniqueData(Integer notUniqueData) {
+        this.notUniqueData = notUniqueData;
+    }
+
+    public Integer getNotUniqueData() {
+        return notUniqueData;
+    }
+
+    public void setNotUniqueDataNumber(Integer notUniqueDataNumber) {
+        this.notUniqueDataNumber = notUniqueDataNumber;
+    }
+
+    public Integer getNotUniqueDataNumber() {
+        return notUniqueDataNumber;
+    }
+
+    public void setDeleted(String deleted) {
+        this.deleted = deleted;
+    }
+
+    public String getDeleted() {
+        return deleted;
+    }
+
+    @Override
+    public String toString() {
+        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
+                .append("id", getId())
+                .append("regionCode", getRegionCode())
+                .append("bayonetName", getBayonetName())
+                .append("bayonetNumber", getBayonetNumber())
+                .append("vehicleDataNumber", getVehicleDataNumber())
+                .append("notUniqueData", getNotUniqueData())
+                .append("notUniqueDataNumber", getNotUniqueDataNumber())
+                .append("createTime", getCreateTime())
+                .append("updateTime", getUpdateTime())
+                .append("deleted", getDeleted())
+                .toString();
+    }
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java b/ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java
new file mode 100644
index 0000000..744c8ae
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/controller/VehicleDataMonitorController.java
@@ -0,0 +1,91 @@
+package com.ycl.platform.controller;
+
+import annotation.Log;
+import com.ycl.platform.domain.entity.VehicleDataMonitor;
+import com.ycl.platform.service.IVehicleDataMonitorService;
+import com.ycl.system.AjaxResult;
+import com.ycl.system.controller.BaseController;
+import com.ycl.system.page.TableDataInfo;
+import com.ycl.utils.poi.ExcelUtil;
+import enumeration.BusinessType;
+import jakarta.servlet.http.HttpServletResponse;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+/**
+ * 鍗″彛杩囪溅鏁版嵁涓�鑷存�ontroller
+ *
+ * @author gonghl
+ * @date 2024-03-19
+ */
+@RestController
+@RequestMapping("/platform/platform")
+public class VehicleDataMonitorController extends BaseController {
+    @Autowired
+    private IVehicleDataMonitorService vehicleDataMonitorService;
+
+    /**
+     * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛�
+     */
+    @PreAuthorize("@ss.hasPermi('platform:platform:list')")
+    @GetMapping("/list")
+    public TableDataInfo list(VehicleDataMonitor vehicleDataMonitor) {
+        startPage();
+        List<VehicleDataMonitor> list = vehicleDataMonitorService.selectVehicleDataMonitorList(vehicleDataMonitor);
+        return getDataTable(list);
+    }
+
+    /**
+     * 瀵煎嚭鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛�
+     */
+    @PreAuthorize("@ss.hasPermi('platform:platform:export')")
+    @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.EXPORT)
+    @PostMapping("/export")
+    public void export(HttpServletResponse response, VehicleDataMonitor vehicleDataMonitor) {
+        List<VehicleDataMonitor> list = vehicleDataMonitorService.selectVehicleDataMonitorList(vehicleDataMonitor);
+        ExcelUtil<VehicleDataMonitor> util = new ExcelUtil<VehicleDataMonitor>(VehicleDataMonitor.class);
+        util.exportExcel(response, list, "鍗″彛杩囪溅鏁版嵁涓�鑷存�ф暟鎹�");
+    }
+
+    /**
+     * 鑾峰彇鍗″彛杩囪溅鏁版嵁涓�鑷存�ц缁嗕俊鎭�
+     */
+    @PreAuthorize("@ss.hasPermi('platform:platform:query')")
+    @GetMapping(value = "/{id}")
+    public AjaxResult getInfo(@PathVariable("id") Integer id) {
+        return success(vehicleDataMonitorService.selectVehicleDataMonitorById(id));
+    }
+
+    /**
+     * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     */
+    @PreAuthorize("@ss.hasPermi('platform:platform:add')")
+    @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.INSERT)
+    @PostMapping
+    public AjaxResult add(@RequestBody VehicleDataMonitor vehicleDataMonitor) {
+        return toAjax(vehicleDataMonitorService.insertVehicleDataMonitor(vehicleDataMonitor));
+    }
+
+    /**
+     * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     */
+    @PreAuthorize("@ss.hasPermi('platform:platform:edit')")
+    @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.UPDATE)
+    @PutMapping
+    public AjaxResult edit(@RequestBody VehicleDataMonitor vehicleDataMonitor) {
+        return toAjax(vehicleDataMonitorService.updateVehicleDataMonitor(vehicleDataMonitor));
+    }
+
+    /**
+     * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     */
+    @PreAuthorize("@ss.hasPermi('platform:platform:remove')")
+    @Log(title = "鍗″彛杩囪溅鏁版嵁涓�鑷存��", businessType = BusinessType.DELETE)
+    @DeleteMapping("/{ids}")
+    public AjaxResult remove(@PathVariable Integer[] ids) {
+        return toAjax(vehicleDataMonitorService.deleteVehicleDataMonitorByIds(ids));
+    }
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java
new file mode 100644
index 0000000..36d9be1
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/VehicleDataMonitorMapper.java
@@ -0,0 +1,62 @@
+package com.ycl.platform.mapper;
+
+
+import com.ycl.platform.domain.entity.VehicleDataMonitor;
+
+import java.util.List;
+
+/**
+ * 鍗″彛杩囪溅鏁版嵁涓�鑷存�apper鎺ュ彛
+ *
+ * @author gonghl
+ * @date 2024-03-19
+ */
+public interface VehicleDataMonitorMapper {
+    /**
+     * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿�
+     * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     */
+    public VehicleDataMonitor selectVehicleDataMonitorById(Integer id);
+
+    /**
+     * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛�
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�ч泦鍚�
+     */
+    public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor);
+
+    /**
+     * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 缁撴灉
+     */
+    public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);
+
+    /**
+     * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 缁撴灉
+     */
+    public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);
+
+    /**
+     * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿�
+     * @return 缁撴灉
+     */
+    public int deleteVehicleDataMonitorById(Integer id);
+
+    /**
+     * 鎵归噺鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+     * @return 缁撴灉
+     */
+    public int deleteVehicleDataMonitorByIds(Integer[] ids);
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java b/ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java
new file mode 100644
index 0000000..a43a9ce
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/IVehicleDataMonitorService.java
@@ -0,0 +1,62 @@
+package com.ycl.platform.service;
+
+
+import com.ycl.platform.domain.entity.VehicleDataMonitor;
+
+import java.util.List;
+
+/**
+ * 鍗″彛杩囪溅鏁版嵁涓�鑷存�ervice鎺ュ彛
+ *
+ * @author gonghl
+ * @date 2024-03-19
+ */
+public interface IVehicleDataMonitorService {
+    /**
+     * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿�
+     * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     */
+    public VehicleDataMonitor selectVehicleDataMonitorById(Integer id);
+
+    /**
+     * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛�
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存�ч泦鍚�
+     */
+    public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor);
+
+    /**
+     * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 缁撴灉
+     */
+    public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);
+
+    /**
+     * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 缁撴灉
+     */
+    public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor);
+
+    /**
+     * 鎵归噺鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param ids 闇�瑕佸垹闄ょ殑鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿泦鍚�
+     * @return 缁撴灉
+     */
+    public int deleteVehicleDataMonitorByIds(Integer[] ids);
+
+    /**
+     * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�т俊鎭�
+     *
+     * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿�
+     * @return 缁撴灉
+     */
+    public int deleteVehicleDataMonitorById(Integer id);
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java
new file mode 100644
index 0000000..170339a
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/VehicleDataMonitorServiceImpl.java
@@ -0,0 +1,91 @@
+package com.ycl.platform.service.impl;
+
+import com.ycl.platform.domain.entity.VehicleDataMonitor;
+import com.ycl.platform.mapper.VehicleDataMonitorMapper;
+import com.ycl.platform.service.IVehicleDataMonitorService;
+import com.ycl.utils.DateUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+
+/**
+ * 鍗″彛杩囪溅鏁版嵁涓�鑷存�ervice涓氬姟灞傚鐞�
+ *
+ * @author gonghl
+ * @date 2024-03-19
+ */
+@Service
+public class VehicleDataMonitorServiceImpl implements IVehicleDataMonitorService {
+    @Autowired
+    private VehicleDataMonitorMapper vehicleDataMonitorMapper;
+
+    /**
+     * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿�
+     * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     */
+    @Override
+    public VehicleDataMonitor selectVehicleDataMonitorById(Integer id) {
+        return vehicleDataMonitorMapper.selectVehicleDataMonitorById(id);
+    }
+
+    /**
+     * 鏌ヨ鍗″彛杩囪溅鏁版嵁涓�鑷存�у垪琛�
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     */
+    @Override
+    public List<VehicleDataMonitor> selectVehicleDataMonitorList(VehicleDataMonitor vehicleDataMonitor) {
+        return vehicleDataMonitorMapper.selectVehicleDataMonitorList(vehicleDataMonitor);
+    }
+
+    /**
+     * 鏂板鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 缁撴灉
+     */
+    @Override
+    public int insertVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor) {
+        vehicleDataMonitor.setCreateTime(DateUtils.getNowDate());
+        vehicleDataMonitor.setDeleted("0");
+        return vehicleDataMonitorMapper.insertVehicleDataMonitor(vehicleDataMonitor);
+    }
+
+    /**
+     * 淇敼鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param vehicleDataMonitor 鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     * @return 缁撴灉
+     */
+    @Override
+    public int updateVehicleDataMonitor(VehicleDataMonitor vehicleDataMonitor) {
+        vehicleDataMonitor.setUpdateTime(DateUtils.getNowDate());
+        return vehicleDataMonitorMapper.updateVehicleDataMonitor(vehicleDataMonitor);
+    }
+
+    /**
+     * 鎵归噺鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存��
+     *
+     * @param ids 闇�瑕佸垹闄ょ殑鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿�
+     * @return 缁撴灉
+     */
+    @Override
+    public int deleteVehicleDataMonitorByIds(Integer[] ids) {
+        return vehicleDataMonitorMapper.deleteVehicleDataMonitorByIds(ids);
+    }
+
+    /**
+     * 鍒犻櫎鍗″彛杩囪溅鏁版嵁涓�鑷存�т俊鎭�
+     *
+     * @param id 鍗″彛杩囪溅鏁版嵁涓�鑷存�т富閿�
+     * @return 缁撴灉
+     */
+    @Override
+    public int deleteVehicleDataMonitorById(Integer id) {
+        return vehicleDataMonitorMapper.deleteVehicleDataMonitorById(id);
+    }
+}
diff --git a/ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml
new file mode 100644
index 0000000..e34e0fb
--- /dev/null
+++ b/ycl-server/src/main/resources/mapper/zgyw/VehicleDataMonitorMapper.xml
@@ -0,0 +1,103 @@
+<?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.ycl.platform.mapper.VehicleDataMonitorMapper">
+
+    <resultMap type="com.ycl.platform.domain.entity.VehicleDataMonitor" id="VehicleDataMonitorResult">
+        <result property="id" column="id"/>
+        <result property="regionCode" column="region_code"/>
+        <result property="bayonetName" column="bayonet_name"/>
+        <result property="bayonetNumber" column="bayonet_number"/>
+        <result property="vehicleDataNumber" column="vehicle_data_number"/>
+        <result property="notUniqueData" column="not_unique_data"/>
+        <result property="notUniqueDataNumber" column="not_unique_data_number"/>
+        <result property="createTime" column="create_time"/>
+        <result property="updateTime" column="update_time"/>
+        <result property="deleted" column="deleted"/>
+    </resultMap>
+
+    <sql id="selectVehicleDataMonitorVo">
+        select id,
+               region_code,
+               bayonet_name,
+               bayonet_number,
+               vehicle_data_number,
+               not_unique_data,
+               not_unique_data_number,
+               create_time,
+               update_time,
+               deleted
+        from t_vehicle_data_monitor
+    </sql>
+
+    <select id="selectVehicleDataMonitorList" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor" resultMap="VehicleDataMonitorResult">
+        <include refid="selectVehicleDataMonitorVo"/>
+        <where>
+            deleted != 1
+            <if test="regionCode != null  and regionCode != ''">and region_code = #{regionCode}</if>
+            <if test="bayonetName != null  and bayonetName != ''">and bayonet_name like concat('%', #{bayonetName}, '%')</if>
+            <if test="bayonetNumber != null  and bayonetNumber != ''">and bayonet_number like concat('%', #{bayonetNumber}, '%')</if>
+        </where>
+    </select>
+
+    <select id="selectVehicleDataMonitorById" parameterType="Integer" resultMap="VehicleDataMonitorResult">
+        <include refid="selectVehicleDataMonitorVo"/>
+        where id = #{id}
+    </select>
+
+    <insert id="insertVehicleDataMonitor" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor" useGeneratedKeys="true" keyProperty="id">
+        insert into t_vehicle_data_monitor
+        <trim prefix="(" suffix=")" suffixOverrides=",">
+            <if test="regionCode != null">region_code,</if>
+            <if test="bayonetName != null and bayonetName != ''">bayonet_name,</if>
+            <if test="bayonetNumber != null and bayonetNumber != ''">bayonet_number,</if>
+            <if test="vehicleDataNumber != null">vehicle_data_number,</if>
+            <if test="notUniqueData != null">not_unique_data,</if>
+            <if test="notUniqueDataNumber != null">not_unique_data_number,</if>
+            <if test="createTime != null">create_time,</if>
+            <if test="updateTime != null">update_time,</if>
+            <if test="deleted != null">deleted,</if>
+        </trim>
+        <trim prefix="values (" suffix=")" suffixOverrides=",">
+            <if test="regionCode != null">#{regionCode},</if>
+            <if test="bayonetName != null and bayonetName != ''">#{bayonetName},</if>
+            <if test="bayonetNumber != null and bayonetNumber != ''">#{bayonetNumber},</if>
+            <if test="vehicleDataNumber != null">#{vehicleDataNumber},</if>
+            <if test="notUniqueData != null">#{notUniqueData},</if>
+            <if test="notUniqueDataNumber != null">#{notUniqueDataNumber},</if>
+            <if test="createTime != null">#{createTime},</if>
+            <if test="updateTime != null">#{updateTime},</if>
+            <if test="deleted != null">#{deleted},</if>
+        </trim>
+    </insert>
+
+    <update id="updateVehicleDataMonitor" parameterType="com.ycl.platform.domain.entity.VehicleDataMonitor">
+        update t_vehicle_data_monitor
+        <trim prefix="SET" suffixOverrides=",">
+            <if test="regionCode != null">region_code = #{regionCode},</if>
+            <if test="bayonetName != null and bayonetName != ''">bayonet_name = #{bayonetName},</if>
+            <if test="bayonetNumber != null and bayonetNumber != ''">bayonet_number = #{bayonetNumber},</if>
+            <if test="vehicleDataNumber != null">vehicle_data_number = #{vehicleDataNumber},</if>
+            <if test="notUniqueData != null">not_unique_data = #{notUniqueData},</if>
+            <if test="notUniqueDataNumber != null">not_unique_data_number = #{notUniqueDataNumber},</if>
+            <if test="createTime != null">create_time = #{createTime},</if>
+            <if test="updateTime != null">update_time = #{updateTime},</if>
+            <if test="deleted != null">deleted = #{deleted},</if>
+        </trim>
+        where id = #{id}
+    </update>
+
+    <delete id="deleteVehicleDataMonitorById" parameterType="Integer">
+        delete
+        from t_vehicle_data_monitor
+        where id = #{id}
+    </delete>
+
+    <delete id="deleteVehicleDataMonitorByIds" parameterType="String">
+        delete from t_vehicle_data_monitor where id in
+        <foreach item="id" collection="array" open="(" separator="," close=")">
+            #{id}
+        </foreach>
+    </delete>
+</mapper>
\ No newline at end of file

--
Gitblit v1.8.0