干货 | C#开发的电影售票系统
01 介绍
一个有会员制的电影院购票系统。具有会员注册功能，可区分会员和散客两种身份，实现会员及折扣管理。购票具有挑选电影场次，选择座位和查看电影信息等功能。
- 查看电影详情、获取排片信息。
- 选择场次座位，完成支付，获取取票信息。
- 注册成为影院会员，享受优惠折扣。
代码获取
关注我们的公众号！在后台回复【CSTK】不包括【】即可获取。
02 设计思路
在功能设计上，一个电影院购票系统，首先需要具备最基础的功能：影片选择、场次选择和座位选择。在用户提交选择后，会需要支付模块提示用户付款并完成出票。为了吸引用户，我们增加了会员的注册和登录模块，为会员用户提供折扣。
注册与购票的支付我们的处理是预留一个接口，当做简单模拟，实际使用可以调用支付宝或微信的支付接口。
在界面设计上，我们为系统添加了好看的背景图片。通过Detail栏展示用户信息与折扣，通过Hot Movie栏在最吸引眼球展示热映电影的海报，提高用户的购买欲望。最后，作为主要部分的座位选择栏简介明了，座位之间间隔明显，有效的防止用户错误操作。
03 具体设计
通过三层架构来完成影院购票系统的开发，将真个业务应用划分为：界面层（UI层）、业务逻辑层（BLL层）、数据访问层（DAL层）。对于复杂的系统分层让结构清晰，便于对系统进行整体的理解、把握；而且便于维护，将各部分之间的相互影响的程度降低到最小，系统基本的架构可以通过工具自动生成代码。当数据库发生改变时，只用重新生成代码，改动业务逻辑层的部分代码即可。在实施的过程中，难点在于将三层结构进行划分，掌握各层之间的设计思路以及调用关系，下面内容就结合代码展示具体实现过程。
1) Model层（ 封装数据，使数据在三层中传输）
例如Movie：
namespace Model
{
public class Movie
{
[Key]
public int MovieID { get; set; }
public string MovieName{ get; set; } /// 电影名称
public string Actor { get; set; } /// 主演
public string Director { get; set; }/// 导演名
public int Duration { get; set; } //时长
public string MovieType { get; set; }/// 电影类型
public string Poster{ get; set; } /// 海报图片名
}
}
2) DAL层（提供基本的数据访问）
实现代码（以Movies为例）：
namespace DAL
{
public class MovieDAL
{
public static List<Movie> GetAllMovies()
{
var MoviesQuery = from m in CinemaDbContext.CDbContext.Movies
select m;
return MoviesQuery.ToList();
}
public static Movie GetMovieByMovieID(int mID)
{
return CinemaDbContext.CDbContext.Movies.Find(mID);
}
}
}
3) BLL层（负责处理业务逻辑，在本次的系统开发中，包括了与用户和影票信息相关的处理）
实现代码（以TicketBLL为例）：
namespace BLL
{
public class TicketBLL
{
public static bool AddTickets(List<Ticket> tickets)
{
return true;
}
}
}
4) UI层（负责显示和采集用户操作）
系统总共包含五个界面，分别为：用户登录界面、用户注册界面、影院主页、票务信息确认界面以及支付界面。同时，使用Winform皮肤插件来实现对系统界面整体风格的把控。下面将以界面的为单位来对其实现过程进行描述：
- 用户登录界面
用户将身份信息写入文本框后，用其输入的信息创建新的customer对象，通过调用BLL层的功能将输入内容与用户信息比对，最后用判断语句激活弹窗反馈登陆结果，登陆成功后进入到售票系统首页。
private void button1_Click(object sender, EventArgs e)
{
Customer cLogin = new Customer
{
UserName = this.textBox1.Text,
PassWord = this.textBox2.Text
};
if (CustomerBLL.Login(cLogin))
{
MessageBox.Show("登录成功");
MainForm mainForm = new MainForm();
mainForm.customerVIP = cLogin;
mainForm.Show();
this.Visible = false;
}
else
{
MessageBox.Show("登录失败");
}
}
同时，用户可以点击注册按钮，跳转到注册界面完成新用户的注册。
private void button3_Click(object sender, EventArgs e)
{
UserRegisterForm userRegisterForm = new UserRegisterForm();
userRegisterForm.Show();
this.Visible = false;
}
- 用户注册界面
用户将身份信息写入文本框后，用其输入的信息创建新的customer对象，通过调用BLL层的服务将新的用户信息写入数据库，最后用判断语句激活弹窗对注册结果予以反馈。
private void button1_Click(object sender, EventArgs e)
{
PayForm payform = new PayForm(true);
payform.ShowDialog();
//Thread.Sleep(7000);
//payform.Visible = false;
Customer cRegister = new Customer
{
UserName = this.textBox1.Text,
PassWord = this.textBox2.Text
};
if (CustomerBLL.Register(cRegister))
{
MessageBox.Show("注册成功");
UserLoginForm userLoginForm = new UserLoginForm();
userLoginForm.Show();
this.Visible = false;
}
else
{
MessageBox.Show("注册失败");
}
}
- 排片详情获取
/// <summary>
/// 初始化TreeView控件
/// </summary>
private void InitTreeView()
{
tvMovies.BeginUpdate();
tvMovies.Nodes.Clear();
TreeNode movieNode = null;
foreach(Movie m in MovieDAL.GetAllMovies())
{
movieNode = new TreeNode(m.MovieName);
tvMovies.Nodes.Add(movieNode);
foreach (Schedule s in ScheduleDAL.GetSchedulesByMovieID(m.MovieID))
{
TreeNode timeNode = new TreeNode(s.DateTime);
timeNode.Name = s.ScheduleID.ToString();
movieNode.Nodes.Add(timeNode);
}
}
tvMovies.EndUpdate();
}
- 影厅初始化
/// <summary>
/// 初始化放映厅座位
/// </summary>
/// <param name="seatRow">行数</param>
/// <param name="seatCol">列数</param>
/// <param name="tb"></param>
//普通厅放映
private void InitSeatsCheckBox(int seatRow, int seatCol, TabPage tb, Dictionary<string, CheckBox> ckBox, Dictionary<string, Seat> cSeats)
{
CheckBox checkBox;
Seat seat;
for (int i = 0; i < seatRow; i++) /* 加载一号放映厅的位置*/
{
for (int j = 0; j < seatCol; j++)
{
checkBox = new CheckBox();
//设置背景颜色
checkBox.BackColor = Color.LightBlue;
//设置字体
checkBox.Font = font1; //new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point,((byte)(134)));
//设置尺寸
checkBox.AutoSize = false;
checkBox.Size = new System.Drawing.Size(60, 25);
//设置座位号
checkBox.Text = (j+1).ToString() + "-" + (i+1).ToString();
checkBox.TextAlign = ContentAlignment.MiddleCenter;
//设置位置
checkBox.Location = new Point(60 + (i * 90), 60 + (j * 60));
//所有的标签都绑定到同一事件
//checkBox.Click += new System.EventHandler(lblSeat_Click);
tb.Controls.Add(checkBox);
ckBox.Add(checkBox.Text, checkBox);
//实例化一个座位
seat = new Seat(checkBox.Text, Color.LightBlue);
//保存的座位集合
cSeats.Add(seat.SeatNum, seat);
}
}
Label lb = new Label();
lb.BackColor = Color.LightGray;
lb.Font = font1; //设置尺寸
lb.AutoSize = false;
lb.Size = new System.Drawing.Size(100, 25);
//
lb.Text = "荧幕中央";
lb.TextAlign = ContentAlignment.MiddleCenter;
//设置位置
lb.Location = new Point(310, 20);
tb.Controls.Add(lb);
}
- 购票
private void tvMovies_AfterSelect(object sender, TreeViewEventArgs e)
{
/// <summary>
/// 选择一场电影事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
TreeNode node = tvMovies.SelectedNode;
if (node == null) return;
if (node.Level != 1) return;
int sID = int.Parse(node.Name);
Schedule s = null;
Movie m = null;
s= ScheduleDAL.GetScheduleByScheduleID(sID);
if (s == null)
{
MessageBox.Show("s should not be null");
return;
}
m = MovieDAL.GetMovieByMovieID(s.MovieID);
if (m == null)
{
MessageBox.Show("m should not be null");
return;
}
//将详细信息显示
this.lblMovieName.Text = m.MovieName;
this.lblDirector.Text = m.Director;
this.lblActor.Text = m.Actor;
this.lblPrice.Text = s.Price.ToString();
this.lblTime.Text = s.DateTime;
this.lblType.Text = m.MovieType;
this.picMovie.Image = Image.FromFile(m.Poster);
if(this.customerVIP != null)
{
this.lblCalcPrice.Text = (s.Price * 0.8).ToString();
}
else
{
this.lblCalcPrice.Text = lblPrice.Text;
}
otherHallIDs.Clear();
foreach (int hID in AllHallIDs)
{
if (hID == s.HallID)
{
continue;
}
otherHallIDs.Add(hID);
}
//清空座位
ReSetSeats(s.HallID);
//遍历该场电影的座位销售情况
foreach (Ticket t in TicketDAL.GetTicketsByScheduleID(sID))
{
foreach (Seat seat in seats[s.HallID].Values)
{
if (t.DetailSeat == seat.SeatNum)
{
seat.Color = Color.LightCoral;
}
}
}
UpdateSeats(s.HallID);
tbSeat.SelectedTab = tbSeat.TabPages[s.HallID-1];
}
- 购票信息确认界面
private void button1_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(this.lblMovieName.Text))
{
MessageBox.Show("您还没选择电影!", "提示");
return;
}
int hID = tbSeat.SelectedIndex + 1;
TreeNode node = tvMovies.SelectedNode;
if (node == null) return;
if (node.Level != 1) return;
int sID = int.Parse(node.Name);
double totalCost = 0;
List<Ticket> selectSeats = new List<Ticket>();
string confireInfo = "您选择的电影票信息如下，请确认：\n\n";
foreach(CheckBox cb in checkBoxs[hID].Values)
{
if (cb.Checked && cb.Enabled == true)
{
selectSeats.Add(new Ticket(sID, cb.Text));
confireInfo += "电影名：" + lblMovieName.Text + " 场次：" + lblTime.Text + " 大厅：" + hID + " 座位："+cb.Text+"\n";
totalCost += double.Parse(lblCalcPrice.Text);
}
}
if (selectSeats.Count < 1)
{
MessageBox.Show("您没有选择任何座位！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
confireInfo += "\n总金额：" + totalCost.ToString()+" 元";
if (MessageBox.Show(confireInfo, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
PayIsSuccess = false;
PayForm pf = new PayForm(false);
pf.Owner = this;
pf.payMoney = totalCost;
pf.ShowDialog();
//支付成功
if (PayIsSuccess)
{
//保存到数据库成功
if (TicketDAL.AddTickets(selectSeats))
{
//生成取票码
//更新位置信息
foreach (Ticket t in selectSeats)
{
Seat s = null;
if(seats[hID].TryGetValue(t.DetailSeat, out s))
{
s.Color = Color.LightCoral;
}
}
//更新UI
UpdateSeats(hID);
TicketForm tf = new TicketForm();
tf.Owner = this;
tf.ticketCode = DateTime.Now.ToFileTimeUtc().ToString();
tf.ShowDialog();
}
}
}
}
- 支付界面（获取购票信息，计算总票价，提示支付）
private void TicketForm_Load(object sender, EventArgs e)
{
label2.Text = ticketCode;
Image qr = getqrcode(ticketCode);
imageList1.Images.Add(qr);
imageList1.ImageSize = new Size(150, 150);
pictureBox1.Image = imageList1.Images[0];
}
public Image getqrcode(string content)
{
var encoder = new QrEncoder(ErrorCorrectionLevel.M);
QrCode qrCode = encoder.Encode(content);
GraphicsRenderer render = new GraphicsRenderer(new FixedModuleSize(12, QuietZoneModules.Two), Brushes.Black, Brushes.White);//如需改变二维码大小，调整12即可
DrawingSize dSize = render.SizeCalculator.GetSize(qrCode.Matrix.Width);
Bitmap map = new Bitmap(dSize.CodeWidth, dSize.CodeWidth);
Graphics g = Graphics.FromImage(map);
render.Draw(g, qrCode.Matrix);
return map;
}
- 取票信息界面（包括取票二维码以及取票序列号的实现）
private void button1_Click(object sender, EventArgs e)
{
MainForm m = (MainForm)Owner;
m.PayIsSuccess = true;
this.Close();
}
private void PayForm_Load(object sender, EventArgs e)
{
label1.Text = payMoney.ToString();
}
05 数据库设计
数据库采用的是SQLSERVER，可以复制下面的脚本到查询框执行，即可得到数据库和样本数据。
系统中采用DbContext方式直接连接数据库。各表的设计如下：
-
Customer
-
Hall
-
Movie
-
Schedule
-
Ticket
数据库脚本：
USE [master]
GO
/****** Object: Database [U201715959] Script Date: 12/12/2019 17:34:20 ******/
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N\'U201715959\')
BEGIN
CREATE DATABASE [U201715959] ON PRIMARY
( NAME = N\'U201715959\', FILENAME = N\'D:\Database\U201715959\U201715959.mdf\' , SIZE = 3072KB , MAXSIZE = 716800KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N\'U201715959_log\', FILENAME = N\'D:\Database\U201715959\U201715959_log.ldf\' , SIZE = 1024KB , MAXSIZE = 204800KB , FILEGROWTH = 10%)
END
GO
ALTER DATABASE [U201715959] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY(\'IsFullTextInstalled\'))
begin
EXEC [U201715959].[dbo].[sp_fulltext_database] @action = \'enable\'
end
GO
ALTER DATABASE [U201715959] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [U201715959] SET ANSI_NULLS OFF
GO
ALTER DATABASE [U201715959] SET ANSI_PADDING OFF
GO
ALTER DATABASE [U201715959] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [U201715959] SET ARITHABORT OFF
GO
ALTER DATABASE [U201715959] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [U201715959] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [U201715959] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [U201715959] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [U201715959] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [U201715959] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [U201715959] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [U201715959] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [U201715959] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [U201715959] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [U201715959] SET DISABLE_BROKER
GO
ALTER DATABASE [U201715959] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [U201715959] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [U201715959] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [U201715959] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [U201715959] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [U201715959] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [U201715959] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [U201715959] SET READ_WRITE
GO
ALTER DATABASE [U201715959] SET RECOVERY FULL
GO
ALTER DATABASE [U201715959] SET MULTI_USER
GO
ALTER DATABASE [U201715959] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [U201715959] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N\'U201715959\', N\'ON\'
GO
USE [U201715959]
GO
/****** Object: Table [dbo].[Customer] Script Date: 12/12/2019 17:34:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Customer]\') AND type in (N\'U\'))
DROP TABLE [dbo].[Customer]
GO
/****** Object: Table [dbo].[Hall] Script Date: 12/12/2019 17:34:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Hall]\') AND type in (N\'U\'))
DROP TABLE [dbo].[Hall]
GO
/****** Object: Table [dbo].[Movie] Script Date: 12/12/2019 17:34:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Movie]\') AND type in (N\'U\'))
DROP TABLE [dbo].[Movie]
GO
/****** Object: Table [dbo].[Schedule] Script Date: 12/12/2019 17:34:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Schedule]\') AND type in (N\'U\'))
DROP TABLE [dbo].[Schedule]
GO
/****** Object: Table [dbo].[Ticket] Script Date: 12/12/2019 17:34:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Ticket]\') AND type in (N\'U\'))
DROP TABLE [dbo].[Ticket]
GO
/****** Object: User [U201715959] Script Date: 12/12/2019 17:34:20 ******/
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N\'U201715959\')
DROP USER [U201715959]
GO
/****** Object: User [U201715959] Script Date: 12/12/2019 17:34:20 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N\'U201715959\')
CREATE USER [U201715959] FOR LOGIN [U201715959] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: Table [dbo].[Ticket] Script Date: 12/12/2019 17:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Ticket]\') AND type in (N\'U\'))
BEGIN
CREATE TABLE [dbo].[Ticket](
[TicketID] [int] IDENTITY(1,1) NOT NULL,
[ScheduleID] [int] NULL,
[DetailSeat] [nvarchar](50) NULL,
CONSTRAINT [PK_Ticket] PRIMARY KEY CLUSTERED
(
[TicketID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[Ticket] ON
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (1, 5, N\'1-1\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (2, 5, N\'1-2\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (3, 1, N\'3-4\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (4, 5, N\'1-3\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (5, 5, N\'3-1\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (6, 18, N\'1-1\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (7, 4, N\'1-1\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (8, 4, N\'1-2\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (9, 5, N\'1-4\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (10, 5, N\'1-5\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (11, 5, N\'1-6\')
INSERT [dbo].[Ticket] ([TicketID], [ScheduleID], [DetailSeat]) VALUES (12, 5, N\'2-6\')
SET IDENTITY_INSERT [dbo].[Ticket] OFF
/****** Object: Table [dbo].[Schedule] Script Date: 12/12/2019 17:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Schedule]\') AND type in (N\'U\'))
BEGIN
CREATE TABLE [dbo].[Schedule](
[ScheduleID] [int] IDENTITY(1,1) NOT NULL,
[MovieID] [int] NULL,
[HallID] [int] NULL,
[Price] [int] NULL,
[DateTime] [nvarchar](50) NULL,
CONSTRAINT [PK_Schedule] PRIMARY KEY CLUSTERED
(
[ScheduleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[Schedule] ON
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (1, 4, 1, 32, N\'12-06 9:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (2, 2, 1, 35, N\'12-06 10:40\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (3, 3, 1, 45, N\'12-06 13:10\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (4, 5, 1, 38, N\'12-06 15:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (5, 1, 1, 35, N\'12-06 18:00\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (6, 5, 1, 40, N\'12-06 20:10\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (7, 3, 1, 36, N\'12-06 22:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (8, 3, 2, 36, N\'12-06 9:25\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (9, 5, 2, 36, N\'12-06 11:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (10, 4, 2, 40, N\'12-06 13:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (11, 2, 2, 36, N\'12-06 15:40\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (12, 2, 2, 40, N\'12-06 17:55\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (13, 3, 2, 36, N\'12-06 20:10\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (14, 1, 2, 36, N\'12-06 10:20\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (15, 5, 3, 100, N\'12-06 13:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (16, 3, 3, 100, N\'12-06 15:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (17, 2, 3, 100, N\'12-06 20:05\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (18, 1, 3, 100, N\'12-05 10:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (19, 4, 3, 100, N\'12-05 15:30\')
INSERT [dbo].[Schedule] ([ScheduleID], [MovieID], [HallID], [Price], [DateTime]) VALUES (20, 5, 3, 100, N\'12-05 20:20\')
SET IDENTITY_INSERT [dbo].[Schedule] OFF
/****** Object: Table [dbo].[Movie] Script Date: 12/12/2019 17:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Movie]\') AND type in (N\'U\'))
BEGIN
CREATE TABLE [dbo].[Movie](
[MovieID] [int] IDENTITY(1,1) NOT NULL,
[MovieName] [nvarchar](50) NULL,
[Actor] [nvarchar](50) NULL,
[Director] [nvarchar](50) NULL,
[Duration] [int] NULL,
[MovieType] [nvarchar](50) NULL,
[Poster] [nvarchar](50) NULL,
CONSTRAINT [PK_Movie] PRIMARY KEY CLUSTERED
(
[MovieID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[Movie] ON
INSERT [dbo].[Movie] ([MovieID], [MovieName], [Actor], [Director], [Duration], [MovieType], [Poster]) VALUES (1, N\'海蒂和爷爷\', N\'阿努克·斯特芬\', N\'阿兰·葛斯彭纳\', 111, N\'剧情、家庭\', N\'海蒂和爷爷.jpg\')
INSERT [dbo].[Movie] ([MovieID], [MovieName], [Actor], [Director], [Duration], [MovieType], [Poster]) VALUES (2, N\'海上钢琴师\', N\'蒂姆·罗斯\', N\'吉赛贝·托纳多雷\', 125, N\'剧情\', N\'海上钢琴师.jpg\')
INSERT [dbo].[Movie] ([MovieID], [MovieName], [Actor], [Director], [Duration], [MovieType], [Poster]) VALUES (3, N\'冰雪奇缘2\', N\'安娜、艾莎\', N\'詹妮弗·李\', 112, N\'喜剧，冒险\', N\'冰雪奇缘.jpg\')
INSERT [dbo].[Movie] ([MovieID], [MovieName], [Actor], [Director], [Duration], [MovieType], [Poster]) VALUES (4, N\'夏目友人帐\', N\'井上和彦\', N\'大森贵弘\', 106, N\'妖怪，治愈，温暖\', N\'夏目友人帐.jpg\')
INSERT [dbo].[Movie] ([MovieID], [MovieName], [Actor], [Director], [Duration], [MovieType], [Poster]) VALUES (5, N\'利刃出鞘\', N\'丹尼尔·克雷格\', N\'莱恩·约翰逊\', 130, N\'喜剧 、悬疑 、犯罪\', N\'利刃出鞘.jpg\')
SET IDENTITY_INSERT [dbo].[Movie] OFF
/****** Object: Table [dbo].[Hall] Script Date: 12/12/2019 17:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Hall]\') AND type in (N\'U\'))
BEGIN
CREATE TABLE [dbo].[Hall](
[HallID] [int] IDENTITY(1,1) NOT NULL,
[rowsCount] [int] NULL,
[colsCount] [int] NULL,
CONSTRAINT [PK_Hall] PRIMARY KEY CLUSTERED
(
[HallID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[Hall] ON
INSERT [dbo].[Hall] ([HallID], [rowsCount], [colsCount]) VALUES (1, 7, 4)
INSERT [dbo].[Hall] ([HallID], [rowsCount], [colsCount]) VALUES (2, 7, 4)
INSERT [dbo].[Hall] ([HallID], [rowsCount], [colsCount]) VALUES (3, 7, 4)
SET IDENTITY_INSERT [dbo].[Hall] OFF
/****** Object: Table [dbo].[Customer] Script Date: 12/12/2019 17:34:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N\'[dbo].[Customer]\') AND type in (N\'U\'))
BEGIN
CREATE TABLE [dbo].[Customer](
[CustomerID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](50) NULL,
[PassWord] [nvarchar](50) NULL,
CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
(
[CustomerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[Customer] ON
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (1, N\'张三\', N\'123456\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (2, N\'小兔子\', N\'123456\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (3, N\'lalala\', N\'123\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (4, N\'可爱宋\', N\'123456\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (5, N\'可爱郝\', N\'123456\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (6, N\'小名\', N\'123\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (7, N\'Angela\', N\'1234567\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (8, N\'小张\', N\'123\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (9, N\'123\', N\'123\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (10, N\'12345\', N\'123\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (11, N\'445\', N\'234\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (12, N\'黎明\', N\'111\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (13, N\'Lina\', N\'666666\')
INSERT [dbo].[Customer] ([CustomerID], [UserName], [PassWord]) VALUES (14, N\'酷酷酷\', N\'111\')
SET IDENTITY_INSERT [dbo].[Customer] OFF
版权声明：本文为dengfaheng原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。