XinYu_RZMES/.svn/pristine/4a/4a62f3abbfaa590de782b1388fef39e1a283464f.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="交付条件（外形尺寸标准号）录入">
	
    <query id="UIB010272_01.INITSELECT" desc="客户名称" fetchSize="10">   
        <![CDATA[
    	 SELECT A.CUST_CD VALUE, A.CUST_NM LABEL
  			FROM TBZ00_CUSTOMER A
 		ORDER BY A.CUST_NM
        ]]>   
    </query> 
	
	<query id="UIB010270_02.INITSELECT" desc="获得公差名及公差代码">
		SELECT 
		SM_CFNM     LABEL  --公差名
		, SM_CD     VALUE  --公差代码
		FROM        TBZ00_COMMCD   WHERE   LG_CD = 'B01012'
	</query>
	
	<query id="UIB010270_03.INITSELECT" desc="等级代码 DengJi">
		SELECT 
		SM_CD       LABEL
		, SM_CD     VALUE
	    FROM        TBZ00_COMMCD    WHERE   LG_CD='B01119'
	</query>
	
	<query id="UIB010270_04.INITSELECT" desc="在基本信息中有，但在标准表中没有">
		SELECT        T1.SM_CD         LABEL
                     ,T1.SM_CD         VALUE
         FROM         TBZ00_COMMCD     T1
         WHERE        T1.LG_CD         =    'B01120'
         AND          T1.USED_YN       =     'Y'
		 MINUS
		 SELECT       T2.DEV_SPEC_CD 
		             ,T2.DEV_SPEC_CD 
		 FROM         TBB01_SPEC_DEL   T2
	</query>
	
	<query id="UIB010272_01.SELECT" desc="按 牌号获取原有数据">
		  SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD
   		   FROM TBB01_SPEC_STL
  		   WHERE SPEC_STL_GRD LIKE ? || '%'
           ORDER BY SPEC_STL_GRD
	</query>
	
	<query id="UIB010272_02.SELECT" desc="双击datagrid1中某条记录时，按交付条件号及名进行查询">
		 SELECT 'N' CHK,T.CUSTSTL,t.mark,t.CUSTNAME,t.SPEC_ABBSYM
  			from TBB01_SPEC_STL t
 		where t.SPEC_STL_GRD = ? 
	</query>
	
	<query id="UIB010272_01.INSERT" desc="插入新的公差">
		INSERT INTO TBB01_SPEC_STL(
		  SPEC_STL_GRD      --交付条件标准号	
		, CUSTSTL
		, CUSTNAME
		, SPEC_ABBSYM
		, MOD_ID           --操作人
		, MOD_DTIME        --操作时间
		, MARK
		)
		VALUES(?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM TBB01_SPEC_STL))
	</query>
	
	<query id="UIB010272_01.UPDATE" desc="datagrid2更新公差等信息">
		UPDATE    TBB01_SPEC_STL
		SET       CUSTSTL=  ?
				,CUSTNAME=?	
				, SPEC_ABBSYM=?		
				, MOD_ID        =  ?
		        , MOD_DTIME     =  TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
		WHERE     SPEC_STL_GRD   =  ?   --交付条件标准号
		AND       MARK	= ?
	</query>
	
	<query id="UIB010272_01.DELETE" desc="datagrid1删除交付条件信息">
		DELETE   FROM   TBB01_SPEC_STL 
		WHERE    SPEC_STL_GRD   =  ? --交付条件标准号
	</query>
	
	<query id="UIB010272_02.DELETE" desc="datagrid2删除具体的一条记录">
		 DELETE   FROM            TBB01_SPEC_STL
		 WHERE    MARK=?
	</query>
	<query id="UIB010274_01.INSERT" desc="插入新的公差">
		INSERT INTO TBB01_SuanXi_smp(
		  SPEC_STL_GRD      --交付条件标准号	
		, SPEC_ABBSYM
		, ORD_USE_TP          
		)
		VALUES(?,?,?)
	</query>
	<query id="UIB010274_01.SELECT" desc="按 牌号获取原有数据">
		  SELECT  SPEC_STL_GRD DEV_SPEC_CD,SPEC_ABBSYM,ORD_USE_TP
   		   FROM TBB01_SuanXi_smp
  		   WHERE SPEC_STL_GRD LIKE ? || '%'
           ORDER BY SPEC_STL_GRD
	</query>
	<query id="UIB010274_02.DELETE" desc="datagrid2删除具体的一条记录">
		 DELETE   FROM            TBB01_SuanXi_smp
		 WHERE    SPEC_STL_GRD=? AND SPEC_ABBSYM=? AND ORD_USE_TP=?
	</query>
	<query id="UIB010270_01.CALL" desc="复制">
		{call ZL_NORM_MANAGE.COPY_SPEC_DELE(?,?,?,?,?,?)}
	</query>
</queryMap>