1、视图（显示）界面代码：
@{ Layout = null; } @using Mvc1.Models; <!DOCTYPE html> @{ if(Session["user"]==null) { Response.Redirect("Login"); } } <html> <head> <meta name="viewport" content="width=device-width" /> <title>Index</title> </head> <body> <div> <table style="background-color: navy; text-align: center; 100%;"> <tr style="color: white;"> <td>用户名</td> <td>密码</td> <td>昵称</td> <td>性别</td> <td>生日</td> <td>民族</td> <td>操作</td> </tr> @{ //先将数据取出来 List<Users> list = new UsersData().Select(); foreach (Users u in list) { <tr style="background-color: #e0e0e0;"> <td>@u.UserName</td> <td>@u.PassWord</td> <td>@u.NickName</td> <td>@((bool)u.Sex ? "男" : "女")</td> <td>@Convert.ToDateTime(u.Birthday).ToString("yyyy年MM月dd日")</td> <td>@u.NationName</td> <td> <a href="Home/Update/@u.UserName">修改</a> </td> </tr> } } </table> </div> </body> </html>
2、视图（修改）界面代码：
@{ Layout = null; } @using Mvc1.Models; @model Users <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width" /> <title>Update</title> </head> <body> <form name="form1" method="post" action="~/Home/UUU"> 用户名：<input type="text" name="username" value="@Model.UserName" /><br /> 密码：<input type="text" name="password" value="@Model.PassWord" /><br /> 昵称：<input type="text" name="nickname" value="@Model.NickName" /><br /> 性别： @{ if ((bool)Model.Sex) { <input type="radio" name="sex" checked="checked" value="True" />@:男 <input type="radio" name="sex" value="False" />@:女 } else { <input type="radio" name="sex" value="True" />@:男 <input type="radio" name="sex" checked="checked" value="False" />@:女 } } <br /> 生日： <select id="year" onchange="DateChange()"> @{ for (int i = DateTime.Now.Year; i > 1900; i--) { if (Convert.ToDateTime(Model.Birthday).Year == i) { <option selected="selected">@i</option> } else { <option>@i</option> } } } </select>年 <select id="month" onchange="DateChange()"> @{ for (int i = 1; i <= 12; i++) { if (Convert.ToDateTime(Model.Birthday).Month == i) { <option selected="selected">@i</option> } else { <option>@i</option> } } } </select>月 <select id="day" onchange="DateChange()"> @{ for (int i = 1; i <= 31; i++) { if (Convert.ToDateTime(Model.Birthday).Day == i) { <option selected="selected">@i</option> } else { <option>@i</option> } } } </select>日 <input type="text" id="birthday" name="birthday" style="display:none;" value="@Model.Birthday" /> <br /> 民族： <select name="nation"> @{ List<Nation> Nlist = new NationData().Select(); foreach (var n in Nlist) { if (Model.Nation == n.NationCode) { <option value="@n.NationCode" selected="selected">@n.NationName</option> } else { <option value="@n.NationCode">@n.NationName</option> } } } </select> <br /> <input type="button" value="提交" onclick="form1.submit()" /> </form> </body> </html> <script type="text/javascript"> function DateChange() { var year = document.getElementById('year').value; var month = document.getElementById('month').value; var day = document.getElementById('day').value; document.getElementById('birthday').value = year + "-" + month + "-" + day; } </script>
3、控制层控制器代码：
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using Mvc1.Models; namespace Mvc1.Controllers { public class HomeController : Controller { public ActionResult Index() { return View(); } public ActionResult Update(string id) { Users u = new UsersData().Select(id); return View(u); } public ActionResult UUU(Users data) { new UsersData().Update(data); return RedirectToAction("Index", "Home"); } } }
4、模型层代码：
民族表查询
using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace Mvc1.Models { public class NationData { Data0425DataContext con = new Data0425DataContext(); public List<Nation> Select() { return con.Nation.ToList(); } } }
民族字段扩展
using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace Mvc1.Models { public partial class Users { Data0425DataContext con = new Data0425DataContext(); public string NationName { get { return con.Nation.Where(r => r.NationCode == this.Nation).FirstOrDefault().NationName; } } } }
数据操作方法
using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace Mvc1.Models { public class UsersData { Data0425DataContext con = new Data0425DataContext(); public List<Users> Select() { return con.Users.ToList(); } public Users Select(string uname) { return con.Users.Where(r => r.UserName == uname).FirstOrDefault(); } public void Update(Users uuu) { Users u = con.Users.Where(r => r.UserName == uuu.UserName).FirstOrDefault(); u.PassWord = uuu.PassWord; u.NickName = uuu.NickName; u.Sex = uuu.Sex; u.Birthday = uuu.Birthday; u.Nation = uuu.Nation; con.SubmitChanges(); } } }