asp.net MVC2 初探四-CSDN博客

今天教大家如何利用ADO.Net 或者linq实现数据增删改查，新建一个项目

using System;

using System.Collections.Generic;

using System.Linq;

using System.Data.Linq;

using System.Web;

using System.Web.Mvc;

using System.Data.Linq.Mapping;

using MvcApplication1.Models;

namespace MvcApplication1.Controllers

{

public class MovieController : Controller

{

MoviesEntities1 _db = new MoviesEntities1();

public ActionResult Index()

{

ViewData.Model = new MoviesEntities1().Movies.ToList();

return View();

}

public ActionResult Details( int id)

{

var model = new MoviesEntities1().Movies.First(m => m.ID == id);

return View(model);

}

public ActionResult Create()

{

return View();

}

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Create(Models.Movie m)

{

try

{

_db.AddToMovies(m);

if ( string.IsNullOrEmpty(m.Movie_Name))

{

ModelState.AddModelError( "Movie_Name", "电影名称不能为空!");

}

if (m.Realease_Date == null)

{

ModelState.AddModelError( "Realease_Date", "放映时间不能为空");

}

foreach (Movie mv in _db.Movies)

{

if (mv.ID == m.ID)

{

ModelState.AddModelError( "ID", "数据库中已经存在Id为" + m.ID + "的数据");

break;

}

if (ModelState.IsValid)

{

_db.SaveChanges();

return RedirectToAction( "Index");

}

return View(m);

}

catch

{

return View();

}

public ActionResult Edit( int id)

{

var movieToUpdate = _db.Movies.First(m => m.ID == id);

ViewData.Model = movieToUpdate;

return View();

}

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Edit(FormCollection form)

{

var id = Int32.Parse(form[ "id"]);

var movieToUpdate = _db.Movies.First(m => m.ID == id);

TryUpdateModel(movieToUpdate, new string[] { "Movie_Name", "Realease_Date" }, form.ToValueProvider());

if (String.IsNullOrEmpty(movieToUpdate.Movie_Name))

ModelState.AddModelError( "Movie_Name", "Movie_Name is required!");

if (movieToUpdate.Realease_Date == null)

ModelState.AddModelError( "Realease_Date", "Realease_Date is required!");

if (ModelState.IsValid)

{

_db.SaveChanges();

return RedirectToAction( "Index");

}

return View(movieToUpdate);

}

//public ActionResult Delete(int id)

//{

// try

// {

// Models.Movie movie = _db.Movies.First(m => m.ID == id);

// _db.DeleteObject(movie);

// _db.SaveChanges();

// return RedirectToAction("Index");

// }

// catch

// {

// return View("Index");

// }

//}

/// <summary>

/// 使用linq

/// </summary>

/// <returns></returns>

public ActionResult ShowDB()

{

string str = System.Configuration.ConfigurationManager.ConnectionStrings[ "MoviesConnectionString"].ToString();

DataContext MyDataSource = new DataContext(str);

Table<Movies> tb = MyDataSource.GetTable<Movies>();

IQueryable<Movies> MyQuery = from movies in tb where movies.ID >= 5 select movies;

return View(MyQuery);

}

public ActionResult Delete( int id)

{

DataClasses1DataContext DataC1Context = new DataClasses1DataContext();

Movy mv = DataC1Context.Movies.First(c => c.ID == id);

DataC1Context.Movies.DeleteOnSubmit(mv);

DataC1Context.SubmitChanges();

return RedirectToRoute( "start");

}

[Table(Name = "Movies")]

public class Movies

{

private int _ID;

private string _Movie_Name;

private DateTime _Realease_Date;

[Column(Storage = "_ID",

AutoSync = AutoSync.OnInsert,

DbType = "int not null indentity",

IsPrimaryKey = true,

IsDbGenerated = true)

]

public int ID

{

set { _ID = ID; }

get { return this._ID; }

}

[Column(Storage = "_Movie_Name",

AutoSync = AutoSync.Always,

DbType = "varchar(200) not null",

IsDbGenerated = true

)]

public string Movie_Name

{

set { _Movie_Name = Movie_Name; }

get { return this._Movie_Name; }

}

[Column(Storage = "_Realease_Date",

AutoSync = AutoSync.Always,

DbType = "datetime not null",

IsDbGenerated = true

)]

public DateTime Realease_Date

{

set { _Realease_Date = Realease_Date; }

get { return _Realease_Date; }

}

上述代码咋一看去很郁闷。其实和日常的webForm是一样的。首先在Index上单击右键Create一个View，那么这个action方法Index对应的页面就是你所建的View。ViewData.Model = new MoviesEntities1().Movies.ToList();将一个List数据泛型返回给ViewData。ViewData作用类似于ViewState，只能在特定的一个视图使用。而TempData作用类似于session。但是其在controller中只能传递使用一次，之后就会被销毁。所以上述代码就是向视图页面Index.aspx页面发送一组数据。

<%@ Page Title= "" Language="C# " MasterPageFile="~/Views/Shared/Site.Master " Inherits="System.Web.Mvc.ViewPage<IEnumerable<MvcApplication1.Models.Movie>>" %>

<asp:Content ID= "Content1" ContentPlaceHolderID= "TitleContent" runat= "server">

Index

</asp:Content>

<asp:Content ID= "Content2" ContentPlaceHolderID= "MainContent" runat= "server">

<h2>

Index</h2>

<table>

<tr>

<th>

</th>

<th>

</th>

<th>

Movie_Name

</th>

<th>

Realease_Date

</th>

</tr>

<% foreach (var item in Model)

{ %>

<tr>

<td>

<%: item.ID %>

</td>

<td>

<%: item.Movie_Name %>

</td>

<td>

<%: String.Format( "{0:g}", item.Realease_Date) %>

</td>

<td>

<%: Html.ActionLink( "Edit", "Edit", new { id=item.ID }) %>

<%: Html.ActionLink( "Details", "Details", new { id=item.ID })%>

<%: Html.ActionLink( "Delete", "Delete", new { id=item.ID })%>

</td>

</tr>

<% } %>

</table>

<p>

<%: Html.ActionLink( "Create New", "Create") %>

<%: Html.ActionLink( "跳转到筛选的页面", "ShowDB")%>

</p>

</asp:Content>

在这个Html页面，当接收到传过来的数据的时候进行循环遍历，采用HtmlHelper扩展类进行显示。 <%: Html.ActionLink("跳转到筛选的页面", "ShowDB")%>这句的意思是一个超链接，连接到ShowDB这个Action。showDB再调用return view跳转到ShowDb.aspx。

public ActionResult Create()
        {
            return View();
        }

[HttpPost]
public ActionResult Create(Models.Movie m){

}

这段代码一个是post方式，另一个是get方式，所谓Get方式即xxx.aspx?id=xx。所以第一个Create所做的动作就是当你点击添加的时候，出现一个添加页面(Create.aspx)而已，仅此而已。第二个post方式的Create才是真正的添加,首先你做个简单的验证。如果验证通过。则调用_db.SaveChanges();在这里需要说明的是Models.Movie m参数的值自动从添加页面可以自动获取。无需写任何代码。对于修改比较特殊，主键不用显示页面view如下

< %@ Page Title ="" Language="C#" MasterPageFile ="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<MvcApplication1.Models.Movie >" %>

< asp:Content ID ="Content1" ContentPlaceHolderID ="TitleContent" runat ="server" >
        Edit
</asp:Content>
< asp:Content ID ="Content2" ContentPlaceHolderID ="MainContent" runat ="server" >
         < h2 >
                Edit </h2>
        <% using (Html.BeginForm())
             {%>
         < %: Html.ValidationSummary(true) % >
         < fieldset >
                 < legend >Fields </legend>
                 < div >
                         < %: Html.HiddenFor(model = > model.ID)%>
                 </div>
                 < div class ="editor-label" >
                         < %: Html.LabelFor(model = > model.Movie_Name) %>
                 </div>
                 < div class ="editor-field" >
                         < %: Html.TextBoxFor(model = > model.Movie_Name) %>
                         < %: Html.ValidationMessageFor(model = > model.Movie_Name) %>
                 </div>
                 < div class ="editor-label" >
                         < %: Html.LabelFor(model = > model.Realease_Date) %>
                 </div>
                 < div class ="editor-field" >
                         < %: Html.TextBoxFor(model = > model.Realease_Date, String.Format("{0:g}", Model.Realease_Date)) %>
                         < %: Html.ValidationMessageFor(model = > model.Realease_Date) %>
                 </div>
                 < p >
                         < input type ="submit" value ="保存" />
                 </p>
         </fieldset>
         < % } % >
         < div >
                 < %: Html.ActionLink("返回", "Index") % >
         </div>
</asp:Content>

本文转自 BruceAndLee 51CTO博客，原文链接：http://blog.51cto.com/leelei/318427，如需转载请自行联系原作者