获取选中的数据:
var selected = $('#Tableid').bootstrapTable('getSelections');
选中全部:
$('#Tableid').bootstrapTable('checkAll');
取消全部:
$('#Tableid').bootstrapTable('uncheckAll');
如果想要把选中数据的某个字段,比如常用的是id传到后台,需要把它转成JSON格式以后,后台再用JSON转换成一个集合(这样做的原因是因为不用我们去拼接id,JSON会自动给我们转换成list集合,很方便):
前端数据传输:
var ids = new Array();
for (var i = 0; i < selected.length; i++){
ids[i] = selected[i].id;
}
$.ajax({
type: "POST",
dataType: "json",
url: url ,
data: {
"ids" : JSON.stringify(ids)
},
后台数据转换格式:
List<String> idList = JSONArray.parseArray(ids, String.class);
bootstraptable的checkbox选中或者取消时触发的函数(点击或取消会触发函数,要实现什么功能自己改变,我记录的是我写的一个功能):
//点击全选框时触发的操作
onCheckAll:function(){
var status = "checkall";
var selected = $('#Tableid').bootstrapTable('getSelections');
var ids = new Array();
for (var i = 0; i < selected.length; i++){
ids[i] = selected[i].sheetid;
}
queryRecord(ids,status);
},
//点击每一个单选框时触发的操作
onCheck:function(){
var status = "select";
var selected = $('#Tableid').bootstrapTable('getSelections');
var ids = new Array();
for (var i = 0; i < selected.length; i++){
ids[i] = selected[i].sheetid;
}
queryRecord(ids,status);
},
//取消每一个单选框时对应的操作;
onUncheck:function(){
var status = "cancel";
var selected = $('#Tableid').bootstrapTable('getSelections');
var ids = new Array();
for (var i = 0; i < selected.length; i++){
ids[i] = selected[i].sheetid;
}
queryRecord(ids,status);
},
//取消所有
onUncheckAll: function () {
var status = "cancelall";
var selected = $('#Tableid').bootstrapTable('getSelections');
var ids = new Array();
for (var i = 0; i < selected.length; i++){
ids[i] = selected[i].sheetid;
}
queryRecord(ids,status);
}
触发的函数:
function queryRecord(ids,status){
$(".runrecordTable tbody tr td").css("color","black");
var qyids = JSON.stringify(ids);
$.ajax({
url:url,
type:'POST', //GET
async:true, //或false,是否异步
dataType:'json', //返回的数据格式:json/xml/html/script/jsonp/text
data:{
"ids" : qyids
},
success:function(data){
debugger;
var allTableData = $('#Tableid').bootstrapTable('getData');
for(var i=0;i<allTableData.length;i++){
for(var j=0;j<data.length;j++){
if(allTableData[i].id == data[j].rzid){
if(status == "select"){
$(".runrecordTable tbody tr").eq(i).find('td').css("color","red");
}else if(status == "canacel"){
$(".runrecordTable tbody tr td").eq(i).find('td').css("color","black");
}
}
}
}
},
})
}
Ajax请求的url:
@RequestMapping(value = "/searchRunrecord")
@ResponseBody
public Object selectRunrecordByQYID(@RequestParam("ids") String ids) {
Wrapper<entity> ew = new EntityWrapper<>();
List<String> QYids = JSONArray.parseArray(ids, String.class);
ew.in("qyid",QYids);
List<entity> list = Service.selectList(ew);
return list;
}