版块数据表

ForumDB

ID OleDbType.Integer
TeamID OleDbType.Integer   父ID
ForumName OleDbType.VarWChar(20)   论坛名
ForumImg OleDbType.VarWChar(10)   图片
ForumUrl OleDbType.VarWChar(100)   地址
ForumRemark OleDbType.VarWChar(255)   说明
ForumTopicCount OleDbType.Integer 总帖数
ForumTopicRevertCount OleDbType.Integer 总回复数
ForumTodayTopicCount OleDbType.Integer 今日发帖总数
f_power OleDbType.VarWChar(255) 无备注


添加版块:
AddData_ForumDB
SQL:
INSERT INTO ForumDB ( TeamID, ForumName, ForumImg, ForumUrl, ForumRemark, f_power )
SELECT [@TeamID] AS 表达式1, [@ForumName] AS 表达式2, [@ForumImg] AS 表达式3, [@ForumUrl] AS 表达式4, [@ForumRemark] AS 表达式5, [@f_power] AS 表达式6;

更新版块详细信息:
UpdateOnID_ForumDB
SQL:
UPDATE ForumDB
SET ForumDB.TeamID = @TeamID,
ForumDB.ForumName = @ForumName,
ForumDB.ForumImg = @ForumImg,
ForumDB.ForumUrl = @ForumUrl,
ForumDB.ForumRemark = @ForumRemark,
ForumDB.f_power = @f_power
WHERE ForumDB.ID=[@ID];

获取所有版块数据:
GetData_ForumDB
SQL:
SELECT ForumDB.*, ForumTeamDB.f_name
FROM ForumDB
LEFT JOIN ForumTeamDB
ON ForumDB.TeamID=ForumTeamDB.ID
ORDER BY ForumDB.ID;

根据ID获取版块说明:
GetForumRemarkOnID_ForumDB
SQL:
SELECT ForumRemark
FROM ForumDB
WHERE ID=[@ID];

根据ID获取版块详细信息:
GetDataOnID_ForumDB
SQL:
SELECT ForumDB.TeamID,
ForumDB.ForumName,
ForumDB.ForumImg,
ForumDB.ForumUrl,
ForumDB.ForumRemark,
ForumDB.ForumTopicCount,
ForumDB.ForumTopicRevertCount,
ForumDB.ForumTodayTopicCount,
ForumDB.f_power
FROM ForumDB
WHERE (((ForumDB.ID)=[@ID]));

获取主题统计，回复统计，今日主题统计
GetCountInf_ForumDB
SQL:
SELECT sum(ForumTopicCount), sum(ForumTopicRevertCount), sum(ForumTodayTopicCount) AS COUNTID
FROM ForumDB;

根据ID删除版块
DelOnID_ForumDB
SQL:
DELETE *
FROM ForumDB
WHERE ID=[@ID];