一、分页获取自定义表数据接口代码
var getRowCount = function(tableFlag,where){
var data = {};
var applications = this.applications;
var serviceRoot = "x_query_assemble_designer";
var path = "table/"+tableFlag+"/row/count/where/" + where;
var resp = applications.getQuery( serviceRoot, path );
var json = JSON.parse( resp.toString() );
return json.data.value;
}
var getRows = function(tableFlag,data){
var string = JSON.stringify(data);
var applications = this.applications;
var serviceRoot = "x_query_assemble_designer";
var path = "table/"+tableFlag+"/execute";
var resp = applications.postQuery( serviceRoot, path , string);
var json = JSON.parse( resp.toString() );
return json.data;
}
var tableFlag = "newTable";
var where = "1>0";
var requestTextObj = JSON.parse(requestText);
var page= requestTextObj.currentPage;
var size = requestTextObj.perPageRows;
var pageIndex = (page-1)*size;
if(requestTextObj.where != ''){
where = requestTextObj.where ;
where = where.replace(/\u0027/, "'");
// where = "o.name like '%机房%'";
//where = encodeURIComponent(where);
}
var data = {};
data["type"] = "select";
data["data"] = "select o from "+ tableFlag +" o where " + where;
data["maxResults"] = size+ "";
data["firstResult"] = pageIndex;
var rowsSie = getRowCount(tableFlag,encodeURIComponent(where));
print("rowsSie="+JSON.stringify(rowsSie));
var rows = getRows(tableFlag,data);
var totalPages = parseInt(rowsSie+"") / parseInt(requestTextObj.perPageRows+"");
totalPages = parseInt(totalPages)
if ( parseInt(rowsSie+"") % parseInt(requestTextObj.perPageRows+"") != 0) {
totalPages++;
}
var pageData = {};
pageData.totalPage=totalPages;
pageData.rows = rowsSie;
pageData.data = rows;
pageData.currentPage = requestTextObj.currentPage;
pageData.perPageRows = requestTextObj.perPageRows;
print(JSON.stringify(pageData));
JSON.stringify(pageData);
请求参数格式说明:
this.requestText={
"currentPage": 1, //当前页号
"perPageRows": "10", //第页数量
"where": "" //查询条件
}