MVC+EF实现增删查改

最新推荐文章于 2021-05-16 16:37:21 发布

weixin_30932215

最新推荐文章于 2021-05-16 16:37:21 发布

阅读量129

点赞数

原文链接：http://www.cnblogs.com/niyingying/p/5292238.html

版权

一、Index主页(查询)

HomeController

MVCDemoEntities entity = new MVCDemoEntities();

public ActionResult Index()
{
var u = entity.Users.ToList(); ToList()是必备的，养成好这个习惯
return View(u);
}

Index.cshtml

@model IEnumerable<MVCDemo.Models.User>

@{
Layout = null;
}

<!DOCTYPE html>

<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
</head>
<body>
<div>
@Html.ActionLink("新增", "Add")
<table>
<tr>
<th>Id</th>
<th>UserName</th>
<th>Age</th>
<th>Edit</th>
<th>Delete</th>
</tr>
@foreach (var u in Model)
{

<tr>
<td>@u.Id</td>
<td>@u.UserName</td>
<td>@u.Age</td>
<td>@Html.ActionLink("编辑", "Edit", new { id=u.Id})</td>
<td>@Html.ActionLink("删除", "Delete", new { id=u.Id})</td> Id作为参数传递，便于删除和修改时候的查询
</tr>
}

</table>
</div>
</body>
</html>

二、新增

HomeController

public ActionResult Add()
{

return View();
}
[HttpPost]
public ActionResult Add(User u)
{
User u1 = new User();
u1.UserName=Request["UserName"]; 从cshtml页面中获取值
u1.Age = Convert.ToInt32(Request["Age"]);
entity.Users.Add(u1);
entity.SaveChanges();

return RedirectToAction("Index");
}

Add.CShtml(使用的是模板)

@using (Html.BeginForm()) {
@Html.ValidationSummary(true)

<fieldset>
<legend>User</legend>

<div class="editor-label">
@Html.LabelFor(model => model.UserName)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.UserName)
@Html.ValidationMessageFor(model => model.UserName)
</div>

<div class="editor-label">
@Html.LabelFor(model => model.Age)
</div>
<div class="editor-field">
@Html.EditorFor(model => model.Age)
@Html.ValidationMessageFor(model => model.Age)
</div>

<p>
<input type="submit" value="Create" />
</p>
</fieldset>
}

三、修改

HomeController

[HttpGet]
public ActionResult Edit(int id)
{
//根据id查找对应的数据然后展示
User user = entity.Users.FirstOrDefault(u => u.Id == id);

return View(user);
}
[HttpPost]
public ActionResult Edit()
{
int id =Convert.ToInt32( Request["userId"]);
User user = entity.Users.FirstOrDefault(u => u.Id == id);
user.UserName = Request["UserName"];
user.Age = Convert.ToInt32(Request["Age"]);
entity.SaveChanges();
return RedirectToAction("Index");
}

Edit.cshtml

<div>
@using (Html.BeginForm())
{
<table>
<tr>
<td>
@Html.LabelFor(model => model.UserName)
</td>
<td>
@Html.TextBox("UserName",Model.UserName)
</td>
</tr>
<tr>
<td>
@Html.LabelFor(model => model.Age)
</td>
<td>
@Html.TextBox("Age",Model.Age)
</td>
</tr>
<input type="hidden" name="userId" value="@Model.Id" />用隐藏的标签来存储Id
<input type="submit" name="name" value="提交" />
</table>
}

四、删除

HomeController

public ActionResult Delete(int id)
{
User user = entity.Users.FirstOrDefault(u => u.Id == id);
entity.Users.Remove(user);
entity.SaveChanges();
return RedirectToAction("Index");
}

转载于:https://www.cnblogs.com/niyingying/p/5292238.html

weixin_30932215

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
MVC+EF实现增删查改

一、Index主页(查询)HomeControllerMVCDemoEntities entity = new MVCDemoEntities(); public ActionResult Index() { var u = entity.Users.ToList(); ToList()是必备的，养成好这个习惯 ...
复制链接

扫一扫