public bool SaveActivitySignUp(ActivitySignUpInfo info)
{
StringBuilder builder = new StringBuilder();
builder.Append("IF NOT EXISTS (select 1 from vshop_ActivitySignUp WHERE ActivityId=@ActivityId and UserId=@UserId) ").Append("INSERT INTO vshop_ActivitySignUp(").Append("ActivityId,UserId,UserName,RealName,SignUpDate").Append(",Item1,Item2,Item3,Item4,Item5)").Append(" VALUES (").Append("@ActivityId,@UserId,@UserName,@RealName,@SignUpDate").Append(",@Item1,@Item2,@Item3,@Item4,@Item5)");
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
this.database.AddInParameter(sqlStringCommand, "ActivityId", DbType.Int32, info.ActivityId);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, info.UserId);
this.database.AddInParameter(sqlStringCommand, "UserName", DbType.String, info.UserName);
this.database.AddInParameter(sqlStringCommand, "RealName", DbType.String, info.RealName);
this.database.AddInParameter(sqlStringCommand, "SignUpDate", DbType.DateTime, info.SignUpDate);
this.database.AddInParameter(sqlStringCommand, "Item1", DbType.String, info.Item1);
this.database.AddInParameter(sqlStringCommand, "Item2", DbType.String, info.Item2);
this.database.AddInParameter(sqlStringCommand, "Item3", DbType.String, info.Item3);
this.database.AddInParameter(sqlStringCommand, "Item4", DbType.String, info.Item4);
this.database.AddInParameter(sqlStringCommand, "Item5", DbType.String, info.Item5);
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
private void SubmitActivity(HttpContext context)
{
context.Response.ContentType = "application/json";
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
if (currentMember == null)
{
context.Response.Write("{\"success\":false}");
}
else
{
ActivityInfo activity = VshopBrowser.GetActivity(Convert.ToInt32(context.Request.Form.Get("id")));
if ((DateTime.Now < activity.StartDate) || (DateTime.Now > activity.EndDate))
{
context.Response.Write("{\"success\":false, \"msg\":\"报名还未开始或已结束\"}");
}
else
{
ActivitySignUpInfo info = new ActivitySignUpInfo {
ActivityId = Convert.ToInt32(context.Request.Form.Get("id")),
Item1 = context.Request.Form.Get("item1"),
Item2 = context.Request.Form.Get("item2"),
Item3 = context.Request.Form.Get("item3"),
Item4 = context.Request.Form.Get("item4"),
Item5 = context.Request.Form.Get("item5"),
RealName = currentMember.RealName,
SignUpDate = DateTime.Now,
UserId = currentMember.UserId,
UserName = currentMember.UserName
};
string s = VshopBrowser.SaveActivitySignUp(info) ? "{\"success\":true}" : "{\"success\":false, \"msg\":\"你已经报过名了,请勿重复报名\"}";
context.Response.Write(s);
}
}
}
public static bool SaveActivitySignUp(ActivitySignUpInfo info)
{
return new ActivitySignUpDao().SaveActivitySignUp(info);
}