Home Esplora Aiuto
Accedi
wudonglin
/
XinYu_RZMES
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 1105ec3dbe
Rami (Branch) Tag
XinYu_RZMES
/
.svn
/
pristine
/
cb
/
cb024a0df76b0407f0c80a7dd66b108936fe852c.svn-base

cb024a0df76b0407f0c80a7dd66b108936fe852c.svn-base 10 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208 
  1. <?xml version="1.0" encoding='UTF-8'?>
    2. 

  2. <queryMap desc="质检_炼钢报表">
    3. 

  3.   
    4. 

  4.      <query id="UIB030020.SELECT" desc="" fetchSize="10">  
    5. 

  5.         <![CDATA[
    6. 

  6.         SELECT ROW_NUMBER()OVER(ORDER BY X.CHARGE_NO) SEQ
    7. 

  7.         ,X.* 
    8. 

  8.         ,(CASE WHEN Y.OFF        != 0 THEN  Y.OFF         END) OFF
    9. 

  9.         ,(CASE WHEN Y.LIEWEN     != 0 THEN  Y.LIEWEN      END) LIEWEN
    10. 

  10.         ,(CASE WHEN Y.JIAZA      != 0 THEN  Y.JIAZA       END) JIAZA
    11. 

  11.         ,(CASE WHEN Y.fenceng    != 0 THEN  Y.fenceng     END) fenceng
    12. 

  12.         ,(CASE WHEN Y.qikong     != 0 THEN  Y.qikong      END) qikong
    13. 

  13.         ,(CASE WHEN Y.shuangjiao != 0 THEN  Y.shuangjiao  END) shuangjiao
    14. 

  14.         ,(CASE WHEN Y.aokeng     != 0 THEN  Y.aokeng      END) aokeng
    15. 

  15.         ,(CASE WHEN Y.tukuai     != 0 THEN  Y.tukuai      END) tukuai
    16. 

  16.         ,(CASE WHEN Y.tuofang    != 0 THEN  Y.tuofang     END) tuofang
    17. 

  17.         FROM 
    18. 

  18.         (SELECT G02CC.CHARGE_NO 
    19. 

  19.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'C',B02WI.CHEM_VAL))  C
    20. 

  20.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'MN',B02WI.CHEM_VAL)) MN
    21. 

  21.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'S',B02WI.CHEM_VAL))  S
    22. 

  22.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'P',B02WI.CHEM_VAL))  P
    23. 

  23.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'SI',B02WI.CHEM_VAL)) SI
    24. 

  24.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'CR',B02WI.CHEM_VAL)) CR
    25. 

  25.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'NI',B02WI.CHEM_VAL)) NI
    26. 

  26.         ,MAX(DECODE(UPPER(B02WI.CHEM_CD)
    27. 

  27.         ,'QB1',B02WI.CHEM_VAL
    28. 

  28.         ,'QB2',B02WI.CHEM_VAL
    29. 

  29.         ,'QB3',B02WI.CHEM_VAL))CEQ
    30. 

  30.         FROM TBG02_CHARGE_COMM G02CC
    31. 

  31.         ,TBB02_WORK_INGR B02WI
    32. 

  32.         WHERE G02CC.CHARGE_NO = B02WI.CHARGE_NO
    33. 

  33.         AND SUBSTR(G02CC.LST_INGR_CD,1,2) = B02WI.PROC_CD
    34. 

  34.         AND SUBSTR(G02CC.LST_INGR_CD,3,2) = B02WI.CHEM_SEQ 
    35. 

  35.         AND   DECODE(?,'1',G02CC.INGR_DEC_DTIME,'2',G02CC.CASTING_END_DTIME) >= ?||'000000'
    36. 

  36.         AND   DECODE(?,'1',G02CC.INGR_DEC_DTIME,'2',G02CC.CASTING_END_DTIME) <= ?||'235959'  
    37. 

  37.         AND   G02CC.STL_GRD                                                      LIKE       ?||'%'
    38. 

  38.         GROUP BY G02CC.CHARGE_NO)X,
    39. 

  39.         (SELECT G02CC.CHARGE_NO
    40. 

  40.         ,SUM(DECODE(G02SC.EXTSHAPE_GRD,'2',1,0)) OFF
    41. 

  41.         ,SUM(DECODE(G02SC.CRK_CD1,'07',1,0)
    42. 

  42.         +DECODE(G02SC.CRK_CD2,'07',1,0)
    43. 

  43.         +DECODE(G02SC.CRK_CD3,'07',1,0)
    44. 

  44.         +DECODE(G02SC.CRK_CD4,'07',1,0)
    45. 

  45.         +DECODE(G02SC.CRK_CD5,'07',1,0)
    46. 

  46.         +DECODE(G02SC.CRK_CD6,'07',1,0)
    47. 

  47.         +DECODE(G02SC.CRK_CD7,'07',1,0)
    48. 

  48.         +DECODE(G02SC.CRK_CD8,'07',1,0)
    49. 

  49.         +DECODE(G02SC.CRK_CD9,'07',1,0)
    50. 

  50.         +DECODE(G02SC.CRK_CD10,'07',1,0)) LIEWEN                     --裂纹(G03004)
    51. 

  51.         ,SUM(DECODE(G02SC.CRK_CD1,'10',1,0)
    52. 

  52.         +DECODE(G02SC.CRK_CD2,'10',1,0)
    53. 

  53.         +DECODE(G02SC.CRK_CD3,'10',1,0)
    54. 

  54.         +DECODE(G02SC.CRK_CD4,'10',1,0)
    55. 

  55.         +DECODE(G02SC.CRK_CD5,'10',1,0)
    56. 

  56.         +DECODE(G02SC.CRK_CD6,'10',1,0)
    57. 

  57.         +DECODE(G02SC.CRK_CD7,'10',1,0)
    58. 

  58.         +DECODE(G02SC.CRK_CD8,'10',1,0)
    59. 

  59.         +DECODE(G02SC.CRK_CD9,'10',1,0)
    60. 

  60.         +DECODE(G02SC.CRK_CD10,'10',1,0)) JIAZA                      --夹杂(G03004)
    61. 

  61.         ,SUM(DECODE(G02SC.CRK_CD1,'31',1,0)
    62. 

  62.         +DECODE(G02SC.CRK_CD2,'31',1,0)
    63. 

  63.         +DECODE(G02SC.CRK_CD3,'31',1,0)
    64. 

  64.         +DECODE(G02SC.CRK_CD4,'31',1,0)
    65. 

  65.         +DECODE(G02SC.CRK_CD5,'31',1,0)
    66. 

  66.         +DECODE(G02SC.CRK_CD6,'31',1,0)
    67. 

  67.         +DECODE(G02SC.CRK_CD7,'31',1,0)
    68. 

  68.         +DECODE(G02SC.CRK_CD8,'31',1,0)
    69. 

  69.         +DECODE(G02SC.CRK_CD9,'31',1,0)
    70. 

  70.         +DECODE(G02SC.CRK_CD10,'31',1,0)) fenceng                    --分层
    71. 

  71.         ,SUM(DECODE(G02SC.CRK_CD1,'14',1,0)
    72. 

  72.         +DECODE(G02SC.CRK_CD2,'14',1,0)
    73. 

  73.         +DECODE(G02SC.CRK_CD3,'14',1,0)
    74. 

  74.         +DECODE(G02SC.CRK_CD4,'14',1,0)
    75. 

  75.         +DECODE(G02SC.CRK_CD5,'14',1,0)
    76. 

  76.         +DECODE(G02SC.CRK_CD6,'14',1,0)
    77. 

  77.         +DECODE(G02SC.CRK_CD7,'14',1,0)
    78. 

  78.         +DECODE(G02SC.CRK_CD8,'14',1,0)
    79. 

  79.         +DECODE(G02SC.CRK_CD9,'14',1,0)
    80. 

  80.         +DECODE(G02SC.CRK_CD10,'14',1,0)) qikong                    --气孔
    81. 

  81.         ,SUM(DECODE(G02SC.CRK_CD1,'30',1,0)
    82. 

  82.         +DECODE(G02SC.CRK_CD2,'30',1,0)
    83. 

  83.         +DECODE(G02SC.CRK_CD3,'30',1,0)
    84. 

  84.         +DECODE(G02SC.CRK_CD4,'30',1,0)
    85. 

  85.         +DECODE(G02SC.CRK_CD5,'30',1,0)
    86. 

  86.         +DECODE(G02SC.CRK_CD6,'30',1,0)
    87. 

  87.         +DECODE(G02SC.CRK_CD7,'30',1,0)
    88. 

  88.         +DECODE(G02SC.CRK_CD8,'30',1,0)
    89. 

  89.         +DECODE(G02SC.CRK_CD9,'30',1,0)
    90. 

  90.         +DECODE(G02SC.CRK_CD10,'30',1,0)) shuangjiao                --双浇
    91. 

  91.         ,SUM(DECODE(G02SC.CRK_CD1,'18',1,0)
    92. 

  92.         +DECODE(G02SC.CRK_CD2,'18',1,0)
    93. 

  93.         +DECODE(G02SC.CRK_CD3,'18',1,0)
    94. 

  94.         +DECODE(G02SC.CRK_CD4,'18',1,0)
    95. 

  95.         +DECODE(G02SC.CRK_CD5,'18',1,0)
    96. 

  96.         +DECODE(G02SC.CRK_CD6,'18',1,0)
    97. 

  97.         +DECODE(G02SC.CRK_CD7,'18',1,0)
    98. 

  98.         +DECODE(G02SC.CRK_CD8,'18',1,0)
    99. 

  99.         +DECODE(G02SC.CRK_CD9,'18',1,0)
    100. 

  100.         +DECODE(G02SC.CRK_CD10,'18',1,0)) aokeng                    --凹坑
    101. 

  101.         ,SUM(DECODE(G02SC.CRK_CD1,'17',1,0)
    102. 

  102.         +DECODE(G02SC.CRK_CD2,'17',1,0)
    103. 

  103.         +DECODE(G02SC.CRK_CD3,'17',1,0)
    104. 

  104.         +DECODE(G02SC.CRK_CD4,'17',1,0)
    105. 

  105.         +DECODE(G02SC.CRK_CD5,'17',1,0)
    106. 

  106.         +DECODE(G02SC.CRK_CD6,'17',1,0)
    107. 

  107.         +DECODE(G02SC.CRK_CD7,'17',1,0)
    108. 

  108.         +DECODE(G02SC.CRK_CD8,'17',1,0)
    109. 

  109.         +DECODE(G02SC.CRK_CD9,'17',1,0)
    110. 

  110.         +DECODE(G02SC.CRK_CD10,'17',1,0)) tukuai                    --凸块
    111. 

  111.         --'',                                                       --化废 
    112. 

  112.         --'',                                                       --弯曲 
    113. 

  113.         ,SUM(DECODE(G02SC.CRK_CD1,'01',1,0)
    114. 

  114.         +DECODE(G02SC.CRK_CD2,'01',1,0)
    115. 

  115.         +DECODE(G02SC.CRK_CD3,'01',1,0)
    116. 

  116.         +DECODE(G02SC.CRK_CD4,'01',1,0)
    117. 

  117.         +DECODE(G02SC.CRK_CD5,'01',1,0)
    118. 

  118.         +DECODE(G02SC.CRK_CD6,'01',1,0)
    119. 

  119.         +DECODE(G02SC.CRK_CD7,'01',1,0)
    120. 

  120.         +DECODE(G02SC.CRK_CD8,'01',1,0)
    121. 

  121.         +DECODE(G02SC.CRK_CD9,'01',1,0)
    122. 

  122.         +DECODE(G02SC.CRK_CD10,'01',1,0)) tuofang                    --脱方
    123. 

  123.         --'',                                                        --疏松 
    124. 

  124.         FROM TBG02_CHARGE_COMM G02CC
    125. 

  125.         ,TBG02_SLAB_COMM       G02SC
    126. 

  126.         WHERE G02CC.CHARGE_NO = SUBSTR(G02SC.SLAB_NO,1,10)
    127. 

  127.         AND   DECODE(?,'1',G02SC.SMS_YARD_EXT_DTIME,'2',G02CC.CASTING_END_DTIME , '3' , G02CC.INGR_DEC_DTIME) >= ?||'01000000'
    128. 

  128.         AND   DECODE(?,'1',G02SC.SMS_YARD_EXT_DTIME,'2',G02CC.CASTING_END_DTIME , '3' , G02CC.INGR_DEC_DTIME) <= ?||'235959'  
    129. 

  129.         AND   G02CC.STL_GRD                                                      LIKE       ?||'%'
    130. 

  130.         GROUP BY G02CC.CHARGE_NO)Y
    131. 

  131.         WHERE X.CHARGE_NO = Y.CHARGE_NO
    132. 

  132. 		AND   X.CHARGE_NO   BETWEEN   ?  AND   ?	
    133. 

  133.         ]]>   
    134. 

  134.     </query> 
    135. 

  135. 	
    136. 

  136. 	<query id="UIB030020_02.SELECT" desc="">
    137. 

  137. SELECT * FROM 
    138. 

  138.     -------------A
    139. 

  139. (SELECT     SUM(DECODE(SC.CRK_CD1,'07',1,0))   LIEWEN            --裂纹  
    140. 

  140.            ,SUM(DECODE(SC.CRK_CD1,'10',1,0))   JIAZA             --夹杂
    141. 

  141.            ,SUM(DECODE(SC.CRK_CD1,'31',1,0))   FENCENG           --分层 
    142. 

  142.            ,SUM(DECODE(SC.CRK_CD1,'14',1,0))   QIKONG            --气孔
    143. 

  143.            ,SUM(DECODE(SC.CRK_CD1,'30',1,0))   SHUANGJIAO        --双浇
    144. 

  144.            ,SUM(DECODE(SC.CRK_CD1,'18',1,0))   AOKENG            --凹坑
    145. 

  145.            ,SUM(DECODE(SC.CRK_CD1,'17',1,0))   TUKUAI            --凸块       
    146. 

  146.            ,SUM(DECODE(SC.CRK_CD1,'01',1,0))   TUOFANG           --脱方    
    147. 

  147.       ,( SUM(DECODE(SC.CRK_CD1,'07',1,0))                    --裂纹  
    148. 

  148.              +SUM(DECODE(SC.CRK_CD1,'10',1,0))                   --夹杂
    149. 

  149.              +SUM(DECODE(SC.CRK_CD1,'31',1,0))                   --分层 
    150. 

  150.              +SUM(DECODE(SC.CRK_CD1,'14',1,0))                   --气孔
    151. 

  151.              +SUM(DECODE(SC.CRK_CD1,'30',1,0))                   --双浇
    152. 

  152.              +SUM(DECODE(SC.CRK_CD1,'18',1,0))                   --凹坑
    153. 

  153.              +SUM(DECODE(SC.CRK_CD1,'17',1,0))                   --凸块       
    154. 

  154.              +SUM(DECODE(SC.CRK_CD1,'01',1,0))                   --脱方 
    155. 

  155.             ) OFF
    156. 

  156.            ,( SUM(DECODE(SC.CRK_CD1,'07',SC.SLAB_WGT,0))                 --裂纹  
    157. 

  157.              +SUM(DECODE(SC.CRK_CD1,'10',SC.SLAB_WGT,0))                 --夹杂
    158. 

  158.              +SUM(DECODE(SC.CRK_CD1,'31',SC.SLAB_WGT,0))                 --分层 
    159. 

  159.              +SUM(DECODE(SC.CRK_CD1,'14',SC.SLAB_WGT,0))                 --气孔
    160. 

  160.              +SUM(DECODE(SC.CRK_CD1,'30',SC.SLAB_WGT,0))                 --双浇
    161. 

  161.              +SUM(DECODE(SC.CRK_CD1,'18',SC.SLAB_WGT,0))                 --凹坑
    162. 

  162.              +SUM(DECODE(SC.CRK_CD1,'17',SC.SLAB_WGT,0))                 --凸块       
    163. 

  163.              +SUM(DECODE(SC.CRK_CD1,'01',SC.SLAB_WGT,0))                 --脱方 
    164. 

  164.             ) DUNWEI
    165. 

  165.             ,SUBSTR(SC.SLAB_NO , 1,10)SLAB_NO
    166. 

  166.             ,SC.SMS_YARD_EXT_DTIME
    167. 

  167. FROM    TBG02_SLAB_COMM   SC 
    168. 

  168. GROUP BY  SUBSTR(SC.SLAB_NO , 1,10) , SC.SMS_YARD_EXT_DTIME ) A
    169. 

  169.     -----------B
    170. 

  170. ,(
    171. 

  171.     SELECT G02CC.CHARGE_NO 
    172. 

  172.    ,G02CC.STL_GRD
    173. 

  173.    ,G02CC.CASTING_END_DTIME
    174. 

  174.    ,G02CC.INGR_DEC_DTIME
    175. 

  175.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'C',B02WI.CHEM_VAL))  C
    176. 

  176.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'MN',B02WI.CHEM_VAL)) MN
    177. 

  177.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'S',B02WI.CHEM_VAL))  S
    178. 

  178.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'P',B02WI.CHEM_VAL))  P
    179. 

  179.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'SI',B02WI.CHEM_VAL)) SI
    180. 

  180.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'CR',B02WI.CHEM_VAL)) CR
    181. 

  181.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'NI',B02WI.CHEM_VAL)) NI
    182. 

  182.    ,MAX(DECODE(UPPER(B02WI.CHEM_CD)
    183. 

  183.    ,'QB1',B02WI.CHEM_VAL
    184. 

  184.    ,'QB2',B02WI.CHEM_VAL
    185. 

  185.    ,'QB3',B02WI.CHEM_VAL))CEQ
    186. 

  186.     FROM      TBG02_CHARGE_COMM G02CC  ,TBB02_WORK_INGR B02WI
    187. 

  187.     WHERE     G02CC.CHARGE_NO    =  B02WI.CHARGE_NO
    188. 

  188.     AND       G02CC.LST_INGR_CD  =  B02WI.PROC_CD||B02WI.CHEM_SEQ
    189. 

  189.     GROUP BY  G02CC.CHARGE_NO
    190. 

  190.              ,G02CC.STL_GRD
    191. 

  191.              ,G02CC.CASTING_END_DTIME
    192. 

  192.              ,G02CC.INGR_DEC_DTIME) B
    193. 

  193.     ----------WHERE
    194. 

  194. WHERE    SUBSTR(A.SLAB_NO ,1,10 )  =    B.CHARGE_NO
    195. 

  195. AND      B.CHARGE_NO         BETWEEN  ?   AND  ?
    196. 

  196. AND      DECODE(?,'1',A.SMS_YARD_EXT_DTIME,'2',B.CASTING_END_DTIME , '3' , B.INGR_DEC_DTIME) BETWEEN  ?||'0000'   AND   ?||'9999'
    197. 

  197. AND      B.STL_GRD  LIKE ?||'%'    
    198. 

  198. 	</query>
    199. 

  199. 	
    200. 

  200. 	<query id="UIB030020_03.SELECT" desc="复样量">
    201. 

  201. 		SELECT   SUM(DECODE(WIR.CHEM_L2_PROC_CD , 'FCP' , 1 , 0))/COUNT(*)     FU
    202. 

  202. 		FROM     TBB02_WORK_INGR WIR , TBG02_CHARGE_COMM CCM 
    203. 

  203. 		WHERE    WIR.CHARGE_NO = CCM.CHARGE_NO AND WIR.PROC_CD||WIR.CHEM_SEQ = CCM.LST_INGR_CD
    204. 

  204. 		AND      CHEM_CD       = 'C' 
    205. 

  205. 		AND      WIR.REG_DTIME   BETWEEN   ?||'0000'   AND   ?||'9999'
    206. 

  206. 		AND      WIR.CHARGE_NO   BETWEEN   ?   AND   ?
    207. 

  207. 	</query>
    208. 

  208. </queryMap>
    209.