a.id AS "id", a.sampling_code AS "samplingCode", a.flow_type AS "flowType", a.oper_data AS "operData", a.oper_by AS "operBy", a.oper_time AS "operTime", a.remarks AS "remarks", a.del_flag AS "delFlag" u.name AS "operName" LEFT JOIN jeesite_sys_user u ON u.id = a.oper_by SELECT , FROM sampling_flow_log a WHERE a.id = #{id} SELECT , FROM sampling_flow_log a a.del_flag = #{DEL_FLAG_NORMAL} AND a.sampling_code = #{samplingCode} AND a.flow_type = #{flowType} AND a.oper_data LIKE '%'||#{operData}||'%' '%'+#{operData}+'%' concat('%',#{operData},'%') ORDER BY a.oper_time DESC,a.sampling_code DESC SELECT , FROM sampling_flow_log a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY a.oper_time DESC,a.sampling_code DESC INSERT INTO sampling_flow_log( id, sampling_code, flow_type, oper_data, oper_by, oper_time, remarks, del_flag ) VALUES ( #{id}, #{samplingCode}, #{flowType}, #{operData}, #{operBy}, #{operTime}, #{remarks}, #{delFlag} ) INSERT INTO `sampling_flow_log`(`id`,`sampling_code`,`flow_type`,`oper_data`,`oper_by`,`oper_time`,`remarks`,`del_flag`) VALUES (#{item.id},#{item.samplingCode},#{item.flowType},#{item.operData},#{item.operBy},#{item.operTime},#{item.remarks},#{item.delFlag}) UPDATE sampling_flow_log SET sampling_code = #{samplingCode}, flow_type = #{flowType}, oper_data = #{operData}, oper_by = #{operBy}, oper_time = #{operTime}, remarks = #{remarks} WHERE id = #{id} UPDATE sampling_flow_log SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}