bbs.cs

网络版的办公自动化系统 功能强大

			SqlDataReader dr = null;
			SqlParameter[] prams = {
									   data.MakeInParam("@id",SqlDbType.Int,4,id)
								   };
			data.RunProc ("sp_BBS_GetAttachmentByID",prams,out dr);
			return(dr);
		}
		#endregion

	}
}

public class BBSBoard
{
	private int m_BoardID;
	private int m_CatalogID;
	private string m_BoardName;
	private string m_BoardDescription;
	private int m_BoardType;
		
	public int BoardID
	{	
		//
		get { return m_BoardID; }
		set { m_BoardID = value; }
	}
 
	public int CatalogID
	{
		//
		get { return m_CatalogID; }
		set { m_CatalogID = value; }
	}

	public string BoardName
	{
		//
		get { return m_BoardName; }
		set { m_BoardName = value; }
	}

	public string BoardDescription
	{
		//
		get { return m_BoardDescription; }
		set { m_BoardDescription = value; }
	}
	
	public int BoardType	
	{
		//
		get { return m_BoardType; }
		set { m_BoardType = value; }
	} 
}

public class BBSBoardmaster
{
	// 板主信息
	private int m_BoardID;
	private int m_StaffID;

	public int BoardID 
	{
		//
		get { return m_BoardID; }
		set { m_BoardID = value; }
	}

	public int StaffID
	{
		//
		get { return m_StaffID; }
		set { m_StaffID = value; } 
	}   

}

public class BBSBoardmember
{
	//BBS里的会员
	private int m_StaffID;
	private int m_BoardID;
		
	public int StaffID 
	{
		//
		get { return m_StaffID; } 
		set { m_StaffID = value; }
	}

	public int BoardID
	{
		//
		get { return m_BoardID; }
		set { m_BoardID = value; }
	}

}

public class BBSCatalog 
{
	//BBS 类别
	private int m_CatalogID;
	private string m_CatalogName; 
	private string m_CatalogDescription;

	public int CatalogID
	{
		//类别ID号
		get { return m_CatalogID; }
		set { m_CatalogID = value; }
	}

	public string CatalogName
	{
		// 类别名称
		get { return m_CatalogName; } 
		set { m_CatalogName = value; }
	}
		
	public string CatalogDescription
	{
		// 类别备注
		get { return m_CatalogDescription; }
		set { m_CatalogDescription = value; } 
	}

}

public class BBSForumItem
{
	//
	private int m_ItemID;
	private int m_BoardID;
	private string m_Title;
	private string m_Content;
	private string m_Sender;
	private DateTime m_SendTime;
	private int m_HitTimes;
	private int m_ReplayTimes;
	private string m_LastReplayer;
	private string m_LastReplayTime;
	private string m_IP;
	private bool m_Bulletin;
	private bool m_SysBulletin;
	private bool m_DeskTop;

	public int ItemID
	{
		//
		get { return m_ItemID;}
		set {m_ItemID = value;}
	}

	public int BoardID
	{
		//
		get { return m_BoardID; }
		set { m_BoardID = value; }
	}

	public string Title
	{
		//
		get { return m_Title; }
		set { m_Title = value; }
	}

	public string Content
	{
		//
		get { return m_Content; }
		set { m_Content = value; }
	}

	public string Sender 
	{
		//
		get { return m_Sender; }
		set { m_Sender = value; }
	}

	public DateTime SendTime
	{
		//发送时间
		get { return m_SendTime; }
		set { m_SendTime = value; }
	}

	public int HitTimes
	{
		//
		get { return m_HitTimes; }
		set { m_HitTimes = value; }
	}

	public int ReplayTimes
	{
		//回复次数
		get { return m_ReplayTimes; }
		set { m_ReplayTimes = value; }
	}

	public string LastReplayer
	{
		//
		get { return m_LastReplayer; }
		set { m_LastReplayer = value; }
	}

	public string LastReplayTime
	{
		//
		get { return m_LastReplayTime; }
		set { m_LastReplayTime = value; }
	}

	public string IP 
	{
		//
		get { return m_IP; }
		set { m_IP = value; }
	}
	/// <summary>
	/// 版面公告
	/// </summary>
	public bool Bulletin
	{
		get{return m_Bulletin;}
		set{m_Bulletin = value;}
	}
	/// <summary>
	/// 系统公告
	/// </summary>
	public bool SysBulletin
	{
		get{return m_SysBulletin;}
		set{m_SysBulletin = value;}
	}

	/// <summary>
	/// 公告桌面显示
	/// </summary>
	public bool DeskTop
	{
		get{return m_DeskTop;}
		set{m_DeskTop = value;}
	}

	/// <summary>
	/// 将贴子附件与自身绑定
	/// </summary>
	/// <param name="filenames">文件名（多个文件名用 , 分开）</param>
	public void Attach(string filenames)
	{
		UDS.Components.Database data = new UDS.Components.Database ();
		string[] arrfilename = filenames.Split(',');
		for(int i=0;i<arrfilename.Length;i++)
		{
			if(arrfilename[i].Trim()!="")
			{
				SqlParameter[] prams = {
										   data.MakeInParam("@itemid",  SqlDbType.Int, 4,this.ItemID),
										   data.MakeInParam("@filename",  SqlDbType.VarChar, 500,arrfilename[i])
									   };
				data.RunProc ("sp_BBS_AttachmentToItem",prams);
			}
			
		}

	}

	/// <summary>
	/// 删除附件
	/// </summary>
	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; }
	}

	/// <summary>
	/// 将附件和回复绑定
	/// </summary>
	/// <param name="filenames">文件名,多个文件名用 , 分开</param>
	public void Attach(string filenames)
	{
		UDS.Components.Database data = new UDS.Components.Database ();
		string[] arrfilename = filenames.Split(',');
		for(int i=0;i<arrfilename.Length;i++)
		{
			if(arrfilename[i].Trim()!="")
			{
				SqlParameter[] prams = {
										   data.MakeInParam("@replayid",  SqlDbType.Int, 4,this.ReplayId),
										   data.MakeInParam("@filename",  SqlDbType.VarChar, 500,arrfilename[i])
									   };
				data.RunProc ("sp_BBS_AttachmentToReplay",prams);
			}
			
		}
	}

	/// <summary>
	/// 删除附件
	/// </summary>
	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}