今天在用easyui分页之后,前端追加了一行统计数据,导致了分页出错,解决方法很简单
- 出现的问题分别是 添加一行以后 会使前端数据的行数加一 导致在翻页的时候 出现错误
- 修改后如下结果 页面分页
- 分页下一行
- 上代码
- 解决方法就是在追加一行后将返回数据的总数减一
- onLoadSuccess 是 当数据加载成功时触发 所以将加载后的数据总数减一,就可以解决分页错误问题
//用户表格接收
$("#project_dg").datagrid({
url: '/ESEasyUi/projectController/queryProjectByPage',
remoteSort: false,
sortName: "projectPrice",
sortOrder: "desc",
method: "get",
fitColumns: true,
toolbar: '#tb',
striped: true,
pagination: true,
rownumbers: false,
singleSelect: true,
ctrlSelect: true,
pageSize: 10,
pageList: [3, 5, 10, 20],
// onAfterEdit: onAfterEdit,
queryParams: {
projectName: $("#projectNameBox").val(),
affiliatedUnit: $("#affiliatedUnitBox").val(),
projectId: $("#projectIdBox").val(),
buildNature: $("#buildNatureBox").val(),
projectTime: $("#projectTimeBox").val()
},
onLoadSuccess: function (data) {
var project = {
"affiliatedUnit": $("#affiliatedUnitBox").val(),
"projectId": $("#projectIdBox").val(),
"projectName": $("#projectNameBox").val(),
"buildNature": $("#buildNatureBox").val(),
"projectTime": $("#projectTimeBox").val()
};
$.ajax({
dataType: "json",
type: "POST",
contentType: "application/json",
data: JSON.stringify(project),
url: "/ESEasyUi/projectController/queryTotalSum",
success: function (data) {
console.log(data);
$("#project_dg").datagrid('insertRow', {
index: 0,
row: {
projectName: '汇总',
affiliatedUnit: "",
projectId: "",
buildNature: "",
projectPrice: data
}
});
},
});
data.total=data.total-1;
},
rowStyler: function (index, row) {
if (row.projectName == "汇总") {
return "background-color:Yellow;";//背景颜色
}
},
columns: [[
{field: 'projectName', title: '项目名称', width: "20%", align: "center"},
{field: 'affiliatedUnit', title: '所属单位', width: "20%", align: "center"},
{field: 'projectId', title: '项目编码', width: "20%", align: "center"},
{field: 'buildNature', title: '建设性质', width: "20%", align: "center"},
{
field: 'projectPrice', title: '总计划值', width: "20%", align: "center",
sortable: true,
formatter:function(v){
return parseFloat(v).toFixed(2)
}
}
]]
});
其中
将datagird的总行数减去1就好了
表头颜色修改
<style>
.datagrid-header-row td{background-color:#2DD8B0;color:#fff;text-align:center}
</style>