| | |
|---|
| | | county."guid" as countyCode, |
|---|
| | | county."ad_name" as countyName, |
|---|
| | | |
|---|
| | | arb."name" as reservoirName |
|---|
| | | arb."name" as reservoirName, |
|---|
| | | acb."cd_nm" as cdName |
|---|
| | | |
|---|
| | | FROM NKY_ALARM_GET NAG |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | LEFT JOIN SJZT_MD."att_bas_base" abb ON abb."code" = rrbl."bas_guid" |
|---|
| | | LEFT JOIN SJZT_MD."att_bas_base" pabb ON abb."p_code" = pabb."code" |
|---|
| | | LEFT JOIN SJZT_MD."att_cd_base" acb ON acb."res_cd" = NAG.DAM_ID AND NAG.POINT_ID = acb."cd" |
|---|
| | | WHERE 1=1 |
|---|
| | | <if test=" vo.adCode != null and vo.adCode !='' "> |
|---|
| | | AND (province."ad_code" =#{vo.adCode} or city."ad_code" = #{vo.adCode} or county."ad_code" = #{vo.adCode}) |
|---|
