vol.core 框架代码生成

1.建立表格

USE [netcoredev]
GO
/****** Object:  Table [dbo].[Cartype]    Script Date: 2024/11/2 18:40:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Cartype](
	[Cartype_Id] [int] IDENTITY(1,1) NOT NULL,
	[chexing] [nvarchar](50) NULL,
	[engine] [nvarchar](50) NULL,
	[mali] [nvarchar](50) NULL,
	[pailiang] [nvarchar](50) NULL,
	[gangcount] [nvarchar](50) NULL,
	[pic1] [nvarchar](300) NULL,
	[pic2] [nvarchar](300) NULL,
	[memo] [nvarchar](300) NULL,
	[filtermodel] [nvarchar](500) NULL,
 CONSTRAINT [PK_cartype] PRIMARY KEY CLUSTERED 
(
	[Cartype_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  View [dbo].[ViewCartype]    Script Date: 2024/11/2 18:40:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ViewCartype]
AS
SELECT   dbo.Cartype.*
FROM      dbo.Cartype

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'Cartype_Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'chexing'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发动机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'engine'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'马力' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'mali'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'pailiang'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缸数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'gangcount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'pic1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'pic2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'memo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'滤清器' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cartype', @level2type=N'COLUMN',@level2name=N'filtermodel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewCartype'
GO

2.登录后台生成代码

2.1 生成代码

在后台点击系统菜单 “代码生成”之下的“代码生成”条目，

2.2 生成菜单

类似这样 vue路径表 在“Vol.Vue3版本\src\router\viewGird.js"文件中。

3.重新加截程序