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

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="配置管理">
	<query id="frmBaseInfo.select" desc="基础信息" fetchSize="10">
        <![CDATA[
 
 	  select t.basecode, t.sortcode pid, t.basename
  		        from scm_base_info t
 				where t.flag = '1' 
   				and length(t.basecode) > 1 
   				$
 				order by t.basecode
        ]]>
	</query>

	<query id="frmBaseInfo_Parent.select" desc=" 获取父节点信息" fetchSize="10">
        <![CDATA[
  
 	  select basecode,
		       basename,
		       memo,
		       recorder,
		       inputtime,
		       sortcode,
		       decode(isvisible, '0', '是', '1', '否') isvisible,
		       memo1,
		       decode(flag, '0', '否', '1', '是') flag,
		       SEQ
  		from scm_base_info where basecode = ?
  		order by  basecode
        ]]>
	</query>
	<query id="frmBaseInfo_Children.select" desc=" 获取对应结点的子节点信息"
		fetchSize="10">
        <![CDATA[
  
 	  select basecode,
		       basename,
		       memo,
		       recorder,
		       inputtime,
		       sortcode,
		       decode(isvisible, '0', '是', '1', '否') isvisible,
		       memo1,
		       decode(flag, '0', '否', '1', '是') flag,
		       SEQ
  		from scm_base_info where sortcode =?
  		order by  basecode
        ]]>
	</query>
	<query id="SaveBaseData.Update" desc="基础信息-修改" fetchSize="10">
        <![CDATA[
        
            MES_LG_CONFIGMGT.baseinfo_update
        ]]>

	</query>
	<query id="SaveBaseData.Add" desc="基础信息-添加" fetchSize="10">
        <![CDATA[
        
            MES_LG_CONFIGMGT.baseinfo_add
        ]]>
	</query>

	<query id="SaveBaseData.Del" desc="基础信息-删除">
		<![CDATA[
		 	MES_LG_CONFIGMGT.baseinfo_del
		 ]]>
	</query>
	<query id="frmJJBBase_Query.select" desc="交接班配置管理" fetchSize="10">
        <![CDATA[

	   select a.itemcode, a.itemtype, a.itemname, a.stationcode, b.description
			  from scm_item_maintenance a, scm_processinfo b
			  where a.stationcode = b.Name_(+)  $
			  order by a.itemcode
  
        ]]>
	</query>

	<query id="frmJJBBase.select" desc="交接班配置管理-查询" fetchSize="10">
        <![CDATA[

    	SELECT * FROM SCM_ITEM_MAINTENANCE T WHERE T.ITEMCODE=?
 
        ]]>
	</query>

	<query id="frmJJBBase_Add.select" desc="交接班配置管理-添加" fetchSize="10">
        <![CDATA[

	  INSERT INTO scm_item_maintenance
			  (itemcode, itemtype, itemname, stationcode)
	  		 VALUES
			  (?,?,?,?)
 
        ]]>
	</query>

	<query id="frmJJBBase_Update.select" desc="交接班配置管理-修改" fetchSize="10">
        <![CDATA[

	   UPDATE scm_item_maintenance
			   SET itemname    = ?,
			       itemtype    = ?,
			       stationcode = ?
			  WHERE itemcode = ?
 
        ]]>
	</query>

	<query id="frmJJBBase_Del.select" desc="交接班配置管理-删除" fetchSize="10">
        <![CDATA[

	  DELETE scm_item_maintenance  WHERE itemcode = ? 
 
        ]]>
	</query>

	<query id="frmStoresProject.select" desc="物料项目配置" fetchSize="10">
        <![CDATA[

	  select   MaterielCode,
		       MaterielType,
		       MaterielName,
		       MaterielforShort,
		       MaterielUnits,
		       JmType
		  from SCM_MATERIEL t where MATERIELTYPE LIKE ? || '%'
 
        ]]>
	</query>

	<query id="frmStoresProject_Save.select" desc="物料项目配置-保存"
		fetchSize="10">
        <![CDATA[

	   INSERT INTO SCM_MATERIEL
			  (MaterielCode, MaterielType, MaterielName, MaterielforShort,MaterielUnits,JmType)
	  		 VALUES
			  (?,?,?,?,?,?)
  
        ]]>
	</query>
	<query id="frmStoresProject_Update.select" desc="物料项目配置-修改"
		fetchSize="10">
        <![CDATA[

	     UPDATE SCM_MATERIEL
			    SET MaterielType    = ?,
			    MaterielforShort    = ?
			  WHERE MaterielCode = ?
 
        ]]>
	</query>
	<query id="frmStoresProject_Del.select" desc="物料项目配置-删除"
		fetchSize="10">
        <![CDATA[

	   DELETE SCM_MATERIEL  WHERE MaterielCode = ? 
 
        ]]>
	</query>
	<query id="frmStationconMateriel.select" desc="岗位与物料配置-物料"
		fetchSize="10">
        <![CDATA[

	   select craftposid,
                 materielcode,
                 materieltype,
                 materielname,
                 memo
           from scm_stationconmateriel where CRAFTPOSID LIKE ? ||'%' and MATERIELTYPE LIKE ? ||'%'
 
        ]]>
	</query>

	<query id="frmSMateriel_AddPInfo.select" desc="岗位与物料配置-新增岗位"
		fetchSize="10">
        <![CDATA[

		INSERT INTO SCM_STATIONCONMATERIEL( CRAFTPOSID,MATERIELCODE,MATERIELTYPE,MATERIELNAME,MATERIELFORSHORT) VALUES (?,?,?,?,?) 
 
        ]]>
	</query>

	<query id="frmSMateriel_DelPInfo.select" desc="岗位与物料配置-删除岗位"
		fetchSize="10">
        <![CDATA[

		DELETE scm_stationconmateriel  WHERE craftposid = ? and  materielcode= ?
 
        ]]>
	</query>

	<query id="frmAdditStat_Load.select" desc="物料消耗加载" fetchSize="10">
        <![CDATA[

		select distinct (a.materielcode) materielcode,
                a.MATERIELTYPE,
                b.materielforshort
			  from STL_additives a, SCM_materiel b
			 where a.materielcode = b.materielcode
			 and b.MATERIELTYPE= ?  and to_char(a.updatetime, 'yyyy-MM-dd') 
	         between ? and ?
 	
        ]]>
	</query>

	<query id="frmAdditStat_Query.select" desc="物料消耗查询" fetchSize="10">
        <![CDATA[
   
		select v.heatprocessno, 
                             v.heatno, 
                             v.PLANSTEEL STEEL,
                             v.STATIONCODE,
                             substr(v.stationcode,3,1) ||'#'|| decode(substr(v.STATIONCODE, 1, 1),
                                 'C','转炉',decode(substr(v.STATIONCODE, 1, 1),
                                 'D','吹氩站',decode(substr(v.STATIONCODE, 1, 1), 
                                 'E','精炼炉',decode(substr(v.STATIONCODE, 1, 1), 
                                 'F','RH炉', decode(substr(v.STATIONCODE, 1, 1),'B','脱硫',''))))) wsid,
                             v.SHIFTCODE,
                             v.MATERIELCODE,
                             d.materielname,
                             v.MATERIELTYPE,
                             round(v.JMWGT,2) JMWGT,
                             v.optdate $ 
                             from (select distinct a.heatprocessno,
                                       a.heatno,
                                       a.optdate,
                                       a.PLANSTEEL,
                                       b.STATIONCODE,
                                       a.wsid,
                                       a.SHIFTCODE,
                                       b.MATERIELCODE,
                                       b.MATERIELTYPE,
                                       round(sum(nvl(b.JMWGT,0)) over (partition by b.HEATNO, b.STATIONCODE, b.DISPOSALTIME, b.MATERIELTYPE, b.MATERIELCODE),2) JMWGT  $ 
                                      from (select * from   $   union select * from J#$  ) a, stl_additives b $ $)v
                             left join (select * from scm_materiel) d on d.materielcode = v.materielcode order by v.heatprocessno desc
                             

 	 
        ]]>
	</query>

	<query id="frmLTemp_Del.select" desc="液相线温度标准-删除" fetchSize="10">
        <![CDATA[

	   			DELETE SCM_LIQUIDUS_TEMP  WHERE ID_ = ? 
 
        ]]>
	</query>

	<query id="frmLTemp_Save.select" desc="液相线温度标准-保存" fetchSize="10">
        <![CDATA[

			   INSERT INTO SCM_LIQUIDUS_TEMP
					  (ID_, STEELNAME, LIQUIDUSTEMP,BEYONDTEMPT)
			  		 VALUES
					  (?,?,?,?)
  
        ]]>
	</query>

	<query id="frmLTemp_Update.select" desc="液相线温度标准-修改" fetchSize="10">
        <![CDATA[
		     
		     UPDATE SCM_LIQUIDUS_TEMP
				    SET LIQUIDUSTEMP    = ?,
				        BEYONDTEMPT     = ?
				  WHERE ID_ = ?
 
        ]]>
	</query>
	
	<query id="frmHLReason_Update.select" desc="连铸非恒拉原因-录入" fetchSize="10">
        <![CDATA[

				  UPDATE STL_CCM_OPTINFO
				    SET PRODUCTCPTCODE    = ?
				  WHERE HEATNO = ?
 
        ]]>
	</query>

	<query id="frmLTemp.select" desc="液相线温度标准查询" fetchSize="10">
        <![CDATA[

			  select   ID_,
				       STEELNAME,
				       LIQUIDUSTEMP,
				       BEYONDTEMPT
				  from SCM_LIQUIDUS_TEMP t where t.steelname=
               		   decode(?, null, steelname, ?)  $ order by ID_ 
               		   
 
        ]]>
	</query>

	<query id="frmSTemp.select" desc="钢水温度范围标准查询" fetchSize="10">
        <![CDATA[

			  select * from temperature_standard t $
        ]]>
	</query>

	<query id="frmSTemp_Del.select" desc="钢水温度范围标准-删除" fetchSize="10">
        <![CDATA[

	   			DELETE temperature_standard WHERE STEELNAME = ? 
 
        ]]>
	</query>

	<query id="frmSTemp_Update.select" desc="钢水温度范围标准-修改" fetchSize="10">
        <![CDATA[

	   		  update temperature_standard
			  set  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 = ?
			 where steelname = ?
 
        ]]>
	</query>

<query id="frmSTemp_Save.select" desc="钢水温度范围标准-增加" fetchSize="10">
        <![CDATA[

	   		  insert into temperature_standard
			  (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)
			values
			  (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
 
        ]]>
	</query>
	
	<query id="frmHLStandard.select" desc="钢种恒拉范围标准查询" fetchSize="10">
        <![CDATA[

			  select * from constant_pull_standard t $
        ]]>
	</query>

	<query id="frmHLStandard_Del.select" desc="钢种恒拉范围标准-删除" fetchSize="10">
        <![CDATA[

	   			DELETE constant_pull_standard WHERE STEELNAME = ? 
 
        ]]>
	</query>

	<query id="frmHLStandard_Update.select" desc="钢种恒拉范围标准-修改" fetchSize="10">
        <![CDATA[

	   		  update constant_pull_standard
			  set  l1_230 = ?,
			       l2_230 = ?,
			       l3_230 = ?,
			       l4_230 = ?,
			       l5_230 = ?,
			       l6_230 = ?,
			       l1_300 = ?,
			       l2_300 = ?,
			       l3_300 = ?,
			       l4_300 = ?,
			       l1_360 = ?,
			       l2_360 = ?,
			       l3_360 = ?,
			       l4_360 = ?,
			       l1_420 = ?,
			       l2_420 = ?,
			       l3_420 = ?,
			       l4_420 = ?
			 where steelname = ?
 
        ]]>
	</query>

<query id="frmHLStandard_Save.select" desc="钢种恒拉范围标准-增加" fetchSize="10">
        <![CDATA[

	   		  insert into constant_pull_standard
			  (steelname,
			   l1_230,
			   l2_230,
			   l3_230,
			   l4_230,
			   l5_230,
			   l6_230,
			   l1_300,
			   l2_300,
			   l3_300,
			   l4_300,
			   l1_360,
			   l2_360,
			   l3_360,
			   l4_360,
			   l1_420,
			   l2_420,
			   l3_420,
			   l4_420)
			values
			  (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
 
        ]]>
	</query>
	
	<query id="LTemp_MaxID.select" desc="获取液相线温度最大ID值" fetchSize="10">
        <![CDATA[
	   		   select max(ID_) from SCM_LIQUIDUS_TEMP t
        ]]>
	</query>
	
	<query id="frmSlabWgtNO.select" desc="坯料重量未匹配数据查询" fetchSize="10">
        <![CDATA[

			  select *
				  from tbg02_slab_comm@XG3Q t
				 where t.SLAB_CUT_DTIME is not null
				   $
        ]]>
	</query>
	
	<query id="frmPotInfo.select" desc="钢包初始化" fetchSize="10">
        <![CDATA[

			  select LADLEID FROM DEV_GB_BASE_INFO $ ORDER BY TO_NUMBER(LADLEID) 
        ]]>
	</query>
	
	<query id="frmSAHit.select" desc="合金窄成分控制标准查询" fetchSize="10">
        <![CDATA[

	   		select * from core_alloyhit_standard t $
 
        ]]>
	</query>
	
	<query id="frmSAHit_Del.select" desc="合金窄成分控制标准-删除" fetchSize="10">
        <![CDATA[

	   	    DELETE core_alloyhit_standard WHERE NUM = ? 
 
        ]]>
	</query>
	
	<query id="frmSAHit_Update.select" desc="合金窄成分控制标准-修改" fetchSize="10">
        <![CDATA[

	   		  update core_alloyhit_standard
			  set  element = ?,
			       actual_steel = ?,
			       lower_limit_e = ?,
			       lower_limit_f = ?,
			       lower_limit_ef = ?,
			       lower_limit_ei = ?,
			       memo = ?,
			       islowlimit = ?
			 where num = ?
 
        ]]>
	</query>

<query id="frmSAHit_Save.select" desc="合金窄成分控制标准-增加" fetchSize="10">
        <![CDATA[

	   		  insert into core_alloyhit_standard
			  (num,
			   element,
			   actual_steel,
			   lower_limit_e,
			   lower_limit_f,
			   lower_limit_ef,
			   lower_limit_ei,
			   memo,
			   islowlimit)
			values
			  (to_char(sysdate,'yyyymmddhh24miss'),?,?,?,?,?,?,?,?)
 
        ]]>
	</query>
	
	<query id="UpLoadData.CAL" desc="合金窄成分控制标准-增加" fetchSize="10">
        <![CDATA[
			UPLOADDATAFOR2LG@XG3Q
        ]]>
	</query>
</queryMap>