<insert id="insertPpElectroplantingList" parameterType="com.hwitec.shrcs.bi.domain.PpElectroplantingList" useGeneratedKeys="true" keyProperty="id">
insert into pp_electroplanting_list
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="area != null">`area`,</if>
<if test="orderNo != null">`order_no`,</if>
<if test="finishedProductNo != null">`finished_product_no`,</if>
<if test="materialDesc != null">`material_desc`,</if>
<if test="customer != null">`customer`,</if>
<if test="segment != null">`segment`,</if>
<if test="line != null">`line`,</if>
<if test="status != null">`status`,</if>
<if test="deliveryStatus != null">`delivery_status`,</if>
<if test="pstartTime != null">`pstart_time`,</if>
<if test="pfinishedTime != null">`pfinished_time`,</if>
<if test="demandDate != null">`demand_date`,</if>
<if test="qty != null">`qty`,</if>
<if test="pbatch != null">`pbatch`,</if>
<if test="delay != null">`delay`,</if>
<if test="oee != null">`oee`,</if>
<if test="ct != null">`ct`,</if>
<if test="doh != null">`doh`,</if>
<if test="createBy != null">`create_by`,</if>
<if test="createTime != null">`create_time`,</if>
<if test="totalTime != null">`total_time`,</if>
<if test="teamNo != null">`team_no`,</if>
<if test="assignClassName != null">`assign_class_name`,</if>
<if test="className != null">`class_name`,</if>
<if test="overflow != null">`overflow`,</if>
<if test="safedays != null">`safedays`,</if>
<if test="dohdiff2 != null">`dohdiff2`,</if>
<if test="dohdiff != null">`dohdiff`,</if>
<if test="version != null">`version`,</if>
<if test="customerProductNo != null">`customer_product_no`,</if>
<if test="project != null">`project`,</if>
<if test="maxDays != null">`max_days`,</if>
<if test="minDays != null">`min_days`,</if>
<if test="stock != null">`stock`,</if>
<if test="timeDesc != null">`time_desc`,</if>
<if test="actualClassNumber != null">`actual_class_number`,</if>
<if test="changeTime != null">`change_time`,</if>
<if test="mrpdailyVersion != null">`mrpdaily_version`,</if>
<if test="cjpVersion != null">`cjp_version`,</if>
<if test="paramsClassInfo != null">`params_class_info`,</if>
<if test="lockOrder != null">`lock_order`,</if>
<if test="updateTime != null">`update_time`,</if>
<if test="updateBy != null">`update_by`,</if>
<if test="onlyDaily != null">`only_daily`,</if>
<if test="beginDate != null">`begin_date`,</if>
<if test="endDate != null">`end_date`,</if>
<if test="platingType != null">`plating_type`,</if>
<if test="faPart != null">`fa_part`,</if>
<if test="productNum != null">`product_num`,</if>
<if test="machineDemandDate != null">`machine_demand_date`,</if>
<if test="type != null">`type`,</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="area != null">#{area},</if>
<if test="orderNo != null">#{orderNo},</if>
<if test="finishedProductNo != null">#{finishedProductNo},</if>
<if test="materialDesc != null">#{materialDesc},</if>
<if test="customer != null">#{customer},</if>
<if test="segment != null">#{segment},</if>
<if test="line != null">#{line},</if>
<if test="status != null">#{status},</if>
<if test="deliveryStatus != null">#{deliveryStatus},</if>
<if test="pstartTime != null">#{pstartTime},</if>
<if test="pfinishedTime != null">#{pfinishedTime},</if>
<if test="demandDate != null">#{demandDate},</if>
<if test="qty != null">#{qty},</if>
<if test="pbatch != null">#{pbatch},</if>
<if test="delay != null">#{delay},</if>
<if test="oee != null">#{oee},</if>
<if test="ct != null">#{ct},</if>
<if test="doh != null">#{doh},</if>
<if test="createBy != null">#{createBy},</if>
<if test="createTime != null">#{createTime},</if>
<if test="totalTime != null">#{totalTime},</if>
<if test="teamNo != null">#{teamNo},</if>
<if test="assignClassName != null">#{assignClassName},</if>
<if test="className != null">#{className},</if>
<if test="overflow != null">#{overflow},</if>
<if test="safedays != null">#{safedays},</if>
<if test="dohdiff2 != null">#{dohdiff2},</if>
<if test="dohdiff != null">#{dohdiff},</if>
<if test="version != null">#{version},</if>
<if test="customerProductNo != null">#{customerProductNo},</if>
<if test="project != null">#{project},</if>
<if test="maxDays != null">#{maxDays},</if>
<if test="minDays != null">#{minDays},</if>
<if test="stock != null">#{stock},</if>
<if test="timeDesc != null">#{timeDesc},</if>
<if test="actualClassNumber != null">#{actualClassNumber},</if>
<if test="changeTime != null">#{changeTime},</if>
<if test="mrpdailyVersion != null">#{mrpdailyVersion},</if>
<if test="cjpVersion != null">#{cjpVersion},</if>
<if test="paramsClassInfo != null">#{paramsClassInfo},</if>
<if test="lockOrder != null">#{lockOrder},</if>
<if test="updateTime != null">#{updateTime},</if>
<if test="updateBy != null">#{updateBy},</if>
<if test="onlyDaily != null">#{onlyDaily},</if>
<if test="beginDate != null">#{beginDate},</if>
<if test="endDate != null">#{endDate},</if>
<if test="platingType != null">#{platingType},</if>
<if test="faPart != null">#{faPart},</if>
<if test="productNum != null">#{productNum},</if>
<if test="machineDemandDate != null">#{machineDemandDate},</if>
<if test="type != null">#{type},</if>
</trim>
</insert>
这个mybatis语句格式有什么问题
最新发布