一、显示界面
、Models(模板)
private MyDBDataContext _context = new MyDBDataContext();
public List<Info> Select() //查询
{
return _context.Info.ToList();
}
、Contrallers(控制器)
public ActionResult Index()
{
//在这里没用ViewBag
List<Info> list = new InfoBF().Select();
return View(list); //强制类型
}
、Views(视图)
@using MVC__数据库增删改查_Razor__Html语法.Models;
@*声明一下强制数据的类型↓*@
@model List<Info>
@{
Layout = null;
} <!DOCTYPE html> <html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
<style>
.trhead
{
background-color:#b200ff }
.trrow
{
background-color:#FFFFcc
}
</style>
</head>
<body>
<div>
@using(Html.BeginForm("Add","Home",FormMethod.Post)) 表单
{
<input id="Submit1" type="submit" value="增加" />
}
<table width="100%" cellpadding="" cellspacing="" border="">
<tr class="trhead">
<td>学号</td>
<td>姓名</td>
<td>操作</td> </tr>
@{
foreach (Info data in Model) //定义的强制类型，Model为List<Info>类型的
{
<tr class="trrow"> <td>@data.code</td>
<td>@data.name</td> //超链接↓
<td>@Html.ActionLink("详细", "Details", "Home",new {id=data.code}, new { }) @Html.ActionLink("删除", "Delete", "Home",new {id=data.code}, new { }) @Html.ActionLink("修改", "Edit", "Home",new {id=data.code}, new { }) </td>
</tr>
} }
</table>
</div>
</body>
</html>
效果图：
二、详细信息
、Models(模板)
public Info Select(string code)//详细查询
{
var query = _context.Info.Where(P=>P.code==code);
if (query.Count() > )
{
return query.First();
}
else
{
return null;
}
}
、Controllers(控制器)
public ActionResult Details(string id) //详细查询
{
Info data=new InfoBF().Select(id);//还是强类型
return View(data);
}
、Views(视图)
@using MVC__数据库增删改查_Razor__Html语法.Models;
@model Info
@{
Layout = null;
} <!DOCTYPE html> <html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Details</title>
<style>
.trhead
{
background-color:#b200ff }
.trrow
{
background-color:#FFFFcc
}
</style>
</head>
<body>
<div>
<table width="100%" cellpadding="" cellspacing="" border="">
<tr class="trhead">
<td>学号</td>
<td>@Model.code</td>
</tr>
<tr class="trrow">
<td>姓名</td>
<td>@Model.name</td>
</tr>
<tr class="trrow">
<td>性别</td>
<td>@Model.sex</td>
</tr>
<tr class="trrow">
<td>生日</td>
<td>@Model.birthday</td>
</tr>
<tr class="trrow">
<td>班级</td>
<td>@Model.banji</td>
</tr>
</table>
</div>
</body>
</html>
效果图：
三、增加
、Models(模板)
public void Insert(string code,string name,string sex,string birthday,string banji) //增加
{
Info data = new Info();
data.code = code;
data.name = name;
data.sex = sex;
data.birthday = birthday;
data.banji = banji;
_context.Info.InsertOnSubmit(data);
_context.SubmitChanges();
}
、Controllers(控制器)
public ActionResult Add() //增加页面
{
Info data = new Info(); //造一个对象用来存储数据
data.sex = "男";//默认选中性别 “男”
List<banji> b = new banjiBF().Selcet(); //下拉列表
ViewBag.bb = new SelectList(b,"banji1","banji1"); //banji1是表里的名字
return View(data);//把这个对象送到视图里面去
}
public ActionResult Insert(string code,string name,string sex,string birthday,string banji)//增加按钮
{
new InfoBF().Insert(code,name,sex,birthday,banji);
return RedirectToAction("Index");
}
、Views(视图)
@using MVC__数据库增删改查_Razor__Html语法.Models;
@model Info
@{
Layout = null;
} <!DOCTYPE html> <html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Add</title>
</head>
<body>
<div>
@using (Html.BeginForm("Insert", "Home", FormMethod.Post))
{
SelectList xx=ViewBag.bb;
<div>
@* 将数据送到Insert*@ 学号: @Html.TextBoxFor(P => P.code, new { maxlength=5})<br>
姓名: @Html.TextBoxFor(P=>P.name)<br>
性别: @Html.RadioButtonFor(P => P.sex, "男")男 @Html.RadioButtonFor(P=>P.sex,"女")女<br>
生日: @Html.TextBoxFor(P=>P.birthday)<br>
班级: @Html.DropDownListFor(P=>P.banji,xx)<br> <input id="Submit1" type="submit" value="增加" />
</div>
}
</div>
</body>
</html>
效果图：
→
四、修改
、Models(模板)
public void Update(string code,string name,string sex,string birthday,string banji)
{
var query = _context.Info.Where(p => p.code == code);
if(query.Count()>)
{
Info x = query.First();
x.code = code;
x.name = name;
x.sex = sex;
x.birthday = birthday;
x.banji = banji;
}
_context.SubmitChanges();
}
、Controllers(控制器)
public ActionResult Edit(string id)
{
Info x =new InfoBF().Select(id);
List<banji> b = new banjiBF().Selcet();//班级表
ViewBag.bb = new SelectList(b, "banji1", "banji1"); //为了将下拉列表里的数据传到Edit里面去
return View(x); }
public ActionResult Update(string code,string name,string sex,string birthday,string banji)
{
new InfoBF().Update(code,name,sex,birthday,banji);
return RedirectToAction("Index"); }
、Views(视图)
@using MVC__数据库增删改查_Razor__Html语法.Models;
@model Info
@{
Layout = null;
} <!DOCTYPE html> <html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Edit</title>
</head>
<body>
<div>
@using (Html.BeginForm("Update", "Home", FormMethod.Post))
{
SelectList xx=ViewBag.bb;
<div>
@* 将数据送到Insert*@ 学号: @Html.TextBoxFor(P=>P.code,new { maxlength= } )<br>
姓名: @Html.TextBoxFor(P=>P.name)<br>
性别: @Html.RadioButtonFor(P => P.sex, "男")男 @Html.RadioButtonFor(P=>P.sex,"女")女<br>
生日: @Html.TextBoxFor(P=>P.birthday)<br>
班级: @Html.DropDownListFor(P=>P.banji,xx)<br> <input id="Submit1" type="submit" value="更新" />
</div>
}
</div>
</body>
</html>
效果图：
五、删除
、Models(模板)
public void Delete(string code)//删除
{
var query = _context.Info.Where(P => P.code == code);
if (query.Count() > )
{
Info a = query.First();
_context.Info.DeleteOnSubmit(a); }
_context.SubmitChanges();
}
二、Controllers(控制器)
public ActionResult Delete(string id)//删除按钮
{
new InfoBF().Delete(id);
return RedirectToAction("Index");
}
三、Views（视图）
null
效果图：