XinYu_RZMES/.svn/pristine/4d/4d8d7db8ec3a4fa849688bab81418b751c633a50.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="板坏单重标准维护">
		<query id="SlabDnWgtStd.select" desc="根据品名和牌号查询板坏单重标准" fetchSize="10">
        <![CDATA[
        SELECT 'false' AS CHK
             , NVL(Y.GRAVITY,0) AS GRAVITY
             , NVL(DECODE(X.SLAB_THK     , NULL, Y.SLAB_THK          , X.SLAB_THK     ),0) AS SLAB_THK
             , NVL(DECODE(X.SLAB_WTH     , NULL, Y.SLAB_WTH          , X.SLAB_WTH     ),0) AS SLAB_WTH
             , NVL(DECODE(X.SLAB_LEN_SMIN, NULL, Y.SLAB_TYPE1_MIN_LEN, X.SLAB_LEN_SMIN),0) AS SLAB_LEN_SMIN
             , NVL(DECODE(X.SLAB_LEN_SMAX, NULL, Y.SLAB_TYPE1_MAX_LEN, X.SLAB_LEN_SMAX),0) AS SLAB_LEN_SMAX
             , NVL((NVL(DECODE(X.SLAB_LEN_SMIN, NULL, Y.SLAB_TYPE1_MIN_LEN, X.SLAB_LEN_SMIN),0)
                   *
                   (NVL(DECODE(X.SLAB_THK     , NULL, Y.SLAB_THK          , X.SLAB_THK     ),0)
                    *
                    NVL(DECODE(X.SLAB_WTH      , NULL, Y.SLAB_WTH          , X.SLAB_WTH     ),0)
                    *
                    NVL(Y.GRAVITY,0))) * 1000 / 1000000000,0)                                      AS SLAB_WGT_SMIN
             , NVL((NVL(DECODE(X.SLAB_LEN_SMAX, NULL, Y.SLAB_TYPE1_MAX_LEN, X.SLAB_LEN_SMAX),0)
                   *
                   (NVL(DECODE(X.SLAB_THK     , NULL, Y.SLAB_THK          , X.SLAB_THK     ),0)
                    *
                    NVL(DECODE(X.SLAB_WTH      , NULL, Y.SLAB_WTH          , X.SLAB_WTH     ),0)
                    *
                    NVL(Y.GRAVITY,0))) * 1000 / 1000000000,0)                                      AS SLAB_WGT_SMAX
             , NVL(DECODE(X.SLAB_LEN_LMIN, NULL, Y.SLAB_TYPE2_MIN_LEN, X.SLAB_LEN_LMIN),0) AS SLAB_LEN_LMIN
             , NVL(DECODE(X.SLAB_LEN_LMAX, NULL, Y.SLAB_TYPE2_MAX_LEN, X.SLAB_LEN_LMAX),0) AS SLAB_LEN_LMAX
             , NVL((NVL(DECODE(X.SLAB_LEN_LMIN, NULL, Y.SLAB_TYPE2_MIN_LEN, X.SLAB_LEN_LMIN),0)
                   *
                   (NVL(DECODE(X.SLAB_THK     , NULL, Y.SLAB_THK          , X.SLAB_THK     ),0)
                    *
                    NVL(DECODE(X.SLAB_WTH      , NULL, Y.SLAB_WTH          , X.SLAB_WTH     ),0)
                    *
                    NVL(Y.GRAVITY,0))) * 1000 / 1000000000,0)                                      AS SLAB_WGT_LMIN
             , NVL((NVL(DECODE(X.SLAB_LEN_LMAX, NULL, Y.SLAB_TYPE2_MAX_LEN, X.SLAB_LEN_LMAX),0)
                   *
                   (NVL(DECODE(X.SLAB_THK     , NULL, Y.SLAB_THK          , X.SLAB_THK     ),0)
                    *
                    NVL(DECODE(X.SLAB_WTH      , NULL, Y.SLAB_WTH          , X.SLAB_WTH     ),0)
                    *
                    NVL(Y.GRAVITY,0))) * 1000 / 1000000000,0)                                      AS SLAB_WGT_LMAX
        FROM TBD00_SLABDN_WGTSTD X
           ,(SELECT *
             FROM(SELECT CASE WHEN ((TO_NUMBER(SM_CD) + 50) > 1430) THEN 1450 ELSE TO_NUMBER(SM_CD) + 50 END AS SLAB_WTH
                       , CD_SEQ
                  FROM TBZ00_COMMCD WHERE LG_CD = 'D01001' AND USED_YN = 'Y') A
                ,(SELECT TO_NUMBER(SM_CD) AS SLAB_THK FROM TBZ00_COMMCD WHERE LG_CD = 'D01002'AND USED_YN = 'Y') B
                ,(SELECT MIN(DECODE(CD_SEQ,1,TO_NUMBER(SM_CD))) AS SLAB_TYPE1_MIN_LEN
                       , MAX(DECODE(CD_SEQ,2,TO_NUMBER(SM_CD))) AS SLAB_TYPE1_MAX_LEN
                       , MIN(DECODE(CD_SEQ,3,TO_NUMBER(SM_CD))) AS SLAB_TYPE2_MIN_LEN
                       , MAX(DECODE(CD_SEQ,4,TO_NUMBER(SM_CD))) AS SLAB_TYPE2_MAX_LEN
                  FROM TBZ00_COMMCD
                  WHERE LG_CD = 'D01003' AND USED_YN = 'Y') C
                ,(SELECT TO_NUMBER(SM_CD) AS GRAVITY FROM TBZ00_COMMCD WHERE LG_CD = 'D01006') D
             ORDER BY A.CD_SEQ) Y
        WHERE Y.SLAB_THK = X.SLAB_THK(+)
        AND Y.SLAB_WTH = X.SLAB_WTH(+)
        ]]>
    </query> 
	<query id="SlabDnWgtStd.update" desc="板坏单重标准更新">
        <![CDATA[
UPDATE TBD00_SLABDN_WGTSTD
SET SLAB_LEN_SMIN = :1
  , SLAB_LEN_SMAX = :2
  , SLAB_LEN_LMIN = :3
  , SLAB_LEN_LMAX = :4
  , SLAB_WGT_SMIN = :5
  , SLAB_WGT_SMAX = :6
  , SLAB_WGT_LMIN = :7
  , SLAB_WGT_LMAX = :8
WHERE SLAB_THK = :9
AND SLAB_WTH = :10
        ]]>
    </query>
	<query id="SlabDnWgtStd.insert" desc="板坏单重标准保存">
        <![CDATA[
INSERT INTO TBD00_SLABDN_WGTSTD (SLAB_LEN_SMIN, SLAB_LEN_SMAX, SLAB_LEN_LMIN, SLAB_LEN_LMAX
                               , SLAB_WGT_SMIN, SLAB_WGT_SMAX, SLAB_WGT_LMIN, SLAB_WGT_LMAX
                               , SLAB_THK, SLAB_WTH) 
VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
        ]]>
    </query>

</queryMap>