XinYu_LZMES/.svn/pristine/03/03bd7c5f69a92653374977ecc064ce927370b219.svn-base

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

<queryMap desc="统计信息录入">


<query id="UIC020111_01.SELECT">
  <![CDATA[
SELECT           PROD_LINE
                ,TJ_DTIME         
                ,TJ_BC
				,TJ_NAME          
				,TJ_RESULT        
				,TJ_DEMO          
				,REG_ID           
				,TO_CHAR(TO_DATE(REG_DTIME ,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')      REG_DTIME 
				,MOD_ID           
				,TO_CHAR(TO_DATE(MOD_DTIME ,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')      MOD_DTIME 
FROM             TBC02_FEICI_LR        T  
WHERE             T.TJ_DTIME            LIKE     ?||'%'
ORDER  BY        t.Dis_Seq          
 ]]>
</query>


<query id="UIC020111_02.SELECT">
  <![CDATA[
  
with d_fc as(
  select t.prod_line, t.tj_name, sum(t.tj_result) rs1,t.dis_seq
    from tbc02_feici_lr t
   where t.tj_dtime like ?
   group by t.tj_name, t.prod_line,t.dis_seq),
  
  m_fc as (select t.prod_line, t.tj_name, sum(t.tj_result) rs2
             from tbc02_feici_lr t
            where t.tj_dtime between substr(?,1,6)||'01' and ?
            group by t.tj_name, t.prod_line),
  
  y_fc as (select t.prod_line, t.tj_name, sum(t.tj_result) rs3
             from tbc02_feici_lr t
            where t.tj_dtime between substr(?,1,4)||'0101' and ?
            group by t.tj_name, t.prod_line)
  
  select d_fc.prod_line,d_fc.tj_name,d_fc.rs1, m_fc.rs2, y_fc.rs3
    from d_fc, m_fc, y_fc
   where d_fc.tj_name = m_fc.tj_name
   and  m_fc.tj_name=y_fc.tj_name
   
   order by d_fc.dis_seq 
 ]]>
</query>

<query id="UIC020111_01.UPDATE">
UPDATE            TBC02_FEICI_LR    T
SET               T.TJ_RESULT       =       ?
                 ,T.TJ_DEMO         =       ?
                 ,T.MOD_ID          =       ?
                 ,T.MOD_DTIME       =       TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
                 ,T.MOD_PGM         =       'UIC020111'
WHERE             T.TJ_DTIME        =       ?
AND               T.TJ_NAME         =       ?    

</query>




<query id="UIC020111_01.CALL">

{call CK_LZ_UIM03.FEICI_INSERT(?,?,?,?)}

</query>

</queryMap>