📄 bbs.cs
字号:
//参数:
// @BoardID : 版块ID
// @StaffID : 员工ID
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@StaffID", SqlDbType.Int, 4, member.StaffID)
};
return(data.RunProc ("sp_BBS_DeleteBoardMember",prams));
}
//设置成员
public bool SetupBoardMember (int boardid,int staffid)
{
//参数:
// @BoardID int : 板块ID
// @StaffID int : 员工ID
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@BoardID", SqlDbType.Int, 4, boardid),
data.MakeInParam("@StaffID", SqlDbType.Int, 4, staffid),
};
try
{
data.RunProc ("sp_BBS_SetupBoardMember",prams);
return true;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return false;
}
}
#endregion
#region 显示所有分栏信息
public SqlDataReader GetBBSCatalog()
{
//参数: 无
SqlDataReader dataReader = null;
Database data = new Database();
try
{
data.RunProc ("sp_GetBBSCatalog",out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 显示个人的分类栏的版块
public SqlDataReader GetBBSBoard(string m_StaffName)
{
//参数: m_StaffName : 员工姓名
//@catalog_id int : 分类栏ID
// @staff_name varchar(50)='' : 员工姓名
SqlDataReader dataReader = null;
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@staff_name", SqlDbType.VarChar, 50, m_StaffName)
};
try
{
data.RunProc ("sp_BBS_GetAllBoardByStaff",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 显示所有板块
public SqlDataReader GetAllBBSBoard()
{
SqlDataReader dataReader = null;
Database data = new Database ();
try
{
data.RunProc ("sp_BBS_GetAllBoard",out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 显示该版块的所有帖子
public SqlDataReader GetBBSForumItem(BBSForumItem item)
{
//参数: @board_id int : 该版块ID
SqlDataReader dataReader = null;
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@board_id", SqlDbType.Int, 4, item.BoardID),
};
try
{
data.RunProc ("sp_GetBBSForumItem",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 得到所有系统公告
/// <summary>
/// 得到所有系统公告
/// </summary>
/// <returns></returns>
public SqlDataReader GetSysBulletin()
{
SqlDataReader dataReader = null;
Database data = new Database ();
try
{
SqlParameter[] prams = {
data.MakeInParam("@type", SqlDbType.Int, 4, -1),
};
data.RunProc ("sp_BBS_GetBulletin",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 得到所有桌面公告
/// <summary>
/// 得到所有桌面公告
/// </summary>
/// <returns></returns>
public SqlDataReader GetDeskTopBulletin()
{
SqlDataReader dataReader = null;
Database data = new Database ();
try
{
SqlParameter[] prams = {
data.MakeInParam("@type", SqlDbType.Int, 4, -2),
};
data.RunProc ("sp_BBS_GetBulletin",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 得到板块公告
/// <summary>
/// 得到板块公告
/// </summary>
/// <param name="boardid">板块id,=0则取出所有板块的公告</param>
/// <returns></returns>
public SqlDataReader GetBulletin(int boardid)
{
SqlDataReader dataReader = null;
Database data = new Database ();
try
{
SqlParameter[] prams = {
data.MakeInParam("@type", SqlDbType.Int, 4, boardid),
};
data.RunProc ("sp_BBS_GetBulletin",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
#endregion
#region 读取论坛帖子
public SqlDataReader ReadBBSForumItem(BBSForumItem item)
{
//参数: @item_id int : 帖子ID
SqlDataReader dataReader = null;
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, item.ItemID),
};
try
{
data.RunProc ("sp_ReadBBSForumItem",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
return null;
}
}
public void ReadBBSForumItemStruct(BBSForumItem item)
{
//参数: @item_id int : 帖子ID
SqlDataReader dataReader = null;
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, item.ItemID),
};
try
{
data.RunProc ("sp_ReadBBSForumItem",prams,out dataReader);
while(dataReader.Read())
{
item.BoardID = Int32.Parse(dataReader["board_id"].ToString());
item.Title = dataReader["title"].ToString();
item.Content = dataReader["content"].ToString();
item.Sender = dataReader["sender"].ToString();
item.SendTime = DateTime.Parse(dataReader["send_time"].ToString());
item.HitTimes = Int32.Parse(dataReader["hit_times"].ToString());
item.ReplayTimes = Int32.Parse(dataReader["replay_times"].ToString());
item.LastReplayer = dataReader["last_replayer"].ToString();
item.LastReplayTime = dataReader["last_replay_time"].ToString();
item.IP = dataReader["ip"].ToString();
item.Bulletin = Convert.ToBoolean(dataReader["bulletin"]);
item.SysBulletin = Convert.ToBoolean(dataReader["sysbulletin"]);
item.DeskTop = Convert.ToBoolean(dataReader["desktop"]);
}
}
catch (Exception ex)
{
Error.Log(ex.ToString());
}
}
#endregion
#region 修改论坛帖子
public void ModBBSForumItem(BBSForumItem item)
{
//参数: @item_id int : 帖子ID
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, item.ItemID),
data.MakeInParam("@board_id", SqlDbType.Int, 4, item.BoardID),
data.MakeInParam("@title", SqlDbType.VarChar, 300, item.Title),
data.MakeInParam("@content", SqlDbType.NText, 5000, item.Content),
data.MakeInParam("@sender", SqlDbType.VarChar, 50, item.Sender),
data.MakeInParam("@send_time", SqlDbType.DateTime, 8, item.SendTime),
data.MakeInParam("@hit_times", SqlDbType.Int, 4, item.HitTimes),
data.MakeInParam("@replay_times", SqlDbType.Int, 4, item.ReplayTimes),
data.MakeInParam("@last_replayer", SqlDbType.VarChar, 50, item.LastReplayer),
data.MakeInParam("@last_replay_time", SqlDbType.DateTime, 8, item.LastReplayTime==""?Convert.DBNull:item.LastReplayTime),
data.MakeInParam("@ip", SqlDbType.VarChar, 50, item.IP),
data.MakeInParam("@bulletin", SqlDbType.Bit, 4, item.Bulletin),
data.MakeInParam("@sysbulletin", SqlDbType.Bit, 4, item.SysBulletin),
data.MakeInParam("@desktop", SqlDbType.Bit, 4, item.DeskTop),
};
try
{
data.RunProc ("sp_BBS_UpdateItemInfo",prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
}
}
#endregion
#region 读取帖子回复
public SqlDataReader ReadBBSForumItemReplay(BBSForumItem item)
{
//参数: @item_id int : 帖子ID
SqlDataReader dataReader = null;
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, item.ItemID),
};
try
{
data.RunProc ("sp_ReadBBSForumItemReplay",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString ());
return null;
}
}
#endregion
#region 删除回复
public void DelReplay(BBSReplay replay)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@replayid", SqlDbType.Int, 4,replay.ReplayId),
data.MakeInParam("@itemid",SqlDbType.Int,4,replay.ItemID)
};
data.RunProc ("sp_BBS_DeleteReplay",prams);
}
#endregion
#region 回复贴子
public int ReplayItem(BBSReplay replay)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4, replay.ItemID),
data.MakeInParam("@content", SqlDbType.NText,5000, replay.Content),
data.MakeInParam("@replayer", SqlDbType.VarChar,300, replay.Replayer),
data.MakeInParam("@replay_ip", SqlDbType.VarChar,50, replay.ReplayId)
};
try
{
return(data.RunProc ("sp_BBSReplay",prams));
}
catch (Exception ex)
{
Error.Log(ex.ToString ());
throw new Exception("回复出错！");
}
}
#endregion
#region 发布贴子
public int SendItem(BBSForumItem item)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@board_id", SqlDbType.Int, 4,item.BoardID),
data.MakeInParam("@title", SqlDbType.VarChar,300,item.Title),
data.MakeInParam("@content", SqlDbType.NText,5000,item.Content),
data.MakeInParam("@sender", SqlDbType.VarChar,100,item.Sender),
data.MakeInParam("@ip", SqlDbType.VarChar,50,item.IP ),
data.MakeInParam("@bulletin",SqlDbType.Bit,1,item.Bulletin),
data.MakeInParam("@sysbulletin",SqlDbType.Bit,1,item.SysBulletin),
data.MakeInParam("@desktop",SqlDbType.Bit,1,item.DeskTop)
};
try
{
return(data.RunProc ("sp_BBSAddItem",prams));
}
catch (Exception ex)
{
Error.Log(ex.ToString ());
throw new Exception("发布出错！");
}
}
#endregion
#region 增加板主
public void AddBoardMaster(int boardid,int staffid)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@BoardID", SqlDbType.Int, 4,boardid),
data.MakeInParam("@StaffID", SqlDbType.Int, 4,staffid)
};
data.RunProc ("sp_BBS_SetupBoardMaster",prams);
}
#endregion
#region 删除板主
public void DelBoardMaster(int boardid,int staffid)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@BoardID", SqlDbType.Int, 4,boardid),
data.MakeInParam("@StaffID", SqlDbType.Int, 4,staffid)
};
data.RunProc ("sp_BBS_DeleteBoardMaster",prams);
}
#endregion
#region 移动论坛贴子
public void MoveBoardItem(BBSForumItem olditem,BBSForumItem newitem)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4,olditem.ItemID),
data.MakeInParam("@to_board_id", SqlDbType.Int, 4,newitem.BoardID)
};
data.RunProc ("sp_BBSMoveItem",prams);
}
#endregion
#region 删除论坛贴子
public void DelItem(BBSForumItem item)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4,item.ItemID)
};
data.RunProc ("sp_BBSDeleteItem",prams);
}
#endregion
#region 得到所有论坛
public SqlDataReader GetAllBoard()
{
Database data = new Database ();
SqlDataReader dr = null;
data.RunProc ("sp_BBSGetMoveToBoard",out dr);
return(dr);
}
#endregion
#region 上传一个文件得到id号
public int InsertFile(string name,string extension)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@name",SqlDbType.VarChar,200,name),
data.MakeInParam("@extension",SqlDbType.VarChar,100,extension)
};
return(data.RunProc ("sp_BBS_AddFile",prams));
}
#endregion
#region 根据id得到上传附件信息
public SqlDataReader GetAttachmentByID(int id)
{
Database data = new Database();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -