From 7a9fd36cadbd5f0d8737955f0edd79e38ef19eaf Mon Sep 17 00:00:00 2001 From: 郑永安 <zyazyz250@sina.com> Date: 星期二, 20 六月 2023 14:48:59 +0800 Subject: [PATCH] SQL异常修复 --- src/main/java/com/nanometer/smartlab/dao/HazardousWasteMapper.java | 17 ++++++++++++++++- 1 files changed, 16 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/nanometer/smartlab/dao/HazardousWasteMapper.java b/src/main/java/com/nanometer/smartlab/dao/HazardousWasteMapper.java index d2617df..5825e2e 100644 --- a/src/main/java/com/nanometer/smartlab/dao/HazardousWasteMapper.java +++ b/src/main/java/com/nanometer/smartlab/dao/HazardousWasteMapper.java @@ -1,6 +1,7 @@ package com.nanometer.smartlab.dao; import com.nanometer.smartlab.entity.HazardousWaste; +import org.apache.ibatis.annotations.Param; import java.util.*; @@ -20,4 +21,18 @@ List<HazardousWaste> selectAll(Map params); int countAll(Map params); -} \ No newline at end of file + + List<Map> selectExportList(Map params); + + int countStatistics(Map<String, Object> params); + + List<HazardousWaste> selectStatistics(Map<String, Object> params); + + List<Map> selectStatisticsExportList(Map<String, Object> params); + + List<HazardousWaste> setAllWasters(@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("status") String status,@Param("applyPerson") String applyPerson); + + HazardousWaste selectByTid(@Param("tid") String tid); + + List<HazardousWaste> setAllWasterCount(@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("status") String status,@Param("applyPerson") String applyPerson); +} -- Gitblit v1.9.2