XinYu_LZMES/.svn/pristine/fc/fce0b496d7793b8a650741d7e3dc730650c90c99.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="质保书编码管理">

<query	id="UIB030340_01.INITSELECT" desc="编码管理">
	<![CDATA[	
		 SELECT  '' SM_CD, 'ALL' SM_CFNM FROM DUAL
    UNION  ALL 
    select T.CUST_CD SM_CD,T.CUST_NM  SM_CFNM FROM  TBZ00_CUSTOMER T
	]]>
</query>
<query	id="UIB030340_01.SELECT" desc="编码管理">
	<![CDATA[	
		SELECT 
	    T1.QLTY_CD
	   ,T1.QLTY_CD_CFNM 
	   ,T2.DISPLAY_SEQ
	   ,T2.MS_QLTY_DIR
	   ,T2.MS_QLTY_SIZ
	   ,T2.MS_QLTY_TEM
	   ,T2.MS_BIG_CFNM
	   ,T2.MS_BIG_EFNM
	   ,T2.MS_SMALL_CFNM
	   ,T2.MS_SMALL_EFNM
	   ,T2.MS_EXT_CODE
	   ,T2.QLTY_TYPE
	   ,T2.REG_ID
	   ,T2.REG_DTIME
	    FROM    TBB01_SEQ_QLTY        T1    , TBB02_MS_QLTYCD T2
	    WHERE   T1.QLTY_CD            =     T2.QLTY_CD(+)
	    ORDER BY T2.DISPLAY_SEQ , T2.QLTY_CD
	]]>
</query>

<query id="UIB030340_02.SELECT" desc="图片管理">
	SELECT T1.PRDNM_CD
	      ,T1.SPEC_ABBSYM
	      ,T1.SPEC_STL_GRD
	      ,T1.ORD_USE_TP    ORD_USE_TP_HIDEN
	      ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , T1.ORD_USE_TP ) ORD_USE_TP
	      ,T1.THK_MIN
	      ,T1.THK_MAX
	      ,T1.WTH_MIN
	      ,T1.WTH_MAX
	      ,T2.PIC1
	      ,T2.PIC2
	      ,T2.PIC3
	      ,T2.TMPL_NO
	      ,T2.REG_ID
	      ,T2.REG_DTIME
	      ,T2.MOD_ID
	      ,T2.MOD_DTIME 
	      ,T2.LICENSE_NO
	      ,DECODE(T2.PRDNM_CD  , NULL , 'N' , 'Y')  EXIT_YN
	FROM   TBB01_KEY_PROD T1 , TBB02_MS_SET1 T2
	WHERE  T1.PRDNM_CD = T2.PRDNM_CD(+)
	AND    T1.SPEC_ABBSYM         =  T2.SPEC_ABBSYM(+)
	AND    T1.SPEC_STL_GRD        =  T2.SPEC_STL_GRD(+)
	AND    T1.ORD_USE_TP          =  T2.ORD_USE_TP(+)
	AND    T1.THK_MIN             =  T2.THK_MIN(+)
	AND    T1.THK_MAX             =  T2.THK_MAX(+) 
	AND    T1.WTH_MIN             =  T2.WTH_MIN(+)
	AND    T1.WTH_MAX             =  T2.WTH_MAX(+)
</query>

<query id="UIB030340_03.SELECT" desc="质保书备注等信息管理">
	SELECT         T1.ORD_NO 
	              ,T1.ORD_SEQ 
	              ,T1.PRDNM_CD 
	              ,T1.SPEC_ABBSYM 
	              ,T1.SPEC_STL_GRD 
	              ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , T1.ORD_USE_TP )   ORD_USE_TP
	              ,T1.CRET_NO_RMK 
	              ,T1.TMPL_NO
	FROM           TBB01_ORD_HEAD     T1  
	WHERE          T1.ORD_NO          LIKE         ?||'%' 
	AND            T1.SPEC_STL_GRD    LIKE         ?||'%'
	AND            SUBSTR(T1.DSN_CMT_DATE ,1,4 )   =         ?
</query>

<query id="UIB030340_04.SELECT" desc="质保书备注"> 
    SELECT T.* , T.MS_SEQ  MS_SEQ_1  FROM TBB02_MS_SET2 T  ORDER BY T.DIS_SEQ
</query>


<query  id="UIB030340_01.UPDATE"> 
		UPDATE    TBB02_MS_QLTYCD     T
		SET       T.DISPLAY_SEQ		 =		?
		         ,T.MS_QLTY_DIR		 =		?	
		         ,T.MS_QLTY_SIZ		 =		?
		         ,T.MS_QLTY_TEM		 =		?
		         ,T.MS_BIG_CFNM		 =		?
		         ,T.MS_BIG_EFNM		 =		?
		         ,T.MS_SMALL_CFNM	 =		?
		         ,T.MS_SMALL_EFNM	 =		?
		         ,T.MS_EXT_CODE 	 =      ?
		         ,T.MOD_ID			 =		?
		         ,T.MOD_DTIME		 =	    TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
		WHERE     T.QLTY_CD          =      ? 
</query>

<query id="UIB030340_02.UPDATE">
		UPDATE   TBB02_MS_SET1   T
		SET      T.PIC1          =                  ?
		        ,T.PIC2          =                  ?
		        ,T.PIC3          =                  ?
		        ,T.TMPL_NO       =                  ?
		        ,T.LICENSE_NO    =                  ?
		WHERE    T.PRDNM_CD      =                  ?
		AND      T.SPEC_ABBSYM   =                  ?
		AND      T.SPEC_STL_GRD  =                  ?
		AND      T.ORD_USE_TP    =                  ?
</query>

<query id="UIB030340_03.UPDATE" desc="质保书备注">
		UPDATE      TBB02_MS_SET2   T
		SET         T.MS_SEQ        =     ?
		           ,T.MS_DESC       =     ?
		           ,T.DIS_SEQ       =     ?
		           ,T.FIXED_PRO  	=	  ?
		           ,T.MOD_ID        =     ?
		           ,T.MOD_DTIME     =     TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') 
		WHERE       T.MS_SEQ        =     ?           
		
</query>

<query id="UIB030340_01.INSERT">
		INSERT    INTO          
		TBB02_MS_SET1
       (PRDNM_CD
       ,SPEC_ABBSYM
       ,SPEC_STL_GRD
       ,ORD_USE_TP
       ,THK_MIN
       ,THK_MAX
       ,WTH_MIN
       ,WTH_MAX
       ,PIC1
       ,PIC2
       ,PIC3
       ,TMPL_NO
       ,LICENSE_NO
       )
	    VALUES   (?,?,?,?,?,?,?,?,?,?,?,?,?)    
</query>

<query id="UIB030340_02.INSERT" desc="质保书备注">
	INSERT  INTO  TBB02_MS_SET2
              (
               MS_SEQ
              ,MS_DESC
              ,DIS_SEQ
              ,FIXED_PRO
              ,REG_ID
              ,REG_DTIME
              )
              VALUES(?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
</query>

<query id="UIB030340_01.DELETE" desc="删除备注">
	DELETE FROM TBB02_MS_SET2 T WHERE T.MS_SEQ = ?
</query>

<query id="UIB030340_01.CALL" desc="质保书模板及备注修改">
	   {call ZL_SUAN_DCS01.SAVE_TMPL_NO_RMK(?,?,?,?,?,?,?)}
</query>

<query id="UIB030340_02.CALL" desc="质保书标准管理">
	   {call ZL_SUAN_DCS01.SAVE_TMPL_NO(?,?,?,?,?,?,?,?,?,?)}
</query>

</queryMap>