asp.net 智能收索
<script type="text/javascript">
function selectHide() {
//获取表对象
document.getElementById("select").style.display = "block";
document.getElementById("comment").style.display = 'none';
document.getElementById("input").value = "0";
}
function closeHide() {
//隐藏表对象
document.getElementById("select").style.display = "none";
document.getElementById("input").value = "1";
}
function clear() {
document.getElementById("input").value = "";
document.getElementById("txtNumber").value = "";
document.getElementById("txtname").value = "";
document.getElementById("txtAuthor").value = "";
document.getElementById("txtPrice").value = "";
}
</script>
<script language="javascript">
var xmlHttp;
function check() {
var txtNumber = document.getElementById("txtNumber").value.replace(/\s/g, "") ;
if (txtNumber.trim() != "") {
document.getElementById("comment").style.display = 'block';
if (document.getElementById("comment").length > 0) {
var l = document.getElementById("comment").length;
for (var i = 0; i < l; i++) {
document.getElementById("comment").remove(0);
}
}
var url = "getreturnValue.aspx?txtNumber=" + encodeURI(encodeURI(txtNumber));
sendRequest(url);
}
else {
document.getElementById("comment").style.display = 'none';
}
}
var xmlHttp;
function createXmlHttp() {
var activeKey = new Array("MSXML2.XMLHTTP.5.0",
"MSXML2.XMLHTTP.4.0",
"MSXML2.XMLHTTP.3.0",
"MSXML2.XMLHTTP", "Microsoft.XMLHTTP");
if (window.ActiveXObject) {
for (var i = 0; i < activeKey.length; i++) {
try {
xmlHttp = new ActiveXObject(activeKey[i]);
if (xmlHttp != null)
return xmlHttp;
}
catch (Error) {
continue;
}
}
throw new Error("客户端浏览器版本太低，不支持XMLHttpRequest对象，请更新浏览器");
} else if (window.XMLHttpRequest) {
xmlHttp = new window.XMLHttpRequest();
}
}
function sendRequest(url) {
var theurl = url;
createXmlHttp();
xmlHttp.open("post", url, true);
xmlHttp.onreadystatechange = handleStateChange;
xmlHttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xmlHttp.send(null);
}
function handleStateChange() {
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200) {
var msg = xmlHttp.responseText;
if (msg == "") {
document.getElementById("comment").style.display = 'none';
}
document.getElementById("comment").style.display = 'block';
var arr = msg.split(",");
for (var i = 0; i < arr.length; i++) {
document.getElementById("comment").options[i] = new Option(arr[i], arr[i]);
}
}
else {
alert('页面出现错误！');
}
}
}
function gaibian(bb) {
document.getElementById("txtNumber").value = bb;
}
//隐藏DIV
function hidDiv() {
document.getElementById('comment').style.display = 'none';
}
</script>
前台页面：
<table width="100%" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="35">
<table width="100%" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17">
</td>
<td valign="top">
<div id="printshow2">
<table align="center" background="../images/bg0003.gif" border="0" cellpadding="0"
cellspacing="0" width="100%">
<tr>
<td style="height: 26px" align="right">
<a href="javascript:void(0)">
<img onclick="selectHide()" src="~/images/button_search.jpg" border="0" id="IMG1"
runat="server" /></a>
</td>
</tr>
</table>
</div>
</td>
<td width="17">
</td>
</tr>
</table>
<table width="100%" id="select" style="display: none" >
<thead>
<tr>
<th>
图书编号：
</th>
<td>
<asp:TextBox ID="txtNumber" autocomplete="true" onKeyUp="javascript:check();" runat="server"></asp:TextBox>
<div id="div2" style="position: absolute; z-index: 1100; border: 1px; border-color: Blue;">
<span style="border-width: 1px; border-color: Blue; position: absolute; overflow: hidden">
<select id="comment" size="10" style="border: 1px; border-color: Blue; width: 140px;
margin: -2px;" onchange="gaibian(this.value)" onfocusout="javascript:hidDiv();"
runat="server">
</select>
</span>
</div>
</td>
<th>
图书名称：
</th>
<td>
<asp:TextBox ID="txtname" runat="server"></asp:TextBox>
<a href="#">
<img src="images/FDJ.gif" style="border: 0;" /></a>
</td>
</tr>
<tr>
<th>
作者：
</th>
<td style="border-color: Blue">
<asp:TextBox ID="txtAuthor" runat="server" />
</td>
<th>
价格：
</th>
<td>
<asp:TextBox ID="txtPrice" runat="server" />
</td>
</tr>
<tr>
<td colspan="4" align="center">
<asp:Button ID="Button1" runat="server" Text="查询" OnClick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="导出Excel"
onclick="Button2_Click" />
<asp:Button ID="Button3" runat="server" Text="关闭" OnClientClick="return closeHide();" />
</td>
</tr>
</thead>
</table>
<input type="text" id="input" runat="server" style="display: none" />
<table width="100%" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17">
</td>
<td valign="top">
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td valign="top">
<div id="Div1">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="#4D77B1" BorderColor="#4D77B1" BorderStyle="None"
BorderWidth="1px" CellPadding="3" CellSpacing="1" GridLines="None" PageSize="12"
Style="font-size: 12px" Width="100%">
<PagerSettings Visible="False" />
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<Columns>
<asp:TemplateField HeaderText="编号" SortExpression="department">
<ItemStyle Wrap="True" />
<HeaderStyle BackColor="#94C3CE" ForeColor="DarkSlateGray" HorizontalAlign="Center"
Wrap="False" />
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "bookNumber")%></a>
</ItemTemplate>
<FooterStyle Wrap="True" />
</asp:TemplateField>
<asp:TemplateField HeaderText="图书名称">
<ItemStyle Wrap="True" />
<HeaderStyle BackColor="#94C3CE" ForeColor="DarkSlateGray" HorizontalAlign="Center"
Wrap="False" />
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "name")%>
</ItemTemplate>
<FooterStyle Wrap="True" />
</asp:TemplateField>
<asp:TemplateField HeaderText="价格">
<ItemStyle Wrap="True" />
<HeaderStyle BackColor="#94C3CE" ForeColor="DarkSlateGray" HorizontalAlign="Center"
Wrap="False" />
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "price")%>
</ItemTemplate>
<FooterStyle Wrap="True" />
</asp:TemplateField>
<asp:TemplateField HeaderText="作者">
<ItemStyle Wrap="True" />
<HeaderStyle BackColor="#94C3CE" ForeColor="DarkSlateGray" HorizontalAlign="Center"
Wrap="False" />
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "auther")%>
</ItemTemplate>
<FooterStyle Wrap="True" />
</asp:TemplateField>
<asp:TemplateField HeaderText="创作时间" SortExpression="createtime">
<ItemStyle Wrap="True" />
<HeaderStyle BackColor="#94C3CE" ForeColor="DarkSlateGray" HorizontalAlign="Center"
Wrap="False" />
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "createtime", "{0:yyyy-MM-dd}")%>
</ItemTemplate>
<FooterStyle Wrap="True" />
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#FBFCFE" ForeColor="Black" />
<SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" Wrap="False" />
<AlternatingRowStyle BackColor="#E6EDF7" />
<EmptyDataTemplate>
<div align="center">
<font color="white">无相关数据！</font></div>
</EmptyDataTemplate>
</asp:GridView>
</div>
</td>
</tr>
</table>
</td>
<td width="17">
</td>
</tr>
</table>
<div id="printshow3">
<table width="100%" height="34" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17">
</td>
<td valign="top" background="images/next_bg.jpg">
</td>
<td width="17">
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
后台代码：
View Code
public string sql = "";
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request["txtNumber"] != null)
{
string selectValue = Request["txtNumber"].ToString();
sql = "select bookNumber from bookList where bookNumber like '" +
HttpUtility.UrlDecode(HttpUtility.UrlDecode(selectValue, System.Text.Encoding.UTF8), System.Text.Encoding.UTF8) + "%'";
}
else
{
sql = "select bookNumber from bookList";
}
DataTable data = DbHelper.ExecuteTable(CommandType.Text, sql);
string name = "";
if (data != null && data.Rows.Count > 0)
{
for (int i = 0; i < data.Rows.Count; i++)
{
name = name + data.Rows[i]["bookNumber"].ToString() + ",";
}
name = name.Substring(0, name.Length - 1);
}
Response.Write(name);
Response.End();
}
catch
{
}
}
}
浙公网安备 33010602011771号