ASP.NET MVC3手把手教你构建Web_实用技巧_

USE [yanComdb] GO /****** 对象: Table [dbo].[NewsEntity] 脚本日期: 03/12/2012 22:03:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NewsEntity]( [NId] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Information] [text] COLLATE Chinese_PRC_CI_AS NULL, [Time] [datetime] NOT NULL CONSTRAINT [DF_NewsEntity_Time] DEFAULT (getdate()), CONSTRAINT [PK_NewsEntity] PRIMARY KEY CLUSTERED ( [NId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 

[TableAttribute("NewsEntity")]//这行很重要，因为mvc框架默认去db中找类名复数的表名 public class NewsEntity { [Key]//设置主键 public int NId { get; set; } [StringLength(100)]//设置验证信息 [Required(ErrorMessage="标题不能为空")] [DisplayName("标题")] public string Title { get; set; } [Required(ErrorMessage = "正文必须填写")] [DisplayName("正文")] public string Information { get; set; } public DateTime Time { get; set; } } 

public class ProjectEntity : DbContext { public DbSet NewsEntity { get; set; } } 

ProjectEntity PE = new ProjectEntity(); public ActionResult News() { try { var list = PE.NewsEntity.ToList(); return View(list); } catch (Exception e) { throw e; } } 

 @model IEnumerable @{ ViewBag.Title = "后台新闻管理列表"; Layout = "~/Views/Shared/_MLayout.cshtml"; } 
 新闻列表
 @Html.ActionLink("添加", "Create") 
 @foreach (var item in Model) {  } 
 ID 
 标题 
 时间 
 @Html.DisplayFor(modelItem => item.NId) 
 @Html.DisplayFor(modelItem => item.Title) 
 @Html.DisplayFor(modelItem => item.Time) 
 @Html.ActionLink("编辑", "EditNews", new { id = item.NId }) | @Html.ActionLink("删除", "DeleteNews", new { id=item.NId }) 

 [HttpPost] [ValidateInput(false)] public ActionResult Create(NewsEntity news) { if (ModelState.IsValid) { news.Time = DateTime.Now; PE.NewsEntity.Add(news); try { PE.SaveChanges(); return RedirectToAction("News"); } catch (Exception e) { throw e; } } return View(); } 

 @model TaiQiu.Models.NewsEntity @{ ViewBag.Title = "添加新闻"; Layout = "~/Views/Shared/_MLayout.cshtml"; } 
 添加新闻
 @using (Html.BeginForm()) { @Html.ValidationSummary(true) 
News
 @Html.LabelFor(model => model.Title) 
 @Html.TextBoxFor(model => model.Title, new { style = "width:500px" }) @Html.ValidationMessageFor(model => model.Title) 
 @Html.LabelFor(model => model.Information) 
 @Html.TextAreaFor(model => model.Information, new { style="width:800px;height:400px"}) @Html.ValidationMessageFor(model => model.Information) 
 } 
 @Html.ActionLink("返回列表", "Index") 

 [HttpPost] [ValidateInput(false)] public ActionResult EditNews(NewsEntity news) { if (ModelState.IsValid) { news.Time = DateTime.Now; PE.Entry(news).State = EntityState.Modified;//修改 PE.SaveChanges(); return RedirectToAction("News"); } return View(news); } 

 public ActionResult DeleteNews(int id) { var model = PE.NewsEntity.Find(id); PE.NewsEntity.Remove(model); PE.SaveChanges(); return RedirectToAction("News"); }