XinYu_RZMES/.svn/pristine/b1/b1c59dc7f8cfb5cf0ef9c92b1587746a33b79d86.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="板坏设计组合与分解">
	<query id="castNumber.select2" desc="浇次号查询">
        <![CDATA[
			SELECT MAT_SPEC_SEQ FROM TBD01_MATDN_RST2 WHERE MAT_TP = '01'
        ]]>
    </query>
	<query id="castInfo.select2" desc="浇次信息查询">
        <![CDATA[
			SELECT 'false' AS CHK,T.* FROM TBD01_MATDN_RST2 T WHERE T.PMAT_SPEC_SEQ = ? AND T.MAT_TP = '02' ORDER BY T.WITHIN_SUB_SEQ
        ]]>
    </query>
	<query id="castInfoAfter.update2" desc="浇次顺序调整后更新浇次信息">
        <![CDATA[
			UPDATE TBD01_MATDN_RST2
			SET PMAT_SPEC_SEQ = ?, 
			WITHIN_SUB_SEQ = ?
			WHERE MAT_SPEC_SEQ = ?
        ]]>
    </query>			
	<query id="castInfoToPro.update2" desc="浇次顺序调整后更新浇次信息">
        <![CDATA[
			UPDATE TBD01_MATDN_RST2
			SET SEND_STS = '02', 
			WITHIN_SUB_SEQ = ?
			WHERE MAT_SPEC_SEQ = ?
        ]]>
    </query>
	<query id="slabInfoByChargNo.select2" desc="浇次顺序调整后更新浇次信息">
        <![CDATA[
		SELECT A.MAT_SPEC_SEQ, A.MAT_WTH, A.MAT_LEN, A.MAT_WGT
		-- , B.ORD_THK, B.ORD_WTH
			,A.FAC_STL_GRD,A.FAC_STL_GRP
			, A.ORD_NO, A.ORD_SEQ
		 --, B.SPEC_ABBSYM, B.SPEC_STL_GRD
		 , 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_RST2 A--, TBA01_ORD_LINE B
		WHERE 1=1
--		AND	A.ORD_NO = B.ORD_NO(+)
--		AND A.ORD_SEQ = B.ORD_SEQ(+)
		AND A.PMAT_SPEC_SEQ = :1
        ]]>
    </query>
	<query id="castInfoWhenSure.select2" desc="指示确认时查询浇次信息">
        <![CDATA[
SELECT 'false' AS CHK
     , T.*
     ,(SELECT COUNT(*) FROM TBD01_MATDN_RST2 X WHERE X.PMAT_SPEC_SEQ = T.MAT_SPEC_SEQ) AS EXIST_YN
     , '' AS INSCHARGESTRDTIME, '' AS INSCHARGEENDDTIME
FROM TBD01_MATDN_RST2 T 
WHERE T.MAT_TP = '01' 
AND T.SEND_STS = '01'
        ]]>
    </query>
</queryMap>