行政区查询，添加了deleted != 1条件

liurunyu

2023-11-16 c889621e732862353911ecc1049dc44f0c592db9

行政区查询，添加了deleted != 1条件

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaDistrictMapper.xml

@@ -30,7 +30,7 @@
    select
    <include refid="Base_Column_List" />
    from ba_district
    where level = #{level,jdbcType=TINYINT}
    where deleted != 1 and level = #{level,jdbcType=TINYINT}
  </select>

  <select id="selectBySupperId" parameterType="java.lang.Long" resultMap="BaseResultMap">
@@ -38,7 +38,7 @@
    select
    <include refid="Base_Column_List" />
    from ba_district
    where supperId = #{supperId,jdbcType=BIGINT}
    where deleted != 1 and supperId = #{supperId,jdbcType=BIGINT}
  </select>

  <insert id="insert" parameterType="com.dy.pipIrrGlobal.pojoBa.BaDistrict">