a.id AS "id",
a.org_id AS "orgId",
a.address AS "address",
a.post_date AS "postDate",
a.batch_num AS "batchNum",
a.sampling_code AS "samplingCode",
a.create_by AS "createBy.id",
a.create_date AS "createDate",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag"
INSERT INTO org_sampling(
id,
org_id,
address,
post_date,
batch_num,
sampling_code,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{orgId},
#{address},
#{postDate},
#{batchNum},
#{samplingCode},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
INSERT INTO `org_sampling`(`id`,`batch_num`,`sampling_code`,`org_id`,`address`,`post_date`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`) VALUES
(#{item.id},#{item.batchNum},#{item.samplingCode},#{item.orgId},#{item.address},#{item.postDate},#{item.createBy.id},#{item.createDate},#{item.updateBy.id},#{item.updateDate},#{item.remarks},#{item.delFlag})
UPDATE org_sampling SET
batch_num = #{batchNum},
sampling_code = #{samplingCode},
org_id = #{orgId},
address = #{address},
post_date = #{postDate},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE org_sampling SET
del_flag = '1'
WHERE id = #{id}
UPDATE org_sampling SET
del_flag = '1'
WHERE id IN
#{id}
UPDATE org_sampling SET
del_flag = '1'
WHERE batch_num = #{batchNum}