//更新板块信息
public bool EditBBSBoard(BBSBoard BBSBoard)
{
//@board_id int, : 被更新的板块ID
//@board_name varchar(300) : 板块名称
//@board_description varchar(300), : 板块介绍
//@board_type bit : 板块类型(公共型，私有型)
// 给存储过程传递参数
Database data = new Database();
SqlParameter[] prams =
{
data.MakeInParam("@board_id", SqlDbType.Int, 4, BBSBoard.BoardID),
data.MakeInParam("@board_name", SqlDbType.VarChar, 300, BBSBoard.BoardName),
data.MakeInParam("@board_description", SqlDbType.VarChar, 300, BBSBoard.BoardDescription),
data.MakeInParam("@board_type", SqlDbType.Bit, 1, BBSBoard.BoardType),
};
//try
{
data.RunProc("sp_BBS_UpdateBoardInfo", prams);
return(true);
}
//catch (Exception ex)
{
// Error.Log(ex.ToString());
// throw new Exception("BBS板块编缉错误!",ex);
}
}
//在BBS大类中 添加板块
public bool BBSAddBoard(BBSBoard BBSBoard)
{
//需向存储过程传递的参数如下
//@catalog_id (int) 分类ID号, @title (varchar(300)) 抬头的名称, @content ntext 板块内容, @boardtype bit 板块类型
Database data = new Database();
SqlParameter[] prams =
{
data.MakeInParam("@catalog_id", SqlDbType.Int, 4, BBSBoard.CatalogID),
data.MakeInParam("@title", SqlDbType.VarChar, 300, BBSBoard.BoardName),
data.MakeInParam("@content", SqlDbType.NText, 16, BBSBoard.BoardDescription),
data.MakeInParam("@boardtype", SqlDbType.Bit, 1, BBSBoard.BoardType),
};
data.RunProc("sp_BBS_AddBoard", prams);
return(true);
}
private void CmdOK_Click(object sender, System.EventArgs e)
{
if (m_Action == "AddBoard")
//新增板块
{
BBSClass BBS = new BBSClass();
BBSBoard Board = new BBSBoard();
HttpCookie UserCookie = Request.Cookies["Username"];
String Username = UserCookie.Value.ToString();
try
{
Board.CatalogID = Int32.Parse(m_CatalogID);
Board.BoardName = this.TxtBoardName.Text;
Board.BoardDescription = this.TxtBoardDescription.Text;
if (this.RdPublic.Checked == true)
{
Board.BoardType = 1;
}
else
{
Board.BoardType = 0;
}
BBS.BBSAddBoard(Board);
//Response.Write("<script language=javascript>alert('添加成功!');parent.location.reload();</script>");
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
finally
{
BBS = null;
Board = null;
Server.Transfer("Catalog.aspx?classID=" + classid);
}
}
else if (m_Action == "ModifyBoard")
{
//编缉板块
BBSClass BBS = new BBSClass();
BBSBoard Board = new BBSBoard();
HttpCookie UserCookie = Request.Cookies["Username"];
String Username = UserCookie.Value.ToString();
//try
{
Board.BoardID = Int32.Parse(m_BoardID);
Board.BoardName = this.TxtBoardName.Text;
Board.BoardDescription = this.TxtBoardDescription.Text;
if (this.RdPublic.Checked == true)
{
Board.BoardType = 1;
}
else
{
Board.BoardType = 0;
}
BBS.EditBBSBoard(Board);
Server.Transfer("Catalog.aspx?classID=" + classid);
}
//catch (Exception ex)
{
// UDS.Components.Error.Log(ex.ToString());
// Server.Transfer("../../Error.aspx");
}
//finally
{
BBS = null;
Board = null;
}
}
}
private void CmdOK_Click(object sender, System.EventArgs e)
{
if (m_Action == "AddBoard" )
//�������
{
BBSClass BBS = new BBSClass();
BBSBoard Board = new BBSBoard();
HttpCookie UserCookie = Request.Cookies["Username"];
String Username = UserCookie.Value.ToString();
try
{
Board.CatalogID = Int32.Parse (m_CatalogID);
Board.BoardName = this.TxtBoardName.Text;
Board.BoardDescription = this.TxtBoardDescription.Text;
if ( this.RdPublic.Checked == true )
{
Board.BoardType = 1;
}
else
{
Board.BoardType = 0;
}
BBS.BBSAddBoard(Board);
//Response.Write("<script language=javascript>alert('��ӳɹ�!');parent.location.reload();</script>");
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
finally
{
BBS = null;
Board = null;
Server.Transfer("Catalog.aspx?classID="+classid);
}
}
else if ( m_Action == "ModifyBoard")
{
//�༩���
BBSClass BBS = new BBSClass();
BBSBoard Board = new BBSBoard();
HttpCookie UserCookie = Request.Cookies["Username"];
String Username = UserCookie.Value.ToString();
//try
{
Board.BoardID = Int32.Parse (m_BoardID);
Board.BoardName = this.TxtBoardName.Text;
Board.BoardDescription = this.TxtBoardDescription.Text;
if ( this.RdPublic.Checked == true )
{
Board.BoardType = 1;
}
else
{
Board.BoardType = 0;
}
BBS.EditBBSBoard (Board);
Server.Transfer("Catalog.aspx?classID="+classid);
}
//catch (Exception ex)
{
// UDS.Components.Error.Log(ex.ToString());
// Server.Transfer("../../Error.aspx");
}
//finally
{
BBS = null;
Board = null;
}
}
}
/// <summary>
/// 显示数据
/// </summary>
private void PopulateData()
{
#region 初始化数据
DataTable dataTable_catalog = new DataTable();
DataTable dataTable_board = new DataTable();
DataTable dataTable_boardmaster = new DataTable();
DataSet ds = new DataSet();
SqlDataReader dr_catalog = null;
SqlDataReader dr_board = null;
SqlDataReader dr_boardmaster = null;
BBSClass bbsclass = new BBSClass();
BBSCatalog catalog = new BBSCatalog(); //分类
BBSBoard board = new BBSBoard(); //板块
BBSForumItem item = new BBSForumItem(); //贴子的信息
BBSBoardmaster master = new BBSBoardmaster(); //斑竹信息
BBSReplay replay = new BBSReplay(); //回复信息
#endregion
//try
//判断权限
Admin = bbsclass.AdminBBS(Username, Int32.Parse(classid));
ViewState["Admin"] = Admin;
Bulletin = bbsclass.AdminSysBulletin(Username, Int32.Parse(classid));
ViewState["Bulletin"] = Bulletin;
A1.Visible = Admin;
//得到类别信息
dr_catalog = bbsclass.GetBBSCatalog();
if (Admin)
{
HttpCookie cookie = new HttpCookie("UDSBBSAdmin", "1");
Response.Cookies.Add(cookie);
}
else
{
HttpCookie cookie = new HttpCookie("UDSBBSAdmin", "0");
Response.Cookies.Add(cookie);
}
if (Bulletin)
{
HttpCookie cookie1 = new HttpCookie("UDSBBSBulletinAdmin", "1");
Response.Cookies.Add(cookie1);
}
else
{
HttpCookie cookie1 = new HttpCookie("UDSBBSBulletinAdmin", "0");
Response.Cookies.Add(cookie1);
}
dataTable_catalog = Tools.ConvertDataReaderToDataTable(dr_catalog);
dataTable_catalog.TableName = "catalogTable";
ds.Tables.Add(dataTable_catalog);
//得到板块信息
if (Admin)
{
dr_board = bbsclass.GetAllBBSBoard();
}
else
{
dr_board = bbsclass.GetBBSBoard((string)Username);
}
dataTable_board = Tools.ConvertDataReaderToDataTable(dr_board);
dataTable_board.TableName = "boardTable";
ds.Tables.Add(dataTable_board);
//得到斑竹信息
dr_boardmaster = bbsclass.GetBoardMaster();
dataTable_boardmaster = Tools.ConvertDataReaderToDataTable(dr_boardmaster);
dataTable_boardmaster.TableName = "boardmasterTable";
ds.Tables.Add(dataTable_boardmaster);
//对子表进行数据绑定
ds.Relations.Add("catolog_board", ds.Tables["catalogTable"].Columns["catalog_id"], ds.Tables["boardTable"].Columns["catalog_id"], false);
ds.Relations.Add("board_boardmaster", ds.Tables["boardTable"].Columns["board_id"], ds.Tables["boardmasterTable"].Columns["board_id"], false);
rpt_catalog.DataSource = ds.Tables["catalogTable"].DefaultView;
Page.DataBind();
}
//���°����Ϣ
public bool EditBBSBoard(BBSBoard BBSBoard)
{
//@board_id int, : �����µİ��ID
//@board_name varchar(300) : �������
//@board_description varchar(300), : ������
//@board_type bit : �������(�����ͣ�˽����)
// ���洢���̴��ݲ���
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@board_id", SqlDbType.Int, 4, BBSBoard.BoardID),
data.MakeInParam("@board_name", SqlDbType.VarChar, 300, BBSBoard.BoardName),
data.MakeInParam("@board_description", SqlDbType.VarChar ,300, BBSBoard.BoardDescription),
data.MakeInParam("@board_type", SqlDbType.Bit, 1 ,BBSBoard.BoardType),
};
//try
{
data.RunProc ("sp_BBS_UpdateBoardInfo",prams);
return true;
}
//catch (Exception ex)
{
// Error.Log(ex.ToString());
// throw new Exception("BBS���༩����!",ex);
}
}
//��BBS������ ��Ӱ��
public bool BBSAddBoard(BBSBoard BBSBoard)
{
//����洢���̴��ݵIJ�������
//@catalog_id (int) ����ID��, @title (varchar(300)) ̧ͷ������, @content ntext �������, @boardtype bit �������
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam ("@catalog_id", SqlDbType.Int, 4, BBSBoard.CatalogID ),
data.MakeInParam ("@title", SqlDbType.VarChar, 300, BBSBoard.BoardName ),
data.MakeInParam ("@content", SqlDbType.NText, 16, BBSBoard.BoardDescription ),
data.MakeInParam ("@boardtype", SqlDbType.Bit, 1, BBSBoard.BoardType ),
};
data.RunProc ("sp_BBS_AddBoard",prams);
return true;
}
/// <summary>
/// ��ʾ����
/// </summary>
private void PopulateData()
{
#region ��ʼ������
DataTable dataTable_catalog = new DataTable();
DataTable dataTable_board = new DataTable();
DataTable dataTable_boardmaster = new DataTable();
DataSet ds = new DataSet();
SqlDataReader dr_catalog = null;
SqlDataReader dr_board = null;
SqlDataReader dr_boardmaster = null;
BBSClass bbsclass = new BBSClass();
BBSCatalog catalog = new BBSCatalog();//����
BBSBoard board = new BBSBoard();//���
BBSForumItem item = new BBSForumItem();//���ӵ���Ϣ
BBSBoardmaster master = new BBSBoardmaster();//������Ϣ
BBSReplay replay = new BBSReplay();//�ظ���Ϣ
#endregion
try
{
//try
//�ж�Ȩ��
Admin = bbsclass.AdminBBS(Username, Int32.Parse(classid));
ViewState["Admin"] = Admin;
Bulletin = bbsclass.AdminSysBulletin(Username, Int32.Parse(classid));
ViewState["Bulletin"] = Bulletin;
A1.Visible = Admin;
//�õ������Ϣ
dr_catalog = bbsclass.GetBBSCatalog();
if (Admin)
{
HttpCookie cookie = new HttpCookie("UDSBBSAdmin", "1");
Response.Cookies.Add(cookie);
}
else
{
HttpCookie cookie = new HttpCookie("UDSBBSAdmin", "0");
Response.Cookies.Add(cookie);
}
if (Bulletin)
{
HttpCookie cookie1 = new HttpCookie("UDSBBSBulletinAdmin", "1");
Response.Cookies.Add(cookie1);
}
else
{
HttpCookie cookie1 = new HttpCookie("UDSBBSBulletinAdmin", "0");
Response.Cookies.Add(cookie1);
}
dataTable_catalog = Tools.ConvertDataReaderToDataTable(dr_catalog);
dataTable_catalog.TableName = "catalogTable";
ds.Tables.Add(dataTable_catalog);
//�õ������Ϣ
if (Admin)
dr_board = bbsclass.GetAllBBSBoard();
else
dr_board = bbsclass.GetBBSBoard((string)Username);
dataTable_board = Tools.ConvertDataReaderToDataTable(dr_board);
dataTable_board.TableName = "boardTable";
ds.Tables.Add(dataTable_board);
//�õ�������Ϣ
dr_boardmaster = bbsclass.GetBoardMaster();
dataTable_boardmaster = Tools.ConvertDataReaderToDataTable(dr_boardmaster);
dataTable_boardmaster.TableName = "boardmasterTable";
ds.Tables.Add(dataTable_boardmaster);
//���ӱ�������ݰ�
ds.Relations.Add("catolog_board", ds.Tables["catalogTable"].Columns["catalog_id"], ds.Tables["boardTable"].Columns["catalog_id"], false);
ds.Relations.Add("board_boardmaster", ds.Tables["boardTable"].Columns["board_id"], ds.Tables["boardmasterTable"].Columns["board_id"], false);
rpt_catalog.DataSource = ds.Tables["catalogTable"].DefaultView;
Page.DataBind();
}
finally
{
dr_board.Close();
dr_boardmaster.Close();
dr_catalog.Close();
}
}
//更新板块信息
public bool EditBBSBoard(BBSBoard BBSBoard)
{
//@board_id int, : 被更新的板块ID
//@board_name varchar(300) : 板块名称
//@board_description varchar(300), : 板块介绍
//@board_type bit : 板块类型(公共型，私有型)
// 给存储过程传递参数
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@board_id", SqlDbType.Int, 4, BBSBoard.BoardID),
data.MakeInParam("@board_name", SqlDbType.VarChar, 300, BBSBoard.BoardName),
data.MakeInParam("@board_description", SqlDbType.VarChar ,300, BBSBoard.BoardDescription),
data.MakeInParam("@board_type", SqlDbType.Bit, 1 ,BBSBoard.BoardType),
};
//try
{
try
{
data.RunProc("sp_BBS_UpdateBoardInfo", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
return true;
}
//catch (Exception ex)
{
// Error.Log(ex.ToString());
// throw new Exception("BBS板块编缉错误!",ex);
}
}
//在BBS大类中 添加板块
public bool BBSAddBoard(BBSBoard BBSBoard)
{
//需向存储过程传递的参数如下
//@catalog_id (int) 分类ID号, @title (varchar(300)) 抬头的名称, @content ntext 板块内容, @boardtype bit 板块类型
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam ("@catalog_id", SqlDbType.Int, 4, BBSBoard.CatalogID ),
data.MakeInParam ("@title", SqlDbType.VarChar, 300, BBSBoard.BoardName ),
data.MakeInParam ("@content", SqlDbType.NText, 16, BBSBoard.BoardDescription ),
data.MakeInParam ("@boardtype", SqlDbType.Bit, 1, BBSBoard.BoardType ),
};
try
{
data.RunProc("sp_BBS_AddBoard", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
return true;
}
