www.pudn.com > UDS1.1_51aspx.rar > BBS.cs
using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Collections ;
using System.Configuration;
using System.Web;
namespace UDS.Components
{
///
/// BBS 的摘要说明。
///
public class BBSClass
{
#region 判断是否有BBS管理权限
///
/// 判断是否有管理权限
///
/// 用户名
/// bool
public bool AdminBBS(string username,int classid)
{
if(classid!=0)
{
int actid = 8;
Database db = new Database();
SqlParameter[] prams = {
db.MakeInParam("@Class_ID",SqlDbType.Int,4,classid),
db.MakeInParam("@Username",SqlDbType.VarChar,100,username),
db.MakeInParam("@Act_ID",SqlDbType.Int,4,actid),
db.MakeOutParam("@ReturnValue",SqlDbType.Int,4)
};
try
{
db.RunProc("sp_GetAccessPermission",prams);
// 仅做测试用
// return(true);
return((Int32.Parse(prams[3].Value.ToString())==1)?true:false);
}
catch(Exception ex)
{
Error.Log(ex.Message);
throw new Exception("BBS权限判断错误!",ex);
}
}
else
return(false);
}
#endregion
#region 判断是否有发布系统公告权限
///
/// 判断是否有发布系统公告权限
///
/// 用户名
/// bool
public bool AdminSysBulletin(string username,int classid)
{
if(classid!=0)
{
int actid = 9;
Database db = new Database();
SqlParameter[] prams = {
db.MakeInParam("@Class_ID",SqlDbType.Int,4,classid),
db.MakeInParam("@Username",SqlDbType.VarChar,100,username),
db.MakeInParam("@Act_ID",SqlDbType.Int,4,actid),
db.MakeOutParam("@ReturnValue",SqlDbType.Int,4)
};
try
{
db.RunProc("sp_GetAccessPermission",prams);
// 仅做测试用
// return(true);
return((Int32.Parse(prams[3].Value.ToString())==1)?true:false);
}
catch(Exception ex)
{
Error.Log(ex.Message);
throw new Exception("BBS权限判断错误!",ex);
}
}
else
return(false);
}
#endregion
#region 判断是否是板块斑竹
///
/// 判断是否是板块斑竹
///
/// 板块ID
/// 用户名
///
/// 得到所有系统公告
///
///
/// 得到所有桌面公告
///
///
/// 得到板块公告
///
/// 板块id,=0则取出所有板块的公告
///
/// 版面公告
///
public bool Bulletin
{
get{return m_Bulletin;}
set{m_Bulletin = value;}
}
///
/// 系统公告
///
public bool SysBulletin
{
get{return m_SysBulletin;}
set{m_SysBulletin = value;}
}
///
/// 公告桌面显示
///
public bool DeskTop
{
get{return m_DeskTop;}
set{m_DeskTop = value;}
}
///
/// 将贴子附件与自身绑定
///
/// 文件名（多个文件名用 , 分开）
public void Attach(string filenames)
{
UDS.Components.Database data = new UDS.Components.Database ();
string[] arrfilename = filenames.Split(',');
for(int i=0;i
/// 删除附件
///
public void DelAttachment(string attachmentmd)
{
UDS.Components.Database data = new UDS.Components.Database ();
//删除所有回复附件
//得到所有回复
UDS.Components.BBSClass bbs = new UDS.Components.BBSClass();
SqlDataReader dr1 = null;
dr1 = bbs.ReadBBSForumItemReplay(this);
while(dr1.Read())
{
BBSReplay replay = new BBSReplay();
replay.ReplayId = Int32.Parse(dr1["replay_id"].ToString());
replay.DelAttachment(attachmentmd);
}
//删除贴子本身附件
SqlParameter[] prams = {
data.MakeInParam("@itemid", SqlDbType.Int, 4,this.ItemID),
};
SqlDataReader dr = null;
data.RunProc ("sp_BBS_GetItemAttachment",prams,out dr);
while(dr.Read())
{
System.IO.File.Delete(attachmentmd+"\\"+dr["filename"].ToString());
}
data.Close();
SqlParameter[] prams1 = {
data.MakeInParam("@itemid", SqlDbType.Int, 4,this.ItemID),
};
data.RunProc("sp_BBS_DelAttachmentToItem",prams1);
}
}
public class BBSReplay
{
private int m_ReplayId;
private int m_ItemId;
private string m_Content;
private string m_Replayer;
private string m_ReplayTime;
private string m_ReplayIP;
public int ReplayId
{
//
get { return m_ReplayId; }
set { m_ReplayId = value; }
}
public int ItemID
{
//
get { return m_ItemId; }
set { m_ItemId = value; }
}
public string Content
{
//
get { return m_Content; }
set { m_Content = value;}
}
public string Replayer
{
//
get { return m_Replayer; }
set { m_Replayer = value; }
}
public string ReplayTime
{
//
get { return m_ReplayTime; }
set { m_ReplayTime = value; }
}
public string ReplayIP
{
//
get { return m_ReplayIP; }
set { m_ReplayIP = value; }
}
///
/// 将附件和回复绑定
///
/// 文件名,多个文件名用 , 分开
public void Attach(string filenames)
{
UDS.Components.Database data = new UDS.Components.Database ();
string[] arrfilename = filenames.Split(',');
for(int i=0;i
/// 删除附件
///
public void DelAttachment(string attachmentmd)
{
UDS.Components.Database data = new UDS.Components.Database ();
SqlParameter[] prams = {
data.MakeInParam("@replayid", SqlDbType.Int, 4,this.ReplayId),
};
SqlDataReader dr = null;
data.RunProc ("sp_BBS_GetReplayAttachment",prams,out dr);
while(dr.Read())
{
System.IO.File.Delete(attachmentmd+"\\"+dr["filename"].ToString());
}
data.Close();
SqlParameter[] prams1 = {
data.MakeInParam("@replayid", SqlDbType.Int, 4,this.ReplayId),
};
data.RunProc("sp_BBS_DelAttachmentToReplay",prams1);
}
}
public class BBSSearchOption
{
private int _boardid;
private TimeSpan _time;
private BBSSearchType _searchtype;
public int BoardID
{
get
{
return _boardid;
}
set
{
_boardid = value;
}
}
public TimeSpan TimeBound
{
get
{
return _time;
}
set
{
_time = value;
}
}
public BBSSearchType searchtype
{
get
{
return _searchtype;
}
set
{
_searchtype = value;
}
}
}
public enum BBSSearchType{author,title}