js文件: var where=" where pd_Isjifen=0 and pd_Isok=1"; //查询条件 var psize=16; //查询数据数目 var pindex=0;//当前页数 var order=" order by pd_Update desc,type_sort,pd_brand,pd_typeid"; //排序条件 var temp=0; //模板名称 var Pcount=0; //获取参数 function getUrlPara(paraName) { var str=window.location.search; if (str.indexOf(paraName)!=-1) { var pos_start=str.indexOf(paraName)+paraName.length+1; var pos_end=str.indexOf("&",pos_start); if (pos_end==-1) { return str.substring(pos_start); } else { return str.substring(pos_start,pos_end) } } else { return ""; } } //设置查询条件 function Set_Where() { var country=getUrlPara("country"); if(country!='') { where+=" and pd_country='" + unescape(country) + "'"; } var search=getUrlPara("search"); if(search!='') { where+=" and " + Get_where(unescape(search)); } var cell=getUrlPara("cell"); if(cell!='') { where+=" and pd_Is" + cell + "=1"; } var days=getUrlPara("days"); if(days!='') { where+=" and DATEDIFF([day], pd_update, GETDATE()) <= " + days; } var tp=getUrlPara("tp"); if(tp!='') { where+=" and pd_Isimport='" + (parseInt(tp)-1)+"'"; order=" order by pd_Update desc,type_sort desc,pd_brand,pd_typeid"; } var brand=getUrlPara("brend"); if(brand!='') { where+=" and pd_brand='" + unescape(brand) + "'"; } } function Get_where(str) { return " (charindex(RTRIM('" + str + "'),RTRIM(pd_keyword))>0 or charindex(RTRIM('" + str + "'),RTRIM(pd_name))>0 or charindex(RTRIM('" + str + "'),RTRIM(pd_search))>0 or pd_brand='" + str + "' or pd_itemno='" + str + "')"; } //获取数据 function Get_div() { var div="查询数据超时,请刷新页面重新查询!"; where=where.replace(//u002B/g, ' '); var rt=TxAjax.Get_ProductDiv(temp,where,psize,pindex,order); var rt2=TxAjax.Get_PageCount(temp,where,psize,pindex,order); if (rt!= null) { var ds1 = rt.value; if(ds1 != null ) { div=ds1; } } if (rt2!= null) { var sum = rt2.value; if(sum != null ) { Pcount=parseInt(sum); } } return div; } //绑定数据 function Bind_Data() { //CreateProcess(); try { if(temp==0) { psize=16; } else { psize=10; } var pDiv=document.getElementById ("pdDiv"); var str=Get_div(); var sum=Pcount; pDiv.innerHTML=str; correctPNG(); document.getElementById ("sums").innerText =sum; document.getElementById ("index").innerText = parseInt(pindex)+1; document.getElementById ("sums2").innerText =Pcount; document.getElementById ("index2").innerText = parseInt(pindex)+1; if(pindex==(parseInt(sum)-1)) { document.getElementById ("last").disabled =true; document.getElementById ("last2").disabled=true; document.getElementById ("next").disabled =true; document.getElementById ("next2").disabled =true; } else { document.getElementById ("last").disabled =false; document.getElementById ("last2").disabled =false; document.getElementById ("next").disabled =false; document.getElementById ("next2").disabled =false; } if(pindex==0) { document.getElementById ("first").disabled =true; document.getElementById ("first2").disabled =true; document.getElementById ("prev").disabled =true; document.getElementById ("prev2").disabled =true; } else { document.getElementById ("first").disabled =false; document.getElementById ("first2").disabled =false; document.getElementById ("prev").disabled =false; document.getElementById ("prev2").disabled =false; } } catch(e) { var pDiv=document.getElementById ("pdDiv"); pDiv.innerHTML="查询数据出错,请刷新页面重新读取数据!"; } //ClearProcess(); } //第一页 function ToFirst() { if(pindex!=0) { pindex=0; Bind_Data(); } } //最末页 function ToLast() { if(pindex!=parseInt(document.getElementById ("sums").innerText)-1) { pindex=parseInt(document.getElementById ("sums").innerText)-1; Bind_Data(); } } //上一页 function ToPrev() { if(pindex>0) { pindex--; Bind_Data(); } } //下一页 function ToNext() { var sum=document.getElementById ("sums").innerText ; if(pindex<parseInt(sum)-1) { pindex++; Bind_Data(); } } //转到 function goTo() { var p=parseInt(document.getElementById ("Tindex").value); var sum=parseInt(document.getElementById ("sums").innerText); if(p>0 && p<=sum) { pindex=(p-1); Bind_Data(); } else { window.alert ("请不要超出页面范围*_*"); } } //转到2 function goTo2() { var p=parseInt(document.getElementById ("Tindex2").value); var sum=parseInt(document.getElementById ("sums2").innerText); if(p>0 && p<=sum) { pindex=(p-1); Bind_Data(); } else { window.alert ("请不要超出页面范围*_*"); } } //时间排序 function DateSort(e) { if(e.src.indexOf("down")>0) { e.src="index_img/date_up.jpg"; order=" order by pd_update desc"; } else { e.src="index_img/date_down.jpg"; order=" order by pd_update"; } Bind_Data(); } //时间排序 function PriceSort(e) { if(e.src.indexOf("价格上")>0) { e.src="index_img/价格下.jpg"; order=" order by pd_vipprice"; } else { e.src="index_img/价格上.jpg"; order=" order by pd_vipprice desc"; } Bind_Data(); } //平铺 function pView(e) { if(e.src.indexOf("平铺1")>0) { e.src="index_img/平铺.jpg"; document.getElementById ("Itable").src="index_img/列表.jpg"; temp=0; } else { e.src="index_img/平铺1.jpg"; document.getElementById ("Itable").src="index_img/列表1.jpg"; temp=1; } pindex=0; Bind_Data(); } function pView2(e) { if(e.src.indexOf("列表1")>0) { e.src="index_img/列表.jpg"; document.getElementById ("Idiv").src="index_img/平铺.jpg"; temp=0; } else { e.src="index_img/列表1.jpg"; document.getElementById ("Idiv").src="index_img/平铺1.jpg"; temp=1; } pindex=0; Bind_Data(); } //创建进度条 function CreateProcess() { move_layer2(); document.getElementById("Proc").style .visibility="visible"; } //清除进度条 function ClearProcess() { document.getElementById("Proc").style .visibility="hidden"; } //指定位置 function move_layer2(event){ event = event || window.event; var x,y; if(typeof event.pageX!='undefined'){ x=event.pageX+10; y=event.pageY-10; }else{ x=event.clientX+(document.documentElement.scrollLeft ? document.documentElement.scrollLeft :document.body.scrollLeft); y=event.clientY+(document.documentElement.scrollTop ?document.documentElement.scrollTop : document.body.scrollTop); } document.getElementById("Proc").style.left=x; document.getElementById("Proc").style.top=y; } function Trim(m){ while((m.length>0)&&(m.charAt(0)==' ')) m = m.substring(1, m.length); while((m.length>0)&&(m.charAt(m.length-1)==' ')) m = m.substring(0, m.length-1); return m; } function Init_Data() //入口 { Set_Where(); Bind_Data(); ClearProcess(); } ajax文件: using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using Ajax; using System.Data.SqlClient; using mydatabase; using System.Collections; namespace Txmother { /// <summary> /// TxAjax 的摘要说明 /// </summary> public class TxAjax { public TxAjax() { // // TODO: 在此处添加构造函数逻辑 // } /// <summary> /// 读取商品一页数据 /// </summary> /// <param name="where">查询条件</param> /// <param name="psize">分页尺寸</param> /// <param name="pindex">当前页</param> /// <param name="order">排序条件</param> /// <returns></returns> [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] public DataTable get_ProductDt(string where,string psize,string pindex,string order) { Hashtable ht = new Hashtable(); database mydata = new database(); DataTable dt = new DataTable(); int len = where.Length; if (len > 350) { where = " where pd_Isok=1 and pd_Isjifen=0"; len = where.Length; } ht = new Hashtable(); ht.Add("@pagesize", Convert.ToInt32(psize)); ht.Add("@currentpage", Convert.ToInt32(pindex)); ht.Add("@order",order); ht.Add("@where1", where); mydata = new database(); dt = mydata.get_table("getpage", ht).Tables[0]; return dt; } /// <summary> /// 读取商品信息 /// </summary> /// <param name="temp">模板类型</param> /// <param name="where">查询条件</param> /// <param name="psize">页面尺寸</param> /// <param name="pindex">当前页数</param> /// <param name="order">排序条件</param> /// <returns></returns> [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] public string Get_ProductDiv(string temp, string where, string psize, string pindex, string order) { string Div = "查询数据为空,请选择其它商品吧^_^!"; DataTable dt =get_ProductDt (where,psize ,pindex ,order); if (dt.Rows.Count > 0) { Div = ""; foreach (DataRow dr in dt.Rows) { if (temp == "0") { Div += "<div style =/"width:195px; float:left; text-align:left;/"><table width=195 border=0 cellpadding=0 cellspacing=0><tr><td width=/"195/" height=/"205/" align=/"center/"><table width=/"120/" border=/"0/" cellpadding=/"0/" cellspacing=/"1/" bgcolor=/"#CCCCCC/"><tr><td bgcolor=/"#FFFFFF/"> <a href =/"product_rt.aspx?pid=" + dr["pd_id"] + "/" target =/"_blank/" ><img src="/" mce_src="/""ProductImages/" + dr["pd_smallImage"] + "/" alt =/"" + dr["pd_name"].ToString ().Trim () + "/" style="/" mce_style="/""BORDER-RIGHT: #FFFFFF 1px solid; BORDER-TOP: #FFFFFF 1px solid; BORDER-LEFT: #FFFFFFFF1px solid; BORDER-BOTTOM: #FFFFFF 1px solid/" onMouseOver=/'this.style.border=/"1px solid #DD338C/"/' onMouseOut=/'this.style.border=/"1px solid #FFFFFF/"/' width=/"145/" height=/"150/" />" + get_post(dr["pd_Ispost"].ToString()) + "</a></td></tr></table><br /><font style="/" mce_style="/""Color:#333333;/">关爱价:</font><Label style="/" mce_style="/"" color:#DF328C;Font-Size:16px; font-weight:600;/">¥" +Convert .ToDouble ( dr["pd_vipprice"]).ToString ("0.0") + "</Label><Label style="/" mce_style="/"" color:#DF328C;/">/" + dr["pd_unit"] + "</Label></td></tr> <tr><td valign=/"top/"><table width=/"190/" height =/"90px/" border=/"0/" cellpadding=/"0/" cellspacing=/"0/" ><tr><td width=/"15/" align=/"left/" style="/" mce_style="/""height: 19px; /";></td><td width=/"175/" align=/"center/" style="/" mce_style="/""height: 19px;/"><font style="/" mce_style="/""Color:#333333;/">货号:</font><Label style="/" mce_style="/""Color:#8080FF;/">" + dr["pd_itemno"] + "</Label><a href =/"product_cart.aspx?pid=" + dr["pd_id"] + "/" target =/"_blank/" ><img src="/" mce_src="/""index_img/" + get_Img(dr["pd_qua"].ToString()) + "/" /></a></td></tr><tr><td align=/"center/" colspan=/"2/" rowspan=/"4/" valign=/"top/"><a href =/"product_rt.aspx?pid=" + dr["pd_id"] + "/" title =/"" + dr["pd_name"].ToString ().Trim () + "/" target =/"_blank/" >" + get_str(dr["pd_name"].ToString().Trim ()) + "</a> </td></tr></table></td></tr></table></div>"; } else { Div += "<div style =/"float :left/"><table width=/"757/" height=/"161/" border=/"0/" cellpadding=/"0/" cellspacing=/"0/"><tr><td width=/"133/" height=/"125/" rowspan=/"2/" align=/"center/"><table width=/"120/" height=/"125/" border=/"0/" cellpadding=/"0/" cellspacing=/"0/"><tr><td><a href =/"product_rt.aspx?pid=" + dr["pd_id"] + "/" target =/"_blank/" ><img src="/" mce_src="/""ProductImages/" + dr["pd_smallImage"] + "/" alt =/"" + dr["pd_name"].ToString ().Trim () + "/" style="/" mce_style="/""BORDER-RIGHT: #FFFFFF 1px solid; BORDER-TOP: #FFFFFF 1px solid; BORDER-LEFT: #FFFFFFFF1px solid; BORDER-BOTTOM: #FFFFFF 1px solid/" onMouseOver=/'this.style.border=/"1px solid #DD338C/"/' onMouseOut=/'this.style.border=/"1px solid #FFFFFF/"/' width=/"120/" height=/"125/" />" + get_post2(dr["pd_Ispost"].ToString()) + "</a></td></tr></table> </td><td height=/"30/" colspan=/"2/" align=/"center/" class=/"name/"><a href =/"product_rt.aspx?pid=" + dr["pd_id"] + "/" target =/"_blank/" > <font style="/" mce_style="/"" font-weight:700; font-size:16px; color:#0066FF;/">" + dr["pd_name"].ToString().Trim () + "</font></a></td><td width=/"147/" rowspan=/"2/"><table width=/"147/" height=/"91/" border=/"0/" cellpadding=/"0/" cellspacing=/"0/"><tr><td width=/"147/" class=/"name/"><font style="/" mce_style="/""Color:#333333;/">关爱价:</font><Label ID=/"Label3/" style="/" mce_style="/"" color:#DF328C;Font-Size:16px; font-weight:600;/">¥" +Convert .ToDouble (dr["pd_vipprice"]).ToString ("0.0") + "</Label><Label style="/" mce_style="/"" color:#DF328C;/" >/" + dr["pd_unit"] + "</:Label></td></tr><tr><td height=/"52/" class=/"hongse/"><font style="/" mce_style="/""Color:#333333;/">赠送积分:</font><Label ForeColor=/"Red/">" + dr["pd_jifen"] + "</:Label></td></tr></table><font style="/" mce_style="/""Color:#333333;/">货号:</font<Label ForeColor=/"#8080FF/" >" + dr["pd_itemno"] + "</:Label><a href =/"product_cart.aspx?pid=" + dr["pd_id"] + " target =/"_blank/" ><img src="/" mce_src="/""index_img/" + get_Img(dr["pd_qua"].ToString()) + "/" /></a></td></tr><tr><td width=/"99/" valign =/"top/" > </td><td width=/"855/" height=/"111/" valign =/"top/" style="/" mce_style="/""color:#999999; font-size:12px;/">颜色:<Label>" + get_str(dr["pd_color"].ToString()) + "</Label><br />规格:<Label>" + get_str(dr["pd_size"].ToString()) + "</Label></td></tr><tr><td height=/"1/" colspan=/"4/" align=/"center/" bgcolor=/"#CCCCCC/"></td></tr></table></div>"; } } } return Div; } /// <summary> /// 读取总页数 /// </summary> /// <param name="temp">模板类型</param> /// <param name="where">查询条件</param> /// <param name="psize">页面尺寸</param> /// <param name="pindex">当前页数</param> /// <param name="order">排序条件</param> /// <returns></returns> [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] public int Get_PageCount(string temp, string where, string psize, string pindex, string order) { int pcount = 0; DataTable dt = get_ProductDt(where, psize, pindex, order); pcount = int.Parse(dt.Rows[0]["pcount"].ToString ()); return pcount; } public string get_str(string str) { str = ComClass.split_str(str, 50); if (str.IndexOf('"') > 0) { str = str.Insert(str.LastIndexOf('"') + 1, "<br/>"); } else if (str.IndexOf('”') > 0) { str = str.Insert(str.IndexOf('”') + 1, "<br/>"); } else if (str.IndexOf("品牌") > 0) { str = str.Insert(str.IndexOf("品牌") + 2, "<br/>"); } else if (str.IndexOf("名牌") > 0) { str = str.Insert(str.IndexOf("名牌") + 2, "<br/>"); } else if (str.IndexOf("进口") > 0) { str = str.Insert(str.IndexOf("进口") + 2, "<br/>"); } else if (str.IndexOf("名厂") > 4) { str = str.Insert(str.IndexOf("名厂") + 2, "<br/>"); } return str; } /// <summary> /// 获取订购按钮 /// </summary> /// <param name="qua">数量</param> /// <returns></returns> public string get_Img(string qua) { string q = "buy.gif"; if (qua != "") { int o = 0; int.TryParse(qua, out o); if (o.ToString() != null) { if (o < 1) { q = "buy1.gif"; } } } else { q = "buy.gif"; } return q; } /// <summary> /// 获取包邮图标 /// </summary> /// <param name="str"></param> /// <returns></returns> public string get_post(string str) { string post = ""; if (str == "True") { post = "<div align =/"left/" style= /"z-index:999;margin-top:-153px; background:trasparent; vertical-align :top ;/"><img src =/"index_img/post.png/" /></div>"; } return post; } /// <summary> /// 获取包邮图标 /// </summary> /// <param name="str"></param> /// <returns></returns> public string get_post2(string str) { string post = ""; if (str == "True") { post = "<div align =/"left/" style= /"z-index:999;margin-top:-123px; background:trasparent; vertical-align :top ;/"><img src =/"index_img/post.png/" /></div>"; } return post; } } } 后台注册代码: Ajax.Utility.RegisterTypeForAjax(typeof(Txmother.TxAjax)); aspx调用js文件 <script type ="text/javascript" src ="JS/文件名.js"></script> 其它html代码: <div id="Proc" style="position:absolute; left:52%; top:122%;"><img src="index_img/process.gif" mce_src="index_img/process.gif" /></div> <td align ="right" valign="bottom" style="100%" mce_style="100%">排序:<img id="Idate" Width ="60px" Height ="20px" style=" cursor :hand;" mce_style=" cursor :hand;" onclick ="DateSort(this);" src="index_img/date_down.jpg" mce_src="index_img/date_down.jpg" /> <img id="Iprice" style=" cursor :hand;" mce_style=" cursor :hand;" Width ="60px" Height ="20px" onclick ="PriceSort(this);" src="index_img/价格上.jpg" mce_src="index_img/价格上.jpg" /> 显示方式:<img id="Idiv" onclick ="pView(this);" Width ="20px" Height ="20px" style=" cursor :hand;" mce_style=" cursor :hand;" src="index_img/平铺.jpg" mce_src="index_img/平铺.jpg" /> <img id="Itable" Width ="20px" Height ="20px" onclick ="pView2(this);" style=" cursor :hand;" mce_style=" cursor :hand;" src="index_img/列表.jpg" mce_src="index_img/列表.jpg" /> </td> </tr> <tr> <td background="index_img/xuxian.jpg" height="2"></td> <td background="index_img/xuxian.jpg" height="2"></td> </tr> <tr> <td colspan="2" valign ="bottom" > 总共<label id="sums">0</label>页 第<label id="index">0</label>页 <a id="first" style="cursor:hand" mce_style="cursor:hand" onclick ="ToFirst();">首页</a> <a style="cursor:hand" mce_style="cursor:hand" id="prev" onclick ="ToPrev();">上一页</a> <a style="cursor:hand" mce_style="cursor:hand" onclick ="ToNext();" id="next">下一页</a> <a style="cursor:hand" mce_style="cursor:hand" onclick ="ToLast();" id="last">末页</a> <a id="goTo" style="cursor:hand" mce_style="cursor:hand" onclick ="goTo();">转到</a> <input id="Tindex" type="text" style="width: 18px" /> </td> </tr> </table> <div style ="width:800px; float :left; text-align :left " id="pdDiv"> </div>