XinYu_RZMES/.svn/pristine/f8/f8ce6087c7ebc5531e9c82eb97ddff33cccbb952.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH050400_01.init" desc="初始化区域,这里只初始化堆放中厚板的区域。暂时定位R1-R2,每个垛位放20块">
        <![CDATA[
		  /***
			SELECT DISTINCT YARD_CLF LABEL,YARD_CLF VALUE FROM tbh05_coil_yard WHERE YARD_CLF LIKE 'C1%' OR YARD_CLF LIKE 'C3%' OR YARD_CLF LIKE 'C2%' order by YARD_CLF
          *****/
			SELECT DISTINCT YARD_CLF LABEL,YARD_CLF VALUE FROM tbh05_coil_yard WHERE YARD_CLF LIKE 'R%' order by YARD_CLF
		]]>
    </query>
	<query id="UIH050400_01.select" desc="查询钢卷号在库区表中是否存在,现在废弃不用">
        <![CDATA[
		  SELECT coil_no FROM tbh02_coil_comm WHERE coil_no = ? 
        ]]>
    </query>
    <query id="UIH050400_02.select" desc="查询生产板坯号在库存表中是否存在，这里板坯号存储在钢卷号字段中">
        <![CDATA[
			SELECT yard_clf||step_clf coil_yard FROM tbh05_coil_yard WHERE coil_no = ? 
        ]]>
    </query>
	<query id="UIH050400_04.select" desc="查询堆放位置上是否已经存在板坯信息">
        <![CDATA[
			SELECT coil_no FROM tbh05_coil_yard WHERE yard_clf||step_clf = ? 
        ]]>
    </query>
    <query id="UIH050400_03.select" desc="查询库存区域">
        <![CDATA[
			/*****
				SELECT YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ COIL_YARD,
				  COIL_NO OLD_SAMPL_NO,
				  '' CHK,
			      '' COIL_NO,
				  '' COIL_OUTDIA,
			      '' COIL_THK,
			      '' COIL_WTH,
			      '' ACT_WGT,
			      '' STL_GRD,
			      '' SMP_DIR_PIC_YN,
			      '' TOT_DEC_GRD,
			      '' REG_ID 
              FROM tbh05_coil_yard 
      WHERE yard_clf LIKE ?||'%'
			******/
			select a.yard_clf||a.step_clf COIL_YARD, 
			 '' CHK,
             b.slab_no,
             b.old_sampl_no,
             b.COIL_OUTDIA,
             b.COIL_THK,
			 b.COIL_WTH,
			 b.ACT_WGT,
			 b.STL_GRD,
			 b.SMP_DIR_PIC_YN,
			 b.TOT_DEC_GRD,
			 a.reg_id  
       from tbh05_coil_yard a,tbh02_coil_comm b 
       where a.coil_no = b.slab_no(+) and a.yard_clf like ?||'%'
       order by COIL_YARD
        ]]>
    </query>
    <query id="UIH050400_02.update" desc="">
        <![CDATA[
                  update tbh05_coil_yard set
					      COIL_NO = ?,
						  REG_ID = ?,
                          REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD') 
                   where YARD_CLF||STEP_CLF = ? 
        ]]>
    </query>
    <query id="UIH050400_02.insert" desc="废弃 ">
        <![CDATA[
			insert into tbh02_coil_comm 
			(COIL_NO,
			  OLD_SAMPL_NO,
			  COIL_OUTDIA,
			  ACT_WGT,
			  STL_GRD,
		      SMP_DIR_PIC_YN,
		      TOT_DEC_GRD,
			  COIL_THK,
			  COIL_WTH,
			  CUR_LOAD_LOC,
			  CUR_LOAD_LOC_DTIME,
			  COIL_STAT   
			)VALUES(?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),'2')
        ]]>
    </query>
    <query id="UIH050400_01.insert" desc="新增废弃轧坯的堆放位置">
        <![CDATA[
			insert into tbh05_coil_yard 
			(YARD_CLF,
			  STEP_CLF,
			  STORELAY,
			  STORE_SEQ,
			  COIL_NO,
		      CR_NO,
		      REG_ID,
			  REG_DTIME,
			  RESERV_FL  
			)VALUES(?,?,'0','0','','','','','')
        ]]>
    </query>
    <query id="UIH050400_01.update" desc="废弃，不使用">
        <![CDATA[
			update tbh02_coil_comm set
					    OLD_SAMPL_NO = ?,
						COIL_OUTDIA = ?,
                        ACT_WGT = ?,
                        STL_GRD = ?,
                        SMP_DIR_PIC_YN = ?,
                        TOT_DEC_GRD = ?,
					    COIL_THK = ?,
			            COIL_WTH = ?,
						CUR_LOAD_LOC = ?,
						CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
                        BEF_LOAD_LOC = CUR_LOAD_LOC,
                        BEF_LOAD_LOC_DTIME = CUR_LOAD_LOC_DTIME, 
			            COIL_STAT = '2'   
			              where COIL_NO = ? 
        ]]>
    </query>
    <query id="UIH050400_03.update" desc="删除">
        <![CDATA[
                  delete tbh05_coil_yard where yard_clf||step_clf = ?
        ]]>
    </query>
</queryMap>