項目還在開發中。不少的模塊還沒有實現。參考網站：革西網絡
我今天把創建數據庫的sql語句給貼出來，大家生成之后修改一下web.config試試看。
表在設計上也有不妥的地方，先這樣吧。
CREATE TABLE [dbo].[AdminInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](50) NULL, [Pwd] [varchar](50) NULL, CONSTRAINT [PK_AdminInfo] 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]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[BannerInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[BannerInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](50) NULL, [KeyWord] [varchar](200) NULL, [Abstract] [varchar](500) NULL, [BannerContent] [ntext] NULL, [ImgName] [varchar](200) NULL, [ImgDec] [varchar](200) NULL, [BannerUrl] [varchar](200) NULL, [BannerRank] [int] NULL, [BannerSource] [varchar](50) NULL, [BannerAuthor] [varchar](50) NULL, [BannerAddTime] [datetime] NULL, [Ichecksign] [int] NULL, [UrlOrBanner] [int] NULL, [BannerType] [int] NULL, CONSTRAINT [PK_BannerInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[CarInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[CarInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [CarTypeId] [int] NULL, [CarTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Price] [int] NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_CarInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[CoOperation] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Cooperation]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, [Url] [varchar](100) NULL, [ImgInfo] [varchar](100) NULL, [ImgDec] [varchar](100) NULL, [Ichecksign] [int] NULL, [AddTime] [datetime] NULL, [TypeId] [int] NULL, [ContentInfo] [ntext] NULL, CONSTRAINT [PK_Cooperation] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[EducationInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[EducationInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [EducationTypeId] [int] NULL, [EducationTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Price] [int] NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_EducationInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[EntertainmentInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[EntertainmentInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [EntertainmentTypeId] [int] NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Price] [int] NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_EntertainmentInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[FashionInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[FashionInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [FashionTypeId] [int] NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_FashionInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[FinanceInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[FinanceInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [FinanceTypeId] [int] NULL, [FinanceTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Price] [int] NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_FinanceInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[GexiInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING OFFGOCREATE TABLE [dbo].[GexiInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [SourceUrl] [varchar](200) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [NewsTypeId] [int] NULL, [NewsTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Price] [int] NULL, [Review] [int] NULL, CONSTRAINT [PK_GexiInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[GexiList] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[GexiList]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, [Profession] [varchar](200) NULL, [Reason] [varchar](200) NULL, [Motto] [varchar](200) NULL, [ContentInfo] [ntext] NULL, [KeyWord] [varchar](200) NULL, [Abstract] [varchar](200) NULL, [AddTime] [datetime] NULL, [Ichecksign] [int] NULL, [ImgName] [varchar](200) NULL, [ImgDec] [varchar](200) NULL, [UserRank] [int] NULL, CONSTRAINT [PK_GexiList] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[HistoryInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HistoryInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [HistoryTypeId] [int] NULL, [HistoryTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Price] [int] NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_HistoryInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[HotWorld] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HotWorld]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, [AddTime] [datetime] NULL, [Ichecksign] [int] NULL, [InfoDec] [varchar](50) NULL, CONSTRAINT [PK_HotWorld] 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]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[HouseInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HouseInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [HouseTypeId] [int] NULL, [HouseTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_HouseInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ImgSpecial] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ImgSpecial]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](50) NULL, [KeyWord] [varchar](50) NULL, [Summary] [varchar](50) NULL, [Source] [varchar](50) NULL, [Author] [varchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [varchar](50) NULL, [ImgDec] [varchar](50) NULL, [IsHotSpot] [int] NULL, CONSTRAINT [PK_ImgSpecial] 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]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ImgSpecialInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ImgSpecialInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](50) NULL, [KeyWord] [varchar](50) NULL, [Summary] [varchar](50) NULL, [SpecialTypeId] [int] NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [varchar](50) NULL, [ImgDec] [varchar](50) NULL, [Time] [datetime] NULL, CONSTRAINT [PK_ImgSpecialInfo] 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]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ImgWorld] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ImgWorld]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](50) NULL, [KeyWord] [varchar](50) NULL, [Summary] [varchar](50) NULL, [Source] [varchar](50) NULL, [Author] [varchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [varchar](50) NULL, [ImgDec] [varchar](50) NULL, [IsHotSpot] [int] NULL, CONSTRAINT [PK_ImgWorld] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[NewsInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[NewsInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](1000) NULL, [Source] [nvarchar](50) NULL, [SourceUrl] [varchar](200) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [NewsInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [NewsTypeId] [int] NULL, [NewsTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL CONSTRAINT [DF_NewsInfo_IsDelete] DEFAULT ((1)), [Sort] [int] NULL CONSTRAINT [DF_NewsInfo_Sort] DEFAULT ((0)), [ImgInfo] [nvarchar](500) NULL, [ImgDec] [nvarchar](500) NULL, [Price] [int] NULL CONSTRAINT [DF_NewsInfo_Price] DEFAULT ((0)), [Review] [int] NULL CONSTRAINT [DF_NewsInfo_Review] DEFAULT ((0)), [CreatUserId] [varchar](50) NULL, [CheckState] [int] NULL CONSTRAINT [DF_NewsInfo_CheckState] DEFAULT ((1)), CONSTRAINT [PK_NewsInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[NoticeInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[NoticeInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](200) NULL, [KeyWord] [varchar](200) NULL, [Summary] [varchar](200) NULL, [Author] [varchar](200) NULL, [AddTime] [datetime] NULL, [Ichecksign] [int] NULL, [IsHotSpot] [int] NULL, [ContentInfo] [ntext] NULL, [Hits] [int] NULL, [NoticeTypeId] [int] NULL, CONSTRAINT [PK_Notice] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[PriceInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[PriceInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [NewsTypeId] [int] NULL, [NewsId] [int] NULL, [UserId] [int] NULL, [IsDelete] [int] NULL, [Time] [datetime] NULL, [Ip] [varchar](50) NULL, CONSTRAINT [PK_PriceInfo] 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]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ReviewInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ReviewInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [NewsTypeId] [int] NULL, [NewsId] [int] NULL, [UserId] [int] NULL, [ContentInfo] [varchar](300) NULL, [Support] [int] NULL, [Against] [int] NULL, [IsDelete] [int] NULL, [Time] [datetime] NULL, [Ip] [varchar](50) NULL, CONSTRAINT [PK_ReviewInfo] 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]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[SearchDetails] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[SearchDetails]( [Id] [uniqueidentifier] NOT NULL, [KeyWords] [nvarchar](50) NULL, [SearchDateTime] [datetime] NULL, [IP] [varchar](50) NULL, CONSTRAINT [PK_SearchDetails] 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]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[SoulInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[SoulInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [SoulTypeId] [int] NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Review] [int] NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_SoulInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[TechInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[TechInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [SourceUrl] [varchar](200) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [TechTypeId] [int] NULL, [TechTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [Price] [int] NULL, [Review] [int] NULL, CONSTRAINT [PK_TechInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[TravelInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[TravelInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](80) NULL, [KeyWord] [nvarchar](80) NULL, [Summary] [nvarchar](500) NULL, [Source] [nvarchar](50) NULL, [Author] [nvarchar](50) NULL, [Time] [datetime] NULL, [Hits] [int] NULL, [ContentInfo] [ntext] NULL, [IsHotSpot] [int] NULL, [TravelTypeId] [int] NULL, [TravelTypeName] [nvarchar](50) NULL, [IsDelete] [int] NULL, [Sort] [int] NULL, [ImgInfo] [nvarchar](50) NULL, [ImgDec] [nvarchar](50) NULL, [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_TravelInfo] 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] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[UserInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[UserInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](50) NULL, [UserPwd] [varchar](50) NULL, [UserEmail] [varchar](50) NULL, [UserTel] [varchar](50) NULL, [UserNickname] [varchar](50) NULL, [UserSex] [varchar](50) NULL, [UserQQ] [varchar](50) NULL, [UserHometown] [varchar](50) NULL, [UserGrade] [int] NULL, [UserFraction] [int] NULL, [UserPassNo] [varchar](50) NULL, [Ichecksign] [int] NULL CONSTRAINT [DF_UserInfo_Ichecksign] DEFAULT ((1)), [UserState] [int] NULL, [UserImg] [varchar](50) NULL, [AddTime] [datetime] NULL, [IsAuthentication] [int] NULL, [Realname] [varchar](50) NULL, [IdentityId] [varchar](50) NULL, [BankId] [int] NULL, [BankNum] [varchar](50) NULL, [BankName] [varchar](50) NULL, [AlipayNum] [varchar](50) NULL, CONSTRAINT [PK_UserInfo] 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]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[ImgSpecialInfo] WITH CHECK ADD CONSTRAINT [FK_ImgSpecialInfo_ImgSpecial] FOREIGN KEY([SpecialTypeId])REFERENCES [dbo].[ImgSpecial] ([Id])GOALTER TABLE [dbo].[ImgSpecialInfo] CHECK CONSTRAINT [FK_ImgSpecialInfo_ImgSpecial]GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'合作方式1：合作 2友鏈' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cooperation', @level2type=N'COLUMN',@level2name=N'TypeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'革西光榮榜' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Name'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'職位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Profession'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入榜理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Reason'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'座右銘' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Motto'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'具體信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'ContentInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'簡介' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Abstract'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'頭像' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'ImgName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'頭像介紹alt' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'ImgDec'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'圖片專題（看圖說話）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ImgSpecial', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'圖片專題（子表）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ImgSpecialInfo', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'標題' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Title'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'關鍵字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'KeyWord'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'摘要' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Summary'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'來源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Source'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Author'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'發表時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Time'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'點擊量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Hits'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'內容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'NewsInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否是熱點' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'IsHotSpot'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新聞類型編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'NewsTypeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新聞類型名稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'NewsTypeName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否刪除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'IsDelete'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新聞排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Sort'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'圖片路徑' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'ImgInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'圖片描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'ImgDec'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'搜索的詞' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'KeyWords'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'搜索詞的時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'SearchDateTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'網站編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'IP'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密碼' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserPwd'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'郵箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserEmail'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'電話' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserTel'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'昵稱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserNickname'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性別' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserSex'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'qq' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserQQ'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'籍貫' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserHometown'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'等級' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserGrade'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'積分' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserFraction'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通行證' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserPassNo'GOUSE [master]GOALTER DATABASE [gexi] SET READ_WRITE GO把web.config中加密的部分修改一下，修改成本地數據庫連接即可:
<appSettings> <add key="ConStr" value="Data Source=.;Initial Catalog=gexi;Persist Security Info=True;UserID=gexi;Password=123456" /> <add key="GexinetUrl" value="http://www.gexinet.com" /> </appSettings>
新聞熱點
疑難解答
