ASP.NET實(shí)現(xiàn)電影票信息的增刪查改功能

public class Movie
 {
 public int ID { get; set; } //電影編號
 public string Title { get; set; } //電影名稱
 public DateTime ReleaseDate { get; set; } //上映時間
 public string Genre { get; set; } //電影類型
 public decimal Price { get; set; } //電影票價
 public string Rating { get; set; } //電影分級
 }

using ProjectThree.Models;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace ProjectThree.Controllers
{
 public class MovieController : Controller
 {
 MovieDBContext db = new MovieDBContext();
 // GET: Movie
 public ActionResult Index(string movieOn, string movieGenre,
 string searchString, string lowPrice, string highPrice)
 {
 //初始化電影是否上映下拉
 var GenreLst1 = new List<string>();
 GenreLst1.Add("是");
 GenreLst1.Add("否");
 ViewBag.movieOn = new SelectList(GenreLst1);
 //初始化電影類型下拉
 var GenreLst2 = new List<string>();
 var GenreQry = from d in db.Movies orderby d.Genre select d.Genre;
 GenreLst2.AddRange(GenreQry.Distinct()); //去重
 ViewBag.movieGenre = new SelectList(GenreLst2);
 var movies = from m in db.Movies select m;
 if (!String.IsNullOrEmpty(movieOn))
 {
 DateTime dtNow = DateTime.Now;
 if (movieOn.Equals("是"))
 { movies = movies.Where(s => DateTime.Compare(dtNow, s.ReleaseDate) > 0); }
 else if (movieOn.Equals("否"))
 { movies = movies.Where(s => DateTime.Compare(dtNow, s.ReleaseDate) <= 0); }
 }
 if (!String.IsNullOrEmpty(movieGenre))
 { movies = movies.Where(x => x.Genre == movieGenre); }
 if (!String.IsNullOrEmpty(searchString))
 { movies = movies.Where(s => s.Title.Contains(searchString)); }
 if ((!String.IsNullOrEmpty(lowPrice)) && (!String.IsNullOrEmpty(highPrice)))
 {
 try
 {
 Decimal low = Decimal.Parse(lowPrice);
 Decimal high = Decimal.Parse(highPrice);
 if (high < low)
 {
 Response.Write("<script>alert('左邊價格不可大于右邊!');</script>");
 }
 else
 {
 movies = movies.Where(s => s.Price >= low);
 movies = movies.Where(s => s.Price <= high);
 }
 }
 catch
 {
 Response.Write("<script>alert('必須輸入數(shù)字!');</script>");
 return View(movies);
 }
 }
 return View(movies);
 }
 public ActionResult Create()
 {
 return View();
 }
 [HttpPost]
 public ActionResult Create(Movie m)
 {
 if (ModelState.IsValid)
 {
 db.Movies.Add(m);
 db.SaveChanges();
 return RedirectToAction("Index", "Movie");
 }
 return View(m);
 }
 public ActionResult Delete(int? id)
 {
 Movie m = db.Movies.Find(id);
 if (m != null)
 {
 db.Movies.Remove(m);
 db.SaveChanges();
 }
 return RedirectToAction("Index", "Movie");
 }
 public ActionResult Edit(int id)
 {
 Movie stu = db.Movies.Find(id);
 return View(stu);
 }
 [HttpPost]
 public ActionResult Edit(Movie stu)
 {
 db.Entry(stu).State = EntityState.Modified;
 db.SaveChanges();
 return RedirectToAction("Index", "Movie");
 }
 }
}

using System;
using System.ComponentModel.DataAnnotations;
namespace ProjectThree.Models
{
 public class Movie
 {
 [Display(Name = "電影編號")]
 public int ID { get; set; } //電影編號
 [Display(Name = "電影名稱")]
 [Required(ErrorMessage = "必填")]
 [StringLength(60, MinimumLength = 3, ErrorMessage = "必須是[3,60]個字符")]
 public string Title { get; set; } //電影名稱
 [Display(Name = "上映時間")]
 [DataType(DataType.Date)]
 [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}",ApplyFormatInEditMode = true)]
 public DateTime ReleaseDate { get; set; } //上映時間
 [Display(Name = "電影類型")]
 [Required]
 public string Genre { get; set; } //電影類型
 [Display(Name = "電影票價")]
 [Range(1, 100)]
 [DataType(DataType.Currency)]
 public decimal Price { get; set; } //電影票價
 [Display(Name = "電影分級")]
 [StringLength(5)]
 [Required]
 public string Rating { get; set; } //電影分級
 }
}

using System.Data.Entity;
namespace ProjectThree.Models
{
 public class MovieDBContext : DbContext
 {
 public DbSet<Movie> Movies { get; set; }
 }
}

@model IEnumerable<ProjectThree.Models.Movie>
@{
 ViewBag.Title = "Index";
}
<p>
 @Html.ActionLink("新建", "Create")
 @using (Html.BeginForm("Index", "Movie", FormMethod.Get))
 {
 <p>
 電影是否上映:@Html.DropDownList("movieOn", "all")
 電影類型:@Html.DropDownList("movieGenre", "all")
 電影名稱:@Html.TextBox("SearchString")
 票價區(qū)間:@Html.TextBox("lowPrice")~@Html.TextBox("highPrice")
 <input type="submit" value="查詢" />
 </p>
 }
</p>
<table class="table">
 <tr>
 <th>
 @Html.DisplayNameFor(model => model.Title)
 </th>
 <th>
 @Html.DisplayNameFor(model => model.ReleaseDate)
 </th>
 <th>
 @Html.DisplayNameFor(model => model.Genre)
 </th>
 <th>
 @Html.DisplayNameFor(model => model.Price)
 </th>
 <th>
 @Html.DisplayNameFor(model => model.Rating)
 </th>
 <th></th>
 </tr>
@foreach (var item in Model) {
 <tr>
 <td>
 @Html.DisplayFor(modelItem => item.Title)
 </td>
 <td>
 @Html.DisplayFor(modelItem => item.ReleaseDate)
 </td>
 <td>
 @Html.DisplayFor(modelItem => item.Genre)
 </td>
 <td>
 @Html.DisplayFor(modelItem => item.Price)
 </td>
 <td>
 @Html.DisplayFor(modelItem => item.Rating)
 </td>
 <td>
 @Html.ActionLink("編輯", "Edit", new { id=item.ID }) |
 @Html.ActionLink("詳情", "Details", new { id=item.ID }) |
 @Html.ActionLink("刪除", "Delete", new { id=item.ID }, new { onclick = "return confirm('確認(rèn)刪除嗎？')" })
 </td>
 </tr>
}
</table>

@model ProjectThree.Models.Movie
@{
 ViewBag.Title = "Create";
}
@using (Html.BeginForm()) 
{
 @Html.AntiForgeryToken()
 <div class="form-horizontal">
 <h4>Movie</h4>
 <hr />
 @Html.ValidationSummary(true, "", new { @class = "text-danger" })
 <div class="form-group">
 @Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.ReleaseDate, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.ReleaseDate, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.ReleaseDate, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.Genre, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Genre, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Genre, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.Price, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Price, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Price, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.Rating, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Rating, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Rating, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 <div class="col-md-offset-2 col-md-10">
 <input type="submit" value="Create" class="btn btn-default" />
 </div>
 </div>
 </div>
}
<div>
 @Html.ActionLink("Back to List", "Index")
</div>

@model ProjectThree.Models.Movie
@{
 ViewBag.Title = "Edit";
}
<h2>Edit</h2>
@using (Html.BeginForm())
{
 @Html.AntiForgeryToken()
 <div class="form-horizontal">
 <h4>Movie</h4>
 <hr />
 @Html.ValidationSummary(true, "", new { @class = "text-danger" })
 @Html.HiddenFor(model => model.ID)
 <div class="form-group">
 @Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.ReleaseDate, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.ReleaseDate, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.ReleaseDate, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.Genre, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Genre, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Genre, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.Price, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Price, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Price, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 @Html.LabelFor(model => model.Rating, htmlAttributes: new { @class = "control-label col-md-2" })
 <div class="col-md-10">
 @Html.EditorFor(model => model.Rating, new { htmlAttributes = new { @class = "form-control" } })
 @Html.ValidationMessageFor(model => model.Rating, "", new { @class = "text-danger" })
 </div>
 </div>
 <div class="form-group">
 <div class="col-md-offset-2 col-md-10">
 <input type="submit" value="Save" class="btn btn-default" />
 </div>
 </div>
 </div>
}
<div>
 @Html.ActionLink("Back to List", "Index")
</div>