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());
}
}
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());
}
}
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("发布出错！");
}
}
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);
}
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);
}
private void BindData()
{
BBSClass bbs = new BBSClass();
BBSForumItem item = new BBSForumItem();
Database db = new Database();
SqlDataReader dr = null;
item.ItemID = itemid;
dr = bbs.ReadBBSForumItemReplay(item);
replaylist.DataSource = dr;
replaylist.DataBind();
dr.Close();
}
private void cbx_DeskTop_CheckedChanged(object sender, System.EventArgs e)
{
UDS.Components.BBSClass bbs = new UDS.Components.BBSClass();
BBSForumItem item = new BBSForumItem();
item.ItemID = itemid;
bbs.ReadBBSForumItemStruct(item);
if (((CheckBox)sender).Checked)
{
item.DeskTop = true;
}
else
{
item.DeskTop = false;
}
bbs.ModBBSForumItem(item);
}
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);
}
}
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);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
int itemid = (Request.QueryString["ItemID"] == null)?0:Int32.Parse(Request.QueryString["ItemID"].ToString());
int boardid = (Request.QueryString["BoardID"] == null)?0:Int32.Parse(Request.QueryString["BoardID"].ToString());
BBSClass bbs = new BBSClass();
BBSForumItem item = new BBSForumItem();
item.ItemID = itemid;
try
{
item.DelAttachment(Server.MapPath(".") + "\\Attachment\\");
bbs.DelItem(item);
Response.Write("<script>alert('删除成功');opener.location.reload();close();</script>");
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
private void cmdOK_ServerClick(object sender, System.EventArgs e)
{
BBSClass bbs = new BBSClass();
BBSForumItem olditem = new BBSForumItem();
BBSForumItem newitem = new BBSForumItem();
olditem.ItemID = itemid;
newitem.BoardID = Int32.Parse(ddlBoardList.SelectedItem.Value);
try
{
bbs.MoveBoardItem(olditem, newitem);
ddlBoardList.Visible = false;
cmdOK.Visible = false;
ltMessage.Visible = true;
ltMessage.Text = "移动成功！";
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
private void cmdOK_ServerClick(object sender, System.EventArgs e)
{
BBSClass bbs = new BBSClass();
BBSForumItem olditem = new BBSForumItem();
BBSForumItem newitem = new BBSForumItem();
olditem.ItemID = itemid;
newitem.BoardID = Int32.Parse(ddlBoardList.SelectedItem.Value);
try
{
bbs.MoveBoardItem(olditem,newitem);
ddlBoardList.Visible = false;
cmdOK.Visible = false;
ltMessage.Visible = true;
ltMessage.Text = "�ƶ��ɹ���";
}
catch(Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// �ڴ˴������û������Գ�ʼ��ҳ��
int itemid = (Request.QueryString["ItemID"]==null)?0:Int32.Parse(Request.QueryString["ItemID"].ToString());
int boardid = (Request.QueryString["BoardID"]==null)?0:Int32.Parse(Request.QueryString["BoardID"].ToString());
BBSClass bbs = new BBSClass();
BBSForumItem item = new BBSForumItem();
item.ItemID = itemid;
try
{
item.DelAttachment(Server.MapPath(".")+"\\Attachment\\");
bbs.DelItem(item);
Response.Write("<script>alert('ɾ���ɹ�');opener.location.reload();close();</script>");
}
catch(Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
private void cmdOK_ServerClick(object sender, System.EventArgs e)
{
BBSClass bbs = new BBSClass();
BBSForumItem item = new BBSForumItem();
string itemcontent = ViewState["Content"] + Content.Value;
item.BoardID = Int32.Parse(boardid);
item.Title = MyTitle.Value.Replace("<", "<");
item.Title = item.Title.Replace(">", ">");
if (item.Title.Trim() == "")
{
item.Title = "无标题";
}
item.Content = itemcontent.Replace("<", "<");
item.Content = item.Content.Replace(">", ">");
item.Sender = username;
item.IP = Request.ServerVariables["remote_addr"].ToString();
item.Bulletin = (cbx_bulletin == null)?false:cbx_bulletin.Checked;
item.SysBulletin = (cbx_bulletin == null)?false:cbx_sysbulletin.Checked;
item.DeskTop = (cbx_DeskTop == null)?false:cbx_DeskTop.Checked;
item.ItemID = bbs.SendItem(item);
if (ViewState["filename"] != null && ViewState["filename"].ToString().Trim() != "")
{
item.Attach(ViewState["filename"].ToString());
}
try
{
Response.Write("<script>if(opener!=null) {opener.location.reload();opener.parent.parent.header.location.reload();location.href='Display.aspx?ItemID=" + item.ItemID.ToString() + "&BoardID=" + item.BoardID.ToString() + "'}</script>");
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.Message);
Server.Transfer("../../Error.aspx");
}
}
private void BindGrid()
{
SqlDataReader dr = null;
DataTable dt = new DataTable();
BBSClass bbsclass = new BBSClass();
BBSForumItem bbsforumitem = new BBSForumItem();
bbsforumitem.BoardID = boardid;
try
{
dr = bbsclass.GetBBSForumItem(bbsforumitem);
dt = Tools.ConvertDataReaderToDataTable(dr);
//��DataTable��ĩβ���Ͽ��У�ʹ��DataGrid�̶�����
int blankrows = ItemList.PageSize - (dt.Rows.Count % ItemList.PageSize);
for (int i = 0; i < blankrows; i++)
{
dt.Rows.Add(dt.NewRow());
}
ItemList.DataSource = dt.DefaultView;
ItemList.DataBind();
string innerstring = "";
//��ʾ��鹫��
SqlDataReader dr_bulletin = bbsclass.GetBulletin(boardid);
try
{
while (dr_bulletin.Read())
{
innerstring += "<a href='display.aspx?ItemID=" + dr_bulletin["item_id"] + "&BoardID=" + boardid + "'title='" + dr_bulletin["content"] + "' target=_blank>" + dr_bulletin["title"].ToString() + "</a> (" + DateTime.Parse(dr_bulletin["send_time"].ToString()).ToString() + ") ";
}
}
finally
{
dr_bulletin.Close();
}
mar_bulletin.InnerHtml = innerstring;
innerstring = "";
//��ʾϵͳ����
SqlDataReader dr_sysbulletin = bbsclass.GetSysBulletin();
try
{
while (dr_sysbulletin.Read())
{
innerstring += "<a href='display.aspx?ItemID=" + dr_sysbulletin["item_id"] + "&BoardID=" + boardid + "'title='" + dr_sysbulletin["content"] + "' target=_blank>" + dr_sysbulletin["title"].ToString() + "</a>(" + DateTime.Parse(dr_sysbulletin["send_time"].ToString()).ToString() + ")";
}
}
finally
{
dr_sysbulletin.Close();
}
sys_bulletin.InnerHtml = innerstring;
//���ڿռ�¼����ʾͼƬ��������Ϣ
for (int i = 0; i < ItemList.Items.Count; i++)
{
if (ItemList.DataKeys[i].ToString() == "")
{
ItemList.Items[i].FindControl("bias").Visible = false;
ItemList.Items[i].FindControl("image").Visible = false;
}
}
lbl_totalrecord.Text = ItemList.PageCount.ToString();
lbl_curpage.Text = txb_PageNo.Text = (ItemList.CurrentPageIndex + 1).ToString();
txb_ItemPerPage.Text = ItemList.PageSize.ToString();
lbl_totalpage.Text = ItemList.PageCount.ToString();
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.Message);
Server.Transfer("../../Error.aspx");
}
finally
{
if (dr != null)
{
dr.Close();
}
}
}
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("���������");
}
}
/// <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();
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
username = Request.Cookies["Username"].Value;
itemid = (Request.QueryString["ItemID"]==null)?0:Int32.Parse(Request.QueryString["ItemID"].ToString());
boardid = (Request.QueryString["BoardID"]==null)?0:Int32.Parse(Request.QueryString["BoardID"].ToString());
ViewState["username"] = username;
ViewState["itemid"] = itemid;
ViewState["boardid"] = boardid;
ViewState["isboardmaster"] = isboardmaster;
BBSClass bbsclass = new BBSClass();
BBSForumItem bbsforumitem = new BBSForumItem();
bbsforumitem.ItemID = itemid;
SqlDataReader dr = null;
dr = bbsclass.ReadBBSForumItem(bbsforumitem);
//�ж��Ƿ��ǰ���
isboardmaster = bbsclass.IsBoardMaster(boardid,username);
if(isboardmaster)
cbx_boardBulletin.Visible = true;
else
cbx_boardBulletin.Visible = false;
if(Request.Cookies["UDSBBSAdmin"]!=null)
{
if(Request.Cookies["UDSBBSAdmin"].Value=="1")
cbx_sysBulletin.Visible = true;
else
cbx_sysBulletin.Visible = false;
}
else
{
cbx_sysBulletin.Visible = false;
cbx_sysBulletin.Visible = false;
}
while(dr.Read())
{
this.title = lblTitle.Text = dr["title"].ToString();
sendtime.Text = dr["send_time"].ToString();
browsetime.Text = dr["hit_times"].ToString();
replaytimes.Text = dr["replay_times"].ToString();
sendman.Text = dr["sender"].ToString();
//�ж��Ƿ���ϵͳ���棬�����ֻ�й���Ա�ܹ�����
if(Boolean.Parse(dr["sysbulletin"].ToString()))
{
if(Request.Cookies["UDSBBSAdmin"]!=null)
{
if(Request.Cookies["UDSBBSAdmin"].Value=="1")
{
itemcontent.InnerHtml += "<b>�٣�����</b><a href=javascript:window.open('DeleteItem.aspx?ItemID=" + itemid + "&BoardID=" + boardid + "','_self','');>ɾ������</a>|<a href='MoveItem.aspx?ItemID=" + itemid + "'>�ƶ�����</a><br><hr color='#C0C0C0' size='1'>";
cbx_DeskTop.Visible = true;
cbx_sysBulletin.Checked = true;
if(Boolean.Parse(dr["DeskTop"].ToString()))
{
cbx_DeskTop.Checked = true;
}
else
cbx_DeskTop.Checked = false;
}
else
{
cbx_sysBulletin.Checked = false;
}
}
}
else
{
if((Request.Cookies["UDSBBSAdmin"].Value=="1")||(isboardmaster))
{
itemcontent.InnerHtml += "<b>�٣�����</b><a href=javascript:window.open('DeleteItem.aspx?ItemID=" + itemid + "&BoardID=" + boardid + "','_self','');>ɾ������</a>|<a href='MoveItem.aspx?ItemID=" + itemid + "'>�ƶ�����</a><br><hr color='#C0C0C0' size='1'>";
cbx_DeskTop.Visible = false;
if(Boolean.Parse(dr["bulletin"].ToString()))
{
cbx_boardBulletin.Checked = true;
}
else
{
cbx_boardBulletin.Checked = false;
}
}
}
itemcontent.InnerHtml += FormatTxt(UBB.txtMessage(dr["content"].ToString()));
}
dr.Close();
BindData();
}
else
{
username = ViewState["username"].ToString();
itemid = Int32.Parse(ViewState["itemid"].ToString());
boardid = Int32.Parse(ViewState["boardid"].ToString());
isboardmaster = Boolean.Parse(ViewState["isboardmaster"].ToString());
}
}
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;
}
}
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());
}
}
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);
}
/// <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 void DelItem(BBSForumItem item)
{
Database data = new Database ();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4,item.ItemID)
};
data.RunProc ("sp_BBSDeleteItem",prams);
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
username = Request.Cookies["Username"].Value;
itemid = (Request.QueryString["ItemID"] == null)?0:Int32.Parse(Request.QueryString["ItemID"].ToString());
boardid = (Request.QueryString["BoardID"] == null)?0:Int32.Parse(Request.QueryString["BoardID"].ToString());
ViewState["username"] = username;
ViewState["itemid"] = itemid;
ViewState["boardid"] = boardid;
ViewState["isboardmaster"] = isboardmaster;
BBSClass bbsclass = new BBSClass();
BBSForumItem bbsforumitem = new BBSForumItem();
bbsforumitem.ItemID = itemid;
SqlDataReader dr = null;
dr = bbsclass.ReadBBSForumItem(bbsforumitem);
//判断是否是斑竹
isboardmaster = bbsclass.IsBoardMaster(boardid, username);
if (isboardmaster)
{
cbx_boardBulletin.Visible = true;
}
else
{
cbx_boardBulletin.Visible = false;
}
if (Request.Cookies["UDSBBSAdmin"] != null)
{
if (Request.Cookies["UDSBBSAdmin"].Value == "1")
{
cbx_sysBulletin.Visible = true;
}
else
{
cbx_sysBulletin.Visible = false;
}
}
else
{
cbx_sysBulletin.Visible = false;
cbx_sysBulletin.Visible = false;
}
while (dr.Read())
{
this.title = lblTitle.Text = dr["title"].ToString();
sendtime.Text = dr["send_time"].ToString();
browsetime.Text = dr["hit_times"].ToString();
replaytimes.Text = dr["replay_times"].ToString();
sendman.Text = dr["sender"].ToString();
//判断是否是系统公告，如果是只有管理员能够操作
if (Boolean.Parse(dr["sysbulletin"].ToString()))
{
if (Request.Cookies["UDSBBSAdmin"] != null)
{
if (Request.Cookies["UDSBBSAdmin"].Value == "1")
{
itemcontent.InnerHtml += "<b>操作：</b><a href=javascript:window.open('DeleteItem.aspx?ItemID=" + itemid + "&BoardID=" + boardid + "','_self','');>删除此贴</a>|<a href='MoveItem.aspx?ItemID=" + itemid + "'>移动帖子</a><br><hr color='#C0C0C0' size='1'>";
cbx_DeskTop.Visible = true;
cbx_sysBulletin.Checked = true;
if (Boolean.Parse(dr["DeskTop"].ToString()))
{
cbx_DeskTop.Checked = true;
}
else
{
cbx_DeskTop.Checked = false;
}
}
else
{
cbx_sysBulletin.Checked = false;
}
}
}
else
{
if ((Request.Cookies["UDSBBSAdmin"].Value == "1") || (isboardmaster))
{
itemcontent.InnerHtml += "<b>操作：</b><a href=javascript:window.open('DeleteItem.aspx?ItemID=" + itemid + "&BoardID=" + boardid + "','_self','');>删除此贴</a>|<a href='MoveItem.aspx?ItemID=" + itemid + "'>移动帖子</a><br><hr color='#C0C0C0' size='1'>";
cbx_DeskTop.Visible = false;
if (Boolean.Parse(dr["bulletin"].ToString()))
{
cbx_boardBulletin.Checked = true;
}
else
{
cbx_boardBulletin.Checked = false;
}
}
}
itemcontent.InnerHtml += FormatTxt(UBB.txtMessage(dr["content"].ToString()));
}
dr.Close();
BindData();
}
else
{
username = ViewState["username"].ToString();
itemid = Int32.Parse(ViewState["itemid"].ToString());
boardid = Int32.Parse(ViewState["boardid"].ToString());
isboardmaster = Boolean.Parse(ViewState["isboardmaster"].ToString());
}
}
private void BindGrid()
{
SqlDataReader dr = null;
DataTable dt = new DataTable();
BBSClass bbsclass = new BBSClass();
BBSForumItem bbsforumitem = new BBSForumItem();
bbsforumitem.BoardID = boardid;
try
{
dr = bbsclass.GetBBSForumItem(bbsforumitem);
dt = Tools.ConvertDataReaderToDataTable(dr);
//在DataTable的末尾加上空行，使得DataGrid固定行数
int blankrows = ItemList.PageSize - (dt.Rows.Count % ItemList.PageSize);
for (int i = 0; i < blankrows; i++)
{
dt.Rows.Add(dt.NewRow());
}
ItemList.DataSource = dt.DefaultView;
ItemList.DataBind();
string innerstring = "";
//显示板块公告
SqlDataReader dr_bulletin = bbsclass.GetBulletin(boardid);
while (dr_bulletin.Read())
{
innerstring += "<a href='display.aspx?ItemID=" + dr_bulletin["item_id"] + "&BoardID=" + boardid + "'title='" + dr_bulletin["content"] + "' target=_blank>" + dr_bulletin["title"].ToString() + "</a> (" + DateTime.Parse(dr_bulletin["send_time"].ToString()).ToString() + ") ";
}
dr_bulletin.Close();
mar_bulletin.InnerHtml = innerstring;
innerstring = "";
//显示系统公告
SqlDataReader dr_sysbulletin = bbsclass.GetSysBulletin();
while (dr_sysbulletin.Read())
{
innerstring += "<a href='display.aspx?ItemID=" + dr_sysbulletin["item_id"] + "&BoardID=" + boardid + "'title='" + dr_sysbulletin["content"] + "' target=_blank>" + dr_sysbulletin["title"].ToString() + "</a>(" + DateTime.Parse(dr_sysbulletin["send_time"].ToString()).ToString() + ")";
}
dr_sysbulletin.Close();
sys_bulletin.InnerHtml = innerstring;
//对于空纪录不显示图片等其他信息
for (int i = 0; i < ItemList.Items.Count; i++)
{
if (ItemList.DataKeys[i].ToString() == "")
{
ItemList.Items[i].FindControl("bias").Visible = false;
ItemList.Items[i].FindControl("image").Visible = false;
}
}
lbl_totalrecord.Text = ItemList.PageCount.ToString();
lbl_curpage.Text = txb_PageNo.Text = (ItemList.CurrentPageIndex + 1).ToString();
txb_ItemPerPage.Text = ItemList.PageSize.ToString();
lbl_totalpage.Text = ItemList.PageCount.ToString();
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.Message);
Server.Transfer("../../Error.aspx");
}
}
public void DelItem(BBSForumItem item)
{
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@item_id", SqlDbType.Int, 4,item.ItemID)
};
try
{
data.RunProc("sp_BBSDeleteItem", prams);
}
finally
{
if (data != null)
{
data.Close();
data.Dispose();
}
}
}
private void BindData()
{
BBSClass bbs = new BBSClass();
BBSForumItem item = new BBSForumItem();
Database db = new Database();
SqlDataReader dr = null;
item.ItemID = itemid;
dr = bbs.ReadBBSForumItemReplay(item);
replaylist.DataSource = dr;
replaylist.DataBind();
dr.Close();
}
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;
}
}
private void cbx_sysBulletin_CheckedChanged(object sender, System.EventArgs e)
{
UDS.Components.BBSClass bbs = new UDS.Components.BBSClass();
BBSForumItem item = new BBSForumItem();
item.ItemID = itemid;
bbs.ReadBBSForumItemStruct(item);
if(((CheckBox)sender).Checked)
{
item.SysBulletin = true;
}
else
{
item.SysBulletin = false;
item.DeskTop = false;
cbx_DeskTop.Enabled = false;
}
bbs.ModBBSForumItem(item);
}
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());
}
}
private void cmdOK_ServerClick(object sender, System.EventArgs e)
{
BBSClass bbs = new BBSClass();
BBSForumItem item = new BBSForumItem();
string itemcontent = ViewState["Content"] + Content.Value;
item.BoardID = Int32.Parse(boardid);
item.Title = MyTitle.Value.Replace("<","<");
item.Title = item.Title.Replace(">",">");
if(item.Title.Trim()=="") item.Title = "�ޱ���";
item.Content = itemcontent.Replace("<","<");
item.Content = item.Content.Replace(">",">");
item.Sender = username;
item.IP = Request.ServerVariables["remote_addr"].ToString();
item.Bulletin = (cbx_bulletin==null)?false:cbx_bulletin.Checked;
item.SysBulletin = (cbx_bulletin==null)?false:cbx_sysbulletin.Checked;
item.DeskTop = (cbx_DeskTop==null)?false:cbx_DeskTop.Checked;
item.ItemID = bbs.SendItem(item);
if(ViewState["filename"]!=null && ViewState["filename"].ToString().Trim()!="")
item.Attach(ViewState["filename"].ToString());
try
{
Response.Write("<script>if(opener!=null) {opener.location.reload();opener.parent.parent.header.location.reload();location.href='Display.aspx?ItemID="+item.ItemID.ToString()+"&BoardID="+item.BoardID.ToString()+"'}</script>");
}
catch(Exception ex)
{
UDS.Components.Error.Log(ex.Message);
Server.Transfer("../../Error.aspx");
}
}
private void BindData()
{
BBSClass bbs = new BBSClass();
BBSForumItem item = new BBSForumItem();
Database db = new Database();
SqlDataReader dr = null;
try
{
item.ItemID = itemid;
dr = bbs.ReadBBSForumItemReplay(item);
replaylist.DataSource = dr;
replaylist.DataBind();
lbx_AttList.Items.Clear();
}
finally
{
if (dr != null)
{
dr.Close();
}
}
}
