<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="TQNQC19 （生成工具：代码生成工具1.0.0.0   访问地址：http://172.16.2.128/tool/）">
    <query id="Tqnqc19DAL.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.PROD_CLASS_DESC,
       T.WHOLE_BACKLOG_NAME,
       T.RAW_ORIGIN,
       T.COST_CENTER_AC,
       T.WHOLE_BACKLOG,
       T.SG_SIGN,
       T.TAP_MARK,
       T.STEEL_TYPE_CODE,
       T.CLASS_INTERVAL,
       T.DIF_RADIO,
       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
 FROM TQNQC19 T
 WHERE
      1<>1
        ]]>
    </query>
    <query id="Tqnqc19DAL.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.PROD_CLASS_DESC,
       T.WHOLE_BACKLOG_NAME,
       T.RAW_ORIGIN,
       T.COST_CENTER_AC,
       T.WHOLE_BACKLOG,
       T.SG_SIGN,
       T.TAP_MARK,
       T.STEEL_TYPE_CODE,
       T.CLASS_INTERVAL,
       T.DIF_RADIO,
       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
 FROM TQNQC19 T
 WHERE
      1<>1
        ]]>
    </query>
    <query id="Tqnqc19DAL.Insert" desc="新增">
        <![CDATA[
 INSERT INTO TQNQC19(
        REC_CREATOR,
        REC_CREATE_TIME,
        REC_REVISOR,
        REC_REVISE_TIME,
        ARCHIVE_FLAG,
        DU_FLAG,
        DU_MAKER,
        DU_TIME,
        VERSION,
        SERIAL_NUM,
        STRATEGRY_IS,
        PROD_CLASS_DESC,
        WHOLE_BACKLOG_NAME,
        RAW_ORIGIN,
        COST_CENTER_AC,
        WHOLE_BACKLOG,
        SG_SIGN,
        TAP_MARK,
        STEEL_TYPE_CODE,
        CLASS_INTERVAL,
        DIF_RADIO,
        ALLOY_BAK1,
        ALLOY_BAK2,
        ALLOY_BAK3,
        ALLOY_BAK4,
        ALLOY_BAK5,
        ALLOY_BAK6,
        ALLOY_BAK7,
        ALLOY_BAK8,
        ALLOY_BAK9,
        ALLOY_BAK10)
 VALUES( 
        '#REC_CREATOR#',
         to_char(sysdate,'yyyymmdd'),
        '#REC_REVISOR#',
        '#REC_REVISE_TIME#',
        '#ARCHIVE_FLAG#',
        '#DU_FLAG#',
        '#DU_MAKER#',
        '#DU_TIME#',
        '#VERSION#',
        '#SERIAL_NUM#',
        '#STRATEGRY_IS#',
        '#PROD_CLASS_DESC#',
        '#WHOLE_BACKLOG_NAME#',
        '#RAW_ORIGIN#',
        '#COST_CENTER_AC#',
        '#WHOLE_BACKLOG#',
        '#SG_SIGN#',
        '#TAP_MARK#',
        '#STEEL_TYPE_CODE#',
        '#CLASS_INTERVAL#',
        '#DIF_RADIO#',
        '#ALLOY_BAK1#',
        '#ALLOY_BAK2#',
        '#ALLOY_BAK3#',
        '#ALLOY_BAK4#',
        '#ALLOY_BAK5#',
        '#ALLOY_BAK6#',
        '#ALLOY_BAK7#',
        '#ALLOY_BAK8#',
        '#ALLOY_BAK9#',
        '#ALLOY_BAK10#')
        ]]>
    </query>
    <query id="Tqnqc19DAL.Update" desc="修改">
        <![CDATA[
	 UPDATE TQNQC19 T
	   SET 
	        T.DIF_RADIO = '#DIF_RADIO#',
	        T.REC_REVISOR = '#REC_REVISOR#',
            T.REC_REVISE_TIME = to_char(sysdate,'yyyymmdd')
	 WHERE
	      SG_SIGN = '#SG_SIGN#'
	      and 
	      STEEL_TYPE_CODE = '#STEEL_TYPE_CODE#'
        ]]>
    </query>
    <query id="Tqnqc19DAL.GetMaxPk" desc="获取最大主键">
        <![CDATA[
SELECT NVL(MAX(?), 0) + 1 MAX_VALUE FROM TQNQC19 T
        ]]>
    </query>
    
    <query id="Tqnqc19DAL.Delete" desc="作废">
        <![CDATA[
  DELETE  FROM TQNQC19 
   WHERE
       SG_SIGN = ?
        and 
       STEEL_TYPE_CODE = ?
        ]]>
    </query>
    
    <query id="Tqnqc19DAL.Resume" desc="恢复">
        <![CDATA[
UPDATE TQNQC19 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>