//发布系统公告
public int fabuXTGG(XTGG gg)
{
string sql = "insert into XTGG (GGHead,GGcontent,GGauthor,GGdateTime) values (@GGHead,@GGcontent,@GGauthor,@GGdateTime) ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@GGHead", gg.GGHead),
new SqlParameter("@GGContent", gg.GGcontent),
new SqlParameter("@GGauthor", gg.GGauthor),
new SqlParameter("@GGdateTime", gg.GGdateTime)
};
return(new Helper.SQLHelper().update(sql, param, false));
}
protected void btn_submit_Click(object sender, EventArgs e)
{
XTGG gg = new XTGG()
{
GGauthor = ((Model.Login)Session["CurrentUser"]).StuName,
GGdateTime = DateTime.Now,
GGHead = GGHead.Text.Trim().ToString(),
GGcontent = editor1.Text
};
int result = new GGManage().fabuXTGG(gg);
if (result > 0)
{
Literal1.Text = "<script type='text/javascript'>alert('公告发布成功！');history.go(-2)</script>";
btn_submit.Enabled = false;
}
else
{
Literal1.Text = "<script type='text/javascript'>alert('公告发布失败！');</script>";
}
}
//查看公告详细信息
public XTGG queryDetail(int GGId)
{
string sql = "select Id ,GGHead,GGContent,GGauthor,GGdateTime from XTGG where Id = @GGId";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@GGId", GGId)
};
XTGG gg = null;
SqlDataReader res = new Helper.SQLHelper().queryAllResult(sql, param, false);
while (res.Read())
{
gg = new XTGG()
{
GGHead = res["GGHead"].ToString(),
GGcontent = res["GGContent"].ToString(),
GGauthor = res["GGauthor"].ToString(),
GGdateTime = Convert.ToDateTime(res["GGdateTime"])
};
}
return(gg);
}
//发布公告
public int fabuXTGG(XTGG gg)
{
return(new GGService().fabuXTGG(gg));
}