/// <summary>
/// 更新版块信息
/// </summary>
/// <param name="fid">版块ID</param>
/// <param name="topiccount">主题数</param>
/// <param name="postcount">帖子数</param>
/// <param name="lasttid">最后回复主题</param>
/// <param name="lasttitle">最后回复标题</param>
/// <param name="lastpost">最后回复时间</param>
/// <param name="lastposterid">最后回复人ID</param>
/// <param name="lastposter">最后回复人</param>
/// <param name="todaypostcount">当天发的帖子数</param>
public static void UpdateForum(int fid, int topiccount, int postcount, int lasttid, string lasttitle, string lastpost,
int lastposterid, string lastposter, int todaypostcount)
{
DatabaseProvider.GetInstance().UpdateForum(fid, topiccount, postcount, lasttid, lasttitle, lastpost, lastposterid, lastposter, todaypostcount);
}
/// <summary>
/// 获取第一个版块的信息
/// </summary>
/// <returns></returns>
public static int GetFirstFourmID()
{
return(DatabaseProvider.GetInstance().GetFirstFourmID());
}
/// <summary>
/// 更新指定版块或分类的displayorder信息
/// </summary>
/// <param name="displayorder">要更新的displayorder信息</param>
/// <param name="fid">版块id</param>
public static void UpdateDisplayorderInForumByFid(int displayorder, int fid)
{
DatabaseProvider.GetInstance().UpdateDisplayorderInForumByFid(displayorder, fid);
}
/// <summary>
/// 获取所有可见版块
/// </summary>
/// <returns></returns>
public static DataTable GetVisibleForumList()
{
return(DatabaseProvider.GetInstance().GetVisibleForumList());
}
/// <summary>
/// 更新所有版块的今日发帖数
/// </summary>
public static void ResetTodayPosts()
{
DatabaseProvider.GetInstance().ResetTodayPosts();
}
/// <summary>
/// 是否存在子版块
/// </summary>
/// <param name="fid"></param>
/// <returns></returns>
public static bool IsExistSubForum(int fid)
{
return(DatabaseProvider.GetInstance().IsExistSubForum(fid));
}
/// <summary>
/// 获取麽一个字段
/// </summary>
/// <param name="fid">板块ID</param>
/// <param name="fieldname">字段名</param>
/// <returns></returns>
public static DataTable GetForumField(int fid, string fieldname)
{
return(DatabaseProvider.GetInstance().GetForumField(fid, fieldname));
}
/// <summary>
/// 批理设置论坛信息
/// </summary>
/// <param name="__foruminfo">复制的论坛信息</param>
/// <param name="bsp">是否要批量设置的信息字段</param>
/// <param name="fidlist">目标论坛(fid)串</param>
/// <returns></returns>
public static bool BatchSetForumInf(ForumInfo __foruminfo, BatchSetParams bsp, string fidlist)
{
return(DatabaseProvider.GetInstance().BatchSetForumInf(__foruminfo, bsp, fidlist));
}
/// <summary>
/// 获得forum的最大排序号
/// </summary>
/// <param name="fid"></param>
/// <returns></returns>
public static DataTable GetMaxDisplayOrder(int fid)
{
return(DatabaseProvider.GetInstance().GetForumsMaxDisplayOrder(fid));
}
/// <summary>
/// 获得版块下的子版块列表
/// </summary>
/// <param name="fid">版块id</param>
/// <returns>子版块列表</returns>
public static DataTable GetSubForumTable(int fid)
{
return(DatabaseProvider.GetInstance().GetSubForumTable(fid));
}
/// <summary>
/// 要设置的起始版块
/// </summary>
/// <param name="start_fid">起始板块ID</param>
/// <param name="end_fid">终止板块ID</param>
/// <returns></returns>
public static IDataReader GetForums(int start_fid, int end_fid)
{
return(DatabaseProvider.GetInstance().GetForums(start_fid, end_fid));
}
/// <summary>
/// 获取版块最大最小主题Id
/// </summary>
/// <param name="fid"></param>
/// <returns></returns>
public static IDataReader GetMaxAndMinTid(int fid)
{
return(DatabaseProvider.GetInstance().GetMaxAndMinTid(fid));
}
/// <summary>
/// 获取有特殊用户的版块列表
/// </summary>
/// <param name="fid">版块Id</param>
/// <returns></returns>
public static DataTable GetForumTableWithSpecialUser(int fid)
{
return(DatabaseProvider.GetInstance().GetForumTableWithSpecialUser(fid));
}
/// <summary>
/// 获取版主列表中包含用户名的版块列表
/// </summary>
/// <param name="userName">用户名</param>
/// <returns></returns>
//public static DataTable GetModerators(string userName)
//{
// return DatabaseProvider.GetInstance().GetModerators(userName);
//}
/// <summary>
/// 获取包含该特殊用户的版块
/// </summary>
/// <param name="userName">用户名</param>
/// <returns></returns>
public static DataTable GetForumTableBySpecialUser(string userName)
{
return(DatabaseProvider.GetInstance().GetForumTableBySpecialUser(userName));
}
/// <summary>
/// 按父板块获取子板块
/// </summary>
/// <param name="parentid">父ID</param>
/// <returns></returns>
public static DataTable GetForumByParentid(int parentid)
{
return(DatabaseProvider.GetInstance().GetForumByParentid(parentid));
}
/// <summary>
/// 获得forum的最大排序号
/// </summary>
/// <returns></returns>
public static int GetMaxDisplayOrder()
{
return(DatabaseProvider.GetInstance().GetForumsMaxDisplayOrder());
}
/// <summary>
/// 合并版块
/// </summary>
/// <param name="sourcefid"></param>
/// <param name="targetfid"></param>
/// <param name="fidlist"></param>
public static void CombinationForums(string sourcefid, string targetfid, string fidlist)
{
DatabaseProvider.GetInstance().CombinationForums(sourcefid, targetfid, fidlist);
}
/// <summary>
/// 更新论坛排序号
/// </summary>
/// <param name="currentdisplayorder"></param>
public static void UpdateForumsDisplayOrder(int currentdisplayorder)
{
DatabaseProvider.GetInstance().UpdateForumsDisplayOrder(currentdisplayorder);
}
/// <summary>
/// 更新版本子版数
/// </summary>
/// <param name="fid">版块Id</param>
public static void UpdateSubForumCount(int fid)
{
DatabaseProvider.GetInstance().UpdateSubForumCount(fid);
}
/// <summary>
/// 设置版块状态
/// </summary>
/// <param name="status">板块状态</param>
/// <param name="fid">板块ID</param>
public static void SetStatusInForum(int status, int fid)
{
DatabaseProvider.GetInstance().SetStatusInForum(status, fid);
}
/// <summary>
/// 获取父ID
/// </summary>
/// <param name="fid"></param>
/// <returns></returns>
public static DataTable GetParentIdByFid(int fid)
{
return(DatabaseProvider.GetInstance().GetParentIdByFid(fid));
}
/// <summary>
/// 获取顶级板块Id列表
/// </summary>
/// <param name="lastfid"></param>
/// <param name="statcount"></param>
/// <returns></returns>
public static IDataReader GetTopForumFids(int lastfid, int statcount)
{
return(DatabaseProvider.GetInstance().GetTopForumFids(lastfid, statcount));
}
/// <summary>
/// 更新所有版块的主题数
/// </summary>
public static void ResetForumsTopics()
{
DatabaseProvider.GetInstance().ResetForumsTopics();
}
/// <summary>
/// 移动版块位置
/// </summary>
/// <param name="currentfid">当前板块ID</param>
/// <param name="targetfid"></param>
/// <param name="isaschildnode"></param>
/// <param name="extname"></param>
public static void MovingForumsPos(string currentfid, string targetfid, bool isaschildnode, string extname)
{
DatabaseProvider.GetInstance().MovingForumsPos(currentfid, targetfid, isaschildnode, extname);
}
/// <summary>
/// 建立更新用户积分存储过程的方法
/// </summary>
/// <param name="creditExpression">总积分计算公式</param>
/// <param name="testCreditExpression">是否需要测试总积分计算公式是否正确</param>
/// <returns></returns>
public static bool CreateUpdateUserCreditsProcedure(string creditExpression, bool testCreditExpression)
{
return(DatabaseProvider.GetInstance().CreateUpdateUserCreditsProcedure(creditExpression, testCreditExpression));
}
/// <summary>
/// 获取顶级板块列表
/// </summary>
/// <returns></returns>
public static DataTable GetMainForum()
{
return(DatabaseProvider.GetInstance().GetMainForum());
}
/// <summary>
/// 获取指定版块id下的最后发帖主题id
/// </summary>
/// <param name="fidList">版块id列表</param>
/// <returns></returns>
public static int GetForumsLastPostTid(string fidList)
{
return(DatabaseProvider.GetInstance().GetForumsLastPostTid(fidList));
}
/// <summary>
/// 批量更新板块状态
/// </summary>
/// <param name="fidlist">板块ID列表</param>
public static void UpdateStatusByFidlistOther(string fidlist)
{
DatabaseProvider.GetInstance().UpdateStatusByFidlistOther(fidlist);
}
/// <summary>
/// 批理设置版块模板信息
/// </summary>
/// <param name="templateID">新的模板id</param>
/// <param name="fidlist">要更新的版块id列表</param>
/// <returns></returns>
public static int UpdateForumTemplateID(int templateID, string fidlist)
{
return(DatabaseProvider.GetInstance().UpdateForumTemplateID(templateID, fidlist));
}
/// <summary>
/// 获取主题分类不为空的板块
/// </summary>
/// <returns></returns>
public static DataTable GetExistTopicTypeOfForum()
{
return(DatabaseProvider.GetInstance().GetExistTopicTypeOfForum());
}