XinYu_RZMES/.svn/pristine/e8/e89bd1d7a01b20e32f4a878d9cb947c0bb7b0689.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="品质设计结果之公差查询（分）">
    <query id="UIB015010_01.SELECT" desc="" fetchSize="10">  
        <![CDATA[
SELECT 
DECODE(LV,1,'厚度公差',
2,'宽度公差',
3,'平坦度',
4,'直角度',
5,'弯曲度',
6,'镰刀弯'
) LABEL,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN1,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_T6_MAX END)
) MAX1,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_T6_UNIT END)
) UNIT1,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN2,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_T6_MAX END)
) MAX2,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_T6_UNIT END)
) UNIT2,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN3,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_T6_MAX END)
) MAX3,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_T6_UNIT END)
) UNIT3,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN4,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_T6_MAX END)
) MAX4,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_T6_UNIT END)
) UNIT4
FROM TBB01_DSN_DEL B01OD,(SELECT LEVEL LV FROM DUAL CONNECT BY 1=1 AND LEVEL <=6) TEMP
WHERE ORD_NO = ? AND ORD_SEQ = ?	
		]]>   
    </query> 
	
	<query id="UIB015010_02.SELECT" desc="" fetchSize="10">  
        <![CDATA[
SELECT 
DECODE(LV,1,'厚度公差',
2,'宽度公差',
3,'平坦度',
4,'直角度',
5,'弯曲度',
6,'镰刀弯'
) LABEL,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN1,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_T6_MAX END)
) MAX1,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '1' THEN DEL_TOL_T6_UNIT END)
) UNIT1,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN2,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_T6_MAX END)
) MAX2,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '2' THEN DEL_TOL_T6_UNIT END)
) UNIT2,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN3,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_T6_MAX END)
) MAX3,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '4' THEN DEL_TOL_T6_UNIT END)
) UNIT3,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_THK_MIN,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_WTH_MIN,'99999.9') END),
3,TO_NUMBER(''),
4,TO_NUMBER(''),
5,TO_NUMBER(''),
6,TO_NUMBER('')
) MIN4,
DECODE(LV,1,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_THK_MAX,'999.999') END),
2,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN TO_CHAR(DEL_TOL_WTH_MAX,'99999.9') END),
3,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_EVEN_MAX END),
4,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_ANGLE_MAX END),
5,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_CAMBER_MAX END),
6,TO_NUMBER(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_T6_MAX END)
) MAX4,
DECODE(LV,1,'',
2,'',
3,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_EVEN_UNIT END),
4,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_ANGLE_UNIT END),
5,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_CAMBER_UNIT END),
6,(CASE WHEN DSN_KIND = '5' THEN DEL_TOL_T6_UNIT END)
) UNIT4
FROM TBB01_ORD_DEL B01OD,(SELECT LEVEL LV FROM DUAL CONNECT BY 1=1 AND LEVEL <=6) TEMP
WHERE ORD_NO = ? AND ORD_SEQ = ?	
		]]>   
    </query> 
	
	<query id="UIB015010_01.UPDATE" desc="" fetchSize="10">
				update TBB01_DSN_DEL set 			
				DEL_TOL_THK_MIN = ?,DEL_TOL_THK_MAX =?,
				DEL_TOL_WTH_MIN =?,DEL_TOL_WTH_MAX =?,
				DEL_TOL_EVEN_MAX =?,DEL_TOL_ANGLE_MAX =?,DEL_TOL_CAMBER_MAX =? 
				where ORD_NO =? and ORD_SEQ=? and DSN_KIND = '1'  
	</query>
	
	<query id="UIB015010_02.UPDATE" desc="" fetchSize="10">
				update TBB01_ORD_DEL set			 
				DEL_TOL_THK_MIN = ?,DEL_TOL_THK_MAX =?,
				DEL_TOL_WTH_MIN =?,DEL_TOL_WTH_MAX =?,
				DEL_TOL_EVEN_MAX =?,DEL_TOL_ANGLE_MAX =?,DEL_TOL_CAMBER_MAX =? 
				where ORD_NO =? and ORD_SEQ=? and DSN_KIND = '1'
	</query>
</queryMap>