var pages = 1;
var limit = 10;
var loading = false;
$('.weui-loadmore').hide();
$(function () {
load();
})

$("#listwrap").pullToRefresh().on("pull-to-refresh", function () {//zfl
setTimeout(function () {
pages = 1;
$("#body_list").html("");
load();
if (loading) loading = false;
$("#listwrap").pullToRefreshDone(); // 重置下拉刷新 zfl
}, 1500); //模拟延迟
});

$("#listwrap").infinite(50).on("infinite", function () {
 if (loading) return;
loading = true;
 pages++; //页数
 $('.weui-loadmore').show();
setTimeout(function () {
 load();
 loading = false;
 }, 2500);//zfl
 //模拟延迟
});

滚动加载有事不响应,并非是document.body的问题,需要看页面布局,看绑定的body的滚动条是否显示

 

SELECT tableB.*
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY ID DESC) AS rownumber, *
FROM (
SELECT ta.*,tqt.QuestionClassify FROM yc.table AS ta

) tableB
) tableB
WHERE rownumber > @Limit * (@Page - 1)
AND rownumber <= @Limit * @Page