@using Mvc190212.Models
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
</head>
<body>
<div>
<table>
<thead>
<tr>
<th>编号</th>
<th>用户名</th>
<th>密码</th>
<th>邮箱</th>
<th>注册日期</th>
</tr>
</thead>
<tbody>
@foreach(UserInfo userInfo in ViewData["UserInfoList"] as IEnumerable<UserInfo> )
{
<tr><td>@userInfo.ID</td><td>@userInfo.UserName</td><td>@userInfo.UserPass</td><td>@userInfo.Email</td><td>@userInfo.RegTime.ToShortDateString()</td></tr>
}
</tbody>
</table>
</div>
</body>
</html>
/***************************************************************************************/
using Mvc190212.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Mvc;
namespace MvcTest1.Controllers
{
public class UserInfoController : Controller
{
UserInfoDbContext db = new UserInfoDbContext();
// GET: UserInfo
public ActionResult Index()
{
var userInfoList = db.UserInfo.Where(u => true).ToList();
ViewData["userInfoList"] = userInfoList;
return View();
}
public ActionResult Register()
{
return View();
}
//处理post请求
[HttpPost]
public ActionResult Register(UserInfo userInfo)
{
userInfo.RegTime = DateTime.Now;
db.UserInfo.Add(userInfo);
if (db.SaveChanges() > 0)
{
return Content("ok");
}
else
{
return Content("Fail");
}
}
}
}
/***************************************************************************************/
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;
namespace Mvc190212.Models
{
public class UserInfo
{
[Key]
[Required]
public int ID { get; set; }
[Required]
[StringLength(32)]
public string UserName { get; set; }
[Required]
[StringLength(32)]
public string UserPass { get; set; }
[Required]
public DateTime RegTime { get; set; }
[Required]
[StringLength(32)]
public string Email { get; set; }
}
}
/***************************************************************************************/
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Linq;
using System.Web;
namespace Mvc190212.Models
{
public class UserInfoDbContext:DbContext
{
public UserInfoDbContext():base("name=connStr")
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}
public DbSet<UserInfo> UserInfo { get; set; }
}
}