| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH010010_01.init" desc="标准号" fetchSize="10">
- <![CDATA[
- SELECT SM_CD LABEL,SM_CD VALUE FROM TBZ00_COMMCD WHERE lg_cd = 'B01001'
- ]]>
- </query>
- <query id="UIH010010_02.select" desc="" fetchSize="10">
- <![CDATA[
- select a.prdnm_cd,a.spec_abbsym,a.stl_grd,a.thk_tgt
- from tbh01_oprn_std a
- where a.prdnm_cd = ?
- and a.spec_abbsym = ?
- and a.stl_grd = ?
- ----------------MODIFY BY WXY 2011.02.22操作标准增加冬夏季节区分
- AND A.SEASON = ?
- ----------------MODIFY BY WXY 2011.02.22操作标准增加冬夏季节区分
- ]]>
- </query>
- <query id="UIH010010_03.select" desc="" fetchSize="10">
- <![CDATA[
- SELECT distinct spec_stl_grd LABEL
- ,spec_stl_grd VALUE
- FROM tbb01_key_prod
- ]]>
- </query>
- <query id="UIH010010_01.select" desc="init " fetchSize="10">
- <![CDATA[
- SELECT THK_TGT ,EXTRACT_TGT_TEMP,
- EXTRACT_MAX_TEMP,
- EXTRACT_MIN_TEMP,
- CHARGING_TGT_TEMP,
- CHARGING_MAX_TEMP,
- INFUR_MIN_HOUR,
- INFUR_MAX_HOUR,
- EQ_HT_MIN_HOUR,
- EQ_HT_MAX_HOUR,
-
- FERR_MODE,
- FERR_CON_STA_TGT_TEMP,
- FERR_CON_END_TGT_TEMP,
- RM2_EXIT_TGT_TEMP,
- RM2_EXIT_MIN_TEMP,
- RM2_EXIT_MAX_TEMP,
- STRIP_TGT_TEMP1,
- STRIP_TGT_TEMP2,
- STRIP_TGT_TEMP3,
- STRIP_TGT_TEMP4,
- STRIP_MIN_TEMP,
- STRIP_MAX_TEMP,
- FM_ENT_TGT_CROWN_40,
- FM_ENT_TGT_CROWN_401,
- FM_ENT_TGT_CROWN_402,
- FM_ENT_TGT_CROWN_403,
- FM_ENT_MAX_CROWN_40,
- FM_ENT_MIN_CROWN_40,
- SYM_FLATNESS_DEV,
- ASY_FLATNESS_DEV,
-
-
- STRIP_WED_MIN,
- STRIP_WED_MAX,
- DUAL_PHASE_CLF,
- DUAL_PHASE_TEMP,
- DUAL_PHASE_TIME,
- NON_COOL_LEN_HEAD,
- NON_COOL_LEN_TAIL,
- NON_COOL_LEN_NOR,
- COOL_TOP_RATE,
- COOL_BOT_RATE,
- COILING_TGT_TEMP1,
- COILING_TGT_TEMP2,
- COILING_TGT_TEMP3,
- COILING_TGT_TEMP4,
- COILING_MAX_TEMP,
- COILING_MIN_TEMP,
- BINDING_WGT_CIR,
- BINDING_WGT_RAD ,
- RT2_EXIT_TGT_TEMP,
- RT2_EXIT_MIN_TEMP,
- RT2_EXIT_MAX_TEMP
-
- FROM TBH01_OPRN_STD
- WHERE PRDNM_CD = ?
- AND SPEC_ABBSYM = ?
- --AND DECODE(THK_TGT,NULL,' ',THK_TGT) like ?||'%'
- AND STL_GRD = ?
- AND SEASON = ?
- ]]>
- </query>
- <query id="UIH010010_04.select" desc="" fetchSize="10">
- <![CDATA[
- select a.thk_tgt||':'||'下限'||a.thk_min||'为'||decode(a.thk_min_label,'A','小于','B','小于等于','C','大于','D','大于等于',' ')||','||'上限'||a.thk_max||'为'
- ||decode(a.thk_max_label,'A','小于','B','小于等于','C','大于','D','大于等于',' ') LABEL,
- a.thk_tgt VALUE from tbh01_thk_std a where a.stl_grd = ?
- ]]>
- </query>
- <query id="UIH010010_01.update" desc="init " fetchSize="10">
- <![CDATA[
- update tbh01_oprn_std set
- EXTRACT_TGT_TEMP = ?
- ,EXTRACT_MAX_TEMP = ?
- ,EXTRACT_MIN_TEMP = ?
- ,CHARGING_TGT_TEMP = ?
- ,CHARGING_MAX_TEMP = ?
- ,INFUR_MIN_HOUR = ?
- ,INFUR_MAX_HOUR = ?
- ,EQ_HT_MIN_HOUR = ?
- ,EQ_HT_MAX_HOUR = ?
- ,FERR_MODE = ?
- ,FERR_CON_STA_TGT_TEMP = ?
- ,FERR_CON_END_TGT_TEMP = ?
- ,RM2_EXIT_TGT_TEMP = ?
- ,RM2_EXIT_MIN_TEMP = ?
- ,RM2_EXIT_MAX_TEMP = ?
- ,STRIP_TGT_TEMP1 = ?
- ,STRIP_TGT_TEMP2 = ?
- ,STRIP_TGT_TEMP3 = ?
- ,STRIP_TGT_TEMP4 = ?
- ,STRIP_MIN_TEMP = ?
- ,STRIP_MAX_TEMP = ?
- ,FM_ENT_TGT_CROWN_40 = ?
- ,FM_ENT_MIN_CROWN_40 = ?
- ,FM_ENT_MAX_CROWN_40 = ?
- ,SYM_FLATNESS_DEV = ?
- ,ASY_FLATNESS_DEV = ?
- ,STRIP_WED_MIN = ?
- ,STRIP_WED_MAX = ?
- ,DUAL_PHASE_CLF = ?
- ,DUAL_PHASE_TEMP = ?
- ,DUAL_PHASE_TIME = ?
- ,NON_COOL_LEN_HEAD = ?
- ,NON_COOL_LEN_TAIL = ?
- ,NON_COOL_LEN_NOR = ?
- ,COOL_TOP_RATE = ?
- ,COOL_BOT_RATE = ?
- ,COILING_TGT_TEMP1 = ?
- ,COILING_TGT_TEMP2 = ?
- ,COILING_TGT_TEMP3 = ?
- ,COILING_TGT_TEMP4 = ?
- ,COILING_MAX_TEMP = ?
- ,COILING_MIN_TEMP = ?
- ,BINDING_WGT_CIR = ?
- ,BINDING_WGT_RAD = ?
- , RT2_EXIT_TGT_TEMP = ?
- , RT2_EXIT_MIN_TEMP = ?
- , RT2_EXIT_MAX_TEMP = ?
-
- ,THK_TGT = ?
- ,MOD_ID = ?
- ,MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,FM_ENT_TGT_CROWN_401 = ?
- ,FM_ENT_TGT_CROWN_402 = ?
- ,FM_ENT_TGT_CROWN_403 = ?
- where PRDNM_CD = ?
- and SPEC_ABBSYM = ?
- and STL_GRD = ?
- ----------------MODIFY BY WXY 2011.02.22操作标准增加冬夏季节区分
- AND SEASON = ?
- ----------------MODIFY BY WXY 2011.02.22操作标准增加冬夏季节区分
- ]]>
- </query>
- <query id="UIH010010_01.insert" desc="init " fetchSize="10">
- <![CDATA[
- insert into tbh01_oprn_std (
- EXTRACT_TGT_TEMP
- ,EXTRACT_MAX_TEMP
- ,EXTRACT_MIN_TEMP
- ,CHARGING_TGT_TEMP
- ,CHARGING_MAX_TEMP
- ,INFUR_MIN_HOUR
- ,INFUR_MAX_HOUR
- ,EQ_HT_MIN_HOUR
- ,EQ_HT_MAX_HOUR
- ,FERR_MODE
- ,FERR_CON_STA_TGT_TEMP
- ,FERR_CON_END_TGT_TEMP
- ,RM2_EXIT_TGT_TEMP
- ,RM2_EXIT_MIN_TEMP
- ,RM2_EXIT_MAX_TEMP
- ,STRIP_TGT_TEMP1
- ,STRIP_TGT_TEMP2
- ,STRIP_TGT_TEMP3
- ,STRIP_TGT_TEMP4
- ,STRIP_MIN_TEMP
- ,STRIP_MAX_TEMP
- ,FM_ENT_TGT_CROWN_40
- ,FM_ENT_MIN_CROWN_40
- ,FM_ENT_MAX_CROWN_40
- ,SYM_FLATNESS_DEV
- ,ASY_FLATNESS_DEV
- ,STRIP_WED_MIN
- ,STRIP_WED_MAX
- ,DUAL_PHASE_CLF
- ,DUAL_PHASE_TEMP
- ,DUAL_PHASE_TIME
- ,NON_COOL_LEN_HEAD
- ,NON_COOL_LEN_TAIL
- ,NON_COOL_LEN_NOR
- ,COOL_TOP_RATE
- ,COOL_BOT_RATE
- ,COILING_TGT_TEMP1
- ,COILING_TGT_TEMP2
- ,COILING_TGT_TEMP3
- ,COILING_TGT_TEMP4
- ,COILING_MAX_TEMP
- ,COILING_MIN_TEMP
- ,BINDING_WGT_CIR
- ,BINDING_WGT_RAD
- , RT2_EXIT_TGT_TEMP
- , RT2_EXIT_MIN_TEMP
- , RT2_EXIT_MAX_TEMP
- ,THK_TGT
- ,PRDNM_CD
- ,SPEC_ABBSYM
- ,STL_GRD
- ,REG_ID
- ,REG_DTIME
- ,SEASON
- ,FM_ENT_TGT_CROWN_401
- ,FM_ENT_TGT_CROWN_402
- ,FM_ENT_TGT_CROWN_403
- )
- values(
- ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,?,?,?)
- ]]>
- </query>
- <query id="UIH010010_MILL_STD.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT REG_DTIME,
- PRDNM_CD PRODNM_CD,
- STL_GRD,
- SPEC_ABBSYM,
- EXTRACT_TGT_TEMP,
- EXTRACT_MAX_TEMP,
- EXTRACT_MIN_TEMP,
- CHARGING_TGT_TEMP,
- CHARGING_MAX_TEMP,
- STRIP_TGT_TEMP1,
- STRIP_TGT_TEMP2,
- STRIP_TGT_TEMP3,
- STRIP_TGT_TEMP4,
- STRIP_MIN_TEMP,
- STRIP_MAX_TEMP,
- COILING_TGT_TEMP1,
- COILING_TGT_TEMP2,
- COILING_TGT_TEMP3,
- COILING_TGT_TEMP4,
- COILING_MAX_TEMP,
- COILING_MIN_TEMP,
- RT2_EXIT_TGT_TEMP,
- RT2_EXIT_MIN_TEMP,
- RT2_EXIT_MAX_TEMP,
- SEASON,
- THK_TGT
- FROM TBH01_OPRN_STD
- WHERE STL_GRD like ?||'%'
- order by STL_GRD
- ]]>
- </query>
- <query id="UIH010010.delete" desc=" " fetchSize="10">
- <![CDATA[
- delete tbh01_oprn_std where PRDNM_CD = ? AND SPEC_ABBSYM = ? AND STL_GRD = ?
- ]]>
- </query>
- </queryMap>
|
