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);
}
}
