Entityframework批量删除

UI层

<a href="#" onclick="DelData(0);return false;" id="a_del" class="easyui-linkbutton" iconcls="icon-cancel">删除</a>   

UI中js：

 //删除按钮事件
         function DelData(id) {
             $.messager.confirm('提示', '确认删除？', function (r) {
                 if (r) {
                     var selected = "";
                     if (id <= 0) {
                         $($('#tab_list').datagrid('getSelections')).each(function () {
                             selected += this.ID + ",";
                         });
                         selected = selected.substr(0, selected.length - 1);
                         if (selected == "") {
                             $.messager.alert('提示', '请选择要删除的数据！', 'info');
                             return;
                         }
                     }
                     else {
                         selected = id;
                     }
                     $.post('/DataGrid/GetJson', { "action": "del", "cbx_select": selected }, function (data) {
                         $.messager.alert('提示', data, 'info', function () { $("#tab_list").datagrid("reload"); });
                     });
                 }
             });
         }

MVC中控制器：

1.action：

 [HttpPost]
        public ActionResult GetJson()
        {
            UserManagerServiceClient client = new UserManagerServiceClient();

            string action = string.Empty;
            if (Request.Form["action"] != "")
            {
                action = Request.Form["action"].ToString();
            }
            switch (action)
            {
                case "query":                                                     //第一次进入页面时查询数据
                    string JsonString = QueryEmployee(client);
                    return Content(JsonString.ToString());
                case "submit":
                    string UpdateMsg = UpdateEmployInfo(client);
                    return Content(UpdateMsg);
                case "queryone":
                    string JsonOneEmployee = QueryOneEmployee(client);
                    return Content(JsonOneEmployee);    
                case "del" :
                    string DelMsg = DelEmployees(client);
                    return Content(DelMsg);  
                default:
                    return Content("");
            }

 

2.DelEmployees（）方法：

  /// <summary>
        /// 删除员工信息
        /// </summary>
        /// <param name="client"></param>
        /// <returns></returns>
        private string DelEmployees(UserManagerServiceClient client)
        {
            string msg = "删除失败！";
            string selectedID = Request.Form["cbx_select"] != "" ? Request.Form["cbx_select"] : "";
            if (selectedID != "" && selectedID !="0")
            {
                int delCount = client.DelEmployee(selectedID); // 从服务端返回的删除员工信息的个数
                if (delCount > 0)
                {
                    msg = string.Format("本次共删除了{0}条员工信息！", delCount);
                }
            }

            return msg;
        }

WCF服务端代码：EF中contains就 好似sql中的in

 /// <summary>
        /// 删除员工信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int DelEmployee(string id)
        {
            int msg = 0;
            try
            {
                List<string> strID = id.Split(',').ToList();
                List<int> arrayID = strID.ConvertAll(e => int.Parse(e)); 
                using (UserManageDB db = new UserManageDB())
                {

                    using (TransactionScope transaction =new TransactionScope()  )
                    {
                        foreach (var employee in db.EmployeInfo.Where(e => arrayID.Contains(e.ID)))
                        {
                            db.EmployeInfo.Remove(employee);
                            msg++;
                        }                      
                        db.SaveChanges();
                        transaction.Complete();
                    }
                   
                   
                }

                return msg;
            }
            catch (Exception ex)
            {                
                throw ex;
            }
        }