Html代码

1
2
3
4
首先在前台页面引用jquery：
<script src="../js/jquery.min.js"></script>
需要放入的html
<div id="m_list"></div>

ajax代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<script>
    $(function () {
        let pageIndex = 1;//当前页面
        let pagetotal = $(".dataNums").text(); //数据总数
        let totalPage = Math.ceil(pagetotal / 10); //总页数，一页10条

        function init(pageIndex, pageSize) {
            $.ajax({
                type: "get",
                url: "../submit_ajax.ashx?action=getList&page_index=" + pageIndex + "&page_size=" + pageSize,
                datatype: "json",
                timeout: 8000,
                success: function (data, textstatus) {
                    var jsonData = JSON.parse(data);

                    var str = "";
                    for (var i = 0; i < jsonData.length; i++) {
                        str += "<div class=\"vmd\">";
                        str += "<span class=\"video_id\">" + jsonData[i]["id"] + "</span>";
                        str += "<div class=\"vmd_title\">";
                        str += "<h3><a href=\"m_curriculum_details/show-" + jsonData[i]["id"] + ".html\" class=\"vmd_title_a\">" + jsonData[i]["title"] + "</a></h3>";
                        str += "<div class=\"vmd_icon\">";
                        str += "<label><i class=\"fa fa-book\"></i>" + jsonData[i]["nums"] + "</label>";
                        str += "<label><i class=\"fa fa-eye\"></i>" + jsonData[i]["click"] + "</label>";
                        str += "</div>";
                        str += "</div>";
                        str += "</div>";
                    }
                    $("#m_list").append(str);
                }
            });
        }

        //页面初始加载调用
        init(pageIndex, 10);

        //当滚动到屏幕最下面触发
        $(window).scroll(function () {
            var windowScrollY = window.scrollY;            // 当前滚动条top值
            var windowInnerH = window.innerHeight;         // 设备窗口的高度
            var bodyScrollH = document.body.scrollHeight;  // body总高度
            if (windowScrollY + windowInnerH == bodyScrollH) {
                //页数+1
                pageIndex++;
                //如果当前页数大于总页数
                if (pageIndex > totalPage) {
                    console.log("加载完成");
                }
                else {
                    init(pageIndex, 10);
                }
            }
        });

    });
</script>

submit_ajax.ashx添加getList

1
2
3
4
5
6
7
8
9
public void getList(HttpContext context)
{
	int page_size = DTRequest.GetQueryInt("page_size");
	int page_index = DTRequest.GetQueryInt("page_index");
           
 	  DataTable dt = new BLL.course().GetList(page_index, page_size);
 	  string json = SerializationHelper.ToJsonString(dt);
 	  context.Response.Write(json);
}

bll层代码

1
2
3
4
public DataTable GetList(int category_id, int page_index, int page_size)
{
	return dal.GetList(category_id, page_index, page_size);
}

dal层代码

1
2
3
4
5
6
public DataTable GetList(int category_id, int page_index, int page_size)
{
	string sql = "";
   	sql = string.Format("select * from 表名 order by id offset(({1} - 1) * {2}) rows  fetch next {2} rows only", page_index, page_size);
   	return DbHelperSQL.Query(sql).Tables[0];
}

补充

ashx引用到SerializationHelper.ToJsonString()方法，如下：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
using Newtonsoft.Json;

	public class SerializationHelper
    {
		public static string ToJsonString(object obj)
        {
            return ToJsonString<object>(obj);
        }

        public static string ToJsonString<T>(T obj) where T : class
        {
            string text = JsonConvert.SerializeObject(obj);
            return text;
        }
	}