在数据中的我们有些数据用不到了,通常会把其删除,以免占据存储空间,那么就可以是批量或者单条的删除数据。
//单条删除
function delectclient(ClientID) {
layer.confirm("您确定要删除选择的客户?", { icon: 6 }, function (index) {
$.post("DelectClient", { ClientID: ClientID }, function (returnJson) {
if (returnJson.State == true) {
layer.close(index);
selctvfdpm();//刷新数据
layer.msg("删除客户成功。", { icon: 1 })
}
else {
layer.msg(returnJson.Text);
}
});
});
}
//批量删除
function batchOperateB() {
var Return = 0;//返回成功的数据
var checkStatus = layuiTable.checkStatus('SalestabTitles');//获取数据表格的数据
var ckdate = checkStatus.data;//获取选中行数据
if (ckdate.length > 0) {
if (ClientStateA() == false) {//判断数据状态
layer.confirm("您确定要删除选择的客户?", { icon: 6 }, function (index) {
layer.close(index);
for (var i = 0; i < ckdate.length; i++) {
$.ajax({
url: "DelectClientone?ClientID=" + ckdate[i].ClientID,
async: false,
type: 'get',//数据传输通道的类型
dataType: 'json',//传输的数据类型
success: function (data) {
if (data) {
Return++;
}
}
});
}
if (Return == ckdate.length) {
selctvfdpm();//刷新数据
layer.msg("删除客户成功。", { icon: 1 })
}
else {
layer.alert("删除客户失败!", { icon: 3 });
}
})
}
else {
layer.alert("已启用的客户不能删除,请先停用客户");
}
}
else {
layer.alert("请选择要删除的客户");
}
}
//判断客户启用的还是作废状态
function ClientStateA() {
var False = false;
var ClientSatate = layuiTable.checkStatus('SalestabTitles');//获取数据表格
var CkDate = ClientSatate.data;//checkStatus 获取行数据
for (var i = 0; i < CkDate.length; i++) {
if (CkDate[i].State) {
False = true;
break;
}
}
return False;
}
至于控制器那边 肯定也的写删除的方法,根据页面传输的ID的去查找对应额的数据已于删除,如果是多表的,也要对其进行删除。
例如:
public ActionResult DelectClientone(int ClientID)
{
try
{
var ClientDate = (from tbClient in myModels.S_Client
where tbClient.ClientID == ClientID
select tbClient).Single();
var Collection = (from tbCollection in myModels.B_Collection
where tbCollection.CollectionID == ClientDate.CollectionID
select tbCollection).Single();
var Lnitialreceipt = (from tbLnitialreceipt in myModels.B_Lnitialreceipt
where tbLnitialreceipt.LnitialreceiptID ==
ClientDate.LnitialreceiptID
select tbLnitialreceipt).Single();
myModels.B_Collection.Remove(Collection);
myModels.B_Lnitialreceipt.Remove(Lnitialreceipt);
myModels.S_Client.Remove(ClientDate);
myModels.SaveChanges();
return Json(true, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
return Json(false, JsonRequestBehavior.AllowGet);
}
}