分享HTMLayout 分页代码

wznjsy · 发表于 2013-1-2 22:23:10

功能列表：
搜索功能
首页按钮
最后一页
上一页
下一页

import win.ui;
/*DSG{{*/
var winform = ..win.form( bottom=399;parent=...;text="aardio Form";right=599 )
winform.add( )
/*}}*/
import sqlite.aes128;
var sqlConn = sqlite.aes128("/database.db",key)
if( not sqlConn.existsTable("black") ){
sqlConn.exec("create table black(name, address integer default 0);")
sqlConn.beginTrans();
for(i=101;200;1){
sqlConn.exec("insert into black(address) values('"+ i + "');")
}
sqlConn.commitTrans();
}
import web.layout;
import web.layout.behavior.tabs;
var wbLayout = web.layout(winform);
import web.layout.debug; //导入该库以显示HTMLayout错误
wbLayout.attachEventHandler( web.layout.debug ); //为CSSS!添加全局函数 debug;
wbLayout.html = /*********
<html>
<head>
<style>
html { background-color: #fff #e9e8f3 #e9e8f3 #fff; }
table
{
background:white;
border:1px solid #bdbccc;
width:100%%;
height:100%%;
behavior:grid column-resizer;
overflow:auto;
flow: table-fixed;
font-family:"Verdana";
font-size:9pt;
border-spacing:0;
}
table th
{
color: white;
font-family:"Century Gothic","Verdana";
font-size:14pt;
border-right:1px solid silver;
border-bottom:1px solid silver;
padding:4px;
background-color:#AAA;
}
table th:hover
{
color: #ffe598;
}
table tr { height:1.6em; }
table tr:current /* current row */
{
background-color:#bdbccc;
color:white;
}
table tr:nth-child(odd)
{
background-color: azure;
}
table td
{
padding:2px;
border-right:1px solid silver;
border-bottom:1px solid silver;
}
table td:nth-child(1) { font-weight:bold; text-align:center; } /* first column */
table td:nth-child(3) /* last column */
{
text-align:left;
overflow:hidden; /* three line below - ellipsis */
text-overflow:ellipsis;
white-space:nowrap;
}
table td:hover
{
color:red;
}
#statusbar{
padding-top:10px;
}
</style>
</head>
<body>
<p>数据列表</p>
<p><input type="text" id="filter" value=""><input type="button" id="Search" value="搜索"></p>
<table width=100% fixedrows=1 id="test">
<tr><th width=40%>地址</th><th width=20%>AA</th><th width=20%>BB</th><th width=20%>CC</th></tr>
</table>
<input type="button" id="FirstPage" value="首页">
<input type="button" id="PreviousPage" value="上一页">
<input type="button" id="NextPage" value="下一页">
<input type="button" id="LastPage" value="最后一页">
<div id="statusbar">总数量：<span id="count">0</span><span style="padding-left:20px;">当前页：</span><span id="CurrentPage">1</span><span style="padding-left:20px;">共：</span><span id="NumTotalPage">0</span>页</div>
</body>
</html>
*********/
replaceNull = function(str){
if(!str){
return "";
}else {
return str;
}
}
replaceSending = function(sending){
if(sending='N'){
return "NoSending";
}else {
return "";
}
}
var filter=""
var numTotal = 0;
var CurrentPage = 1;
var NumTotalPage =0;
Address = sqlConn.getTable("SELECT COUNT(*) FROM black" )
numTotal = Address[1]["COUNT(*)"];
wbLayout.getEle("count").innerText = numTotal;
//
Listing = function(Filter,Page){
ItemPerNum = 10;
wbLayout.getEle("CurrentPage").innerText = CurrentPage;
strCondition ="";
strSQL = "select address, name from black ";
if(string.len(filter)>0){
strCondition = "WHERE address LIKE'%" + Filter + "%' ";
}
Offset = (CurrentPage-1) * ItemPerNum;
strSQL = strSQL + strCondition + "ORDER BY address LIMIT " + ItemPerNum +" OFFSET "+Offset;
var eles = wbLayout.queryEles("tr[data='row']");
for(i,ele in eles){
ele.delete();
};
var sqlConn = sqlite.aes128("/database.db",key)
Address = sqlConn.getTable("SELECT COUNT(*) FROM black " + strCondition)
numTotal = Address[1]["COUNT(*)"]
wbLayout.getEle("count").innerText = numTotal;
NumTotalPage = math.ceil(numTotal/ItemPerNum); //获得总页数
wbLayout.getEle("NumTotalPage").innerText = NumTotalPage;
for address,time_created,time_sent,sending in sqlConn.each(strSQL ) {
wbLayout.getEle("test").insertAdjacentHTML("beforeEnd","<tr data='row' class='" + replaceSending(sending)+"'>"+
"<td>"+replaceNull(address)+"</td>"+
"<td>"+replaceNull(time_created)+"</td>"+
"<td>"+replaceNull(time_sent)+"</td>"+
"<td>"+replaceNull(sending)+"</td>"+
"</tr>");
}
sqlConn.close();
}
Listing("");
wbLayout.onButtonClick = {
FirstPage = function (layoutEle,reason,behaviorParams) {
filter = string.trim(wbLayout.getEle("filter").value);
CurrentPage = 1;
Listing(filter);
}
LastPage = function (layoutEle,reason,behaviorParams) {
filter = string.trim(wbLayout.getEle("filter").value);
CurrentPage = NumTotalPage;
Listing(filter);
}
PreviousPage = function (layoutEle,reason,behaviorParams) {
filter = string.trim(wbLayout.getEle("filter").value);
CurrentPage =CurrentPage-1;
if(CurrentPage<1){
CurrentPage = 1; // 如果当前页<1
}
Listing(filter);
}
NextPage = function (layoutEle,reason,behaviorParams) {
filter = string.trim(wbLayout.getEle("filter").value);
CurrentPage = CurrentPage+1;
if(CurrentPage>NumTotalPage){
CurrentPage = NumTotalPage;
}
Listing(filter);
}
Search = function (layoutEle,reason,behaviorParams) {
filter = string.trim(wbLayout.getEle("filter").value);
CurrentPage = 1;
Listing(filter);
}
}
sqlConn.close();
winform.show();
win.loopMessage();
return winform,wbLayout;

复制代码

万事发↑新一天 · 发表于 2013-1-3 11:30:58

正用到, 多谢分享

jyb21 · 发表于 2013-1-3 14:17:45

这个得顶挺酷的

万事发↑新一天 · 发表于 2013-1-3 15:42:21

双击编辑,怎样编写事件,刚接确HTMLayout,好多看不明,先谢!

csdn321 · 发表于 2013-3-6 23:13:04

需要，收藏下！

cn_xc_wyj · 发表于 2013-3-8 18:26:21

感谢分享

cnhope · 发表于 2013-10-26 13:43:01

这个太厉害了，学习

zjutsxj · 发表于 2013-11-9 23:26:33

这个需要的先收藏一下。

Q74484 · 发表于 2013-12-8 19:48:29

谢谢分享

tansuozhexigua · 发表于 2015-7-25 15:49:37

这两天正找这个呢不胜感激

sandorn · 发表于 2016-5-19 13:17:22

在aardio 10里面，需要做一些修改，
将wbLayout.getEle("count").innerText = numTotal;类似的语句修改成
wbLayout.getEle("count").innerText = tostring(numTotal);

lvhoo · 发表于 2016-5-21 19:40:57

运行出错，提示库文件错误：
文件:[string "import win.ui;..."]
错误行号:#161
错误行号:#121
文件:D:\aardio\lib\web\layout\element\_.aardio:
不支持此操作:get length of
定义类型:variable(local)
名字:'v'
类型:number
---------------------------------------------------
调用栈:
[kernel]: in function 'error'
D:\aardio\lib\util\metaProperty.aardio:37: in function <D:\aardio\lib\util\metaProperty.aardio:32>
[string "import win.ui;..."]:161: in main chunk
打开提示的文件，找到121行是红色字体这个代码
innerText = {
_set = function (v) {
SetElementInnerText(owner[["handle"]], v, #v);
}

用户名		自动登录	找回密码
密码			注册会员

分享HTMLayout 分页代码

评分