XinYu_RZMES/.svn/pristine/e2/e24b59bcda596ffffb8629b86824ac721e7b8a4f.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH040010_01.select" desc="查询出轧辊状态不为D的" fetchSize="10">
		<![CDATA[
			select ROLL_NO,
       				ROLL_STAT,
					ROLL_TYPE,
					ROLL_MAKER,
					ROLL_MAT_QLTY,
					ROLL_UCOST,
					ENT_DIA,
					DISUSE_DIA,
					ROLL_LEN,
					ROLL_MAKER,
					ENT_DTIME,
					ROLL_SHAPE_CD,
					SONIC_SIGHT,
					LEN_TOL,
					SURFACE_TREAT_TYPE,
					ENT_ROLL_WKSHIFT,
					ENT_ROLL_WKSGROUP,
					ROLL_ENT_EMP_ID 
         				from tbh04_roll 
						   where ROLL_STAT<>'d' 
							 and ROLL_STAT<>'D' 
							 and ROLL_NO LIKE ?||'%'
							 order by ROLL_NO desc
		]]>
	</query>
	<query id="UIH040010_01.update" desc="" >
		<![CDATA[
			update tbh04_roll set 
				ROLL_TYPE =?,
				ROLL_MAKER =?,
				ROLL_UCOST =?,
				ENT_DIA =?,
				DISUSE_DIA =?,
				ROLL_LEN =?,
				ENT_DTIME =?,
				ENT_ROLL_WKSHIFT =?,
				ENT_ROLL_WKSGROUP =?,
				ROLL_ENT_EMP_ID =?,
				ROLL_MAT_QLTY = ?,
				SONIC_SIGHT = ?,
				SURFACE_TREAT_TYPE = ?,
				LEN_TOL = ?,
				ROLL_SHAPE_CD = ?,
				CUR_DIA = ? ,
				BEF_DIA = ?
			where ROLL_NO=?
		]]>
	</query>
	<query id="UIH040010_01.insert" desc="" >
		<![CDATA[
			insert into tbh04_roll 
			(
				ROLL_NO,
				ROLL_TYPE,
				ROLL_MAKER,
				ROLL_UCOST,
				ENT_DIA,
				DISUSE_DIA,
				ROLL_LEN,
				ENT_DTIME,
				ENT_ROLL_WKSHIFT,
				ENT_ROLL_WKSGROUP,
				ROLL_ENT_EMP_ID,
				ROLL_MAT_QLTY,
				SONIC_SIGHT,
				SURFACE_TREAT_TYPE,
				LEN_TOL,
				ROLL_SHAPE_CD,
				ROLL_STAT ,
				CUR_DIA ,
				BEF_DIA
			)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'I',?,?)
		]]>
	</query>
   <query id="UIH040010_delete" desc="删除录入错误的轧辊" fetchSize="10">
		<![CDATA[
			delete tbh04_roll where roll_no = ?
		]]>
	</query>
</queryMap>