XinYu_RZMES/.svn/pristine/da/dab8841e0923352b2978b3577f2df1a50262d4e4.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH010040_01.select" desc="查询能耗和停轧数据" fetchSize="10">
		<![CDATA[
      SELECT  MQ,DIAN,SHUI,KQ,GH,JIXIE,DQ,ZG,HG,JIANXIU,WB,YC,RL,TZ  FROM 
      (SELECT LOG_VALUE MQ FROM TBH01_COIL_OUT WHERE LOG_SORT = '1' AND DTIME = ? AND LOG_GROUP = ?)A,
      (SELECT LOG_VALUE DIAN FROM TBH01_COIL_OUT WHERE LOG_SORT = '2' AND DTIME = ? AND LOG_GROUP = ?)B,           
      (SELECT LOG_VALUE SHUI FROM TBH01_COIL_OUT WHERE LOG_SORT = '3' AND DTIME = ? AND LOG_GROUP = ?)C,
      (SELECT LOG_VALUE KQ FROM TBH01_COIL_OUT WHERE LOG_SORT = '4' AND DTIME = ? AND LOG_GROUP = ?)D,  
      (SELECT LOG_VALUE GH FROM TBH01_COIL_OUT WHERE LOG_SORT = '5' AND DTIME = ? AND LOG_GROUP = ?)E,   
      (SELECT LOG_VALUE JIXIE FROM TBH01_COIL_OUT WHERE LOG_SORT = '6' AND DTIME = ? AND LOG_GROUP = ?)F,    
      (SELECT LOG_VALUE DQ FROM TBH01_COIL_OUT WHERE LOG_SORT = '7' AND DTIME = ? AND LOG_GROUP = ?)G, 
      (SELECT LOG_VALUE ZG FROM TBH01_COIL_OUT WHERE LOG_SORT = '8' AND DTIME = ? AND LOG_GROUP = ?)H,
      (SELECT LOG_VALUE HG FROM TBH01_COIL_OUT WHERE LOG_SORT = '9' AND DTIME = ? AND LOG_GROUP = ?)I,
      (SELECT LOG_VALUE JIANXIU FROM TBH01_COIL_OUT WHERE LOG_SORT = '10' AND DTIME = ? AND LOG_GROUP = ?)J,
      (SELECT LOG_VALUE WB FROM TBH01_COIL_OUT WHERE LOG_SORT = '11' AND DTIME = ? AND LOG_GROUP = ?)K,
      (SELECT LOG_VALUE YC FROM TBH01_COIL_OUT WHERE LOG_SORT = '12' AND DTIME = ? AND LOG_GROUP = ?)L,
      (SELECT LOG_VALUE RL FROM TBH01_COIL_OUT WHERE LOG_SORT = '13' AND DTIME = ? AND LOG_GROUP = ?)M,
      (SELECT LOG_VALUE TZ FROM TBH01_COIL_OUT WHERE LOG_SORT = '14' AND DTIME = ? AND LOG_GROUP = ?)N
		]]>
	</query>
	<query id="UIH010040_02.select" desc="查询记录是否存在" fetchSize="10">
		<![CDATA[
			SELECT A.DTIME,A.LOG_SORT,A.LOG_GROUP FROM TBH01_COIL_OUT A WHERE A.DTIME = ? AND A.LOG_GROUP = ? AND A.LOG_SORT = ? 
		]]>
	</query>
	<query id="UIH010040_01.insert" desc="" fetchSize="10">
		<![CDATA[
			INSERT INTO TBH01_COIL_OUT (
            DTIME,
            LOG_SORT,
            LOG_GROUP,
            LOG_VALUE,
            LOG_REG,
            LOG_DTIME   
       )VALUES(?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD'))
		]]>
	</query>
	<query id="UIH010040_01.update" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBH01_COIL_OUT A SET 
				   A.LOG_VALUE = ?,
				   A.MOD = ?,
				   A.MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') 
				   
				   WHERE A.DTIME = ? AND A.LOG_SORT = ? AND A.LOG_GROUP = ? 
		]]>
	</query>
</queryMap>