ASP.net 星期三人才信息系统

if exists (select * from sysobjects where id = OBJECT_ID('[gl_admin]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [gl_admin] CREATE TABLE [gl_admin] ( [id] [int] NOT NULL, [name] [varchar] (20) NULL, [pwd] [varchar] (20) NULL, [ip] [varchar] (50) NULL, [fabu_date] [datetime] NULL) INSERT [gl_admin] ([id],[name],[pwd],[ip],[fabu_date]) VALUES ( 1,'cuizhanjun','3071907','127.0.0.1','2009-3-23 0:00:00') if exists (select * from sysobjects where id = OBJECT_ID('[gl_users]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [gl_users] CREATE TABLE [gl_users] ( [id] [int] NOT NULL, [cx_name] [varchar] (100) NULL, [cx_banben] [varchar] (100) NULL, [yuming] [varchar] (500) NULL, [sitekey] [varchar] (100) NULL, [kaitong_date] [datetime] NULL, [zuixin_date] [datetime] NULL, [mes] [text] NULL, [indexHtml] [text] NULL, [pingbi] [varchar] (2) NULL, [beizhu] [text] NULL, [ip] [varchar] (50) NULL) if exists (select * from sysobjects where id = OBJECT_ID('[rc_admin]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_admin] CREATE TABLE [rc_admin] ( [id] [int] NOT NULL, [name] [varchar] (20) NULL, [pwd] [varchar] (20) NULL, [ip] [varchar] (50) NULL, [fabu_date] [datetime] NULL, [type] [varchar] (50) NULL DEFAULT ('管理员|操作员')) ALTER TABLE [rc_admin] WITH NOCHECK ADD CONSTRAINT [PK_rc_admin] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_admin] ([id],[name],[pwd],[ip],[fabu_date],[type]) VALUES ( 1,'admin','admin','127.0.0.1','2009-3-23 0:00:00','管理员') if exists (select * from sysobjects where id = OBJECT_ID('[rc_diqv]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_diqv] CREATE TABLE [rc_diqv] ( [id] [int] NOT NULL, [name] [varchar] (50) NULL, [pr] [int] NULL DEFAULT (0), [isshow] [int] NULL) ALTER TABLE [rc_diqv] WITH NOCHECK ADD CONSTRAINT [PK_rc_diqv] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_diqv] ([id],[name],[pr],[isshow]) VALUES ( 0,'清苑',3,0) INSERT [rc_diqv] ([id],[name],[pr],[isshow]) VALUES ( 1,'保定',10,1) INSERT [rc_diqv] ([id],[name],[pr],[isshow]) VALUES ( 2,'满城',2,1) if exists (select * from sysobjects where id = OBJECT_ID('[rc_flash]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_flash] CREATE TABLE [rc_flash] ( [id] [int] NOT NULL, [name] [varchar] (100) NULL, [flashPic] [varchar] (200) NULL, [toUrl] [varchar] (200) NULL, [pr] [int] NULL, [isshow] [varchar] (50) NULL) ALTER TABLE [rc_flash] WITH NOCHECK ADD CONSTRAINT [PK_rc_flash] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_flash] ([id],[name],[flashPic],[toUrl],[pr],[isshow]) VALUES ( 1,'动漫清美','http://localhost:9778/xiaocui_rc/createhtml/20091108041259.jpg','http://www.qingmeicg.com/web/info/infolist_class1.htm?gclid=CMTYho_4-p0CFdMtpAodompWrw',0,'显示') INSERT [rc_flash] ([id],[name],[flashPic],[toUrl],[pr],[isshow]) VALUES ( 2,'第2个','http://localhost:9778/xiaocui_rc/createhtml/20091108041259.jpg','#',0,'显示') INSERT [rc_flash] ([id],[name],[flashPic],[pr],[isshow]) VALUES ( 3,'第3个','http://localhost:9778/xiaocui_rc/createhtml/20091108041259.jpg',0,'显示') if exists (select * from sysobjects where id = OBJECT_ID('[rc_guanggao_tupian]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_guanggao_tupian] CREATE TABLE [rc_guanggao_tupian] ( [id] [int] NOT NULL, [name] [varchar] (300) NULL, [tupianurl] [varchar] (500) NULL, [url] [varchar] (500) NULL, [pr] [int] NULL, [type] [varchar] (50) NULL) ALTER TABLE [rc_guanggao_tupian] WITH NOCHECK ADD CONSTRAINT [PK_rc_guanggao_tupian] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 1,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组2') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 3,'广告图片3','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 4,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 5,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 6,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 7,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 8,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 9,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 10,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 11,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 12,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 13,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 14,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 15,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 16,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 17,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 18,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 19,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 20,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 21,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 22,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') INSERT [rc_guanggao_tupian] ([id],[name],[tupianurl],[url],[pr],[type]) VALUES ( 23,'广告图片1','images/guanggao/guanggao_1.gif','http://www.63i.cn',0,'分组1') if exists (select * from sysobjects where id = OBJECT_ID('[rc_hangye]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [rc_hangye] CREATE TABLE [rc_hangye] ( [id] [int] NOT NULL, [name] [varchar] (100) NULL, [pr] [int] NULL DEFAULT (0), [isshow] [int] NULL) ALTER TABLE [rc_hangye] WITH NOCHECK ADD CONSTRAINT [PK_rc_hangye] PRIMARY KEY NONCLUSTERED ( [id] ) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 1,'计算机',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 2,'互联网/电子商务',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 3,'电子/微电子技术',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 4,'通讯/电信业',0,1) INSERT [rc_hangye] ([id],[name],[pr],[isshow]) VALUES ( 5,'快速消费品/食品/饮料/日化/烟酒等',0,1) INSERT [rc_hangye] (