insert into QCM_ORD_DESIGN_SAMPLE_M smp_no, heat_no, batch_no, inspection_lot, board_no, material_no, 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, 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.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}, sysdate 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, 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}, #{q.send_time,jdbcType =VARCHAR}, #{q.chem_item,jdbcType =VARCHAR}, #{q.product_cnt,jdbcType =VARCHAR}, #{q.create_time,jdbcType =TIMESTAMP}, 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_, item_desc_l, test_qty, smp_qty, create_time, create_id, create_name, specl_fl, 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_,jdbcType =VARCHAR}, #{q.item_desc_l,jdbcType =VARCHAR}, #{q.test_qty,jdbcType =VARCHAR}, #{q.smp_qty,jdbcType =VARCHAR}, #{q.create_time,jdbcType =TIMESTAMP}, #{q.create_id,jdbcType =VARCHAR}, #{q.create_name,jdbcType =VARCHAR}, #{q.specl_fl,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, 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},