1、輸入編號(hào)(ID)按enter鍵顯示名稱方法使用說(shuō)明文檔在日常企業(yè)應(yīng)用系統(tǒng)中，很多地方用到輸入編號(hào)(ID)按enter鍵顯示對(duì)應(yīng)的名稱的情況：如下圖所示：現(xiàn)開(kāi)發(fā)出通用方法：cmmCodeIDReturnNm 統(tǒng)一調(diào)用/* enter 顯示name */window.cmmCodeInputEventBind(SELECTOR:prdId,TARGET:prdNm,SEARCH:PRD,USE_YN:1,TP1:2,TP2:,TP3:,TP4:,TP5:);- SELECTOR、TARGET、SEARCH 為必傳屬性- SELECTOR - id值 CMM_EMTDR_CONFIG_M.SOURC

2、E_NM- TARGET - name的id值 CMM_EMTDR_CONFIG_M.SOURCE_ID- SEARCH - 標(biāo)識(shí) CMM_EMTDR_CONFIG_M.SOURCE_TYPE- USE_YN、TP1、TP2、TP3、TP4、TP5 可選屬性- USE_YN - 條件值 CMM_EMTDR_CONFIG_M. SOURCE_USE_YN- TP1 - 條件值 CMM_EMTDR_CONFIG_M.SOURCE_TEMP_1- TP2 - 條件值 CMM_EMTDR_CONFIG_M.SOURCE_TEMP_2- TP3 -條件值 CMM_EMTDR_CONFIG_M.SOURC

3、E_TEMP_3- TP4 -條件值 CMM_EMTDR_CONFIG_M.SOURCE_TEMP_4- TP5 - 條件值 CMM_EMTDR_CONFIG_M.SOURCE_TEMP_5實(shí)例：window.cmmCodeIDReturnNm(SELECTOR:prdId,TARGET:prdNm,SEARCH:PRD,)window.cmmCodeIDReturnNm(SELECTOR:mdId,TARGET:mdNm,SEARCH:MD)window.cmmCodeIDReturnNm(SELECTOR:dlrId,TARGET:dlrNm,SEARCH:DLR )window.cmmC

4、odeIDReturnNm(SELECTOR:dlrId,TARGET:dlrNm,SEARCH:DLR,TP3:10)window.cmmCodeIDReturnNm(SELECTOR:dlrId,TARGET:dlrNm,SEARCH:DLR, TP3:20)配置表實(shí)例數(shù)據(jù):查詢SQL:傳參：SELECT /* emtdr-find-prdins.xml | selectEmtdrFindPrdIns | wuliwei */FUN_GET_SOURCENM( #SEARCH, #CODE_ID, #USE_YN, #TP1, #TP2, #TP3, #TP4, #TP5)FROM DUA

5、L附件1:JS通用方法;(function (w) /*按下enter鍵 顯示 name *start*/ w.cmmCodeIDReturnNm = function(prams) var $source = $(# + prams.SELECTOR); var $target = $(# + prams.TARGET); $source.bind(keydown, function(event) $source.data(code, $source.val(); ); $source.bind(keypress, function(event) if (event.keyCode = 13

6、) /*阻止默認(rèn)行為*/ event.preventDefault(); ); $source.bind(keyup cut, function(event) if (event.type = cut) /*向 input 元素附加數(shù)據(jù)*/ $source.data(code, ); if ($source.val() != & event.keyCode = 13) $source.val( $source.val().trim() ); prams.CODE_ID = $source.val() cmmCodeKeyPress(event, prams); else /*獲取input附加

7、的數(shù)據(jù)，對(duì)比是否相同，不同時(shí)，刪除name值*/ if ($source.data(code) != $source.val() $target.val();$source.data(code, ); ); $target.bind(mouseenter, function(event)if ( $target.val() = ) $target.removeAttr(title); else $target.attr(title, $target.val(); ); function cmmCodeKeyPress(event, prams)if (event.keyCode = 13) v

8、ar inputNm = $(# + prams.TARGET) var path = /popup/prd/emtdrFindPrdIns $.ajax( url : path ,type : post ,async : false ,data : prams ,dataType : json ,success : function(response) if(response.CODE_NM) inputNm.val(response.CODE_NM); ,exception : function(response) ); else return false /*按下enter鍵 顯示 na

9、me *end*/ /*彈窗*/ w.popupOpen = function (url,title, options) return layerType(url,title, options) function layerType(url,title, options) var width = var height = if(!options | (options & !options.width & !options.height) width = 700px height = 555px else if(options & options.width & options.height)

10、width = options.width height = options.height /是否使用加密 if(options & options.isEncrypt) /var esParams = escape().replace(/+/g, %2B).replace(/g,%22).replace(/g, %27).replace(/g,%2F); url += ?paramsJson= + encodeURIComponent(encodeURIComponent(encryptAes128(JSON.stringify(options.params); if(options & o

11、ptions.params) layer.open( title: title, type: 2, offset: 10px, shade: 0.1, #fff, area: width, height, content: url, success: function(layero, index) var iframeWindow = windowlayero.find(iframe)0name; /*子頁(yè)面的函數(shù)*/ if(options & options.params & options.ifmFnName) iframeWindowoptions.ifmFnName(options.p

12、arams) ) else layer.open( title: title, offset: 10px, shade: 0.1, #fff, type: 2, area: width, height, content: url ) )(window)附件2: FUN_GET_SOURCENM 函數(shù)Eg: SELECT FUN_GET_SOURCENM(PRD,547849,Y,null,null,null,null,null) FROM DUAL;CREATE OR REPLACE FUNCTION FUN_GET_SOURCENM(SOURCETYPE VARCHAR2, SOURCEID

13、 VARCHAR2, SOURCEUSEYN VARCHAR2, SOURCETP1 VARCHAR2, SOURCETP2 VARCHAR2, SOURCETP3 VARCHAR2, SOURCETP4 VARCHAR2, SOURCETP5 VARCHAR2) RETURN VARCHAR2 IS LV_NAME VARCHAR2(200) := ; T_SQL VARCHAR2(6000); LV_SOURCETP1 VARCHAR2(40); LV_SOURCETP2 VARCHAR2(40); LV_SOURCETP3 VARCHAR2(40); LV_SOURCETP4 VARCH

14、AR2(40); LV_SOURCETP5 VARCHAR2(40); LV_SOURCEUSEYN VARCHAR2(10);BEGIN -拼接sql SELECT select | T.SOURCE_NM | from | T.SOURCE_TABLE_NM | WHERE | T.SOURCE_ID | = | SOURCEID | , T.SOURCE_TEMP_1, T.SOURCE_TEMP_2, T.SOURCE_TEMP_3, T.SOURCE_TEMP_4, T.SOURCE_TEMP_5, T.SOURCE_USE_YN INTO T_SQL, LV_SOURCETP1,

15、LV_SOURCETP2, LV_SOURCETP3, LV_SOURCETP4, LV_SOURCETP5, LV_SOURCEUSEYN FROM CMM_EMTDR_CONFIG_M T WHERE T.SOURCE_TYPE = SOURCETYPE; -where條件拼接 IF SOURCEUSEYN IS NOT NULL AND LV_SOURCEUSEYN IS NOT NULL THEN T_SQL := T_SQL | and | LV_SOURCEUSEYN | = | SOURCEUSEYN | ; END IF; IF SOURCETP1 IS NOT NULL AN

16、D LV_SOURCETP1 IS NOT NULL THEN T_SQL := T_SQL | and | LV_SOURCETP1 | = | SOURCETP1 | ; END IF; IF SOURCETP2 IS NOT NULL AND LV_SOURCETP2 IS NOT NULL THEN T_SQL := T_SQL | and | LV_SOURCETP2 | = | SOURCETP2 | ; END IF; IF SOURCETP3 IS NOT NULL AND LV_SOURCETP3 IS NOT NULL THEN T_SQL := T_SQL | and |

17、 LV_SOURCETP3 | = | SOURCETP3 | ; END IF; IF SOURCETP4 IS NOT NULL AND LV_SOURCETP4 IS NOT NULL THEN T_SQL := T_SQL | and | LV_SOURCETP4 | = | SOURCETP4 | ; END IF; IF SOURCETP5 IS NOT NULL AND LV_SOURCETP5 IS NOT NULL THEN T_SQL := T_SQL | and | LV_SOURCETP5 | = | SOURCETP5 | ; END IF; -執(zhí)行sql EXECU

18、TE IMMEDIATE T_SQL INTO LV_NAME; RETURN LV_NAME; -RETURN T_SQL;END;附件3: 配置表結(jié)構(gòu)- Create tablecreate table CMM_EMTDR_CONFIG_M( SOURCE_TYPE VARCHAR2(40) not null, SOURCE_ID VARCHAR2(40) not null, SOURCE_NM VARCHAR2(40) not null, SOURCE_TABLE_NM VARCHAR2(40) not null, SOURCE_TEMP_1 VARCHAR2(40), SOURCE_T

19、EMP_2 VARCHAR2(40), SOURCE_TEMP_3 VARCHAR2(40), SOURCE_TEMP_4 VARCHAR2(40), SOURCE_TEMP_5 VARCHAR2(40), SOURCE_USE_YN VARCHAR2(40), INST_ID VARCHAR2(40) not null, INST_DTM DATE default SYSDATE not null, MDF_ID VARCHAR2(40) not null, MDF_DTM DATE default SYSDATE not null)tablespace TS_BSC pctfree 10

20、initrans 1 maxtrans 255 storage ( initial 16 next 8 minextents 1 maxextents unlimited );- Add comments to the table comment on table CMM_EMTDR_CONFIG_M is 回車鍵顯示信息配置表;- Add comments to the columns comment on column CMM_EMTDR_CONFIG_M.SOURCE_TYPE is 標(biāo)識(shí);comment on column CMM_EMTDR_CONFIG_M.SOURCE_ID is 鍵入ID;comment on column CMM_EMTDR_CONFIG_M.SOURCE_NM is 返回名稱;comment on column CMM_EMTDR_CONFIG_M.SOURCE_TABLE_NM is 相關(guān)表名;comment on column CMM_EMTDR_CONFIG_M.SOURCE_TEMP_1 is 拓展字段1;comment on column CMM_EMTDR_CONFIG_M.SOURCE_TEMP_2 is 拓展字段2;comment on column CMM_EMTDR_CONFIG_M.SOURCE_