XinYu_RZMES/.svn/pristine/cf/cfcdc169dfeee708863f526db63319a26197cd86.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="EMP Project D">

	<query id="SearchFacStlGradeCode.Select" desc="" fetchSize="10">
        <![CDATA[
SELECT ROWNUM AS SEQ
     , A.FAC_STL_GRD
     , 0 AS CAST_SEQ
     , A.FAC_STL_GRP
     , 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
     , A.FAC_STL_GRDNM
     ,'false'                AS CHK  -- Un-used
FROM TBD00_STLGRD A
WHERE NVL(A.FAC_STL_GRP ,'X')  LIKE :1||'%'
AND A.FAC_STL_GRD LIKE :2||'%'
ORDER BY A.FAC_STL_GRD, A.CAST_SEQ
        ]]>
    </query>
    
    <query id="SaveFacStlGrd.Insert" desc="">
        <![CDATA[
INSERT INTO TBD00_STLGRD (FAC_STL_GRD, FAC_STL_GRDNM, REG_ID, REG_DTIME, MOD_ID, MOD_DTIME, FAC_STL_GRP, CAST_SEQ)
            VALUES (:1, :2, :3, TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), :4, TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), :5, :6)
        ]]>
    </query>

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

	<query id="SaveFacStlGrd.Delete" desc="">
        <![CDATA[
DELETE TBD00_STLGRD WHERE FAC_STL_GRD = :1
        ]]>
    </query>


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

</queryMap>