XinYu_RZMES/.svn/pristine/b2/b2f3e37ca9d751fa6bbe6569fa4fd7cb4d3720ed.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="板坏设计组合与分解">
	<query id="castNumber.select" desc="浇次号查询">
        <![CDATA[
			SELECT MAT_SPEC_SEQ FROM TBD01_MATDN_RST WHERE MAT_TP = '01'
        ]]>
    </query>
	<query id="castInfo.select" desc="浇次信息查询">
        <![CDATA[
			SELECT 'false' AS CHK,T.* FROM TBD01_MATDN_RST T WHERE T.PMAT_SPEC_SEQ = ? AND T.MAT_TP = '02' ORDER BY T.WITHIN_SUB_SEQ
        ]]>
    </query>
	<query id="castInfoAfter.update" desc="浇次顺序调整后更新浇次信息">
        <![CDATA[
			UPDATE TBD01_MATDN_RST
			SET PMAT_SPEC_SEQ = ?, 
			WITHIN_SUB_SEQ = ?
			WHERE MAT_SPEC_SEQ = ?
        ]]>
    </query>			
	<query id="castInfoToPro.update" desc="浇次顺序调整后更新浇次信息">
        <![CDATA[
			UPDATE TBD01_MATDN_RST
			SET SEND_STS = '02', 
			WITHIN_SUB_SEQ = ?
			WHERE MAT_SPEC_SEQ = ?
        ]]>
    </query>
	<query id="slabInfoByChargNo.select" desc="浇次顺序调整后更新浇次信息">
        <![CDATA[
SELECT A.MAT_SPEC_SEQ, A.MAT_WTH, A.MAT_LEN, A.MAT_WGT
		 , B.ORD_THK, B.ORD_WTH
			, A.ORD_NO, A.ORD_SEQ
		 , B.SPEC_ABBSYM, B.SPEC_STL_GRD
     , A.FAC_STL_GRD, A.FAC_STL_GRP
		 , B.UST_CD, A.SPM_PROC_YN, A.HCR_YN, A.ORD_FL
		 , DECODE(NVL(A.CMAT_CNT,0),0,'N','Y') AS COMB_YN
			 , A. DELV_REQ_DATE 
		FROM TBD01_MATDN_RST A, TBA01_ORD_LINE B
		WHERE A.ORD_NO = B.ORD_NO(+)
		AND A.ORD_SEQ = B.ORD_SEQ(+)
		AND A.PMAT_SPEC_SEQ =?
        ]]>
    </query>
	<query id="castInfoWhenSure.select" desc="指示确认时查询浇次信息">
        <![CDATA[
SELECT 'false' AS CHK
     , T.*
     ,(SELECT COUNT(*) FROM TBD01_MATDN_RST X WHERE X.PMAT_SPEC_SEQ = T.MAT_SPEC_SEQ) AS EXIST_YN
     , '' AS insChargeStrDtime, '' AS insChargeEndDtime
FROM TBD01_MATDN_RST T 
WHERE T.MAT_TP = '01' 
AND T.SEND_STS = '01'
        ]]>
    </query>
	<query id="matdnRstBackup.insert" desc="指示确认时查询浇次信息">
        <![CDATA[
INSERT INTO TBD01_MATDN_RST_BACKUP( 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
                                  , REG_ID, REG_DTIME, MOD_ID, MOD_DTIME, DSN_SLAB_NO, P_DSN_SLAB_NO
                                  , GRAVITY, AUTODSN_YN, COIL_INDIA, COIL_OUTDIA )
SELECT 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
     , :1, TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), :2,  TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), DSN_SLAB_NO, P_DSN_SLAB_NO
     , GRAVITY, AUTODSN_YN, COIL_INDIA, COIL_OUTDIA
FROM TBD01_MATDN_RST A
WHERE 1=1
START WITH A.MAT_SPEC_SEQ = :3
CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ
		]]>
    </query>
</queryMap>