XinYu_RZMES/.svn/pristine/6c/6c0b40e4e5d06eeadb6e6e29db8b8750f36454eb.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="热轧管理">
	<query id="UIF026010_01.INITSELECT" desc="标准钢号初始化，从标准成分处带来" fetchSize="10">
		SELECT      DISTINCT 
					SIR.SPEC_STL_GRD    LABEL
				  , SIR.SPEC_STL_GRD    VALUE
		FROM        TBB01_SPEC_INGR     SIR
		ORDER BY    SIR.SPEC_STL_GRD
	</query>
		<query id="UIF026010_01.INSERT" fetchSize="" desc="">
		INSERT   INTO   TBB01_MILL_TECH(  --规范代码录入
    	                SPEC_STL_GRD,
		                ORD_THK_MIN,
						ORD_THK_MAX,
						THK_MIN,
						THK_MAX,
						SEQ_NO 
		) VALUES(?,?,?,?,?,(SELECT NVL(MAX(SEQ_NO),0) + 1 FROM TBB01_MILL_TECH))
	</query>
	<query id="UIF026010_01.SELECT" desc="查询牌号" fetchSize="10">
		 SELECT DISTINCT T.SPEC_STL_GRD --规格钢号
    FROM tbb01_mill_tech T
   WHERE T.SPEC_STL_GRD = DECODE(?, NULL, T.SPEC_STL_GRD, ?)
   ORDER BY T.SPEC_STL_GRD
	</query>
	
   <query id="UIF026010_02.SELECT" desc="查询牌号" fetchSize="10">
		 SELECT t.ord_thk_min, t.ord_thk_max, t.thk_min, t.thk_max,t.seq_no --规格钢号
    FROM tbb01_mill_tech T
   WHERE T.SPEC_STL_GRD = ?
   ORDER BY T.ORD_THK_MIN asc
	</query>
	<query id="UIF026010_03.SELECT" desc="查询牌号" fetchSize="10">
		 SELECT * FROM (select get_tbf02_thkmin(?,?)  AA from dual)T WHERE T.AA IS NOT NULL
	</query>
	<query id="UIF026010_04.SELECT" desc="查询牌号" fetchSize="10">
		 SELECT * FROM (select get_tbf02_thkmax(?,?)  AA from dual)T WHERE T.AA IS NOT NULL
	</query>
	
	<query id="UIF026010_01.UPDATE" desc="数据更新" fetchSize="10">
		  	update tbb01_mill_tech t
      				set t.ord_thk_min = ?,
          				t.ord_thk_max = ?,
          				t.thk_min     = ?,
          				t.thk_max     = ?
    		where t.seq_no = ?
	</query>
	<query id="UIF026010_01.DELETE" desc="数据删除" fetchSize="10">
		  	delete tbb01_mill_tech t where T.SPEC_STL_GRD = ?
	</query>
	<query id="UIF026010_02.DELETE" desc="数据删除" fetchSize="10">
		  	delete tbb01_mill_tech t where T.SEQ_NO = ?
	</query>
</queryMap>