# SmartParking2024

**Repository Path**: scada_2/smart-parking2024

## Basic Information

- **Project Name**: SmartParking2024
- **Description**: 单体架构停车场项目
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 5
- **Forks**: 5
- **Created**: 2024-09-09
- **Last Updated**: 2025-12-08

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SmartParking
WPF + Prism + NetCore + EF Core 停车场实战 

解决方案：XH.SmartParking这个里面

使用之前修改数据库配置字符串：在DbContext中

初始化数据表格：

auto_register

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[auto_register]    Script Date: 2024/9/14 22:11:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[auto_register]') AND type in (N'U'))
DROP TABLE [dbo].[auto_register]
GO

/****** Object:  Table [dbo].[auto_register]    Script Date: 2024/9/14 22:11:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[auto_register](
	[auto_id] [int] IDENTITY(1,1) NOT NULL,
	[auto_license] [nvarchar](max) NOT NULL,
	[license_color_id] [int] NOT NULL,
	[license_type] [int] NOT NULL,
	[auto_color_id] [int] NOT NULL,
	[fee_mode_id] [int] NOT NULL,
	[description] [nvarchar](max) NULL,
	[state] [int] NOT NULL,
	[valid_count] [int] NULL,
	[valid_end_time] [nvarchar](max) NULL,
	[valid_start_time] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[auto_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
```

base_auto_color 

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[base_auto_color]    Script Date: 2024/9/14 22:12:47 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[base_auto_color]') AND type in (N'U'))
DROP TABLE [dbo].[base_auto_color]
GO

/****** Object:  Table [dbo].[base_auto_color]    Script Date: 2024/9/14 22:12:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[base_auto_color](
	[color_id] [int] NOT NULL,
	[color_name] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[color_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
```

base_fee_mode 

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[base_fee_mode]    Script Date: 2024/9/14 22:13:52 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[base_fee_mode]') AND type in (N'U'))
DROP TABLE [dbo].[base_fee_mode]
GO

/****** Object:  Table [dbo].[base_fee_mode]    Script Date: 2024/9/14 22:13:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[base_fee_mode](
	[fee_mode_id] [int] NOT NULL,
	[fee_mode_name] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[fee_mode_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

```

base_license_color

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[base_license_color]    Script Date: 2024/9/14 22:14:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[base_license_color]') AND type in (N'U'))
DROP TABLE [dbo].[base_license_color]
GO

/****** Object:  Table [dbo].[base_license_color]    Script Date: 2024/9/14 22:14:26 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[base_license_color](
	[color_id] [int] NOT NULL,
	[color_name] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[color_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


```

base_license_type

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[base_license_type]    Script Date: 2024/9/14 22:14:36 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[base_license_type]') AND type in (N'U'))
DROP TABLE [dbo].[base_license_type]
GO

/****** Object:  Table [dbo].[base_license_type]    Script Date: 2024/9/14 22:14:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[base_license_type](
	[type_id] [int] NOT NULL,
	[type_name] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[type_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


```

device_info

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[device_info]    Script Date: 2024/9/14 22:15:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[device_info]') AND type in (N'U'))
DROP TABLE [dbo].[device_info]
GO

/****** Object:  Table [dbo].[device_info]    Script Date: 2024/9/14 22:15:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[device_info](
	[device_id] [int] IDENTITY(1,1) NOT NULL,
	[device_name] [varchar](50) NOT NULL,
	[addr_ip] [varchar](30) NULL,
	[addr_port] [int] NULL,
	[addr_com] [varchar](10) NULL,
	[password] [varchar](50) NULL,
	[username] [varchar](50) NULL,
	[addr_url1] [varchar](300) NULL,
	[addr_url2] [varchar](300) NULL,
	[addr_url3] [varchar](300) NULL,
	[desc] [varchar](300) NULL,
PRIMARY KEY CLUSTERED 
(
	[device_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

member_recharge

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[member_recharge]    Script Date: 2024/9/14 22:15:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[member_recharge]') AND type in (N'U'))
DROP TABLE [dbo].[member_recharge]
GO

/****** Object:  Table [dbo].[member_recharge]    Script Date: 2024/9/14 22:15:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[member_recharge](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[auto_lisence] [varchar](15) NOT NULL,
	[fee_mode_id] [int] NOT NULL,
	[recharge_count] [int] NULL,
	[recharge_start_time] [varchar](20) NULL,
	[recharge_end_time] [varchar](20) NULL,
	[state] [int] NOT NULL,
	[create_time] [varchar](20) NOT NULL,
	[create_id] [int] NOT NULL,
	[create_name] [varchar](50) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

menus

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[menus]    Script Date: 2024/9/14 22:15:30 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[menus]') AND type in (N'U'))
DROP TABLE [dbo].[menus]
GO

/****** Object:  Table [dbo].[menus]    Script Date: 2024/9/14 22:15:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[menus](
	[menu_id] [int] NOT NULL,
	[menu_header] [varchar](50) NULL,
	[target_view] [varchar](50) NULL,
	[parent_id] [int] NULL,
	[menu_icon] [varchar](50) NULL,
	[_index] [int] NULL,
	[menu_type] [int] NULL,
	[state] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[menu_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

order

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[order]    Script Date: 2024/9/14 22:15:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[order]') AND type in (N'U'))
DROP TABLE [dbo].[order]
GO

/****** Object:  Table [dbo].[order]    Script Date: 2024/9/14 22:15:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[order](
	[order_id] [int] IDENTITY(1,1) NOT NULL,
	[auto_license] [nvarchar](20) NULL,
	[enter_time] [nvarchar](20) NULL,
	[leave_time] [nvarchar](20) NULL,
	[fee_mode_id] [int] NULL,
	[state] [int] NULL,
	[payable] [float] NULL,
	[payment] [float] NULL,
	[discount] [float] NULL,
	[enter_record] [int] NULL,
	[exit_record] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[order_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

record

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[record]    Script Date: 2024/9/14 22:15:51 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[record]') AND type in (N'U'))
DROP TABLE [dbo].[record]
GO

/****** Object:  Table [dbo].[record]    Script Date: 2024/9/14 22:15:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[record](
	[record_id] [int] IDENTITY(1,1) NOT NULL,
	[auto_license] [nvarchar](20) NULL,
	[pass_time] [nvarchar](20) NULL,
	[channal] [int] NULL,
	[car_color] [int] NOT NULL,
	[license_color] [int] NOT NULL,
	[img_full] [nvarchar](50) NULL,
	[img_small] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[record_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

role_menu

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[role_menu]    Script Date: 2024/9/14 22:16:14 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[role_menu]') AND type in (N'U'))
DROP TABLE [dbo].[role_menu]
GO

/****** Object:  Table [dbo].[role_menu]    Script Date: 2024/9/14 22:16:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[role_menu](
	[role_id] [int] NOT NULL,
	[menu_id] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[role_id] ASC,
	[menu_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

role_user

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[role_user]    Script Date: 2024/9/14 22:16:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[role_user]') AND type in (N'U'))
DROP TABLE [dbo].[role_user]
GO

/****** Object:  Table [dbo].[role_user]    Script Date: 2024/9/14 22:16:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[role_user](
	[user_id] [int] NOT NULL,
	[role_id] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[role_id] ASC,
	[user_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

SysRole

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[SysRole]    Script Date: 2024/9/14 22:16:40 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SysRole]') AND type in (N'U'))
DROP TABLE [dbo].[SysRole]
GO

/****** Object:  Table [dbo].[SysRole]    Script Date: 2024/9/14 22:16:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SysRole](
	[role_id] [int] IDENTITY(1,1) NOT NULL,
	[role_name] [nvarchar](50) NOT NULL,
	[role_desc] [nvarchar](200) NULL,
	[state] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[role_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO


```

SysUser

```
USE [XHSmartParking]
GO

/****** Object:  Table [dbo].[SysUser]    Script Date: 2024/9/14 22:16:52 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SysUser]') AND type in (N'U'))
DROP TABLE [dbo].[SysUser]
GO

/****** Object:  Table [dbo].[SysUser]    Script Date: 2024/9/14 22:16:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SysUser](
	[UserId] [int] NOT NULL,
	[UserName] [nvarchar](50) NULL,
	[CompanyId] [int] NULL,
	[Password] [nvarchar](50) NULL,
	[Avatar] [nvarchar](50) NULL,
	[Status] [int] NULL,
	[Phone] [nvarchar](50) NULL,
	[Mobile] [nvarchar](50) NULL,
	[Address] [nvarchar](50) NULL,
	[Email] [nvarchar](50) NULL,
	[QQ] [nvarchar](50) NULL,
	[WeChat] [nvarchar](50) NULL,
	[Gender] [int] NULL,
	[LastLoginTime] [nvarchar](50) NULL,
	[CreateTime] [nvarchar](50) NULL,
	[CreateId] [int] NULL,
	[LastModifyTime] [nvarchar](50) NULL,
	[LastModifyId] [int] NULL,
	[RealName] [nvarchar](50) NULL,
	[UserIcon] [nvarchar](50) NULL,
	[Age] [int] NULL
) ON [PRIMARY]
GO


```