ASP.NET AJAX AutoComplete

最新推荐文章于 2019-01-08 01:30:03 发布

原创最新推荐文章于 2019-01-08 01:30:03 发布 · 612 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#autocomplete #asp.net #ajax #string #dataset #null

ASP.NET AJAX 专栏收录该内容

10 篇文章

订阅专栏

本文介绍了一个用于自动完成订单号搜索的Web方法实现。该方法通过连接Oracle数据库获取最近六个月内的有效订单号，并按订单号降序排列。采用不区分大小写的比较方式，实现了根据输入前缀快速匹配并返回最多十个相关订单号的功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[WebMethod] [System.Web.Script.Services.ScriptMethod()] public string[] GetNumber(string prefixText, int count) { string[] autofilelist = null; if (autofilelist == null) { DataSet ds = OracleDp.GetOracleDp.SelData("select order_number from oe_order_headers_all where cancelled_flag <> 'Y' and open_flag <> 'N' and ordered_date >= (sysdate - 180) order by order_number desc"); string[] templist=new string[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { templist[i] = ds.Tables[0].Rows[i]["order_number"].ToString(); } Array.Sort(templist, new CaseInsensitiveComparer()); autofilelist = templist; } int index = Array.BinarySearch(autofilelist,prefixText,new CaseInsensitiveComparer()); if (index < 0) { index = ~index; } int matchcount = 0; for (matchcount = 0; matchcount < count && count + index < autofilelist.Length; matchcount++) { if (autofilelist[matchcount + index].StartsWith(prefixText, StringComparison.CurrentCultureIgnoreCase) == false) { break; } } string[] resultlist=new string[matchcount]; if (matchcount > 0) { Array.Copy(autofilelist, index, resultlist, 0, count); } else { resultlist = new string[1]; resultlist[0] = "暂无您搜索的数据！"; } return resultlist; }