IDC资讯中心
在运行之初,先进行web.config文件的配置
<add key=”connstring” value=”persist security info=false;server=(local);database=数据库名;uid=用户名;pwd=密码” />
<add key=”localpath” value=”虚拟目录的物理路径” />
数据库脚本如下:
/****** object: table [dbo].[adminuser] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[adminuser]) and objectproperty(id, nisusertable) = 1)drop table [dbo].[adminuser]go
/****** object: table [dbo].[article] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[article]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[article]
go
/****** object: table [dbo].[articlegroup] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[articlegroup]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[articlegroup]
go
/****** object: table [dbo].[grouppurview] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[grouppurview]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[grouppurview]
go
/****** object: table [dbo].[imagearticle] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[imagearticle]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[imagearticle]
go
/****** object: table [dbo].[logs] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[logs]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[logs]
go
/****** object: table [dbo].[purviewtype] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[purviewtype]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[purviewtype]
go
/****** object: table [dbo].[singlepurview] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[singlepurview]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[singlepurview]
go
/****** object: table [dbo].[uploadfile] script date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(n[dbo].[uploadfile]) and objectproperty(id, nisusertable) = 1)
drop table [dbo].[uploadfile]
go
/****** object: table [dbo].[adminuser] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[adminuser] (
[uid] [int] identity (1, 1) not null ,
[uname] [varchar] (24) collate chinese_prc_ci_as not null ,
[upsw] [varchar] (36) collate chinese_prc_ci_as not null ,
[gid] [int] null ,
[realname] [varchar] (50) collate chinese_prc_ci_as null ,
[regtime] [varchar] (50) collate chinese_prc_ci_as null ,
[email] [varchar] (50) collate chinese_prc_ci_as null
) on [primary]
go
/****** object: table [dbo].[article] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[article] (
[aid] [int] identity (1, 1) not null ,
[agid] [int] null ,
[ishidden] [bit] null ,
[ismain] [bit] null ,
[atitle] [varchar] (100) collate chinese_prc_ci_as not null ,
[acontent] [ntext] collate chinese_prc_ci_as not null ,
[ntime] [datetime] not null ,
[nclick] [int] null ,
[isbold] [bit] null ,
[uid] [int] null
) on [primary] textimage_on [primary]
go
/****** object: table [dbo].[articlegroup] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[articlegroup] (
[agid] [int] not null ,
[groupname] [varchar] (100) collate chinese_prc_ci_as not null ,
[describe] [varchar] (200) collate chinese_prc_ci_as null
) on [primary]
go
/****** object: table [dbo].[grouppurview] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[grouppurview] (
[gid] [int] identity (1, 1) not null ,
[gname] [varchar] (50) collate chinese_prc_ci_as not null ,
[describe] [varchar] (50) collate chinese_prc_ci_as not null ,
[subpurview] [varchar] (200) collate chinese_prc_ci_as not null
) on [primary]
go
/****** object: table [dbo].[imagearticle] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[imagearticle] (
[iaid] [int] identity (1, 1) not null ,
[ianame] [varchar] (100) collate chinese_prc_ci_as not null ,
[imagename] [varchar] (100) collate chinese_prc_ci_as not null ,
[iacontent] [ntext] collate chinese_prc_ci_as null ,
[iatime] [datetime] not null ,
[imageoldname] [varchar] (100) collate chinese_prc_ci_as not null ,
[imagethum1] [varchar] (50) collate chinese_prc_ci_as not null ,
[imagethum2] [varchar] (50) collate chinese_prc_ci_as not null ,
[ishide] [bit] not null
) on [primary] textimage_on [primary]
go
/****** object: table [dbo].[logs] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[logs] (
[lid] [int] identity (1, 1) not null ,
[uname] [varchar] (30) collate chinese_prc_ci_as null ,
[uip] [varchar] (40) collate chinese_prc_ci_as null ,
[utime] [varchar] (20) collate chinese_prc_ci_as null ,
[describe] [varchar] (200) collate chinese_prc_ci_as null
) on [primary]
go
/****** object: table [dbo].[purviewtype] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[purviewtype] (
[pid] [int] not null ,
[describe] [varchar] (200) collate chinese_prc_ci_as null
) on [primary]
go
/****** object: table [dbo].[singlepurview] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[singlepurview] (
[sid] [int] identity (1, 1) not null ,
[describe] [varchar] (200) collate chinese_prc_ci_as null ,
[ptype] [int] null ,
[psubcode] [int] null
) on [primary]
go
/****** object: table [dbo].[uploadfile] script date: 2005-6-12 16:26:48 ******/
create table [dbo].[uploadfile] (
[fid] [int] identity (1, 1) not null ,
[aid] [int] null ,
[fname] [varchar] (50) collate chinese_prc_ci_as null ,
[foldname] [varchar] (100) collate chinese_prc_ci_as null ,
[fsize] [int] null
) on [primary]
go
insert into purviewtype values(1, 系统设置类型);
insert into purviewtype values(2, 新闻管理类型);
insert into singlepurview(describe, ptype, psubcode) values(权限管理-对权限组进行建立及管理, 1, 1);
insert into singlepurview(describe, ptype, psubcode) values(用户管理-对管理员进行建立及管理, 1, 2);
insert into singlepurview(describe, ptype, psubcode) values(系统管理-对系统日志进行查看及网站信息的查看, 1, 3);
insert into singlepurview(describe, ptype, psubcode) values(图片新闻模块-对图片新闻专栏进行管理, 2, 0);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-教学管理_本科教学-的添加、编辑、删除管理, 2, 1);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-教学管理_工学硕士-的添加、编辑、删除管理, 2, 2);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-教学管理_工程硕士-的添加、编辑、删除管理, 2, 3);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-学生工作_工作计划-的添加、编辑、删除管理, 2, 11);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-学生工作_学生活动-的添加、编辑、删除管理, 2, 12);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-学生工作_科技学术-的添加、编辑、删除管理, 2, 13);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-学生工作_党团之窗-的添加、编辑、删除管理, 2, 14);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-学生工作_工作简报-的添加、编辑、删除管理, 2, 15);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-学生工作_学生信息-的添加、编辑、删除管理, 2, 16);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-就业工作_就业政策-的添加、编辑、删除管理, 2, 21);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-就业工作_就业指导-的添加、编辑、删除管理, 2, 22);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-就业工作_需求信息-的添加、编辑、删除管理, 2, 23);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-研发合作_合作交流-的添加、编辑、删除管理, 2, 31);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-专题信息_文档下载-的添加、编辑、删除管理, 2, 41);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-专题信息_本科评估-的添加、编辑、删除管理, 2, 42);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-专题信息_爱心服务-的添加、编辑、删除管理, 2, 43);
insert into singlepurview(describe, ptype, psubcode) values(对新闻版块-学院新闻-的添加、编辑、删除管理, 2, 51);
insert into grouppurview(gname, describe, subpurview) values(系统管理员, 对权限组和用户进行管理, 1,2,3);
insert into adminuser(uname, upsw, gid, realname, regtime, email) values(admin, 21232f297a57a5a743894a0e4a801fc3, 1, justin, 2005-5-1, finalcore@163.com);
insert into articlegroup values(1, 教学管理_本科教学, 新闻类别1_相关信息);
insert into articlegroup values(2, 教学管理_工学硕士, 新闻类别2_相关信息);
insert into articlegroup values(3, 教学管理_工程硕士, 新闻类别3_相关信息);
insert into articlegroup values(11, 学生工作_工作计划, 新闻类别1_相关信息);
insert into articlegroup values(12, 学生工作_学生活动, 新闻类别2_相关信息);
insert into articlegroup values(13, 学生工作_科技学术, 新闻类别3_相关信息);
insert into articlegroup values(14, 学生工作_党团之窗, 新闻类别2_相关信息);
insert into articlegroup values(15, 学生工作_工作简报, 新闻类别3_相关信息);
insert into articlegroup values(16, 学生工作_学生信息, 新闻类别2_相关信息);
insert into articlegroup values(21, 就业工作_就业政策, 新闻类别2_相关信息);
insert into articlegroup values(22, 就业工作_就业指导, 新闻类别2_相关信息);
insert into articlegroup values(23, 就业工作_需求信息, 新闻类别2_相关信息);
insert into articlegroup values(31, 研发合作_合作交流, 新闻类别2_相关信息);
insert into articlegroup values(41, 专题信息_文档下载, 新闻类别2_相关信息);
insert into articlegroup values(42, 专题信息_本科评估, 新闻类别2_相关信息);
insert into articlegroup values(43, 专题信息_爱心服务, 新闻类别2_相关信息);
insert into articlegroup values(51, 学院新闻, 新闻类别2_相关信息);
