one-code-manage/siwei-modules/siwei-apply/src/main/java/com/siwei/apply/mapper/CadastreFileMapper.java

package com.siwei.apply.mapper;

import com.siwei.apply.domain.CadastreFile;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface CadastreFileMapper {
    /**
     * 新增
     */
    void add(CadastreFile cadastreFile);

    /**
     * 根据ID查询
     */
    CadastreFile get(String id);

    /**
     * 更新
     */
    void update(CadastreFile cadastreFile);

    /**
     * 删除
     */
    void delete(String id);

    /**
     * 批量删除
     */
    void batchDelete(@Param("ids") List<String> ids);


    /**
     * 列表查询
     */
    List<CadastreFile> getList(CadastreFile cadastreFile);

    /**
     * 分页列表查询
     */
    List<CadastreFile> getListByFilter(com.siwei.apply.domain.vo.CadastreFileFilterVo filterVo);

    /**
     * 查询总数（用于分页）
     */
    int getCountByFilter(com.siwei.apply.domain.vo.CadastreFileFilterVo filterVo);


    /**
     * 查询当前表的所有列
     */
    List<String> selectTableCollum(String tableName);

    List<Map<String,String>> selectTableCollumAndType(@Param("tableName") String tableName);

    List<String> selectDistinctValueByField(@Param("tableName") String tableName, @Param("fieldName") String fieldName);

    /**
     * 查询所有表名
     */
    List<String> selectAllTable();


    /**
     * 查询所有表名无视图
     */
    List<String> selectAllTableNoView();

    int insertTableData(@Param("tableName") String tableName, @Param("data") Map<String, Object> data, @Param("shpDbSRID") Integer shpDbSRID);


    String selectGeoms(String tableName);

    /**
     * 增加valid_flag字段
     */
    void addValidFlagColumn(@Param("tableName") String tableName);

    void updateValidFlag(@Param("validFlag") String validFlag, @Param("oldValidFlag") String oldValidFlag, @Param("tableName") String tableName);


    void deleteByValidFlag(@Param("validFlag") String validFlag,@Param("tableName") String tableName);


    Integer countByValidFlag(@Param("validFlag") String validFlag, @Param("tableName") String tableName);

    List<Map<String,Object>> selectTableData(@Param("validFlag") String validFlag, @Param("tableName") String tableName);

    Map<String,Object> selectExistsSameData(@Param("validFlag") String validFlag, @Param("data") Map<String, Object> data, @Param("tableName") String tableName);

    int batchUpdateByBsm(@Param("tableName") String tableName, @Param("list") List<Map<String, Object>> list);

    int batchDeleteByBsm(@Param("tableName") String tableName, @Param("list") List<Map<String, Object>> list);

    List<Map<String,Object>> selectTableDataByCondition(@Param("validFlag") String validFlag, @Param("tableName") String tableName,@Param("bsm") String bsm,@Param("ywh") String ywh);



}