XinYu_LZMES/.svn/pristine/cf/cfddfb9e8d74b1cb87497340a9e4f881f6fa852d.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.JhySqlMapper">

<insert id="insertSampleM" parameterType = "QCM.JHY01.VO.JhySampleMMdoel">
	insert into QCM_ORD_DESIGN_SAMPLE_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.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>
			 
       </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.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>
			  sysdate
			  
       </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>
	
     
  
			 
       </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  " >#{q.send_time,jdbcType =VARCHAR},</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>

			  
       </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_,</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>
			 
       </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_,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 =VARCHAR},</if>
		      <if test = " q.smp_qty!= null  " >#{q.smp_qty,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.specl_fl!= null  " >#{q.specl_fl,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>
	      
       </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>
        
       </trim>
	
       
</insert>










</mapper>