<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="OUTPRODUCTS （生成工具：代码生成工具1.0.0.0   访问地址：http://172.16.2.128/tool/）">
    <query id="OutproductsDAL.Query" desc="查询">
        <![CDATA[
 SELECT 
       T.NAME,
       T.CODE,
       T.TYPE,
       T.PRICE,
       T.MONTH,
       T.INSERTMAN,
       T.INSERTDATE,
       T.UPDATEMAN,
       T.UPDATEDATE
 FROM OUTPRODUCTS T
 WHERE
      1<>1
        ]]>
    </query>
    <query id="OutproductsDAL.QueryByPk" desc="通过主键查询">
        <![CDATA[
 SELECT 
       T.NAME,
       T.CODE,
       T.TYPE,
       T.PRICE,
       T.MONTH,
       T.INSERTMAN,
       T.INSERTDATE,
       T.UPDATEMAN,
       T.UPDATEDATE
 FROM OUTPRODUCTS T
 WHERE
      1<>1
        ]]>
    </query>
    <query id="OutproductsDAL.Insert" desc="新增">
        <![CDATA[
 INSERT INTO OUTPRODUCTS(
        NAME,
        CODE,
        TYPE,
        PRICE,
        MONTH,
        GRADENAME,
        INSERTMAN,
        INSERTDATE,
        UPDATEMAN,
        UPDATEDATE)
 VALUES( 
        '#NAME#',
        '#CODE#',
        '#TYPE#',
        '#PRICE#',
        '#MONTH#',
        '#GRADENAME#',
        '#INSERTMAN#',
        '#INSERTDATE#',
        '#UPDATEMAN#',
        '#UPDATEDATE#')
        ]]>
    </query>
    <query id="OutproductsDAL.Update" desc="修改">
        <![CDATA[
 UPDATE OUTPRODUCTS T
   SET 
        T.NAME = '#NAME#',
        T.TYPE = '#TYPE#',
        T.PRICE = '#PRICE#',
        T.INSERTMAN = '#INSERTMAN#',
        T.INSERTDATE = '#INSERTDATE#',
        T.UPDATEMAN = '#UPDATEMAN#',
        T.UPDATEDATE = '#UPDATEDATE#'
 WHERE
      T.CODE = '#CODE#'
      AND
      T.MONTH = '#MONTH#'
        ]]>
    </query>
    <query id="OutproductsDAL.GetMaxPk" desc="获取最大主键">
        <![CDATA[
SELECT NVL(MAX(?), 0) + 1 MAX_VALUE FROM OUTPRODUCTS T
        ]]>
    </query>
    <query id="OutproductsDAL.Delete" desc="作废">
        <![CDATA[
DELETE OUTPRODUCTS
WHERE 
CODE = ? AND MONTH = ?
        ]]>
    </query>
    <query id="OutproductsDAL.Resume" desc="恢复">
        <![CDATA[
UPDATE OUTPRODUCTS 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>