ASP.NET/C# 电子商务系统

CREATE DATABASE EntLibShopping GO USE EntLibShopping GO if exists (select * from sysobjects where id = OBJECT_ID('[Ent_Adv_Question]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Ent_Adv_Question] CREATE TABLE [Ent_Adv_Question] ( [SysNo] [int] IDENTITY (1, 1) NOT NULL , [ActivityName] [nvarchar] (100) NOT NULL , [CreateUserSysNo] [int] NOT NULL , [StartTime] [datetime] NOT NULL , [EndTime] [datetime] NOT NULL ) ALTER TABLE [Ent_Adv_Question] WITH NOCHECK ADD CONSTRAINT [PK_Ent_Adv_Question] PRIMARY KEY NONCLUSTERED ( [SysNo] ) SET IDENTITY_INSERT [Ent_Adv_Question] ON INSERT [Ent_Adv_Question] ( [SysNo] , [ActivityName] , [CreateUserSysNo] , [StartTime] , [EndTime] ) VALUES ( 9 , 'GiftCenter.cn 促销-有奖问答' , 23 , '2007-07-26 23:59:03.000' , '2010-10-01 00:00:00.000' ) SET IDENTITY_INSERT [Ent_Adv_Question] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Ent_Adv_Question_Customer]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Ent_Adv_Question_Customer] CREATE TABLE [Ent_Adv_Question_Customer] ( [SysNo] [int] IDENTITY (1, 1) NOT NULL , [ActivitySysNo] [int] NOT NULL , [CustomerSysNo] [int] NOT NULL , [CreateTime] [datetime] NOT NULL ) ALTER TABLE [Ent_Adv_Question_Customer] WITH NOCHECK ADD CONSTRAINT [PK_Ent_Adv_Question_Customer] PRIMARY KEY NONCLUSTERED ( [SysNo] ) SET IDENTITY_INSERT [Ent_Adv_Question_Customer] ON INSERT [Ent_Adv_Question_Customer] ( [SysNo] , [ActivitySysNo] , [CustomerSysNo] , [CreateTime] ) VALUES ( 1 , 9 , 1 , '2007-07-27 08:52:12.407' ) SET IDENTITY_INSERT [Ent_Adv_Question_Customer] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Ent_Adv_Question_Item]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Ent_Adv_Question_Item] CREATE TABLE [Ent_Adv_Question_Item] ( [SysNo] [int] IDENTITY (1, 1) NOT NULL , [ActivitySysNo] [int] NOT NULL , [Question] [varchar] (100) NOT NULL , [QuestionType] [int] NOT NULL , [Option1] [varchar] (100) NOT NULL , [Option2] [varchar] (100) NULL , [Option3] [varchar] (100) NULL , [Option4] [varchar] (100) NULL , [Option5] [varchar] (100) NULL , [Option6] [varchar] (100) NULL , [Answer] [varchar] (10) NOT NULL ) ALTER TABLE [Ent_Adv_Question_Item] WITH NOCHECK ADD CONSTRAINT [PK_Ent_Adv_Question_Item] PRIMARY KEY NONCLUSTERED ( [SysNo] ) SET IDENTITY_INSERT [Ent_Adv_Question_Item] ON INSERT [Ent_Adv_Question_Item] ( [SysNo] , [ActivitySysNo] , [Question] , [QuestionType] , [Option1] , [Option2] , [Option3] , [Option4] , [Answer] ) VALUES ( 19 , 9 , 'GiftCenter.cn 中文称谓' , 0 , '礼品世界' , '礼品中心' , '礼品玩具' , '礼品城' , 'B' ) INSERT [Ent_Adv_Question_Item] ( [SysNo] , [ActivitySysNo] , [Question] , [QuestionType] , [Option1] , [Option2] , [Option3] , [Option4] , [Answer] ) VALUES ( 20 , 9 , 'GiftCenter.cn 是' , 0 , '中国最大的图书交易中心' , '中国最大的IT产品商务网站之一' , '中国最大的礼品交易网站之一' , '中国最大的儿童玩具商务网站之一' , 'C' ) SET IDENTITY_INSERT [Ent_Adv_Question_Item] OFF if exists (select * from sysobjects where id = OBJECT_ID('[Ent_Area]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [Ent_Area] CREATE TABLE [Ent_Area] ( [SysNo] [int] NOT NULL , [ProvinceSysNo] [int] NULL , [CitySysNo] [int] NULL , [ProvinceName] [nvarchar] (20) NOT NULL , [CityName] [nvarchar] (20) NULL , [DistrictName] [nvarchar] (200) NULL , [OrderNumber] [nvarchar] (20) NOT NULL , [IsLocal] [int] NOT NULL , [Status] [int] NOT NULL ) ALTER TABLE [Ent_Area] WITH NOCHECK ADD CONSTRAINT [DF_Ent_Area_OrderNumber] DEFAULT ('') FOR [OrderNumber],CONSTRAINT [PK_Ent_Area] PRIMARY KEY NONCLUSTERED ( [SysNo] ) INSERT [Ent_Area] ( [SysNo] , [ProvinceName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 1 , '安徽省' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [ProvinceName] , [CityName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 2 , 1 , '安徽省' , '合肥市' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 3 , 1 , 2 , '安徽省' , '合肥市' , '瑶海区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 4 , 1 , 2 , '安徽省' , '合肥市' , '庐阳区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 5 , 1 , 2 , '安徽省' , '合肥市' , '蜀山区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 6 , 1 , 2 , '安徽省' , '合肥市' , '包河区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 7 , 1 , 2 , '安徽省' , '合肥市' , '肥东县' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 8 , 1 , 2 , '安徽省' , '合肥市' , '肥西县' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 9 , 1 , 2 , '安徽省' , '合肥市' , '长丰县' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [ProvinceName] , [CityName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 13 , 1 , '安徽省' , '淮南市' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 14 , 1 , 13 , '安徽省' , '淮南市' , '田家庵区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 15 , 1 , 13 , '安徽省' , '淮南市' , '大通区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 16 , 1 , 13 , '安徽省' , '淮南市' , '谢家集区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 17 , 1 , 13 , '安徽省' , '淮南市' , '八公山区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 18 , 1 , 13 , '安徽省' , '淮南市' , '潘集区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 20 , 1 , 13 , '安徽省' , '淮南市' , '凤台县' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [ProvinceName] , [CityName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 21 , 1 , '安徽省' , '淮北市' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 22 , 1 , 21 , '安徽省' , '淮北市' , '相山区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 23 , 1 , 21 , '安徽省' , '淮北市' , '杜集区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 24 , 1 , 21 , '安徽省' , '淮北市' , '烈山区' , '' , 0 , 0 ) INSERT [Ent_Area] ( [SysNo] , [ProvinceSysNo] , [CitySysNo] , [ProvinceName] , [CityName] , [DistrictName] , [OrderNumber] , [IsLocal] , [Status] ) VALUES ( 25 , 1 , 21 , '安