XinYu_RZMES/.svn/pristine/75/75abae3cd083dfc4222ed18c7a121aaf5207573e.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH051300_01_SELECT" desc=" 预装车查询 " fetchSize="10">
        <![CDATA[
            SELECT '' CHK,A.OLD_SAMPL_NO,A.ACT_WGT,A.COIL_THK||'*'||A.COIL_WTH T_W,A.ORD_NO,A.ORD_SEQ
      ,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','','待判定') TOT_DEC_GRD
    ,DECODE(A.CUR_PROG_CD,'SFA','发货指示待机','SED','判定待机','SRC','充当待机') CUR_PROG_CD
    ,A.CUR_LOAD_LOC
    ,A.INSTR_COIL_THK||'*'||A.INSTR_COIL_WTH IT_IW 
    FROM TBH02_COIL_COMM A 
    WHERE A.COIL_STAT = '2'  
    AND A.OLD_SAMPL_NO LIKE ?||'%'
    AND A.OLD_SAMPL_NO IS NOT NULL
    ORDER BY A.OLD_SAMPL_NO
        ]]>
    </query> 
	<query id="UIH051300_02_SELECT" desc=" 预装车查询 " fetchSize="10">
        <![CDATA[
            SELECT '' CHK,A.OLD_SAMPL_NO,A.ACT_WGT,A.COIL_THK||'*'||A.COIL_WTH T_W,A.ORD_NO,A.ORD_SEQ
      ,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','','待判定') TOT_DEC_GRD
	  ,DECODE(A.CUR_PROG_CD,'SFA','发货指示待机','SED','判定待机','SRC','充当待机') CUR_PROG_CD
	  ,A.CUR_LOAD_LOC
	  ,A.INSTR_COIL_THK||'*'||A.INSTR_COIL_WTH IT_IW 
	  FROM TBH02_COIL_COMM A 
	  WHERE A.COIL_STAT = '4'  
	  AND A.OLD_SAMPL_NO IS NOT NULL
	  ORDER BY A.YZCS_DTIME  DESC 
        ]]>
    </query> 
	<query id="UIH051300_04_SELECT" desc=" 预装车查询 统计 " fetchSize="10">
        <![CDATA[
            SELECT count(*) COIL_CNT,
				nvl(sum(a.act_wgt)/1000,0) COIL_WGT 
			FROM TBH02_COIL_COMM A 
			WHERE A.COIL_STAT = '2'  
			AND A.OLD_SAMPL_NO LIKE ?||'%'
			AND A.OLD_SAMPL_NO IS NOT NULL
			ORDER BY A.OLD_SAMPL_NO
        ]]>
    </query> 
	<query id="UIH051300_05_SELECT" desc=" 预装车查询 统计 " fetchSize="10">
        <![CDATA[
            SELECT  count(*) COIL_CNT,
 				   nvl(sum(a.act_wgt)/1000,0) COIL_WGT 
				FROM TBH02_COIL_COMM A 
				WHERE A.COIL_STAT = '4'  
				AND A.OLD_SAMPL_NO IS NOT NULL
				ORDER BY A.YZCS_DTIME  DESC 
        ]]>
    </query> 
	<query id="UIH051300_03_SELECT" desc=" 预装车查询 " fetchSize="10">
        <![CDATA[
			   SELECT T.COIL_NO FROM TBH05_COIL_YARD T WHERE T.YARD_CLF||T.STEP_CLF||T.STORELAY||T.STORE_SEQ = ? 
        ]]>
    </query> 
	<query id="UIH051300_01.update" desc=" 预装车更新 " fetchSize="10">
        <![CDATA[
			UPDATE TBH02_COIL_COMM A SET 
				   A.ACT_WGT = ?,
				   A.YZCS_REG = ?,
				   A.YZCS_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
				   A.CUR_LOAD_LOC = '',
				   A.COIL_STAT = '4' 
				   WHERE A.OLD_SAMPL_NO = ?  
        ]]>
    </query> 
	<query id="UIH051300_02.update" desc=" 预装车更新 " fetchSize="10">
        <![CDATA[
		UPDATE TBH05_COIL_YARD T SET 
              T.COIL_NO = '' 
              WHERE T.COIL_NO = ?   
        ]]>
    </query> 
	<query id="UIH051300_03.update" desc=" 预装车取消 " fetchSize="10">
        <![CDATA[
			UPDATE TBH02_COIL_COMM A SET 
 				  A.ACT_WGT = ?,
				   A.YZCC_REG = ?,
				   A.YZCC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
				   A.CUR_LOAD_LOC = ?,
				   A.COIL_STAT = '2' 
				   WHERE A.OLD_SAMPL_NO = ?
        ]]>
    </query>
	<query id="UIH051300_04.update" desc=" 预装车取消 " fetchSize="10">
        <![CDATA[
				UPDATE TBH05_COIL_YARD B SET 
                    B.COIL_NO = ? 
                    WHERE B.YARD_CLF = ?
                      AND B.STEP_CLF = ?
                      AND B.STORELAY = ?
                      AND B.STORE_SEQ = ? 
        ]]>
    </query>
</queryMap>