public void GetOneMessage()
{
Fannie.Message mess = new Fannie.Message();
DataSet ds = mess.GetOneNotice(id);
tbTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString();
tbContent.Text = ds.Tables[0].Rows[0]["Contents"].ToString();
lbTime.Text = ds.Tables[0].Rows[0]["SenderTime"].ToString();
}
protected void gvNotice_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Fannie.Message mes = new Fannie.Message();
int id = Convert.ToInt32(gvNotice.DataKeys[e.RowIndex].Value);
if (mes.DeleteNotice(id) > 0)
{
Response.Write("<script>alert('删除成功')</script>");
GetAllNotice();
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
string title = tbTitle.Text;
string manager = Request.Cookies["user"].Value.ToString();
string content = tbContent.Text;
string year = tYeat.Value;
string[] str = new string[4] {
title, manager, content, year
};
Fannie.Message mes = new Fannie.Message();
if (mes.InsertNotice(str) > 0)
{
Response.Write("<script>alert('成功发布公告');location.href='../Public/Message.aspx'</script>");
}
}
private void GetAllNotice()
{
Fannie.Message mes = new Fannie.Message();
DataSet ds = mes.GetAllNotice();
DataColumn dc = new DataColumn();
dc.ColumnName = "PId";
ds.Tables[0].Columns.Add(dc);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["Pid"] = (i + 1).ToString();
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["Title"] = SubStr(Convert.ToString(ds.Tables[0].Rows[i]["Title"]), 40);
ds.Tables[0].Rows[i]["Contents"] = SubStr(Convert.ToString(ds.Tables[0].Rows[i]["Contents"]), 50);
}
gvNotice.DataKeyNames = new string[] { "NoticeNo" };
gvNotice.DataSource = ds;
gvNotice.DataBind();
}
