站长资源网络编程
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="http://m.wwsws.com/show/1/160228.html" title="使用AJAX返回WebService里的集合具体实现">使用AJAX返回WebService里的集合具体实现</a></p>
<p>下一篇：<a href="http://m.wwsws.com/show/1/160230.html" title="AJAX和WebService实现邮箱验证(无刷新验证邮件地址是否合法)">AJAX和WebService实现邮箱验证(无刷新验证邮件地址是否合法)</a></p>
</div>
<div class="otherlink">
<h2>最新资源</h2>
<ul>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620773.html" one-link-mark="yes" title="群星《歌手2024 第3期》[FLAC/分轨][204.16MB]"><span>群星《歌手2024 第3期》[FLAC/分轨][204.16MB]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620772.html" one-link-mark="yes" title="群星《乘风2024 第6期》[320K/MP3][57.95MB]"><span>群星《乘风2024 第6期》[320K/MP3][57.95MB]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620771.html" one-link-mark="yes" title="群星《乘风2024 第6期》[FLAC/分轨][170.72MB]"><span>群星《乘风2024 第6期》[FLAC/分轨][170.72MB]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620770.html" one-link-mark="yes" title="陈立强1995-我爱你胜过这世界[福茂][WAV+CUE]"><span>陈立强1995-我爱你胜过这世界[福茂][WAV+CUE]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620769.html" one-link-mark="yes" title="群星-《2014年十大发烧唱片精选HQCD》[低速原抓WAV+CUE]"><span>群星-《2014年十大发烧唱片精选HQCD》[低速原抓</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620768.html" one-link-mark="yes" title="群星2013-青春缤纷辑压箱宝大公开3CD2[新加坡限量版][WAV整轨]"><span>群星2013-青春缤纷辑压箱宝大公开3CD2[新加坡限</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620767.html" one-link-mark="yes" title="林育群.2013-BalladShow（日本版）【环球】【WAV+CUE】"><span>林育群.2013-BalladShow（日本版）【环球】【WAV+</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620766.html" one-link-mark="yes" title="陈加洛.1992-痛到感觉不到【宝丽金】【WAV+CUE】"><span>陈加洛.1992-痛到感觉不到【宝丽金】【WAV+CUE】</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620765.html" one-link-mark="yes" title="群星.2023-宿命之敌电视剧原声带【韶愔音乐】【FLAC分轨】"><span>群星.2023-宿命之敌电视剧原声带【韶愔音乐】【</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/620764.html" one-link-mark="yes" title="東京事変-大発見[FLAC+CUE]"><span>東京事変-大発見[FLAC+CUE]</span></a>
</li>
</ul>
</div>
</div>
<div class="sidebar">
<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>
</article>
<footer>
<p>友情链接:<a href="http://www.imxmx.com/" title="杰晶网络" target="_blank">杰晶网络</a> <a href="http://www.ddrfans.com/" 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="/sitemap.xml">SiteMap</a></p>
<p>Design by <a href="http://m.wwsws.com">伏龙阁资源网</a> <a href="/">http://m.wwsws.com</a></p>
</footer>
<script src="/images/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>