JQuery下拉框模糊查詢

1、2012-04-1014:24C#+jQuery+div實現(xiàn)下拉框信息提示模糊搜索結(jié)果（百度、google搜索提示框）實現(xiàn)效果：用戶輸入查詢字符串，當(dāng)文本框內(nèi)容變化時，顯示下拉框為用戶提示完整信息，并可以實現(xiàn)選中所查信息后獲得對應(yīng)ID而進行更進一步的關(guān)聯(lián)顯示。（比如搜某一公司，選中公司后在根據(jù)公司ID獲得公司產(chǎn)品）。推薦jQueryAutocomplete插件：（演示地址）http:/jquery.bassistance.de/autocomplete/demo/?主人博客：http:/bassistance.de/（還有好多有用的Plugins）手動實現(xiàn)：在輸入框所在的頁面：引入jquery

2、開發(fā)包：樣式及腳本bodyfont:11pxarial;.suggest_link_altbackground-color:#FFFFFF;text-align:right;cursor:hand;padding:2px6px2px6px;z-index:101;.suggest_linkbackground-color:#FFFFFF;padding:2px6px2px6px;z-index:101;.suggest_link_overbackground-color:#E8F2FE;padding:2px6px2px6px;z-index:101;#search_suggestz-inde

3、x:100;position:absolute;background-color:#FFFFFF;text-align:left;border:1pxsolid#000000;#search_suggestRz-index:100;position:absolute;background-color:#FFFFFF;text-align:left;border:1pxsolid#000000;/*input*/.input_onmargin:2px8px0pt10px;height:18px;border:1pxsolid#999;background-color:#FFFFCC;.input

4、_offmargin:2px8px0pt10px;height:18px;border:1pxsolid#CCC;background-color:#FFF;.input_movemargin:2px8px0pt10px;height:18px;border:1pxsolid#999;background-color:#FFFFCC;.input_out/*height:16px;默認高度*/margin:2px8px0pt10px;height:18px;border:1pxsolid#CCC;background-color:#FFF;functionDivSetVisible(divid

5、,frameid,state)varDivRef=document.getElementById(divid);varIfrRef=document.getElementById(frameid);if(state)DivRef.style.display=block;IfrRef.style.width=DivRef.offsetWidth;IfrRef.style.height=DivRef.offsetHeight;IfrRef.style.top=DivRef.style.top;IfrRef.style.left=DivRef.style.left;IfrRef.style.zInd

6、ex=DivRef.style.zIndex-1;IfrRef.style.display=block;elseDivRef.style.display=none;IfrRef.style.display=none;/當(dāng)輸入框的內(nèi)容變化時，調(diào)用該函數(shù)functionsearchSuggest()if($(#txtSearch).val()!=&$(#txtSearch).val()!=null)$.ajax(type:GET,url:././AJAX.aspx,data:type=searchCompany&searchText=+escape($(#txtSearch).val(),succ

7、ess:function(result)varsourceText=result.split(*);if(sourceText.length1)DivSetVisible(search_suggest,DivShim,true);/$(#search_suggest).show();$(#search_suggest).html();for(vari=0;isourceText.length-1;i+)vars=+sourceTexti.split(,)1+;$(#search_suggest).html($(#search_suggest).html()+s);$(#search_sugge

8、st).html($(#search_suggest).html()+關(guān)閉提示/div);elseDivSetVisible(search_suggest,DivShim,false);/$(#search_suggest).hide(););elseDivSetVisible(search_suggest,DivShim,false);/$(#search_suggest).hide();functionsuggestOver(div_value)div_value.className=suggest_link_over;functionsuggestOut(div_value)div_va

9、lue.className=suggest_link;functionsetSearch(obj,id)$(#txtSearch).val(obj);$(#hidCompId).val(id);$.ajax(type:GET,url:././AJAX.aspx,data:type=getCompanyJob&companyId=+id,success:function(result)$(#drpPost).empty();varsourceText=result.split(*);if(sourceText.length1)for(vari=0;isourceText.length-1;i+)

10、$(+sourceTexti.split(,)1+).appendTo(#drpPost);$(#search_suggest).html();DivSetVisible(search_suggest,DivShim,false);/$(#search_suggest).hide();HTML:/r*1TCl,r*1IIAJAX.aspx實現(xiàn)：AJAX.aspx.cs:stringsearchText=RequestsearchText;StringBuilderresult=newStringBuilder(100);if(!string.IsNullOrEmpty(searchText)SqlDataReaderdr=null;trydr=SqlHelper.ExecuteReader(SqlHelper.ConnectionString,CommandType.Text,selecttop20Identifier,CompanyfromUserInfowherecompanylike%+keywords+%,newSqlParameter(keywords,sea