/// <summary> /// Page_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //判断是否存在该id的公告 int id = int.Parse(Request.QueryString["id"].ToString()); AnnouncementEntity ae = AnnouncementOperation.GetAM(int.Parse(Request.QueryString["id"].ToString())); if (ae == null) { SmallScript.MessageBox(Page, "不存在该公告!点击返回!"); SmallScript.GoBack(Page); return; } else { //在表单中显示数据 DataBase db = new DataBase(); DataSet sql = db.ExCommand(string.Format("SELECT tb_announcement.id, tb_announcement.uid, tb_announcement.amtitle, tb_announcement.essay, tb_announcement.uptime, tb_user.userName FROM tb_announcement INNER JOIN tb_user ON tb_announcement.uid = tb_user.id WHERE (tb_announcement.id ={0} )", id)); string User = sql.Tables[0].Rows[0]["userName"].ToString(); lb_ID.Text = ae.Id.ToString(); tb_amtitle.Text = ae.AmTitle; lb_User.Text = User; lb_essay.Text = ae.Essay; lb_UpTime.Text = ae.Time.ToString(); } } }
/// <summary> /// Page_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = int.Parse(Request.QueryString["id"].ToString()); AnnouncementEntity ae = AnnouncementOperation.GetAM(int.Parse(Request.QueryString["id"].ToString())); if (ae != null) { DataBase db = new DataBase(); DataSet sql = db.ExCommand(string.Format("SELECT tb_announcement.id, tb_announcement.uid, tb_announcement.amtitle, tb_announcement.essay, tb_announcement.uptime, tb_user.userName FROM tb_announcement INNER JOIN tb_user ON tb_announcement.uid = tb_user.id WHERE (tb_announcement.id ={0} ) ", id)); string User = sql.Tables[0].Rows[0]["userName"].ToString(); //在表单中显示数据 lb_Id.Text = ae.Id.ToString(); lb_amtitle.Text = ae.AmTitle; lb_User.Text = User; lb_UpTime.Text = ae.Time.ToString(); lb_essay.Text = ae.Essay; } } }