单表的数据删除

开发工具与关键技术：VS MVC.NET

作者：周乐献

撰写时间：2020年8月18日

点击删除按钮,询问确定要删除点击行的信息吗,如果确认就获取到点击行的学院ID,通过获取到学院ID的信息传递到控制器,如果点击取消则不再删除

 

通过页面传递过来的学院ID来查询该学院是否还有专业的数据,如果有则提示不能删除,否则直接删除

public ActionResult deleteFacultyInfo(int facultyID)

        {

            ReturnJson msg = new ReturnJson();

            int dbSpecialtyCount = (from tbSpecialty in myModel.S_Specialty

                                             where tbSpecialty.facultyID == facultyID

                                             select tbSpecialty).Count();

            if (dbSpecialtyCount == 0)

            {

                try

                {

                    S_Academy dbAcademy = (from tbAcademy in myModel.S_Academy

                                           where tbAcademy.facultyID == facultyID

                                           select tbAcademy).Single();

                    myModel.S_Academy.Remove(dbAcademy);

                    if (myModel.SaveChanges() > 0)

                    {

                        msg.State = true;

                        msg.Text = "删除成功!";

                    }

                    else

                    {

                        msg.Text = "删除失败";

                    }

                }

                catch (Exception e)

                {

                    Console.WriteLine(e);

                    msg.Text = "数据异常";

                }

            }

            else

            {

                msg.Text = "该学院还有专业存在,不能直接删除!";

            }

          

            return Json(msg, JsonRequestBehavior.AllowGet);

        }