XinYu_RZMES/.svn/pristine/dc/dc2034ffdf4d16b9e8450cbf28db37f7286af068.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="板坏设计组合与分解">
	<query id="tbd01_slabdn_rst.update" desc="板坏设计结果更新">
        <![CDATA[
            UPDATE TBD01_SLABDN_RST
            set SLAB_WTH=?,
            SLAB_THK=?,
			SLAB_LEN=?,
			SLAB_WGT=?,
			SLAB_TRMTH_TP=?,
			AUTODSN_YN=?,
			EMGMTR_YN=?,
			COIL_PACK_WGT_MIN=?,
			COIL_PACK_WGT_MAX=?,
			HCR_YN=?,
			GRAVITY=?,
			FAC_STL_GRD=?,
			COIL_THK=?,
			COIL_WTH=?,
			COIL_LEN=?,
			COIL_WGT=?,
			PROC_PATH=?,
			P_DSN_SLAB_NO=?,
			FAC_STL_GRP=?,
			COMB_YN=?,
			ORD_SEQ=?,
			ORD_NO=?
            where DSN_SLAB_NO=?
        ]]>
    </query>
	<query id="tbd01_slabdn_rst.insert" desc="板坏设计结果插入">
        <![CDATA[
            INSERT INTO 
			TBD01_SLABDN_RST(SLAB_WTH,
            SLAB_THK,
			SLAB_LEN,
			SLAB_WGT,
			SLAB_TRMTH_TP,
			AUTODSN_YN,
			EMGMTR_YN,
			COIL_PACK_WGT_MIN,
			COIL_PACK_WGT_MAX,
			HCR_YN,
			GRAVITY,
			FAC_STL_GRD,
			COIL_THK,
			COIL_WTH,
			COIL_LEN,
			COIL_WGT,
			PROC_PATH,
			P_DSN_SLAB_NO,
			FAC_STL_GRP,
			COMB_YN,
			ORD_SEQ,
			ORD_NO,
            DSN_SLAB_NO
			)
            values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
        ]]>
    </query>
	<query id="tbd01_slabdn_rst.delete" desc="板坏设计结果删除">
        <![CDATA[
			DELETE TBD01_SLABDN_RST WHERE DSN_SLAB_NO=?
        ]]>
    </query>
	<query id="p_dsn_slab_no.update" desc="板坏设计结果删除">
        <![CDATA[
			UPDATE TBD01_SLABDN_RST
            SET P_DSN_SLAB_NO = NULL
			  , COMB_YN = 'N'
            WHERE DSN_SLAB_NO = ?
        ]]>
    </query>
	<query id="tbd01_slabdn_rst.updateByP_DSN_SLAB_NO" desc="板坏设计结果删除">
        <![CDATA[
			UPDATE TBD01_SLABDN_RST
            SET P_DSN_SLAB_NO = NULL
			  , COMB_YN = 'N'
            WHERE P_DSN_SLAB_NO = ?
        ]]>
    </query>
</queryMap>