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

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="工器具-垂直段、弯曲段">
	 
    <query id="FrmVBBaseInfo_Count" desc="垂直段、弯曲段count" fetchSize="10">
        <![CDATA[
        select count(1) from DEV_JJQ_BASE_INFO 
        where CCM_ID = ? and CRYSTALLIZERID = ?
        ]]>
    </query>
    
    <query id="FrmVBBaseInfoBP_Edit.select" desc="垂直段、弯曲段息修改时判断该是否存在" fetchSize="10">
        <![CDATA[
		select nvl(NOWSTATUS,'') NOWSTATUS, OUTERCOPPER, INNERCOPPER, LEFTCOPPER, RIGHTCOPPER, OUTERWATER, INNERWATER 
        from DEV_JJQ_BASE_INFO where CCM_ID = ? and CRYSTALLIZERID = ?
        ]]>
    </query>
    <query id="FrmVBBaseInfoBP" desc="垂直段、弯曲段count" fetchSize="10">
        <![CDATA[
        select count(1) from DEV_VB_BASE_INFO 
        where CCM_ID = ? and CRYSTALLIZERID = ?
        ]]>
    </query>
    <query id="FrmVBBaseInfoBP.ADD" desc="垂直段、弯曲段基本信息增加" fetchSize="10">
        <![CDATA[
		insert into DEV_VB_BASE_INFO 
                (CRYSTALLIZERID, NOWSTATUS, TYPE, CUPRUMCANALTIME, AGE,
                CREATIVEDATE, BUYDATE, MEMO, CCM_ID, ID,
                OUTERCOPPER, INNERCOPPER, LEFTCOPPER, RIGHTCOPPER, OUTERWATER, INNERWATER,
                OUTAGE,INNERAGE,LEFTAGE,RIGHTAGE,OUTTIMES,INNERTIMES,LEFTTIMES,RIGHTTIMES)
                values 
                (?,'3',?,?,?,
                to_date(?,'yyyy-MM-dd'),
                to_date(?,'yyyy-MM-dd'),
                ?,?,
                (select nvl(max(ID),0)+1 from DEV_VB_BASE_INFO),
                ?,?,?,?,?,?,
                ?,?,?,?,
                ?,?,?,?)
        ]]>
    </query>
    
    <query id="FrmVBBaseInfoBP.Edit" desc="垂直段、弯曲段信息修改" fetchSize="10">
        <![CDATA[
		update DEV_VB_BASE_INFO set 
        		TYPE = ? ,
        		CCM_ID=?,
                CUPRUMCANALTIME = ?,
                AGE = ?,
                OUTAGE=?,
                INNERAGE=?,
                LEFTAGE=?,
                RIGHTAGE=?,
                OUTTIMES=?,
                INNERTIMES=?,
                LEFTTIMES=?,
                RIGHTTIMES=?,
                OUTERCOPPER = ?,
                INNERCOPPER = ?, 
                LEFTCOPPER = ?,
                RIGHTCOPPER = ?,
                OUTERWATER = ?,
                INNERWATER = ?,
                CREATIVEDATE = to_date( ?,'yyyy-MM-dd'),
                BUYDATE = to_date( ?,'yyyy-MM-dd'),
                MEMO = ? 
                where CCM_ID = ? and CRYSTALLIZERID = ?
        ]]>
    </query>
    <query id="FrmVBBaseInfoBP_Del_Select" desc="垂直段、弯曲段信息删除时判断该垂直段、弯曲段是否存在" fetchSize="10">
        <![CDATA[
			select count(1) from DEV_VB_BASE_INFO where CCM_ID = ? and CRYSTALLIZERID = ?
        ]]>
    </query>
     <query id="FrmVBBaseInfoBP_Del_Select_1" desc="垂直段、弯曲段信息删除时判断是否存在使用记录" fetchSize="10">
        <![CDATA[
			select count(1) from DEV_VB_use_DETAIL where CRYSTALLIZERID = (select ID from DEV_VB_BASE_INFO where CCM_ID = ? and CRYSTALLIZERID = ?)
        ]]>
    </query>
     <query id="FrmVBBaseInfoBP_Del_Select_2" desc="垂直段、弯曲段信息删除时判断是否存在工器具维修记录" fetchSize="10">
        <![CDATA[
			select count(1) from DEV_TOOL_REPAIR where TOOLTYPEID = '2' and REPAIRTOOLID = (select ID from DEV_JJQ_BASE_INFO where CCM_ID = ? and CRYSTALLIZERID = ?)
        ]]>
    </query>
     <query id="FrmVBBaseInfoBP_Del.Delect" desc="垂直段、弯曲段信息删除" fetchSize="10">
        <![CDATA[
			delete from DEV_VB_BASE_INFO where CCM_ID = ? and CRYSTALLIZERID = ?
		]]>
    </query>
    <query id="VBcbbID.Select" desc="垂直段、弯曲段属性更改时 查询" fetchSize="10">
        <![CDATA[
        select case t.NOWSTATUS
		         when '0' then
		          '下线'
		         when '1' then
		          '上线'
		         when '2' then
		          '维修'
		         when '3' then
		          '备用'
		       end NOWSTATUS,
		       t.AGE AGE,
		       t.TYPE,
		       t.outage,
		       t.innerage,
		       t.leftage,
		       t.rightage,
		       t.outtimes,
		       t.innertimes,
		       t.lefttimes,
		       t.righttimes,
		       t.CUPRUMCANALTIME CUPRUMCANALTIME,
		       case t.NOWSTATUS
		         when '1' then
		          t.CCM_S_ID
		       end CCM_S_ID,
		       to_char(t.CREATIVEDATE, 'yyyy-MM-dd') CREATIVEDATE,
		       to_char(t.BUYDATE, 'yyyy-MM-dd') BUYDATE,
		       t.MEMO MEMO
		  from DEV_VB_BASE_INFO    t
		 where t.CRYSTALLIZERID = ?
		   and t.CCM_ID = ?

        ]]>
    </query> 
    
    <query id="VBUSETIMES.select" desc="使用次数查询" fetchSize="10">
        <![CDATA[
        select nvl(USETIMES,0) USETIMES from DEV_JJQ_PLUGIN_INFO where ID = ?
        ]]>
    </query>
    
    <query id="FrmVBManageBP.Select" desc="垂直段、弯曲段基础信息查询" fetchSize="10">
        <![CDATA[
		select t.CRYSTALLIZERID 段位号,
			       t.ID,
			       case t.NOWSTATUS
			         when '0' then
			          '下线'
			         when '1' then
			          '上线'
			         when '2' then
			          '维修'
			         when '3' then
			          '备用'
			       end 状态,
			       t.CCM_ID 铸机号,
			       case t.NOWSTATUS
			         when '1' then
			          t.CCM_S_ID
			       end 流号,
			       t.AGE 通钢量,
			       t.CUPRUMCANALTIME 使用炉数,
			       case t.TYPE
			         when '1' then
			          '垂直段'
			         when '2' then
			          '弯曲段'
			       end 类型,
			       t.OUTAGE,
			       t.INNERAGE,
			       t.LEFTAGE,
			       t.RIGHTAGE,
			       to_char(t.CREATIVEDATE, 'yyyy-MM-dd') 生产日期,
			       to_char(t.CREATIVEDATE, 'yyyy-MM-dd') 购买日期,
			       t.MEMO 备注
			  from DEV_VB_BASE_INFO   t,
			       DEV_JJQ_PLUGIN_INFO t1,
			       DEV_JJQ_PLUGIN_INFO t2,
			       DEV_JJQ_PLUGIN_INFO t3,
			       DEV_JJQ_PLUGIN_INFO t4,
			       DEV_JJQ_PLUGIN_INFO t5,
			       DEV_JJQ_PLUGIN_INFO t6
			 where t.OUTERCOPPER = t1.ID(+)
			   and t.INNERCOPPER = t2.ID(+)
			   and t.LEFTCOPPER = t3.ID(+)
			   and t.RIGHTCOPPER = t4.ID(+)
			   and t.OUTERWATER = t5.ID(+)
			   and t.INNERWATER = t6.ID(+)
			   and t.CCM_ID = decode(?, null, t.CCM_ID, ?)
			   and t.CRYSTALLIZERID = decode(?, null, t.CRYSTALLIZERID, ?)
			 order by t.CCM_ID,
			          case t.NOWSTATUS
			            when '0' then
			             '下线'
			            when '1' then
			             '上线'
			            when '2' then
			             '维修'
			            when '3' then
			             '备用'
			          end,
			          length(t.CRYSTALLIZERID),
			          t.CRYSTALLIZERID

        ]]>
    </query>
    
     <query id="DEV_VB_USE_DETAIL.Select" desc="垂直段、弯曲段信息修改时判断是否存在使用记录" fetchSize="10">
        <![CDATA[
		select count(1) from DEV_VB_USE_DETAIL where CRYSTALLIZERID = ? and CYCID = ?
        ]]>
    </query>
     <query id="DEV_VB_USE_DETAIL.Select_1" desc="垂直段、弯曲段使用信息删除时判断是否存在使用记录" fetchSize="10">
        <![CDATA[
		select nvl(NOWSTATUS,'0') NOWSTATUS from DEV_VB_USE_DETAIL where CRYSTALLIZERID = ? and CYCID = ?
        ]]>
    </query>
     <query id="FrmVBManageDetail.Edit" desc="垂直段、弯曲段使用信息修改 " fetchSize="10">
        <![CDATA[
		update DEV_VB_USE_DETAIL set 
                CLASS = ?,
                AGE = ?,
                COPPERPLATETIME = ?,
                GRUDE = ?,
                JJQSECTION = ?,
                MOULDNUMBER = ?,
                SURFACEMAN = ?,
                OCTIMES = ?,
                ICTIMES = ?,
                LCTIMES = ?,
                RCTIMES = ?,
                OWTIMES = ?,
                IWTIMES = ?,
                BEGINTIME = to_date(?,'yyyy-MM-dd HH24:mi:ss'),
                ENDTIME = to_date(?,'yyyy-MM-dd HH24:mi:ss')
                
                where CRYSTALLIZERID = ? and CYCID = ?
        ]]>
    </query>
     <query id="FrmVBManageDETAIL.Del" desc="垂直段、弯曲段使用信息删除" fetchSize="10">
        <![CDATA[
		delete from DEV_VB_USE_DETAIL where CRYSTALLIZERID = ? and CYCID = ?
        ]]>
    </query>
     <query id="FrmVBManageBP.Del.Updata" desc="垂直段、弯曲段使用信息删除时修改基本信息" fetchSize="10">
        <![CDATA[
		update DEV_VB_BASE_INFO set NOWSTATUS = '0', CCM_S_ID = null where ID = ?
        ]]>
    </query>
    <query id="VBCRYSTALLIZERID.select" desc="段位编号查询" fetchSize="10">
        <![CDATA[
        select CRYSTALLIZERID from DEV_VB_BASE_INFO where CCM_ID = ?
        order by length(CRYSTALLIZERID), CRYSTALLIZERID
        ]]>
   </query>
   
    <query id="FrmVBManageBP_GetUseInfo.Select" desc="段位使用信息查询" fetchSize="10">
        <![CDATA[
		select t2.CRYSTALLIZERID 段位号,
             t1.CYCID 周期编号,  t1.NOWPOSITION 铸机号,t1.CCM_S_ID 流号,t1.CRYSTALLIZERID ID,
             case t1.NOWSTATUS when '0' then '下线' when '1' then '上线' when '2' then '维修' when '3' then '备用'end 状态,
             t1.COPPERPLATEFACTORY 铜板厂家,
             case substr(t1.CLASS, 1, 1)
               when '1' then '白'  when '2' then '中' when '3' then '夜' end || case substr(t1.CLASS, 2, 1)
               when '1' then '甲' when '2' then '乙' when '3' then '丙' when '4' then '丁' end 班别,
             t1.MOULDNUMBER 连浇炉数,t1.JJQSECTION 断面,t1.COPPERPLATETIME 使用炉数,
             case t1.TYPE when '1' then '垂直段' when '2' then '弯曲段' end 类型,
             t2.AGE 通钢量,'' 外弧铜板,
             '' 内弧铜板,'' 左侧铜板,'' 右侧铜板,
             t2.OUTTIMES VL1,
             t2.INNERTIMES VL2,
             t2.LEFTTIMES VL3,
             t2.RIGHTTIMES VL4,
             to_char(t1.BEGINTIME, 'yyyy-MM-dd HH24:mi:ss') 换上时间,
             to_char(t1.ENDTIME, 'yyyy-MM-dd HH24:mi:ss') 换下时间,
             t1.SURFACEMAN 维护人员,
             t2.OUTAGE ,
             t2.INNERAGE ,
             t2.LEFTAGE ,
             t2.RIGHTAGE ,
             t1.MEMO 备注
			
			 from DEV_VB_USE_DETAIL  t1,DEV_VB_BASE_INFO   t2
			
			 where t1.CRYSTALLIZERID = t2.ID(+)
				  	$
        ]]>
    </query>
    
    <query id="FrmVBCryByCcmsId.Query" desc="根据流号获取编号和周期编号" fetchSize="10">
        <![CDATA[
		     (select y.CRYSTALLIZERID,CYCID
                    from (select a.*, row_number() over(order by a.begintime desc) xh
                            from dev_VB_use_detail a
                           where a.ccm_s_id = ?) y
					         where y.xh = 1)
        ]]>
    </query>
    
    <query id="FrmVB_User_Detail.Edit" desc="修改段位使用铜板信息（使用炉数、过钢量）" fetchSize="10">
        <![CDATA[
		   
				Update dev_VB_use_detail c
				   set c.octimes  = ?,
				       c.ictimes  = ?,
				       c.lctimes  = ?,
				       c.rctimes  = ?,
				       c.outage   = ?,
				       c.innerage = ?,
				       c.leftage  = ?,
				       c.rightage = ?,
				       c.TYPE     =?
				 where c.crystallizerid = ?
				   and c.cycid = ?

        ]]>
    </query>
</queryMap>