<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="TQNQC13 （生成工具：代码生成工具1.0.0.0   访问地址：http://172.16.2.128/tool/）">
<query id="Tqnqc13DAL.Query" desc="查询">
        <![CDATA[
 SELECT 
       T.REC_CREATOR,
       T.REC_CREATE_TIME,
       T.REC_REVISOR,
       T.REC_REVISE_TIME,
       T.ARCHIVE_FLAG,
       T.DU_FLAG,
       T.DU_MAKER,
       T.DU_TIME,
       T.VERSION,
       T.SERIAL_NUM,
       T.STRATEGRY_IS,
       T.RP_CODE,
       T.WHOLE_BACKLOG_NAME,
       T.WHOLE_BACKLOG,
       T.ALLOY_BAK1,
       T.ALLOY_BAK2,
       T.ALLOY_BAK3,
       T.ALLOY_BAK4,
       T.ALLOY_BAK5,
       T.ALLOY_BAK6,
       T.ALLOY_BAK7,
       T.ALLOY_BAK8,
       T.ALLOY_BAK9,
       T.ALLOY_BAK10,
       T.LTEM_NUM,
       T.WHOLE_BACKLOG_CODE
 FROM TQNQC13 T
 WHERE
      1<>1
        ]]>
    </query>
    <query id="Tqnqc13DAL.QueryByPk" desc="通过主键查询">
        <![CDATA[
 SELECT 
       T.REC_CREATOR,
       T.REC_CREATE_TIME,
       T.REC_REVISOR,
       T.REC_REVISE_TIME,
       T.ARCHIVE_FLAG,
       T.DU_FLAG,
       T.DU_MAKER,
       T.DU_TIME,
       T.VERSION,
       T.SERIAL_NUM,
       T.STRATEGRY_IS,
       T.RP_CODE,
       T.WHOLE_BACKLOG_NAME,
       T.WHOLE_BACKLOG,
       T.ALLOY_BAK1,
       T.ALLOY_BAK2,
       T.ALLOY_BAK3,
       T.ALLOY_BAK4,
       T.ALLOY_BAK5,
       T.ALLOY_BAK6,
       T.ALLOY_BAK7,
       T.ALLOY_BAK8,
       T.ALLOY_BAK9,
       T.ALLOY_BAK10,
       T.LTEM_NUM,
       T.WHOLE_BACKLOG_CODE
 FROM TQNQC13 T
 WHERE
      1<>1
        ]]>
    </query>
    <query id="Tqnqc13DAL.Insert" desc="新增">
        <![CDATA[
 INSERT INTO TQNQC13(
        REC_CREATOR,
        REC_CREATE_TIME,
        RP_CODE,
        WHOLE_BACKLOG_NAME,
        WHOLE_BACKLOG,
        LTEM_NUM)
 VALUES( 
        '#REC_CREATOR#',
         to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),
        '#RP_CODE#',
        '#WHOLE_BACKLOG_NAME#',
        '#WHOLE_BACKLOG#',
        '#LTEM_NUM#')
        ]]>
    </query>
    <query id="Tqnqc13DAL.Update" desc="修改">
        <![CDATA[
 UPDATE TQNQC13 T
   SET 
        T.REC_REVISOR = '#REC_REVISOR#',
        T.REC_REVISE_TIME = to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),
        T.WHOLE_BACKLOG_NAME = '#WHOLE_BACKLOG_NAME#',
        T.WHOLE_BACKLOG = '#WHOLE_BACKLOG#'
 WHERE
        T.LTEM_NUM = '#LTEM_NUM#'
        AND
        T.RP_CODE = '#RP_CODE#'
        ]]>
    </query>
    <query id = "Tqnqc13DAL.Del" desc = "删除">
     delete from  TQNQC13 where LTEM_NUM = ?
        AND
        RP_CODE = ?
    </query>
    <query id="Tqnqc13DAL.GetMaxPk" desc="获取最大主键">
        <![CDATA[
SELECT NVL(MAX(?), 0) + 1 MAX_VALUE FROM TQNQC13 T
        ]]>
    </query>
    <query id="Tqnqc13DAL.Delete" desc="作废">
        <![CDATA[
UPDATE TQNQC13 T
   SET
       T.VALIDFLAG = '0',
       T.DELETE_NAME = '#DELETE_NAME#',
       T.DELETE_TIME = SYSDATE
WHERE
      1<>1
        ]]>
    </query>
    <query id="Tqnqc13DAL.Resume" desc="恢复">
        <![CDATA[
UPDATE TQNQC13 T
   SET
       T.VALIDFLAG = '1',
       T.DELETE_NAME = NULL,
       T.DELETE_TIME = NULL,
       T.UPDATE_NAME = '#UPDATE_NAME#',
       T.UPDATE_TIME = SYSDATE
WHERE
      1<>1
        ]]>
    </query>
</queryMap>