XinYu_RZMES/.svn/pristine/1b/1b6f88d806ff962ce6169279d3de1a1f36a7e272.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH050600_02.select" desc="查询钢卷在库信息">
        <![CDATA[
			select b.COIL_NO,
       a.INSTR_COIL_THK||'*'||a.INSTR_COIL_WTH t_w,
       a.ACT_WGT,
       A.CAL_WGT,
       A.YARD_ENTRY_REG,
       A.YARD_ENTRY_DTIME,
       DECODE(a.TOT_DEC_GRD,'1','合格','2','不合格',null,'待判定') TOT_DEC_GRD,
       A.SPEC_STL_GRD,
       decode(a.CUR_PROG_CD,'SED','判定待机','SFA','发货待机','SFB','运送待机','SFF','发货完成') CUR_PROG_CD  
       from tbh02_coil_comm a,tbh05_coil_yard b where a.OLD_SAMPL_NO(+) = b.COIL_NO 
			and b.YARD_CLF||B.STEP_CLF||B.STORELAY||B.STORE_SEQ = ? 
       order by b.YARD_CLF,B.STEP_CLF,B.STORELAY,B.STORE_SEQ   
		]]>
    </query>
		<query id="UIH050600_01.select" desc="查询钢卷入库信息">
        <![CDATA[
      select A.COIL_NO from tbh02_coil_comm a 
        where  a.OLD_SAMPL_NO = ?
               AND A.COIL_STAT = '2' 
		]]>
    </query>
	<query id="UIH050600_03.select" desc="查询钢卷出库信息">
        <![CDATA[
			select A.COIL_NO from tbh05_coil_yard a 
				where  a.COIL_NO = ? 
		]]>
    </query>
	<query id="UIH050600_04.select" desc="查询钢卷的实际垛位">
        <![CDATA[
      select A.YARD_CLF||a.STEP_CLF||a.STORELAY||a.STORE_SEQ COIL_YARD from tbh05_coil_yard a 
        where  a.COIL_NO = ?
		]]>
    </query>
	<query id="UIH050600_05.select" desc="查询这里垛位上面是否有卷">
        <![CDATA[
			select coil_no from tbh05_coil_yard a 
				where a.yard_clf||a.step_clf||a.storelay||a.store_seq = ?
		]]>
    </query>
	<query id="UIH050600_06.select" desc="查询这里垛位上面是否有卷">
        <![CDATA[
			SELECT A.MILL_DTIME FROM TBH02_COIL_COMM A WHERE A.OLD_SAMPL_NO = ? 
		]]>
    </query>
	<query id="UIH050600_01.update" desc="入库">
        <![CDATA[
			update tbh05_coil_yard set
              COIL_NO = ?,
              REG_ID  = ?,
              REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
                    where YARD_CLF = substr(?,0,5) 
                    and STEP_CLF = substr(?,6,2)
                    and STORELAY = substr(?,8,1)
                    and STORE_SEQ = substr(?,9,1) 
		]]>
    </query>
	<query id="UIH050600_02.update" desc="把钢卷数据出库">
        <![CDATA[
			update tbh05_coil_yard set
			  COIL_NO = '',
              REG_ID  = ?,
              REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
                    where YARD_CLF =  substr(?,0,5) 
                    and STEP_CLF = substr(?,6,2)
                    and STORELAY =substr(?,8,1)
                    and STORE_SEQ = substr(?,9,1)
		]]>
    </query>
	<query id="UIH050600_03.update" desc="把钢卷数据出库">
        <![CDATA[
			        update tbh02_coil_comm set
							  CUR_LOAD_LOC = ?,
							  ACT_WGT = ?,
							  YARD_ENTRY_REG  = ?,
							  YARD_ENTRY_DTIME = ?,
							  YARD_ENTRY_SHIFT = ?,
							  YARD_ENTRY_GROUP = ?,
							  YARD_ENTRY_USE_TIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
							  where OLD_SAMPL_NO = ? 
		]]>
    </query>
	<query id="UIH050600_04.update" desc="入库钢卷更新卷重">
        <![CDATA[
			        update tbh02_coil_comm set
			  ACT_WGT = ?,
              WGT_REG  = ?,
              WGT_TIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
                    where OLD_SAMPL_NO = ? 
		]]>
    </query>
	<query id="UIH050600_05.update" desc="入库操作记录数据">
        <![CDATA[
             update tbh02_coil_comm set
                CUR_LOAD_LOC = ?,
                CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
                YARD_ENTRY_SHIFT = ?,
                YARD_ENTRY_GROUP = ?,
                YARD_ENTRY_REG  = ?,
                YARD_ENTRY_DTIME = ?,
                YARD_ENTRY_USE_REG = ?,
                YARD_ENTRY_USE_TIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
             -- SHIP_PROG_CD = ''
                where OLD_SAMPL_NO = ? 
		]]>
    </query>
	<query id="UIH050600_06.update" desc="清库">
        <![CDATA[
			        update tbh02_coil_comm set
              CUR_LOAD_LOC = '',
              REG_ID  = ?,
              REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
                    where OLD_SAMPL_NO = ? 
		]]>
    </query>
</queryMap>