protected void Button3_Click(object sender, EventArgs e) { Model.Helpcate mh = new Model.Helpcate(); BLL.Helpcate bh = new BLL.Helpcate(); int result = 0; for (int i = 0; i < GridView1.Rows.Count; i++) { CheckBox cb = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1"); if (cb.Checked) { mh.ID = Convert.ToInt32(GridView1.DataKeys[i].Value); result = bh._delete(mh); } } if (result > 0) { Response.Write("<script>alert('删除成功'),location.href='helpcatelist.aspx'</script>"); } else { Response.Write("<script>alert('删除失败'),location.href='helpcatelist.aspx'</script>"); } }
protected void up() { Model.Helpcate mh = new Model.Helpcate(); mh.ID = Convert.ToInt32(Request.QueryString["uid"]); BLL.Helpcate bh = new BLL.Helpcate(); MySqlDataReader dr = bh.sqlDataReader(mh); if (dr.Read()) { Label1.Text = dr["_cateid"].ToString(); name.Text = dr["_catename"].ToString(); } dr.Close(); }
protected void Button1_Click(object sender, EventArgs e) { Model.Helpcate mh = new Model.Helpcate(); BLL.Helpcate bn = new BLL.Helpcate(); mh.Catename = TextBox1.Text; int result = bn.insert(mh); if (result > 0) { Response.Write("<script>alert('添加成功'),location.href='helpcatelist.aspx'</script>"); } else { Response.Write("<script>alert('添加失败'),location.href='helpcatelist.aspx'</script>"); } }
protected void 提交_Click(object sender, EventArgs e) { Model.Helpcate mh = new Model.Helpcate(); mh.ID = Convert.ToInt32(Request.QueryString["uid"]); mh.Catename = name.Text; BLL.Helpcate bh = new BLL.Helpcate(); int result = bh.update(mh); if (result > 0) { Response.Write("<script>alert('更新成功'),location.href='helpcatelist.aspx'</script>"); } else { Response.Write("<script>alert('更新失败'),location.href='helpcatelist.aspx'</script>"); } }
protected void up() { Model.Helpcate mh = new Model.Helpcate(); mh.ID = Convert.ToInt32(Request.QueryString["uid"]); BLL.Helpcate bh = new BLL.Helpcate(); SqlDataReader dr = bh.sqldatareader(mh); if (dr.Read()) { Label1.Text = dr["_cateid"].ToString(); name.Text = dr["_catename"].ToString(); } dr.Close(); }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); BLLHelpcate bllhelpcate = new BLLHelpcate(); DataSet ds = bllhelpcate.select(); Repeater1.DataSource = ds; Repeater1.DataBind(); DataSet ds2 = bllhelpcate.select(id); Repeater3.DataSource = ds2; Repeater3.DataBind(); BLLhelp bllhelp = new BLLhelp(); DataSet ds1 = bllhelp.selectAll(id); Repeater2.DataSource = ds1; Repeater2.DataBind(); Model.Helpcate helpcate = new Model.Helpcate(); helpcate.ID = id; SqlDataReader sdr = bllhelpcate.sqldatareader(helpcate); if (sdr.Read()) { Page.Title = sdr["_catename"].ToString(); } else { sdr.Close(); if (Label1.Text == "个人注册及信息管理") { Response.Write(Label1.Text); Page.Title = "个人注册及信息管理"; } } }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); BLLHelpcate bllhelpcate = new BLLHelpcate(); DataSet ds = bllhelpcate.select(); Repeater1.DataSource = ds; Repeater1.DataBind(); DataSet ds2 = bllhelpcate.select(id); Repeater3.DataSource = ds2; Repeater3.DataBind(); BLLhelp bllhelp = new BLLhelp(); DataSet ds1 = bllhelp.selectAll(id); Repeater2.DataSource = ds1; Repeater2.DataBind(); Model.Helpcate helpcate=new Model.Helpcate(); helpcate.ID=id; MySqlDataReader sdr = bllhelpcate.sqldatareader(helpcate); if (sdr.Read()) { Page.Title = sdr["_catename"].ToString(); } else { sdr.Close(); if (Label1.Text == "个人注册及信息管理") { Response.Write(Label1.Text); Page.Title = "个人注册及信息管理"; } } }