From 3c00fb91eb2f617922730e7d0c56ea0e1ad373e0 Mon Sep 17 00:00:00 2001 From: zmc <zmc_li@foxmail.com> Date: 星期二, 05 九月 2023 18:23:29 +0800 Subject: [PATCH] 新增数据接入接口 --- src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java | 20 ++++++++++++++++---- 1 files changed, 16 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java b/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java index 78094de..7598ab1 100644 --- a/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java +++ b/src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java @@ -1,9 +1,7 @@ package com.job.zsc.mapper; -import com.job.zsc.pojo.AnalysisDustData; -import com.job.zsc.pojo.DustExceptionData; -import com.job.zsc.pojo.DustExceptionType; -import com.job.zsc.pojo.DustSiteData; +import com.job.zsc.pojo.*; +import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; @@ -39,4 +37,18 @@ @Select("select DISTINCT mn_code from dust_exception_data") List<DustExceptionData> exceptionSiteNum(); + + /*鏂板瀹¤鍐呭*/ + @Insert("insert into audit_info(exception_id,checker,checker_content,enterprise_content,audit_status,create_time,update_time) values(#{exceptionId},#{checker},#{checkerContent},#{enterpriseContent},#{auditStatus},#{createTime},#{updateTime})") + void insert(AuditInfo auditInfo); + + @Select("select * from audit_info") + List<AuditInfo> getAuditAllData(); + void update(AuditInfo auditInfo); + + + List<DustExceptionData> getHasAuditedData(String beginTime, String endTime); + + @Insert("insert into dust_global_setting(user,create_time,begin_time,end_time,region,is_regular_time) values( #{user},#{createTime},#{beginTime},#{endTime},#{region},#{isRegularTime})") + void setting(DustDataAccessSetting dustDataAccessSetting); } -- Gitblit v1.9.3