XinYu_LG2MES/ServerSolution/WebRoot/WEB-INF/query - 副本/.svn/text-base/QueryBofJob.xml.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="转炉作业">

	<query id="GetPlaningInfo.Select" desc="查询作业计划信息" fetchSize="10">
        <![CDATA[
		        select rownum,
				       ORD_GON_ID,
				       HEATNO,
				       t1.steel AIM_GRADE_CODE,
				       CAST_ID,
				       CAST_NO,
				       HEAT_NUM,
				       CAST_SEQ,
				       to_char(PLAN_CCM_STR_TIME, 'yyyy-MM-dd HH24:mi:ss') PLAN_CCM_STR_TIME,
				       STD_NAME,
				       HEAT_STATE
				  from PPC_STEEL_HEAT t, scm_steel t1
				 where t.aim_grade_code = t1.steelcode
				   and HEAT_STATE = '03'
				   and substr(heatno, 3, 1) = ?
				 order by HEATNO asc
	 ]]>
    </query>
    
    <query id="GetBofOptInfo.Select" desc="查询转炉作业信息" fetchSize="10">
        <![CDATA[
			       select HEATPROCESSNO,
					       HEATNO,
					       STATIONCODE,
					       DISPOSALTIME,
					       WOID,
					       OPTDATE,
					       SHIFTCODE,
					       MOLIRNSOURCE,
					       IRONPOTID,
					       IRONPOTWGT,
					       IRONTEMPERATURE,
					       PIGIRONWGT,
					       WSTEELWGT,
					       CHANGESTARTTIME,
					       CHANGEENDTIME,
					       OPENOXYGENTIME,
					       STOPOXYGENTIME,
					       SUPPLYOXYGENTIME,
					       O2PRESS,
					       O2FLUX,
					       O2CONSUME,
					       MOLSTLTEMPERATURE,
					       B1STARTTIME,
					       B1ENDTIME,
					       B1TIME,
					       B1TEMPERATURE,
					       B2STARTTIME,
					       B2ENDTIME,
					       B2TIME,
					       B2TEMPERATURE,
					       B3STARTTIME,
					       B3ENDTIME,
					       B3TIME,
					       B3TEMPERATURE,
					       B4STARTTIME,
					       B4ENDTIME,
					       B4TIME,
					       B4TEMPERATURE,
					       B5STARTTIME,
					       B5ENDTIME,
					       B5TIME,
					       B5TEMPERATURE,
					       TERMINUSTEPT,
					       TERMINUSC,
					       TERMINUSO2,
					       BLOWO2TIMES,
					       BLOWARTIMES,
					       BLOWN2TIMES,
					       TAPPINGSTARTTIME,
					       TAPPINGENDTIME,
					       TAPPINGTIME,
					       BLKREDMODE,
					       OGGNUMID,
					       SUBNUMID,
					       SUBAGE,
                           SUBHEIGHT,
                           SUBTENSION,
					       PSSTARTTIME,
					       PSENDTIME,
					       BRPSTIME,
					       BRPSTIMES,
					       N2PRESS,
					       N2FLUX,
					       N2CONSUME,
					       ARCONSUME,
					       BRWGT,
					       DRWGT,
					       RSSTOVENO,
					       RSWGT,
					       POTNO,
					       POTDISTINCTION,
					       POTAGE,
					       POTWRAPSTATE,
					       TAPPINGWGT,
					       GAGE,
					       SAGE,
					       VFLAG,
					       EMOLSTLTIME,
					       UPDATETIME,
					       MEMO,
					       ARPRESS,
					       ARFLUX,
					       MOLSTLLEAVE,
					       MOLIRNTYPE,
					       TOPN2CONSUME,
					       CCMPLANTEMPT,
					       CCMPLANTEMPTTIME,
					       LMLTEMPT,
					       OGGNO,
					       POTTEMP
					  from STL_BOF_OPTINFO
					 WHERE HEATNO = ?
					   AND STATIONCODE = ?
					   AND DISPOSALTIME = ?
	 ]]>
    </query>
    
    <query id="GetBofSampling.Select" desc="查询转炉作业采样信息" fetchSize="10">
        <![CDATA[
		        select *
				  from stl_bof_sampling t
				 WHERE HEATNO = ?
				   AND STATIONCODE = 'C' || ?
				   AND DISPOSALTIME = ?
				   and samplingname = ?
				   and samplingdate = (select max(samplingdate)
				                         from stl_bof_sampling
				                        WHERE HEATNO = ?
				                          AND STATIONCODE = 'C' || ?
				                          AND DISPOSALTIME = ?
				                          and samplingname = ?)
	 ]]>
    </query>
    
    <query id="GetPlanAndFactTime.Select" desc="查询作业计划时间与实际时间" fetchSize="10">
        <![CDATA[
		        select PLAN_BOF_STR_TIME,
				       PLAN_BOF_END_TIME,
				       B1STARTTIME,
				       decode(B1STARTTIME,
				              null,
				              '0',
				              decode(TAPPINGSTARTTIME,
				                     null,
				                     round((sysdate - B1STARTTIME) * 24 * 60),
				                     round((TAPPINGSTARTTIME - B1STARTTIME) * 24 * 60))) SJZYSJ,
				       decode(B1STARTTIME,
				              null,
				              round((sysdate - PLAN_BOF_STR_TIME) * 24 * 60),
				              round((B1STARTTIME - PLAN_BOF_STR_TIME) * 24 * 60)) SJYS
				  from ppc_steel_heat a, stl_bof_optinfo b
				 where a.HeatNo = b.heatno
				   and b.HeatNo =?
	 ]]>
    </query>
    
    <query id="GetBofTempInfo.Select" desc="查询转炉作业温度信息" fetchSize="10">
        <![CDATA[
		        select HEATPROCESSNO,
				       SAMPLINGID,
				       SAMPLINGNAME,
				       HEATNO,
				       STATIONCODE,
				       DISPOSALTIME,
				       SAMPLINGDEPICT,
				       SAMPLINGVALUE,
				       SAMPLINGDATE
				  from stl_tempsampling
				 WHERE HEATNO = ?
				   AND STATIONCODE ='C'|| ?
				   AND DISPOSALTIME = ?
				 order by samplingdate
	 ]]>
    </query>
    
    <query id="GetMaterialData.Select" desc="查询物料配置信息" fetchSize="10">
        <![CDATA[
		        select MATERIELCODE,
				       MATERIELNAME,
				       MATERIELFORSHORT,
				       decode(MATERIELTYPE,
				              'FL',
				              '辅料',
				              decode(MATERIELTYPE, 'HJ', '合金', '喂线')) WLLXM,
				       MATERIELTYPE
				  from SCM_MATERIEL
	 ]]>
    </query>
    
    <query id="GetBofAdditiveData.Select" desc="查询转炉物料消耗信息" fetchSize="10">
        <![CDATA[
		        select round(sum(JMWGT)) JMWGT,
				       MATERIELCODE,
				       HOPPERNUMID,
				       MATERIELTYPE,
				       JMTYPE
				  from STL_BOF_ADDITIVES
				 WHERE HEATNO = ?
				   AND STATIONCODE = ?
				   AND DISPOSALTIME = ? group by MATERIELCODE, HOPPERNUMID, MATERIELTYPE, JMTYPE
	 ]]>
    </query>
    
    <query id="GetBofIronInfo.Select" desc="查询发送到转炉的铁水信息" fetchSize="10">
        <![CDATA[
		        select MOLIRNSOURCE,
				       MOLIRNSOURCE_Key,
				       decode(MOLIRNSOURCE,
				              '1',
				              '半钢',
				              decode(MOLIRNSOURCE,
				                     '2',
				                     '脱硫',
				                     decode(MOLIRNSOURCE, '3', '混铁炉', '直兑'))) MOLIRNSOURCEName,
				       IRONPOTID,
				       IRONPOTWGT,
				       IRONTEMPERATURE,
				       WEIGHTOFCVT,
				       SMELTINGIDOFCVT,
				       to_char(TAPHOLEENDTIME, 'HH24:mi') TAPHOLEENDTIME
				  from (select '3' MOLIRNSOURCE,
				               MISID as MOLIRNSOURCE_Key,
				               IRONWRAPID as IRONPOTID,
				               IRONPOTWGT,
				               IRONTEMPERATURE,
				               TAPHOLEENDTIME,
				               WEIGHTOFCVT,
				               SMELTINGIDOFCVT,
				               OPERATIONDATE
				          from stl_mis_taphole
				        union
				        select '2' MOLIRNSOURCE,
				               HEATPROCESSNO as MOLIRNSOURCE_Key,
				               IRONPWRAPNO as IRONPOTID,
				               IRONWGT as IRONPOTWGT,
				               SWBTEMPERATURE as IRONTEMPERATURE,
				               LEAVETIME as TAPHOLEENDTIME,
				               to_number('') as WEIGHTOFCVT,
				               '' as SMELTINGIDOFCVT,
				               OPTDATE 
				          from STL_hmp_optinfo
				        union
				        select '4' MOLIRNSOURCE,
				               MISID as MOLIRNSOURCE_Key,
				               IRONWRAPID as IRONPOTID,
				               IRONPOTWGT,
				               IRONTEMPERATURE,
				               TAPHOLEENDTIME,
				               WEIGHTOFCVT,
				               SMELTINGIDOFCVT,
				               OPERATIONDATE
				          from STL_ES_TAPHOLE) a
				 where OPERATIONDATE > to_date(?,'yyyy-MM-dd HH24:mi:ss')
				 order by molirnsource, OPERATIONDATE desc

	 ]]>
    </query>
    
     <query id="GetScrapSteelInfo.Select" desc="查询废钢生铁信息" fetchSize="10">
        <![CDATA[
		        select jobid ZYXH,
				       heatno LH,
				       stationcode GWBH,
				       DISPOSALTIME CLCS,
				       SHIFTCODE BC,
				       CHARGENO ZDDH,
				       WSTEELTYPE FGZL,
				       PIGIRONWGT STZL,
				       JOINMARLWGT CLZL,
				       RSTEELWGT ZGZL,
				       GOODMARLWGT HGZL,
				       TOTALWGT ZZ,
				       CHUTEWGT DZ,
				       JOINSTOVEWGT RLZL,
				       OPTPERSONNEL CZRY,
				       JOBDATE ZYSJ,
				       MEMO BZ,
				       C,
				       SI,
				       MN,
				       P,
				       S,
				       ASN
				  from STL_SCRAPSTEEL
				 where JOBDATE between to_date(?, 'yyyy-MM-dd HH24:mi:ss') and
				       to_date(?, 'yyyy-MM-dd HH24:mi:ss')
				 order by jobid desc
	 ]]>
    </query>
    
     <query id="BofScrapSteel.INSERT" desc="转炉工序确认废钢生铁信息" fetchSize="10">
        <![CDATA[
		        RES_LG_LFSMANAGE.SendFG_ZL
	 ]]>
    </query>
    
    <query id="InitGtt_bofadditives.Update" desc="手动加载作业计划时初始化转炉物料消耗临时表" fetchSize="10">
        <![CDATA[
		        update gtt_bofadditives
				   set additivetotal0  = 0,
				       additivetotal1  = 0,
				       additivetotal2  = 0,
				       additivetotal3  = 0,
				       additivetotal4  = 0,
				       additivetotal5  = 0,
				       additivetotal6  = 0,
				       additivetotal7  = 0,
				       additivetotal8  = 0,
				       additivetotal9  = 0,
				       additivetotal10 = 0,
				       additivetotal11 = 0,
				       lastfreshtime   = sysdate
				 where devpos = ?
				    or devpos = ?

	 ]]>
    </query>
</queryMap>