• ajax删除DB数据


    1.前台js

     1 $().ready(function () {
     2     
     3     $('[name="checkAll"]').click(function () {
     4         if ("checked" == $('input[name="checkAll"]').attr("checked")) {
     5             $('input[type="checkbox"]').attr("checked", "checked");
     6         } else {
     7             $('input[type="checkbox"]').removeAttr("checked");
     8         }
     9     });
    10 
    11     $('input[name="btnDelete"]').click(function () {
    12         var checkCount = 0;
    13 
    14         $('input[type="checkbox"]').not('input[name="checkAll"]').each(function (index, element) {
    15             if ("checked" == $(this).attr("checked")) {
    16                 checkCount++;
    17             }
    18         });
    19 
    20         if (checkCount <= 0) {
    21             alert("请选择您要删除的数据!");
    22             return false;
    23         }
    24 
    25         if (confirm("确定要删除吗?")) {
    26             var data = "[";
    27 
    28             $('input[type="checkbox"]').not('input[name="checkAll"]').each(function (index, element) {
    29                 if ("checked" == $(this).attr("checked")) {
    30                     data += "{id : " + $(this).val() + "} ,";
    31                 }
    32             });
    33 
    34             if (data != "[") {
    35                 data = data.substring(0, data.length - 1) + "]";
    36 
    37                 $.post("/User/DeleteById", data, function success(result) {
    38                     //1.ajax返回单个字符串内容
    39                     //var msg = " <font style='color:red'>" + result + "</font>";
    40                     //if ($('#ajaxMsg').html() == '') {
    41                     //    $('#ajaxMsg').append(msg);
    42                     //}
    43 
    44                     //2.ajax返回多个字符串内容
    45                     var msg = " <font style='color:red'>删除成功!</font>";
    46                     if ($('#ajaxMsg').html() == '') {
    47                         $('#ajaxMsg').append(msg);
    48                     }
    49 
    50                     $('input[name="checkAll"]').removeAttr("checked");
    51 
    52                     $('input[type="checkbox"]').not('input[name="checkAll"]').each(function (index, element) {
    53                         $(this).parent().parent().remove();
    54                     });
    55 
    56                     var ajaxResult = $.parseJSON(result);
    57                     $.each(ajaxResult, function (index, element) {
    58                         var tr = "<tr>"
    59                                   + "<td><input type='checkbox' value='" + element.ID + "' /></td>"
    60                                   + "<td><a href='/User/Detail/" + element.ID + "'>" + element.UserName + "</a></td>"
    61                                   + "<td>" + element.Phone + "</td>"
    62                                   + "<td>" + element.Email + "</td>"
    63                                   + "<td>" + element.Address + "</td>"
    64                                   + "<td>" + element.CreateTime + "</td>"
    65                                   + "<td>" + element.UpdateTime + "</td>"
    66                                   + "<td><a href='/User/Edit/" + element.ID + "'>修改</a></td>"
    67                                   + "<td><a href='/User/Delete/" + element.ID + "'>删除</a></td>"
    68                                   + "</tr>";
    69                         $('table').append(tr);
    70                     });
    71                 });
    72             }
    73         }
    74     });
    75 });
    View Code

    2.后台代码:

    [HttpPost]
            public ActionResult DeleteById()
            {
                String ajaxId = Request.Params[0];
    
                JavaScriptSerializer js = new JavaScriptSerializer();
                List<AjaxReq> ajaxReqList = js.Deserialize<List<AjaxReq>>(ajaxId);
                if (null != ajaxReqList && 0 < ajaxReqList.Count())
                {
                    foreach (AjaxReq ajaxReq in ajaxReqList)
                    {
                        UserDto user = new UserDto();
                        user.ID = ajaxReq.ID;
                        db.Entry<UserDto>(user).State = System.Data.EntityState.Deleted;
                        db.SaveChanges();
                    }
                }
    
                List<UserDto> userList = db.Users.ToList();
    
                //1.ajax返回单个字符串内容
                //return base.Json("删除成功!");
    
                //2.ajax返回多个字符串内容
                return base.Json(js.Serialize(userList));
                
            }
    View Code
  • 相关阅读:
    JDK6的switch支持不是很好
    团队作业(2)
    团队作业(1)
    4月30日
    重构:改善既有代码的设计有感
    4月28日
    4月27日
    4月26日
    4月25日
    4月24日
  • 原文地址:https://www.cnblogs.com/buguangchao/p/4236683.html
Copyright © 2020-2023  润新知