ASP.NET 電影票資訊的增刪查改

許佳佳233發表於2016-12-14

#題目
1、使用Code First技術建立一個Movie資料模型。

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; }     //電影分級
 }

2、使用MVC相關技術實現資料的列表顯示和新增功能。

3、完成資料的編輯、刪除、明細和條件查詢等功能。

4、完成如下查詢：
（1）查詢尚未上映電影的資訊
（4）查詢票價在某個區間的電影資訊

#效果
##（原始碼在文章結尾）
這裡寫圖片描述

#主要涉及知識點
1、ASP.Net WEB MVC下的目錄結構以及基礎程式設計
2、Linq查詢操作
3、Code First
4、各模板View的建立和使用
#主要程式碼
##MovieController.cs

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('必須輸入數字!');</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");
        }

    }


}

##Movie.cs

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; } //電影分級

    }

}

##MovieDBContext.cs


using System.Data.Entity;


namespace ProjectThree.Models
{
    public class MovieDBContext : DbContext

    {
        public DbSet<Movie> Movies { get; set; }
    }
}

##Index.cshtml

@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")
        票價區間:@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('確認刪除嗎？')" })
        </td>
    </tr>
}

</table>

##Create.cshtml

@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>

##Edit.cshtml

@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>

#原始碼地址
http://download.csdn.net/detail/double2hao/9710754

增刪改查
2024-03-23
layui的增刪改查
2019-07-10
UI
列表的增刪改查
2018-07-31
字典的增刪改查
2018-08-01
redist的增刪改查
2020-12-29
Redis
Mybatis的增刪改查
2020-12-21
MyBatis
MongoDB的增刪改查
2016-08-05
MongoDB
ThinkPHP的增、刪、改、查
2017-08-03
PHP
indexedDB 增刪改查
2020-07-13
Index
SQL增刪改查
2018-08-21
SQL
mysql增刪改查
2020-10-18
MySql
Mongoose查增改刪
2023-12-02
Go
FMDB增刪改查
2017-12-15
mysql增查刪改
2012-12-31
MySql
sql指令，增，刪，查，改
2021-04-28
SQL
EFCore之增刪改查
2021-05-24
mysql基本增刪改查
2020-12-15
MySql
MongoDB增刪改查操作
2020-10-22
MongoDB
mongodb 基本增刪改查
2024-04-03
MongoDB
02-CoreData 的增刪改查
2019-01-02
增刪改查框架的疑問
2007-01-30
框架
Elasticsearch增刪改查之 —— Delete刪除
2016-03-26
Elasticsearchdelete
elasticsearch7.2增刪改查
2020-06-03
Elasticsearch
SQL 基礎增、刪、改、查
2018-08-22
SQL
iOS CoreData (一) 增刪改查
2018-12-06
iOS
CoreData - 簡單增刪改查
2018-12-23
[express+mongoose](增刪改查)
2020-11-20
ExpressGo
rust sqlx 使用---增刪改查
2022-07-27
RustSQL
PHP操作MongoDB（增刪改查）
2021-11-23
PHPMongoDB
JavaWeb中jdbc增刪查改
2021-11-02
JavaWebJDBC
sql 常見增刪改查
2017-11-07
SQL
Hibernate--增刪改查
2017-08-13
MySQL表的增刪查改(提高篇)
2020-02-17
MySql
js實現表格的增刪改查
2019-04-12
JS
字典，元組，集合的增刪改查
2020-11-08
MySQL表的增刪改查（基礎）
2021-01-03
MySql
基本的資料庫增刪改查
2014-03-11
資料庫
lucene(二) 索引的建立、增刪改查
2016-05-16
索引

ASP.NET 電影票資訊的增刪查改

相關文章