[color=#FF0000][b]服务器部分的代码。（这个除了函数开始申明[Ajax.AjaxMethod]与普通的asp.net代码是一样的）[/b][/color][Ajax.AjaxMethod]
public DataSet fds(string pageno,string lx)
{
dpath dp=new dpath();
DbClass dc=new DbClass(dp.Dbpath);
string sql1="select a.hit as hit, a.hlp as hlp, a.id as id,a.jylb as jylb,a.pname as pname,a.pfbsj as pfbsj,b.lb as plx from proc1 a left join pn_type b on a.plx=b.id where a.jylx="+lx+" order by pfbsj desc ";
int pgn=Convert.ToInt32(pageno);
pgn--;
dc.open();
DataSet myset=dc.MySelectSet(sql1,"a",20,pgn);
dc.close();
myset.Tables[0].Columns.Add("otime");
return myset;
}
[color=#FF0000]客户端的JS代码[/color]
function intl()
{ var cou=procshow.cou("1").value;
var zpage=cou/20;
zpage=parseInt(zpage);
zpage++;
document.getElementById("zpg").value=zpage;
var pageno=document.getElementById("hpgn").value;
opg.innerHTML="一共有:"+zpage+"页";
draw(pageno);
}
function topage()
{
var pageno=document.getElementById("pg").value;
document.getElementById("pg").value="";
draw(pageno);
}
function fir()
{draw("1");
}
function las()
{ var zpage=document.getElementById("zpg").value;
draw(zpage);
}
function rew()
{ var pageno=document.getElementById("hpgn").value;
var zpage=document.getElementById("zpg").value;
pageno=parseInt(pageno);
zpage=parseInt(zpage);
if(pageno<zpage)
{pageno++;
draw(pageno);}
else
{alert("已经是最后一页了");
pageno=zpage;}
}
function pre()
{ var pageno=document.getElementById("hpgn").value;
pageno=parseInt(pageno);
if(pageno>1)
{pageno--;
draw(pageno);
}
else
{ pageno=1;
alert("已经是第一页了");}
}
function draw(pageno)
{zpage=document.getElementById("zpg").value;
if(pageno==null || pageno==""|| pageno<1|| isNaN(pageno))
pageno="1";
zpage=parseInt(zpage);
pageno=parseInt(pageno);
if(pageno>zpage)
pageno=zpage;
document.getElementById("hpgn").value=pageno;
ocpg.innerHTML="现在是:"+pageno+"页";
var ds=procshow.fds(pageno,"1").value;//调用asp.net函数。
if(ds!=null){//
[color=#FF0000]处理返回的DATASET，使其生成为HTML格式[/color]
var s = new Array();
s[s.length] = "<TABLE style=BORDER-RIGHT: white 1px solid; BORDER-TOP: white 1px solid; BORDER-LEFT: white 1px solid; BORDER-BOTTOM: white 1px solid; BORDER-COLLAPSE: collapse borderColor=white cellSpacing=0 rules=all border=1>";
s[s.length] ="<TR style=BACKGROUND-COLOR: #999999>";
s[s.length] ="<TD style=WIDTH: 60px; COLOR: white; HEIGHT: 15px; BACKGROUND-COLOR: #6699cc align=middle>物品类型</TD>";
s[s.length] ="<TD style=WIDTH: 60px; COLOR: white; HEIGHT: 15px; BACKGROUND-COLOR: #6699cc align=middle>交易方式</TD>";
s[s.length] ="<TD style=WIDTH: 290px; COLOR: white; HEIGHT: 15px; BACKGROUND-COLOR: #6699cc align=middle>标题</TD>";
s[s.length] ="<TD style=WIDTH: 100px; COLOR: white; HEIGHT: 15px; BACKGROUND-COLOR: #6699cc align=middle>发布时间</TD>";
s[s.length] ="<TD style=WIDTH: 30px; COLOR: white; HEIGHT: 15px; BACKGROUND-COLOR: #6699cc align=middle>关注</TD></TR>";
for(var i=0; i<ds.Tables[0].Rows.length; i++){
if(i%2)
s[s.length] = "<TR style=FONT-SIZE: 12pt; BACKGROUND-COLOR: #e1f0f9><TD style=COLOR: black align=middle><SPAN>"+ds.Tables[0].Rows[i]["plx"]+"</SPAN> </TD>";
else
s[s.length] = "<TR><TD style=COLOR: black align=middle><SPAN>"+ds.Tables[0].Rows[i]["plx"]+"</SPAN> </TD>";
s[s.length] = "<TD style=COLOR: black align=middle><SPAN>"+ds.Tables[0].Rows[i]["jylb"]+"</SPAN></TD>";
s[s.length] = "<TD style=COLOR: black><SPAN><A href=proc/"+ds.Tables[0].Rows[i]["hlp"]+".html>"+ds.Tables[0].Rows[i]["pname"]+"</A></SPAN></TD>";
s[s.length] = "<TD style=COLOR: black align=middle><SPAN>"+ds.Tables[0].Rows[i]["otime"]+"</SPAN></TD>";
s[s.length] = "<TD style=COLOR: black vAlign=center align=middle><SPAN>"+ds.Tables[0].Rows[i]["hit"]+"</SPAN></TD></TR>";
}
s[s.length] = "</table>";
ogid.innerHTML = s.join("");
}
else {
alert("数据是空的");
}
}
[color=#FF0000]前台的HTLM[/color]
<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
<TR>
<TD vAlign="middle" width="100%">
<TABLE cellSpacing="1" cellPadding="1" width="98%" align="center" border="0">
<TR>
<TD id="ogid">
</TD>
</TR>
<TR>
<TD align="center">
<input type="hidden" id="hpgn"><input type="hidden" id="zpg">
<table border="0" cellpadding="2" height="28" width="100%">
<tr>
<td><a href="javascript:fir()">第一页</a> <a href="javascript:pre()">前一页</a> <a href="javascript:rew()">后一页</a> <a href="javascript:las()">最后一页</a></td><td>转到:<input id="pg" type="text" size="1" style="WIDTH: 15px">页<input type="button" id="bt" value="转" onclick="topage();"></td>
<td id="ocpg" width="100" valign="middle" align="right"></td>
<td id="opg" width="100" valign="middle" align="left"></td>
</tr>
</table></TD></TR>
<tr>
<td>
</td>
</tr>
</TABLE> |