# CarparkIMS

**Repository Path**: gitmy/CarparkIMS

## Basic Information

- **Project Name**: CarparkIMS
- **Description**: 车场计时系统 方案包括所有项目
- **Primary Language**: C#
- **License**: Zlib
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2025-10-23
- **Last Updated**: 2025-10-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## CarparkIMS
 
 
CarparkIMS_CMS 前端
 
CarparkBusiness 后端


## CarparkiMS_CMS
1. 裝個CMS web  落iMS 部機到
1. nav. /CamearSetting/Index to add camera door mapping
1. nav. to / add car license plate and card number mapping
1. cam 裝vaxtor ANPR app
1. in vaxtor ANPR app, reporting -> JSON
1. Check Active
1. Set URL To http://{{IP}}/PlateReturn
1. Set Message to{ "plate":"$plate$", "date":"$date$", "country":"$country$", "confidence":"$confidence$", "ip":"$ip$"，“ParkingNoCalcType”：0} 具体看看 Vaxtar.json
1. “ParkingNoCalcType”：0 表示車位計時模式的log記錄。其他值保留其他用途，1表示停車場出入記錄。
1. 支cam認完車牌會經api 俾個車牌號碼出黎
1. CarparkiMS_CMS會check吓個車牌號碼 && iMS USER 存唔存在
1. 存在->叫iMS 開門
1. 圖片->img 文件夾下按日期分類 例如./img/20260930/123456.jpg  固定格式是jpg
1. DEMO圖片->img 文件夾下缺失圖片，則調用./SampleNumberPlate.jpg
1. 後端設置->https://localhost:5001/camerasetting  設置測試參數 鏡頭IP等等
## DB Setup 
```
USE [iMS_7f]
GO

/****** Object:  Table [dbo].[llqqCameraDoorMapping]    Script Date: 11/14/2022 11:04:56 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[llqqCameraDoorMapping](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CameraIP] [nvarchar](50) NOT NULL,
	[DoorID] [int] NOT NULL,
	[TransactionTypeID] [int] NOT NULL,
	[Deleted] [bit] NOT NULL,
	[ParkingPlaceId] [nvarchar](256) NULL,
	[ParkingPlaceSharpNumber] [nvarchar](256) NULL,
 CONSTRAINT [PK_llqqCameraDoorMapping] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'program create a random number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'llqqCameraDoorMapping', @level2type=N'COLUMN',@level2name=N'ParkingPlaceId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'suggest the number with  #  like #1 by user manual input' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'llqqCameraDoorMapping', @level2type=N'COLUMN',@level2name=N'ParkingPlaceSharpNumber'
GO

USE [iMS_7f]
GO

/****** Object:  Table [dbo].[llqqNumberPlate]    Script Date: 11/14/2022 11:05:39 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[llqqNumberPlate](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[NumberPlate] [nvarchar](max) NULL,
	[ParkingPlaceId] [nchar](10) NULL,
	[LogIdOfStart] [int] NULL,
	[StartDatetime] [datetime] NULL,
	[LogIdOfEnd] [int] NULL,
	[EndDatetime] [datetime] NULL,
	[InteralTimes] [int] NULL,
 CONSTRAINT [PK_llqqNumberPlate] 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] TEXTIMAGE_ON [PRIMARY]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'null = 0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'llqqNumberPlate', @level2type=N'COLUMN',@level2name=N'LogIdOfStart'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'null = 0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'llqqNumberPlate', @level2type=N'COLUMN',@level2name=N'LogIdOfEnd'
GO

USE [iMS_7f]
GO

/****** Object:  Table [dbo].[llqqPlateLog]    Script Date: 11/14/2022 11:05:54 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[llqqPlateLog](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[plate] [nvarchar](max) NOT NULL,
	[date] [nvarchar](50) NOT NULL,
	[confidence] [int] NOT NULL,
	[ip] [nvarchar](50) NOT NULL,
	[createdOn] [datetime] NOT NULL,
	[image64] [nvarchar](max) NULL,
	[isValid] [bit] NULL,
 CONSTRAINT [PK_llqqPlateLog] 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] TEXTIMAGE_ON [PRIMARY]
GO

USE [iMS_7f]
GO

/****** Object:  Table [dbo].[llqqPlateMapping]    Script Date: 11/14/2022 11:06:07 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[llqqPlateMapping](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NULL,
	[CardID] [nvarchar](250) NOT NULL,
	[PlateNo] [nvarchar](50) NOT NULL,
	[Deleted] [bit] NOT NULL,
 CONSTRAINT [PK_llqqPlateMapping] 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


```
//DbContextOptions<IMSContext> dbContextOption = new DbContextOptions<IMSContext>();
//DbContextOptionsBuilder<IMSContext> dbContextOptionBuilder = new DbContextOptionsBuilder<IMSContext>(dbContextOption);
//Context = new IMSContext(dbContextOptionBuilder.UseSqlServer(Configuration.GetConnectionString("IMSDatabase")).Options);

//Setting Here
//var parkingSetting = Configuration.GetSection("ParkingSetting").Get<ParkingSetting>();