62,267
社区成员
发帖
与我相关
我的任务
分享 $(document).ready(function()
{
$("#txt_Keys").keyup(function()
{
var proname=$("#txt_Keys").val();
if(proname.length!=0)
{alert(proname);
$("autodiv").attr("style","display:block");
$.ajax(
{
type:"GET",
url:"Handler.ashx",
data:"keyword"+proname,
success:function(data)
{
if(data!="")
{
<!--写到这里有点迷糊了,不知道该干啥了~-->
}
}
})
}
})
});其中Handler.ashx代码如下:public void ProcessRequest (HttpContext context)
{
context.Response.ClearContent();
context.Response.ContentType = "text/plain";
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
string proName="";
proName = context.Request["keyword"];
string sql = "select Top 10 Project_Name from UDP_Project where Project_Name like '" + proName + "'";
DataSet ds = SQLHelper.theSearch(sql);
ArrayList list = new ArrayList();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
list.Add(ds.Tables[0].Rows[i].ToString().Trim());
}
System.Threading.Thread.Sleep(1000);
context.Response.Write(list);
context.Response.End();
},麻烦帮我看看,有没有写错了,做了几天了~~ <script type="text/javascript">
$(document).ready(function()
{
//使div隐藏
$("#autodiv").attr("style","display:none");
// var p=$("#txt_Keys");
// var position=p.position();
// $("#autodiv").html("left:"+position.left+",top:"+position.top);
$("#txt_Keys").keyup(function()
{
var proname=$("#txt_Keys").val();
var s="";
if(proname.length!=0)
{
//$("#autodiv").attr("style","display:none");
$.ajax(
{
type:"GET",
url:"Handler.ashx",
data:"keyword="+proname,//后台接收proname的关键
success:function(data)
{
if(data!="")
{
data=eval('('+data+')');
//json串输出
$.each(data,function(i,v)
{
$.each(v,function(k,val)
{
//alert(val.proName);
s+="<table><tr><td width=\"152px\" left=\"0\">"+val.proName+"</td></tr></table>";
$("#autodiv").attr("style","display:block");
document.getElementById("autodiv").innerHTML=s;
})
})
$("#autodiv td").click(function(e)
{
$("#txt_Keys").val($(this).text());
$("#autodiv").attr("style","display:none");
//$("#autodiv").fadeOut('slow');
})
$("#autodiv td").mouseover(function(e)
{
$(this).css("background","#B3CFFC");
$(this).css("cursor","hand")
})
$("#autodiv td").mouseout(function(e)
{
$(this).css("background","");
})
}
}
})
}
})
});
</script>
public class Handler : IHttpHandler
{
string proName = "";
public void ProcessRequest (HttpContext context)
{
context.Response.ClearContent();
context.Response.ContentType = "text/plain";
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
proName = context.Request["keyword"];
string sql = "select Top 10 Project_Name from UDP_Project where Project_Name like '%" + proName + "%' or Project_Yjdw like '%"+proName+"%' or Project_Yjr like '%"+proName+"%'";//写上自己的SQL
DataSet ds = SQLHelper.theSearch(sql);//这个应该能看懂吧。返回的是DataSet
string json = "";
json = this.DataTableToJSON(ds.Tables[0]);
context.Response.Write(json);
context.Response.End();
}
//public string ToJSON(string item)
//{
// // TODO: ToJSON 实现
// string json = string.Empty;
// return "{"+string.Format("\"proName\":\"{0}\"",item)+"}";
//}
public string DataTableToJSON(DataTable dt)
{
//DataTable转换成JSON
if (dt != null && dt.Rows.Count > 0)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{");
jsonBuilder.Append("\"proNames\":");
jsonBuilder.Append("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
jsonBuilder.Append("\"");
jsonBuilder.Append("proName");
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][0].ToString());
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
else
{
return "{\"proName\":\"\"}";
}
}<input id="txt_Keys" type="text"/>
<div id="autodiv"></div>
<script type="text/javascript" language="javascript">
$(document).ready(function() {
$.ajax({
type: "get",
contentType: "application/json",
url: "returndata.aspx",
success: function(data) {
var data = eval("(" + data + ")");
$("#txtIMO").autocomplete(data, {
minChars: 1,
matchContains: true,
autoFill: false,
mustMatch: false, //是否完全匹配
width: 80, //宽度
formatItem: function(row, i, max) {
return row.IMO;
},
formatMatch: function(row, i, max) {
return row.IMO;
},
formatResult: function(row) {
return row.IMO;
}
});
}
})
})
</script>
JavaScriptSerializer j = new JavaScriptSerializer();
json = j.Serialize(list);
Response.Write(json);
Response.End();