
加好友 发短信
等级:三尾狐
帖子:649
积分:5736
威望:0
精华:0
注册:2017/4/7 12:15:00
|
请教蓝老师关于滚动加载的排序问题,只能用[_Identify]排序吗? Post By:2022/1/6 10:11:00 [显示全部帖子]
如何改成按日期倒序呢?
- Dim wb As New weui
- Select Case e.Path
- Case "infinitescroll"
- wb.AppendHTML("<link rel='stylesheet' href='./weui/exweui.css'/>",True)
- wb.AppendHTML("<script src='./weui/exweui.js' ></script>",True)
- Dim drs As List(of DataRow) = DataTables("订单2").SQLSelect("",8,"[_Identify]")
- With ExWeUI.WebUI.AddExInfiniteScroll("pr01","testcallback",0,8)
- Dim wb2 As New weui
- With wb2.AddPanelGroup("","pg1","")
- For Each dr As DataRow In drs
- .Add("pn1" & dr("_Identify"), "日期: " & Format(dr("日期"),"yy年MM月dd日") & " 金额: " & dr("金额"),"产品: " & dr("产品") & ", 客户: " & dr("客户") & ", 雇员: " & dr("雇员"),"./images/button.png")
- Next
- End With
- .Content = wb2.BuildHtml("pg1")
- wb.InsertHTML(.BuildHtml)
- End With
- wb.AppendHTML("<script>initExWeUI();</script>")
- e.WriteString(wb.Build)
- Case "testcallback"
- Dim json As String = e.PlainText
- Dim jo2 As JObject = JObject.parse(json)
- Dim drs As List(of DataRow) = DataTables("订单2").SQLSelect("[_Identify] > " & jo2("max").ToString , 5 ,"[_Identify]")
- Dim jo As new JObject
- jo("page") = cint(jo2("page")) + 1
- jo("max") = cstr(drs(drs.Count - 1)("_Identify"))
-
- If drs.count < 5 Then
- jo("done") = True
- Else
- With wb.AddPanelGroup("","pg1" & jo("page").ToString,"")
- For Each dr As DataRow In drs
- .Add("pn1" & dr("_Identify"), "日期: " & Format(dr("日期"),"yy年MM月dd日") & " 金额: " & dr("金额"),"产品: " & dr("产品") & ", 客户: " & dr("客户") & ", 雇员: " & dr("雇员"),"./images/button.png")
- Next
- End With
- jo("html") = wb.BuildHtml("pg1" & jo("page").ToString)
- End If
- System.Threading.Thread.Sleep(500)
- e.WriteString(jo.ToString)
- End Select
|
|