ID
,
OBJ_TYPE,
CODE,
NM,
AD_CODE,
AD_NAME,
LOC,
NOTE,
CENTER_X,
CENTER_Y,
GD_X,
GD_Y,
INTM,
UPTM,
DATA_STAT,
SECT_NAME
#{id}
,
#{objType},
#{code},
#{nm},
#{adCode},
#{adName},
#{loc},
#{note},
#{centerX},
#{centerY},
#{gdX},
#{gdY},
#{intm},
#{uptm},
#{dataStat},
#{sectName}
and OBJ_TYPE = #{objType}
and CODE = #{code}
and NM = #{nm}
and AD_CODE = #{adCode}
and AD_NAME = #{adName}
and LOC = #{loc}
and NOTE = #{note}
and CENTER_X = #{centerX}
and CENTER_Y = #{centerY}
and GD_X = #{gdX}
and GD_Y = #{gdY}
and INTM = #{intm}
and UPTM = #{uptm}
and DATA_STAT = #{dataStat}
and SECT_NAME = #{sectName}
and DATA_STAT='0'
insert into BIS_INSP_BASE_NEW(
)
values (
)
update BIS_INSP_BASE_NEW
set DATA_STAT='9'
where ID = #{id}
update BIS_INSP_BASE_NEW set DATA_STAT='9'
update BIS_INSP_BASE_NEW
set DATA_STAT = '9'
where ID = #{id}
update BIS_INSP_BASE_NEW
OBJ_TYPE = #{objType},
CODE = #{code},
NM = #{nm},
AD_CODE = #{adCode},
AD_NAME = #{adName},
LOC = #{loc},
NOTE = #{note},
CENTER_X = #{centerX},
CENTER_Y = #{centerY},
GD_X = #{gdX},
GD_Y = #{gdY},
INTM = #{intm},
UPTM = #{uptm},
DATA_STAT = #{dataStat},
SECT_NAME = #{sectName},
ID = #{id}
update BIS_INSP_BASE_NEW
OBJ_TYPE = #{objType},
CODE = #{code},
NM = #{nm},
AD_CODE = #{adCode},
AD_NAME = #{adName},
LOC = #{loc},
NOTE = #{note},
CENTER_X = #{centerX},
CENTER_Y = #{centerY},
GD_X = #{gdX},
GD_Y = #{gdY},
INTM = #{intm},
UPTM = #{uptm},
DATA_STAT = #{dataStat},
SECT_NAME = #{sectName},