XinYu_LZMES/.svn/pristine/0b/0b9d819f29c8931a705fd257779c2eebc4862cc3.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="轧辊磨削">
	
	<query id="UIK050101_01.SELECT"  desc="查询磨削实绩">
		<![CDATA[		
			select t.roll_number,
       to_char(t.grind_start_time,'yyyy-mm-dd-hh24:mi:ss') grind_start_time,
       to_char(t.grind_end_time,'yyyy-mm-dd-hh24:mi:ss') grind_end_time,
       t.roughness,
       t.roll_diameter_md_before,
       t.roll_diameter_md_after,
       t.crownheight,
       t.PROGRAM_NUMBE,
       t.crackmax,
       t.crackmaxlocation,
       t.crackangle,
       t.bruisemax,
       t.bruiseangle,
       t.stock_removeal_md,
       t.station_no,
       t.grindwheelsize,
       t.operator,
       t.hardness_md,
       t.id,
       t.flag,
       t.grind_amount,
       t.roll_roundness,
       t.roll_type
  from tbs02_roll_grind t
 where t.roll_number like ? || '%'
   and ((substr(to_char(t.grind_start_time, 'yyyymmddhh24miss'), 1, 8) between
       ? and ?) or
       (substr(t.grind_date, 1, 8) between ? and ?))	
		]]>
	</query>
	<query id="UIK050101_02.SELECT"  desc="查询轧辊明细">
		<![CDATA[		
			select t.id,
       to_char(t.timestart,'yyyy-mm-dd hh24:mi:ss') timestart,
       to_char(t.timeend,'yyyy-mm-dd hh24:mi:ss' ) timeend,
       t.code,
       decode(t.flag,'ROLLDOWN','换辊','ROLLGRIND','磨削') flag
  from tbs02_roll_detail t
  where t.id like ?||'%'
  and to_char(t.timestart,'yyyymmdd') between ? and ?		
		]]>
	</query>
	<query id="UIK050101_03.SELECT"  desc="查询轧辊明细">
		<![CDATA[		
			select t.id,
       to_char(t.timestart,'yyyy-mm-dd hh24:mi:ss') timestart,
       to_char(t.timeend,'yyyy-mm-dd hh24:mi:ss' ) timeend,
       t.code,
       decode(t.flag,'ROLLDOWN','换辊','ROLLGRIND','磨削') flag
  from tbs02_roll_detail t
  where t.id like ?||'%'		
		]]>
	</query>
	<query id="UIK050101_01.UPDATE"  desc="磨削更改">
		<![CDATA[		
			update tbs02_roll_grind t
   				set PROGRAM_NUMBE           = ?,
       			ROUGHNESS               = ?,
       			ROLL_DIAMETER_MD_BEFORE = ?,
       			BRUISEMAX               = ?,
       			GRIND_AMOUNT            = ?,
       			STATION_NO              = ?,
       			ROLL_DIAMETER_MD_AFTER  = ?,
       			HARDNESS_MD             = ?,
       			ROLL_TYPE               = ?,
       			ROLL_ROUNDNESS          = ?,
       			CRACKMAX                = ?
 			where t.roll_number = ?
 			and substr(t.grind_start_time,1,8) between ? and ?	
	
		]]>
	</query>
	<query id="UIK050103_01.SELECT"  desc="轧辊消耗">
		<![CDATA[		
		select t.ROLLID_UP ROLLID,
       t.roll_type,
       t.RESERVE1 RESERVE,
       t.stand_id,
       to_char(t.reg_dtime, 'yyyy-mm-dd hh24:mi:ss') reg_dtime,
       t.spec_no,
       t.SHIFT,
       'UP' DIS   
  from c_tbk05_roll_up t
 where t.rollid_up like ? || '%'
   and (t.roll_type like ? || '%' or t.ROLL_TYPE is null)
   and to_char(t.reg_dtime, 'yyyymmdd') between ? and ?
   union all
   select t.ROLLID_LO ROLLID,
       t.roll_type,
       t.RESERVE2 RESERVE,
       t.stand_id,
       to_char(t.reg_dtime, 'yyyy-mm-dd hh24:mi:ss') reg_dtime,
       t.spec_no,
       t.SHIFT,
       'LO' DIS 
  from c_tbk05_roll_up t
 where t.rollid_up like ? || '%'
   and (t.roll_type like ? || '%' or t.ROLL_TYPE is null)
   and to_char(t.reg_dtime, 'yyyymmdd') between ? and ?
		]]>
	</query>
	<query id="UIK050103_01.UPDATE"  desc="换辊更改">
		<![CDATA[		
			update c_tbk05_roll_up t
   				set t.ROLL_TYPE = ?,
       				t.RESERVE1  = ?,
       				t.STAND_ID  = ?,
       				t.REG_DTIME = to_date(?, 'yyyy-MM-dd HH24:mi:ss')
 				where t.ROLLID_UP = ?
   					  and t.SPEC_NO = ?
	
		]]>
	</query>
	
	<query id="UIK050103_02.UPDATE"  desc="换辊更改">
		<![CDATA[		
			update c_tbk05_roll_up t
   				set t.ROLL_TYPE = ?,
       				t.RESERVE2  = ?,
       				t.STAND_ID  = ?,
       				t.REG_DTIME = to_date(?, 'yyyy-MM-dd HH24:mi:ss')
 				where t.ROLLID_LO = ?
   					  and t.SPEC_NO = ?
	
		]]>
	</query>
	<query id="UIK050103_01.CALL"  desc="">
 		<![CDATA[
				{call C_PKG_UIK.ROLL_DETAIL(?,?,?)}
			]]>
	</query>
	<query id="UIK050103_02.SELECT"  desc="轧辊消耗报表">
		<![CDATA[		
		select t.ROLL_id,
       			t.roll_type,
       			t.roll_diam_before,
       			t.reg_dtime1,
       			t.roll_diam_after,
       			t.reg_dtime2,
       			round(NVL(power(t.roll_diam_before,2) - power(t.roll_diam_after,2), 0) * 3.14 * 7.85 * 0.25 *
             decode(t.roll_type, 'IMR', '1580', '1550'),
             2) rolluse
  		from tbk05_roll_expend t
 		where t.roll_id like ?||'%'
   				and (t.roll_type like ?||'%' or t.roll_type is null)
   				and substr(t.reg_dtime1,1,8) between ? and ?
		]]>
	</query>
	<query id="UIK050103_03.SELECT"  desc="轧辊消耗报表">
		<![CDATA[		
 		SELECT t.roll_type,
          round(SUM(NVL(power(t.roll_diam_before, 2) -
                        power(t.roll_diam_after, 2),
                        0) * 3.14 * 7.85 * 0.25 *
                    decode(t.roll_type, 'IMR', '1580', '1550')),
                2) rolluse, --消耗量
          
          round(SUM(NVL(power(t.roll_diam_before, 2) - power(t.roll_diam_after, 2), 0) * 3.14 * 7.85 * 0.25 * decode(t.roll_type, 'IMR', '1580', '1550') / t.pltcm_wgt), 4) rolluse1,
          
          round(sum(NVL(power(t.roll_diam_before, 2) - power(t.roll_diam_after, 2), 0) * 3.14 * 7.85 * 0.25 * decode(t.roll_type, 'IMR', '1580', '1550') * decode(t.ROLL_TYPE, 'BUR', '23.11', '21.51')), 2) rolluse2,
          
          round(sum(NVL(power(t.roll_diam_before, 2) -
                        power(t.roll_diam_after, 2),
                        0) * 3.14 * 7.85 * 0.25 *
                    decode(t.roll_type, 'IMR', '1580', '1550') *
                    decode(t.ROLL_TYPE, 'BUR', '23.11', '21.51') /
                    t.pltcm_wgt),
                4) rolluse3
      FROM tbk05_roll_expend t
      GROUP BY t.roll_type
		]]>
	</query>
</queryMap>