GUID,
AD_CODE,
AD_NAME,
LOW_LEFT_LONG,
LOW_LEFT_LAT,
UP_RIGHT_LONG,
UP_RIGHT_LAT,
AD_GRAD,
NOTE,
STAT
#{guid},
#{adCode},
#{adName},
#{lowLeftLong},
#{lowLeftLat},
#{upRightLong},
#{upRightLat},
#{adGrad},
#{note},
#{stat}
and AD_CODE LIKE '${adCode}%'
and AD_NAME = #{adName}
and AD_TYPE = #{adType}
and LOW_LEFT_LONG = #{lowLeftLong}
and LOW_LEFT_LAT = #{lowLeftLat}
and UP_RIGHT_LONG = #{upRightLong}
and UP_RIGHT_LAT = #{upRightLat}
and AD_GRAD = #{adGrad}
and UP_AD_GUID = #{upAdGuid}
and NOTE = #{note}
and COLL_TIME = #{collTime}
and UPD_TIME = #{updTime}
and STAT = #{stat}
insert into att_ad_base(
)
values (
)
delete from att_ad_base where GUID = #{id}
delete from att_ad_base
update att_ad_base set flag_valid = 0 where GUID = #{id}
update att_ad_base
AD_CODE = #{adCode},
AD_NAME = #{adName},
AD_TYPE = #{adType},
LOW_LEFT_LONG = #{lowLeftLong},
LOW_LEFT_LAT = #{lowLeftLat},
UP_RIGHT_LONG = #{upRightLong},
UP_RIGHT_LAT = #{upRightLat},
AD_GRAD = #{adGrad},
UP_AD_GUID = #{upAdGuid},
NOTE = #{note},
COLL_TIME = #{collTime},
UPD_TIME = #{updTime},
REC_PERS = #{recPers},
STAT = #{stat},
GUID = #{guid}
update att_ad_base
AD_CODE = #{adCode},
AD_NAME = #{adName},
AD_TYPE = #{adType},
LOW_LEFT_LONG = #{lowLeftLong},
LOW_LEFT_LAT = #{lowLeftLat},
UP_RIGHT_LONG = #{upRightLong},
UP_RIGHT_LAT = #{upRightLat},
AD_GRAD = #{adGrad},
UP_AD_GUID = #{upAdGuid},
NOTE = #{note},
COLL_TIME = #{collTime},
UPD_TIME = #{updTime},
REC_PERS = #{recPers},
STAT = #{stat},
and ORG_ID=#{orgId}
and ORG_ID is null