关于不使用web服务实现文本框自动完成扩展

来博客园很久了，一直是伸手党，呵呵，现在终于申请了一个账号并开通了博客

下面分享下之前在一个项目里遇到的问题

前段时间在一个项目里要求在文本框内输入要搜索的内容，自动提示与此内容相关的词条

当时在博客园里看到了（http://www.cnblogs.com/insus/archive/2013/03/28/2986217.html）这篇文章觉得挺好，我也就按照这样的方法去做了

在逻辑层我写两个一个类，去跟数据层交互

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using Bthinking.PlatForm.SystemManage.BLL;
using Bthinking.PlatForm.SystemManage.Model;


/// <summary>
///ActiveDirectoryInfo 的摘要说明
/// </summary>
public class ActiveDirectoryInfo
{
    Dim_RessellorInfoBLL bll_RessellorInfo = new Dim_RessellorInfoBLL();
    public ActiveDirectoryInfo()
    {
        //
        //TODO: 在此处添加构造函数逻辑
        //
    }
    public DataTable GetDisplayName(string prefixText,int count)
    {
        Dim_RessellorInfoParameters para_RessellorInfo = new Dim_RessellorInfoParameters();
        para_RessellorInfo.RessellorName = prefixText;
        Dim_RessellorInfoCollection ressellorCollection = new Dim_RessellorInfoCollection();
        ressellorCollection = bll_RessellorInfo.GetAllDim_RessellorInfos(para_RessellorInfo,1,count);
        DataTable ret = new DataTable();
        ret = ressellorCollection.ToDataTable();
        return ret;
    }

    public int GetDisplayCount(string prefixText, int count)
    {
        Dim_RessellorInfoParameters para_RessellorInfo = new Dim_RessellorInfoParameters();
        para_RessellorInfo.RessellorName = prefixText;
        count = bll_RessellorInfo.GetRecordCount(para_RessellorInfo);
        return count;
    }
}

把一下代码拉至aspx页面

 <ajaxToolkit:ToolkitScriptManager ID="ToolkitScriptManager" runat="server"></ajaxToolkit:ToolkitScriptManager>

 

在对应控件出引入如下代码

<asp:TextBox ID="TxtRessellorName" runat="server" Height="21px" Width="188px"></asp:TextBox>
<ajaxToolkit:AutoCompleteExtender 
ID="AutoCompleteExtender1" runat="server"  MinimumPrefixLength = "1"
CompletionInterval = "1000" EnableCaching ="true"  CompletionSetCount = "10" TargetControlID="TxtRessellorName" ServiceMethod="GetDisplayUserName">
</ajaxToolkit:AutoCompleteExtender>

这里的ServiceMethod="GetDisplayUserName"对应CS中的方法 红色的部分必须添加

 　 [System.Web.Services.WebMethod]
    [System.Web.Script.Services.ScriptMethod]
    public static string[] GetDisplayUserName(string prefixText, int count)
    {
        ActiveDirectoryInfo objActiveDirectoryInfo = new ActiveDirectoryInfo();
        count = objActiveDirectoryInfo.GetDisplayCount(prefixText, count);
        DataTable dt = objActiveDirectoryInfo.GetDisplayName(prefixText, count);
        string[] strArray = new string[count];
        int i = 0;
        foreach (DataRow dataRow in dt.Rows)
        {
            //array.Add(dataRow["RessellorName"].ToString());
            strArray[i] = dataRow["RessellorName"].ToString();
            i++;
        }

        //return (string[])array.ToArray(typeof(string));
        return strArray;
    }
}

效果如下

总体来说，效果还是不错的，但是对于大数据量的词条筛选可能就显得有点鸡肋了