XinYu_RZMES/.svn/pristine/f3/f35db04915179499e514f7d71d3c003c0a97e6bc.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="厂内牌号录入">



	<query id="UID010120.SearchFacStlGroupCode.Select" desc="" fetchSize="10">
        <![CDATA[
SELECT FAC_STL_GRP, FAC_STL_GRPNM
FROM TBD00_STLGRD_GRP
WHERE USE_YN = 'Y'
ORDER BY FAC_STL_GRP
        ]]>
    </query>



    <query id="UID010120.SearchFacStlGradeCode.Select" desc="" fetchSize="10">
        <![CDATA[
SELECT FAC_STL_GRD, FAC_STL_GRDNM
FROM TBD00_STLGRD
WHERE 1 = 1
ORDER BY FAC_STL_GRD
        ]]>
    </query>



    <query id="UID010120.SearchCastStlGrade.find" desc="" fetchSize="10">
        <![CDATA[
SELECT ROW_NUMBER() OVER (ORDER BY A.FAC_STL_GRP, A.CAST_SEQ) AS SEQ
     , A.FAC_STL_GRP
     , A.FAC_STL_GRD
     , A.CAST_SEQ
     , A.USE_YN
     , A.REG_ID
     , TO_CHAR(TO_DATE(A.REG_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS REG_DTIME
     , A.MOD_ID
     , TO_CHAR(TO_DATE(A.MOD_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS MOD_DTIME
     ,'N'                AS CHK  -- Un-used
FROM TBD00_CAST_STLGRD A
WHERE A.FAC_STL_GRP LIKE :1||'%'
AND A.FAC_STL_GRD LIKE :2||'%'
-- ORDER BY A.FAC_STL_GRP, A.CAST_SEQ
        ]]>
    </query>
    


    <query id="UID010120.SaveCastStlGrd.Insert" desc="">
        <![CDATA[
INSERT INTO TBD00_CAST_STLGRD (FAC_STL_GRP, FAC_STL_GRD, CAST_SEQ, USE_YN, REG_ID, REG_DTIME, MOD_ID, MOD_DTIME)
            VALUES (:1, :2, :3, :4, :5, TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), :6, TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'))
        ]]>
    </query>



    <query id="UID010120.SaveCastStlGrd.Update" desc="">
        <![CDATA[
UPDATE TBD00_CAST_STLGRD
SET CAST_SEQ = :1
  , USE_YN = :2
  , MOD_ID = :3
  , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
WHERE FAC_STL_GRP = :4
AND FAC_STL_GRD = :5
        ]]>
    </query>



	<query id="UID010120.SaveCastStlGrd.Delete" desc="">
        <![CDATA[
DELETE TBD00_CAST_STLGRD WHERE FAC_STL_GRP = :1 AND FAC_STL_GRD = :2
        ]]>
    </query>



</queryMap>