AngelRM_MVC-master.zip

USE [angelmvc] GO /****** Object: Table [dbo].[t_fileinfo] Script Date: 08/06/2020 18:58:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[t_fileinfo]( [id] [int] IDENTITY(1,1) NOT NULL, [FileName] [nvarchar](200) NULL, [DownLoadLink] [nvarchar](200) NULL, [Remak] [nvarchar](max) NULL, [CreateDate] [datetime2](7) NULL, [CreateUserId] [int] NULL, [CreateUserName] [nvarchar](50) NULL, [ModifyDate] [datetime2](7) NULL, [ModifyUserId] [int] NULL, [ModifyUserName] [nvarchar](50) NULL, CONSTRAINT [PK__t_filein__3213E83F2A4B4B5E] PRIMARY KEY CLUSTERED ( [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 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录代码 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_fileinfo', @level2type=N'COLUMN',@level2name=N'id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_fileinfo', @level2type=N'COLUMN',@level2name=N'FileName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下载链接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_fileinfo', @level2type=N'COLUMN',@level2name=N'DownLoadLink' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_fileinfo', @level2type=N'COLUMN',@level2name=N'Remak' GO SET IDENTITY_INSERT [dbo].[t_fileinfo] ON INSERT [dbo].[t_fileinfo] ([id], [FileName], [DownLoadLink], [Remak], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName]) VALUES (102, N'指标上报时间_指标负责人_联系电话.xlsx', N'UploadFiles/admin', NULL, CAST(0x0780F0C05CBC803D0B AS DateTime2), 1, N'admin', NULL, NULL, NULL) INSERT [dbo].[t_fileinfo] ([id], [FileName], [DownLoadLink], [Remak], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName]) VALUES (103, N'联系电话.xlsx', N'UploadFiles/admin', NULL, CAST(0x0780F0C05CBC803D0B AS DateTime2), 1, N'admin', NULL, NULL, NULL) INSERT [dbo].[t_fileinfo] ([id], [FileName], [DownLoadLink], [Remak], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate], [ModifyUserId], [ModifyUserName]) VALUES (104, N'指标负责人_联系电话.xlsx', N'UploadFiles/admin', NULL, CAST(0x0780F0C05CBC803D0B AS DateTime2), 1, N'admin', NULL, NULL, NULL) SET IDENTITY_INSERT [dbo].[t_fileinfo] OFF /****** Object: Table [dbo].[city] Script Date: 08/06/2020 18:58:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[city]( [ID] [int] IDENTITY(1,1) NOT NULL, [CITYNAME] [nvarchar](10) NULL ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[city] ON INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (1, N'安徽') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (2, N'北京') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (3, N'福建') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (4, N'甘肃') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (5, N'广东') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (6, N'广西') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (7, N'贵州') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (8, N'海南') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (9, N'河北') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (10, N'河南') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (11, N'黑龙江') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (12, N'湖北') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (13, N'湖南') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (14, N'吉林') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (15, N'江苏') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (16, N'江西') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (17, N'辽宁') INSERT [dbo].[city] ([ID], [CITYNAME]) VALUES (18, N'内蒙古') INSERT [dbo].[city] ([ID],�