XinYu_LG2MES/ServerSolution/WebRoot/WEB-INF/query/.svn/text-base/QueryCommonModule.xml.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="作业管理公共信息">
	<query id="GetHeatRegulation.Select" desc="查询加热处理号，炉号规则信息" fetchSize="10">
        <![CDATA[
       select itemcode, itemname, startposition, itemlength, flag
         from scm_heat_regulation
        where flag = '1'
	 ]]>
    </query>
    
    <query id="GetCurrDuty.Select" desc="获取班次信息" fetchSize="10">
        <![CDATA[
             select mes_lg_common.getlgshift1(sysdate) from dual
	     ]]>
    </query>
    
    <query id="GetManualOperateInfo.Select" desc="查询作业手动操作配置信息" fetchSize="10">
        <![CDATA[
                select t.stationcode,
				       t.OPTTYPE,
				       t.commandtype,
				       t.objectpos,
				       t.optcaption,
				       t.optcommandtype
				  from scm_job_manualoperate t
				 where t.stationcode = ? and t.flag='1'
				 order by t.sortid asc
             
	     ]]>
    </query>
    
    <query id="ReceivePlanInfo.Select" desc="查询指定炉号的作业计划信息" fetchSize="10">
        <![CDATA[
			       select a.HEATNO,
			       a.aim_grade_code,
			       c.steel,
			       '' catalogid,
			       a.STD_CODE,
			       a.PLAN_LINES,
			       a.FACT_ROUTE,
			       a.CAST_ID,
			       a.heat_state,
			       a.PLAN_MAKING_TIME,
			       a.PLAN_MAKER,
			       a.STD_CODE,
			       a.V_HEAT_ID,
			       a.ORD_GON_ID,
			       a.cast_no,
			       a.cast_seq,
			       a.HEAT_NUM,
			       a.len,
			       a.width,
			       a.thick,
			       b.POTNO SENDTOOLID,
			       b.POTDISTINCTION SENDGRADE,
			       b.POTWRAPSTATE INSTANCE,
			       b.POTAGE,
			       (select f.basename
			          from ppc_steel_cutingdetail e, scm_base_info f
			         where e.STANDARDSCODE = f.basecode(+)
			           and e.furnaceno = a.v_heat_id
			           and rownum < 2) ||
			       decode(a.STD_NAME, null, '', '(' || a.STD_NAME || ')') SPECIFICATION,
			       (select SLABWIDTH || '*' || SLABHEIGHT
			          from ppc_STEEL_CUTINGDETAIL
			         where FURNACENO = a.heatno
			           and rownum < 2) Aim_W_T
			  from ppc_STEEL_HEAT a, stl_bof_optinfo b, scm_steel c
			 WHERE a.aim_grade_code = c.steelcode
			   and a.HEATNO = b.heatno(+)
			   and a.heatNo = ?
	 ]]>
    </query>
    
    <query id="ReceiveCraftElement.Select" desc="查询各工序作业化学成分信息" fetchSize="10">
        <![CDATA[
        select CHECKNO,
		       HEATNO,
		       ASSAYTYPECODE,
		       FLAG,
		       C,SI,MN,P,S,NI,CR,CU,ASN,TI,V,MO,B,
		       W,AL,ZN,PB,SN,CA,LA,SB,CE,SE,MG,NB,
		       CD,BI,N,H,O,FE,AT,BA,BE,CS,CL,CO,DY,
		       ER,EU,GD,GA,GE,HF,HO,IND,I,IR,KR,LI,
		       LU,ND,NA,OS,PD,PT,K,PR,RE,RH,RB,SM,
		       SC,SR,TA,TE,TB,TM,YB,Y,ZR,ALT, ALS,
		       ALINS,CSC,CEQ,CEV,CAO,MGO,SIO2,AL2O3,TFEO,
		       FE2O3,H2O,CAF2,P2O5,TFE,CR2O3,TIO2,MNO,
		       ALKALINITY,V2O5,FEO,HIC,Pcm,
		       --round(1536-(nvl(C,0)*78+nvl(Mn,0)*4.9+nvl(Si,0)*7.6+nvl(P,0)*34+nvl(S,0)*30+nvl(Cu,0)*5+nvl(Ni,0)*3.1+nvl(Mo,0)*2+nvl(V,0)*2+nvl(Cr,0)*1.3+nvl(Ti,0)*18+nvl(Als,0)*3.6),2) YXX,
		       CASE WHEN STEELNAME IN ('JBXS60','JBXS30','JBXS23','JBXS18','JBXS14','JBXS12','JBXS12D','JBXS10','JBXS8','JBXS7',
		       'JBXG1300WR','JBXG250WG-1','JBXG300WG-1','JBXG350WD','JBXG350WG','JBXG400WG','JBXG470WG','JBXG470WR','JBXG600WG','JBXG600WM','JBXG600WR','JBXG600WY','JBXG800WR','JBXG600WA')
							THEN ROUND(1538-55*nvl(C,0)-80*nvl(C,0)*nvl(C,0)-13*nvl(SI,0)-4.8*nvl(MN,0)-1.5*nvl(CR,0)-4.3*nvl(NI,0)-30*nvl(P,0)-30*nvl(S,0),2)
							ELSE round(1536-(nvl(C,0)*78+nvl(Mn,0)*4.9+nvl(Si,0)*7.6+nvl(P,0)*34+nvl(S,0)*30+nvl(Cu,0)*5+nvl(Ni,0)*3.1+nvl(Mo,0)*2+nvl(V,0)*2+nvl(Cr,0)*1.3+nvl(Ti,0)*18+nvl(Als,0)*3.6),2) END YXX,
		       case when s=0 then '0' else to_char(round(MN/S,2)) end MNS,
		       case when c=0 then '0' else to_char(round(MN/C,2)) end QD9,
		       STEELNAME,
		       SHIFTCODE,
		       ASSAYDATE,
		       round((0.53-1*C)/(0.53-(0.0885-0.02124*Ni-0.01258*Cu+0.006*Cr+0.00529*Mo+0.01076*V-0.03398*power(Nb,2)-0.00846*Nb-0.00865*power(Ti,3)+0.02595*power(Ti,2)-0.03581*Ti+0.05056*P-0.58528*S-0.443*N-0.0089*Si-0.0145*Mn+0.0144*AlS-0.0115*Si*Mn-0.0031*AlS*Mn+0.0041*power(Si,2)+0.0104*AlS*Si+0.0056*power(AlS,2))),3) BJFYL,
              		   round((0.1688-0.0091*Si-0.0218*Mn+0.0435*AlS-0.0261*Si*Mn-0.0143*AlS*Mn+0.0371*AlS*Si+0.0078*power(Si,2)+0.039*power(AlS,2)+0.0022*power(Si,2)*Mn-0.03522*Ni-0.01632*Cu+0.00116*power(Cr,2)+0.0071*Cr+0.02222*Mo+0.04439*V-0.02474*Nb+0.03484*power(Ti,2)-0.02842*Ti+0.27635*P-2.22519*S-0.55592*N-1*C)/(0.1688-0.0091*Si-0.0218*Mn+0.0435*AlS-0.0261*Si*Mn-0.0143*AlS*Mn+0.0371*AlS*Si+0.0078*power(Si,2)+0.039*power(AlS,2)+0.0022*power(Si,2)*Mn-0.03522*Ni-0.01632*Cu+0.00116*power(Cr,2)+0.0071*Cr+0.02222*Mo+0.04439*V-0.02474*Nb+0.03484*power(Ti,2)-0.02842*Ti+0.27635*P-2.22519*S-0.55592*N-(0.0885-0.02124*Ni-0.01258*Cu+0.006*Cr+0.00529*Mo+0.01076*V-0.03398*power(Nb,2)-0.00846*Nb-0.00865*power(Ti,3)+0.02595*power(Ti,2)-0.03581*Ti+0.05056*P-0.58528*S-0.443*N-0.0089*Si-0.0145*Mn+0.0144*AlS-0.0115*Si*Mn-0.0031*AlS*Mn+0.0041*power(Si,2)+0.0104*AlS*Si+0.0056*power(AlS,2))),3) BJZHL,				       
		  	   ROUND(C + 0.02*Mn + 0.04*Ni - 0.01*Si - 0.1*Mo - 0.04*Cr,3) BHZ
		  from stl_CHEMELEMENT	
		 WHERE HeatNo = ?
		   and substr(checkno, length(checkno), 1) = ?
		 ORDER BY ASSAYTYPECODE DESC
	 ]]>
    </query>
    
     <query id="ReceiveIronCraftElement.Select" desc="查询各工序作业铁水化学成分信息" fetchSize="10">
        <![CDATA[

			SELECT CHECKNO, heatno, ASSAYTYPECODE, c, si, mn, p, s, asn, ni, Cu, sn, sb
  FROM (SELECT *
          FROM STL_CHEMELEMENT
         WHERE HEATNO = ? AND SUBSTR(ASSAYTYPECODE,4) = (SELECT MAX(SUBSTR(ASSAYTYPECODE,4)) 
               FROM (SELECT * FROM STL_CHEMELEMENT WHERE HEATNO = ? UNION SELECT * FROM J#STL_CHEMELEMENT WHERE HEATNO = ?))
        UNION
        SELECT * FROM J#STL_CHEMELEMENT WHERE HEATNO = ?  AND SUBSTR(ASSAYTYPECODE,4) = (SELECT MAX(SUBSTR(ASSAYTYPECODE,4)) 
               FROM (SELECT * FROM STL_CHEMELEMENT WHERE HEATNO = ? UNION SELECT * FROM J#STL_CHEMELEMENT WHERE HEATNO = ?)))

	 ]]>
    </query>
    
    <query id="GetHopperNameBof.Select" desc="查询转炉料仓配置信息" fetchSize="10">
        <![CDATA[
			        select a.MSNUMID,
					       a.MSLOCATION,
					       a.MATERIELTYPE,
					       a.MATERIELCODE,
					       a.MATERIELUNITS,
					       a.JMTYPE,
					       b.MATERIELFORSHORT
					  from STL_MATERIALCONFG a, SCM_MATERIEL b
					 where a.MATERIELCODE = b.MATERIELCODE(+)
					   and a.MATERIELTYPE = b.MATERIELTYPE(+)
					   and a.MSLOCATION = ? and a.MATERIELTYPE=?
					 order by a.MATERIELTYPE
	 ]]>
    </query>
    
    <query id="GetHopperNameSet.Select" desc="查询料仓配置信息" fetchSize="10">
        <![CDATA[
			        select a.MSNUMID,
					       a.MSLOCATION,
					       a.MATERIELTYPE,
					       a.MATERIELCODE,
					       a.MATERIELUNITS,
					       a.JMTYPE,
					       b.MATERIELFORSHORT
					  from STL_MATERIALCONFG a, SCM_MATERIEL b
					 where a.MATERIELCODE = b.MATERIELCODE(+)
					   and a.MATERIELTYPE = b.MATERIELTYPE(+)
					   and a.MSLOCATION = ? and (a.MATERIELTYPE = 'FL' or a.MATERIELTYPE = 'HJ')
					 order by a.MATERIELTYPE
	 ]]>
    </query>
    
    
    <query id="GetHopperName.Select" desc="作业管理查询料仓配置信息" fetchSize="10">
        <![CDATA[
			        select a.MSNUMID,
					       a.MSLOCATION,
					       a.MATERIELTYPE,
					       a.MATERIELCODE,
					       a.MATERIELUNITS,
					       a.JMTYPE,
					       b.MATERIELFORSHORT
					  from STL_MATERIALCONFG a, SCM_MATERIEL b
					 where a.MATERIELCODE = b.MATERIELCODE(+)
					   and a.MATERIELTYPE = b.MATERIELTYPE(+)
					   and a.MSLOCATION = ? and (a.MATERIELTYPE = 'FL' or a.MATERIELTYPE = 'HJ' or a.MATERIELTYPE = 'WS')
					 order by a.MATERIELTYPE
	 ]]>
    </query>
    
    <query id="GetMaterialData.Select" desc="查询物料配置信息" fetchSize="10">
        <![CDATA[
		        select MATERIELCODE,
				       MATERIELNAME,
				       MATERIELFORSHORT,
				       decode(MATERIELTYPE,'FL','辅料', decode(MATERIELTYPE,'HJ','合金',decode(MATERIELTYPE,'WS','喂线','保护渣'))) WLLXM,
				       MATERIELTYPE
				  from SCM_MATERIEL order by MATERIELTYPE
	 ]]>
    </query>
    
    
    <query id="GetHndMtrInfo.Select" desc="查询手投料物料信息" fetchSize="10">
        <![CDATA[
		        select MATERIELCODE,
				       MATERIELFORSHORT,
				       MATERIELNAME,
				       CASE MATERIELTYPE
				         WHEN 'FL' THEN
				          '辅料'
				         WHEN 'HJ' THEN
				          '合金'
				         ELSE
				          '喂丝'
				       END MATERIELTYPE
				  from SCM_MATERIEL
				 WHERE MATERIELTYPE IN (?, ?, ?, ?)
				 order by materielcode
	 ]]>
    </query>
    
     <query id="GetHndTrwMtr.Select" desc="查询手投料配置信息" fetchSize="10">
        <![CDATA[
		        select CONFGITEM, USEDLOCATION, USEDEXPLAIN, CONFGCODE
				  from stl_interfaceconfg
				 where CONFGITEM = ?
				   and USEDLOCATION = 'STL'
	 ]]>
    </query>
    
    <query id="GetStationconMaterialData.Select" desc="查询岗位对应物料配置信息" fetchSize="10">
        <![CDATA[
		        select MATERIELCODE,
				       MATERIELNAME,
				       MATERIELFORSHORT,
				       decode(MATERIELTYPE,
				              'FL',
				              '辅料',
				              decode(MATERIELTYPE,
				                     'HJ',
				                     '合金',
				                     decode(MATERIELTYPE, 'WS', '喂线', '保护渣'))) WLLXM,
				       MATERIELTYPE
				  from scm_stationconmateriel
				 where craftposid = ?
				 order by MATERIELTYPE
	 ]]>
    </query>
    
    <query id="SwapHopper.Procedure" desc="设置料仓物料信息" fetchSize="10">
        <![CDATA[
		        job_lg_manage.sethopper
	 ]]>
    </query>
    
      <query id="SwapHatHopper.Procedure" desc="设置手动料仓物料信息" fetchSize="10">
        <![CDATA[
		        JOB_LG_MANAGE.Savesj_jmwgpz
	 ]]>
    </query>
    
    <query id="UpdateTableField.Update" desc="更新作业的操作记录表字段信息" fetchSize="10">
        <![CDATA[
		        JOB_LG_MANAGE.updatetblefield
	 ]]>
    </query>
    
    <query id="UpdateHMPTableField.Update" desc="更新脱硫作业的操作记录表字段信息" fetchSize="10">
        <![CDATA[
		        JOB_LG_MANAGE.UpdateHmptblefield
	 ]]>
    </query>
    
     <query id="AddMaterialProc.INSERT" desc="新增过程添加料操作记录" fetchSize="10">
        <![CDATA[
		        JOB_LG_MANAGE.InsertProcData
	 ]]>
    </query>
    
     <query id="GetBofSamplingData.Select" desc="查询转炉采样信息" fetchSize="10">
        <![CDATA[
		        SELECT a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  FROM stl_BOF_SAMPLING a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM stl_BOF_SAMPLING
				         GROUP BY heatprocessno) b
				 WHERE a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and STATIONCODE = ?
				   and DISPOSALTIME = ?
				union
				select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  from stl_tempsampling a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM stl_tempsampling
				         GROUP BY heatprocessno) b
				 where a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and substr(STATIONCODE, 0, 1) = ?
				   and DISPOSALTIME = ?
	 ]]>
    </query>
    
    <query id="GetCasSamplingData.Select" desc="查询吹氩采样信息" fetchSize="10">
        <![CDATA[
		        SELECT a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  FROM STL_CAS_SAMPLING a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM STL_CAS_SAMPLING
				         GROUP BY heatprocessno) b
				 WHERE a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and STATIONCODE = ?
				   and DISPOSALTIME = ?
				union
				select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  from stl_tempsampling a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM stl_tempsampling
				         GROUP BY heatprocessno) b
				 where a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and substr(STATIONCODE, 0, 1) = ?
				   and DISPOSALTIME = ?
	 ]]>
    </query>
    
    <query id="GetLfsSamplingData.Select" desc="查询LF炉采样信息" fetchSize="10">
        <![CDATA[
		        SELECT a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  FROM STL_LFS_SAMPLING a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM STL_LFS_SAMPLING
				         GROUP BY heatprocessno) b
				 WHERE a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and STATIONCODE = ?
				   and DISPOSALTIME = ?
				union
				select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  from stl_tempsampling a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM stl_tempsampling
				         GROUP BY heatprocessno) b
				 where a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and substr(STATIONCODE, 0, 1) = ?
				   and DISPOSALTIME = ?
	 ]]>
    </query>
    
    <query id="GetRhsSamplingData.Select" desc="查询RH炉采样信息" fetchSize="10">
        <![CDATA[
		        SELECT a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  FROM STL_RHS_SAMPLING a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM STL_RHS_SAMPLING
				         GROUP BY heatprocessno) b
				 WHERE a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and STATIONCODE = ?
				   and DISPOSALTIME = ?
				union
				select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  from stl_tempsampling a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM stl_tempsampling
				         GROUP BY heatprocessno) b
				 where a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and substr(STATIONCODE, 0, 1) = ?
				   and DISPOSALTIME = ?
	 ]]>
    </query>
    
     <query id="GetVdsSamplingData.Select" desc="查询VD炉采样信息" fetchSize="10">
        <![CDATA[
		        SELECT a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  FROM STL_VDS_SAMPLING a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM STL_VDS_SAMPLING
				         GROUP BY heatprocessno) b
				 WHERE a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and STATIONCODE = ?
				   and DISPOSALTIME = ?
				union
				select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  from stl_tempsampling a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM stl_tempsampling
				         GROUP BY heatprocessno) b
				 where a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and substr(STATIONCODE, 0, 1) = ?
				   and DISPOSALTIME = ?
	 ]]>
    </query>
    
     <query id="GetCcmSamplingData.Select" desc="查询连铸机采样信息" fetchSize="10">
        <![CDATA[
		        SELECT a.HEATPROCESSNO,a.SAMPLINGID,to_char(a.SAMPLINGNAME, 'yyyy-MM-dd HH24:mi:ss') SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  FROM STL_CCM_SAMPLING a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM STL_CCM_SAMPLING
				         GROUP BY heatprocessno) b
				 WHERE a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and STATIONCODE = ?
				   and DISPOSALTIME = ?
				union
				select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,to_char(a.SAMPLINGDATE, 'yyyy-MM-dd HH24:mi:ss') SAMPLINGDATE
				  from stl_tempsampling a,
				       (SELECT heatprocessno, MAX(samplingid) samplingid
				          FROM stl_tempsampling
				         GROUP BY heatprocessno) b
				 where a.heatprocessno = b.heatprocessno
				   and HEATNO = ?
				   and substr(STATIONCODE, 0, 1) = ?
				   and DISPOSALTIME = ?
	 ]]>
    </query>
    
    <query id="GetFromToolInfo_Custom.Select" desc="查询窗体工具栏信息,带参数" fetchSize="10">
        <![CDATA[
		        SELECT ID, KEY, CAPTION, IMAGE
				  FROM core_app_function
				 WHERE PARENT_ID =
				       (select ID
				          from core_app_function t
				         where key = ?
				           and custominfo = ? ) order by id
	 ]]>
    </query>
    
    <query id="GetFromToolInfo.Select" desc="查询窗体工具栏信息,不带参数" fetchSize="10">
        <![CDATA[
		        SELECT ID, KEY, CAPTION, IMAGE
				  FROM core_app_function
				 WHERE PARENT_ID =
				       (select ID
				          from core_app_function t
				         where key = ?
				           and custominfo is null) order by id
	 ]]>
    </query>
    
     <query id="GetAllowOperate.Select" desc="查询LF炉当前允许操作工序" fetchSize="10">
        <![CDATA[
			   select decode(t.car1allowoperate,
				              '1',
				              '1#位允许操作',
				              decode(t.car2allowoperate, '1', '2#位允许操作', '')) Lfs1allowOperate,
				       decode(t1.car1allowoperate,
				              '1',
				              '1#位位允许操作',
				              decode(t1.car2allowoperate, '1', '2#位允许操作', '')) Lfs2allowOperate
				  from rtd_pointlfs1no1 t, rtd_pointlfs2no1 t1
	 ]]>
    </query>
    
     <query id="GetRhsAllowOperate.Select" desc="查询RH炉当前允许操作工序" fetchSize="10">
        <![CDATA[
			    select decode(t.car1allowoperate,
                      '1',
                      '1#位允许操作',
                      decode(t.car2allowoperate, '1', '2#位允许操作', '')) Rhs1allowOperate              
          from rtd_pointrhs1no1 t
	 ]]>
    </query>
    
     <query id="GetJobStandardElement.Select" desc="查询作业化学成分标准信息" fetchSize="10">
        <![CDATA[
			    select t.cic,t.stdstyle,t.steel,t1.itemcode,t1.std,t1.stdmin,t1.stdmax,t1.stdsign
				  from scm_sortcode_chem t, scm_standard_chem t1
				 where t.cic = t1.cic
				   and (t.stdstyle = '1' or t.stdstyle = '2' or t.stdstyle = '3')
				   and t.gycode = ?
				 order by t.stdstyle , itemcode
	 ]]>
    </query>
    
    <query id="GetJobStandardTemp.Select" desc="查询温度作业标准" fetchSize="10">
        <![CDATA[
			    select a.craftcode,
				       a.processcode PROCESSID,
				       a.STEELCODE,
				       b.CRAFTITEMNAME,
				       a.craftitemcode1 ITEM1,
				       a.itemminvalue1 ITEM1MIN,
				       a.itemmaxvalue1 ITEM1MAX,
				       c.name_
				  from SCM_CRAFTSTANDARD a, SCM_CRAFT_ITEM b, scm_processinfo c
				 where a.craftitemcode1 = b.CRAFTITEMID(+)
				   and a.processcode = c.processid
				   and substr(a.processcode, 1, 1) = 'L'
				   and a.craftitemcode1 in
				       ('LG0201002', 'LG0301002', 'LG0401002', 'LG0501002', 'LG0601002',
				        'LG0601005', 'LG0701002')
				   and steelcode = ?
				 order by a.xh
	 ]]>
    </query>
    
    <query id="GetJobStandardTemp2.Select" desc="查询温度作业标准2" fetchSize="10">
        <![CDATA[
		         select steelname,
				        leavetemptc_d,
				        arrivetemptd_d,
				        leavetemptd_d,
				        arrivetemptg_d,
				        leavetemptc_e,
				        arrivetemptd_e,
				        leavetempte_e,
				        arrivetemptg_e,
				        leavetemptc_f,
				        arrivetemptd_f,
				        arrivetemptf_f,
				        leavetemptf_f,
				        arrivetemptg_f,
				        leavetemptc_ef,
				        arrivetemptd_ef,
				        leavetempte_ef,
				        leavetemptf_ef,
				        arrivetemptg_ef,
				        leavetemptc_ei,
				        arrivetemptd_ei,
				        leavetempte_ei,
				        leavetempti_ei,
				        arrivetemptg_ei
				        , (select a.fact_route From ppc_steel_heat a where a.heatno = ?) factlines
			   from temperature_standard t
			   where t.steelname = ?
	 ]]>
    </query>
    
    <query id="GetJobStandardMateriel.Select" desc="查询物料消耗标准" fetchSize="10">
        <![CDATA[
			    select a.craftcode,
				       a.processcode PROCESSID,
				       a.STEELCODE,
				       b.CRAFTITEMNAME,
				       a.craftitemcode1 ITEM1,
				       a.itemminvalue1 ITEM1MIN,
				       a.itemmaxvalue1 ITEM1MAX,
				       c.name_
				  from SCM_CRAFTSTANDARD a, SCM_CRAFT_ITEM b, scm_processinfo c
				 where a.craftitemcode1 = b.CRAFTITEMID(+)
				   and a.processcode = c.processid
				   and substr(a.processcode, 1, 1) = 'L'
				   and substr(a.craftitemcode1, 1, 6) in
				       ('LG0202', 'LG0302', 'LG0402', 'LG0502')
				   and (a.itemminvalue1 IS NOT NULL OR a.itemmaxvalue1 IS NOT NULL)
				   and steelcode = ?
				 order by a.xh
	 ]]>
    </query>
    
    <query id="GetdDetectTasklList.Select" desc="查询探伤统计数据" fetchSize="10">
        <![CDATA[
			    select sum(unqualitySum) unqualitySum,sum(qualitySum) qualitySum,t1.thick,sum(unqualityWeight) unqualityWeight
				,sum(qualityWeight) qualityWeight,sum(T1.SUMALL) SUMALL,ROUND((sum(qualitySum)/sum(T1.SUMALL))*100,2)||'%' qualityrate from (
					SELECT * from (select  --(SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep) DetectStep,
						sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') > 0 then 1 else 0 end) unqualitySum,
						sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 then 1 else 0 end) qualitySum,
						               M.BILLETTHICK thick,
						               sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') > 0 THEN A.WEIGHT ELSE 0 END) unqualityWeight,
						               SUM(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 THEN A.WEIGHT ELSE 0 END) qualityWeight,
						               count(*) sumall
						          FROM KCH_DETECTMARTASKLIST    A,
						               zyhb_plandetailofplate   B,
						               ZYHB_PLANOFMOTHERPLATE   M
						         WHERE a.creattime = (select max(creattime)
						                                from KCH_DETECTMARTASKLIST
						                               where billetid = a.billetid)
						           AND A.BILLETID = B.SLABNO(+)
						           AND B.MOTHERSLAB = M.MOTHERPLATEID(+)
						           AND ？
								   AND SUBSTR(a.STOVENO, 3, 1) in ('1','2','3')
								   group by M.BILLETTHICK order by M.BILLETTHICK)
					union
					SELECT * from (select
						sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') > 0 then 1 else 0 end) unqualitySum,
						sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 then 1 else 0 end) qualitySum,
						               M.BILLETHEIGHT thick,
						               sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') > 0 THEN A.WEIGHT ELSE 0 END) unqualityWeight,
						               SUM(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 THEN A.WEIGHT ELSE 0 END) qualityWeight,
						               count(*) sumall
						          FROM KCZ_DETECTMARTASKLIST    A,
						               MB_PLANDETAILOFPLATE     B,
						               MB_PLANOFMOTHERPLATE     M,
						               kcZ_turnofflist          E
						         WHERE a.creattime = (select max(creattime)
						                                from KCZ_DETECTMARTASKLIST
						                               where billetid = a.billetid
						                                 and isvalid <> '0')
						           AND A.BILLETID = E.BILLETID(+)
						           AND B.MOTHERPLATEID = M.MOTHERPLATEID(+)
						           AND A.BILLETID = B.PRODUCTNO(+)
						           AND ？
						           AND SUBSTR(e.STOVENO, 3, 1) in ('1','2','3')
						group by M.BILLETHEIGHT order by M.BILLETHEIGHT) 
					)T1
				group by t1.thick order by t1.thick

	 ]]>
    </query>
</queryMap>