//更新板块信息 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; }