XinYu_RZMES/.svn/pristine/ad/adfc4a144a5ac265322006f7f6362e73730ccb02.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="">
    <query id="NIB027070_01.select" desc="查询实绩材质信息" fetchSize="10">  
        <![CDATA[
            select SMP_NO from TBB02_WORK_QLTY 
			where SMP_NO = ? and SMP_CUT_LOC = ? and QLTY_CD = ?
        ]]>   
    </query>
    <query id="NIB027070_01.update" desc="更新实绩材质信息" fetchSize="10">  
        <![CDATA[
            update TBB02_WORK_QLTY set QLTY_VAL_WK = ?,QLTY_UNIT_WK = ?,QLTY_TYPE_WK = ?
            where SMP_NO = ? and SMP_CUT_LOC = ? and QLTY_CD = ?
        ]]>   
    </query>
	
	<query id="NIB027070_01.insert" desc="插入实绩材质信息" fetchSize="10">  
        <![CDATA[
           INSERT INTO TBB02_WORK_QLTY
           (SMP_NO,SMP_CUT_LOC,QLTY_CD,QLTY_VAL_WK,QLTY_UNIT_WK,QLTY_TYPE_WK) 
			VALUES(?,?,?,?,?,?)    
		]]>   
    </query>
	
	<query id="NIB027071" desc="" fetchSize="10">  
        <![CDATA[
			{call NIB027071(?,?,?,?)}
        ]]>   
    </query>
		 
</queryMap>