XinYu_RZMES/.svn/pristine/53/53d6804652ac6b7a8bd9cac47e2fa694bed2fcf8.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="EMP Project D">
	<query id="orderNo.select" desc="订单号码查询" fetchSize="10">
        <![CDATA[
             SELECT ORD_NO,ORD_NO AS PRDNM_CD FROM TBD01_SLABDN_OBJ
        ]]>
    </query> 
	<query id="select.orderInfo.byOrderNo" desc="根据订单号码查询订单" fetchSize="10">
        <![CDATA[
SELECT A.*
     , E.SM_CFNM    AS RCVORD_TP
     , B.PRODNM_CD
     , F.SM_CFNM    AS ORD_USE_TP
     , C.SPEC_STL_GRD
     , G.FAC_STL_GRP
FROM TBD01_SLABDN_OBJ A, TBE02_ORD_PRC B, TBA01_ORD_LINE C, TBA01_ORD_COMM D
   ,(SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'A01001') E
   ,(SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'A01007') F
   , TBD00_STLGRD G
WHERE A.ORD_NO = B.ORD_NO(+) AND A.ORD_SEQ = B.ORD_SEQ(+)
AND B.ORD_NO = C.ORD_NO(+) AND B.ORD_SEQ = C.ORD_SEQ(+)
AND C.ORD_NO = D.ORD_NO(+)
AND D.RCVORD_TP = E.SM_CD(+)
AND B.ORD_USEAGE_CD = F.SM_CD(+)
AND B.STL_GRD = G.FAC_STL_GRD(+)
AND A.ORD_NO LIKE :1||'%'
        ]]>
    </query> 
	<query id="select.sm.cfnm" desc="查询产品名称" fetchSize="10">
        <![CDATA[
            SELECT T.SM_CFNM, T.SM_CD FROM TBZ00_COMMCD T WHERE T.LG_CD='A01004' AND T.USED_YN='Y'
        ]]>
    </query> 
	<query id="autoslabdnres.select" desc="自动板坏设计结果查询" fetchSize="10">
        <![CDATA[
SELECT 'false' AS CHK, T.*
FROM TBD01_SLABDN_RST T
WHERE T.ORD_NO = ?
AND T.ORD_SEQ = ?
AND T.COMB_YN = 'N'
ORDER BY T.DSN_SLAB_NO
        ]]>
    </query> 
	<query id="coil_wgt.select" desc="钢号查询">
        <![CDATA[
--			SELECT DISTINCT FAC_STL_GRD, FAC_STL_GRD AS PRDNM_CD FROM  TBD01_SLABDN_RST 
SELECT A.FAC_STL_GRD, A.FAC_STL_GRD AS PRDNM_CD
FROM TBD00_STLGRD A
WHERE EXISTS (SELECT 'X'
              FROM TBD01_SLABDN_RST B
              WHERE B.FAC_STL_GRD = A.FAC_STL_GRD)
ORDER BY A.FAC_STL_GRD
        ]]>
    </query>
	<query id="proc_path.select" desc="工序路径查询">
        <![CDATA[
--			SELECT DISTINCT PROC_PATH, PROC_PATH AS PRDNM_CD FROM  TBD01_SLABDN_RST 
SELECT SM_CFNM AS PROC_PATH, SM_CD AS PRDNM_CD 
FROM TBZ00_COMMCD
WHERE LG_CD = 'F01001' AND SM_CD LIKE 'J%'
        ]]>
    </query>
	<query id="slabNoMax.select" desc="板坏设计时最大板坏号的查询">
        <![CDATA[
			SELECT NVL(MAX(DSN_SLAB_NO),0)+1 AS DSN_SLAB_NO FROM TBD01_SLABDN_RST
        ]]>
    </query>
	
	<query id="sumSlabNo.updata" desc="板坏设计结果删除">
        <![CDATA[
			UPDATE TBD01_SLABDN_RST
			SET P_DSN_SLAB_NO = ?
			where DSN_SLAB_NO = ?
        ]]>
    </query>
	
	<query id="castStlGrd.find" desc="查询连浇钢种号" fetchSize="10">
        <![CDATA[
			SELECT B.FAC_STL_GRPNM AS SM_CFNM, B.FAC_STL_GRP AS CAST_STL_GRD
			FROM TBD00_STLGRD_GRP B
			WHERE EXISTS (SELECT 'X'
			              FROM TBD00_STLGRD A
			              WHERE A.FAC_STL_GRP = B.FAC_STL_GRP)
        ]]>
    </query> 
	<query id="allCastStlGrd.find" desc="查询所有连浇钢种组" fetchSize="10">
        <![CDATA[
            SELECT FAC_STL_GRP AS SM_CD, FAC_STL_GRPNM AS SM_CFNM 
			FROM TBD00_STLGRD_GRP 
        ]]>
    </query>

</queryMap>