站长资源网络编程
AJAX和三层架构实现分页功能具体思路及代码
简介复制代码 代码如下: -----------------------------HTMLPage1.htm--------------------------------- </tit</div>
<div class="news_infos"><div id="MyContent"><U>复制代码</U> 代码如下: <BR>-----------------------------HTMLPage1.htm--------------------------------- <BR><html xmlns="http://www.w3.org/1999/xhtml"> <BR><head> <BR><title></title> <BR><style type="text/css"> <BR>table{ border:solid 1px #444; background-color:Aqua;} <BR>table td{border:solid 1px #444;} <BR></style> <BR><script src="/UploadFiles/2021-04-02/Jquery1.7.js"><script type="text/javascript"> <BR>$(function () { <BR>var pageindex = 1; <BR>var pagesize = 10; <BR>var lastpageindex = 1; <BR>loaddata(); <BR>function loaddata() { <BR>$.ajax({ <BR>type: "post", <BR>contentType: "application/json", <BR>url: "WebService1.asmx/GetListAjax", <BR>data: "{pagesize:" + pagesize + ",pageindex:" + pageindex + "}", <BR>success: function (result) { <BR>var strtable = '<table>'; <BR>strtable += '<tr><td>编号</td><td>标题</td><td>内容</td><td>创建时间</td></tr>'; <BR>for (var i = 0; i < result.d.length; i++) { <BR>strtable += '<tr>'; <BR>strtable += '<td>' + result.d[i].Id + '</td>'; <BR>strtable += '<td>' + result.d[i].NewsTitle + '</td>'; <BR>strtable += '<td>' + result.d[i].NewsContent + '</td>'; <BR>strtable += '<td>' + result.d[i].CreateTime + '</td>'; <BR>strtable += '</tr>'; <BR>} <BR>strtable += '</table>'; <BR>$('#mydiv').html(strtable); <BR>} <BR>}) <BR>} <BR>$.ajax({ <BR>type: "post", <BR>contentType: "application/json", <BR>url: "WebService1.asmx/GetLastPageindex", <BR>data: "{pagesize:" + pagesize + "}", <BR>success: function (result) { <BR>lastpageindex = result.d; <BR>} <BR>}) <BR>//第一页 <BR>$('a:first').click(function () { <BR>pageindex = 1; <BR>loaddata(); <BR>}) <BR>//上一页 <BR>$('#divfenye a:eq(1)').click(function () { <BR>if (pageindex > 1) { <BR>pageindex--; <BR>loaddata(); <BR>} <BR>}) <BR>//下一页 <BR>$('#divfenye a:eq(2)').click(function () { <BR>if (pageindex < lastpageindex) { <BR>pageindex++; <BR>loaddata(); <BR>} <BR>}) <BR>//最后一页 <BR>$('#divfenye a:eq(3)').click(function () { <BR>pageindex = lastpageindex; <BR>loaddata(); <BR>}) <BR>$('#divfenye a:last').click(function () { <BR>pageindex = $('#txtPageindex').val(); <BR>loaddata(); <BR>}) <BR>$('#txtPageindex').focus(function () { <BR>$(this).val(''); <BR>}) <BR>}) <BR></script> <BR></head> <BR><body> <BR><div id="mydiv"> <BR></div> <BR><div id="divfenye"><a href="#">第一页</a><a href="#">上一页</a><a href="#">下一页</a><a href="#">最后一页</a><input <BR>id="txtPageindex" type="text" /><a href="#">Go</a></div> <BR></body> <BR></html> <BR>-------------------------WebService1 -------------------------------- <BR>// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。 <BR>[System.Web.Script.Services.ScriptService] <BR>public class WebService1 : System.Web.Services.WebService <BR>{ <BR>[WebMethod] <BR>public string HelloWorld() <BR>{ <BR>return "Hello World"; <BR>} <BR>[WebMethod] <BR>public List<Model.T_News1> GetListAjax(int pagesize, int pageindex) <BR>{ <BR>BLL.T_News1 bnews = new BLL.T_News1(); <BR>DataTable dt = bnews.GetListDataTable(pagesize, pageindex); <BR>List<Model.T_News1> list = new List<Model.T_News1>(); <BR>int Id; <BR>string newstitle = ""; <BR>string newscontent = ""; <BR>DateTime createtime; <BR>for (int i = 0; i < dt.Rows.Count; i++) <BR>{ <BR>Id = Convert.ToInt32(dt.Rows[i]["Id"]); <BR>newstitle = dt.Rows[i]["NewsTitle"].ToString(); <BR>newscontent = dt.Rows[i]["NewsContent"].ToString(); <BR>createtime = Convert.ToDateTime(dt.Rows[i]["CreateTime"]); <BR>Model.T_News1 news = new Model.T_News1() <BR>{ <BR>Id = Id, <BR>NewsTitle = newstitle, <BR>NewsContent = newscontent, <BR>CreateTime = createtime <BR>}; <BR>list.Add(news); <BR>} <BR>return list; <BR>} <BR>[WebMethod] <BR>public int GetLastPageindex(int pagesize) <BR>{ <BR>BLL.T_News1 bnews = new BLL.T_News1(); <BR>int totalcount = bnews.GetRecordCount(""); <BR>if (totalcount % pagesize == 0) <BR>{ <BR>return totalcount / pagesize; <BR>} <BR>else <BR>{ <BR>return totalcount / pagesize + 1; <BR>} <BR>} <BR>------------------------------DAL层：-------------------------- <BR>/// <summary> <BR>/// 分页获取数据列表 <BR>/// </summary> <BR>public DataTable GetListDataTable(int PageSize, int PageIndex) <BR>{ <BR>SqlParameter[] parameters = { <BR>new SqlParameter("@PageSize", SqlDbType.Int), <BR>new SqlParameter("@PageIndex", SqlDbType.Int) <BR>}; <BR>parameters[0].Value = PageSize; <BR>parameters[1].Value = PageIndex; <BR>return DbHelperSQL.RunProcedureDataTable("pro_fenye", parameters); <BR>} <BR>--------------------BLL层：-------------------------- <BR>public DataTable GetListDataTable(int pagesize, int pageindex) <BR>{ <BR>return dal.GetListDataTable(pagesize, pageindex); <BR>} <BR>------------------DbHelperSQL:----------------------- <BR>public static DataTable RunProcedureDataTable(string storedProcName, IDataParameter[] parameters) <BR>{ <BR>using (SqlConnection connection = new SqlConnection(connectionString)) <BR>{ <BR>DataTable dt = new DataTable(); <BR>connection.Open(); <BR>SqlDataAdapter sqlDA = new SqlDataAdapter(); <BR>sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters); <BR>sqlDA.Fill(dt); <BR>connection.Close(); <BR>return dt; <BR>} <BR>} <BR></div>
</div>
</div>
<div class="share"> </div>
<div class="nextinfo">
<p>上一篇：<a href="/3g/1/160228.html" title="使用AJAX返回WebService里的集合具体实现">使用AJAX返回WebService里的集合具体实现</a></p>
<p>下一篇：<a href="/3g/1/160230.html" title="AJAX和WebService实现邮箱验证(无刷新验证邮件地址是否合法)">AJAX和WebService实现邮箱验证(无刷新验证邮件地址是否合法)</a></p>
</div>
<div class="otherlink">
<h2>最新资源</h2>
<ul>
<li><a href="/3g/1/623703.html" title="群星《奔赴！万人现场 第2期》[FLAC/分轨]">群星《奔赴！万人现场 第2期》[FLAC/分轨]</a></li>
<li><a href="/3g/1/623702.html" title="群星《奇妙浪一夏 (上海迪士尼度假区音乐">群星《奇妙浪一夏 (上海迪士尼度假区音乐</a></li>
<li><a href="/3g/1/623701.html" title="群星《奇妙浪一夏 (上海迪士尼度假区音乐">群星《奇妙浪一夏 (上海迪士尼度假区音乐</a></li>
<li><a href="/3g/1/623700.html" title="【古典音乐】詹姆斯·高威《季节》1993[WA">【古典音乐】詹姆斯·高威《季节》1993[WA</a></li>
<li><a href="/3g/1/623699.html" title="贝拉芳蒂《卡里普索之王》SACD[WAV+CUE]">贝拉芳蒂《卡里普索之王》SACD[WAV+CUE]</a></li>
<li><a href="/3g/1/623698.html" title="小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE">小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE</a></li>
<li><a href="/3g/1/623697.html" title="群星《欢迎来到我身边 电影原声专辑》[32">群星《欢迎来到我身边 电影原声专辑》[32</a></li>
<li><a href="/3g/1/623696.html" title="群星《欢迎来到我身边 电影原声专辑》[FL">群星《欢迎来到我身边 电影原声专辑》[FL</a></li>
<li><a href="/3g/1/623695.html" title="雷婷《梦里蓝天HQⅡ》 2023头版限量编号低">雷婷《梦里蓝天HQⅡ》 2023头版限量编号低</a></li>
<li><a href="/3g/1/623694.html" title="群星《2024好听新歌42》AI调整音效【WAV分">群星《2024好听新歌42》AI调整音效【WAV分</a></li>
</ul>
</div>
</div>
<div class="sidebar">
<div class="cloud"><h2 class="hometitle">一句话新闻</h2><a href="/3G/1/604673.html"><ul>高通与谷歌联手！首款骁龙PC优化Chrome浏览器发布<br><br>高通和谷歌日前宣布，推出首次面向搭载骁龙的Windows PC的优化版Chrome浏览器。<br>在对骁龙X Elite参考设计的初步测试中，全新的Chrome浏览器在Speedometer 2.1基准测试中实现了显著的性能提升。<br>预计在2024年年中之前，搭载骁龙X Elite计算平台的PC将面世。该浏览器的提前问世，有助于骁龙PC问世就获得满血表现。<br>谷歌高级副总裁Hiroshi Lockheimer表示，此次与高通的合作将有助于确保Chrome用户在当前ARM兼容的PC上获得最佳的浏览体验。</ul></a></div>
<div class="cloud"><h2 class="hometitle">标签云</h2><ul><a href="/search.asp?key=1080P高清&m=1">1080P高清<span>(5)</span></a><a href="/search.asp?key=高清电影&m=1">高清电影<span>(5)</span></a><a href="/search.asp?key=百度云盘&m=1">百度云盘<span>(5)</span></a><a href="/search.asp?key=网盘下载&m=1">网盘下载<span>(4)</span></a><a href="/search.asp?key=破解软件&m=1">破解软件<span>(4)</span></a><a href="/search.asp?key=绿色软件&m=1">绿色软件<span>(4)</span></a><a href="/search.asp?key=磁力链接&m=1">磁力链接<span>(3)</span></a><a href="/search.asp?key=强度天梯&m=1">强度天梯<span>(3)</span></a><a href="/search.asp?key=福利资源&m=1">福利资源<span>(2)</span></a><a href="/search.asp?key=王者荣耀&m=1">王者荣耀<span>(2)</span></a><a href="/search.asp?key=黑钻活动&m=1">黑钻活动<span>(2)</span></a><a href="/search.asp?key=WPS会员&m=1">WPS会员<span>(2)</span></a><a href="/search.asp?key=刷图排行&m=1">刷图排行<span>(1)</span></a><a href="/search.asp?key=网盘限速&m=1">网盘限速<span>(1)</span></a><a href="/search.asp?key=鬼灭之刃&m=1">鬼灭之刃<span>(1)</span></a><a href="/search.asp?key=免费韩国漫画&m=1">免费韩国漫画<span>(1)</span></a><a href="/search.asp?key=宫本重做&m=1">宫本重做<span>(1)</span></a><a href="/search.asp?key=免费动漫&m=1">免费动漫<span>(1)</span></a></ul></div>
</div>
<div class="sidebar">
友情链接:<a href="http://www.imxmx.com/" title="杰晶网络" target="_blank">杰晶网络</a> <a href="/" title="DDR爱好者之家" target="_blank">DDR爱好者之家</a> <a href="http://www.nqxw.com/" title="南强小屋" target="_blank">南强小屋</a> <a href="http://www.paidiu.com/" title="黑松山资源网" target="_blank">黑松山资源网</a> <a href="http://www.dyhadc.com/" title="白云城资源网" target="_blank">白云城资源网</a> <a href="/sitemap1.xml">站点地图</a> <a href="/sitemap.xml">SiteMap</a>
</div>
</article>
<footer>
<p>Design by <a href="http://m.ddrfans.com">DDR爱好者之家</a> <a href="http://m.ddrfans.com">http://m.ddrfans.com</a></p>
</footer>
<script src="/images3g/nav.js"></script>
<script type="text/javascript">
jQuery.noConflict();
jQuery(function() {
var elm = jQuery('#left_flow2');
var startPos = jQuery(elm).offset().top;
jQuery.event.add(window, "scroll", function() {
var p = jQuery(window).scrollTop();
jQuery(elm).css('position', ((p) > startPos) ? 'fixed' : '');
jQuery(elm).css('top', ((p) > startPos) ? '0' : '');
});
});
</script>
</body>
</html>