MVC+EF简单增删改查

1 篇文章 0 订阅

1.创建实体

2、创建一个UserInfo的控制器 

 

 

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>

数据展示

 

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

 

<script>
        function del(id) {
            if (confirm("确定删除吗?")) {
                $.post("/UserInfo/Delete/" + id, null,
                    function success(data) {
                        if (data == "ok") {
                            alert("删除成功");
                            window.location.href = "/UserInfo/Index";
                        }
                        else {
                            alert("参数错误");
                        }
                    })
            }
        }
    </script>

 

  • 10
    点赞
  • 40
    收藏
    觉得还不错? 一键收藏
  • 5
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值