public void BindAct_sign() { int id = Convert.ToInt32(Request.QueryString["id"]); DataTable dt = Activity_signManager.SelectAct_sign(id); if (dt != null && dt.Rows.Count > 0) { LVlist.DataSource = dt; LVlist.DataBind(); } }
protected void Btnjoin_click(object sender, EventArgs e) { if (Session["user_name"] != null) { Button btn = (Button)sender; string sql = "select* from activity_sign where activity_id=@activity_id and user_name=@user_name"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@activity_id", Int32.Parse((btn.Parent.FindControl("HiddenFieldComID") as HiddenField).Value)), new SqlParameter("@user_name", ((TextBox)btn.Parent.FindControl("txtname")).Text.Trim()), }; SqlDataReader dr = DBHelper.GetDataReader(sql, para); if (dr.Read()) { ScriptManager.RegisterClientScriptBlock(updatejoin, this.GetType(), "click", "alert('用户已报名!')", true); } else { if (Page.IsValid) { string a = ((TextBox)btn.Parent.FindControl("txtname")).Text.Trim(); string b = ((TextBox)btn.Parent.FindControl("txtphone")).Text.Trim(); activity_sign us = new activity_sign(); us.user_id = int.Parse(Session["user_id"].ToString()); us.activity_id = Int32.Parse((btn.Parent.FindControl("HiddenFieldComID") as HiddenField).Value); us.sign_time = DateTime.Now; us.user_name = ((TextBox)btn.Parent.FindControl("txtname")).Text.Trim(); us.user_phone = ((TextBox)btn.Parent.FindControl("txtphone")).Text.Trim(); int result = Activity_signManager.InsertActSign(us); if (result == 1) { ScriptManager.RegisterClientScriptBlock(updatejoin, this.GetType(), "click", "alert('报名成功!')", true); } else { ScriptManager.RegisterClientScriptBlock(updatejoin, this.GetType(), "click", "alert('报名失败!')", true); } } } } else { ScriptManager.RegisterClientScriptBlock(updatejoin, this.GetType(), "click", "alert('您必须先登录才能报名!')", true); ScriptManager.RegisterStartupScript(updatejoin, updatejoin.GetType(), "updateScript", "window.location.href='login1.aspx'", true); } }