堰顶高程

aix

2024-07-24 45dd5b7936714718a84f90183084334d259292cc

堰顶高程

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml

@@ -158,12 +158,14 @@
            arb."eng_scal",
            arb."res_loc" ,
            arb."res_reg_code",
            arrn."tb_weir_top_elevation" as tbWeirTopElevation,
            <include refid="resBase"></include>
        FROM "att_res_base" arb
        left join "att_ad_base" town on town."guid" = arb."interior_ad_guid"
        left join "att_ad_base" county on town."p_ad_code" = county."ad_code"
        left join "att_ad_base" city on county."p_ad_code" = city."ad_code"
        left join "att_ad_base" province on city."p_ad_code" = province."ad_code"
        left join "att_res_rsb_norspi" arrn on arb."guid" = arrn."res_guid"
        WHERE arb."is_deleted"=0
        <if test="obj.code != null and obj.code != '' ">
            and (town."ad_code" = #{obj.code} or county."ad_code" = #{obj.code} or city."ad_code" = #{obj.code} or province."ad_code"

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/AttResBaseVO.java

@@ -26,4 +26,5 @@

    private String townCode;
    private String townName;
    private String tbWeirTopElevation;
}