想要删除哪些数据直接选中,点击删除的按钮便好,如图
显示提示是否要删除选择的数据,点击确定
数据就删除了,如图
实现代码如下,在控制器这边写方法,把数据查询出来再执行删除
public ActionResult DeleteAgreementClassify(int AgreementClassifyID)
{
ReturnJson returnJson = new ReturnJson();
try
{ S_AgreementClassify dba = (from tbAgreement in myModel.S_AgreementClassify
where tbAgreement.AgreementClassifyID == AgreementClassifyID
selecttbAgreement).Single();
//执行删除
myModel.S_AgreementClassify.Remove(dba);
if(myModel.SaveChanges() > 0) { returnJson.State = true;
returnJson.Text = "删除成功!";
}
else{
returnJson.State = false;
returnJson.Text = "删除失败!";
}
}
catch (Exception e)
{
Console.WriteLine(e);
returnJson.State = false;
returnJson.Text = "数据异常!";
}
return Json(returnJson, JsonRequestBehavior.AllowGet);
}
再到试图写删除代码
//删除
$("#Deter").click(function () {
$.ajaxSettings.async = false;
var Return = 0;
//checkStatus 该方法可获取到表格所有选中行的相关数据
var checkStatus = layuiTable.checkStatus('tabAgreementClassify').data;
//var ckdata = checkStatus.data;//获取选取行的数据数组
if (checkStatus.length > 0) {
layer.confirm("是否需要删除选择的试题?", { icon: 6, offset:'100px;' }, function (index) {
layer.close(index);
if (!JudgingState()) {
for (var i = 0; i <checkStatus.length; i++) {
$.ajax({
url: "DeleteAgreementClassify?AgreementClassifyID=" +checkStatus[i].AgreementClassifyID,//所需要的列表接口地址(控制器的方法)
async: false,
type: 'get',
dataType: 'json',
success: function (data) {
if (data) {
Return++;
}
}
});
}
if (Return ==checkStatus.length) {
tabAgreementClassify = layuiTable.reload('tabAgreementClassify'); //刷新table
} else {
layer.alert("数据异常!");
}
} else {
layer.alert("选项中有已启用的项!故不能删除", { icon: 2, offset: '100px;' });
}
});
}
else {
layer.alert("请选择需要删除的数据!", { icon: 6, offset:'100px;' });
}
});
//JudgingState 判断选中数据的状态
function JudgingState() {
var bl = false;//未启用
var checkStatus = layuiTable.checkStatus('tabAgreementClassify');
var ckdata = checkStatus.data;
for (var i = 0; i < ckdata.length; i++) {
}
}