62,025
社区成员
发帖
与我相关
我的任务
分享
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Web._Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1" ServicePath="WebService1.asmx" ServiceMethod="SearchUserNameByName" MinimumPrefixLength="1" CompletionSetCount="12">
</cc1:AutoCompleteExtender>
</form>
</body>
</html>
public string[] GetAll(string prefixText, int count)
{
List<Model.OrganizationModel> list = new List<OrganizationModel>();
Model.OrganizationModel orgmodel = null;
string sql = "select OrgName from Organization where OrgName like '@prefixText%'";
SqlParameter[] pm = new SqlParameter[] {
new SqlParameter("@prefixText",prefixText)
};
SqlDataReader dr = null;
dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, pm);
if (dr != null)
{
while (dr.Read())
{
orgmodel = new OrganizationModel();
orgmodel.ID = Convert.ToInt32(dr["ID"]);
orgmodel.DeclareID = dr["DeclareID"].ToString().Trim();
orgmodel.OrgCode = dr["OrgCode"].ToString().Trim();
orgmodel.OrgName = dr["OrgName"].ToString().Trim();
orgmodel.OrgType = dr["OrgType"].ToString().Trim();
orgmodel.LoginPasswordOne = dr["LoginPasswordOne"].ToString().Trim();
orgmodel.BeginTime = Convert.ToDateTime(dr["BeginTime"]);
orgmodel.EndTime = Convert.ToDateTime(dr["EndTime"]);
orgmodel.SubTime = Convert.ToDateTime(dr["SubTime"]);
}
dr.Close();
}
List<string> reslut = new List<string>();
foreach (OrganizationModel item in list)
{
reslut.Add(item.OrgName);
}
return reslut.ToArray();
}