用AppFramework重写Discuz数据访问层源代码

下载地址：http://download.csdn.net/source/331414 

修改的地方主要有:

1）在解决方案里增加了“Discuz.Data.AppFramework”项目

2）AppFramework插件生成的代码放在“Discuz.Data.AppFramework”项目的GenerateCode目录下

3）对论坛管理的数据访问类源代码ForumManage.cs做了重写

4）修改 Discuz.Web目录下的DNT.config，设置数据库访类型为 AppFramework

安装方法（请参考官方文档，下面仅简述）：

1）用VS2005打开解决方案编译

2）在IIS上创建站点，配置好站点主机头，例如为discuz.AppFramework.com（记得把这个站点主机头配置到hosts文件里，这样就可以用域名访问），把主目录指向Discuz.Web，设置站点的ASP.NET使用.NetFramework2.0;

3）在SqlServer里创建数据库，在DNT.config设置好数据库连接；

4）打开浏览器，键入 http://discuz.AppFramework.com/Install；按向导提示完成安装

5）然后就可以运行了

附录：

安装完数据库后，要修改下dnt_forums表结构，把char类型修改为varchar（我认为Discuz这个表的设计不合理，修改了下）。否则在板块管理里添加或挪动板块时会因字段值超长而报错。建表脚本如下：

CREATE TABLE [dbo].[dnt_forums](
 [fid] [int] IDENTITY(1,1) NOT NULL,
 [parentid] [int] NOT NULL CONSTRAINT [DF__dnt_forum__paren__377B294A]  DEFAULT ('0'),
 [layer] [int] NOT NULL CONSTRAINT [DF__dnt_forum__layer__386F4D83]  DEFAULT ('0'),
 [pathlist] [nvarchar](3000) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__dnt_forum__pathl__396371BC]  DEFAULT (''),
 [parentidlist] [varchar](300) COLLATE Chinese_PRC_CI_AS NOT NULL,
 [subforumcount] [int] NOT NULL CONSTRAINT [DF__dnt_forum__subfo__3A5795F5]  DEFAULT (''),
 [name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
 [status] [int] NOT NULL CONSTRAINT [DF__dnt_forum__statu__3B4BBA2E]  DEFAULT ('0'),
 [colcount] [int] NOT NULL CONSTRAINT [DF_dnt_forums_colcount]  DEFAULT ('1'),
 [displayorder] [int] NOT NULL CONSTRAINT [DF__dnt_forum__displ__3C3FDE67]  DEFAULT ('0'),
 [templateid] [int] NOT NULL CONSTRAINT [DF__dnt_forum__style__3D3402A0]  DEFAULT ('0'),
 [topics] [int] NOT NULL CONSTRAINT [DF__dnt_forum__topic__3E2826D9]  DEFAULT ('0'),
 [curtopics] [int] NOT NULL CONSTRAINT [DF_dnt_forums_curtopics]  DEFAULT ((0)),
 [posts] [int] NOT NULL CONSTRAINT [DF__dnt_forum__posts__3F1C4B12]  DEFAULT ('0'),
 [todayposts] [int] NOT NULL CONSTRAINT [DF__dnt_forum__today__40106F4B]  DEFAULT ('0'),
 [lasttid] [int] NOT NULL CONSTRAINT [DF__dnt_forum__lastt__41049384]  DEFAULT ('0'),
 [lasttitle] [nvarchar](60) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__dnt_forum__lastt__41F8B7BD]  DEFAULT (''),
 [lastpost] [datetime] NOT NULL CONSTRAINT [DF__dnt_forum__lastp__42ECDBF6]  DEFAULT (''),
 [lastposterid] [int] NOT NULL CONSTRAINT [DF__dnt_forum__lastp__43E1002F]  DEFAULT (''),
 [lastposter] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__dnt_forum__lastp__44D52468]  DEFAULT (''),
 [allowsmilies] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__45C948A1]  DEFAULT ('0'),
 [allowrss] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__46BD6CDA]  DEFAULT ('0'),
 [allowhtml] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__47B19113]  DEFAULT ('0'),
 [allowbbcode] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__48A5B54C]  DEFAULT ('0'),
 [allowimgcode] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__4999D985]  DEFAULT ('0'),
 [allowblog] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__4A8DFDBE]  DEFAULT ('0'),
 [allowtrade] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__4B8221F7]  DEFAULT ('0'),
 [alloweditrules] [int] NOT NULL CONSTRAINT [DF__dnt_forum__allow__4C764630]  DEFAULT ('0'),
 [allowthumbnail] [int] NOT NULL CONSTRAINT [DF_dnt_forum_allowthumbnail]  DEFAULT ('0'),
 [recyclebin] [int] NOT NULL CONSTRAINT [DF__dnt_forum__recyc__4D6A6A69]  DEFAULT ('0'),
 [modnewposts] [int] NOT NULL CONSTRAINT [DF__dnt_forum__modne__4E5E8EA2]  DEFAULT ('0'),
 [jammer] [int] NOT NULL CONSTRAINT [DF__dnt_forum__jamme__4F52B2DB]  DEFAULT ('0'),
 [disablewatermark] [int] NOT NULL CONSTRAINT [DF__dnt_forum__disab__5046D714]  DEFAULT ('0'),
 [inheritedmod] [int] NOT NULL CONSTRAINT [DF__dnt_forum__inher__513AFB4D]  DEFAULT ('0'),
 [autoclose] [int] NOT NULL CONSTRAINT [DF__dnt_forum__autoc__522F1F86]  DEFAULT ('0'),
 CONSTRAINT [PK_dnt_forums] PRIMARY KEY CLUSTERED
(
 [fid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]