XinYu_RZMES/.svn/pristine/69/692380ece356fe3918d23092541dd0ba60c14a8d.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="厂内牌号录入">
	<query id="TbStlGrdGrp.select" desc="查询厂内牌号" fetchSize="10">
        <![CDATA[
			SELECT 'false' AS CHK, 
			FAC_STL_GRP,
 			FAC_STL_GRPNM,
			CHGCNT_MIN,
			CHGCNT_MAX,
			CHGCNT_CHK_YN,
			CHGCNT_CHK_TP,
			USE_YN,
			REG_ID,
			TO_CHAR(TO_DATE(REG_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS REG_DTIME,
			MOD_ID,
			TO_CHAR(TO_DATE(MOD_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS MOD_DTIME
            FROM TBD00_STLGRD_GRP T
            WHERE T.CHGCNT_CHK_YN=?
            --AND T.CHGCNT_CHK_TP=?
            AND T.USE_YN=?
        ]]>
    </query> 
	<query id="tbd00_stlgrd_grp.update" desc="更新厂内牌号" fetchSize="10">
        <![CDATA[
            UPDATE TBD00_STLGRD_GRP
            set 
            FAC_STL_GRPNM=?,
			CHGCNT_MIN=?,
			CHGCNT_MAX=?,
			CHGCNT_CHK_YN=?,
			CHGCNT_CHK_TP=?,
			USE_YN=?,
			MOD_ID=?,
			MOD_DTIME=TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            where FAC_STL_GRP=?
        ]]>
    </query> 
	<query id="tbd00_stlgrd_grp.insert" desc="插入厂内牌号" fetchSize="10">
        <![CDATA[
            INSERT INTO 
			TBD00_STLGRD_GRP(
            FAC_STL_GRPNM,
			CHGCNT_MIN,
			CHGCNT_MAX,
			CHGCNT_CHK_YN,
			CHGCNT_CHK_TP,
			USE_YN,
			REG_ID,
			REG_DTIME,
			MOD_ID,
			MOD_DTIME,
			FAC_STL_GRP)
            values(?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?)
        ]]>
    </query> 
	<query id="tbd00_stlgrd_grp.delete" desc="删除厂内牌号" fetchSize="10">
        <![CDATA[
			DELETE TBD00_STLGRD_GRP WHERE FAC_STL_GRP=?
        ]]>
    </query>
</queryMap>