| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="生产规范代码基本信息维护">
- <query id="UIB010321_01.INITSELECT" desc="代码类型查询" >
- SELECT DISTINCT T.SPEC_STL_GRD SM_CFNM, T.SPEC_STL_GRD SM_CD
- FROM TBB01_SPEC_INGR T
- </query>
- <query id="UIB010321_01.SELECT" desc="查询生产规范代码">
- SELECT 'False' CHK
- ,T.STL_GRD
- , T.DAT_TYPE
- , T.DAT_TYPE EDIT_TYPE
- , T.ROOM1
- , T.ROOM2
- , T.ROOM3
- , T.ROOM4
- , T.ROOM5
- , T.ROOM6
- , T.ROOM7
- , T.ROOM8
- , T.ROOM9
- , T.ROOM10
- , T.ROOM11
- , T.ROOM12
- , T.ROOM13
- , T.ROOM14
- , T.ROOM15
- , T.ROOM16
- , T.ROOM17
- , T.ROOM18
- FROM C_TBF02_LTYS T
- WHERE T.DAT_TYPE =?
- </query>
-
- <query id="UIB010321_01.UPDATE" desc="更新">
- UPDATE c_tbf02_ltys
- SET PROD_CD = ? --更新后规范编码
- , DISPLAY_SEQ = ? --显示顺序
- , PROD_TYPE = ? --代码类型
- , PROD_CD_CFNM = ? --中文名称
- , DCS_SYM = ? --判定符号
- , MOD_ID = ? --修改人
- , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') --修改日期
- WHERE STL_GRD = ? --更新前规范编码
- </query>
- <query id="UIB010321_01.INSERT" desc="插入">
- INSERT INTO c_tbf02_ltys
- (STL_GRD,
- DAT_TYPE,
- ROOM1,
- ROOM2,
- ROOM3,
- ROOM4,
- ROOM5,
- ROOM6,
- ROOM7,
- ROOM8,
- ROOM9,
- ROOM10,
- ROOM11,
- ROOM12,
- ROOM13,
- ROOM14,
- ROOM15,
- ROOM16,
- ROOM17,
- ROOM18)
- VALUES
- (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
- </query>
- <query id="UIB010321_01.DELETE" desc="删除某规范编码">
- DELETE FROM TBB01_SEQ_PROD WHERE PROD_CD = ?
- </query>
- </queryMap>
|
