站长资源网络编程
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.paidiu.com/show/1/160228.html" title="使用AJAX返回WebService里的集合具体实现">使用AJAX返回WebService里的集合具体实现</a></p>
<p>下一篇：<a href="http://m.paidiu.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/619123.html" one-link-mark="yes" title="群星《奔赴！万人现场 第2期》[FLAC/分轨][518.87MB]"><span>群星《奔赴！万人现场 第2期》[FLAC/分轨][518.8</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619122.html" one-link-mark="yes" title="群星《奇妙浪一夏 (上海迪士尼度假区音乐)》[320K/MP3][43.91MB]"><span>群星《奇妙浪一夏 (上海迪士尼度假区音乐)》[32</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619121.html" one-link-mark="yes" title="群星《奇妙浪一夏 (上海迪士尼度假区音乐)》[FLAC/分轨][140.49MB]"><span>群星《奇妙浪一夏 (上海迪士尼度假区音乐)》[FL</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619120.html" one-link-mark="yes" title="【古典音乐】詹姆斯·高威《季节》1993[WAV+CUE]"><span>【古典音乐】詹姆斯·高威《季节》1993[WAV+CUE]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619119.html" one-link-mark="yes" title="贝拉芳蒂《卡里普索之王》SACD[WAV+CUE]"><span>贝拉芳蒂《卡里普索之王》SACD[WAV+CUE]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619118.html" one-link-mark="yes" title="小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE]"><span>小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE]</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619117.html" one-link-mark="yes" title="群星《欢迎来到我身边 电影原声专辑》[320K/MP3][105.02MB]"><span>群星《欢迎来到我身边 电影原声专辑》[320K/MP3</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619116.html" one-link-mark="yes" title="群星《欢迎来到我身边 电影原声专辑》[FLAC/分轨][480.9MB]"><span>群星《欢迎来到我身边 电影原声专辑》[FLAC/分轨</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619115.html" one-link-mark="yes" title="雷婷《梦里蓝天HQⅡ》 2023头版限量编号低速原抓[WAV+CUE][463M]"><span>雷婷《梦里蓝天HQⅡ》 2023头版限量编号低速原抓</span></a>
</li>
<li>
<i class="iconfont icon-point"></i>
<a class="text-sm" href="/show/1/619114.html" one-link-mark="yes" title="群星《2024好听新歌42》AI调整音效【WAV分轨】"><span>群星《2024好听新歌42》AI调整音效【WAV分轨】</span></a>
</li>
</ul>
</div>
</div>
<div class="sidebar">
</div>
</article>
<footer>
<p style="font-size: 14px;">友情链接:<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="/" 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></p>
<p>Design by <a href="http://m.paidiu.com">黑松山资源网</a> <a href="/">http://m.paidiu.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>