public int InsertActSign(activity_sign ActSign)
{
string sql = "insert into activity_sign(user_id,activity_id,sign_time) values(@user_id,@activity_id,@sign_time)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@user_id", ActSign.user_id),
new SqlParameter("@activity_id", ActSign.activity_id),
new SqlParameter("@sign_time", ActSign.sign_time),
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
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);
}
}
public static int InsertActSign(activity_sign ActSign)
{
return(iactivity_sign.InsertActSign(ActSign));
}
