XinYu_RZMES/.svn/pristine/a9/a97b6020a148ce859f80854de56364b8d9a43915.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="班次班组信息">
  
     <query id="UIB030204_01.SELECT" desc="" fetchSize="10">  
        <![CDATA[
			SELECT * FROM TBB02_HIS_DCS  HIS  WHERE HIS.REG_DTIME BETWEEN  ?  AND ?   ORDER BY  HIS.MATERIAL_NO 
        ]]>   
    </query> 

	<query id="UIB030204_02.SELECT" desc="">
		SELECT * FROM TBB02_HIS_DCS  HIS  WHERE HIS.REG_DTIME BETWEEN  ?  AND ?  AND SUBSTR(HIS.MATERIAL_NO ,1,10) BETWEEN ? AND ? ORDER BY  HIS.MATERIAL_NO 
	</query>
</queryMap>