insert into QCM_JUDGE_CHEMICAL cic_id, design_key, psc, heat_no, batch_no, inspection_lot, smp_no, board_no, material_no, delivery_state_code, delivery_state_desc, thick, width, length, grade_code, grade_name, assay_no_cp, assay_no_rl, pline_code, pline_name, cic_result_code, cic_result_desc, cic_memo, judge_name, judge_ttime, psc_desc, prod_code, prod_name, steel_code, steel_name, std_code, std_name, create_name, values #{qjc.cic_id,jdbcType =VARCHAR}, #{qjc.design_key,jdbcType =VARCHAR}, #{qjc.psc,jdbcType =VARCHAR}, #{qjc.heat_no,jdbcType =VARCHAR}, #{qjc.batch_no,jdbcType =VARCHAR}, #{qjc.inspection_lot,jdbcType =VARCHAR}, #{qjc.smp_no,jdbcType =VARCHAR}, #{qjc.board_no,jdbcType =VARCHAR}, #{qjc.material_no,jdbcType =VARCHAR}, #{qjc.delivery_state_code,jdbcType =VARCHAR}, #{qjc.delivery_state_desc,jdbcType =VARCHAR}, #{qjc.thick,jdbcType =NUMERIC}, #{qjc.width,jdbcType =NUMERIC}, #{qjc.length,jdbcType =NUMERIC}, #{qjc.grade_code,jdbcType =VARCHAR}, #{qjc.grade_name,jdbcType =VARCHAR}, #{qjc.assay_no_cp,jdbcType =VARCHAR}, #{qjc.assay_no_rl,jdbcType =VARCHAR}, #{qjc.pline_code,jdbcType =VARCHAR}, #{qjc.pline_name,jdbcType =VARCHAR}, #{qjc.cic_result_code,jdbcType =VARCHAR}, #{qjc.cic_result_desc,jdbcType =VARCHAR}, #{qjc.cic_memo,jdbcType =VARCHAR}, #{qjc.judge_name,jdbcType =VARCHAR}, sysdate, #{qjc.psc_desc,jdbcType =VARCHAR}, #{qjc.prod_code,jdbcType =VARCHAR}, #{qjc.prod_name,jdbcType =VARCHAR}, #{qjc.steel_code,jdbcType =VARCHAR}, #{qjc.steel_name,jdbcType =VARCHAR}, #{qjc.std_code,jdbcType =VARCHAR}, #{qjc.std_name,jdbcType =VARCHAR}, #{qjc.judge_name,jdbcType =VARCHAR}, update QCM_JHY_SAMPLE_R_ORD JUDGE_STATUS=#{qsrd.judge_status}, ASSAY_NO_CP=#{qsrd.assay_no_cp}, ASSAY_NO_RL=#{qsrd.assay_no_rl}, PHY_ID=#{qsrd.phy_id}, CIC_ID=#{qsrd.cic_id}, JUDGE_RESULT_CODE=#{qsrd.judge_result_code}, JUDGE_RESULT_DESC=#{qsrd.judge_result_desc}, JUDGE_NAME=#{qsrd.judge_name}, JUDGE_TIME=sysdate, JUDGE_MEMO=#{qsrd.judge_memo}, 1=1 AND SMP_NO=#{qsrd.smp_no} update qcm_judge_coil_result chemresult=#{q.chemresult}, sizeresult=#{q.sizeresult}, judgeresult=#{q.judgeresult}, physresult=#{q.physresult}, phyfstsresult=#{q.phyfstsresult}, spyresult=#{q.spyresult}, surfaceresult=#{q.surfaceresult}, up_surface_result=#{q.up_surface_result}, ud_surface_result=#{q.ud_surface_result}, marginal_result=#{q.marginal_result}, chemresult_desc=#{q.chemresult_desc}, sizeresult_desc=#{q.sizeresult_desc}, judgeresult_desc=#{q.judgeresult_desc}, physresult_desc=#{q.physresult_desc}, phyfstsresult_desc=#{q.phyfstsresult_desc}, spyresult_desc=#{q.spyresult_desc}, surfaceresult_desc=#{q.surfaceresult_desc}, up_surface_result_desc=#{q.up_surface_result_desc}, ud_surface_result_desc=#{q.ud_surface_result_desc}, marginal_result_desc=#{q.marginal_result_desc}, up_surface_result_id_desc=#{q.up_surface_result_id_desc}, ud_surface_result_id_desc=#{q.ud_surface_result_id_desc}, marginal_result_id_desc=#{q.marginal_result_id_desc}, chemid=#{q.chemid}, physid=#{q.physid}, phyfstsid=#{q.phyfstsid}, surfaceid=#{q.surfaceid}, spyid=#{q.spyid}, sizeid=#{q.sizeid}, judgeid=#{q.judgeid}, cic_is_lock=#{q.cic_is_lock}, pic_is_lock=#{q.pic_is_lock}, sic_is_lock=#{q.sic_is_lock}, dic_is_lock=#{q.dic_is_lock}, sfu_is_lock=#{q.sfu_is_lock}, sfd_is_lock=#{q.sfd_is_lock}, sfe_is_lock=#{q.sfe_is_lock}, r_chemid=#{q.r_chemid}, r_chemresult=#{q.r_chemresult}, r_chemresult_desc=#{q.r_chemresult_desc}, r_cic_is_lock=#{q.r_cic_is_lock}, inspection_lot=#{q.new_inspection_lot}, tic_id=#{q.tic_id}, tic_result=#{q.tic_result}, tic_result_desc=#{q.tic_result_desc}, tic_is_lock=#{q.tic_is_lock}, 1=1 and judgeresult = '0' AND coil_no=#{q.coil_no} AND inspection_lot=#{q.inspection_lot} update qcm_judge_yt_coil_result chemresult=#{q.chemresult}, sizeresult=#{q.sizeresult}, judgeresult=#{q.judgeresult}, physresult=#{q.physresult}, phyfstsresult=#{q.phyfstsresult}, spyresult=#{q.spyresult}, surfaceresult=#{q.surfaceresult}, up_surface_result=#{q.up_surface_result}, ud_surface_result=#{q.ud_surface_result}, marginal_result=#{q.marginal_result}, chemresult_desc=#{q.chemresult_desc}, sizeresult_desc=#{q.sizeresult_desc}, judgeresult_desc=#{q.judgeresult_desc}, physresult_desc=#{q.physresult_desc}, phyfstsresult_desc=#{q.phyfstsresult_desc}, spyresult_desc=#{q.spyresult_desc}, surfaceresult_desc=#{q.surfaceresult_desc}, up_surface_result_desc=#{q.up_surface_result_desc}, ud_surface_result_desc=#{q.ud_surface_result_desc}, marginal_result_desc=#{q.marginal_result_desc}, up_surface_result_id_desc=#{q.up_surface_result_id_desc}, ud_surface_result_id_desc=#{q.ud_surface_result_id_desc}, marginal_result_id_desc=#{q.marginal_result_id_desc}, chemid=#{q.chemid}, physid=#{q.physid}, phyfstsid=#{q.phyfstsid}, surfaceid=#{q.surfaceid}, spyid=#{q.spyid}, sizeid=#{q.sizeid}, judgeid=#{q.judgeid}, cic_is_lock=#{q.cic_is_lock}, pic_is_lock=#{q.pic_is_lock}, sic_is_lock=#{q.sic_is_lock}, dic_is_lock=#{q.dic_is_lock}, sfu_is_lock=#{q.sfu_is_lock}, sfd_is_lock=#{q.sfd_is_lock}, sfe_is_lock=#{q.sfe_is_lock}, r_chemid=#{q.r_chemid}, r_chemresult=#{q.r_chemresult}, r_chemresult_desc=#{q.r_chemresult_desc}, r_cic_is_lock=#{q.r_cic_is_lock}, inspection_lot=#{q.new_inspection_lot}, tic_id=#{q.tic_id}, tic_result=#{q.tic_result}, tic_result_desc=#{q.tic_result_desc}, tic_is_lock=#{q.tic_is_lock}, 1=1 and judgeresult = '0' AND coil_no=#{q.coil_no} AND inspection_lot=#{q.inspection_lot} update zj_result_all@xgcx chemresult=#{q.chemresult}, sizeresult=#{q.sizeresult}, judgeresult=#{q.judgeresult}, physresult=#{q.physresult}, phyfstsresult=#{q.phyfstsresult}, spyresult=#{q.spyresult}, surfaceresult=#{q.surfaceresult}, surfaceresult_desc=#{q.surfaceresult_desc}, up_surface_result=#{q.up_surface_result}, ud_surface_result=#{q.ud_surface_result}, marginal_result=#{q.marginal_result}, chemresult_desc=#{q.chemresult_desc}, sizeresult_desc=#{q.sizeresult_desc}, judgeresult_desc=#{q.judgeresult_desc}, physresult_desc=#{q.physresult_desc}, phyfstsresult_desc=#{q.phyfstsresult_desc}, spyresult_desc=#{q.spyresult_desc}, up_surface_result_desc=#{q.up_surface_result_desc}, ud_surface_result_desc=#{q.ud_surface_result_desc}, marginal_result_desc=#{q.marginal_result_desc}, up_surface_result_id_desc=#{q.up_surface_result_id_desc}, ud_surface_result_id_desc=#{q.ud_surface_result_id_desc}, marginal_result_id_desc=#{q.marginal_result_id_desc}, chemid=#{q.chemid}, physid=#{q.physid}, phyfstsid=#{q.phyfstsid}, surfaceid=#{q.surfaceid}, spyid=#{q.spyid}, sizeid=#{q.sizeid}, judgeid=#{q.judgeid}, cic_is_lock=#{q.cic_is_lock}, pic_is_lock=#{q.pic_is_lock}, sic_is_lock=#{q.sic_is_lock}, dic_is_lock=#{q.dic_is_lock}, sfu_is_lock=#{q.sfu_is_lock}, sfd_is_lock=#{q.sfd_is_lock}, sfe_is_lock=#{q.sfe_is_lock}, r_chemid=#{q.r_chemid}, r_chemresult=#{q.r_chemresult}, r_chemresult_desc=#{q.r_chemresult_desc}, r_cic_is_lock=#{q.r_cic_is_lock}, billetid_jy=#{q.new_inspection_lot}, fst_judgeresult=#{q.fst_judgeresult}, fst_judgeresult_desc=#{q.fst_judgeresult_desc}, 1=1 and judgeresult = '0' AND billetid=#{q.billetid} AND billetid_jy=#{q.billetid_jy} update zj_result_all@xgcx chemresult=#{q.chemresult}, sizeresult=#{q.sizeresult}, judgeresult=#{q.judgeresult}, physresult=#{q.physresult}, phyfstsresult=#{q.phyfstsresult}, spyresult=#{q.spyresult}, surfaceresult=#{q.surfaceresult}, surfaceresult_desc=#{q.surfaceresult_desc}, up_surface_result=#{q.up_surface_result}, ud_surface_result=#{q.ud_surface_result}, marginal_result=#{q.marginal_result}, chemresult_desc=#{q.chemresult_desc}, sizeresult_desc=#{q.sizeresult_desc}, judgeresult_desc=#{q.judgeresult_desc}, physresult_desc=#{q.physresult_desc}, phyfstsresult_desc=#{q.phyfstsresult_desc}, spyresult_desc=#{q.spyresult_desc}, up_surface_result_desc=#{q.up_surface_result_desc}, ud_surface_result_desc=#{q.ud_surface_result_desc}, marginal_result_desc=#{q.marginal_result_desc}, up_surface_result_id_desc=#{q.up_surface_result_id_desc}, ud_surface_result_id_desc=#{q.ud_surface_result_id_desc}, marginal_result_id_desc=#{q.marginal_result_id_desc}, chemid=#{q.chemid}, physid=#{q.physid}, phyfstsid=#{q.phyfstsid}, surfaceid=#{q.surfaceid}, spyid=#{q.spyid}, sizeid=#{q.sizeid}, judgeid=#{q.judgeid}, cic_is_lock=#{q.cic_is_lock}, pic_is_lock=#{q.pic_is_lock}, sic_is_lock=#{q.sic_is_lock}, dic_is_lock=#{q.dic_is_lock}, sfu_is_lock=#{q.sfu_is_lock}, sfd_is_lock=#{q.sfd_is_lock}, sfe_is_lock=#{q.sfe_is_lock}, r_chemid=#{q.r_chemid}, r_chemresult=#{q.r_chemresult}, r_chemresult_desc=#{q.r_chemresult_desc}, r_cic_is_lock=#{q.r_cic_is_lock}, billetid_jy=#{q.new_inspection_lot}, fst_judgeresult=#{q.fst_judgeresult}, fst_judgeresult_desc=#{q.fst_judgeresult_desc}, 1=1 AND billetid like #{q.billetid} ||'%' AND billetid_jy=#{q.billetid_jy} insert into QCM_JUDGE_PHYSICAL_RESULT phy_id, guid, smp_no, heat_no, batch_no, inspection_lot, specimen_no, material_no, phy_code_l, phy_name_l, phy_code_m, phy_name_m, phy_code_s, phy_name_s, item_code_d, item_name_d, item_code_t, item_name_t, item_code_s, item_name_s, val1, val2, val3, val4, val5, val6, val7, val8, val9, val10, val11, val12, val13, val14, val15, avg_val, pri, is_pass, create_name, create_time, item_code_l, item_desc_l, defect_flag, phy_unit, values #{q.phy_id,jdbcType =VARCHAR}, #{q.guid,jdbcType =VARCHAR}, #{q.smp_no,jdbcType =VARCHAR}, #{q.heat_no,jdbcType =VARCHAR}, #{q.batch_no,jdbcType =VARCHAR}, #{q.inspection_lot,jdbcType =VARCHAR}, #{q.specimen_no,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.phy_code_l,jdbcType =VARCHAR}, #{q.phy_name_l,jdbcType =VARCHAR}, #{q.phy_code_m,jdbcType =VARCHAR}, #{q.phy_name_m,jdbcType =VARCHAR}, #{q.phy_code_s,jdbcType =VARCHAR}, #{q.phy_name_s,jdbcType =VARCHAR}, #{q.item_code_d,jdbcType =VARCHAR}, #{q.item_name_d,jdbcType =VARCHAR}, #{q.item_code_t,jdbcType =VARCHAR}, #{q.item_name_t,jdbcType =VARCHAR}, #{q.item_code_s,jdbcType =VARCHAR}, #{q.item_name_s,jdbcType =VARCHAR}, #{q.val1,jdbcType =VARCHAR}, #{q.val2,jdbcType =VARCHAR}, #{q.val3,jdbcType =VARCHAR}, #{q.val4,jdbcType =VARCHAR}, #{q.val5,jdbcType =VARCHAR}, #{q.val6,jdbcType =VARCHAR}, #{q.val7,jdbcType =VARCHAR}, #{q.val8,jdbcType =VARCHAR}, #{q.val9,jdbcType =VARCHAR}, #{q.val10,jdbcType =VARCHAR}, #{q.val11,jdbcType =VARCHAR}, #{q.val12,jdbcType =VARCHAR}, #{q.val13,jdbcType =VARCHAR}, #{q.val14,jdbcType =VARCHAR}, #{q.val15,jdbcType =VARCHAR}, #{q.avg_val,jdbcType =VARCHAR}, #{q.pri,jdbcType =VARCHAR}, #{q.is_pass,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, sysdate, #{q.item_code_l,jdbcType =VARCHAR}, #{q.item_desc_l,jdbcType =VARCHAR}, #{q.defect_flag,jdbcType=VARCHAR}, #{q.phy_unit,jdbcType =VARCHAR}, insert into QCM_JUDGE_MEASURE_D sic_id, sic_item_code, sic_item_desc, plan_val, judge_val, memo, values #{q.sic_id,jdbcType =VARCHAR}, #{q.sic_item_code,jdbcType =VARCHAR}, #{q.sic_item_desc,jdbcType =VARCHAR}, #{q.plan_val,jdbcType =VARCHAR}, #{q.judge_val,jdbcType =VARCHAR}, #{q.memo,jdbcType =VARCHAR}, insert into QCM_JUDGE_PHYSICAL phy_id, smp_no, heat_no, batch_no, inspection_lot, board_no, design_key, psc, delivery_state_code, delivery_state_desc, thick, width, length, cert_inst_code, cert_inst_name, smp_type_code, smp_type_name, pline_code, pline_name, phy_result_code, phy_result_desc, phy_memo, judge_name, judge_ttime, psc_desc, prod_code, prod_name, steel_code, steel_name, std_code, std_name, cancel_memo, values #{qjc.phy_id,jdbcType =VARCHAR}, #{qjc.smp_no,jdbcType =VARCHAR}, #{qjc.heat_no,jdbcType =VARCHAR}, #{qjc.batch_no,jdbcType =VARCHAR}, #{qjc.inspection_lot,jdbcType =VARCHAR}, #{qjc.board_no,jdbcType =VARCHAR}, #{qjc.design_key,jdbcType =VARCHAR}, #{qjc.psc,jdbcType =VARCHAR}, #{qjc.delivery_state_code,jdbcType =VARCHAR}, #{qjc.delivery_state_desc,jdbcType =VARCHAR}, #{qjc.thick,jdbcType =NUMERIC}, #{qjc.width,jdbcType =NUMERIC}, #{qjc.length,jdbcType =NUMERIC}, #{qjc.cert_inst_code,jdbcType =VARCHAR}, #{qjc.cert_inst_name,jdbcType =VARCHAR}, #{qjc.smp_type_code,jdbcType =VARCHAR}, #{qjc.smp_type_name,jdbcType =VARCHAR}, #{qjc.pline_code,jdbcType =VARCHAR}, #{qjc.pline_name,jdbcType =VARCHAR}, #{qjc.phy_result_code,jdbcType =VARCHAR}, #{qjc.phy_result_desc,jdbcType =VARCHAR}, #{qjc.phy_memo,jdbcType =VARCHAR}, #{qjc.judge_name,jdbcType =VARCHAR}, sysdate, #{qjc.psc_desc,jdbcType =VARCHAR}, #{qjc.prod_code,jdbcType =VARCHAR}, #{qjc.prod_name,jdbcType =VARCHAR}, #{qjc.steel_code,jdbcType =VARCHAR}, #{qjc.steel_name,jdbcType =VARCHAR}, #{qjc.std_code,jdbcType =VARCHAR}, #{qjc.std_name,jdbcType =VARCHAR}, #{qjc.cancel_memo,jdbcType =VARCHAR}, insert into QCM_JUDGE_PHYSICAL_UTM_M pic_id, inspection_lot, design_key, pic_result_code, pic_result_desc, CREATE_TIME, values #{qpu.pic_id,jdbcType =VARCHAR}, #{qpu.inspection_lot,jdbcType =VARCHAR}, #{qpu.design_key,jdbcType =VARCHAR}, #{qpu.pic_result_code,jdbcType =VARCHAR}, #{qpu.pic_result_desc,jdbcType =VARCHAR}, sysdate, insert into QCM_JUDGE_PHYSICAL_UTM_D pic_id, smp_no, heat_no, batch_no, inspection_lot, design_key, psc, cert_inst_code, cert_inst_name, smp_type_code, smp_type_name, judge_result_code, judge_result_desc, phy_id, memo, judge_name, judge_ttime, psc_desc, prod_code, prod_name, steel_code, steel_name, std_code, std_name, values #{qpd.pic_id,jdbcType =VARCHAR}, #{qpd.smp_no,jdbcType =VARCHAR}, #{qpd.heat_no,jdbcType =VARCHAR}, #{qpd.batch_no,jdbcType =VARCHAR}, #{qpd.inspection_lot,jdbcType =VARCHAR}, #{qpd.design_key,jdbcType =VARCHAR}, #{qpd.psc,jdbcType =VARCHAR}, #{qpd.cert_inst_code,jdbcType =VARCHAR}, #{qpd.cert_inst_name,jdbcType =VARCHAR}, #{qpd.smp_type_code,jdbcType =VARCHAR}, #{qpd.smp_type_name,jdbcType =VARCHAR}, #{qpd.judge_result_code,jdbcType =VARCHAR}, #{qpd.judge_result_desc,jdbcType =VARCHAR}, #{qpd.phy_id,jdbcType =VARCHAR}, #{qpd.memo,jdbcType =VARCHAR}, #{qpd.judge_name,jdbcType =VARCHAR}, SYSDATE, #{qpd.psc_desc,jdbcType =VARCHAR}, #{qpd.prod_code,jdbcType =VARCHAR}, #{qpd.prod_name,jdbcType =VARCHAR}, #{qpd.steel_code,jdbcType =VARCHAR}, #{qpd.steel_name,jdbcType =VARCHAR}, #{qpd.std_code,jdbcType =VARCHAR}, #{qpd.std_name,jdbcType =VARCHAR}, insert into QCM_JUDGE_SURFACE surface_id, heat_no, batch_no, board_no, inspection_lot, material_no, sf_result_code, sf_result_desc, level_code, level_desc, sf_memo, sf_type, roughness_val1, roughness_val2, roughness_val3, cop_section_code, cop_section_desc, respon_section_code, respon_section_name, reason_code, reason_desc, sfu_is_lock, sfd_is_lock, sfe_is_lock, design_key, order_no, psc, psc_desc, pline_code, pline_name, wrk_ord, wrk_grp, judge_name, judge_time, prod_code, prod_name, steel_code, steel_name, std_code, std_name, thick, width, length, values #{q.surface_id,jdbcType =VARCHAR}, #{q.heat_no,jdbcType =VARCHAR}, #{q.batch_no,jdbcType =VARCHAR}, #{q.board_no,jdbcType =VARCHAR}, #{q.inspection_lot,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.sf_result_code,jdbcType =VARCHAR}, #{q.sf_result_desc,jdbcType =VARCHAR}, #{q.level_code,jdbcType =VARCHAR}, #{q.level_desc,jdbcType =VARCHAR}, #{q.sf_memo,jdbcType =VARCHAR}, #{q.sf_type,jdbcType =VARCHAR}, #{q.roughness_val1,jdbcType =VARCHAR}, #{q.roughness_val2,jdbcType =VARCHAR}, #{q.roughness_val3,jdbcType =VARCHAR}, #{q.cop_section_code,jdbcType =VARCHAR}, #{q.cop_section_desc,jdbcType =VARCHAR}, #{q.respon_section_code,jdbcType =VARCHAR}, #{q.respon_section_name,jdbcType =VARCHAR}, #{q.reason_code,jdbcType =VARCHAR}, #{q.reason_desc,jdbcType =VARCHAR}, #{q.sfu_is_lock,jdbcType =VARCHAR}, #{q.sfd_is_lock,jdbcType =VARCHAR}, #{q.sfe_is_lock,jdbcType =VARCHAR}, #{q.design_key,jdbcType =VARCHAR}, #{q.order_no,jdbcType =VARCHAR}, #{q.psc,jdbcType =VARCHAR}, #{q.psc_desc,jdbcType =VARCHAR}, #{q.pline_code,jdbcType =VARCHAR}, #{q.pline_name,jdbcType =VARCHAR}, #{q.wrk_ord,jdbcType =VARCHAR}, #{q.wrk_grp,jdbcType =VARCHAR}, #{q.judge_name,jdbcType =VARCHAR}, sysdate, #{q.prod_code,jdbcType =VARCHAR}, #{q.prod_name,jdbcType =VARCHAR}, #{q.steel_code,jdbcType =VARCHAR}, #{q.steel_name,jdbcType =VARCHAR}, #{q.std_code,jdbcType =VARCHAR}, #{q.std_name,jdbcType =VARCHAR}, #{q.thick,jdbcType =VARCHAR}, #{q.width,jdbcType =VARCHAR}, #{q.length,jdbcType =VARCHAR}, insert into QCM_JUDGE_SURFACE_FLAW surface_id, primary_flag, is_repair, flaw_seq, flaw_code, flaw_desc, flaw_area, flaw_type_code, flaw_type_desc, flaw_pos_code, flaw_pos_desc, flaw_dir_code, flaw_dir_desc, flaw_size_code, flaw_size_desc, flaw_lv_code, flaw_lv_desc, flaw_weight, flaw_quantity, memo, create_name, create_time, fixed_type_code, fixed_type_desc, fixed_thick, fixed_name, flaw_origin, values #{q.surface_id,jdbcType =VARCHAR}, #{q.primary_flag,jdbcType =VARCHAR}, #{q.is_repair,jdbcType =VARCHAR}, #{q.flaw_seq,jdbcType =NUMERIC}, #{q.flaw_code,jdbcType =VARCHAR}, #{q.flaw_desc,jdbcType =VARCHAR}, #{q.flaw_area,jdbcType =VARCHAR}, #{q.flaw_type_code,jdbcType =VARCHAR}, #{q.flaw_type_desc,jdbcType =VARCHAR}, #{q.flaw_pos_code,jdbcType =VARCHAR}, #{q.flaw_pos_desc,jdbcType =VARCHAR}, #{q.flaw_dir_code,jdbcType =VARCHAR}, #{q.flaw_dir_desc,jdbcType =VARCHAR}, #{q.flaw_size_code,jdbcType =VARCHAR}, #{q.flaw_size_desc,jdbcType =VARCHAR}, #{q.flaw_lv_code,jdbcType =VARCHAR}, #{q.flaw_lv_desc,jdbcType =VARCHAR}, #{q.flaw_weight,jdbcType =NUMERIC}, #{q.flaw_quantity,jdbcType =NUMERIC}, #{q.memo,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, #{q.create_time,jdbcType =TIMESTAMP}, #{q.fixed_type_code,jdbcType =VARCHAR}, #{q.fixed_type_desc,jdbcType =VARCHAR}, #{q.fixed_thick,jdbcType =VARCHAR}, #{q.fixed_name,jdbcType =VARCHAR}, #{q.flaw_origin,jdbcType =VARCHAR}, insert into QCM_JUDGE_ULTIMATE_REASON material_no, type_code, record_id, seq, phy_code_l, phy_name_l, phy_code_m, phy_name_m, phy_code_s, phy_name_s, item_code_d, item_name_d, item_code_t, item_name_t, item_code_s, item_name_s, val1, val2, val3, avg_val, stdmin_sign, stdmin, stdmax_sign, stdmax, create_name, create_time, item_code_l, item_desc_l, values #{q.material_no,jdbcType =VARCHAR}, #{q.type_code,jdbcType =VARCHAR}, #{q.record_id,jdbcType =VARCHAR}, #{q.seq,jdbcType =NUMERIC}, #{q.phy_code_l,jdbcType =VARCHAR}, #{q.phy_name_l,jdbcType =VARCHAR}, #{q.phy_code_m,jdbcType =VARCHAR}, #{q.phy_name_m,jdbcType =VARCHAR}, #{q.phy_code_s,jdbcType =VARCHAR}, #{q.phy_name_s,jdbcType =VARCHAR}, #{q.item_code_d,jdbcType =VARCHAR}, #{q.item_name_d,jdbcType =VARCHAR}, #{q.item_code_t,jdbcType =VARCHAR}, #{q.item_name_t,jdbcType =VARCHAR}, #{q.item_code_s,jdbcType =VARCHAR}, #{q.item_name_s,jdbcType =VARCHAR}, #{q.val1,jdbcType =VARCHAR}, #{q.val2,jdbcType =VARCHAR}, #{q.val3,jdbcType =VARCHAR}, #{q.avg_val,jdbcType =VARCHAR}, #{q.stdmin_sign,jdbcType =VARCHAR}, #{q.stdmin,jdbcType =VARCHAR}, #{q.stdmax_sign,jdbcType =VARCHAR}, #{q.stdmax,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, SYSDATE, #{q.item_code_l,jdbcType =VARCHAR}, #{q.item_desc_l,jdbcType =VARCHAR}, insert into deal_memo memo_code, memo, pline_code, creat_name, creat_time, mod_id, mod_time, VALUES #{list.memo_code,jdbcType =VARCHAR}, #{list.memo,jdbcType =VARCHAR}, #{list.pline_code,jdbcType =VARCHAR}, #{list.creat_name,jdbcType =VARCHAR}, #{list.creat_time,jdbcType =DATE}, #{list.mod_id,jdbcType =VARCHAR}, #{list.mod_time,jdbcType =DATE}, 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) 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 insert into Excel_LZ_XN (COIL_NO,KLQD,QFQD,DHSCL) select #{item.coil_no,jdbcType =VARCHAR},#{item.klqd,jdbcType =VARCHAR}, #{item.qfqd,jdbcType =VARCHAR},#{item.dhscl,jdbcType =VARCHAR} from dual 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) 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 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) 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 insert into QCM_JUDGE_MEASURE sic_id, design_key, heat_no, batch_no, inspection_lot, board_no, material_no, sic_result_code, sic_result_desc, sic_memo, weight, south_thick_val, south_h_val, south_m_val, south_r_val, middle_thick_val, middle_h_val, middle_m_val, middle_r_val, north_thick_val, north_h_val, north_m_val, north_r_val, pline_code, pline_name, wrk_ord, wrk_grp, judge_name, judge_time, psc, psc_desc, respon_section_code, respon_section_name, prod_code, prod_name, steel_code, steel_name, std_code, std_name, level_code, level_desc, thick, width, length, change_type_desc, values #{qju.sic_id,jdbcType =VARCHAR}, #{qju.design_key,jdbcType =VARCHAR}, #{qju.heat_no,jdbcType =VARCHAR}, #{qju.batch_no,jdbcType =VARCHAR}, #{qju.inspection_lot,jdbcType =VARCHAR}, #{qju.board_no,jdbcType =VARCHAR}, #{qju.material_no,jdbcType =VARCHAR}, #{qju.sic_result_code,jdbcType =VARCHAR}, #{qju.sic_result_desc,jdbcType =VARCHAR}, #{qju.sic_memo,jdbcType =VARCHAR}, #{qju.weight,jdbcType =NUMERIC}, #{qju.south_thick_val,jdbcType =NUMERIC}, #{qju.south_h_val,jdbcType =NUMERIC}, #{qju.south_m_val,jdbcType =NUMERIC}, #{qju.south_r_val,jdbcType =NUMERIC}, #{qju.middle_thick_val,jdbcType =NUMERIC}, #{qju.middle_h_val,jdbcType =NUMERIC}, #{qju.middle_m_val,jdbcType =NUMERIC}, #{qju.middle_r_val,jdbcType =NUMERIC}, #{qju.north_thick_val,jdbcType =NUMERIC}, #{qju.north_h_val,jdbcType =NUMERIC}, #{qju.north_m_val,jdbcType =NUMERIC}, #{qju.north_r_val,jdbcType =NUMERIC}, #{qju.pline_code,jdbcType =VARCHAR}, #{qju.pline_name,jdbcType =VARCHAR}, #{qju.wrk_ord,jdbcType =VARCHAR}, #{qju.wrk_grp,jdbcType =VARCHAR}, #{qju.judge_name,jdbcType =VARCHAR}, sysdate, #{qju.psc,jdbcType =VARCHAR}, #{qju.psc_desc,jdbcType =VARCHAR}, #{qju.respon_section_code,jdbcType =VARCHAR}, #{qju.respon_section_name,jdbcType =VARCHAR}, #{qju.prod_code,jdbcType =VARCHAR}, #{qju.prod_name,jdbcType =VARCHAR}, #{qju.steel_code,jdbcType =VARCHAR}, #{qju.steel_name,jdbcType =VARCHAR}, #{qju.std_code,jdbcType =VARCHAR}, #{qju.std_name,jdbcType =VARCHAR}, #{qju.level_code,jdbcType =VARCHAR}, #{qju.level_desc,jdbcType =VARCHAR}, #{qju.thick,jdbcType =VARCHAR}, #{qju.width,jdbcType =VARCHAR}, #{qju.length,jdbcType =VARCHAR}, #{qju.change_type_desc,jdbcType =VARCHAR}, insert into QCM_JUDGE_ULTIMATE utm_id, design_key, heat_no, batch_no, board_no, inspection_lot, material_no, contract_line_no, psc, box_no, cic_id, cic_result_code, cic_result_desc, cic_memo, pic_id, pic_result_code, pic_result_desc, pic_memo, sic_id, sic_result_code, sic_result_desc, sic_memo, dic_id, dic_result_code, dic_result_desc, dic_memo, sfu_id, sfu_result_code, sfu_result_desc, sfu_memo, sfd_id, sfd_result_code, sfd_result_desc, sfd_memo, sfe_id, sfe_result_code, sfe_result_desc, sfe_memo, mst_id, mst_result_code, mst_result_desc, mst_memo, fst_id, fst_result_code, fst_result_desc, fst_memo, fst_reason, utm_result_code, utm_result_desc, utm_reason, utm_memo, pline_code, pline_name, judge_name, judge_time, psc_desc, prod_code, prod_name, steel_code, steel_name, std_code, std_name, r_cic_id, r_cic_result_code, r_cic_result_desc, product_name, judge_reason, judge_memo, cancel_memo, check_remarks, fix_remarks, tic_id, tic_result_code, tic_result_desc, values #{qju.utm_id,jdbcType =VARCHAR}, #{qju.design_key,jdbcType =VARCHAR}, #{qju.heat_no,jdbcType =VARCHAR}, #{qju.batch_no,jdbcType =VARCHAR}, #{qju.board_no,jdbcType =VARCHAR}, #{qju.inspection_lot,jdbcType =VARCHAR}, #{qju.material_no,jdbcType =VARCHAR}, #{qju.contract_line_no,jdbcType =VARCHAR}, #{qju.psc,jdbcType =VARCHAR}, #qju.box_no,jdbcType =VARCHAR}, #{qju.cic_id,jdbcType =VARCHAR}, #{qju.cic_result_code,jdbcType =VARCHAR}, #{qju.cic_result_desc,jdbcType =VARCHAR}, #{qju.cic_memo,jdbcType =VARCHAR}, #{qju.pic_id,jdbcType =VARCHAR}, #{qju.pic_result_code,jdbcType =VARCHAR}, #{qju.pic_result_desc,jdbcType =VARCHAR}, #{qju.pic_memo,jdbcType =VARCHAR}, #{qju.sic_id,jdbcType =VARCHAR}, #{qju.sic_result_code,jdbcType =VARCHAR}, #{qju.sic_result_desc,jdbcType =VARCHAR}, #{qju.sic_memo,jdbcType =VARCHAR}, #{qju.dic_id,jdbcType =VARCHAR}, #{qju.dic_result_code,jdbcType =VARCHAR}, #{qju.dic_result_desc,jdbcType =VARCHAR}, #{qju.dic_memo,jdbcType =VARCHAR}_MEMO, #{qju.sfu_id,jdbcType =VARCHAR}, #{qju.sfu_result_code,jdbcType =VARCHAR}, #{qju.sfu_result_desc,jdbcType =VARCHAR}, #{qju.sfu_memo,jdbcType =VARCHAR}, #{qju.sfd_id,jdbcType =VARCHAR}, #{qju.sfd_result_code,jdbcType =VARCHAR}, #{qju.sfd_result_desc,jdbcType =VARCHAR}, #{qju.sfd_memo,jdbcType =VARCHAR}, #{qju.sfe_id,jdbcType =VARCHAR}, #{qju.sfe_result_code,jdbcType =VARCHAR}, #{qju.sfe_result_desc,jdbcType =VARCHAR}, #{qju.sfe_memo,jdbcType =VARCHAR}, #{qju.mst_id,jdbcType =VARCHAR}, #{qju.mst_result_code,jdbcType =VARCHAR}, #{qju.mst_result_desc,jdbcType =VARCHAR}, #{qju.mst_memo,jdbcType =VARCHAR}, #{qju.fst_id,jdbcType =VARCHAR}, #{qju.fst_result_code,jdbcType =VARCHAR}, #{qju.fst_result_desc,jdbcType =VARCHAR}, #{qju.fst_memo,jdbcType =VARCHAR}, #{qju.fst_reason,jdbcType =VARCHAR}, #{qju.utm_result_code,jdbcType =VARCHAR}, #{qju.utm_result_desc,jdbcType =VARCHAR}, #{qju.utm_reason,jdbcType =VARCHAR}, #{qju.utm_memo,jdbcType =VARCHAR}, #{qju.pline_code,jdbcType =VARCHAR}, #{qju.pline_name,jdbcType =VARCHAR}, #{qju.judge_name,jdbcType =VARCHAR}, sysdate, #{qju.psc_desc,jdbcType =VARCHAR}, #{qju.prod_code,jdbcType =VARCHAR}, #{qju.prod_name,jdbcType =VARCHAR}, #{qju.steel_code,jdbcType =VARCHAR}, #{qju.steel_name,jdbcType =VARCHAR}, #{qju.std_code,jdbcType =VARCHAR}, #{qju.std_name,jdbcType =VARCHAR}, #{qju.r_cic_id,jdbcType =VARCHAR}, #{qju.r_cic_result_code,jdbcType =VARCHAR}, #{qju.r_cic_result_desc,jdbcType =VARCHAR}, #{qju.product_name,jdbcType =VARCHAR}, #{qju.judge_reason,jdbcType =VARCHAR}, #{qju.judge_memo,jdbcType =VARCHAR}, #{qju.cancel_memo,jdbcType =VARCHAR}, #{qju.check_remarks,jdbcType =VARCHAR}, #{qju.fix_remarks,jdbcType =VARCHAR}, #{qju.tic_id,jdbcType =VARCHAR}, #{qju.tic_result_code,jdbcType =VARCHAR}, #{qju.tic_result_desc,jdbcType =VARCHAR}, insert into qcm_judge_locking material_no, lock_seq, lock_type_code, lock_type_desc, lock_memo, unlock_type_code, unlock_type_desc, unlock_memo, target_design_key, target_psc, heat_no, batch_no, board_no, plan_no, ht_no, design_key, psc, fic_locking, sic_locking, pic_locking, dic_locking, lock_name, lock_time, psc_desc, pline_code, pline_name, cic_locking, prod_code, prod_name, steel_code, steel_name, std_code, std_name, lock_id, reason_code, reason_desc, flaw_code, flaw_desc, create_name, unlock_name, unlock_time, check_remarks, fix_remarks, height, values #{q.material_no,jdbcType =VARCHAR}, #{q.lock_seq,jdbcType =NUMERIC}, #{q.lock_type_code,jdbcType =VARCHAR}, #{q.lock_type_desc,jdbcType =VARCHAR}, #{q.lock_memo,jdbcType =VARCHAR}, #{q.unlock_type_code,jdbcType =VARCHAR}, #{q.unlock_type_desc,jdbcType =VARCHAR}, #{q.unlock_memo,jdbcType =VARCHAR}, #{q.target_design_key,jdbcType =VARCHAR}, #{q.target_psc,jdbcType =VARCHAR}, #{q.heat_no,jdbcType =VARCHAR}, #{q.batch_no,jdbcType =VARCHAR}, #{q.board_no,jdbcType =VARCHAR}, #{q.plan_no,jdbcType =VARCHAR}, #{q.ht_no,jdbcType =VARCHAR}, #{q.design_key,jdbcType =VARCHAR}, #{q.psc,jdbcType =VARCHAR}, #{q.fic_locking,jdbcType =VARCHAR}, #{q.sic_locking,jdbcType =VARCHAR}, #{q.pic_locking,jdbcType =VARCHAR}, #{q.dic_locking,jdbcType =VARCHAR}, #{q.lock_name,jdbcType =VARCHAR}, sysdate, #{q.psc_desc,jdbcType =VARCHAR}, #{q.pline_code,jdbcType =VARCHAR}, #{q.pline_name,jdbcType =VARCHAR}, #{q.cic_locking,jdbcType =VARCHAR}, #{q.prod_code,jdbcType =VARCHAR}, #{q.prod_name,jdbcType =VARCHAR}, #{q.steel_code,jdbcType =VARCHAR}, #{q.steel_name,jdbcType =VARCHAR}, #{q.std_code,jdbcType =VARCHAR}, #{q.std_name,jdbcType =VARCHAR}, #{q.lock_id,jdbcType =VARCHAR}, #{q.reason_code,jdbcType =VARCHAR}, #{q.reason_desc,jdbcType =VARCHAR}, #{q.flaw_code,jdbcType =VARCHAR}, #{q.flaw_desc,jdbcType =VARCHAR}, #{q.lock_name,jdbcType =VARCHAR}, #{q.unlock_name,jdbcType =VARCHAR}, sysdate, #{q.check_remarks,jdbcType =VARCHAR}, #{q.fix_remarks,jdbcType =VARCHAR}, #{q.height,jdbcType =VARCHAR}, insert into qcm_judge_locking_apply apply_id, material_no, lock_seq, lock_type_code, lock_type_desc, lock_memo, unlock_type_code, unlock_type_desc, unlock_memo, heat_no, batch_no, board_no, plan_no, ht_no, design_key, psc, psc_desc, pline_code, pline_name, prod_code, prod_name, steel_code, steel_name, std_code, std_name, lock_id, create_id, create_name, create_time, height, cancel_name, cancel_time, cancel_memo, status, check_name, check_time, values #{q.apply_id,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.lock_seq,jdbcType =NUMERIC}, #{q.lock_type_code,jdbcType =VARCHAR}, #{q.lock_type_desc,jdbcType =VARCHAR}, #{q.lock_memo,jdbcType =VARCHAR}, #{q.unlock_type_code,jdbcType =VARCHAR}, #{q.unlock_type_desc,jdbcType =VARCHAR}, #{q.unlock_memo,jdbcType =VARCHAR}, #{q.heat_no,jdbcType =VARCHAR}, #{q.batch_no,jdbcType =VARCHAR}, #{q.board_no,jdbcType =VARCHAR}, #{q.plan_no,jdbcType =VARCHAR}, #{q.ht_no,jdbcType =VARCHAR}, #{q.design_key,jdbcType =VARCHAR}, #{q.psc,jdbcType =VARCHAR}, #{q.psc_desc,jdbcType =VARCHAR}, #{q.pline_code,jdbcType =VARCHAR}, #{q.pline_name,jdbcType =VARCHAR}, #{q.prod_code,jdbcType =VARCHAR}, #{q.prod_name,jdbcType =VARCHAR}, #{q.steel_code,jdbcType =VARCHAR}, #{q.steel_name,jdbcType =VARCHAR}, #{q.std_code,jdbcType =VARCHAR}, #{q.std_name,jdbcType =VARCHAR}, #{q.lock_id,jdbcType =VARCHAR}, #{q.create_id,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, sysdate, #{q.height,jdbcType =VARCHAR}, #{q.cancel_name,jdbcType =VARCHAR}, sysdate, #{q.cancel_memo,jdbcType =VARCHAR}, #{q.status,jdbcType =VARCHAR}, #{q.check_name,jdbcType =VARCHAR}, sysdate, update QCM_JUDGE_SURFACE_FLAW t set t.IS_REPAIR = #{flag} where t.SURFACE_ID = #{sufId} and t.FLAW_SEQ = #{FlawSeq} 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 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 }, status= #{qjl.status,jdbcType =VARCHAR}, apply_id = #{qjl.apply_id,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 MATERIAL_NO = #{qjl.material_no,jdbcType =VARCHAR } and LOCK_SEQ = #{qjl.lock_seq,jdbcType =VARCHAR } 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 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 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 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, apply_id = #{qjl.apply_id,jdbcType =VARCHAR }, 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 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} and material_no = #{qjl.material_no,jdbcType =VARCHAR} and lock_id = #{qjl.lock_id,jdbcType =VARCHAR} and unlock_type_code is null and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR } 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} and heat_no = #{qjl.heat_no,jdbcType =VARCHAR} and material_no = #{qjl.material_no,jdbcType =VARCHAR} and unlock_type_code is null and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR } 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 }, apply_id = #{qjl.apply_id,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}, status= #{qjl.status,jdbcType =VARCHAR}, check_name= #{qjl.check_name,jdbcType =VARCHAR}, check_time= sysdate, unlock_result = #{qjl.unlock_result,jdbcType =VARCHAR} where 1= 1 and batch_no = #{qjl.batch_no,jdbcType =VARCHAR} and material_no = #{qjl.material_no,jdbcType =VARCHAR} and lock_id = #{qjl.lock_id,jdbcType =VARCHAR} and unlock_type_code is null and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR } 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} and material_no like #{qjl.material_no,jdbcType =VARCHAR} || '%' and lock_id = #{qjl.lock_id,jdbcType =VARCHAR} and unlock_type_code is null and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR } 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 and smp_no = #{q.smp_no,jdbcType =VARCHAR} and inspection_lot = #{q.inspection_lot,jdbcType =VARCHAR} and cic_id is not null 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 and smp_no = #{q.smp_no,jdbcType =VARCHAR} and inspection_lot = #{q.inspection_lot,jdbcType =VARCHAR} and phy_id is not null 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 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 qcm_judge_ultimate set JUDGE_NAME = null, JUDGE_TIME = null where UTM_ID = #{utm_id} update ZJ_RESULT_ALL@xgcx set CHEMRESULT_DESC = null, CHEMRESULT = '0', CHEMID = null, CIC_IS_LOCK = '0' where BILLETID_JY = #{inspection_lot} 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 QCM_JUDGE_COIL_RESULT set CHEMRESULT_DESC = null, CHEMRESULT = '0', CHEMID = null, CIC_IS_LOCK = '0' where INSPECTION_LOT = #{inspection_lot} update ZJ_RESULT_ALL@xgcx set JUDGERESULT = '0', JUDGERESULT_DESC = null, JUDGEID = null, billetid_jy = #{inspection_lot} where BILLETID = #{material_no} update QCM_JUDGE_COIL_RESULT set JUDGERESULT = '0', JUDGERESULT_DESC = null, JUDGEID = null, inspection_lot = #{inspection_lot} where coil_no = #{material_no} 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 ZJ_RESULT_ALL@xgcx set judgeresult_desc = #{judgeresult}, judgeresult = #{judgeresultid}, judgeid = #{CHEMID} where BILLETID = #{material_no} update QCM_JUDGE_COIL_RESULT set judgeresult_desc = #{judgeresult}, judgeresult = #{judgeresultid}, judgeid = #{utm_id} where coil_no = #{material_no} insert into QCM_JHY_SAMPLE_CONSIGN_M smp_no, heat_no, batch_no, inspection_lot, board_no, material_no, smp_catg, psc, psc_desc, cert_inst_code, cert_inst_name, smp_type_code, smp_type_name, grade_code, grade_name, pline_code, pline_name, validflag, memo, create_id, create_name, create_time, item_flag, values #{q.smp_no,jdbcType =VARCHAR}, #{q.heat_no,jdbcType =VARCHAR}, #{q.batch_no,jdbcType =VARCHAR}, #{q.inspection_lot,jdbcType =VARCHAR}, #{q.board_no,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.smp_catg,jdbcType =VARCHAR}, #{q.psc,jdbcType =VARCHAR}, #{q.psc_desc,jdbcType =VARCHAR}, #{q.cert_inst_code,jdbcType =VARCHAR}, #{q.cert_inst_name,jdbcType =VARCHAR}, #{q.smp_type_code,jdbcType =VARCHAR}, #{q.smp_type_name,jdbcType =VARCHAR}, #{q.grade_code,jdbcType =VARCHAR}, #{q.grade_name,jdbcType =VARCHAR}, #{q.pline_code,jdbcType =VARCHAR}, #{q.pline_name,jdbcType =VARCHAR}, #{q.validflag,jdbcType =VARCHAR}, #{q.memo,jdbcType =VARCHAR}, #{q.create_id,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, #{q.create_time,jdbcType =TIMESTAMP}, #{q.item_flag,jdbcType =VARCHAR}, insert into QCM_JHY_SAMPLE_CONSIGN_D smp_no, specimen_no, heat_no, batch_no, inspection_lot, board_no, material_no, freq_code, freq_name, smp_type_code, smp_type_name, consign_no, consign_no_seq, test_qty, smp_qty, smp_location, quote_consign_no, old_consign_no, pline_code, pline_name, status, validflag, source, guid, send_id, send_name, send_time, chem_item, product_cnt, create_time, smp_location_code, memo, weight, weight_std, weight_sfd, item_flag, send_memo, improve_memo, process_no, process_nos, artificial_memo, process_code, values #{q.smp_no,jdbcType =VARCHAR}, #{q.specimen_no,jdbcType =VARCHAR}, #{q.heat_no,jdbcType =VARCHAR}, #{q.batch_no,jdbcType =VARCHAR}, #{q.inspection_lot,jdbcType =VARCHAR}, #{q.board_no,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.freq_code,jdbcType =VARCHAR}, #{q.freq_name,jdbcType =VARCHAR}, #{q.smp_type_code,jdbcType =VARCHAR}, #{q.smp_type_name,jdbcType =VARCHAR}, #{q.consign_no,jdbcType =VARCHAR}, #{q.consign_no_seq,jdbcType =INTEGER}, #{q.test_qty,jdbcType =DECIMAL}, #{q.smp_qty,jdbcType= DECIMAL}, #{q.smp_location,jdbcType =VARCHAR}, #{q.quote_consign_no,jdbcType =VARCHAR}, #{q.old_consign_no,jdbcType =VARCHAR}, #{q.pline_code,jdbcType =VARCHAR}, #{q.pline_name,jdbcType =VARCHAR}, #{q.status,jdbcType =VARCHAR}, #{q.validflag,jdbcType =VARCHAR}, #{q.source,jdbcType =VARCHAR}, #{q.guid,jdbcType =VARCHAR}, #{q.send_id,jdbcType =VARCHAR}, #{q.send_name,jdbcType =VARCHAR}, sysdate, #{q.chem_item,jdbcType =VARCHAR}, #{q.product_cnt,jdbcType =VARCHAR}, #{q.create_time,jdbcType =TIMESTAMP}, #{q.smp_location_code,jdbcType =VARCHAR}, #{q.memo,jdbcType =VARCHAR}, #{q.weight,jdbcType =VARCHAR}, #{q.weight_std,jdbcType =VARCHAR}, #{q.weight_sfd,jdbcType =VARCHAR}, #{q.item_flag,jdbcType =VARCHAR}, #{q.send_memo,jdbcType =VARCHAR}, #{q.improve_memo,jdbcType =VARCHAR}, #{q.process_no,jdbcType =VARCHAR}, #{q.process_nos,jdbcType =VARCHAR}, #{q.artificial_memo,jdbcType =VARCHAR}, #{q.process_code,jdbcType =VARCHAR}, insert into QCM_JHY_SAMPLE_CONSIGN_D_ITEM specimen_no, seq, smp_no, phy_name_l, phy_code_l, phy_code_m, phy_name_m, phy_code_s, phy_name_s, item_code_d, item_name_d, item_code_t, item_name_t, item_code_s, item_name_s, isjudge, judge_basis, phy_unit, group_seq, quote_specimen_no, quote_seq, memo, item_code_l, item_desc_l, test_qty, smp_qty, create_time, create_id, create_name, specl_fl, item_flag, stdmemo, stdmin_sign, stdmin, stdmax_sign, stdmax, phy_group_code, resmp_seq values #{q.specimen_no,jdbcType =VARCHAR}, #{q.seq,jdbcType =INTEGER}, #{q.smp_no,jdbcType =VARCHAR}, #{q.phy_name_l,jdbcType =VARCHAR}, #{q.phy_code_l,jdbcType =VARCHAR}, #{q.phy_code_m,jdbcType =VARCHAR}, #{q.phy_name_m,jdbcType =VARCHAR}, #{q.phy_code_s,jdbcType =VARCHAR}, #{q.phy_name_s,jdbcType =VARCHAR}, #{q.item_code_d,jdbcType =VARCHAR}, #{q.item_name_d,jdbcType =VARCHAR}, #{q.item_code_t,jdbcType =VARCHAR}, #{q.item_name_t,jdbcType =VARCHAR}, #{q.item_code_s,jdbcType =VARCHAR}, #{q.item_name_s,jdbcType =VARCHAR}, #{q.isjudge,jdbcType =VARCHAR}, #{q.judge_basis,jdbcType =VARCHAR}, #{q.phy_unit,jdbcType =VARCHAR}, #{q.group_seq,jdbcType =VARCHAR}, #{q.quote_specimen_no,jdbcType =VARCHAR}, #{q.quote_seq,jdbcType =INTEGER}, #{q.memo,jdbcType =VARCHAR}, #{q.item_code_l,jdbcType =VARCHAR}, #{q.item_desc_l,jdbcType =VARCHAR}, #{q.test_qty,jdbcType = DECIMAL}, #{q.smp_qty,jdbcType= DECIMAL}, #{q.create_time,jdbcType =TIMESTAMP}, #{q.create_id,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, #{q.specl_fl,jdbcType =VARCHAR}, #{q.item_flag,jdbcType =VARCHAR}, #{q.stdmemo,jdbcType =VARCHAR}, #{q.stdmin_sign,jdbcType =VARCHAR}, #{q.stdmin,jdbcType =VARCHAR}, #{q.stdmax_sign,jdbcType =VARCHAR}, #{q.stdmax,jdbcType =VARCHAR}, #{q.phy_group_code,jdbcType =VARCHAR}, #{q.resmp_seq,jdbcType =VARCHAR}, insert into QCM_JHY_SAMPLE_R_ORD design_key, smp_no, psc, psc_desc, heat_no, batch_no, inspection_lot, delivery_state_code, delivery_state_desc, thick, width, length, pline_code, pline_name, msc_pline, process_code, cert_inst_code, cert_inst_name, smp_type_code, smp_type_name, smelting_cnt, product_cnt, assay_no_cp, assay_no_rl, cic_id, phy_id, judge_status, judge_result_code, judge_result_desc, judge_name, judge_time, judge_memo, prod_code, prod_name, steel_code, steel_name, std_code, std_name, create_time, create_id, create_name, item_flag, improve_memo, values #{q.design_key,jdbcType =VARCHAR}, #{q.smp_no,jdbcType =VARCHAR}, #{q.psc,jdbcType =VARCHAR}, #{q.psc_desc,jdbcType =VARCHAR}, #{q.heat_no,jdbcType =VARCHAR}, #{q.batch_no,jdbcType =VARCHAR}, #{q.inspection_lot,jdbcType =VARCHAR}, #{q.delivery_state_code,jdbcType =VARCHAR}, #{q.delivery_state_desc,jdbcType =VARCHAR}, #{q.thick,jdbcType =VARCHAR}, #{q.width,jdbcType =VARCHAR}, #{q.length,jdbcType =VARCHAR}, #{q.pline_code,jdbcType =VARCHAR}, #{q.pline_name,jdbcType =VARCHAR}, #{q.msc_pline,jdbcType =VARCHAR}, #{q.process_code,jdbcType =VARCHAR}, #{q.cert_inst_code,jdbcType =VARCHAR}, #{q.cert_inst_name,jdbcType =VARCHAR}, #{q.smp_type_code,jdbcType =VARCHAR}, #{q.smp_type_name,jdbcType =VARCHAR}, #{q.smelting_cnt,jdbcType =DECIMAL}, #{q.product_cnt,jdbcType =DECIMAL}, #{q.assay_no_cp,jdbcType =VARCHAR}, #{q.assay_no_rl,jdbcType =VARCHAR}, #{q.cic_id,jdbcType =VARCHAR}, #{q.phy_id,jdbcType =VARCHAR}, #{q.judge_status,jdbcType =VARCHAR}, #{q.judge_result_code,jdbcType =VARCHAR}, #{q.judge_result_desc,jdbcType =VARCHAR}, #{q.judge_name,jdbcType =VARCHAR}, #{q.judge_time,jdbcType =TIMESTAMP}, #{q.judge_memo,jdbcType =VARCHAR}, #{q.prod_code,jdbcType =VARCHAR}, #{q.prod_name,jdbcType =VARCHAR}, #{q.steel_code,jdbcType =VARCHAR}, #{q.steel_name,jdbcType =VARCHAR}, #{q.std_code,jdbcType =VARCHAR}, #{q.std_name,jdbcType =VARCHAR}, #{q.create_time,jdbcType =TIMESTAMP}, #{q.create_id,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, #{q.item_flag,jdbcType =VARCHAR}, #{q.improve_memo,jdbcType =VARCHAR}, insert into QCM_JHY_INSP_PHYSICS specimen_no, seq, test_qty, phy_code_l, phy_name_l, phy_code_m, phy_name_m, phy_code_s, phy_name_s, item_code_d, item_name_d, item_code_t, item_name_t, item_code_s, item_name_s, val1, val2, val3, val4, val5, val6, val7, val8, val9, val10, val11, val12, val13, val14, val15, avg_val, create_name, create_time, group_seq, defect_flag, max_val, min_val, item_code_l, item_desc_l, phy_unit, memo, values #{q.specimen_no,jdbcType =VARCHAR}, #{q.seq,jdbcType =INTEGER}, #{q.test_qty,jdbcType =DECIMAL}, #{q.phy_code_l,jdbcType =VARCHAR}, #{q.phy_name_l,jdbcType =VARCHAR}, #{q.phy_code_m,jdbcType =VARCHAR}, #{q.phy_name_m,jdbcType =VARCHAR}, #{q.phy_code_s,jdbcType =VARCHAR}, #{q.phy_name_s,jdbcType =VARCHAR}, #{q.item_code_d,jdbcType =VARCHAR}, #{q.item_name_d,jdbcType =VARCHAR}, #{q.item_code_t,jdbcType =VARCHAR}, #{q.item_name_t,jdbcType =VARCHAR}, #{q.item_code_s,jdbcType =VARCHAR}, #{q.item_name_s,jdbcType =VARCHAR}, #{q.val1,jdbcType =VARCHAR}, #{q.val2,jdbcType =VARCHAR}, #{q.val3,jdbcType =VARCHAR}, #{q.val4,jdbcType =VARCHAR}, #{q.val5,jdbcType =VARCHAR}, #{q.val6,jdbcType =VARCHAR}, #{q.val7,jdbcType =VARCHAR}, #{q.val8,jdbcType =VARCHAR}, #{q.val9,jdbcType =VARCHAR}, #{q.val10,jdbcType =VARCHAR}, #{q.val11,jdbcType =VARCHAR}, #{q.val12,jdbcType =VARCHAR}, #{q.val13,jdbcType =VARCHAR}, #{q.val14,jdbcType =VARCHAR}, #{q.val15,jdbcType =VARCHAR}, #{q.avg_val,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, #{q.create_time,jdbcType =TIMESTAMP}, #{q.group_seq,jdbcType =VARCHAR}, #{q.defect_flag,jdbcType =VARCHAR}, #{q.max_val,jdbcType =VARCHAR}, #{q.min_val,jdbcType =VARCHAR}, #{q.item_code_l,jdbcType =VARCHAR}, #{q.item_desc_l,jdbcType =VARCHAR}, #{q.phy_unit,jdbcType =VARCHAR}, #{q.memo,jdbcType =VARCHAR}, insert into QCM_JUDGE_ULTIMATE_SENDINFO guid, material_no, design_key, send_flag, result_type, judge_id, memo, create_id, create_name, create_time, values #{q.guid,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.design_key,jdbcType =VARCHAR}, #{q.send_flag,jdbcType =VARCHAR}, #{q.result_type,jdbcType =VARCHAR}, #{q.judge_id,jdbcType =VARCHAR}, #{q.memo,jdbcType =VARCHAR}, #{q.create_id,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, sysdate, insert into QCM_JUDGE_LOG judge_type, material_no, create_name, create_time, material_type, prod_line, values #{q.judge_type,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, sysdate, #{q.material_type,jdbcType =VARCHAR}, #{q.prod_line,jdbcType =VARCHAR}, insert into QCM_JUDGE_OPERATE_LOG guid, operate_type, operate_name, operate_time, params, prod_line, operation_interface, batchno, judge_result, memo, values #{q.guid,jdbcType =VARCHAR}, #{q.operate_type,jdbcType =VARCHAR}, #{q.operate_name,jdbcType =VARCHAR}, sysdate, #{q.params,jdbcType =VARCHAR}, #{q.prod_line,jdbcType =VARCHAR}, #{q.operation_interface,jdbcType =VARCHAR}, #{q.batchno,jdbcType =VARCHAR}, #{q.judge_result,jdbcType =VARCHAR}, #{q.memo,jdbcType =VARCHAR}, update qcm_jhy_insp_elements assay_no=#{q.a_assay_no}, heat_no=#{q.a_heat_no}, 1=1 AND assay_no=#{q.b_assay_no} AND heat_no=#{q.b_heat_no} AND pline_code=#{q.pline_code} update qcm_judge_ultimate utm_memo=#{q.utm_memo}, 1=1 AND utm_id=#{q.utm_id} insert into QCM_JHY_ELEMENTS_EDIT_LOG b_heat_no, b_assay_no, a_heat_no, a_assay_no, create_name, create_time, pline_code, h, o, values #{q.b_heat_no,jdbcType =VARCHAR}, #{q.b_assay_no,jdbcType =VARCHAR}, #{q.a_heat_no,jdbcType =VARCHAR}, #{q.a_assay_no,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, sysdate, #{q.pline_code,jdbcType =VARCHAR}, #{q.h,jdbcType =VARCHAR}, #{q.o,jdbcType =VARCHAR}, insert into qcm_judge_gpinfo gp_id, material_no, steel_name, thick, width, length, orderno, gp_name, gp_time, old_orderno, weight, prod_line, gp_steel_name, gp_type, values #{q.gp_id,jdbcType =VARCHAR}, #{q.material_no,jdbcType =VARCHAR}, #{q.steel_name,jdbcType =VARCHAR}, #{q.thick,jdbcType =VARCHAR}, #{q.width,jdbcType =VARCHAR}, #{q.length,jdbcType =VARCHAR}, #{q.orderno,jdbcType =VARCHAR}, #{q.gp_name,jdbcType =VARCHAR}, sysdate, #{q.old_orderno,jdbcType =VARCHAR}, #{q.weight,jdbcType =VARCHAR}, #{q.prod_line,jdbcType =VARCHAR}, #{q.gp_steel_name,jdbcType =VARCHAR}, #{q.gp_type,jdbcType =VARCHAR}, update ZJ_RESULT_ALL@xgcx set PIC_IS_LOCK = '1' where BILLETID = #{material_no} AND JUDGERESULT = '0' 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} and material_no = #{qjl.material_no,jdbcType =VARCHAR} and unlock_type_code is null and LOCK_TYPE_CODE = #{qjl.lock_type_code,jdbcType =VARCHAR } update ZJ_RESULT_ALL@xgcx set billetid_jy = #{inspection_lot},PHYSRESULT='0',PHYSRESULT_DESC='',PHYSID='' where BILLETID = #{material_no} and JUDGERESULT='0'