MVC+EF简单增删改查

柔情只为你懂 2022-05-17 20:16 140阅读 0赞

## **1.创建实体** ##

**![70][]**

## **2、创建一个UserInfo的控制器 ** ##

![70 1][]

![70 2][]

## **3、查询数据 ** ##

code

public IList<UserInfo> userInfoList { get; set; }
            DemoEntities demoEntities = new DemoEntities();//创建EF上下文
            public ActionResult Index()
            {
                userInfoList = demoEntities.Set<UserInfo>().ToList();
                ViewBag.userInfoList = userInfoList;
                return View();
            }

view

@{
        Layout = null;
    }
    @using MVCCRUDAPI.Models;
    <!DOCTYPE html>
    
    <html>
    <head>
        <meta name="viewport" content="width=device-width" />
        <title>Index</title>
    </head>
    <body>
        <table>
            <tr><td>用户名</td><td>密码</td><td>年龄</td><td>邮箱</td><td>备注</td><td>添加时间</td><td>操作</td></tr>
            @foreach (UserInfo userInfo in ViewBag.userInfoList)
            {
                <tr><td>@userInfo.UserName</td><td>@userInfo.UserPwd</td><td>@userInfo.Age<td>@userInfo.Email</td><td>@userInfo.Remark</td><td>@userInfo.RegTime</td><td><a href="/UserInfo/Edit/@userInfo.Id">编辑</a> <a href="javascript:void(0)" onclick="del(@userInfo.Id)">删除</a></td></tr>
            }
        </table>
    </body>
    </html>

数据展示

![70 3][]

## **3、添加数据 ** ##

code

public ActionResult Add()
            {
                return View();
            }
            [HttpPost]
            public ActionResult Add(UserInfo userInfo)
            {
                if (!ModelState.IsValid)
                {
                    return Content("error");
                }
                userInfo.RegTime = DateTime.Now;
                demoEntities.UserInfo.Add(userInfo);
                demoEntities.SaveChanges();
                return Content("ok");
            }

view

@{
        Layout = null;
    }
    @model MVCCRUDAPI.Models.UserInfo
    <!DOCTYPE html>
    
    <html>
    <head>
        <meta name="viewport" content="width=device-width" />
        <title>添加</title>
        <script src="~/Scripts/jquery-1.8.2.js"></script>
        <script src="~/Scripts/jquery.unobtrusive-ajax.min.js"></script>
        <script src="~/Scripts/jquery.validate.min.js"></script>
        <script src="~/Scripts/jquery.validate.unobtrusive.min.js"></script>
        <script>
            function success(data) {
                if (data == "ok") {
                    alert("添加成功");
                    window.location.href = "/UserInfo/Index";
                }
                else if (data == "error") {
                    alert("参数提交失败");
                }
            }
        </script>
    </head>
    <body>
        <div>
            @using (Ajax.BeginForm("add", "UserInfo", new AjaxOptions { HttpMethod = "post", OnSuccess = "success" }))
            {
                <div>
                    @Html.LabelFor(u => u.UserName)
                </div>
                <div>
                    @Html.TextBoxFor(u => u.UserName)
                    
                </div>
                <div>
                    @Html.LabelFor(u => u.UserPwd)
                </div>
                <div>
                    @Html.PasswordFor(u => u.UserPwd)
                    
                </div>
                <div>
                    @Html.LabelFor(u => u.Email)
                </div>
                <div>
                    @Html.TextBoxFor(u => u.Email)
                    
                </div>
                <div>
                    @Html.LabelFor(u => u.Age)
                </div>
                <div>
                    @Html.TextBoxFor(u => u.Age)
                    
                </div>
                <div>
                    @Html.LabelFor(u => u.Remark)
                </div>
                <div>
                    @Html.TextAreaFor(u => u.Remark)
                    
                </div>
                <br />
                <input type="submit" value="添加" />  <a href="/UserInfo/Index">返回</a>
            }
        </div>
    </body>
    </html>

## **4、更新数据 ** ##

code

UserInfo userInfo = new UserInfo();
    public ActionResult Edit(int id)
            {
                userInfo = demoEntities.Set<UserInfo>().Where(u => u.Id == id).FirstOrDefault();
                return View(userInfo);
            }
            [HttpPost]
            public ActionResult Edit(UserInfo userInfo)
            {
                if (!ModelState.IsValid)
                {
                    return Content("error");
                }
                demoEntities.UserInfo.Attach(userInfo);//对象添加到EF管理容器中
                demoEntities.Entry(userInfo).State = EntityState.Modified;
                demoEntities.SaveChanges();
                return Content("ok");
            }

view

@model MVCCRUDAPI.Models.UserInfo
    
    @{
        Layout = null;
    }
    
    <!DOCTYPE html>
    
    <html>
    <head>
        <meta name="viewport" content="width=device-width" />
        <title>编辑</title>
    </head>
    <body>
        <script src="~/Scripts/jquery-1.8.2.js"></script>
        <script src="~/Scripts/jquery.unobtrusive-ajax.min.js"></script>
        <script src="~/Scripts/jquery.validate.min.js"></script>
        <script src="~/Scripts/jquery.validate.unobtrusive.min.js"></script>
        <script>
            function success(data) {
                if (data == "ok") {
                    alert("编辑成功");
                    window.location.href = "/UserInfo/Index";
                }
                else if (data == "error") {
                    alert("参数提交失败");
                }
            }
        </script>
        @using (Ajax.BeginForm("Edit", "UserInfo", new AjaxOptions { OnSuccess = "success", HttpMethod = "post" }))
        {
            @Html.HiddenFor(model => model.Id)
    
            <div>
                @Html.LabelFor(model => model.UserName)
            </div>
            <div>
                @Html.EditorFor(model => model.UserName)
                
            </div>
            <div>
                @Html.LabelFor(model => model.UserPwd)
            </div>
            <div>
                @Html.EditorFor(model => model.UserPwd)
                
            </div>
            <div>
                @Html.LabelFor(model => model.Age)
            </div>
            <div>
                @Html.EditorFor(model => model.Age)
               
            </div>
            <div>
                @Html.LabelFor(model => model.Email)
            </div>
            <div>
                @Html.EditorFor(model => model.Email)
                
            </div>
            <div>
                @Html.LabelFor(model => model.Remark)
            </div>
            <div>
                @Html.TextAreaFor(u => u.Remark)
                
            </div>
            @Html.HiddenFor(model => model.RegTime)
            <p>
                <input type="submit" value="保存" /> <a href="/UserInfo/Index">返回</a>
            </p>
        }
    </body>
    </html>

## **5、删除数据 ** ##

code

public ActionResult Delete(int id)
            {
                userInfo.Id = id;
                demoEntities.UserInfo.Attach(userInfo);//对象添加到EF管理容器中
                demoEntities.Entry(userInfo).State = EntityState.Deleted;
                demoEntities.SaveChanges();
                return Content("ok");
            }

view

[70]: /images/20220518/75ddd8064f434f3dbabe00ce46f736eb.png
[70 1]: /images/20220518/982d45f4bf32449aa907e4339acc54bf.png
[70 2]: /images/20220518/ae5d805f2c9048e282e9ff0b665b1fa3.png
[70 3]: /images/20220518/b93318d3590b4726b0623cdf81e1dd78.png