XinYu_RZMES/.svn/pristine/7e/7e1b3ac5de242655dce110e0646256abcd4c4455.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="UID040010">
	<query id="UID040010.SrcSlabDnRst.Select" desc="SearchSrcSlabDnRst">
        <![CDATA[
SELECT LEVEL
     , A.DSN_SLAB_NO, A.P_DSN_SLAB_NO
     , A.ORD_NO, A.ORD_SEQ
     , A.SLAB_THK, A.SLAB_WTH, A.SLAB_LEN, A.SLAB_WGT
     , A.SLAB_TRMTH_TP
     , A.FAC_STL_GRD, A.FAC_STL_GRP
     , A.COIL_THK, A.COIL_WTH, A.COIL_LEN, A.COIL_WGT
     , A.PROC_PATH
     , A.HCR_YN, A.EMGMTR_YN, A.COMB_YN
     , NULL AS ORD_DEVLMT_DATE
     ,'N'   AS SCARFING_PROC_YN                    
     ,'N'   AS SPM_PROC_YN                           
     ,'N'   AS CHK
     , A.GRAVITY
     , A.COIL_INDIA
     , A.COIL_OUTDIA
FROM TBD01_SLABDN_RST2 A
WHERE 1 = 1
AND A.PROC_STAT = '02'
AND A.FAC_STL_GRP LIKE :1||'%'
AND A.FAC_STL_GRD LIKE :2||'%'
AND A.SLAB_WTH BETWEEN NVL(:3,0) AND NVL(:4,999999)
AND A.COIL_THK BETWEEN NVL(:5,0) AND NVL(:6,999999)
START WITH 1 = 1
CONNECT BY PRIOR A.DSN_SLAB_NO = A.P_DSN_SLAB_NO
ORDER SIBLINGS BY A.SLAB_THK DESC, A.SLAB_WTH DESC, A.SLAB_LEN DESC
        ]]>
    </query>
	
	<query id="UID040010.AllMatDnRst.Select" desc="SearchAllMatDnRst">
        <![CDATA[
			SELECT LEVEL
				 , X.*
                 ,'N' AS CHK
			FROM TBD01_MATDN_RST3 X
			START WITH X.MAT_TP = :1
			CONNECT BY PRIOR X.MAT_SPEC_SEQ = X.PMAT_SPEC_SEQ
			ORDER SIBLINGS BY X.WITHIN_SUB_SEQ 
        ]]>
    </query>
	<query id="UID040010.pathProcCd.Select" desc="SearchAllMatDnRst">
    <![CDATA[
SELECT *
FROM (SELECT X.ORD_NO, X.ORD_SEQ, X.FAC_STL_GRD, X.ORD_USE_TP, Y.PATH_PROC_CD
           , ROW_NUMBER() OVER (ORDER BY X.REG_DTIME) AS RN
      FROM TBB01_ORD_HEAD X, TBB01_ORD_PROD Y
      WHERE X.ORD_NO = Y.ORD_NO
      AND X.ORD_SEQ = Y.ORD_SEQ
      AND X.FAC_STL_GRD = :1) A
WHERE A.RN = 1
	 ]]>
    </query>
	
	<query id="UID040010.facStlGrp.Select" desc="SearchAllMatDnRst">
    <![CDATA[
SELECT FAC_STL_GRP
FROM TBD00_STLGRD
WHERE FAC_STL_GRD = :1

	 ]]>
    </query>
	
	<query id="charge_slabdn_rst.insert2" desc="板坏设计结果插入">
        <![CDATA[
            INSERT INTO 
			TBD01_SLABDN_RST2(
			DSN_SLAB_NO,
            P_DSN_SLAB_NO,
			ORD_NO,
			ORD_SEQ,
			SLAB_THK,
			SLAB_WTH,
			SLAB_LEN,
			SLAB_WGT,
			SLAB_TRMTH_TP,
			GRAVITY,
			AUTODSN_YN,
			COIL_PACK_WGT_MIN,
			COIL_PACK_WGT_MAX,
			FAC_STL_GRD,
			COIL_THK,
			COIL_WTH,
			COIL_LEN,
			COIL_WGT,
			PROC_PATH,
			HCR_YN,
			EMGMTR_YN,
			FAC_STL_GRP,
            COMB_YN,
			COIL_INDIA,
			COIL_OUTDIA
			)
            values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
			]]>
    </query>
    <query id="UID040010.MatDnRst.Type.Select" desc="SearchAllMatDnRst">
        <![CDATA[
            SELECT DECODE(X.MAT_TP, '01', 1
                                  , '02', 2
                                  , '03', 3
                                  , '04', 4) AS LVL
                 , X.*
            FROM TBD01_MATDN_RST3 X
            WHERE X.MAT_TP = :1
			ORDER BY X.MAT_SPEC_SEQ
        ]]>
    </query>

    <query id="UID040010.MatDnRst.All.Delete" desc="SearchAllMatDnRst">
        <![CDATA[
            DELETE FROM TBD01_MATDN_RST3 WHERE 1 = 1
        ]]>
    </query>

    <query id="UID040010.MatDnRst.ByType.MaxMatSpecSeq" desc="SearchAllMatDnRst">
        <![CDATA[
            SELECT NVL(MAX(MAT_SPEC_SEQ),0) AS MAX_MAT_SPEC_SEQ
            FROM TBD01_MATDN_RST3
            WHERE MAT_TP = NVL(:1,'01')
        ]]>
    </query>

    <query id="UID040010.MatDnRst.Row.Insert" desc="SearchAllMatDnRst">
        <![CDATA[
            INSERT INTO TBD01_MATDN_RST3( MAT_SPEC_SEQ, PMAT_SPEC_SEQ
                                       , MAT_TP
                                       , EXP_MAT_NO, WITHIN_SUB_SEQ, CMAT_CNT
                                       , FAC_STL_GRD, FAC_STL_GRP
                                       , MAT_RT
                                       , TREAT_RT_CD
                                       , PATH_PROC_CD, LINE_PROC_CD
                                       , MAT_THK, MAT_WTH, MAT_LEN, MAT_LEN_MIN, MAT_LEN_MAX, MAT_WGT
                                       , CCM_TERM_TIME
                                       , WID_CHG_FL, HCR_YN, EMGMTR_YN
                                       , SMS_DUEDATE
                                       , PRC_LINE
                                       , CCM_PRC_LINE
                                       , PROG_CD
                                       , SLAB_CUT_SEQ
                                       , DSG_RATE
                                       , OVER_ROLL_YN, SAMPLE_CUT, ORD_FL
                                       , ORD_NO, ORD_SEQ, DELV_REQ_DATE
                                       , SPM_PROC_YN, SCARPING_PROC_YN
                                       , SEND_STS
                                       , COMB_YN
                                       , COIL_THK, COIL_WTH, COIL_LEN, COIL_WGT,DSN_SLAB_NO,P_DSN_SLAB_NO 
									   , GRAVITY, AUTODSN_YN, COIL_INDIA, COIL_OUTDIA, KEEPWARM_YN)
            SELECT ?, ?
                 , ?
                 , ?, ?, ?
                 , ?, ?
                 , ?
                 , ?
                 , ?, ?
                 , ?, ?, ?, ?, ?, ?
                 , ?
                 , ?, ?, ?
                 , ?
                 , ?
                 , ?
                 , ?
                 , ?
                 , ?
                 , ?, ?, ?
                 , ?, ?, ?
                 , ?, ?
                 , ?
                 , ?
                 , ?, ?, ?, ?, ?, ?
			     , ?, ?, ?, ?, ?
            FROM DUAL
        ]]>
    </query>
	<query id="UID040010.DeleteMatDnRst.Row.Select" desc="删除炉次浇次信息时炉次浇次删除的SELECT">
		SELECT X.MAT_SPEC_SEQ, X.DSN_SLAB_NO
		FROM (SELECT ROWNUM AS RN, A.MAT_SPEC_SEQ, A.DSN_SLAB_NO
			  FROM TBD01_MATDN_RST3 A
			  START WITH A.MAT_SPEC_SEQ = :1
			  CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ
			  ORDER BY 1 DESC) X
	</query>
	<query id="UID040010.DeleteMatDnRst.Row.Delete" desc="删除炉次浇次信息时炉次浇次的删除">
			DELETE FROM TBD01_MATDN_RST3 WHERE MAT_SPEC_SEQ = :1
	</query>
	
	<query id="UID040010.SlabDnObj2.Update" desc="下发出钢指示时改变OBJ2表中板坯的状态">
			UPDATE TBD01_SLABDN_OBJ2 SET PROC_STAT = :1 WHERE DSN_SLAB_NO = :2
	</query>
	
	<query id="UID040010.UpdateMatDnRst.Row.Select" desc="删除炉次浇次信息时炉次浇次顺序的调整SELECT">
		SELECT *
		FROM (SELECT MAT_SPEC_SEQ, PMAT_SPEC_SEQ, WITHIN_SUB_SEQ
				   , ROW_NUMBER() OVER (PARTITION BY PMAT_SPEC_SEQ ORDER BY WITHIN_SUB_SEQ) AS RNUM
			  FROM TBD01_MATDN_RST3) A
		WHERE A.WITHIN_SUB_SEQ != A.RNUM
		START WITH A.PMAT_SPEC_SEQ = :1
		CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ
	</query>
	<query id="UID040010.UpdateMatDnRst.Row.Update" desc="删除炉次浇次信息时炉次浇次顺序的调整的UPDATE">
		UPDATE TBD01_MATDN_RST3 SET WITHIN_SUB_SEQ = :1 WHERE MAT_SPEC_SEQ = :2
	</query>
		<query id="UID040010.castInfoWhenSure.select2" desc="指示确认时查询浇次信息">
        <![CDATA[
SELECT 'false' AS CHK
     , T.*
     ,(SELECT COUNT(*) FROM TBD01_MATDN_RST3 X WHERE X.PMAT_SPEC_SEQ = T.MAT_SPEC_SEQ) AS EXIST_YN
FROM TBD01_MATDN_RST3 T 
WHERE T.MAT_TP = '01' 
AND T.SEND_STS = '01'
        ]]>
    </query>
</queryMap>