insert
into
chongaibao_new.cab_sys_user_third_ref
(
id,
user_id,
third_id,
third_type,
bind_time,
del_flag,
member_card_type,
member_end_date
)
values
(
#{entity.id},
#{entity.userId},
#{entity.thirdId},
#{entity.thirdType},
#{entity.bindTime},
#{entity.delFlag},
#{entity.memberCardType},
#{entity.memberEndDate}
)
insert
into
chongaibao_new.cab_sys_user
(
id,
mobile,
password,
real_name,
card_no,
authentication,
province_name,
city_name,
area_name,
address,
regist_ip,
create_by,
create_date,
update_by,
update_date,
del_flag
)
values
(
#{entity.id},
#{entity.mobile},
#{entity.password},
#{entity.realName},
#{entity.cardNo},
#{entity.authentication},
#{entity.provinceName},
#{entity.cityName},
#{entity.areaName},
#{entity.address},
#{entity.registIp},
#{entity.createBy.id},
#{entity.createDate},
#{entity.updateBy.id},
#{entity.updateDate},
#{entity.delFlag}
)
update
chongaibao_new.cab_sys_user
set
real_name = #{entity.realName},
card_no = #{entity.cardNo},
province_name = #{entity.provinceName},
city_name = #{entity.cityName},
area_name = #{entity.areaName},
address = #{entity.address},
authentication = #{entity.authentication},
update_by = #{entity.updateBy.id},
update_date = #{entity.updateDate},
del_flag = #{entity.delFlag}
where
id = #{entity.id}
update
chongaibao_new.cab_sys_user
set
real_name = #{entity.realName},
card_no = #{entity.cardNo},
authentication = #{entity.authentication}
where
id = #{entity.id}
update
chongaibao_new.cab_sys_user
set
del_flag = (
case
when (
select
count(1)
from
chongaibao_new.cab_sys_user_third_ref
where
del_flag = '0'
and user_id = #{userId}) = 0
then '1'
else '0'
end )
where
id = #{userId}
delete from chongaibao_new.cab_sys_user_third_ref where third_id = #{thirdId}