XinYu_LZMES/.svn/pristine/47/47b54dcf6f4a0fe71ab45b74d363c9962b751d3b.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!-- mapper标签要指定namespace属性，不然会报错，可看做包名-->
<mapper namespace="QCM.COMMUNAL.OrderSqMapper">
<insert id = "insertqcmjudgechemcial" parameterType="QCM.COMMUNAL.VO.QcmJudgeChemical">
insert into QCM_JUDGE_CHEMICAL
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " qjc.cic_id!= null  " >cic_id,</if>
  <if test = " qjc.design_key!= null  " >design_key,</if>
  <if test = " qjc.psc!= null  " >psc,</if>
  <if test = " qjc.heat_no!= null  " >heat_no,</if>
  <if test = " qjc.batch_no!= null  " >batch_no,</if>
  <if test = " qjc.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " qjc.smp_no!= null  " >smp_no,</if>
  <if test = " qjc.board_no!= null  " >board_no,</if>
  <if test = " qjc.material_no!= null  " >material_no,</if>
  <if test = " qjc.delivery_state_code!= null  " >delivery_state_code,</if>
  <if test = " qjc.delivery_state_desc!= null  " >delivery_state_desc,</if>
  <if test = " qjc.thick!= null  " >thick,</if>
  <if test = " qjc.width!= null  " >width,</if>
  <if test = " qjc.length!= null  " >length,</if>
  <if test = " qjc.grade_code!= null  " >grade_code,</if>
  <if test = " qjc.grade_name!= null  " >grade_name,</if>
  <if test = " qjc.assay_no_cp!= null  " >assay_no_cp,</if>
  <if test = " qjc.assay_no_rl!= null  " >assay_no_rl,</if>
  <if test = " qjc.pline_code!= null  " >pline_code,</if>
  <if test = " qjc.pline_name!= null  " >pline_name,</if>
  <if test = " qjc.cic_result_code!= null  " >cic_result_code,</if>
  <if test = " qjc.cic_result_desc!= null  " >cic_result_desc,</if>
  <if test = " qjc.cic_memo!= null  " >cic_memo,</if>
  <if test = " qjc.judge_name!= null  " >judge_name,</if>
  <if test = " qjc.judge_name!= null  " >judge_ttime,</if>
  <if test = " qjc.psc_desc!= null  " >psc_desc,</if>
  <if test = " qjc.prod_code!= null  " >prod_code,</if>
  <if test = " qjc.prod_name!= null  " >prod_name,</if>
  <if test = " qjc.steel_code!= null  " >steel_code,</if>
  <if test = " qjc.steel_name!= null  " >steel_name,</if>
  <if test = " qjc.std_code!= null  " >std_code,</if>
  <if test = " qjc.std_name!= null  " >std_name,</if>
  <if test = " qjc.judge_name != null">create_name,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
         <if test = " qjc.cic_id!= null  " >#{qjc.cic_id,jdbcType =VARCHAR},</if>
  <if test = " qjc.design_key!= null  " >#{qjc.design_key,jdbcType =VARCHAR},</if>
  <if test = " qjc.psc!= null  " >#{qjc.psc,jdbcType =VARCHAR},</if>
  <if test = " qjc.heat_no!= null  " >#{qjc.heat_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.batch_no!= null  " >#{qjc.batch_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.inspection_lot!= null  " >#{qjc.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " qjc.smp_no!= null  " >#{qjc.smp_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.board_no!= null  " >#{qjc.board_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.material_no!= null  " >#{qjc.material_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.delivery_state_code!= null  " >#{qjc.delivery_state_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.delivery_state_desc!= null  " >#{qjc.delivery_state_desc,jdbcType =VARCHAR},</if>
  <if test = " qjc.thick!= null  " >#{qjc.thick,jdbcType =NUMERIC},</if>
  <if test = " qjc.width!= null  " >#{qjc.width,jdbcType =NUMERIC},</if>
  <if test = " qjc.length!= null  " >#{qjc.length,jdbcType =NUMERIC},</if>
  <if test = " qjc.grade_code!= null  " >#{qjc.grade_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.grade_name!= null  " >#{qjc.grade_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.assay_no_cp!= null  " >#{qjc.assay_no_cp,jdbcType =VARCHAR},</if>
  <if test = " qjc.assay_no_rl!= null  " >#{qjc.assay_no_rl,jdbcType =VARCHAR},</if>
  <if test = " qjc.pline_code!= null  " >#{qjc.pline_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.pline_name!= null  " >#{qjc.pline_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.cic_result_code!= null  " >#{qjc.cic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.cic_result_desc!= null  " >#{qjc.cic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qjc.cic_memo!= null  " >#{qjc.cic_memo,jdbcType =VARCHAR},</if>
  <if test = " qjc.judge_name!= null  " >#{qjc.judge_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.judge_name!= null  " >sysdate,</if>
  <if test = " qjc.psc_desc!= null  " >#{qjc.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " qjc.prod_code!= null  " >#{qjc.prod_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.prod_name!= null  " >#{qjc.prod_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.steel_code!= null  " >#{qjc.steel_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.steel_name!= null  " >#{qjc.steel_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.std_code!= null  " >#{qjc.std_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.std_name!= null  " >#{qjc.std_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.judge_name != null">#{qjc.judge_name,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<update id= "updateQcmJhySampleROrds" parameterType="QCM.COMMUNAL.VO.QcmJhySampleROrd">
update QCM_JHY_SAMPLE_R_ORD
        <trim prefix="set" suffixOverrides=",">
            <if test="qsrd.judge_status!=null">
                JUDGE_STATUS=#{qsrd.judge_status},
            </if>
            <if test="qsrd.assay_no_cp!=null">
                ASSAY_NO_CP=#{qsrd.assay_no_cp},
            </if>
            <if test="qsrd.assay_no_rl!=null">
                ASSAY_NO_RL=#{qsrd.assay_no_rl},
            </if>
            <if test="qsrd.phy_id!=null">
                PHY_ID=#{qsrd.phy_id},
            </if>
            <if test="qsrd.cic_id!=null">
                CIC_ID=#{qsrd.cic_id},
            </if>
            <if test="qsrd.judge_result_code!=null">
                JUDGE_RESULT_CODE=#{qsrd.judge_result_code},
            </if>
            <if test="qsrd.judge_result_desc!=null">
                JUDGE_RESULT_DESC=#{qsrd.judge_result_desc},
            </if>
            <if test="qsrd.judge_name!=null">
                JUDGE_NAME=#{qsrd.judge_name},
            </if>
            <if test="qsrd.judge_name!=null">
                JUDGE_TIME=sysdate,
            </if>
            <if test="qsrd.judge_memo!=null">
                JUDGE_MEMO=#{qsrd.judge_memo},
            </if>
        </trim>
        <where>
            1=1
               <!-- AND DESIGN_KEY=#{qsrd.design_key} -->
               AND SMP_NO=#{qsrd.smp_no}
               <!-- AND PSC=#{qsrd.psc} -->
            </where>
</update>

<!-- <update id= "updateQcmJudgePhysical" parameterType="QCM.COMMUNAL.VO.QcmJudgePhysical">
update qcm_judge_physical
        <trim prefix="set" suffixOverrides=",">
            <if test="qsrd.phy_result_code!=null">
                phy_result_code=#{qsrd.phy_result_code},
            </if>
            <if test="qsrd.phy_result_desc!=null">
                phy_result_desc=#{qsrd.phy_result_desc},
            </if>
        </trim>
        <where>
            1=1
               AND DESIGN_KEY=#{qsrd.design_key}
               AND phy_id=#{qsrd.phy_id}
               AND PSC=#{qsrd.psc}
            </where>
</update>

<update id= "updateQcmJudgeChemical" parameterType="QCM.COMMUNAL.VO.QcmJudgeChemical">
update qcm_judge_chemical
        <trim prefix="set" suffixOverrides=",">
            <if test="qsrd.cic_result_code!=null">
                cic_result_code=#{qsrd.cic_result_code},
            </if>
            <if test="qsrd.cic_result_desc!=null">
                cic_result_desc=#{qsrd.cic_result_desc},
            </if>
        </trim>
        <where>
            1=1
               AND DESIGN_KEY=#{qsrd.design_key}
               AND cic_id=#{qsrd.cic_id}
               AND PSC=#{qsrd.psc}
            </where>
</update> -->

<update id= "UpdateJugeResultJ" parameterType="QCM.COMMUNAL.VO.QcmJudgeCoilResult">
update qcm_judge_coil_result
        <trim prefix="set" suffixOverrides=",">
            <if test="q.chemresult!=null">
                chemresult=#{q.chemresult},
            </if>
            <if test="q.sizeresult!=null">
                sizeresult=#{q.sizeresult},
            </if>
            <if test="q.judgeresult!=null">
                judgeresult=#{q.judgeresult},
            </if>
            <if test="q.physresult!=null">
                physresult=#{q.physresult},
            </if>
            <if test="q.phyfstsresult!=null">
                phyfstsresult=#{q.phyfstsresult},
            </if>
            <if test="q.spyresult!=null">
                spyresult=#{q.spyresult},
            </if>
            <if test="q.surfaceresult!=null">
                surfaceresult=#{q.surfaceresult},
            </if>
            <if test="q.up_surface_result!=null">
                up_surface_result=#{q.up_surface_result},
            </if>
            <if test="q.ud_surface_result!=null">
                ud_surface_result=#{q.ud_surface_result},
            </if>
            <if test="q.marginal_result!=null">
                marginal_result=#{q.marginal_result},
            </if>
            <if test="q.chemresult_desc!=null">
                chemresult_desc=#{q.chemresult_desc},
            </if>
            <if test="q.sizeresult_desc!=null">
                sizeresult_desc=#{q.sizeresult_desc},
            </if>
            <if test="q.judgeresult_desc!=null">
                judgeresult_desc=#{q.judgeresult_desc},
            </if>
            <if test="q.physresult_desc!=null">
                physresult_desc=#{q.physresult_desc},
            </if>
            <if test="q.phyfstsresult_desc!=null">
                phyfstsresult_desc=#{q.phyfstsresult_desc},
            </if>
            <if test="q.spyresult_desc!=null">
                spyresult_desc=#{q.spyresult_desc},
            </if>
            <if test="q.surfaceresult_desc!=null">
                surfaceresult_desc=#{q.surfaceresult_desc},
            </if>
            <if test="q.up_surface_result_desc!=null">
                up_surface_result_desc=#{q.up_surface_result_desc},
            </if>
            <if test="q.ud_surface_result_desc!=null">
                ud_surface_result_desc=#{q.ud_surface_result_desc},
            </if>
            <if test="q.marginal_result_desc!=null">
                marginal_result_desc=#{q.marginal_result_desc},
            </if>
            <if test="q.up_surface_result_id_desc!=null">
                up_surface_result_id_desc=#{q.up_surface_result_id_desc},
            </if>
            <if test="q.ud_surface_result_id_desc!=null">
                ud_surface_result_id_desc=#{q.ud_surface_result_id_desc},
            </if>
            <if test="q.marginal_result_id_desc!=null">
                marginal_result_id_desc=#{q.marginal_result_id_desc},
            </if>
            <if test="q.chemid!=null">
                chemid=#{q.chemid},
            </if>
            <if test="q.physid!=null">
                physid=#{q.physid},
            </if>
            <if test="q.phyfstsid!=null">
                phyfstsid=#{q.phyfstsid},
            </if>
            <if test="q.surfaceid!=null">
                surfaceid=#{q.surfaceid},
            </if>
            <if test="q.spyid!=null">
                spyid=#{q.spyid},
            </if>
            <if test="q.sizeid!=null">
                sizeid=#{q.sizeid},
            </if>
            <if test="q.judgeid!=null">
                judgeid=#{q.judgeid},
            </if>
            <if test="q.cic_is_lock!=null">
                cic_is_lock=#{q.cic_is_lock},
            </if>
            <if test="q.pic_is_lock!=null">
                pic_is_lock=#{q.pic_is_lock},
            </if>
            <if test="q.sic_is_lock!=null">
                sic_is_lock=#{q.sic_is_lock},
            </if>
            <if test="q.dic_is_lock!=null">
                dic_is_lock=#{q.dic_is_lock},
            </if>
            <if test="q.sfu_is_lock!=null">
                sfu_is_lock=#{q.sfu_is_lock},
            </if>
            <if test="q.sfd_is_lock!=null">
                sfd_is_lock=#{q.sfd_is_lock},
            </if>
            <if test="q.sfe_is_lock!=null">
                sfe_is_lock=#{q.sfe_is_lock},
            </if>
             <if test="q.r_chemid!=null">
                r_chemid=#{q.r_chemid},
            </if>
            <if test="q.r_chemresult!=null">
                r_chemresult=#{q.r_chemresult},
            </if>
            <if test="q.r_chemresult_desc!=null">
                r_chemresult_desc=#{q.r_chemresult_desc},
            </if>
            <if test="q.r_cic_is_lock!=null">
                r_cic_is_lock=#{q.r_cic_is_lock},
            </if>
            <if test="q.new_inspection_lot!=null">
                inspection_lot=#{q.new_inspection_lot},
            </if>
            <if test="q.tic_id!=null">
                tic_id=#{q.tic_id},
            </if>
            <if test="q.tic_result!=null">
                tic_result=#{q.tic_result},
            </if>
            <if test="q.tic_result_desc!=null">
                tic_result_desc=#{q.tic_result_desc},
            </if>
            <if test="q.tic_is_lock!=null">
                tic_is_lock=#{q.tic_is_lock},
            </if>
        </trim>
        <where>
            1=1
            and judgeresult = '0' 
            <if test="q.coil_no!=null">
              AND  coil_no=#{q.coil_no}
            </if>
            <if test="q.inspection_lot!=null">
              AND   inspection_lot=#{q.inspection_lot}
            </if>
            </where>
</update>

<update id= "UpdateJugeResultY" parameterType="QCM.COMMUNAL.VO.QcmJudgeYtCoilResult">
update qcm_judge_yt_coil_result
        <trim prefix="set" suffixOverrides=",">
            <if test="q.chemresult!=null">
                chemresult=#{q.chemresult},
            </if>
            <if test="q.sizeresult!=null">
                sizeresult=#{q.sizeresult},
            </if>
            <if test="q.judgeresult!=null">
                judgeresult=#{q.judgeresult},
            </if>
            <if test="q.physresult!=null">
                physresult=#{q.physresult},
            </if>
            <if test="q.phyfstsresult!=null">
                phyfstsresult=#{q.phyfstsresult},
            </if>
            <if test="q.spyresult!=null">
                spyresult=#{q.spyresult},
            </if>
            <if test="q.surfaceresult!=null">
                surfaceresult=#{q.surfaceresult},
            </if>
            <if test="q.up_surface_result!=null">
                up_surface_result=#{q.up_surface_result},
            </if>
            <if test="q.ud_surface_result!=null">
                ud_surface_result=#{q.ud_surface_result},
            </if>
            <if test="q.marginal_result!=null">
                marginal_result=#{q.marginal_result},
            </if>
            <if test="q.chemresult_desc!=null">
                chemresult_desc=#{q.chemresult_desc},
            </if>
            <if test="q.sizeresult_desc!=null">
                sizeresult_desc=#{q.sizeresult_desc},
            </if>
            <if test="q.judgeresult_desc!=null">
                judgeresult_desc=#{q.judgeresult_desc},
            </if>
            <if test="q.physresult_desc!=null">
                physresult_desc=#{q.physresult_desc},
            </if>
            <if test="q.phyfstsresult_desc!=null">
                phyfstsresult_desc=#{q.phyfstsresult_desc},
            </if>
            <if test="q.spyresult_desc!=null">
                spyresult_desc=#{q.spyresult_desc},
            </if>
            <if test="q.surfaceresult_desc!=null">
                surfaceresult_desc=#{q.surfaceresult_desc},
            </if>
            <if test="q.up_surface_result_desc!=null">
                up_surface_result_desc=#{q.up_surface_result_desc},
            </if>
            <if test="q.ud_surface_result_desc!=null">
                ud_surface_result_desc=#{q.ud_surface_result_desc},
            </if>
            <if test="q.marginal_result_desc!=null">
                marginal_result_desc=#{q.marginal_result_desc},
            </if>
            <if test="q.up_surface_result_id_desc!=null">
                up_surface_result_id_desc=#{q.up_surface_result_id_desc},
            </if>
            <if test="q.ud_surface_result_id_desc!=null">
                ud_surface_result_id_desc=#{q.ud_surface_result_id_desc},
            </if>
            <if test="q.marginal_result_id_desc!=null">
                marginal_result_id_desc=#{q.marginal_result_id_desc},
            </if>
            <if test="q.chemid!=null">
                chemid=#{q.chemid},
            </if>
            <if test="q.physid!=null">
                physid=#{q.physid},
            </if>
            <if test="q.phyfstsid!=null">
                phyfstsid=#{q.phyfstsid},
            </if>
            <if test="q.surfaceid!=null">
                surfaceid=#{q.surfaceid},
            </if>
            <if test="q.spyid!=null">
                spyid=#{q.spyid},
            </if>
            <if test="q.sizeid!=null">
                sizeid=#{q.sizeid},
            </if>
            <if test="q.judgeid!=null">
                judgeid=#{q.judgeid},
            </if>
            <if test="q.cic_is_lock!=null">
                cic_is_lock=#{q.cic_is_lock},
            </if>
            <if test="q.pic_is_lock!=null">
                pic_is_lock=#{q.pic_is_lock},
            </if>
            <if test="q.sic_is_lock!=null">
                sic_is_lock=#{q.sic_is_lock},
            </if>
            <if test="q.dic_is_lock!=null">
                dic_is_lock=#{q.dic_is_lock},
            </if>
            <if test="q.sfu_is_lock!=null">
                sfu_is_lock=#{q.sfu_is_lock},
            </if>
            <if test="q.sfd_is_lock!=null">
                sfd_is_lock=#{q.sfd_is_lock},
            </if>
            <if test="q.sfe_is_lock!=null">
                sfe_is_lock=#{q.sfe_is_lock},
            </if>
             <if test="q.r_chemid!=null">
                r_chemid=#{q.r_chemid},
            </if>
            <if test="q.r_chemresult!=null">
                r_chemresult=#{q.r_chemresult},
            </if>
            <if test="q.r_chemresult_desc!=null">
                r_chemresult_desc=#{q.r_chemresult_desc},
            </if>
            <if test="q.r_cic_is_lock!=null">
                r_cic_is_lock=#{q.r_cic_is_lock},
            </if>
            <if test="q.new_inspection_lot!=null">
                inspection_lot=#{q.new_inspection_lot},
            </if>
            <if test="q.tic_id!=null">
                tic_id=#{q.tic_id},
            </if>
            <if test="q.tic_result!=null">
                tic_result=#{q.tic_result},
            </if>
            <if test="q.tic_result_desc!=null">
                tic_result_desc=#{q.tic_result_desc},
            </if>
            <if test="q.tic_is_lock!=null">
                tic_is_lock=#{q.tic_is_lock},
            </if>
        </trim>
        <where>
            1=1
            and judgeresult = '0' 
            <if test="q.coil_no!=null">
              AND  coil_no=#{q.coil_no}
            </if>
            <if test="q.inspection_lot!=null">
              AND   inspection_lot=#{q.inspection_lot}
            </if>
            </where>
</update>

<update id= "UpdateJugeResultB" parameterType="QCM.COMMUNAL.VO.ZjResultAll">
update zj_result_all@xgcx
        <trim prefix="set" suffixOverrides=",">
            <if test="q.chemresult!=null">
                chemresult=#{q.chemresult},
            </if>
            <if test="q.sizeresult!=null">
                sizeresult=#{q.sizeresult},
            </if>
            <if test="q.judgeresult!=null">
                judgeresult=#{q.judgeresult},
            </if>
            <if test="q.physresult!=null">
                physresult=#{q.physresult},
            </if>
            <if test="q.phyfstsresult!=null">
                phyfstsresult=#{q.phyfstsresult},
            </if>
            <if test="q.spyresult!=null">
                spyresult=#{q.spyresult},
            </if>
            <if test="q.surfaceresult!=null">
                surfaceresult=#{q.surfaceresult},
            </if>
            <if test="q.surfaceresult_desc!=null">
                surfaceresult_desc=#{q.surfaceresult_desc},
            </if>
            <if test="q.up_surface_result!=null">
                up_surface_result=#{q.up_surface_result},
            </if>
            <if test="q.ud_surface_result!=null">
                ud_surface_result=#{q.ud_surface_result},
            </if>
            <if test="q.marginal_result!=null">
                marginal_result=#{q.marginal_result},
            </if>
            <if test="q.chemresult_desc!=null">
                chemresult_desc=#{q.chemresult_desc},
            </if>
            <if test="q.sizeresult_desc!=null">
                sizeresult_desc=#{q.sizeresult_desc},
            </if>
            <if test="q.judgeresult_desc!=null">
                judgeresult_desc=#{q.judgeresult_desc},
            </if>
            <if test="q.physresult_desc!=null">
                physresult_desc=#{q.physresult_desc},
            </if>
            <if test="q.phyfstsresult_desc!=null">
                phyfstsresult_desc=#{q.phyfstsresult_desc},
            </if>
            <if test="q.spyresult_desc!=null">
                spyresult_desc=#{q.spyresult_desc},
            </if>
            <!-- <if test="q.surfaceresult_desc!=null">
                surfaceresult_desc=#{q.surfaceresult_desc},
            </if> -->
            <if test="q.up_surface_result_desc!=null">
                up_surface_result_desc=#{q.up_surface_result_desc},
            </if>
            <if test="q.ud_surface_result_desc!=null">
                ud_surface_result_desc=#{q.ud_surface_result_desc},
            </if>
            <if test="q.marginal_result_desc!=null">
                marginal_result_desc=#{q.marginal_result_desc},
            </if>
            <if test="q.up_surface_result_id_desc!=null">
                up_surface_result_id_desc=#{q.up_surface_result_id_desc},
            </if>
            <if test="q.ud_surface_result_id_desc!=null">
                ud_surface_result_id_desc=#{q.ud_surface_result_id_desc},
            </if>
            <if test="q.marginal_result_id_desc!=null">
                marginal_result_id_desc=#{q.marginal_result_id_desc},
            </if>
            <if test="q.chemid!=null">
                chemid=#{q.chemid},
            </if>
            <if test="q.physid!=null">
                physid=#{q.physid},
            </if>
            <if test="q.phyfstsid!=null">
                phyfstsid=#{q.phyfstsid},
            </if>
            <if test="q.surfaceid!=null">
                surfaceid=#{q.surfaceid},
            </if>
            <if test="q.spyid!=null">
                spyid=#{q.spyid},
            </if>
            <if test="q.sizeid!=null">
                sizeid=#{q.sizeid},
            </if>
            <if test="q.judgeid!=null">
                judgeid=#{q.judgeid},
            </if>
            <if test="q.cic_is_lock!=null">
                cic_is_lock=#{q.cic_is_lock},
            </if>
            <if test="q.pic_is_lock!=null">
                pic_is_lock=#{q.pic_is_lock},
            </if>
            <if test="q.sic_is_lock!=null">
                sic_is_lock=#{q.sic_is_lock},
            </if>
            <if test="q.dic_is_lock!=null">
                dic_is_lock=#{q.dic_is_lock},
            </if>
            <if test="q.sfu_is_lock!=null">
                sfu_is_lock=#{q.sfu_is_lock},
            </if>
            <if test="q.sfd_is_lock!=null">
                sfd_is_lock=#{q.sfd_is_lock},
            </if>
            <if test="q.sfe_is_lock!=null">
                sfe_is_lock=#{q.sfe_is_lock},
            </if>
             <if test="q.r_chemid!=null">
                r_chemid=#{q.r_chemid},
            </if>
            <if test="q.r_chemresult!=null">
                r_chemresult=#{q.r_chemresult},
            </if>
            <if test="q.r_chemresult_desc!=null">
                r_chemresult_desc=#{q.r_chemresult_desc},
            </if>
            <if test="q.r_cic_is_lock!=null">
                r_cic_is_lock=#{q.r_cic_is_lock},
            </if>
            <if test="q.new_inspection_lot!=null">
                billetid_jy=#{q.new_inspection_lot},
            </if>
            <if test="q.fst_judgeresult!=null">
                fst_judgeresult=#{q.fst_judgeresult},
            </if>
            <if test="q.fst_judgeresult_desc!=null">
                fst_judgeresult_desc=#{q.fst_judgeresult_desc},
            </if>
        </trim>
        <where>
             1=1
             and judgeresult = '0' 
            <if test="q.billetid!=null">
               AND billetid=#{q.billetid}
            </if>
            <if test="q.billetid_jy!=null">
               AND billetid_jy=#{q.billetid_jy}
            </if>
            </where>
</update>

<update id= "UpdateJugeResultB1" parameterType="QCM.COMMUNAL.VO.ZjResultAll">
update zj_result_all@xgcx
        <trim prefix="set" suffixOverrides=",">
            <if test="q.chemresult!=null">
                chemresult=#{q.chemresult},
            </if>
            <if test="q.sizeresult!=null">
                sizeresult=#{q.sizeresult},
            </if>
            <if test="q.judgeresult!=null">
                judgeresult=#{q.judgeresult},
            </if>
            <if test="q.physresult!=null">
                physresult=#{q.physresult},
            </if>
            <if test="q.phyfstsresult!=null">
                phyfstsresult=#{q.phyfstsresult},
            </if>
            <if test="q.spyresult!=null">
                spyresult=#{q.spyresult},
            </if>
            <if test="q.surfaceresult!=null">
                surfaceresult=#{q.surfaceresult},
            </if>
            <if test="q.surfaceresult_desc!=null">
                surfaceresult_desc=#{q.surfaceresult_desc},
            </if>
            <if test="q.up_surface_result!=null">
                up_surface_result=#{q.up_surface_result},
            </if>
            <if test="q.ud_surface_result!=null">
                ud_surface_result=#{q.ud_surface_result},
            </if>
            <if test="q.marginal_result!=null">
                marginal_result=#{q.marginal_result},
            </if>
            <if test="q.chemresult_desc!=null">
                chemresult_desc=#{q.chemresult_desc},
            </if>
            <if test="q.sizeresult_desc!=null">
                sizeresult_desc=#{q.sizeresult_desc},
            </if>
            <if test="q.judgeresult_desc!=null">
                judgeresult_desc=#{q.judgeresult_desc},
            </if>
            <if test="q.physresult_desc!=null">
                physresult_desc=#{q.physresult_desc},
            </if>
            <if test="q.phyfstsresult_desc!=null">
                phyfstsresult_desc=#{q.phyfstsresult_desc},
            </if>
            <if test="q.spyresult_desc!=null">
                spyresult_desc=#{q.spyresult_desc},
            </if>
            <!-- <if test="q.surfaceresult_desc!=null">
                surfaceresult_desc=#{q.surfaceresult_desc},
            </if> -->
            <if test="q.up_surface_result_desc!=null">
                up_surface_result_desc=#{q.up_surface_result_desc},
            </if>
            <if test="q.ud_surface_result_desc!=null">
                ud_surface_result_desc=#{q.ud_surface_result_desc},
            </if>
            <if test="q.marginal_result_desc!=null">
                marginal_result_desc=#{q.marginal_result_desc},
            </if>
            <if test="q.up_surface_result_id_desc!=null">
                up_surface_result_id_desc=#{q.up_surface_result_id_desc},
            </if>
            <if test="q.ud_surface_result_id_desc!=null">
                ud_surface_result_id_desc=#{q.ud_surface_result_id_desc},
            </if>
            <if test="q.marginal_result_id_desc!=null">
                marginal_result_id_desc=#{q.marginal_result_id_desc},
            </if>
            <if test="q.chemid!=null">
                chemid=#{q.chemid},
            </if>
            <if test="q.physid!=null">
                physid=#{q.physid},
            </if>
            <if test="q.phyfstsid!=null">
                phyfstsid=#{q.phyfstsid},
            </if>
            <if test="q.surfaceid!=null">
                surfaceid=#{q.surfaceid},
            </if>
            <if test="q.spyid!=null">
                spyid=#{q.spyid},
            </if>
            <if test="q.sizeid!=null">
                sizeid=#{q.sizeid},
            </if>
            <if test="q.judgeid!=null">
                judgeid=#{q.judgeid},
            </if>
            <if test="q.cic_is_lock!=null">
                cic_is_lock=#{q.cic_is_lock},
            </if>
            <if test="q.pic_is_lock!=null">
                pic_is_lock=#{q.pic_is_lock},
            </if>
            <if test="q.sic_is_lock!=null">
                sic_is_lock=#{q.sic_is_lock},
            </if>
            <if test="q.dic_is_lock!=null">
                dic_is_lock=#{q.dic_is_lock},
            </if>
            <if test="q.sfu_is_lock!=null">
                sfu_is_lock=#{q.sfu_is_lock},
            </if>
            <if test="q.sfd_is_lock!=null">
                sfd_is_lock=#{q.sfd_is_lock},
            </if>
            <if test="q.sfe_is_lock!=null">
                sfe_is_lock=#{q.sfe_is_lock},
            </if>
             <if test="q.r_chemid!=null">
                r_chemid=#{q.r_chemid},
            </if>
            <if test="q.r_chemresult!=null">
                r_chemresult=#{q.r_chemresult},
            </if>
            <if test="q.r_chemresult_desc!=null">
                r_chemresult_desc=#{q.r_chemresult_desc},
            </if>
            <if test="q.r_cic_is_lock!=null">
                r_cic_is_lock=#{q.r_cic_is_lock},
            </if>
            <if test="q.new_inspection_lot!=null">
                billetid_jy=#{q.new_inspection_lot},
            </if>
            <if test="q.fst_judgeresult!=null">
                fst_judgeresult=#{q.fst_judgeresult},
            </if>
            <if test="q.fst_judgeresult_desc!=null">
                fst_judgeresult_desc=#{q.fst_judgeresult_desc},
            </if>
        </trim>
        <where>
             1=1
            <if test="q.billetid!=null">
               AND billetid like #{q.billetid} ||'%'
            </if>
            <if test="q.billetid_jy!=null">
               AND billetid_jy=#{q.billetid_jy}
            </if>
            </where>
</update>

<insert id="insertQcmPhyJudgeResult" parameterType = "QCM.COMMUNAL.VO.QcmPhyJudgeResult">
insert into QCM_JUDGE_PHYSICAL_RESULT
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.phy_id!= null  " >phy_id,</if>
  <if test = " q.guid!= null  " >guid,</if>
  <if test = " q.smp_no!= null  " >smp_no,</if>
  <if test = " q.heat_no!= null  " >heat_no,</if>
  <if test = " q.batch_no!= null  " >batch_no,</if>
  <if test = " q.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " q.specimen_no!= null  " >specimen_no,</if>
  <if test = " q.material_no!= null  " >material_no,</if>
  <if test = " q.phy_code_l!= null  " >phy_code_l,</if>
  <if test = " q.phy_name_l!= null  " >phy_name_l,</if>
  <if test = " q.phy_code_m!= null  " >phy_code_m,</if>
  <if test = " q.phy_name_m!= null  " >phy_name_m,</if>
  <if test = " q.phy_code_s!= null  " >phy_code_s,</if>
  <if test = " q.phy_name_s!= null  " >phy_name_s,</if>
  <if test = " q.item_code_d!= null  " >item_code_d,</if>
  <if test = " q.item_name_d!= null  " >item_name_d,</if>
  <if test = " q.item_code_t!= null  " >item_code_t,</if>
  <if test = " q.item_name_t!= null  " >item_name_t,</if>
  <if test = " q.item_code_s!= null  " >item_code_s,</if>
  <if test = " q.item_name_s!= null  " >item_name_s,</if>
  <if test = " q.val1!= null  " >val1,</if>
  <if test = " q.val2!= null  " >val2,</if>
  <if test = " q.val3!= null  " >val3,</if>
  <if test = " q.val4!= null  " >val4,</if>
  <if test = " q.val5!= null  " >val5,</if>
  <if test = " q.val6!= null  " >val6,</if>
  <if test = " q.val7!= null  " >val7,</if>
  <if test = " q.val8!= null  " >val8,</if>
  <if test = " q.val9!= null  " >val9,</if>
  <if test = " q.val10!= null  " >val10,</if>
  <if test = " q.val11!= null  " >val11,</if>
  <if test = " q.val12!= null  " >val12,</if>
  <if test = " q.val13!= null  " >val13,</if>
  <if test = " q.val14!= null  " >val14,</if>
  <if test = " q.val15!= null  " >val15,</if>
  <if test = " q.avg_val!= null  " >avg_val,</if>
  <if test = " q.pri!= null  " >pri,</if>
  <if test = " q.is_pass!= null  " >is_pass,</if>
  <if test = " q.create_name!= null  " >create_name,</if>
  <if test = " q.create_name!= null  " >create_time,</if>
  <if test = " q.item_code_l!= null  " >item_code_l,</if>
  <if test = " q.item_desc_l!= null  " >item_desc_l,</if>
  <if test = " q.defect_flag!= null">defect_flag,</if>
  <if test=" q.phy_unit= null">phy_unit,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " q.phy_id!= null  " >#{q.phy_id,jdbcType =VARCHAR},</if>
  <if test = " q.guid!= null  " >#{q.guid,jdbcType =VARCHAR},</if>
  <if test = " q.smp_no!= null  " >#{q.smp_no,jdbcType =VARCHAR},</if>
  <if test = " q.heat_no!= null  " >#{q.heat_no,jdbcType =VARCHAR},</if>
  <if test = " q.batch_no!= null  " >#{q.batch_no,jdbcType =VARCHAR},</if>
  <if test = " q.inspection_lot!= null  " >#{q.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " q.specimen_no!= null  " >#{q.specimen_no,jdbcType =VARCHAR},</if>
  <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
  <if test = " q.phy_code_l!= null  " >#{q.phy_code_l,jdbcType =VARCHAR},</if>
  <if test = " q.phy_name_l!= null  " >#{q.phy_name_l,jdbcType =VARCHAR},</if>
  <if test = " q.phy_code_m!= null  " >#{q.phy_code_m,jdbcType =VARCHAR},</if>
  <if test = " q.phy_name_m!= null  " >#{q.phy_name_m,jdbcType =VARCHAR},</if>
  <if test = " q.phy_code_s!= null  " >#{q.phy_code_s,jdbcType =VARCHAR},</if>
  <if test = " q.phy_name_s!= null  " >#{q.phy_name_s,jdbcType =VARCHAR},</if>
  <if test = " q.item_code_d!= null  " >#{q.item_code_d,jdbcType =VARCHAR},</if>
  <if test = " q.item_name_d!= null  " >#{q.item_name_d,jdbcType =VARCHAR},</if>
  <if test = " q.item_code_t!= null  " >#{q.item_code_t,jdbcType =VARCHAR},</if>
  <if test = " q.item_name_t!= null  " >#{q.item_name_t,jdbcType =VARCHAR},</if>
  <if test = " q.item_code_s!= null  " >#{q.item_code_s,jdbcType =VARCHAR},</if>
  <if test = " q.item_name_s!= null  " >#{q.item_name_s,jdbcType =VARCHAR},</if>
  <if test = " q.val1!= null  " >#{q.val1,jdbcType =VARCHAR},</if>
  <if test = " q.val2!= null  " >#{q.val2,jdbcType =VARCHAR},</if>
  <if test = " q.val3!= null  " >#{q.val3,jdbcType =VARCHAR},</if>
  <if test = " q.val4!= null  " >#{q.val4,jdbcType =VARCHAR},</if>
  <if test = " q.val5!= null  " >#{q.val5,jdbcType =VARCHAR},</if>
  <if test = " q.val6!= null  " >#{q.val6,jdbcType =VARCHAR},</if>
  <if test = " q.val7!= null  " >#{q.val7,jdbcType =VARCHAR},</if>
  <if test = " q.val8!= null  " >#{q.val8,jdbcType =VARCHAR},</if>
  <if test = " q.val9!= null  " >#{q.val9,jdbcType =VARCHAR},</if>
  <if test = " q.val10!= null  " >#{q.val10,jdbcType =VARCHAR},</if>
  <if test = " q.val11!= null  " >#{q.val11,jdbcType =VARCHAR},</if>
  <if test = " q.val12!= null  " >#{q.val12,jdbcType =VARCHAR},</if>
  <if test = " q.val13!= null  " >#{q.val13,jdbcType =VARCHAR},</if>
  <if test = " q.val14!= null  " >#{q.val14,jdbcType =VARCHAR},</if>
  <if test = " q.val15!= null  " >#{q.val15,jdbcType =VARCHAR},</if>
  <if test = " q.avg_val!= null  " >#{q.avg_val,jdbcType =VARCHAR},</if>
  <if test = " q.pri!= null  " >#{q.pri,jdbcType =VARCHAR},</if>
  <if test = " q.is_pass!= null  " >#{q.is_pass,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >sysdate,</if>
  <if test = " q.item_code_l!= null  " >#{q.item_code_l,jdbcType =VARCHAR},</if>
  <if test = " q.item_desc_l!= null  " >#{q.item_desc_l,jdbcType =VARCHAR},</if>
  <if test = " q.defect_flag!= null">#{q.defect_flag,jdbcType=VARCHAR},</if>
  <if test = " q.phy_unit!= null">#{q.phy_unit,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id="insertQcmJudgeMeasureD" parameterType = "QCM.COMMUNAL.VO.QcmJudgeMeasureD">
insert into QCM_JUDGE_MEASURE_D
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.sic_id!= null  " >sic_id,</if>
  <if test = " q.sic_item_code!= null  " >sic_item_code,</if>
  <if test = " q.sic_item_desc!= null  " >sic_item_desc,</if>
  <if test = " q.plan_val!= null  " >plan_val,</if>
  <if test = " q.judge_val!= null  " >judge_val,</if>
  <if test = " q.memo!= null  " >memo,</if>
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " q.sic_id!= null  " >#{q.sic_id,jdbcType =VARCHAR},</if>
  <if test = " q.sic_item_code!= null  " >#{q.sic_item_code,jdbcType =VARCHAR},</if>
  <if test = " q.sic_item_desc!= null  " >#{q.sic_item_desc,jdbcType =VARCHAR},</if>
  <if test = " q.plan_val!= null  " >#{q.plan_val,jdbcType =VARCHAR},</if>
  <if test = " q.judge_val!= null  " >#{q.judge_val,jdbcType =VARCHAR},</if>
  <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id= "insertQcmJudgePhysical" parameterType = "QCM.COMMUNAL.VO.QcmJudgePhysical">
insert into QCM_JUDGE_PHYSICAL
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " qjc.phy_id!= null  " >phy_id,</if>
  <if test = " qjc.smp_no!= null  " >smp_no,</if>
  <if test = " qjc.heat_no!= null  " >heat_no,</if>
  <if test = " qjc.batch_no!= null  " >batch_no,</if>
  <if test = " qjc.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " qjc.board_no!= null  " >board_no,</if>
  <if test = " qjc.design_key!= null  " >design_key,</if>
  <if test = " qjc.psc!= null  " >psc,</if>
  <if test = " qjc.delivery_state_code!= null  " >delivery_state_code,</if>
  <if test = " qjc.delivery_state_desc!= null  " >delivery_state_desc,</if>
  <if test = " qjc.thick!= null  " >thick,</if>
  <if test = " qjc.width!= null  " >width,</if>
  <if test = " qjc.length!= null  " >length,</if>
  <if test = " qjc.cert_inst_code!= null  " >cert_inst_code,</if>
  <if test = " qjc.cert_inst_name!= null  " >cert_inst_name,</if>
  <if test = " qjc.smp_type_code!= null  " >smp_type_code,</if>
  <if test = " qjc.smp_type_name!= null  " >smp_type_name,</if>
  <if test = " qjc.pline_code!= null  " >pline_code,</if>
  <if test = " qjc.pline_name!= null  " >pline_name,</if>
  <if test = " qjc.phy_result_code!= null  " >phy_result_code,</if>
  <if test = " qjc.phy_result_desc!= null  " >phy_result_desc,</if>
  <if test = " qjc.phy_memo!= null  " >phy_memo,</if>
  <if test = " qjc.judge_name!= null  " >judge_name,</if>
  <if test = " qjc.judge_name!= null  " >judge_ttime,</if>
  <if test = " qjc.psc_desc!= null  " >psc_desc,</if>
  <if test = " qjc.prod_code!= null  " >prod_code,</if>
  <if test = " qjc.prod_name!= null  " >prod_name,</if>
  <if test = " qjc.steel_code!= null  " >steel_code,</if>
  <if test = " qjc.steel_name!= null  " >steel_name,</if>
  <if test = " qjc.std_code!= null  " >std_code,</if>
  <if test = " qjc.std_name!= null  " >std_name,</if>
  <if test = " qjc.cancel_memo!= null">cancel_memo,</if> 
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
         <if test = " qjc.phy_id!= null  " >#{qjc.phy_id,jdbcType =VARCHAR},</if>
  <if test = " qjc.smp_no!= null  " >#{qjc.smp_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.heat_no!= null  " >#{qjc.heat_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.batch_no!= null  " >#{qjc.batch_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.inspection_lot!= null  " >#{qjc.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " qjc.board_no!= null  " >#{qjc.board_no,jdbcType =VARCHAR},</if>
  <if test = " qjc.design_key!= null  " >#{qjc.design_key,jdbcType =VARCHAR},</if>
  <if test = " qjc.psc!= null  " >#{qjc.psc,jdbcType =VARCHAR},</if>
  <if test = " qjc.delivery_state_code!= null  " >#{qjc.delivery_state_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.delivery_state_desc!= null  " >#{qjc.delivery_state_desc,jdbcType =VARCHAR},</if>
  <if test = " qjc.thick!= null  " >#{qjc.thick,jdbcType =NUMERIC},</if>
  <if test = " qjc.width!= null  " >#{qjc.width,jdbcType =NUMERIC},</if>
  <if test = " qjc.length!= null  " >#{qjc.length,jdbcType =NUMERIC},</if>
  <if test = " qjc.cert_inst_code!= null  " >#{qjc.cert_inst_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.cert_inst_name!= null  " >#{qjc.cert_inst_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.smp_type_code!= null  " >#{qjc.smp_type_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.smp_type_name!= null  " >#{qjc.smp_type_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.pline_code!= null  " >#{qjc.pline_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.pline_name!= null  " >#{qjc.pline_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.phy_result_code!= null  " >#{qjc.phy_result_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.phy_result_desc!= null  " >#{qjc.phy_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qjc.phy_memo!= null  " >#{qjc.phy_memo,jdbcType =VARCHAR},</if>
  <if test = " qjc.judge_name!= null  " >#{qjc.judge_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.judge_name!= null  " >sysdate,</if>
  <if test = " qjc.psc_desc!= null  " >#{qjc.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " qjc.prod_code!= null  " >#{qjc.prod_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.prod_name!= null  " >#{qjc.prod_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.steel_code!= null  " >#{qjc.steel_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.steel_name!= null  " >#{qjc.steel_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.std_code!= null  " >#{qjc.std_code,jdbcType =VARCHAR},</if>
  <if test = " qjc.std_name!= null  " >#{qjc.std_name,jdbcType =VARCHAR},</if>
  <if test = " qjc.cancel_memo != null">#{qjc.cancel_memo,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id="insertQcmJhySampleConsignDItem" parameterType = "QCM.COMMUNAL.VO.QcmJhySampleConsignDItem">
</insert>

<insert id ="insertQcmJhySampleConsignD" parameterType = "QCM.COMMUNAL.VO.QcmJhySampleConsignD">
</insert>
	
<insert id="insertQcmJudgePhysicalUtmM" parameterType = "QCM.COMMUNAL.VO.QcmJudgePhysicalUtmM">
insert into QCM_JUDGE_PHYSICAL_UTM_M
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " qpu.pic_id!= null  " >pic_id,</if>
  <if test = " qpu.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " qpu.design_key!= null  " >design_key,</if>
  <if test = " qpu.pic_result_code!= null  " >pic_result_code,</if>
  <if test = " qpu.pic_result_desc!= null  " >pic_result_desc,</if>
  <if test = " qpu.pic_id!= null  " >CREATE_TIME,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " qpu.pic_id!= null  " >#{qpu.pic_id,jdbcType =VARCHAR},</if>
        <if test = " qpu.inspection_lot!= null  " >#{qpu.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " qpu.design_key!= null  " >#{qpu.design_key,jdbcType =VARCHAR},</if>
  <if test = " qpu.pic_result_code!= null  " >#{qpu.pic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qpu.pic_result_desc!= null  " >#{qpu.pic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qpu.pic_id!= null  " >sysdate,</if>
       </trim>
</insert>

<insert id ="insertQcmJudgePhysicalUtmD" parameterType = "QCM.COMMUNAL.VO.QcmJudgePhysicalUtmD">
insert into QCM_JUDGE_PHYSICAL_UTM_D
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " qpd.pic_id!= null  " >pic_id,</if>
  <if test = " qpd.smp_no!= null  " >smp_no,</if>
  <if test = " qpd.heat_no!= null  " >heat_no,</if>
  <if test = " qpd.batch_no!= null  " >batch_no,</if>
  <if test = " qpd.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " qpd.design_key!= null  " >design_key,</if>
  <if test = " qpd.psc!= null  " >psc,</if>
  <if test = " qpd.cert_inst_code!= null  " >cert_inst_code,</if>
  <if test = " qpd.cert_inst_name!= null  " >cert_inst_name,</if>
  <if test = " qpd.smp_type_code!= null  " >smp_type_code,</if>
  <if test = " qpd.smp_type_name!= null  " >smp_type_name,</if>
  <if test = " qpd.judge_result_code!= null  " >judge_result_code,</if>
  <if test = " qpd.judge_result_desc!= null  " >judge_result_desc,</if>
  <if test = " qpd.phy_id!= null  " >phy_id,</if>
  <if test = " qpd.memo!= null  " >memo,</if>
  <if test = " qpd.judge_name!= null  " >judge_name,</if>
  <if test = " qpd.judge_name!= null  " >judge_ttime,</if>
   <if test = " qpd.psc_desc!= null  " >psc_desc,</if>
  <if test = " qpd.prod_code!= null  " >prod_code,</if>
  <if test = " qpd.prod_name!= null  " >prod_name,</if>
  <if test = " qpd.steel_code!= null  " >steel_code,</if>
  <if test = " qpd.steel_name!= null  " >steel_name,</if>
  <if test = " qpd.std_code!= null  " >std_code,</if>
  <if test = " qpd.std_name!= null  " >std_name,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " qpd.pic_id!= null  " >#{qpd.pic_id,jdbcType =VARCHAR},</if>
  <if test = " qpd.smp_no!= null  " >#{qpd.smp_no,jdbcType =VARCHAR},</if>
  <if test = " qpd.heat_no!= null  " >#{qpd.heat_no,jdbcType =VARCHAR},</if>
  <if test = " qpd.batch_no!= null  " >#{qpd.batch_no,jdbcType =VARCHAR},</if>
  <if test = " qpd.inspection_lot!= null  " >#{qpd.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " qpd.design_key!= null  " >#{qpd.design_key,jdbcType =VARCHAR},</if>
  <if test = " qpd.psc!= null  " >#{qpd.psc,jdbcType =VARCHAR},</if>
  <if test = " qpd.cert_inst_code!= null  " >#{qpd.cert_inst_code,jdbcType =VARCHAR},</if>
  <if test = " qpd.cert_inst_name!= null  " >#{qpd.cert_inst_name,jdbcType =VARCHAR},</if>
  <if test = " qpd.smp_type_code!= null  " >#{qpd.smp_type_code,jdbcType =VARCHAR},</if>
  <if test = " qpd.smp_type_name!= null  " >#{qpd.smp_type_name,jdbcType =VARCHAR},</if>
  <if test = " qpd.judge_result_code!= null  " >#{qpd.judge_result_code,jdbcType =VARCHAR},</if>
  <if test = " qpd.judge_result_desc!= null  " >#{qpd.judge_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qpd.phy_id!= null  " >#{qpd.phy_id,jdbcType =VARCHAR},</if>
  <if test = " qpd.memo!= null  " >#{qpd.memo,jdbcType =VARCHAR},</if>
  <if test = " qpd.judge_name!= null  " >#{qpd.judge_name,jdbcType =VARCHAR},</if>
  <if test = " qpd.judge_name!= null  " >SYSDATE,</if>
  <if test = " qpd.psc_desc!= null  " >#{qpd.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " qpd.prod_code!= null  " >#{qpd.prod_code,jdbcType =VARCHAR},</if>
  <if test = " qpd.prod_name!= null  " >#{qpd.prod_name,jdbcType =VARCHAR},</if>
  <if test = " qpd.steel_code!= null  " >#{qpd.steel_code,jdbcType =VARCHAR},</if>
  <if test = " qpd.steel_name!= null  " >#{qpd.steel_name,jdbcType =VARCHAR},</if>
  <if test = " qpd.std_code!= null  " >#{qpd.std_code,jdbcType =VARCHAR},</if>
  <if test = " qpd.std_name!= null  " >#{qpd.std_name,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id = "insertQcmJudgeSurface" parameterType = "QCM.COMMUNAL.VO.QcmJudgeSurface">
insert into QCM_JUDGE_SURFACE
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.surface_id!= null  " >surface_id,</if>
  <if test = " q.heat_no!= null  " >heat_no,</if>
  <if test = " q.batch_no!= null  " >batch_no,</if>
  <if test = " q.board_no!= null  " >board_no,</if>
  <if test = " q.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " q.material_no!= null  " >material_no,</if>
  <if test = " q.sf_result_code!= null  " >sf_result_code,</if>
  <if test = " q.sf_result_desc!= null  " >sf_result_desc,</if>
  <if test = " q.level_code!= null  " >level_code,</if>
  <if test = " q.level_desc!= null  " >level_desc,</if>
  <if test = " q.sf_memo!= null  " >sf_memo,</if>
  <if test = " q.sf_type!= null  " >sf_type,</if>
  <if test = " q.roughness_val1!= null  " >roughness_val1,</if>
  <if test = " q.roughness_val2!= null  " >roughness_val2,</if>
  <if test = " q.roughness_val3!= null  " >roughness_val3,</if>
  <if test = " q.cop_section_code!= null  " >cop_section_code,</if>
  <if test = " q.cop_section_desc!= null  " >cop_section_desc,</if>
  <if test = " q.respon_section_code!= null  " >respon_section_code,</if>
  <if test = " q.respon_section_name!= null  " >respon_section_name,</if>
  <if test = " q.reason_code!= null  " >reason_code,</if>
  <if test = " q.reason_desc!= null  " >reason_desc,</if>
  <if test = " q.sfu_is_lock!= null  " >sfu_is_lock,</if>
  <if test = " q.sfd_is_lock!= null  " >sfd_is_lock,</if>
  <if test = " q.sfe_is_lock!= null  " >sfe_is_lock,</if>
  <if test = " q.design_key!= null  " >design_key,</if>
  <if test = " q.order_no!= null  " >order_no,</if>
  <if test = " q.psc!= null  " >psc,</if>
  <if test = " q.psc_desc!= null  " >psc_desc,</if>
  <if test = " q.pline_code!= null  " >pline_code,</if>
  <if test = " q.pline_name!= null  " >pline_name,</if>
  <if test = " q.wrk_ord!= null  " >wrk_ord,</if>
  <if test = " q.wrk_grp!= null  " >wrk_grp,</if>
  <if test = " q.judge_name!= null  " >judge_name,</if>
  <if test = " q.judge_name!= null  " >judge_time,</if>
  <if test = " q.prod_code!= null  " >prod_code,</if>
  <if test = " q.prod_name!= null  " >prod_name,</if>
  <if test = " q.steel_code!= null  " >steel_code,</if>
  <if test = " q.steel_name!= null  " >steel_name,</if>
  <if test = " q.std_code!= null  " >std_code,</if>
  <if test = " q.std_name!= null  " >std_name,</if>
  <if test = " q.thick!= null  " >thick,</if>
  <if test = " q.width!= null  " >width,</if>
  <if test = " q.length!= null  " >length,</if>
  
       </trim> values
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
       <if test = " q.surface_id!= null  " >#{q.surface_id,jdbcType =VARCHAR},</if>
  <if test = " q.heat_no!= null  " >#{q.heat_no,jdbcType =VARCHAR},</if>
  <if test = " q.batch_no!= null  " >#{q.batch_no,jdbcType =VARCHAR},</if>
  <if test = " q.board_no!= null  " >#{q.board_no,jdbcType =VARCHAR},</if>
  <if test = " q.inspection_lot!= null  " >#{q.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
  <if test = " q.sf_result_code!= null  " >#{q.sf_result_code,jdbcType =VARCHAR},</if>
  <if test = " q.sf_result_desc!= null  " >#{q.sf_result_desc,jdbcType =VARCHAR},</if>
  <if test = " q.level_code!= null  " >#{q.level_code,jdbcType =VARCHAR},</if>
  <if test = " q.level_desc!= null  " >#{q.level_desc,jdbcType =VARCHAR},</if>
  <if test = " q.sf_memo!= null  " >#{q.sf_memo,jdbcType =VARCHAR},</if>
  <if test = " q.sf_type!= null  " >#{q.sf_type,jdbcType =VARCHAR},</if>
  <if test = " q.roughness_val1!= null  " >#{q.roughness_val1,jdbcType =VARCHAR},</if>
  <if test = " q.roughness_val2!= null  " >#{q.roughness_val2,jdbcType =VARCHAR},</if>
  <if test = " q.roughness_val3!= null  " >#{q.roughness_val3,jdbcType =VARCHAR},</if>
  <if test = " q.cop_section_code!= null  " >#{q.cop_section_code,jdbcType =VARCHAR},</if>
  <if test = " q.cop_section_desc!= null  " >#{q.cop_section_desc,jdbcType =VARCHAR},</if>
  <if test = " q.respon_section_code!= null  " >#{q.respon_section_code,jdbcType =VARCHAR},</if>
  <if test = " q.respon_section_name!= null  " >#{q.respon_section_name,jdbcType =VARCHAR},</if>
  <if test = " q.reason_code!= null  " >#{q.reason_code,jdbcType =VARCHAR},</if>
  <if test = " q.reason_desc!= null  " >#{q.reason_desc,jdbcType =VARCHAR},</if>
  <if test = " q.sfu_is_lock!= null  " >#{q.sfu_is_lock,jdbcType =VARCHAR},</if>
  <if test = " q.sfd_is_lock!= null  " >#{q.sfd_is_lock,jdbcType =VARCHAR},</if>
  <if test = " q.sfe_is_lock!= null  " >#{q.sfe_is_lock,jdbcType =VARCHAR},</if>
  <if test = " q.design_key!= null  " >#{q.design_key,jdbcType =VARCHAR},</if>
  <if test = " q.order_no!= null  " >#{q.order_no,jdbcType =VARCHAR},</if>
  <if test = " q.psc!= null  " >#{q.psc,jdbcType =VARCHAR},</if>
  <if test = " q.psc_desc!= null  " >#{q.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " q.pline_code!= null  " >#{q.pline_code,jdbcType =VARCHAR},</if>
  <if test = " q.pline_name!= null  " >#{q.pline_name,jdbcType =VARCHAR},</if>
  <if test = " q.wrk_ord!= null  " >#{q.wrk_ord,jdbcType =VARCHAR},</if>
  <if test = " q.wrk_grp!= null  " >#{q.wrk_grp,jdbcType =VARCHAR},</if>
  <if test = " q.judge_name!= null  " >#{q.judge_name,jdbcType =VARCHAR},</if>
  <if test = " q.judge_name!= null  " >sysdate,</if>
  <if test = " q.prod_code!= null  " >#{q.prod_code,jdbcType =VARCHAR},</if>
  <if test = " q.prod_name!= null  " >#{q.prod_name,jdbcType =VARCHAR},</if>
  <if test = " q.steel_code!= null  " >#{q.steel_code,jdbcType =VARCHAR},</if>
  <if test = " q.steel_name!= null  " >#{q.steel_name,jdbcType =VARCHAR},</if>
  <if test = " q.std_code!= null  " >#{q.std_code,jdbcType =VARCHAR},</if>
  <if test = " q.std_name!= null  " >#{q.std_name,jdbcType =VARCHAR},</if>
  <if test = " q.thick!= null  " >#{q.thick,jdbcType =VARCHAR},</if>
  <if test = " q.width!= null  " >#{q.width,jdbcType =VARCHAR},</if>
  <if test = " q.length!= null  " >#{q.length,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id="insertQcmJudgeSurfaceFlaw" parameterType = "QCM.COMMUNAL.VO.QcmJudgeSurfaceFlaw">
insert into QCM_JUDGE_SURFACE_FLAW
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.surface_id!= null  " >surface_id,</if>
  <if test = " q.primary_flag!= null  " >primary_flag,</if>
  <if test = " q.is_repair!= null  " >is_repair,</if>
  <if test = " q.flaw_seq!= null  " >flaw_seq,</if>
  <if test = " q.flaw_code!= null  " >flaw_code,</if>
  <if test = " q.flaw_desc!= null  " >flaw_desc,</if>
  <if test = " q.flaw_area!= null  " >flaw_area,</if>
  <if test = " q.flaw_type_code!= null  " >flaw_type_code,</if>
  <if test = " q.flaw_type_desc!= null  " >flaw_type_desc,</if>
  <if test = " q.flaw_pos_code!= null  " >flaw_pos_code,</if>
  <if test = " q.flaw_pos_desc!= null  " >flaw_pos_desc,</if>
  <if test = " q.flaw_dir_code!= null  " >flaw_dir_code,</if>
  <if test = " q.flaw_dir_desc!= null  " >flaw_dir_desc,</if>
  <if test = " q.flaw_size_code!= null  " >flaw_size_code,</if>
  <if test = " q.flaw_size_desc!= null  " >flaw_size_desc,</if>
  <if test = " q.flaw_lv_code!= null  " >flaw_lv_code,</if>
  <if test = " q.flaw_lv_desc!= null  " >flaw_lv_desc,</if>
  <if test = " q.flaw_weight!= null  " >flaw_weight,</if>
  <if test = " q.flaw_quantity!= null  " >flaw_quantity,</if>
  <if test = " q.memo!= null  " >memo,</if>
  <if test = " q.create_name!= null  " >create_name,</if>
  <if test = " q.create_name!= null  " >create_time,</if>
  <if test = "q.fixed_type_code!= null">fixed_type_code,</if>
  <if test = "q.fixed_type_desc!= null">fixed_type_desc,</if>
  <if test = "q.fixed_thick!= null">fixed_thick,</if>
  <if test = "q.fixed_name!= null">fixed_name,</if>
    <if test = "q.flaw_origin!= null">flaw_origin,</if>

       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " q.surface_id!= null  " >#{q.surface_id,jdbcType =VARCHAR},</if>
  <if test = " q.primary_flag!= null  " >#{q.primary_flag,jdbcType =VARCHAR},</if>
  <if test = " q.is_repair!= null  " >#{q.is_repair,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_seq!= null  " >#{q.flaw_seq,jdbcType =NUMERIC},</if>
  <if test = " q.flaw_code!= null  " >#{q.flaw_code,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_desc!= null  " >#{q.flaw_desc,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_area!= null  " >#{q.flaw_area,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_type_code!= null  " >#{q.flaw_type_code,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_type_desc!= null  " >#{q.flaw_type_desc,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_pos_code!= null  " >#{q.flaw_pos_code,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_pos_desc!= null  " >#{q.flaw_pos_desc,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_dir_code!= null  " >#{q.flaw_dir_code,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_dir_desc!= null  " >#{q.flaw_dir_desc,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_size_code!= null  " >#{q.flaw_size_code,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_size_desc!= null  " >#{q.flaw_size_desc,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_lv_code!= null  " >#{q.flaw_lv_code,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_lv_desc!= null  " >#{q.flaw_lv_desc,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_weight!= null  " >#{q.flaw_weight,jdbcType =NUMERIC},</if>
  <if test = " q.flaw_quantity!= null  " >#{q.flaw_quantity,jdbcType =NUMERIC},</if>
  <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >#{q.create_time,jdbcType =TIMESTAMP},</if>
  <if test = "q.fixed_type_code!= null">#{q.fixed_type_code,jdbcType =VARCHAR},</if>
  <if test = "q.fixed_type_desc!= null">#{q.fixed_type_desc,jdbcType =VARCHAR},</if>
  <if test = "q.fixed_thick!= null">#{q.fixed_thick,jdbcType =VARCHAR},</if>
  <if test = "q.fixed_name!= null">#{q.fixed_name,jdbcType =VARCHAR},</if>
  <if test = "q.flaw_origin!= null">#{q.flaw_origin,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id= "insertQcmJudgeUltimateReason" parameterType= "QCM.COMMUNAL.VO.QcmJudgeUltimateReason">
insert into QCM_JUDGE_ULTIMATE_REASON
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.material_no!= null  " >material_no,</if>
  <if test = " q.type_code!= null  " >type_code,</if>
  <if test = " q.record_id!= null  " >record_id,</if>
  <if test = " q.seq!= null  " >seq,</if>
  <if test = " q.phy_code_l!= null  " >phy_code_l,</if>
  <if test = " q.phy_name_l!= null  " >phy_name_l,</if>
  <if test = " q.phy_code_m!= null  " >phy_code_m,</if>
  <if test = " q.phy_name_m!= null  " >phy_name_m,</if>
  <if test = " q.phy_code_s!= null  " >phy_code_s,</if>
  <if test = " q.phy_name_s!= null  " >phy_name_s,</if>
  <if test = " q.item_code_d!= null  " >item_code_d,</if>
  <if test = " q.item_name_d!= null  " >item_name_d,</if>
  <if test = " q.item_code_t!= null  " >item_code_t,</if>
  <if test = " q.item_name_t!= null  " >item_name_t,</if>
  <if test = " q.item_code_s!= null  " >item_code_s,</if>
  <if test = " q.item_name_s!= null  " >item_name_s,</if>
  <if test = " q.val1!= null  " >val1,</if>
  <if test = " q.val2!= null  " >val2,</if>
  <if test = " q.val3!= null  " >val3,</if>
  <if test = " q.avg_val!= null  " >avg_val,</if>
  <if test = " q.stdmin_sign!= null  " >stdmin_sign,</if>
  <if test = " q.stdmin!= null  " >stdmin,</if>
  <if test = " q.stdmax_sign!= null  " >stdmax_sign,</if>
  <if test = " q.stdmax!= null  " >stdmax,</if>
  <if test = " q.create_name!= null  " >create_name,</if>
  <if test = " q.create_name!= null  " >create_time,</if>
  <if test = " q.item_code_l!= null  " >item_code_l,</if>
  <if test = " q.item_desc_l!= null  " >item_desc_l,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
       <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
  <if test = " q.type_code!= null  " >#{q.type_code,jdbcType =VARCHAR},</if>
  <if test = " q.record_id!= null  " >#{q.record_id,jdbcType =VARCHAR},</if>
  <if test = " q.seq!= null  " >#{q.seq,jdbcType =NUMERIC},</if>
  <if test = " q.phy_code_l!= null  " >#{q.phy_code_l,jdbcType =VARCHAR},</if>
  <if test = " q.phy_name_l!= null  " >#{q.phy_name_l,jdbcType =VARCHAR},</if>
  <if test = " q.phy_code_m!= null  " >#{q.phy_code_m,jdbcType =VARCHAR},</if>
  <if test = " q.phy_name_m!= null  " >#{q.phy_name_m,jdbcType =VARCHAR},</if>
  <if test = " q.phy_code_s!= null  " >#{q.phy_code_s,jdbcType =VARCHAR},</if>
  <if test = " q.phy_name_s!= null  " >#{q.phy_name_s,jdbcType =VARCHAR},</if>
  <if test = " q.item_code_d!= null  " >#{q.item_code_d,jdbcType =VARCHAR},</if>
  <if test = " q.item_name_d!= null  " >#{q.item_name_d,jdbcType =VARCHAR},</if>
  <if test = " q.item_code_t!= null  " >#{q.item_code_t,jdbcType =VARCHAR},</if>
  <if test = " q.item_name_t!= null  " >#{q.item_name_t,jdbcType =VARCHAR},</if>
  <if test = " q.item_code_s!= null  " >#{q.item_code_s,jdbcType =VARCHAR},</if>
  <if test = " q.item_name_s!= null  " >#{q.item_name_s,jdbcType =VARCHAR},</if>
  <if test = " q.val1!= null  " >#{q.val1,jdbcType =VARCHAR},</if>
  <if test = " q.val2!= null  " >#{q.val2,jdbcType =VARCHAR},</if>
  <if test = " q.val3!= null  " >#{q.val3,jdbcType =VARCHAR},</if>
  <if test = " q.avg_val!= null  " >#{q.avg_val,jdbcType =VARCHAR},</if>
  <if test = " q.stdmin_sign!= null  " >#{q.stdmin_sign,jdbcType =VARCHAR},</if>
  <if test = " q.stdmin!= null  " >#{q.stdmin,jdbcType =VARCHAR},</if>
  <if test = " q.stdmax_sign!= null  " >#{q.stdmax_sign,jdbcType =VARCHAR},</if>
  <if test = " q.stdmax!= null  " >#{q.stdmax,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >SYSDATE,</if>
  <if test = " q.item_code_l!= null  " >#{q.item_code_l,jdbcType =VARCHAR},</if>
  <if test = " q.item_desc_l!= null  " >#{q.item_desc_l,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id="insertDealMemo"  parameterType="QCM.COMMUNAL.VO.DealMemo">
        insert into deal_memo
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " list.memo_code!= null  " >memo_code,</if>
 	 	<if test = " list.memo!= null  " >memo,</if>
  		<if test = " list.pline_code!= null  " >pline_code,</if>
  		<if test = " list.creat_name!= null  " >creat_name,</if>
  		<if test = " list.creat_time!= null  " >creat_time,</if>
  		<if test = " list.mod_id!= null  " >mod_id,</if>
  		<if test = " list.mod_time!= null  " >mod_time,</if>  
  		</trim>      
         VALUES
         <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " list.memo_code!= null  " >#{list.memo_code,jdbcType =VARCHAR},</if>
 	 	<if test = " list.memo!= null  " >#{list.memo,jdbcType =VARCHAR},</if>
  		<if test = " list.pline_code!= null  " >#{list.pline_code,jdbcType =VARCHAR},</if>
  		<if test = " list.creat_name!= null  " >#{list.creat_name,jdbcType =VARCHAR},</if>
  		<if test = " list.creat_time!= null  " >#{list.creat_time,jdbcType =DATE},</if>
  		<if test = " list.mod_id!= null  " >#{list.mod_id,jdbcType =VARCHAR},</if>
  		<if test = " list.mod_time!= null  " >#{list.mod_time,jdbcType =DATE},</if>
  		 </trim>
</insert>

<!-- <insert id="insertExcelWGJMain"  parameterType="QCM.COMMUNAL.VO.ExcelWGJMain"> -->
<!--         insert into Excel_SZ -->
<!--         <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=","> -->
<!--         <if test = " list.coil_no!= null  " >coil_no,</if> -->
<!--  	 	<if test = " list.slab_no!= null  " >slab_no,</if> -->
<!--   		<if test = " list.old_sampl_no!= null  " >old_sampl_no,</if> -->
<!--   		<if test = " list.coil_stat!= null  " >coil_stat,</if> -->
<!--   		<if test = " list.cur_prog_cd!= null  " >cur_prog_cd,</if> -->
<!--   		<if test = " list.coil_len!= null  " >coil_len,</if> -->
<!--   		<if test = " list.coil_india!= null  " >coil_india,</if> -->
<!--   		<if test = " list.coil_outdia!= null  " >coil_outdia,</if> -->
<!--   		<if test = " list.coil_thk!= null  " >coil_thk,</if> -->
<!--   		<if test = " list.coil_wth!= null  " >coil_wth,</if> -->
<!--   		<if test = " list.act_wgt!= null  " >act_wgt,</if> -->
<!--   		<if test = " list.ord_fl!= null  " >ord_fl,</if> -->
<!--   		<if test = " list.ord_no!= null  " >ord_no,</if> -->
<!--   		<if test = " list.ord_seq!= null  " >ord_seq,</if> -->
<!--   		<if test = " list.spec_abbsym!= null  " >spec_abbsym,</if> -->
<!--   		<if test = " list.spec_stl_grd!= null  " >spec_stl_grd,</if> -->
<!--   		<if test = " list.stl_grd!= null  " >stl_grd,</if>   -->
<!--   		</trim>       -->
<!--          VALUES -->
<!--          <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=","> -->
<!--          <if test = " list.coil_no!= null  " >#{list.coil_no,jdbcType =VARCHAR},</if> -->
<!--  	 	<if test = " list.slab_no!= null  " >#{list.slab_no,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.old_sampl_no!= null  " >#{list.old_sampl_no,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.coil_stat!= null  " >#{list.coil_stat,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.cur_prog_cd!= null  " >#{list.cur_prog_cd,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.coil_len!= null  " >#{list.coil_len,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.coil_india!= null  " >#{list.coil_india,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.coil_outdia!= null  " >#{list.coil_outdia,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.coil_thk!= null  " >#{list.coil_thk,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.coil_wth!= null  " >#{list.coil_wth,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.act_wgt!= null  " >#{list.act_wgt,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.ord_fl!= null  " >#{list.ord_fl,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.ord_no!= null  " >#{list.ord_no,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.ord_seq!= null  " >#{list.ord_seq,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.spec_abbsym!= null  " >#{list.spec_abbsym,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.spec_stl_grd!= null  " >#{list.spec_stl_grd,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.stl_grd!= null  " >#{list.stl_grd,jdbcType =VARCHAR},</if>           -->
<!--   		 </trim> -->
<!-- </insert> -->

<insert id="insertExcelWGJMain"  parameterType="java.util.List">
        insert into c_tbk02_coil_comm
        (coil_no,slab_no,old_sampl_no,coil_stat,cur_prog_cd,coil_len,coil_india,coil_outdia,
        coil_thk,coil_wth,act_wgt,ord_fl,ord_no,ord_seq,spec_abbsym,spec_stl_grd,stl_grd,cur_prog_cd_dtime,cur_prog_cd_pgm,CR_PLANT_TRS_DTIME)     
         <foreach collection="list" item="item" index="index" separator="union all">
         select 
        #{item.coil_no,jdbcType =VARCHAR},#{item.slab_no,jdbcType =VARCHAR},#{item.old_sampl_no,jdbcType =VARCHAR},
        '2',
  		#{item.cur_prog_cd,jdbcType =VARCHAR},#{item.coil_len,jdbcType =VARCHAR},#{item.coil_india,jdbcType =VARCHAR},
  		#{item.coil_outdia,jdbcType =VARCHAR},
  		#{item.coil_thk,jdbcType =VARCHAR},#{item.coil_wth,jdbcType =VARCHAR},#{item.act_wgt,jdbcType =VARCHAR},
  		#{item.ord_fl,jdbcType =VARCHAR},
  		#{item.ord_no,jdbcType =VARCHAR},#{item.ord_seq,jdbcType =VARCHAR},#{item.spec_abbsym,jdbcType =VARCHAR},
  		#{item.spec_stl_grd,jdbcType =VARCHAR},#{item.stl_grd,jdbcType =VARCHAR},TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),'外购',TO_CHAR(SYSDATE,'YYYYMMDD')
  		from dual        
  		 </foreach>
</insert>

<!-- <insert id="insertExcelWGJCXN"  parameterType="QCM.COMMUNAL.VO.ExcelWGJCXN"> -->
<!--         insert into Excel_LZ_XN -->
<!--         <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=","> -->
<!--         <if test = " list.specimen_no!= null  " >specimen_no,</if> -->
<!--  	 	<if test = " list.phy_name_s!= null  " >phy_name_s,</if> -->
<!--   		<if test = " list.val1!= null  " >val1,</if>  		  -->
<!--   		</trim>       -->
<!--          VALUES -->
<!--          <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=","> -->
<!--         <if test = " list.specimen_no!= null  " >#{list.specimen_no,jdbcType =VARCHAR},</if> -->
<!--  	 	<if test = " list.phy_name_s!= null  " >#{list.phy_name_s,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.val1!= null   " >#{list.val1,jdbcType =VARCHAR},</if> -->
  		
<!--   		 </trim> -->
<!-- </insert> -->

<!-- <insert id="insertExcelWGJCXN"  parameterType="java.util.List"> -->
<!--         insert into Excel_LZ_XN         -->
<!--         (specimen_no,phy_name_s,val1) -->
<!--          <foreach collection="list" item="item" index="index" separator="union all"> -->
<!--         select #{item.specimen_no,jdbcType =VARCHAR},#{item.phy_name_s,jdbcType =VARCHAR},#{item.val1,jdbcType =VARCHAR} from dual 		 -->
<!--   		 </foreach> -->
<!-- </insert> -->

<insert id="insertExcelWGJCXN"  parameterType="java.util.List">
        insert into Excel_LZ_XN        
        (COIL_NO,KLQD,QFQD,DHSCL)
         <foreach collection="list" item="item" index="index" separator="union all">
        select #{item.coil_no,jdbcType =VARCHAR},#{item.klqd,jdbcType =VARCHAR},
        #{item.qfqd,jdbcType =VARCHAR},#{item.dhscl,jdbcType =VARCHAR} from dual 		
  		 </foreach>
</insert>

<!-- <insert id="insertExcelWGJCF"  parameterType="QCM.COMMUNAL.VO.ExcelWGJCF"> -->
<!--         insert into Excel_LZ_CF -->
<!--         <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=","> -->
<!--         <if test = " list.charge_no!= null  " >charge_no,</if> -->
<!--  	 	<if test = " list.chem_cd!= null  " >chem_cd,</if> -->
<!--   		<if test = " list.chem_val!= null  " >chem_val,</if>  		  -->
<!--   		</trim>       -->
<!--          VALUES -->
<!--          <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=","> -->
<!--         <if test = " list.charge_no!= null  " >#{list.charge_no,jdbcType =VARCHAR},</if> -->
<!--  	 	<if test = " list.chem_cd!= null  " >#{list.chem_cd,jdbcType =VARCHAR},</if> -->
<!--   		<if test = " list.chem_val!= null   " >#{list.chem_val,jdbcType =VARCHAR},</if> -->
  		
<!--   		 </trim> -->
<!-- </insert> -->

<!-- <insert id="insertExcelWGJCF" parameterType="java.util.List"> -->
<!--         insert into Excel_LZ_CF(charge_no,chem_cd,chem_value,proc_cd,chem_seq, -->
<!--         chem_val_tp,reg_id,reg_dtime)     -->
<!--          <foreach collection="list" item="item" index="index" separator="union all"> -->
<!--         select #{item.charge_no,jdbcType =VARCHAR}, -->
<!--  	 	#{item.chem_cd,jdbcType =VARCHAR},#{item.chem_val,jdbcType =VARCHAR},  -->
<!--  	 	'JJ','01','L','Excel',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') from DUAL -->
<!--   		 </foreach> -->
<!-- </insert> -->

<insert id="insertExcelWGJCF" parameterType="java.util.List">
        insert into QCM_JHY_INSP_ELEMENTS(assay_no,heat_no,chem_code,chem_name,chem_value,batch_no,material_no,
        pline_code,pline_name,assay_type,source,create_time,create_name)    
         <foreach collection="list" item="item" index="index" separator="union all">
        select #{item.assay_no,jdbcType =VARCHAR},#{item.heat_no,jdbcType =VARCHAR},
 	 	#{item.chem_cd,jdbcType =VARCHAR},#{item.chem_name,jdbcType =VARCHAR},
 	 	#{item.chem_value,jdbcType =VARCHAR},#{item.batch_no,jdbcType =VARCHAR},
 	 	#{item.material_no,jdbcType =VARCHAR},'RZ1','热轧','L', '0',SYSDATE,#{item.create_name,jdbcType =VARCHAR}
 	 	from DUAL
  		 </foreach>
</insert>

<insert id="insertExcelWGJCF1" parameterType="java.util.List">
        insert into tbb02_work_ingr(charge_no,chem_cd,chem_val,proc_cd,chem_seq,
        chem_val_tp,reg_id,reg_dtime,chem_l2_val)    
         <foreach collection="list" item="item" index="index" separator="union all">
        select #{item.charge_no,jdbcType =VARCHAR},
 	 	#{item.chem_cd,jdbcType =VARCHAR},#{item.chem_value,jdbcType =VARCHAR}, 
 	 	'JJ','01','L','Excel',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),#{item.chem_value,jdbcType =VARCHAR} from DUAL
  		 </foreach>
</insert>

<insert id = "insertQCMJudgeMeasure" parameterType ="QCM.COMMUNAL.VO.QCMJudgeMeasure">
insert into QCM_JUDGE_MEASURE
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " qju.sic_id!= null  " >sic_id,</if>
  <if test = " qju.design_key!= null  " >design_key,</if>
  <if test = " qju.heat_no!= null  " >heat_no,</if>
  <if test = " qju.batch_no!= null  " >batch_no,</if>
  <if test = " qju.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " qju.board_no!= null  " >board_no,</if>
  <if test = " qju.material_no!= null  " >material_no,</if>
  <if test = " qju.sic_result_code!= null  " >sic_result_code,</if>
  <if test = " qju.sic_result_desc!= null  " >sic_result_desc,</if>
  <if test = " qju.sic_memo!= null  " >sic_memo,</if>
  <if test = " qju.weight!= null  " >weight,</if>
  <if test = " qju.south_thick_val!= null  " >south_thick_val,</if>
  <if test = " qju.south_h_val!= null  " >south_h_val,</if>
  <if test = " qju.south_m_val!= null  " >south_m_val,</if>
  <if test = " qju.south_r_val!= null  " >south_r_val,</if>
  <if test = " qju.middle_thick_val!= null  " >middle_thick_val,</if>
  <if test = " qju.middle_h_val!= null  " >middle_h_val,</if>
  <if test = " qju.middle_m_val!= null  " >middle_m_val,</if>
  <if test = " qju.middle_r_val!= null  " >middle_r_val,</if>
  <if test = " qju.north_thick_val!= null  " >north_thick_val,</if>
  <if test = " qju.north_h_val!= null  " >north_h_val,</if>
  <if test = " qju.north_m_val!= null  " >north_m_val,</if>
  <if test = " qju.north_r_val!= null  " >north_r_val,</if>
  <if test = " qju.pline_code!= null  " >pline_code,</if>
  <if test = " qju.pline_name!= null  " >pline_name,</if>
  <if test = " qju.wrk_ord!= null  " >wrk_ord,</if>
  <if test = " qju.wrk_grp!= null  " >wrk_grp,</if>
  <if test = " qju.judge_name!= null  " >judge_name,</if>
  <if test = " qju.judge_name!= null  " >judge_time,</if>
  <if test = " qju.psc!= null  " >psc,</if>
  <if test = " qju.psc_desc!= null  " >psc_desc,</if>
  <if test = " qju.respon_section_code!= null  " >respon_section_code,</if>
  <if test = " qju.respon_section_name!= null  " >respon_section_name,</if>
  <if test = " qju.prod_code!= null  " >prod_code,</if>
  <if test = " qju.prod_name!= null  " >prod_name,</if>
  <if test = " qju.steel_code!= null  " >steel_code,</if>
  <if test = " qju.steel_name!= null  " >steel_name,</if>
  <if test = " qju.std_code!= null  " >std_code,</if>
  <if test = " qju.std_name!= null  " >std_name,</if>
  <if test = " qju.level_code!= null  " >level_code,</if>
  <if test = " qju.level_desc!= null  " >level_desc,</if>
  <if test = " qju.thick!= null  " >thick,</if>
  <if test = " qju.width!= null  " >width,</if>
  <if test = " qju.length!= null  " >length,</if>
  <if test = " qju.change_type_desc!= null  " >change_type_desc,</if>
  
       </trim> values
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
       <if test = " qju.sic_id!= null  " >#{qju.sic_id,jdbcType =VARCHAR},</if>
  <if test = " qju.design_key!= null  " >#{qju.design_key,jdbcType =VARCHAR},</if>
  <if test = " qju.heat_no!= null  " >#{qju.heat_no,jdbcType =VARCHAR},</if>
  <if test = " qju.batch_no!= null  " >#{qju.batch_no,jdbcType =VARCHAR},</if>
  <if test = " qju.inspection_lot!= null  " >#{qju.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " qju.board_no!= null  " >#{qju.board_no,jdbcType =VARCHAR},</if>
  <if test = " qju.material_no!= null  " >#{qju.material_no,jdbcType =VARCHAR},</if>
  <if test = " qju.sic_result_code!= null  " >#{qju.sic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.sic_result_desc!= null  " >#{qju.sic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.sic_memo!= null  " >#{qju.sic_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.weight!= null  " >#{qju.weight,jdbcType =NUMERIC},</if>
  <if test = " qju.south_thick_val!= null  " >#{qju.south_thick_val,jdbcType =NUMERIC},</if>
  <if test = " qju.south_h_val!= null  " >#{qju.south_h_val,jdbcType =NUMERIC},</if>
  <if test = " qju.south_m_val!= null  " >#{qju.south_m_val,jdbcType =NUMERIC},</if>
  <if test = " qju.south_r_val!= null  " >#{qju.south_r_val,jdbcType =NUMERIC},</if>
  <if test = " qju.middle_thick_val!= null  " >#{qju.middle_thick_val,jdbcType =NUMERIC},</if>
  <if test = " qju.middle_h_val!= null  " >#{qju.middle_h_val,jdbcType =NUMERIC},</if>
  <if test = " qju.middle_m_val!= null  " >#{qju.middle_m_val,jdbcType =NUMERIC},</if>
  <if test = " qju.middle_r_val!= null  " >#{qju.middle_r_val,jdbcType =NUMERIC},</if>
  <if test = " qju.north_thick_val!= null  " >#{qju.north_thick_val,jdbcType =NUMERIC},</if>
  <if test = " qju.north_h_val!= null  " >#{qju.north_h_val,jdbcType =NUMERIC},</if>
  <if test = " qju.north_m_val!= null  " >#{qju.north_m_val,jdbcType =NUMERIC},</if>
  <if test = " qju.north_r_val!= null  " >#{qju.north_r_val,jdbcType =NUMERIC},</if>
  <if test = " qju.pline_code!= null  " >#{qju.pline_code,jdbcType =VARCHAR},</if>
  <if test = " qju.pline_name!= null  " >#{qju.pline_name,jdbcType =VARCHAR},</if>
  <if test = " qju.wrk_ord!= null  " >#{qju.wrk_ord,jdbcType =VARCHAR},</if>
  <if test = " qju.wrk_grp!= null  " >#{qju.wrk_grp,jdbcType =VARCHAR},</if>
  <if test = " qju.judge_name!= null  " >#{qju.judge_name,jdbcType =VARCHAR},</if>
  <if test = " qju.judge_name!= null  " >sysdate,</if>
  <if test = " qju.psc!= null  " >#{qju.psc,jdbcType =VARCHAR},</if>
  <if test = " qju.psc_desc!= null  " >#{qju.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.respon_section_code!= null  " >#{qju.respon_section_code,jdbcType =VARCHAR},</if>
  <if test = " qju.respon_section_name!= null  " >#{qju.respon_section_name,jdbcType =VARCHAR},</if>
   <if test = " qju.prod_code!= null  " >#{qju.prod_code,jdbcType =VARCHAR},</if>
  <if test = " qju.prod_name!= null  " >#{qju.prod_name,jdbcType =VARCHAR},</if>
  <if test = " qju.steel_code!= null  " >#{qju.steel_code,jdbcType =VARCHAR},</if>
  <if test = " qju.steel_name!= null  " >#{qju.steel_name,jdbcType =VARCHAR},</if>
  <if test = " qju.std_code!= null  " >#{qju.std_code,jdbcType =VARCHAR},</if>
   <if test = " qju.std_name!= null  " >#{qju.std_name,jdbcType =VARCHAR},</if>
   <if test = " qju.level_code!= null  " >#{qju.level_code,jdbcType =VARCHAR},</if>
  <if test = " qju.level_desc!= null  " >#{qju.level_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.thick!= null  " >#{qju.thick,jdbcType =VARCHAR},</if>
   <if test = " qju.width!= null  " >#{qju.width,jdbcType =VARCHAR},</if>
  <if test = " qju.length!= null  " >#{qju.length,jdbcType =VARCHAR},</if>
  <if test = " qju.change_type_desc!= null  " >#{qju.change_type_desc,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id="insertQcmJudgeUltimate" parameterType= "QCM.COMMUNAL.VO.QcmJudgeUltimate">
  insert into QCM_JUDGE_ULTIMATE
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " qju.utm_id!= null  " >utm_id,</if>
  <if test = " qju.design_key!= null  " >design_key,</if>
  <if test = " qju.heat_no!= null  " >heat_no,</if>
  <if test = " qju.batch_no!= null  " >batch_no,</if>
  <if test = " qju.board_no!= null  " >board_no,</if>
  <if test = " qju.inspection_lot!= null  " >inspection_lot,</if>
  <if test = " qju.material_no!= null  " >material_no,</if>
  <if test = " qju.contract_line_no!= null  " >contract_line_no,</if>
  <if test = " qju.psc!= null  " >psc,</if>
  <if test = " qju.box_no!= null  " >box_no,</if>
  <if test = " qju.cic_id!= null  " >cic_id,</if>
  <if test = " qju.cic_result_code!= null  " >cic_result_code,</if>
  <if test = " qju.cic_result_desc!= null  " >cic_result_desc,</if>
  <if test = " qju.cic_memo!= null  " >cic_memo,</if>
  <if test = " qju.pic_id!= null  " >pic_id,</if>
  <if test = " qju.pic_result_code!= null  " >pic_result_code,</if>
  <if test = " qju.pic_result_desc!= null  " >pic_result_desc,</if>
  <if test = " qju.pic_memo!= null  " >pic_memo,</if>
  <if test = " qju.sic_id!= null  " >sic_id,</if>
  <if test = " qju.sic_result_code!= null  " >sic_result_code,</if>
  <if test = " qju.sic_result_desc!= null  " >sic_result_desc,</if>
  <if test = " qju.sic_memo!= null  " >sic_memo,</if>
  <if test = " qju.dic_id!= null  " >dic_id,</if>
  <if test = " qju.dic_result_code!= null  " >dic_result_code,</if>
  <if test = " qju.dic_result_desc!= null  " >dic_result_desc,</if>
  <if test = " qju.dic_memo!= null  " >dic_memo,</if>
  <if test = " qju.sfu_id!= null  " >sfu_id,</if>
  <if test = " qju.sfu_result_code!= null  " >sfu_result_code,</if>
  <if test = " qju.sfu_result_desc!= null  " >sfu_result_desc,</if>
  <if test = " qju.sfu_memo!= null  " >sfu_memo,</if>
  <if test = " qju.sfd_id!= null  " >sfd_id,</if>
  <if test = " qju.sfd_result_code!= null  " >sfd_result_code,</if>
  <if test = " qju.sfd_result_desc!= null  " >sfd_result_desc,</if>
  <if test = " qju.sfd_memo!= null  " >sfd_memo,</if>
  <if test = " qju.sfe_id!= null  " >sfe_id,</if>
  <if test = " qju.sfe_result_code!= null  " >sfe_result_code,</if>
  <if test = " qju.sfe_result_desc!= null  " >sfe_result_desc,</if>
  <if test = " qju.sfe_memo!= null  " >sfe_memo,</if>
  <if test = " qju.mst_id!= null  " >mst_id,</if>
  <if test = " qju.mst_result_code!= null  " >mst_result_code,</if>
  <if test = " qju.mst_result_desc!= null  " >mst_result_desc,</if>
  <if test = " qju.mst_memo!= null  " >mst_memo,</if>
  <if test = " qju.fst_id!= null  " >fst_id,</if>
  <if test = " qju.fst_result_code!= null  " >fst_result_code,</if>
  <if test = " qju.fst_result_desc!= null  " >fst_result_desc,</if>
  <if test = " qju.fst_memo!= null  " >fst_memo,</if>
  <if test = " qju.fst_reason!= null  " >fst_reason,</if>
  <if test = " qju.utm_result_code!= null  " >utm_result_code,</if>
  <if test = " qju.utm_result_desc!= null  " >utm_result_desc,</if>
  <if test = " qju.utm_reason!= null  " >utm_reason,</if>
  <if test = " qju.utm_memo!= null  " >utm_memo,</if>
  <if test = " qju.pline_code!= null  " >pline_code,</if>
  <if test = " qju.pline_name!= null  " >pline_name,</if>
  <if test = " qju.judge_name!= null  " >judge_name,</if>
  <if test = " qju.judge_name!= null  " >judge_time,</if>
  <if test = " qju.psc_desc!= null  " >psc_desc,</if>
  <if test = " qju.prod_code!= null  " >prod_code,</if>
  <if test = " qju.prod_name!= null  " >prod_name,</if>
  <if test = " qju.steel_code!= null  " >steel_code,</if>
  <if test = " qju.steel_name!= null  " >steel_name,</if>
  <if test = " qju.std_code!= null  " >std_code,</if>
  <if test = " qju.std_name!= null  " >std_name,</if>
  <if test = " qju.r_cic_id!= null  " >r_cic_id,</if>
  <if test = " qju.r_cic_result_code!= null  " >r_cic_result_code,</if>
  <if test = " qju.r_cic_result_desc!= null  " >r_cic_result_desc,</if>
  <if test = " qju.product_name!= null  " >product_name,</if>
  <if test = " qju.judge_reason!= null  " >judge_reason,</if>
  <if test = " qju.judge_memo!= null  " >judge_memo,</if>
  <if test = " qju.cancel_memo!= null">cancel_memo,</if>
  <if test = " qju.check_remarks!= null  " >check_remarks,</if>
  <if test = " qju.fix_remarks!= null  " >fix_remarks,</if>
  <if test = " qju.tic_id!= null  " >tic_id,</if>
  <if test = " qju.tic_result_code!= null  " >tic_result_code,</if>
  <if test = " qju.tic_result_desc!= null  " >tic_result_desc,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
       <if test = " qju.utm_id!= null  " >#{qju.utm_id,jdbcType =VARCHAR},</if>
  <if test = " qju.design_key!= null  " >#{qju.design_key,jdbcType =VARCHAR},</if>
  <if test = " qju.heat_no!= null  " >#{qju.heat_no,jdbcType =VARCHAR},</if>
  <if test = " qju.batch_no!= null  " >#{qju.batch_no,jdbcType =VARCHAR},</if>
  <if test = " qju.board_no!= null  " >#{qju.board_no,jdbcType =VARCHAR},</if>
  <if test = " qju.inspection_lot!= null  " >#{qju.inspection_lot,jdbcType =VARCHAR},</if>
  <if test = " qju.material_no!= null  " >#{qju.material_no,jdbcType =VARCHAR},</if>
  <if test = " qju.contract_line_no!= null  " >#{qju.contract_line_no,jdbcType =VARCHAR},</if>
  <if test = " qju.psc!= null  " >#{qju.psc,jdbcType =VARCHAR},</if>
  <if test = " qju.box_no!= null  " >#qju.box_no,jdbcType =VARCHAR},</if>
  <if test = " qju.cic_id!= null  " >#{qju.cic_id,jdbcType =VARCHAR},</if>
  <if test = " qju.cic_result_code!= null  " >#{qju.cic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.cic_result_desc!= null  " >#{qju.cic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.cic_memo!= null  " >#{qju.cic_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.pic_id!= null  " >#{qju.pic_id,jdbcType =VARCHAR},</if>
  <if test = " qju.pic_result_code!= null  " >#{qju.pic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.pic_result_desc!= null  " >#{qju.pic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.pic_memo!= null  " >#{qju.pic_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.sic_id!= null  " >#{qju.sic_id,jdbcType =VARCHAR},</if>
  <if test = " qju.sic_result_code!= null  " >#{qju.sic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.sic_result_desc!= null  " >#{qju.sic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.sic_memo!= null  " >#{qju.sic_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.dic_id!= null  " >#{qju.dic_id,jdbcType =VARCHAR},</if>
  <if test = " qju.dic_result_code!= null  " >#{qju.dic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.dic_result_desc!= null  " >#{qju.dic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.dic_memo!= null  " >#{qju.dic_memo,jdbcType =VARCHAR}_MEMO,</if>
  <if test = " qju.sfu_id!= null  " >#{qju.sfu_id,jdbcType =VARCHAR},</if>
  <if test = " qju.sfu_result_code!= null  " >#{qju.sfu_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.sfu_result_desc!= null  " >#{qju.sfu_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.sfu_memo!= null  " >#{qju.sfu_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.sfd_id!= null  " >#{qju.sfd_id,jdbcType =VARCHAR},</if>
  <if test = " qju.sfd_result_code!= null  " >#{qju.sfd_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.sfd_result_desc!= null  " >#{qju.sfd_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.sfd_memo!= null  " >#{qju.sfd_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.sfe_id!= null  " >#{qju.sfe_id,jdbcType =VARCHAR},</if>
  <if test = " qju.sfe_result_code!= null  " >#{qju.sfe_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.sfe_result_desc!= null  " >#{qju.sfe_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.sfe_memo!= null  " >#{qju.sfe_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.mst_id!= null  " >#{qju.mst_id,jdbcType =VARCHAR},</if>
  <if test = " qju.mst_result_code!= null  " >#{qju.mst_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.mst_result_desc!= null  " >#{qju.mst_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.mst_memo!= null  " >#{qju.mst_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.fst_id!= null  " >#{qju.fst_id,jdbcType =VARCHAR},</if>
  <if test = " qju.fst_result_code!= null  " >#{qju.fst_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.fst_result_desc!= null  " >#{qju.fst_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.fst_memo!= null  " >#{qju.fst_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.fst_reason!= null  " >#{qju.fst_reason,jdbcType =VARCHAR},</if>
  <if test = " qju.utm_result_code!= null  " >#{qju.utm_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.utm_result_desc!= null  " >#{qju.utm_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.utm_reason!= null  " >#{qju.utm_reason,jdbcType =VARCHAR},</if>
  <if test = " qju.utm_memo!= null  " >#{qju.utm_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.pline_code!= null  " >#{qju.pline_code,jdbcType =VARCHAR},</if>
  <if test = " qju.pline_name!= null  " >#{qju.pline_name,jdbcType =VARCHAR},</if>
  <if test = " qju.judge_name!= null  " >#{qju.judge_name,jdbcType =VARCHAR},</if>
  <if test = " qju.judge_name!= null  " >sysdate,</if>
  <if test = " qju.psc_desc!= null  " >#{qju.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.prod_code!= null  " >#{qju.prod_code,jdbcType =VARCHAR},</if>
  <if test = " qju.prod_name!= null  " >#{qju.prod_name,jdbcType =VARCHAR},</if>
  <if test = " qju.steel_code!= null  " >#{qju.steel_code,jdbcType =VARCHAR},</if>
  <if test = " qju.steel_name!= null  " >#{qju.steel_name,jdbcType =VARCHAR},</if>
  <if test = " qju.std_code!= null  " >#{qju.std_code,jdbcType =VARCHAR},</if>
  <if test = " qju.std_name!= null  " >#{qju.std_name,jdbcType =VARCHAR},</if>
  <if test = " qju.r_cic_id!= null  " >#{qju.r_cic_id,jdbcType =VARCHAR},</if>
  <if test = " qju.r_cic_result_code!= null  " >#{qju.r_cic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.r_cic_result_desc!= null  " >#{qju.r_cic_result_desc,jdbcType =VARCHAR},</if>
  <if test = " qju.product_name!= null  " >#{qju.product_name,jdbcType =VARCHAR},</if>
  <if test = " qju.judge_reason!= null  " >#{qju.judge_reason,jdbcType =VARCHAR},</if>
  <if test = " qju.judge_memo!= null  " >#{qju.judge_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.cancel_memo!= null ">#{qju.cancel_memo,jdbcType =VARCHAR},</if>
  <if test = " qju.check_remarks!= null  " >#{qju.check_remarks,jdbcType =VARCHAR},</if>
  <if test = " qju.fix_remarks!= null  " >#{qju.fix_remarks,jdbcType =VARCHAR},</if>
  <if test = " qju.tic_id!= null  " >#{qju.tic_id,jdbcType =VARCHAR},</if>
  <if test = " qju.tic_result_code!= null  " >#{qju.tic_result_code,jdbcType =VARCHAR},</if>
  <if test = " qju.tic_result_desc!= null  " >#{qju.tic_result_desc,jdbcType =VARCHAR},</if>
       </trim>
</insert>
<insert id="insertQCMJudgeLocking" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">

insert into qcm_judge_locking
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.material_no!= null  " >material_no,</if>
  <if test = " q.lock_seq!= null  " >lock_seq,</if>
  <if test = " q.lock_type_code!= null  " >lock_type_code,</if>
  <if test = " q.lock_type_desc!= null  " >lock_type_desc,</if>
  <if test = " q.lock_memo!= null  " >lock_memo,</if>
  <if test = " q.unlock_type_code!= null  " >unlock_type_code,</if>
  <if test = " q.unlock_type_desc!= null  " >unlock_type_desc,</if>
  <if test = " q.unlock_memo!= null  " >unlock_memo,</if>
  <if test = " q.target_design_key!= null  " >target_design_key,</if>
  <if test = " q.target_psc!= null  " >target_psc,</if>
  <if test = " q.heat_no!= null  " >heat_no,</if>
  <if test = " q.batch_no!= null  " >batch_no,</if>
  <if test = " q.board_no!= null  " >board_no,</if>
  <if test = " q.plan_no!= null  " >plan_no,</if>
  <if test = " q.ht_no!= null  " >ht_no,</if>
  <if test = " q.design_key!= null  " >design_key,</if>
  <if test = " q.psc!= null  " >psc,</if>
  <if test = " q.fic_locking!= null  " >fic_locking,</if>
  <if test = " q.sic_locking!= null  " >sic_locking,</if>
  <if test = " q.pic_locking!= null  " >pic_locking,</if>
  <if test = " q.dic_locking!= null  " >dic_locking,</if>
  <if test = " q.lock_name!= null  " >lock_name,</if>
  <if test = " q.lock_name!= null  " >lock_time,</if>
  <if test = " q.psc_desc!= null  " >psc_desc,</if>
  <if test = " q.pline_code!= null  " >pline_code,</if>
  <if test = " q.pline_name!= null  " >pline_name,</if>
  <if test = " q.cic_locking!= null  " >cic_locking,</if>
  <if test = " q.prod_code!= null  " >prod_code,</if>
  <if test = " q.prod_name!= null  " >prod_name,</if>
  <if test = " q.steel_code!= null  " >steel_code,</if>
  <if test = " q.steel_name!= null  " >steel_name,</if>
  <if test = " q.std_code!= null  " >std_code,</if>
  <if test = " q.std_name!= null  " >std_name,</if>
  <if test = " q.lock_id!= null  " >lock_id,</if>
  <if test = " q.reason_code!= null  " >reason_code,</if>
  <if test = " q.reason_desc!= null  " >reason_desc,</if>
  <if test = " q.flaw_code!= null  " >flaw_code,</if>
  <if test = " q.flaw_desc!= null  " >flaw_desc,</if>
  <if test = " q.lock_name!= null ">create_name,</if>
  <if test = " q.unlock_name!= null ">unlock_name,</if>
  <if test = " q.unlock_name!= null  " >unlock_time,</if>
  <if test = " q.check_remarks!= null  " >check_remarks,</if>
  <if test = " q.fix_remarks!= null  " >fix_remarks,</if>
  <if test = " q.height!= null">height,</if>
  
       </trim> values
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
       <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
  <if test = " q.lock_seq!= null  " >#{q.lock_seq,jdbcType =NUMERIC},</if>
  <if test = " q.lock_type_code!= null  " >#{q.lock_type_code,jdbcType =VARCHAR},</if>
  <if test = " q.lock_type_desc!= null  " >#{q.lock_type_desc,jdbcType =VARCHAR},</if>
  <if test = " q.lock_memo!= null  " >#{q.lock_memo,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_type_code!= null  " >#{q.unlock_type_code,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_type_desc!= null  " >#{q.unlock_type_desc,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_memo!= null  " >#{q.unlock_memo,jdbcType =VARCHAR},</if>
  <if test = " q.target_design_key!= null  " >#{q.target_design_key,jdbcType =VARCHAR},</if>
  <if test = " q.target_psc!= null  " >#{q.target_psc,jdbcType =VARCHAR},</if>
  <if test = " q.heat_no!= null  " >#{q.heat_no,jdbcType =VARCHAR},</if>
  <if test = " q.batch_no!= null  " >#{q.batch_no,jdbcType =VARCHAR},</if>
  <if test = " q.board_no!= null  " >#{q.board_no,jdbcType =VARCHAR},</if>
  <if test = " q.plan_no!= null  " >#{q.plan_no,jdbcType =VARCHAR},</if>
  <if test = " q.ht_no!= null  " >#{q.ht_no,jdbcType =VARCHAR},</if>
  <if test = " q.design_key!= null  " >#{q.design_key,jdbcType =VARCHAR},</if>
  <if test = " q.psc!= null  " >#{q.psc,jdbcType =VARCHAR},</if>
  <if test = " q.fic_locking!= null  " >#{q.fic_locking,jdbcType =VARCHAR},</if>
  <if test = " q.sic_locking!= null  " >#{q.sic_locking,jdbcType =VARCHAR},</if>
  <if test = " q.pic_locking!= null  " >#{q.pic_locking,jdbcType =VARCHAR},</if>
  <if test = " q.dic_locking!= null  " >#{q.dic_locking,jdbcType =VARCHAR},</if>
  <if test = " q.lock_name!= null  " >#{q.lock_name,jdbcType =VARCHAR},</if>
  <if test = " q.lock_name!= null  " >sysdate,</if>
  <if test = " q.psc_desc!= null  " >#{q.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " q.pline_code!= null  " >#{q.pline_code,jdbcType =VARCHAR},</if>
  <if test = " q.pline_name!= null  " >#{q.pline_name,jdbcType =VARCHAR},</if>
  <if test = " q.cic_locking!= null  " >#{q.cic_locking,jdbcType =VARCHAR},</if>
  <if test = " q.prod_code!= null  " >#{q.prod_code,jdbcType =VARCHAR},</if>
  <if test = " q.prod_name!= null  " >#{q.prod_name,jdbcType =VARCHAR},</if>
  <if test = " q.steel_code!= null  " >#{q.steel_code,jdbcType =VARCHAR},</if>
  <if test = " q.steel_name!= null  " >#{q.steel_name,jdbcType =VARCHAR},</if>
  <if test = " q.std_code!= null  " >#{q.std_code,jdbcType =VARCHAR},</if>
  <if test = " q.std_name!= null  " >#{q.std_name,jdbcType =VARCHAR},</if>
  <if test = " q.lock_id!= null  " >#{q.lock_id,jdbcType =VARCHAR},</if>
  <if test = " q.reason_code!= null  " >#{q.reason_code,jdbcType =VARCHAR},</if>
  <if test = " q.reason_desc!= null  " >#{q.reason_desc,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_code!= null  " >#{q.flaw_code,jdbcType =VARCHAR},</if>
  <if test = " q.flaw_desc!= null  " >#{q.flaw_desc,jdbcType =VARCHAR},</if>
  <if test = " q.lock_name!= null ">#{q.lock_name,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_name!= null  " >#{q.unlock_name,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_name!= null  " >sysdate,</if>
  <if test = " q.check_remarks!= null  " >#{q.check_remarks,jdbcType =VARCHAR},</if>
  <if test = " q.fix_remarks!= null  " >#{q.fix_remarks,jdbcType =VARCHAR},</if>
  <if test = " q.height!= null">#{q.height,jdbcType =VARCHAR},</if>
       </trim>
</insert>
<insert id="insertQCMJudgeLockingApply" parameterType= "QCM.COMMUNAL.VO.QcmJudgeLockingApply">

insert into qcm_judge_locking_apply
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
       <if test = " q.apply_id!= null  " >apply_id,</if>
            <if test = " q.material_no!= null  " >material_no,</if>
  <if test = " q.lock_seq!= null  " >lock_seq,</if>
  <if test = " q.lock_type_code!= null  " >lock_type_code,</if>
  <if test = " q.lock_type_desc!= null  " >lock_type_desc,</if>
  <if test = " q.lock_memo!= null  " >lock_memo,</if>
  <if test = " q.unlock_type_code!= null  " >unlock_type_code,</if>
  <if test = " q.unlock_type_desc!= null  " >unlock_type_desc,</if>
  <if test = " q.unlock_memo!= null  " >unlock_memo,</if>
  <if test = " q.heat_no!= null  " >heat_no,</if>
  <if test = " q.batch_no!= null  " >batch_no,</if>
  <if test = " q.board_no!= null  " >board_no,</if>
  <if test = " q.plan_no!= null  " >plan_no,</if>
  <if test = " q.ht_no!= null  " >ht_no,</if>
  <if test = " q.design_key!= null  " >design_key,</if>
  <if test = " q.psc!= null  " >psc,</if>
  <if test = " q.psc_desc!= null  " >psc_desc,</if>
  <if test = " q.pline_code!= null  " >pline_code,</if>
  <if test = " q.pline_name!= null  " >pline_name,</if>
  <if test = " q.prod_code!= null  " >prod_code,</if>
  <if test = " q.prod_name!= null  " >prod_name,</if>
  <if test = " q.steel_code!= null  " >steel_code,</if>
  <if test = " q.steel_name!= null  " >steel_name,</if>
  <if test = " q.std_code!= null  " >std_code,</if>
  <if test = " q.std_name!= null  " >std_name,</if>
  <if test = " q.lock_id!= null  " >lock_id,</if>
  <if test = " q.create_id!= null  " >create_id,</if>
  <if test = " q.create_name!= null  " >create_name,</if>
  <if test = " q.create_name!= null  " >create_time,</if>
  <if test = " q.height!= null  " >height,</if>
  <if test = " q.cancel_name!= null ">cancel_name,</if>
  <if test = " q.cancel_time!= null ">cancel_time,</if>
  <if test = " q.cancel_memo!= null  " >cancel_memo,</if>
  <if test = " q.status!= null  " >status,</if>
  <if test = " q.check_name!= null  " >check_name,</if>
  <if test = " q.check_name!= null">check_time,</if>
  
       </trim> values
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " q.apply_id!= null  " >#{q.apply_id,jdbcType =VARCHAR},</if>
       <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
  <if test = " q.lock_seq!= null  " >#{q.lock_seq,jdbcType =NUMERIC},</if>
  <if test = " q.lock_type_code!= null  " >#{q.lock_type_code,jdbcType =VARCHAR},</if>
  <if test = " q.lock_type_desc!= null  " >#{q.lock_type_desc,jdbcType =VARCHAR},</if>
  <if test = " q.lock_memo!= null  " >#{q.lock_memo,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_type_code!= null  " >#{q.unlock_type_code,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_type_desc!= null  " >#{q.unlock_type_desc,jdbcType =VARCHAR},</if>
  <if test = " q.unlock_memo!= null  " >#{q.unlock_memo,jdbcType =VARCHAR},</if>
  <if test = " q.heat_no!= null  " >#{q.heat_no,jdbcType =VARCHAR},</if>
  <if test = " q.batch_no!= null  " >#{q.batch_no,jdbcType =VARCHAR},</if>
  <if test = " q.board_no!= null  " >#{q.board_no,jdbcType =VARCHAR},</if>
  <if test = " q.plan_no!= null  " >#{q.plan_no,jdbcType =VARCHAR},</if>
  <if test = " q.ht_no!= null  " >#{q.ht_no,jdbcType =VARCHAR},</if>
  <if test = " q.design_key!= null  " >#{q.design_key,jdbcType =VARCHAR},</if>
  <if test = " q.psc!= null  " >#{q.psc,jdbcType =VARCHAR},</if>
  <if test = " q.psc_desc!= null  " >#{q.psc_desc,jdbcType =VARCHAR},</if>
  <if test = " q.pline_code!= null  " >#{q.pline_code,jdbcType =VARCHAR},</if>
  <if test = " q.pline_name!= null  " >#{q.pline_name,jdbcType =VARCHAR},</if>
  <if test = " q.prod_code!= null  " >#{q.prod_code,jdbcType =VARCHAR},</if>
  <if test = " q.prod_name!= null  " >#{q.prod_name,jdbcType =VARCHAR},</if>
  <if test = " q.steel_code!= null  " >#{q.steel_code,jdbcType =VARCHAR},</if>
  <if test = " q.steel_name!= null  " >#{q.steel_name,jdbcType =VARCHAR},</if>
  <if test = " q.std_code!= null  " >#{q.std_code,jdbcType =VARCHAR},</if>
  <if test = " q.std_name!= null  " >#{q.std_name,jdbcType =VARCHAR},</if>
  <if test = " q.lock_id!= null  " >#{q.lock_id,jdbcType =VARCHAR},</if>
  <if test = " q.create_id!= null  " >#{q.create_id,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >sysdate,</if>
   <if test = " q.height!= null">#{q.height,jdbcType =VARCHAR},</if>
  <if test = " q.cancel_name!= null  " >#{q.cancel_name,jdbcType =VARCHAR},</if>
  <if test = " q.cancel_name!= null ">sysdate,</if>
  <if test = " q.cancel_memo!= null  " >#{q.cancel_memo,jdbcType =VARCHAR},</if>
  <if test = " q.status!= null  " >#{q.status,jdbcType =VARCHAR},</if>
  <if test = " q.check_name!= null  " >#{q.check_name,jdbcType =VARCHAR},</if>
  <if test = " q.check_name!= null  " >sysdate,</if>
 
       </trim>
</insert>
<update id = "UpdateSurfaceFlaw">
update QCM_JUDGE_SURFACE_FLAW t
 set t.IS_REPAIR = #{flag}
 where t.SURFACE_ID = #{sufId}
 and t.FLAW_SEQ = #{FlawSeq}
</update>

<update id = "UpdateSurfaceFlaws">
update QCM_JUDGE_SURFACE_FLAW t
 set t.IS_REPAIR = #{flag},
 t.fixed_type_desc = #{fixed_type_desc},
 t.fixed_thick = #{fixed_thick}
 where t.SURFACE_ID = #{sufId}
 and t.FLAW_SEQ = #{FlawSeq}
</update>

<update id = "UpdateQcmJudgeLocking" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set UNLOCK_TYPE_CODE = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 UNLOCK_TYPE_DESC = #{qjl.unlock_type_desc,jdbcType =VARCHAR },
 UNLOCK_MEMO = #{qjl.unlock_memo,jdbcType =VARCHAR },
 TARGET_DESIGN_KEY = #{qjl.target_design_key,jdbcType =VARCHAR },
 TARGET_PSC = #{qjl.target_psc,jdbcType =VARCHAR },
 CIC_LOCKING = #{qjl.cic_locking,jdbcType =VARCHAR },
 FIC_LOCKING = #{qjl.fic_locking,jdbcType =VARCHAR },
 SIC_LOCKING = #{qjl.sic_locking,jdbcType =VARCHAR },
 PIC_LOCKING = #{qjl.pic_locking,jdbcType =VARCHAR },
 DIC_LOCKING = #{qjl.dic_locking,jdbcType =VARCHAR },
 UNLOCK_NAME = #{qjl.unlock_name,jdbcType =VARCHAR },
  <if test = " qjl.status != null ">
status=  #{qjl.status,jdbcType =VARCHAR},
</if>
 <if test = " qjl.apply_id != null ">
 apply_id = #{qjl.apply_id,jdbcType =VARCHAR },
  </if>
 UNLOCK_TIME = sysdate,
 reason_code= #{qjl.reason_code,jdbcType =VARCHAR},
 reason_desc=   #{qjl.reason_desc,jdbcType =VARCHAR},
 flaw_code=  #{qjl.flaw_code,jdbcType =VARCHAR},
 flaw_desc=   #{qjl.flaw_desc,jdbcType =VARCHAR},
 unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR}
 where MATERIAL_NO = #{qjl.material_no,jdbcType =VARCHAR }
 and LOCK_SEQ = #{qjl.lock_seq,jdbcType =VARCHAR }
</update>

<update id = "UpdateQcmJudgeLocking4" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set steel_code = #{qjl.steel_code,jdbcType =VARCHAR },
 steel_name = #{qjl.steel_name,jdbcType =VARCHAR }
 where MATERIAL_NO = #{qjl.material_no,jdbcType =VARCHAR }
 and LOCK_SEQ = #{qjl.lock_seq,jdbcType =VARCHAR }
</update>

<update id = "UpdateQcmJudgeLocking5" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set unlock_type_code = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 unlock_type_desc = #{qjl.unlock_type_desc,jdbcType =VARCHAR }
 where MATERIAL_NO = #{qjl.material_no,jdbcType =VARCHAR }
 and LOCK_SEQ = #{qjl.lock_seq,jdbcType =VARCHAR }
</update>

<update id = "UpdateQcmJudgeLocking9" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set valid_flag = #{qjl.valid_flag,jdbcType =VARCHAR },
 cancel_name = #{qjl.cancel_name,jdbcType =VARCHAR },
 cancel_memo = #{qjl.cancel_memo,jdbcType =VARCHAR },
 cancel_time = sysdate
 where MATERIAL_NO = #{qjl.material_no,jdbcType =VARCHAR }
 and LOCK_SEQ = #{qjl.lock_seq,jdbcType =VARCHAR }
</update>


<update id = "UpdateQcmJudgeLocking2" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set UNLOCK_TYPE_CODE = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 UNLOCK_TYPE_DESC = #{qjl.unlock_type_desc,jdbcType =VARCHAR },
 UNLOCK_MEMO = #{qjl.unlock_memo,jdbcType =VARCHAR },
 TARGET_DESIGN_KEY = #{qjl.target_design_key,jdbcType =VARCHAR },
 TARGET_PSC = #{qjl.target_psc,jdbcType =VARCHAR },
 CIC_LOCKING = #{qjl.cic_locking,jdbcType =VARCHAR },
 FIC_LOCKING = #{qjl.fic_locking,jdbcType =VARCHAR },
 SIC_LOCKING = #{qjl.sic_locking,jdbcType =VARCHAR },
 PIC_LOCKING = #{qjl.pic_locking,jdbcType =VARCHAR },
 DIC_LOCKING = #{qjl.dic_locking,jdbcType =VARCHAR },
 UNLOCK_NAME = #{qjl.unlock_name,jdbcType =VARCHAR },
 UNLOCK_TIME = sysdate,
  <if test = " qjl.apply_id != null ">
 apply_id = #{qjl.apply_id,jdbcType =VARCHAR },
  </if>
 reason_code= #{qjl.reason_code,jdbcType =VARCHAR},
 reason_desc=   #{qjl.reason_desc,jdbcType =VARCHAR},
 flaw_code=  #{qjl.flaw_code,jdbcType =VARCHAR},
 flaw_desc=   #{qjl.flaw_desc,jdbcType =VARCHAR},
 check_remarks=   #{qjl.check_remarks,jdbcType =VARCHAR},
 fix_remarks=   #{qjl.fix_remarks,jdbcType =VARCHAR},
 unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR}
 where MATERIAL_NO = #{qjl.material_no,jdbcType =VARCHAR }
 and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR }
 and unlock_type_code is null
</update>

<update id = "UpdateQcmJudgeLocking1" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set UNLOCK_TYPE_CODE = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 UNLOCK_TYPE_DESC = #{qjl.unlock_type_desc,jdbcType =VARCHAR },
 UNLOCK_MEMO = #{qjl.unlock_memo,jdbcType =VARCHAR },
 TARGET_DESIGN_KEY = #{qjl.target_design_key,jdbcType =VARCHAR },
 TARGET_PSC = #{qjl.target_psc,jdbcType =VARCHAR },
 CIC_LOCKING = #{qjl.cic_locking,jdbcType =VARCHAR },
 FIC_LOCKING = #{qjl.fic_locking,jdbcType =VARCHAR },
 SIC_LOCKING = #{qjl.sic_locking,jdbcType =VARCHAR },
 PIC_LOCKING = #{qjl.pic_locking,jdbcType =VARCHAR },
 DIC_LOCKING = #{qjl.dic_locking,jdbcType =VARCHAR },
 UNLOCK_NAME = #{qjl.unlock_name,jdbcType =VARCHAR },
 UNLOCK_TIME = sysdate,
 reason_code= #{qjl.reason_code,jdbcType =VARCHAR},
 reason_desc=   #{qjl.reason_desc,jdbcType =VARCHAR},
 flaw_code=   #{qjl.flaw_code,jdbcType =VARCHAR},
 flaw_desc=  #{qjl.flaw_desc,jdbcType =VARCHAR},
 unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR}
 where 1= 1
and batch_no = #{qjl.batch_no,jdbcType =VARCHAR}
 <if test = " qjl.material_no!= null  " >
and material_no = #{qjl.material_no,jdbcType =VARCHAR}
</if>
 <if test = " qjl.lock_id!= null  " >
and lock_id = #{qjl.lock_id,jdbcType =VARCHAR}
</if>
 and unlock_type_code is null
 and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR }
</update>

<update id = "UpdateQcmJudgeLocking7" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set UNLOCK_TYPE_CODE = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 UNLOCK_TYPE_DESC = #{qjl.unlock_type_desc,jdbcType =VARCHAR },
 UNLOCK_MEMO = #{qjl.unlock_memo,jdbcType =VARCHAR },
 TARGET_DESIGN_KEY = #{qjl.target_design_key,jdbcType =VARCHAR },
 TARGET_PSC = #{qjl.target_psc,jdbcType =VARCHAR },
 CIC_LOCKING = #{qjl.cic_locking,jdbcType =VARCHAR },
 FIC_LOCKING = #{qjl.fic_locking,jdbcType =VARCHAR },
 SIC_LOCKING = #{qjl.sic_locking,jdbcType =VARCHAR },
 PIC_LOCKING = #{qjl.pic_locking,jdbcType =VARCHAR },
 DIC_LOCKING = #{qjl.dic_locking,jdbcType =VARCHAR },
 UNLOCK_NAME = #{qjl.unlock_name,jdbcType =VARCHAR },
 UNLOCK_TIME = sysdate,
 reason_code= #{qjl.reason_code,jdbcType =VARCHAR},
 reason_desc=   #{qjl.reason_desc,jdbcType =VARCHAR},
 flaw_code=   #{qjl.flaw_code,jdbcType =VARCHAR},
 flaw_desc=  #{qjl.flaw_desc,jdbcType =VARCHAR},
 unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR}
 where 1= 1
and batch_no != #{qjl.batch_no,jdbcType =VARCHAR}
<if test=" qjl.heat_no != null">
and heat_no = #{qjl.heat_no,jdbcType =VARCHAR}
</if>
 <if test = " qjl.material_no!= null  " >
and material_no = #{qjl.material_no,jdbcType =VARCHAR}
</if>
 and unlock_type_code is null
 and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR }
</update>

<update id = "UpdateQcmJudgeLocking3" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set UNLOCK_TYPE_CODE = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 UNLOCK_TYPE_DESC = #{qjl.unlock_type_desc,jdbcType =VARCHAR },
 <if test = " qjl.unlock_memo != null ">
 UNLOCK_MEMO = #{qjl.unlock_memo,jdbcType =VARCHAR },
  </if>
   <if test = " qjl.apply_id != null ">
 apply_id = #{qjl.apply_id,jdbcType =VARCHAR },
  </if>
 TARGET_DESIGN_KEY = #{qjl.target_design_key,jdbcType =VARCHAR },
 TARGET_PSC = #{qjl.target_psc,jdbcType =VARCHAR },
 CIC_LOCKING = #{qjl.cic_locking,jdbcType =VARCHAR },
 FIC_LOCKING = #{qjl.fic_locking,jdbcType =VARCHAR },
 SIC_LOCKING = #{qjl.sic_locking,jdbcType =VARCHAR },
 PIC_LOCKING = #{qjl.pic_locking,jdbcType =VARCHAR },
 DIC_LOCKING = #{qjl.dic_locking,jdbcType =VARCHAR },
 <if test = " qjl.unlock_name != null ">
 UNLOCK_NAME = #{qjl.unlock_name,jdbcType =VARCHAR },
  </if>
 <if test = " qjl.unlock_name != null ">
 UNLOCK_TIME = sysdate,
  </if>
 <if test = " qjl.reason_code != null ">
 reason_code= #{qjl.reason_code,jdbcType =VARCHAR},
 </if>
 <if test = " qjl.reason_desc != null ">
 reason_desc=   #{qjl.reason_desc,jdbcType =VARCHAR},
 </if>
 flaw_code=   #{qjl.flaw_code,jdbcType =VARCHAR},
 flaw_desc=  #{qjl.flaw_desc,jdbcType =VARCHAR},
 <if test = " qjl.status != null ">
status=  #{qjl.status,jdbcType =VARCHAR},
</if>
<if test = " qjl.check_name != null ">
check_name=  #{qjl.check_name,jdbcType =VARCHAR},
</if>
<if test = " qjl.check_name != null ">
check_time=  sysdate,
</if>
 unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR}
 where 1= 1
and batch_no = #{qjl.batch_no,jdbcType =VARCHAR}
 <if test = " qjl.material_no!= null  " >
and material_no = #{qjl.material_no,jdbcType =VARCHAR}
</if>
<if test = " qjl.lock_id!= null  " >
and lock_id = #{qjl.lock_id,jdbcType =VARCHAR}
</if>
 and unlock_type_code is null
 and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR }
</update>


<update id = "UpdateQcmJudgeLocking6" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set UNLOCK_TYPE_CODE = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 UNLOCK_TYPE_DESC = #{qjl.unlock_type_desc,jdbcType =VARCHAR },
 UNLOCK_MEMO = #{qjl.unlock_memo,jdbcType =VARCHAR },
 TARGET_DESIGN_KEY = #{qjl.target_design_key,jdbcType =VARCHAR },
 TARGET_PSC = #{qjl.target_psc,jdbcType =VARCHAR },
 CIC_LOCKING = #{qjl.cic_locking,jdbcType =VARCHAR },
 FIC_LOCKING = #{qjl.fic_locking,jdbcType =VARCHAR },
 SIC_LOCKING = #{qjl.sic_locking,jdbcType =VARCHAR },
 PIC_LOCKING = #{qjl.pic_locking,jdbcType =VARCHAR },
 DIC_LOCKING = #{qjl.dic_locking,jdbcType =VARCHAR },
 UNLOCK_NAME = #{qjl.unlock_name,jdbcType =VARCHAR },
 UNLOCK_TIME = sysdate,
 reason_code= #{qjl.reason_code,jdbcType =VARCHAR},
 reason_desc=   #{qjl.reason_desc,jdbcType =VARCHAR},
 flaw_code=   #{qjl.flaw_code,jdbcType =VARCHAR},
 flaw_desc=  #{qjl.flaw_desc,jdbcType =VARCHAR},
 unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR}
 where 1= 1
and batch_no = #{qjl.batch_no,jdbcType =VARCHAR}
 <if test = " qjl.material_no!= null  " >
and material_no like #{qjl.material_no,jdbcType =VARCHAR} || '%'
</if>
<if test = " qjl.lock_id!= null  " >
and lock_id = #{qjl.lock_id,jdbcType =VARCHAR}
</if>
 and unlock_type_code is null
 and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR }
</update>

<update id="UpdateQcmJhySampleROrd" parameterType = "QCM.COMMUNAL.VO.QcmJhySampleROrd">

update QCM_JHY_SAMPLE_R_ORD
set CIC_ID = null,
JUDGE_STATUS = '0',
JUDGE_RESULT_CODE = null,
JUDGE_RESULT_DESC = null,
JUDGE_NAME = null,
JUDGE_TIME = null,
JUDGE_MEMO = null
where 1=1
 <if test = " q.smp_no!= null  " >
and smp_no = #{q.smp_no,jdbcType =VARCHAR}
</if>
 <if test = " q.inspection_lot!= null  " >
and inspection_lot = #{q.inspection_lot,jdbcType =VARCHAR}
</if>
and cic_id is not null
</update>

<update id="UpdateQcmJhySampleROrd1" parameterType = "QCM.COMMUNAL.VO.QcmJhySampleROrd">

update QCM_JHY_SAMPLE_R_ORD
set phy_id = null,
JUDGE_STATUS = '0',
JUDGE_RESULT_CODE = null,
JUDGE_RESULT_DESC = null,
JUDGE_NAME = null,
JUDGE_TIME = null,
JUDGE_MEMO = null
where 1=1
 <if test = " q.smp_no!= null  " >
and smp_no = #{q.smp_no,jdbcType =VARCHAR}
</if>
 <if test = " q.inspection_lot!= null  " >
and inspection_lot = #{q.inspection_lot,jdbcType =VARCHAR}
</if>
and phy_id is not null
</update>

<update id="UpdateQcmJudgeSurface" parameterType = "QCM.COMMUNAL.VO.QcmJudgeSurface">
update qcm_judge_surface
set SFU_IS_LOCK = #{q.sfu_is_lock,jdbcType =VARCHAR},
SFD_IS_LOCK = #{q.sfd_is_lock,jdbcType =VARCHAR},
SFE_IS_LOCK = #{q.sfe_is_lock,jdbcType =VARCHAR}
where SURFACE_ID = #{q.surface_id,jdbcType =VARCHAR}
</update>

<update id="UpdateQcmJudgeSurface1" parameterType = "QCM.COMMUNAL.VO.QcmJudgeSurface">
update qcm_judge_surface
set SFU_IS_LOCK = #{q.sfu_is_lock,jdbcType =VARCHAR},
SFD_IS_LOCK = #{q.sfd_is_lock,jdbcType =VARCHAR},
SFE_IS_LOCK = #{q.sfe_is_lock,jdbcType =VARCHAR},
sf_result_code = #{q.sf_result_code,jdbcType =VARCHAR},
sf_result_desc = #{q.sf_result_desc,jdbcType =VARCHAR},
level_code = #{q.level_code,jdbcType =VARCHAR},
level_desc = #{q.level_desc,jdbcType =VARCHAR}
where SURFACE_ID = #{q.surface_id,jdbcType =VARCHAR}
</update>

<update id="UpdateQcmJudgeUltimateByUtmid">
update qcm_judge_ultimate
set <!-- UTM_RESULT_CODE = null,
UTM_RESULT_DESC = null,
UTM_REASON = null,
UTM_MEMO = null,
 -->JUDGE_NAME = null,
JUDGE_TIME = null
where UTM_ID = #{utm_id}
</update>

<update id="clearCHEMRESULT">
update ZJ_RESULT_ALL@xgcx 
set CHEMRESULT_DESC = null,
CHEMRESULT = '0',
CHEMID = null,
CIC_IS_LOCK = '0'
where BILLETID_JY = #{inspection_lot}
</update>

<!-- <update id="updateCHEMRESULT2">
update ZJ_RESULT_ALL@xgcx 
set CHEMRESULT_DESC = #{CHEMRESULT_DESC},
CHEMRESULT = #{CHEMRESULT},
CHEMID = #{CHEMID},
CIC_IS_LOCK = #{CIC_IS_LOCK}
where BILLETID_JY = #{inspection_lot}
</update> -->

<update id="cancelLoad">
update QCM_MAT_CERT_D t
   set t.validflag        = '1',
       t.JUDGERESULT_NAME = #{username},
       t.JUDGERESULT_MEMO = #{remark}
 where t.material_no = #{material_no}
   and t.validflag is null
</update>

<update id="clearCHEMRESULT1">
update QCM_JUDGE_COIL_RESULT 
set CHEMRESULT_DESC = null,
CHEMRESULT = '0',
CHEMID = null,
CIC_IS_LOCK = '0'
where INSPECTION_LOT = #{inspection_lot}
</update>
<update id="clearJUDGERESULT">
update ZJ_RESULT_ALL@xgcx 
set JUDGERESULT = '0',
JUDGERESULT_DESC = null,
JUDGEID = null,
billetid_jy = #{inspection_lot}
where BILLETID = #{material_no}
</update>

<update id="clearJUDGERESULT1">
update QCM_JUDGE_COIL_RESULT
set JUDGERESULT = '0',
JUDGERESULT_DESC = null,
JUDGEID = null,
inspection_lot = #{inspection_lot}
where coil_no = #{material_no}
</update>

<update id="clearJUDGERESULT2">
update QCM_JUDGE_YT_COIL_RESULT
set JUDGERESULT = '0',
JUDGERESULT_DESC = null,
JUDGEID = null,
R_CHEMRESULT = '0',
R_CHEMRESULT_DESC = null,
R_CHEMID = null,
R_CIC_IS_LOCK = '0',
inspection_lot = #{inspection_lot}
where coil_no = #{material_no}
</update>

<!-- <update id="updateCHEMRESULT3">
update QCM_JUDGE_COIL_RESULT 
set CHEMRESULT_DESC = #{CHEMRESULT_DESC},
CHEMRESULT = #{CHEMRESULT},
CHEMID = #{CHEMID},
CIC_IS_LOCK = #{CIC_IS_LOCK}
where INSPECTION_LOT = #{inspection_lot}
</update> -->

<update id="updateCHEMRESULT4">
update ZJ_RESULT_ALL@xgcx
set judgeresult_desc = #{judgeresult},
judgeresult = #{judgeresultid},
judgeid = #{CHEMID}
where BILLETID = #{material_no}
</update>

<update id="updateCHEMRESULT5">
update QCM_JUDGE_COIL_RESULT 
set judgeresult_desc = #{judgeresult},
judgeresult = #{judgeresultid},
judgeid = #{utm_id}
where coil_no = #{material_no}
</update>

<!-- <update id="uptdateSurfaceResult">
update ZJ_RESULT_ALL@xgcx
set surfaceresult  = '1',
surfaceid = #{surface_id},
up_surface_result  = '1',
ud_surface_result  = '1',
marginal_result = '1',
up_surface_result_desc = '合格',
ud_surface_result_desc = '合格',
marginal_result_desc = '合格'
surfaceresult_desc = '合格'
where BILLETID = #{material_no}
</update> -->
<!-- <update id="uptdateSurfaceResult1">
update QCM_JUDGE_COIL_RESULT 
set surfaceresult  = '1',
surfaceid = #{surface_id},
up_surface_result  = '1',
ud_surface_result  = '1',
marginal_result = '1',
up_surface_result_desc = '合格',
ud_surface_result_desc = '合格',
marginal_result_desc = '合格'
surfaceresult_desc = '合格'
where coil_no = #{material_no}
</update> -->
<!-- <update id="uptdateSurfaceResult2">
update ZJ_RESULT_ALL@xgcx
set surfaceresult  = '0',
up_surface_result  = '0',
ud_surface_result  = '0',
marginal_result = '0',
sfu_is_lock = '0',
sfd_is_lock = '0',
sfe_is_lock = '0',
up_surface_result_desc = '待判',
ud_surface_result_desc = '待判',
marginal_result_desc = '待判'
surfaceresult_desc = '待判'
where BILLETID = #{material_no}
</update> -->
<!-- <update id="uptdateSurfaceResult3">
update QCM_JUDGE_COIL_RESULT 
set surfaceresult  = '0',
up_surface_result  = '0',
ud_surface_result  = '0',
marginal_result = '0',
sfu_is_lock = '0',
sfd_is_lock = '0',
sfe_is_lock = '0',
up_surface_result_desc = '待判',
ud_surface_result_desc = '待判',
marginal_result_desc = '待判'
surfaceresult_desc = '待判'
where coil_no = #{material_no}
</update> -->

<!-- <update id="UpdateSurfaceResults">
update ZJ_RESULT_ALL@xgcx
set surfaceresult  = #{is_pass},
surfaceid = #{sid},
up_surface_result  = case when #{is_sfu_lock} = '0' then '1' else '2' end,
ud_surface_result  = case when #{is_sfd_lock} = '0' then '1' else '2' end,
marginal_result = case when #{is_sfe_lock} = '0' then '1' else '2' end,
sfu_is_lock = #{is_sfu_lock},
sfd_is_lock = #{is_sfd_lock},
sfe_is_lock = #{is_sfe_lock},
up_surface_result_desc = case when #{is_sfu_lock} = '0' then '合格' else '不合格' end,
ud_surface_result_desc = case when #{is_sfd_lock} = '0' then '合格' else '不合格' end,
marginal_result_desc = case when #{is_sfe_lock} = '0' then '合格' else '不合格' end,
surfaceresult_desc = case when #{is_pass} = '1' then '合格' else '不合格' end
where BILLETID = #{material_no}
</update> -->

<!-- <update id="UpdateSurfaceResultss">
update QCM_JUDGE_COIL_RESULT
set surfaceresult  = #{is_pass},
surfaceid = #{sid},
up_surface_result  = case when #{is_sfu_lock} = '0' then '1' else '2' end,
ud_surface_result  = case when #{is_sfd_lock} = '0' then '1' else '2' end,
marginal_result = case when #{is_sfe_lock} = '0' then '1' else '2' end,
sfu_is_lock = #{is_sfu_lock},
sfd_is_lock = #{is_sfd_lock},
sfe_is_lock = #{is_sfe_lock},
up_surface_result_desc = case when #{is_sfu_lock} = '0' then '合格' else '不合格' end,
ud_surface_result_desc = case when #{is_sfd_lock} = '0' then '合格' else '不合格' end,
marginal_result_desc = case when #{is_sfe_lock} = '0' then '合格' else '不合格' end,
surfaceresult_desc = case when #{is_pass} = '1' then '合格' else '不合格' end
where coil_no = #{material_no}
</update> -->










<insert id="insertSampleM" parameterType = "QCM.JHY01.VO.JhySampleMMdoel">
	insert into QCM_JHY_SAMPLE_CONSIGN_M 
	      <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
              <if test = " q.smp_no!= null  " >smp_no,</if>
			  <if test = " q.heat_no!= null  " >heat_no,</if>
			  <if test = " q.batch_no!= null  " >batch_no,</if>
			  <if test = " q.inspection_lot!= null  " >inspection_lot,</if>
			  <if test = " q.board_no!= null  " >board_no,</if>
			  <if test = " q.material_no!= null  " >material_no,</if>
			  <if test = " q.smp_catg!= null  " >smp_catg,</if>
			  
			  <if test = " q.psc!= null  " >psc,</if>
			  <if test = " q.psc_desc!= null  " >psc_desc,</if>
			  <if test = " q.cert_inst_code!= null  " >cert_inst_code,</if>
			  <if test = " q.cert_inst_name!= null  " >cert_inst_name,</if>
			  <if test = " q.smp_type_code!= null  " >smp_type_code,</if>
			  <if test = " q.smp_type_name!= null  " >smp_type_name,</if>
			  
			  <if test = " q.grade_code!= null  " >grade_code,</if>
			  <if test = " q.grade_name!= null  " >grade_name,</if>
			  <if test = " q.pline_code!= null  " >pline_code,</if>
			  <if test = " q.pline_name!= null  " >pline_name,</if>
			  <if test = " q.validflag!= null  " >validflag,</if>
			  <if test = " q.memo!= null  " >memo,</if>
			  
			  <if test = " q.create_id!= null  " >create_id,</if>
			  <if test = " q.create_name!= null  " >create_name,</if>
			  <if test = " q.create_time!= null  " >create_time,</if>
			  
			  <if test = " q.item_flag!= null  " >item_flag,</if>
			 
       </trim>
       
       values
       
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">			  
			  <if test = " q.smp_no!= null  " >#{q.smp_no,jdbcType =VARCHAR},</if>
			  <if test = " q.heat_no!= null  " >#{q.heat_no,jdbcType =VARCHAR},</if>
			  <if test = " q.batch_no!= null  " >#{q.batch_no,jdbcType =VARCHAR},</if>
			  <if test = " q.inspection_lot!= null  " >#{q.inspection_lot,jdbcType =VARCHAR},</if>
			  <if test = " q.board_no!= null  " >#{q.board_no,jdbcType =VARCHAR},</if>
			  <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
			  <if test = " q.smp_catg!= null  " >#{q.smp_catg,jdbcType =VARCHAR},</if>
			  
			  <if test = " q.psc!= null  " >#{q.psc,jdbcType =VARCHAR},</if>
			  <if test = " q.psc_desc!= null  " >#{q.psc_desc,jdbcType =VARCHAR},</if>
			  <if test = " q.cert_inst_code!= null  " >#{q.cert_inst_code,jdbcType =VARCHAR},</if>
			  <if test = " q.cert_inst_name!= null  " >#{q.cert_inst_name,jdbcType =VARCHAR},</if>
			  <if test = " q.smp_type_code!= null  " >#{q.smp_type_code,jdbcType =VARCHAR},</if>
			  <if test = " q.smp_type_name!= null  " >#{q.smp_type_name,jdbcType =VARCHAR},</if>
			  
			  <if test = " q.grade_code!= null  " >#{q.grade_code,jdbcType =VARCHAR},</if>
			  <if test = " q.grade_name!= null  " >#{q.grade_name,jdbcType =VARCHAR},</if>
			  <if test = " q.pline_code!= null  " >#{q.pline_code,jdbcType =VARCHAR},</if>
			  <if test = " q.pline_name!= null  " >#{q.pline_name,jdbcType =VARCHAR},</if>
			  <if test = " q.validflag!= null  " >#{q.validflag,jdbcType =VARCHAR},</if>
			  <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
			  
			  <if test = " q.create_id!= null  " >#{q.create_id,jdbcType =VARCHAR},</if>
			  <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
			  <if test = " q.create_time!= null  " >#{q.create_time,jdbcType =TIMESTAMP},</if>
			 
			 <if test = " q.item_flag!= null  " >#{q.item_flag,jdbcType =VARCHAR},</if>
			  
       </trim>
	
       
</insert>



<insert id="insertSampleD" parameterType = "QCM.JHY01.VO.JhySampleDModel">
	insert into QCM_JHY_SAMPLE_CONSIGN_D 
	      <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
	
              <if test = " q.smp_no!= null  " >smp_no,</if>
              <if test = " q.specimen_no!= null  " >specimen_no,</if>
			  <if test = " q.heat_no!= null  " >heat_no,</if>
			  <if test = " q.batch_no!= null  " >batch_no,</if>
			  <if test = " q.inspection_lot!= null  " >inspection_lot,</if>
			  <if test = " q.board_no!= null  " >board_no,</if>
			  <if test = " q.material_no!= null  " >material_no,</if>
			  <if test = " q.freq_code!= null  " >freq_code,</if>
			  <if test = " q.freq_name!= null  " >freq_name,</if>
			  <if test = " q.smp_type_code!= null  " >smp_type_code,</if>
			  <if test = " q.smp_type_name!= null  " >smp_type_name,</if>
			  <if test = " q.consign_no!= null  " >consign_no,</if>
			  <if test = " q.consign_no_seq!= null  " >consign_no_seq,</if>
			  <if test = " q.test_qty!= null  " >test_qty,</if>
			  <if test = " q.smp_qty!= null  " >smp_qty,</if>
			  <if test = " q.smp_location!= null  " >smp_location,</if>
			  <if test = " q.quote_consign_no!= null  " >quote_consign_no,</if>
			  <if test = " q.old_consign_no!= null  " >old_consign_no,</if>
			  <if test = " q.pline_code!= null  " >pline_code,</if>
			  <if test = " q.pline_name!= null  " >pline_name,</if>
			  <if test = " q.status!= null  " >status,</if>
			  <if test = " q.validflag!= null  " >validflag,</if>
			  <if test = " q.source!= null  " >source,</if>
			  <if test = " q.guid!= null  " >guid,</if>
			  <if test = " q.send_id!= null  " >send_id,</if>
			  <if test = " q.send_name!= null  " >send_name,</if>
			  <if test = " q.send_time!= null  " >send_time,</if>
			  <if test = " q.chem_item!= null  " >chem_item,</if>
			  <if test = " q.product_cnt!= null  " >product_cnt,</if>
			  <if test = " q.create_time!= null  " >create_time,</if>
	          <if test = " q.smp_location_code!= null  " >smp_location_code,</if>
	          <if test = " q.memo!= null  " >memo,</if>
              <if test = " q.weight!= null  " >weight,</if>
	          <if test = " q.weight_std!= null  " >weight_std,</if>
	          <if test = " q.weight_sfd!= null  " >weight_sfd,</if>
  
			 <if test = " q.item_flag!= null  " >item_flag,</if>
			 <if test = " q.send_memo!= null  " >send_memo,</if>
			 <if test = " q.improve_memo!= null  " >improve_memo,</if>
			 <if test = " q.process_no!= null  " >process_no,</if>
			 <if test = " q.process_nos!= null  " >process_nos,</if>
			 <if test = " q.artificial_memo!= null  " >artificial_memo,</if>
			   <if test = " q.process_code!= null  " >process_code,</if>
       </trim>
       
       values
       
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">	
       
              <if test = " q.smp_no!= null  " >#{q.smp_no,jdbcType =VARCHAR},</if>
              <if test = " q.specimen_no!= null  " >#{q.specimen_no,jdbcType =VARCHAR},</if>
			  <if test = " q.heat_no!= null  " >#{q.heat_no,jdbcType =VARCHAR},</if>
			  <if test = " q.batch_no!= null  " >#{q.batch_no,jdbcType =VARCHAR},</if>
			  <if test = " q.inspection_lot!= null  " >#{q.inspection_lot,jdbcType =VARCHAR},</if>
			  <if test = " q.board_no!= null  " >#{q.board_no,jdbcType =VARCHAR},</if>
			  <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
			  <if test = " q.freq_code!= null  " >#{q.freq_code,jdbcType =VARCHAR},</if>
			  <if test = " q.freq_name!= null  " >#{q.freq_name,jdbcType =VARCHAR},</if>
			  <if test = " q.smp_type_code!= null  " >#{q.smp_type_code,jdbcType =VARCHAR},</if>
			  <if test = " q.smp_type_name!= null  " >#{q.smp_type_name,jdbcType =VARCHAR},</if>
			  <if test = " q.consign_no!= null  " >#{q.consign_no,jdbcType =VARCHAR},</if>
			  <if test = " q.consign_no_seq!= null  " >#{q.consign_no_seq,jdbcType =INTEGER},</if>
			  <if test = " q.test_qty!= null  " >#{q.test_qty,jdbcType =DECIMAL},</if>
			  <if test = " q.smp_qty!= null  " >#{q.smp_qty,jdbcType= DECIMAL},</if>
			  <if test = " q.smp_location!= null  " >#{q.smp_location,jdbcType =VARCHAR},</if>
			  <if test = " q.quote_consign_no!= null  " >#{q.quote_consign_no,jdbcType =VARCHAR},</if>
			  <if test = " q.old_consign_no!= null  " >#{q.old_consign_no,jdbcType =VARCHAR},</if>
			  <if test = " q.pline_code!= null  " >#{q.pline_code,jdbcType =VARCHAR},</if>
			  <if test = " q.pline_name!= null  " >#{q.pline_name,jdbcType =VARCHAR},</if>
			  <if test = " q.status!= null  " >#{q.status,jdbcType =VARCHAR},</if>
			  <if test = " q.validflag!= null  " >#{q.validflag,jdbcType =VARCHAR},</if>
			  <if test = " q.source!= null  " >#{q.source,jdbcType =VARCHAR},</if>
			  <if test = " q.guid!= null  " >#{q.guid,jdbcType =VARCHAR},</if>
			  <if test = " q.send_id!= null  " >#{q.send_id,jdbcType =VARCHAR},</if>
			  <if test = " q.send_name!= null  " >#{q.send_name,jdbcType =VARCHAR},</if>
			  <if test = " q.send_time!= null  " >sysdate,</if>
			  <if test = " q.chem_item!= null  " >#{q.chem_item,jdbcType =VARCHAR},</if>
			  <if test = " q.product_cnt!= null  " >#{q.product_cnt,jdbcType =VARCHAR},</if>
			  <if test = " q.create_time!= null  " >#{q.create_time,jdbcType =TIMESTAMP},</if>
			  <if test = " q.smp_location_code!= null  " >#{q.smp_location_code,jdbcType =VARCHAR},</if>
			  <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
			  <if test = " q.weight!= null  " >#{q.weight,jdbcType =VARCHAR},</if>
			  <if test = " q.weight_std!= null  " >#{q.weight_std,jdbcType =VARCHAR},</if>
			  <if test = " q.weight_sfd!= null  " >#{q.weight_sfd,jdbcType =VARCHAR},</if>
			  <if test = " q.item_flag!= null  " >#{q.item_flag,jdbcType =VARCHAR},</if>
			  <if test = " q.send_memo!= null  " >#{q.send_memo,jdbcType =VARCHAR},</if>
			  <if test = " q.improve_memo!= null  " >#{q.improve_memo,jdbcType =VARCHAR},</if>
			  <if test = " q.process_no!= null  " >#{q.process_no,jdbcType =VARCHAR},</if>
			  <if test = " q.process_nos!= null  " >#{q.process_nos,jdbcType =VARCHAR},</if>
			  <if test = " q.artificial_memo!= null  " >#{q.artificial_memo,jdbcType =VARCHAR},</if>
			   <if test = " q.process_code!= null  " >#{q.process_code,jdbcType =VARCHAR},</if>
       </trim>
	
       
</insert>



<insert id="insertSampleItem" parameterType = "QCM.JHY01.VO.JhySampleDItemModel">
	insert into QCM_JHY_SAMPLE_CONSIGN_D_ITEM 
	      <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
	      
              <if test = " q.specimen_no!= null  " >specimen_no,</if>
		      <if test = " q.seq!= null  " >seq,</if>
		      <if test = " q.smp_no!= null  " >smp_no,</if>
		      <if test = " q.phy_name_l!= null  " >phy_name_l,</if>
		      <if test = " q.phy_code_l!= null  " >phy_code_l,</if>
		      <if test = " q.phy_code_m!= null  " >phy_code_m,</if>
		      <if test = " q.phy_name_m!= null  " >phy_name_m,</if>
		      <if test = " q.phy_code_s!= null  " >phy_code_s,</if>
		      <if test = " q.phy_name_s!= null  " >phy_name_s,</if>
		      <if test = " q.item_code_d!= null  " >item_code_d,</if>
		      <if test = " q.item_name_d!= null  " >item_name_d,</if>
		      <if test = " q.item_code_t!= null  " >item_code_t,</if>
		      <if test = " q.item_name_t!= null  " >item_name_t,</if>
		      <if test = " q.item_code_s!= null  " >item_code_s,</if>
		      <if test = " q.item_name_s!= null  " >item_name_s,</if>
		      <if test = " q.isjudge!= null  " >isjudge,</if>
		      <if test = " q.judge_basis!= null  " >judge_basis,</if>
		      <if test = " q.phy_unit!= null  " >phy_unit,</if>
		      <if test = " q.group_seq!= null  " >group_seq,</if>
		      <if test = " q.quote_specimen_no!= null  " >quote_specimen_no,</if>
		      <if test = " q.quote_seq!= null  " >quote_seq,</if>
		      <if test = " q.memo!= null  " >memo,</if>
		      <if test = " q.item_code_l!= null  " >item_code_l,</if>
		      <if test = " q.item_desc_l!= null  " >item_desc_l,</if>
		      <if test = " q.test_qty!= null  " >test_qty,</if>
		      <if test = " q.smp_qty!= null  " >smp_qty,</if>
		      <if test = " q.create_time!= null  " >create_time,</if>
		      <if test = " q.create_id!= null  " >create_id,</if>
		      <if test = " q.create_name!= null  " >create_name,</if>
		      <if test = " q.specl_fl!= null  " >specl_fl,</if>
		      <if test = " q.item_flag!= null  " >item_flag,</if>
		      
		      <if test = " q.stdmemo!= null  " >stdmemo,</if>
		      <if test = " q.stdmin_sign!= null  " >stdmin_sign,</if>
		      <if test = " q.stdmin!= null  " >stdmin,</if>
		      <if test = " q.stdmax_sign!= null  " >stdmax_sign,</if>
              <if test = " q.stdmax!= null  " >stdmax,</if>
              <if test = " q.phy_group_code!= null  " >phy_group_code,</if>
              <if test = " q.resmp_seq!= null  " >resmp_seq</if> 
			 
       </trim>
       
       values
       
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">	
        
        	  <if test = " q.specimen_no!= null  " >#{q.specimen_no,jdbcType =VARCHAR},</if>
		      <if test = " q.seq!= null  " >#{q.seq,jdbcType =INTEGER},</if>
		      <if test = " q.smp_no!= null  " >#{q.smp_no,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_name_l!= null  " >#{q.phy_name_l,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_code_l!= null  " >#{q.phy_code_l,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_code_m!= null  " >#{q.phy_code_m,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_name_m!= null  " >#{q.phy_name_m,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_code_s!= null  " >#{q.phy_code_s,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_name_s!= null  " >#{q.phy_name_s,jdbcType =VARCHAR},</if>
		      <if test = " q.item_code_d!= null  " >#{q.item_code_d,jdbcType =VARCHAR},</if>
		      <if test = " q.item_name_d!= null  " >#{q.item_name_d,jdbcType =VARCHAR},</if>
		      <if test = " q.item_code_t!= null  " >#{q.item_code_t,jdbcType =VARCHAR},</if>
		      <if test = " q.item_name_t!= null  " >#{q.item_name_t,jdbcType =VARCHAR},</if>
		      <if test = " q.item_code_s!= null  " >#{q.item_code_s,jdbcType =VARCHAR},</if>
		      <if test = " q.item_name_s!= null  " >#{q.item_name_s,jdbcType =VARCHAR},</if>
		      <if test = " q.isjudge!= null  " >#{q.isjudge,jdbcType =VARCHAR},</if>
		      <if test = " q.judge_basis!= null  " >#{q.judge_basis,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_unit!= null  " >#{q.phy_unit,jdbcType =VARCHAR},</if>
		      <if test = " q.group_seq!= null  " >#{q.group_seq,jdbcType =VARCHAR},</if>
		      <if test = " q.quote_specimen_no!= null  " >#{q.quote_specimen_no,jdbcType =VARCHAR},</if>
		      <if test = " q.quote_seq!= null  " >#{q.quote_seq,jdbcType =INTEGER},</if>
		      <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
		      <if test = " q.item_code_l!= null  " >#{q.item_code_l,jdbcType =VARCHAR},</if>
		      <if test = " q.item_desc_l!= null  " >#{q.item_desc_l,jdbcType =VARCHAR},</if>
		      <if test = " q.test_qty!= null  " >#{q.test_qty,jdbcType = DECIMAL},</if>
		      <if test = " q.smp_qty!= null  " >#{q.smp_qty,jdbcType= DECIMAL},</if>
		      <if test = " q.create_time!= null  " >#{q.create_time,jdbcType =TIMESTAMP},</if>
		      <if test = " q.create_id!= null  " >#{q.create_id,jdbcType =VARCHAR},</if>
		      <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
		      <if test = " q.specl_fl!= null  " >#{q.specl_fl,jdbcType =VARCHAR},</if>
              <if test = " q.item_flag!= null  " >#{q.item_flag,jdbcType =VARCHAR},</if>
              
              <if test = " q.stdmemo!= null  " >#{q.stdmemo,jdbcType =VARCHAR},</if>
              <if test = " q.stdmin_sign!= null  " >#{q.stdmin_sign,jdbcType =VARCHAR},</if>
		      <if test = " q.stdmin!= null  " >#{q.stdmin,jdbcType =VARCHAR},</if>
		      <if test = " q.stdmax_sign!= null  " >#{q.stdmax_sign,jdbcType =VARCHAR},</if>
              <if test = " q.stdmax!= null  " >#{q.stdmax,jdbcType =VARCHAR},</if>
              <if test = " q.phy_group_code!= null  " >#{q.phy_group_code,jdbcType =VARCHAR},</if>
              <if test = " q.resmp_seq!= null  " >#{q.resmp_seq,jdbcType =VARCHAR},</if>
       </trim>
	
       
</insert>




<insert id="insertSampleOrd" parameterType = "QCM.JHY01.VO.JhySampleOrdMdoel">
	insert into QCM_JHY_SAMPLE_R_ORD 
	      <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
	          <if test = " q.design_key!= null  " >design_key,</if>
		      <if test = " q.smp_no!= null  " >smp_no,</if>
		      <if test = " q.psc!= null  " >psc,</if>
		      <if test = " q.psc_desc!= null  " >psc_desc,</if>
		      <if test = " q.heat_no!= null  " >heat_no,</if>
		      <if test = " q.batch_no!= null  " >batch_no,</if>
		      <if test = " q.inspection_lot!= null  " >inspection_lot,</if>
		      <if test = " q.delivery_state_code!= null  " >delivery_state_code,</if>
		      <if test = " q.delivery_state_desc!= null  " >delivery_state_desc,</if>
		      <if test = " q.thick!= null  " >thick,</if>
		      <if test = " q.width!= null  " >width,</if>
		      <if test = " q.length!= null  " >length,</if>
		      <if test = " q.pline_code!= null  " >pline_code,</if>
		      <if test = " q.pline_name!= null  " >pline_name,</if>
		      <if test = " q.msc_pline!= null  " >msc_pline,</if>
		      <if test = " q.process_code!= null  " >process_code,</if>
		      <if test = " q.cert_inst_code!= null  " >cert_inst_code,</if>
		      <if test = " q.cert_inst_name!= null  " >cert_inst_name,</if>
		      <if test = " q.smp_type_code!= null  " >smp_type_code,</if>
		      <if test = " q.smp_type_name!= null  " >smp_type_name,</if>
		      <if test = " q.smelting_cnt!= null  " >smelting_cnt,</if>
		      <if test = " q.product_cnt!= null  " >product_cnt,</if>
		      <if test = " q.assay_no_cp!= null  " >assay_no_cp,</if>
		      <if test = " q.assay_no_rl!= null  " >assay_no_rl,</if>
		      <if test = " q.cic_id!= null  " >cic_id,</if>
		      <if test = " q.phy_id!= null  " >phy_id,</if>
		      <if test = " q.judge_status!= null  " >judge_status,</if>
		      <if test = " q.judge_result_code!= null  " >judge_result_code,</if>
		      <if test = " q.judge_result_desc!= null  " >judge_result_desc,</if>
		      <if test = " q.judge_name!= null  " >judge_name,</if>
		      <if test = " q.judge_time!= null  " >judge_time,</if>
		      <if test = " q.judge_memo!= null  " >judge_memo,</if>
		      <if test = " q.prod_code!= null  " >prod_code,</if>
		      <if test = " q.prod_name!= null  " >prod_name,</if>
		      <if test = " q.steel_code!= null  " >steel_code,</if>
		      <if test = " q.steel_name!= null  " >steel_name,</if>
		      <if test = " q.std_code!= null  " >std_code,</if>
		      <if test = " q.std_name!= null  " >std_name,</if>
		      <if test = " q.create_time!= null  " >create_time,</if>
		      <if test = " q.create_id!= null  " >create_id,</if>
		      <if test = " q.create_name!= null  " >create_name,</if>
		      <if test = " q.item_flag!= null  " >item_flag,</if>
	          <if test = " q.improve_memo!= null  " >improve_memo,</if>
       </trim>
       
       values
       
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">	
        
              <if test = " q.design_key!= null  " >#{q.design_key,jdbcType =VARCHAR},</if>
		      <if test = " q.smp_no!= null  " >#{q.smp_no,jdbcType =VARCHAR},</if>
		      <if test = " q.psc!= null  " >#{q.psc,jdbcType =VARCHAR},</if>
		      <if test = " q.psc_desc!= null  " >#{q.psc_desc,jdbcType =VARCHAR},</if>
		      <if test = " q.heat_no!= null  " >#{q.heat_no,jdbcType =VARCHAR},</if>
		      <if test = " q.batch_no!= null  " >#{q.batch_no,jdbcType =VARCHAR},</if>
		      <if test = " q.inspection_lot!= null  " >#{q.inspection_lot,jdbcType =VARCHAR},</if>
		      <if test = " q.delivery_state_code!= null  " >#{q.delivery_state_code,jdbcType =VARCHAR},</if>
		      <if test = " q.delivery_state_desc!= null  " >#{q.delivery_state_desc,jdbcType =VARCHAR},</if>
		      <if test = " q.thick!= null  " >#{q.thick,jdbcType =VARCHAR},</if>
		      <if test = " q.width!= null  " >#{q.width,jdbcType =VARCHAR},</if>
		      <if test = " q.length!= null  " >#{q.length,jdbcType =VARCHAR},</if>
		      <if test = " q.pline_code!= null  " >#{q.pline_code,jdbcType =VARCHAR},</if>
		      <if test = " q.pline_name!= null  " >#{q.pline_name,jdbcType =VARCHAR},</if>
		      <if test = " q.msc_pline!= null  " >#{q.msc_pline,jdbcType =VARCHAR},</if>
		      <if test = " q.process_code!= null  " >#{q.process_code,jdbcType =VARCHAR},</if>
		      <if test = " q.cert_inst_code!= null  " >#{q.cert_inst_code,jdbcType =VARCHAR},</if>
		      <if test = " q.cert_inst_name!= null  " >#{q.cert_inst_name,jdbcType =VARCHAR},</if>
		      <if test = " q.smp_type_code!= null  " >#{q.smp_type_code,jdbcType =VARCHAR},</if>
		      <if test = " q.smp_type_name!= null  " >#{q.smp_type_name,jdbcType =VARCHAR},</if>
		      <if test = " q.smelting_cnt!= null  " >#{q.smelting_cnt,jdbcType =DECIMAL},</if>
		      <if test = " q.product_cnt!= null  " >#{q.product_cnt,jdbcType =DECIMAL},</if>
		      <if test = " q.assay_no_cp!= null  " >#{q.assay_no_cp,jdbcType =VARCHAR},</if>
		      <if test = " q.assay_no_rl!= null  " >#{q.assay_no_rl,jdbcType =VARCHAR},</if>
		      <if test = " q.cic_id!= null  " >#{q.cic_id,jdbcType =VARCHAR},</if>
		      <if test = " q.phy_id!= null  " >#{q.phy_id,jdbcType =VARCHAR},</if>
		      <if test = " q.judge_status!= null  " >#{q.judge_status,jdbcType =VARCHAR},</if>
		      <if test = " q.judge_result_code!= null  " >#{q.judge_result_code,jdbcType =VARCHAR},</if>
		      <if test = " q.judge_result_desc!= null  " >#{q.judge_result_desc,jdbcType =VARCHAR},</if>
		      <if test = " q.judge_name!= null  " >#{q.judge_name,jdbcType =VARCHAR},</if>
		      <if test = " q.judge_time!= null  " >#{q.judge_time,jdbcType =TIMESTAMP},</if>
		      <if test = " q.judge_memo!= null  " >#{q.judge_memo,jdbcType =VARCHAR},</if>
		      <if test = " q.prod_code!= null  " >#{q.prod_code,jdbcType =VARCHAR},</if>
		      <if test = " q.prod_name!= null  " >#{q.prod_name,jdbcType =VARCHAR},</if>
		      <if test = " q.steel_code!= null  " >#{q.steel_code,jdbcType =VARCHAR},</if>
		      <if test = " q.steel_name!= null  " >#{q.steel_name,jdbcType =VARCHAR},</if>
		      <if test = " q.std_code!= null  " >#{q.std_code,jdbcType =VARCHAR},</if>
		      <if test = " q.std_name!= null  " >#{q.std_name,jdbcType =VARCHAR},</if>
		      <if test = " q.create_time!= null  " >#{q.create_time,jdbcType =TIMESTAMP},</if>
		      <if test = " q.create_id!= null  " >#{q.create_id,jdbcType =VARCHAR},</if>
		      <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
		       <if test = " q.item_flag!= null  " >#{q.item_flag,jdbcType =VARCHAR},</if>
		       <if test = " q.improve_memo!= null  " >#{q.improve_memo,jdbcType =VARCHAR},</if>
        
       </trim>
	
       
</insert>


<insert id="insertPhyResults" parameterType = "QCM.JHY01.VO.QcmJhyPhyresult">
	insert into QCM_JHY_INSP_PHYSICS 
	      <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
	      
             <if test = " q.specimen_no!= null  " >specimen_no,</if>
		     <if test = " q.seq!= null  " >seq,</if>
		     <if test = " q.test_qty!= null  " >test_qty,</if>
		     <if test = " q.phy_code_l!= null  " >phy_code_l,</if>
		     <if test = " q.phy_name_l!= null  " >phy_name_l,</if>
		     <if test = " q.phy_code_m!= null  " >phy_code_m,</if>
		     <if test = " q.phy_name_m!= null  " >phy_name_m,</if>
		     <if test = " q.phy_code_s!= null  " >phy_code_s,</if>
		     <if test = " q.phy_name_s!= null  " >phy_name_s,</if>
		     <if test = " q.item_code_d!= null  " >item_code_d,</if>
		     <if test = " q.item_name_d!= null  " >item_name_d,</if>
		     <if test = " q.item_code_t!= null  " >item_code_t,</if>
		     <if test = " q.item_name_t!= null  " >item_name_t,</if>
		     <if test = " q.item_code_s!= null  " >item_code_s,</if>
		     <if test = " q.item_name_s!= null  " >item_name_s,</if>
		     <if test = " q.val1!= null  " >val1,</if>
		     <if test = " q.val2!= null  " >val2,</if>
		     <if test = " q.val3!= null  " >val3,</if>
		     <if test = " q.val4!= null  " >val4,</if>
		     <if test = " q.val5!= null  " >val5,</if>
		     <if test = " q.val6!= null  " >val6,</if>
		     <if test = " q.val7!= null  " >val7,</if>
		     <if test = " q.val8!= null  " >val8,</if>
		     <if test = " q.val9!= null  " >val9,</if>
		     <if test = " q.val10!= null  " >val10,</if>
		     <if test = " q.val11!= null  " >val11,</if>
		     <if test = " q.val12!= null  " >val12,</if>
		     <if test = " q.val13!= null  " >val13,</if>
		     <if test = " q.val14!= null  " >val14,</if>
		     <if test = " q.val15!= null  " >val15,</if>
		     <if test = " q.avg_val!= null  " >avg_val,</if>
		     <!-- <if test = " q.guid!= null  " >guid,</if> -->
		     <if test = " q.create_name!= null  " >create_name,</if>
		     <if test = " q.create_time!= null  " >create_time,</if>
		     <if test = " q.group_seq!= null  " >group_seq,</if>
		     <if test = " q.defect_flag!= null  " >defect_flag,</if>
		     <if test = " q.max_val!= null  " >max_val,</if>
		     <if test = " q.min_val!= null  " >min_val,</if>
		     <if test = " q.item_code_l!= null  " >item_code_l,</if>
		     <if test = " q.item_desc_l!= null  " >item_desc_l,</if>
		     <if test = " q.phy_unit!= null  " >phy_unit,</if>
		     <if test = " q.memo!= null  " >memo,</if>
			 
       </trim>
       
       values
       
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">	
        
			 <if test = " q.specimen_no!= null  " >#{q.specimen_no,jdbcType =VARCHAR},</if>
		     <if test = " q.seq!= null  " >#{q.seq,jdbcType =INTEGER},</if>
		     <if test = " q.test_qty!= null  " >#{q.test_qty,jdbcType =DECIMAL},</if>
		     <if test = " q.phy_code_l!= null  " >#{q.phy_code_l,jdbcType =VARCHAR},</if>
		     <if test = " q.phy_name_l!= null  " >#{q.phy_name_l,jdbcType =VARCHAR},</if>
		     <if test = " q.phy_code_m!= null  " >#{q.phy_code_m,jdbcType =VARCHAR},</if>
		     <if test = " q.phy_name_m!= null  " >#{q.phy_name_m,jdbcType =VARCHAR},</if>
		     <if test = " q.phy_code_s!= null  " >#{q.phy_code_s,jdbcType =VARCHAR},</if>
		     <if test = " q.phy_name_s!= null  " >#{q.phy_name_s,jdbcType =VARCHAR},</if>
		     <if test = " q.item_code_d!= null  " >#{q.item_code_d,jdbcType =VARCHAR},</if>
		     <if test = " q.item_name_d!= null  " >#{q.item_name_d,jdbcType =VARCHAR},</if>
		     <if test = " q.item_code_t!= null  " >#{q.item_code_t,jdbcType =VARCHAR},</if>
		     <if test = " q.item_name_t!= null  " >#{q.item_name_t,jdbcType =VARCHAR},</if>
		     <if test = " q.item_code_s!= null  " >#{q.item_code_s,jdbcType =VARCHAR},</if>
		     <if test = " q.item_name_s!= null  " >#{q.item_name_s,jdbcType =VARCHAR},</if>
		     <if test = " q.val1!= null  " >#{q.val1,jdbcType =VARCHAR},</if>
		     <if test = " q.val2!= null  " >#{q.val2,jdbcType =VARCHAR},</if>
		     <if test = " q.val3!= null  " >#{q.val3,jdbcType =VARCHAR},</if>
		     <if test = " q.val4!= null  " >#{q.val4,jdbcType =VARCHAR},</if>
		     <if test = " q.val5!= null  " >#{q.val5,jdbcType =VARCHAR},</if>
		     <if test = " q.val6!= null  " >#{q.val6,jdbcType =VARCHAR},</if>
		     <if test = " q.val7!= null  " >#{q.val7,jdbcType =VARCHAR},</if>
		     <if test = " q.val8!= null  " >#{q.val8,jdbcType =VARCHAR},</if>
		     <if test = " q.val9!= null  " >#{q.val9,jdbcType =VARCHAR},</if>
		     <if test = " q.val10!= null  " >#{q.val10,jdbcType =VARCHAR},</if>
		     <if test = " q.val11!= null  " >#{q.val11,jdbcType =VARCHAR},</if>
		     <if test = " q.val12!= null  " >#{q.val12,jdbcType =VARCHAR},</if>
		     <if test = " q.val13!= null  " >#{q.val13,jdbcType =VARCHAR},</if>
		     <if test = " q.val14!= null  " >#{q.val14,jdbcType =VARCHAR},</if>
		     <if test = " q.val15!= null  " >#{q.val15,jdbcType =VARCHAR},</if>
		     <if test = " q.avg_val!= null  " >#{q.avg_val,jdbcType =VARCHAR},</if>
		     <!-- <if test = " q.guid!= null  " >#{q.guid,jdbcType =VARCHAR},</if> -->
		     <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
		     <if test = " q.create_time!= null  " >#{q.create_time,jdbcType =TIMESTAMP},</if>
		     <if test = " q.group_seq!= null  " >#{q.group_seq,jdbcType =VARCHAR},</if>
		     <if test = " q.defect_flag!= null  " >#{q.defect_flag,jdbcType =VARCHAR},</if>
		     <if test = " q.max_val!= null  " >#{q.max_val,jdbcType =VARCHAR},</if>
		     <if test = " q.min_val!= null  " >#{q.min_val,jdbcType =VARCHAR},</if>
		     <if test = " q.item_code_l!= null  " >#{q.item_code_l,jdbcType =VARCHAR},</if>
		     <if test = " q.item_desc_l!= null  " >#{q.item_desc_l,jdbcType =VARCHAR},</if>
		     <if test = " q.phy_unit!= null  " >#{q.phy_unit,jdbcType =VARCHAR},</if>
		     <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
       </trim>
	
       
</insert>

<insert id = "insertQcmJudgeUltimateSendinfo" parameterType = "QCM.COMMUNAL.VO.QcmJudgeUltimateSendinfo">
insert into QCM_JUDGE_ULTIMATE_SENDINFO
 <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.guid!= null  " >guid,</if>
  <if test = " q.material_no!= null  " >material_no,</if>
  <if test = " q.design_key!= null  " >design_key,</if>
  <if test = " q.send_flag!= null  " >send_flag,</if>
  <if test = " q.result_type!= null  " >result_type,</if>
  <if test = " q.judge_id!= null  " >judge_id,</if>
  <if test = " q.memo!= null  " >memo,</if>
  <if test = " q.create_id!= null  " >create_id,</if>
  <if test = " q.create_name!= null  " >create_name,</if>
  <if test = " q.create_name!= null  " >create_time,</if>
  <!-- <if test = " q.json_text!= null">json_text,</if> -->
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " q.guid!= null  " >#{q.guid,jdbcType =VARCHAR},</if>
  <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
  <if test = " q.design_key!= null  " >#{q.design_key,jdbcType =VARCHAR},</if>
  <if test = " q.send_flag!= null  " >#{q.send_flag,jdbcType =VARCHAR},</if>
  <if test = " q.result_type!= null  " >#{q.result_type,jdbcType =VARCHAR},</if>
  <if test = " q.judge_id!= null  " >#{q.judge_id,jdbcType =VARCHAR},</if>
  <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
  <if test = " q.create_id!= null  " >#{q.create_id,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >sysdate,</if>
  <!-- <if test = " q.json_text!= null">#{q.json_text,jdbcType =VARCHAR},</if> -->
       </trim>
</insert>

<insert id = "insertQcmJudgeLog" parameterType = "QCM.COMMUNAL.VO.QcmJudgeLog">
insert into QCM_JUDGE_LOG
 <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
  <if test = " q.judge_type!= null  " >judge_type,</if>
  <if test = " q.material_no!= null  " >material_no,</if>
  <if test = " q.create_name!= null  " >create_name,</if>
  <if test = " q.create_name!= null  " >create_time,</if>
  <if test = " q.material_type!= null  " >material_type,</if>
  <if test = " q.prod_line!= null  " >prod_line,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " q.judge_type!= null  " >#{q.judge_type,jdbcType =VARCHAR},</if>
  <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
  <if test = " q.create_name!= null  " >sysdate,</if>
  <if test = " q.material_type!= null  " >#{q.material_type,jdbcType =VARCHAR},</if>
  <if test = " q.prod_line!= null  " >#{q.prod_line,jdbcType =VARCHAR},</if>
       </trim>
</insert>

<insert id="insertQcmJudgeOperateLog" parameterType = "QCM.COMMUNAL.VO.QcmJudgeOperateLog">
insert into QCM_JUDGE_OPERATE_LOG
 <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
  <if test = " q.guid!= null  " >guid,</if>
  <if test = " q.operate_type!= null  " >operate_type,</if>
  <if test = " q.operate_name!= null  " >operate_name,</if>
  <if test = " q.operate_name!= null  " >operate_time,</if>
  <if test = " q.params!= null  " >params,</if>
  <if test = " q.prod_line!= null  " >prod_line,</if>
  <if test = " q.operation_interface!= null  " >operation_interface,</if>
  <if test = " q.batchno!= null  " >batchno,</if>
  <if test = " q.judge_result!= null  " >judge_result,</if>
  <if test = " q.memo!= null  " >memo,</if>
  
       </trim> values
       <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
        <if test = " q.guid!= null  " >#{q.guid,jdbcType =VARCHAR},</if>
  <if test = " q.operate_type!= null  " >#{q.operate_type,jdbcType =VARCHAR},</if>
  <if test = " q.operate_name!= null  " >#{q.operate_name,jdbcType =VARCHAR},</if>
  <if test = " q.operate_name!= null  " >sysdate,</if>
  <if test = " q.params!= null  " >#{q.params,jdbcType =VARCHAR},</if>
  <if test = " q.prod_line!= null  " >#{q.prod_line,jdbcType =VARCHAR},</if>
  <if test = " q.operation_interface!= null  " >#{q.operation_interface,jdbcType =VARCHAR},</if>
  <if test = " q.batchno!= null  " >#{q.batchno,jdbcType =VARCHAR},</if>
  <if test = " q.judge_result!= null  " >#{q.judge_result,jdbcType =VARCHAR},</if>
  <if test = " q.memo!= null  " >#{q.memo,jdbcType =VARCHAR},</if>
       </trim>
</insert>


    <update id="updateQcmJhyInspElements" parameterType="QCM.COMMUNAL.VO.QcmJhyElementsEditLog">
        update qcm_jhy_insp_elements
        <trim prefix="set" suffixOverrides=",">
            <if test="q.a_assay_no!=null">
                assay_no=#{q.a_assay_no},
            </if>
            <if test="q.a_heat_no!=null">
                heat_no=#{q.a_heat_no},
            </if>
        </trim>
        <where>
            1=1
            AND assay_no=#{q.b_assay_no}
            AND heat_no=#{q.b_heat_no}
            AND pline_code=#{q.pline_code}
        </where>
    </update>
    
    <update id="UpdateQcmJudgeUltimate" parameterType = "QCM.COMMUNAL.VO.QcmJudgeUltimate">
        update qcm_judge_ultimate
        <trim prefix="set" suffixOverrides=",">
            <if test="q.utm_memo!=null">
                utm_memo=#{q.utm_memo},
            </if>
        </trim>
        <where>
            1=1
            AND utm_id=#{q.utm_id}
        </where>
     </update>

    <insert id = "insertQcmJhyElementsEditLog" parameterType = "QCM.COMMUNAL.VO.QcmJhyElementsEditLog">
        insert into QCM_JHY_ELEMENTS_EDIT_LOG
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.b_heat_no!= null  " >b_heat_no,</if>
            <if test = " q.b_assay_no!= null  " >b_assay_no,</if>
            <if test = " q.a_heat_no!= null  " >a_heat_no,</if>
            <if test = " q.a_assay_no!= null  " >a_assay_no,</if>
            <if test = " q.create_name!= null  " >create_name,</if>
            <if test = " q.create_time!= null  " >create_time,</if>
            <if test = " q.pline_code!= null  " >pline_code,</if>
            <if test = " q.h!= null  " >h,</if>
            <if test = " q.o!= null  " >o,</if>
        </trim> values
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.b_heat_no!= null  " >#{q.b_heat_no,jdbcType =VARCHAR},</if>
            <if test = " q.b_assay_no!= null  " >#{q.b_assay_no,jdbcType =VARCHAR},</if>
            <if test = " q.a_heat_no!= null  " >#{q.a_heat_no,jdbcType =VARCHAR},</if>
            <if test = " q.a_assay_no!= null  " >#{q.a_assay_no,jdbcType =VARCHAR},</if>
            <if test = " q.create_name!= null  " >#{q.create_name,jdbcType =VARCHAR},</if>
            <if test = " q.create_time!= null  " >sysdate,</if>
            <if test = " q.pline_code!= null  " >#{q.pline_code,jdbcType =VARCHAR},</if>
            <if test = " q.h!= null  " >#{q.h,jdbcType =VARCHAR},</if>
            <if test = " q.o!= null  " >#{q.o,jdbcType =VARCHAR},</if>
        </trim>
    </insert>
    
    <insert id="insertQcmJudgeGpInfo" parameterType = "QCM.COMMUNAL.VO.QcmJudgeGpInfo">
        insert into qcm_judge_gpinfo
         <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.gp_id!= null  " >gp_id,</if>
            <if test = " q.material_no!= null  " >material_no,</if>
            <if test = " q.steel_name!= null  " >steel_name,</if>
            <if test = " q.thick!= null  " >thick,</if>
            <if test = " q.width!= null  " >width,</if>
            <if test = " q.length!= null  " >length,</if>
            <if test = " q.orderno!= null  " >orderno,</if>
            <if test = " q.gp_name!= null  " >gp_name,</if>
            <if test = " q.gp_name!= null  " >gp_time,</if>
            <if test = " q.old_orderno!= null  " >old_orderno,</if>
            <if test = " q.weight!= null  " >weight,</if>
            <if test = " q.prod_line!= null  " >prod_line,</if>
            <if test = " q.gp_steel_name!= null  " >gp_steel_name,</if>
            <if test = " q.gp_type!= null  " >gp_type,</if>
        </trim> values
        <trim prefix="(" prefixOverrides="," suffix=")" suffixOverrides=",">
            <if test = " q.gp_id!= null  " >#{q.gp_id,jdbcType =VARCHAR},</if>
            <if test = " q.material_no!= null  " >#{q.material_no,jdbcType =VARCHAR},</if>
            <if test = " q.steel_name!= null  " >#{q.steel_name,jdbcType =VARCHAR},</if>
            <if test = " q.thick!= null  " >#{q.thick,jdbcType =VARCHAR},</if>
            <if test = " q.width!= null  " >#{q.width,jdbcType =VARCHAR},</if>
            <if test = " q.length!= null  " >#{q.length,jdbcType =VARCHAR},</if>
            <if test = " q.orderno!= null  " >#{q.orderno,jdbcType =VARCHAR},</if>
            <if test = " q.gp_name!= null  " >#{q.gp_name,jdbcType =VARCHAR},</if>
            <if test = " q.gp_name!= null  " >sysdate,</if>
            <if test = " q.old_orderno!= null  " >#{q.old_orderno,jdbcType =VARCHAR},</if>
            <if test = " q.weight!= null  " >#{q.weight,jdbcType =VARCHAR},</if>
            <if test = " q.prod_line!= null  " >#{q.prod_line,jdbcType =VARCHAR},</if>
            <if test = " q.gp_steel_name!= null  " >#{q.gp_steel_name,jdbcType =VARCHAR},</if>
            <if test = " q.gp_type!= null  " >#{q.gp_type,jdbcType =VARCHAR},</if>
        </trim>
    </insert>
    <update id="LockP">
update ZJ_RESULT_ALL@xgcx 
set PIC_IS_LOCK = '1'
where BILLETID = #{material_no}
AND JUDGERESULT = '0'
</update>

<update id = "UpdateQcmJudgeLocking8" parameterType= "QCM.COMMUNAL.VO.QCMJudgeLocking">
 update qcm_judge_locking
 set UNLOCK_TYPE_CODE = #{qjl.unlock_type_code,jdbcType =VARCHAR },
 UNLOCK_TYPE_DESC = #{qjl.unlock_type_desc,jdbcType =VARCHAR },
 UNLOCK_MEMO = #{qjl.unlock_memo,jdbcType =VARCHAR },
 TARGET_DESIGN_KEY = #{qjl.target_design_key,jdbcType =VARCHAR },
 TARGET_PSC = #{qjl.target_psc,jdbcType =VARCHAR },
 CIC_LOCKING = #{qjl.cic_locking,jdbcType =VARCHAR },
 FIC_LOCKING = #{qjl.fic_locking,jdbcType =VARCHAR },
 SIC_LOCKING = #{qjl.sic_locking,jdbcType =VARCHAR },
 PIC_LOCKING = #{qjl.pic_locking,jdbcType =VARCHAR },
 DIC_LOCKING = #{qjl.dic_locking,jdbcType =VARCHAR },
 UNLOCK_NAME = #{qjl.unlock_name,jdbcType =VARCHAR },
 UNLOCK_TIME = sysdate,
 reason_code= #{qjl.reason_code,jdbcType =VARCHAR},
 reason_desc=   #{qjl.reason_desc,jdbcType =VARCHAR},
 flaw_code=   #{qjl.flaw_code,jdbcType =VARCHAR},
 flaw_desc=  #{qjl.flaw_desc,jdbcType =VARCHAR},
 unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR}
 where 1= 1
and batch_no = #{qjl.batch_no,jdbcType =VARCHAR}
 <if test = " qjl.material_no!= null  " >
and material_no = #{qjl.material_no,jdbcType =VARCHAR}
</if>
 and unlock_type_code is null
 and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR }
</update>


<update id="zjResultAllZHB">
update ZJ_RESULT_ALL@xgcx
set billetid_jy = #{inspection_lot},PHYSRESULT='0',PHYSRESULT_DESC='',PHYSID=''
where BILLETID = #{material_no} and JUDGERESULT='0'
</update>

</mapper>