输入编号(ID)按enter键显示名称方法使用说明文档在日常企业应用系统中，很多地方用到输入编号(ID)按enter键显示对应的名称的情况：
如下图所示：现开发出通用方法：cmmCodeIDReturnNm统一调用/enter显示name/window.cm
mCodeInputEventBind({SELECTOR:''prdId'',TARGET:''prdNm'',SEARCH:''PRD''
,USE_YN:"1",TP1:"2",TP2:"",TP3:"",TP4:"",TP5:""});--SELECTOR、TA
RGET、SEARCH为必传属性-SELECTOR->id值CMM_EMTDR_CONFIG_M.SOURCE_NM-
TARGET->name的id值CMM_EMTDR_CONFIG_M.SOURCE_ID-SEARCH->标
识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.SOURCE_TEMP_3-TP4-
>条件值CMM_EMTDR_CONFIG_M.SOURCE_TEMP_4-TP5->条件值CMM_EMTDR_CONFI
G_M.SOURCE_TEMP_5实例：window.cmmCodeIDReturnNm({SELECTOR:''prdId'',TA
RGET:''prdNm'',SEARCH:''PRD'',})window.cmmCodeIDReturnNm({SELECTOR:''m
dId'',TARGET:''mdNm'',SEARCH:''MD''})window.cmmCodeIDReturnNm({SELECTO
R:''dlrId'',TARGET:''dlrNm'',SEARCH:''DLR''})window.cmmCodeIDReturnNm(
{SELECTOR:''dlrId'',TARGET:''dlrNm'',SEARCH:''DLR'',TP3:’10’})window.cm
mCodeIDReturnNm({SELECTOR:''dlrId'',TARGET:''dlrNm'',SEARCH:''DLR'',TP
3:’20’})配置表实例数据:查询SQL:传参：SELECT/emtdr-find-prdins.xml|select
EmtdrFindPrdIns|wuliwei/FUN_GET_SOURCENM(#{SEARCH},#{CODE_I
D},#{USE_YN},#{TP1},#{TP2},#{TP3},#{TP4},#{TP5})FROMDUAL附件
1:JS通用方法;(function(w){/按下enter键显示name
start/w.cmmCodeIDReturnNm=function(prams){var$so
urce=$(''#''+prams.SELECTOR);var$target=$(''#''+prams.TARGE
T);$source.bind("keydown",function(event){$source.data("code"
,$source.val());});$source.bind("keypress",function(event){
if(event.keyCode==13){/阻止默认行为/event.preventDefault();}}
);$source.bind("keyupcut",function(event){if(event.type=="
cut"){/向input元素附加数据/$source.data("code","");}if($sourc
e.val()!=""&&event.keyCode==13){$source.val($source.val(
).trim());prams.CODE_ID=$source.val()cmmCodeKeyPress(event,
prams);}else{/获取input附加的数据，对比是否相同，不同时，删除name值/if($source.
data("code")!=$source.val()){$target.val("");$source.data("co
de","");}}});$target.bind("mouseenter",function(event){if(
$target.val()==""){$target.removeAttr("title");}else{$targe
t.attr("title",$target.val());}});}functioncmmCodeKeyPress(
event,prams){if(event.keyCode==13){varinputNm=$(''#''+pr
ams.TARGET)varpath=''/popup/prd/emtdrFindPrdIns''$.ajax({url
:path,type:"post",async:false,data:prams,dataType:"
json",success:function(response){if(response.CODE_NM){input
Nm.val(response.CODE_NM);}},exception:function(response){}
});}else{returnfalse}}/按下enter键显示name
end//弹窗/w.popupOpen=function(url,title,opt
ions){returnlayerType(url,title,options)}functionlayerType
(url,title,options){varwidth=''''varheight=''''if(!options
||(options&&!options.width&&!options.height)){width=''700
px''height=''555px''}elseif(options&&options.width&&option
s.height){width=options.widthheight=options.height}//是否使用
加密if(options&&options.isEncrypt){//varesParams=escape().re
place(/\+/g,''%2B'').replace(/\"/g,''%22'').replace(/\''/g,''%27'').re
place(/\//g,''%2F'');url+="?paramsJson="+encodeURIComponent(en
codeURIComponent(encryptAes128(JSON.stringify(options.params))));
}if(options&&options.params){layer.open({title:title,type
:2,offset:''10px'',shade:[0.1,''#fff''],area:[width,height],
content:url,success:function(layero,index){variframeWindow
=window[layero.find(''iframe'')[0][''name'']];/子页面的函数/if(option
s&&options.params&&options.ifmFnName){iframeWindow[options.i
fmFnName](options.params)}}})}else{layer.open({title:title
,offset:''10px'',shade:[0.1,''#fff''],type:2,area:[width,he
ight],content:url})}}})(window)附件2:FUN_GET_SOURCENM函数Eg:S
ELECTFUN_GET_SOURCENM(''PRD'',''547849'',''Y'',null,null,null,null,nul
l)FROMDUAL;CREATEORREPLACEFUNCTIONFUN_GET_SOURCENM(SOURCETY
PEVARCHAR2,SOURCEIDVARCHAR2,SOURCEUSEYNVARCHAR2,SOURCETP1VA
RCHAR2,SOURCETP2VARCHAR2,SOURCETP3VARCHAR2,SOURCETP4VARCHAR2,
SOURCETP5VARCHAR2)RETURNVARCHAR2ISLV_NAMEVARCHAR2(200):='''';
T_SQLVARCHAR2(6000);LV_SOURCETP1VARCHAR2(40);LV_SOURCETP2VARCH
AR2(40);LV_SOURCETP3VARCHAR2(40);LV_SOURCETP4VARCHAR2(40);LV_S
OURCETP5VARCHAR2(40);LV_SOURCEUSEYNVARCHAR2(10);BEGIN--拼接sqlS
ELECT''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.SOU
RCE_TEMP_5,T.SOURCE_USE_YNINTOT_SQL,LV_SOURCETP1,LV_SOURCETP
2,LV_SOURCETP3,LV_SOURCETP4,LV_SOURCETP5,LV_SOURCEUSEYNFROM
CMM_EMTDR_CONFIG_MTWHERET.SOURCE_TYPE=SOURCETYPE;--where条件拼
接IFSOURCEUSEYNISNOTNULLANDLV_SOURCEUSEYNISNOTNULLTHEN
T_SQL:=T_SQL||''and''||LV_SOURCEUSEYN||''=''''''||SOURCEUS
EYN||'''''''';ENDIF;IFSOURCETP1ISNOTNULLANDLV_SOURCETP1IS
NOTNULLTHENT_SQL:=T_SQL||''and''||LV_SOURCETP1||''=''''
''||SOURCETP1||'''''''';ENDIF;IFSOURCETP2ISNOTNULLANDLV_S
OURCETP2ISNOTNULLTHENT_SQL:=T_SQL||''and''||LV_SOURCET
P2||''=''''''||SOURCETP2||'''''''';ENDIF;IFSOURCETP3ISNOTNU
LLANDLV_SOURCETP3ISNOTNULLTHENT_SQL:=T_SQL||''and''||
LV_SOURCETP3||''=''''''||SOURCETP3||'''''''';ENDIF;IFSOURCETP
4ISNOTNULLANDLV_SOURCETP4ISNOTNULLTHENT_SQL:=T_SQL||
''and''||LV_SOURCETP4||''=''''''||SOURCETP4||'''''''';ENDIF;
IFSOURCETP5ISNOTNULLANDLV_SOURCETP5ISNOTNULLTHENT_SQL
:=T_SQL||''and''||LV_SOURCETP5||''=''''''||SOURCETP5||''''''
'';ENDIF;--执行sqlEXECUTEIMMEDIATET_SQLINTOLV_NAME;RETURNL
V_NAME;--RETURNT_SQL;END;附件3:配置表结构--Createtablecreatetable
CMM_EMTDR_CONFIG_M(SOURCE_TYPEVARCHAR2(40)notnull,SOURCE_IDVA
RCHAR2(40)notnull,SOURCE_NMVARCHAR2(40)notnull,SOURCE_TABLE
_NMVARCHAR2(40)notnull,SOURCE_TEMP_1VARCHAR2(40),SOURCE_TEMP
_2VARCHAR2(40),SOURCE_TEMP_3VARCHAR2(40),SOURCE_TEMP_4VARCHAR2(
40),SOURCE_TEMP_5VARCHAR2(40),SOURCE_USE_YNVARCHAR2(40),INST_I
DVARCHAR2(40)notnull,INST_DTMDATEdefaultSYSDATEnotnull,MD
F_IDVARCHAR2(40)notnull,MDF_DTMDATEdefaultSYSDATEnotnull)t
ablespaceTS_BSCpctfree10initrans1maxtrans255storage(ini
tial16next8minextents1maxextentsunlimited);--Addcomment
stothetablecommentontableCMM_EMTDR_CONFIG_Mis''回车键显示信息配置表
'';--AddcommentstothecolumnscommentoncolumnCMM_EMTDR_CONF
IG_M.SOURCE_TYPEis''标识'';commentoncolumnCMM_EMTDR_CONFIG_M.SOU
RCE_IDis''键入ID'';commentoncolumnCMM_EMTDR_CONFIG_M.SOURCE_NMi
s''返回名称'';commentoncolumnCMM_EMTDR_CONFIG_M.SOURCE_TABLE_NMis
''相关表名'';commentoncolumnCMM_EMTDR_CONFIG_M.SOURCE_TEMP_1is''拓展字
段1'';commentoncolumnCMM_EMTDR_CONFIG_M.SOURCE_TEMP_2is''拓展字段2''
;commentoncolumnCMM_EMTDR_CONFIG_M.SOURCE_TEMP_3is''拓展字段3'';co
mmentoncolumnCMM_EMTDR_CONFIG_M.SOURCE_TEMP_4is''拓展字段4'';comme
ntoncolumnCMM_EMTDR_CONFIG_M.SOURCE_TEMP_5is''拓展字段5'';comment
oncolumnCMM_EMTDR_CONFIG_M.SOURCE_USE_YNis''使用与否字段'';commenton
columnCMM_EMTDR_CONFIG_M.INST_IDis''创建人'';commentoncolumnCMM_EMTDR_CONFIG_M.INST_DTMis''创建日期'';commentoncolumnCMM_EMTDR_CONFIG_M.MDF_IDis''修改人'';commentoncolumnCMM_EMTDR_CONFIG_M.MDF_DTMis''修改日期'';--Create/Recreateprimary,uniqueandforeignkeyconstraintsaltertableCMM_EMTDR_CONFIG_MaddconstraintPK_CMM_EMTDR_CONFIG_Mprimarykey(SOURCE_TYPE)usingindextablespaceTS_INX_BSCpctfree10initrans2maxtrans255storage(initial64Knext1Mminextents1maxextentsunlimited); |
|
