From b397edee2be2dfcc3f28eeac50298b4de26b1afa Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期五, 13 十二月 2024 16:53:45 +0800 Subject: [PATCH] 取水口日取水量表中,出现一些大数,明显不正确,发析系统日志,发现一些阀控器会上报一些累计流量为0的数据,且无规律,推测是其不能从水表读取到累计流量时会上报0值。如果间歇上报0值,间歇上报一些非0值,非0值减去0值,就会出现大数,一天中出现几次那么会大数进行累加,数值将更大。为此变更算法,规避这种情况,但也会丢失一些流量值。 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaDistrictMapper.java | 82 ++++++++++++++++++++++++++-------------- 1 files changed, 53 insertions(+), 29 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaDistrictMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaDistrictMapper.java index 07963e0..bf05ee2 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaDistrictMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaDistrictMapper.java @@ -2,40 +2,14 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoBa.BaDistrict; -import com.dy.pipIrrGlobal.pojoBa.BaPrivilege; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import java.util.List; +import java.util.Map; @Mapper -public interface BaDistrictMapper extends BaseMapper<BaPrivilege> { - /** - * delete by primary key - * @param id primaryKey - * @return deleteCount - */ - int deleteByPrimaryKey(Long id); - - /** - * 閫昏緫鍒犻櫎 - * @param id primaryKey - * @return update count - */ - int deleteLogicById(Long id); - - /** - * insert record to table - * @param record the record - * @return insert count - */ - int insert(BaDistrict record); - - /** - * insert record to table selective - * @param record the record - * @return insert count - */ - int insertSelective(BaDistrict record); +public interface BaDistrictMapper extends BaseMapper<BaDistrict> { /** * select by primary key @@ -59,6 +33,21 @@ List<BaDistrict> selectBySupperId(Long supperId) ; /** + * insert record to table + * @param record the record + * @return insert count + */ + int putin(BaDistrict record); + + /** + * insert record to table selective + * @param record the record + * @return insert count + */ + int insertSelective(BaDistrict record); + + + /** * update record selective * @param record the updated record * @return update count @@ -71,4 +60,39 @@ * @return update count */ int updateByPrimaryKey(BaDistrict record); + + /** + * delete by primary key + * @param id primaryKey + * @return deleteCount + */ + int deleteByPrimaryKey(Long id); + + /** + * 閫昏緫鍒犻櫎 + * @param id primaryKey + * @return update count + */ + int deleteLogicById(Long id); + + /** + * 鏍规嵁鏉戠紪鍙疯幏鍙�5绾у尯鍒掍俊鎭� + * @param villageId 鏉戠紪鍙凤紙涓婚敭锛� + * @return 5绾ц鏀垮尯鍒掍俊鎭� + */ + Map getDistrictsByVillageId(@Param("villageId") Long villageId); + + /** + * 鏍规嵁绾у埆鑾峰彇琛屾斂鍖哄垝鍒楄〃 + * @param level 琛屾斂鍖哄垝灞傜骇 + * @return 琛屾斂鍖哄垝鍒楄〃 + */ + List<Map<String, Object>> getDistrictgsByLevel(@Param("level") Integer level); + + /** + * 鏍规嵁鐖禝D鑾峰彇琛屾斂鍖哄垝鍒楄〃 + * @param supperId 琛屾斂鍖哄垝鐖剁骇ID + * @return 琛屾斂鍖哄垝鍒楄〃 + */ + List<Map<String, Object>> getDistrictsBySupperId(@Param("supperId") Long supperId); } \ No newline at end of file -- Gitblit v1.8.0