| | |
| | | <insert id="insertComActDpc"> |
| | | insert into com_act_dpc |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="comActDpc.id != null and comActDpc.id != ''"> |
| | | <if test="comActDpc.id != null"> |
| | | id, |
| | | </if> |
| | | <if test="comActDpc.name != null and comActDpc.name != ''"> |
| | |
| | | <if test="comActDpc.nation != null and comActDpc.nation != ''"> |
| | | nation, |
| | | </if> |
| | | <if test="comActDpc.sex != null and comActDpc.sex != ''"> |
| | | <if test="comActDpc.sex != null"> |
| | | sex, |
| | | </if> |
| | | <if test="comActDpc.area != null and comActDpc.area != ''"> |
| | |
| | | <if test="comActDpc.photo != null and comActDpc.photo != ''"> |
| | | photo, |
| | | </if> |
| | | <if test="comActDpc.communityId != null and comActDpc.communityId != ''"> |
| | | <if test="comActDpc.communityId != null"> |
| | | community_id, |
| | | </if> |
| | | <if test="comActDpc.createdBy != null and comActDpc.createdBy != ''"> |
| | | <if test="comActDpc.createdBy != null "> |
| | | created_by, |
| | | </if> |
| | | <if test="comActDpc.createdAt != null and comActDpc.createdAt != ''"> |
| | | <if test="comActDpc.createdAt != null "> |
| | | created_at, |
| | | </if> |
| | | </trim> |
| | | values |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="comActDpc.id != null and comActDpc.id != ''"> |
| | | <if test="comActDpc.id != null"> |
| | | #{comActDpc.id}, |
| | | </if> |
| | | <if test="comActDpc.name != null and comActDpc.name != ''"> |
| | |
| | | <if test="comActDpc.nation != null and comActDpc.nation != ''"> |
| | | #{comActDpc.nation}, |
| | | </if> |
| | | <if test="comActDpc.sex != null and comActDpc.sex != ''"> |
| | | <if test="comActDpc.sex != null"> |
| | | #{comActDpc.sex}, |
| | | </if> |
| | | <if test="comActDpc.area != null and comActDpc.area != ''"> |
| | |
| | | <if test="comActDpc.photo != null and comActDpc.photo != ''"> |
| | | #{comActDpc.photo}, |
| | | </if> |
| | | <if test="comActDpc.communityId != null and comActDpc.communityId != ''"> |
| | | <if test="comActDpc.communityId != null "> |
| | | #{comActDpc.communityId}, |
| | | </if> |
| | | <if test="comActDpc.createdBy != null and comActDpc.createdBy != ''"> |
| | | <if test="comActDpc.createdBy != null "> |
| | | #{comActDpc.createdBy}, |
| | | </if> |
| | | <if test="comActDpc.createdAt != null and comActDpc.createdAt != ''"> |
| | | <if test="comActDpc.createdAt != null "> |
| | | #{comActDpc.createdAt}, |
| | | </if> |
| | | </trim> |