var dg;
$(function() {
dg = $('#vehicle_datagrid').datagrid( {
title : '',
iconCls : 'icon-save',
pagination : true,
pageSize : 10,
pageList : [ 10, 20, 30, 40 ],
fit : true,
fitColumns : true,
nowrap : false,
border : false,
idField : 'id',
singleSelect : false,
iconCls : 'icon-save',
rownumbers : true,
url : '${pageContext.request.contextPath}/findVehicle.action?',
pagePosition : 'bottom',
toolbar : '#vehicle_toolbar',
loadMsg : '正在加载数据当中....',
frozenColumns : [ [ {
field : 'id',
title : '编号',
width : 100,
checkbox : true
}] ],
columns : [ [
{
field : 'UserName',
title : '姓名',
width : 100,
align : "center"
},{
field : 'IdCard',
title : '身份证号',
width : 150,
align : "center"
} , {
field : 'VehicleNumber',
title : '车号',
width : 100,
align : "center"
}, {
field : 'Phone',
title : '电话号码',
width : 150,
align : "center"
}, {
field : 'StartTime',
title : '开始时间',
width : 150,
align : "center"
}, {
field : 'EndTime',
title : '结束时间',
width : 150,
align : "center"
} ,{
field : 'Money',
title : '金额',
width : 150,
align : "center"
}] ],
toolbar : "#vehicle_toolbar"
});
});
//这是表格
//这是action
//获取列表
@Action(value = "findVehicle")
public void findVehicle() {
super.writeJson(vehicleRentServices.datagrid(vehicle));
}
//业务层
@Override
public DataGrid datagrid(VehicleRentModel vehicle) {
DataGrid j = new DataGrid();
j.setRows(this.changeModel(this.find(vehicle)));
j.setTotal(this.total(vehicle));
return j;
}
private List<VehicleRentModel> changeModel(List<VehicleRent> vehicleList) {
List<VehicleRentModel> vehicleRentModelList = new ArrayList<VehicleRentModel>();
if (vehicleList!= null && vehicleList.size() > 0) {
for (VehicleRent v : vehicleList) {
VehicleRentModel vr = new VehicleRentModel();
BeanUtils.copyProperties(v, vr); // 拷贝属性
vehicleRentModelList.add(vr);
}
}
return vehicleRentModelList;
}
private List<VehicleRent> find(VehicleRentModel vehicle) {
String hql = "from VehicleRent v where 1=1";
List<Object> values = new ArrayList<Object>();
// 查询条件
hql = addWhere(vehicle, hql, values);
// 是否排序 按照什么排序
if (vehicle.getSort() != null && vehicle.getOrder() != null) {
hql += " order by " + vehicle.getSort() + " " + vehicle.getOrder();
}
// 分页查询
return bd.find(hql, values, vehicle.getPage(),
vehicle.getRows());
}
private Long total(VehicleRentModel vehicle) {
String hql = "select count(*) from VehicleRent v where 1=1 ";
List<Object> values = new ArrayList<Object>();
hql = addWhere(vehicle, hql, values);
return bd.count(hql, values);
}