public void binddata() { BLLmessage bllmessage = new BLLmessage(); DataSet ds = bllmessage.h_select(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "message"); GridView1.DataSource = ds; GridView1.DataBind(); }
protected void Button3_Click(object sender, EventArgs e) { for (int i = 0; i < GridView1.Rows.Count; i++) { CheckBox cb = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1"); if (cb.Checked) { int id = Convert.ToInt32(GridView1.DataKeys[i].Value); message mes = new message(); mes.id = id; mes.state = 1; BLLmessage bllmessage = new BLLmessage(); int result = bllmessage.p_update(mes); if (result > 0) { Response.Write("<script>alert('批量审核成功');location.href='../message.aspx'</script>"); } else { Common.MessageAlert.Alert(Page, "alert('批量审核失败');"); } } } }
public void bindmes() { string title = Request.QueryString["_title"].ToString(); BLLmessage bllmessage = new BLLmessage(); DataSet ds = bllmessage.messelect(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "info", title); GridView1.DataSource = ds; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { //BLLmessage bllmessage = new BLLmessage(); //DataSet ds = bllmessage.select(); //DataList1.DataSource = ds; //DataList1.DataBind(); if (!IsPostBack) { BLLmessage bllmessage = new BLLmessage(); int result = bllmessage.message_state(); AspNetPager1.RecordCount = result; AspNetPager1.PageSize = 5; binddata(); } }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["_id"]); message mes = new message(); mes.id = id; BLLmessage bllmessage = new BLLmessage(); MySqlDataReader sdr = bllmessage.readmessage(mes); if (sdr.Read()) { Label1.Text = sdr["_title"].ToString(); TextBox1.Text = sdr["_content"].ToString(); Label3.Text = sdr["_posttime"].ToString(); } sdr.Close(); }
protected void Button1_Click(object sender, EventArgs e) { message mes = new message(); mes.id = Convert.ToInt32(Request.QueryString["_id"]); mes.reply = TextBox2.Text; mes.state = 1; BLLmessage bllmessage = new BLLmessage(); int result = bllmessage.reply(mes); if (result > 0) { Response.Write("<script>alert('回复留言成功');location.href='../message.aspx'</script>"); } else { Response.Write("<script>alert('回复留言失败');</script>"); } }
public string insert(string title, string content) { Model.message mes = new Model.message(); mes.title = title; mes.content = content; mes.ip = Request.UserHostAddress; BLL.BLLmessage bllmessage = new BLL.BLLmessage(); int result = bllmessage.post(mes); if (result > 0) { return("1"); } else { return("0"); } }
public string insert(string title,string content) { Model.message mes = new Model.message(); mes.title = title; mes.content = content; mes.ip = Request.UserHostAddress; BLL.BLLmessage bllmessage = new BLL.BLLmessage(); int result = bllmessage.post(mes); if (result > 0) { return "1"; } else { return "0"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BLLmessage bllmessage = new BLLmessage(); int result = bllmessage.messageCount(); AspNetPager1.RecordCount = result; AspNetPager1.PageSize = 10; binddata(); } }
protected void Page_Load(object sender, EventArgs e) { string title = Request.QueryString["_title"].ToString(); if (!IsPostBack) { BLLmessage bllmessage = new BLLmessage(); int result = bllmessage.mes_select(title); AspNetPager1.RecordCount = result; if (result > 0) { AspNetPager1.PageSize = 5; bindmes(); Label1.Visible = false; } else { Button1.Visible = false; Button2.Visible = false; Button3.Visible = false; Button4.Visible = false; Button5.Visible = false; Button6.Visible = false; Button7.Visible = false; txt_search.Visible = false; Label1.Text = "对不起,没有搜索的相关信息"; Label1.Visible = true; AspNetPager1.Visible = false; } } }