/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TravelAgent.Model.ClubPoints model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ClubPoints(");
strSql.Append("clubid,Content,points,remark,pType,adddate)");
strSql.Append(" values (");
strSql.Append("@clubid,@Content,@points,@remark,@pType,@adddate)");
SqlParameter[] parameters =
{
new SqlParameter("@clubid", SqlDbType.Int),
new SqlParameter("@Content", SqlDbType.VarChar),
new SqlParameter("@points", SqlDbType.Int),
new SqlParameter("@remark", SqlDbType.VarChar),
new SqlParameter("@pType", SqlDbType.Int),
new SqlParameter("@adddate", SqlDbType.DateTime)
};
parameters[0].Value = model.clubid;
parameters[1].Value = model.Content;
parameters[2].Value = model.points;
parameters[3].Value = model.remark;
parameters[4].Value = model.pType;
parameters[5].Value = model.adddate;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "会员注册-" + Master.webinfo.WebName;
if (!this.IsPostBack)
{
TravelAgent.Model.InfoSetting info = new TravelAgent.Model.InfoSetting();
info.ds = bll.GetList();
strMemberAgreement = info.getValue("RegFWTK");
if (Request["type"] != null)
{
string strTag = Request["type"];
TravelAgent.Model.Club model = new TravelAgent.Model.Club();
if (strTag.Equals("mobile"))
{
model.clubMobile = Request["mobile"];
model.clubName = "club" + model.clubMobile;
}
else
{
model.clubEmail = Request["email"];
model.clubName = "club" + model.clubEmail;
}
model.clubPwd = Request["password"];
model.isLock = 1;
int userid = ClubBll.Add(model);
if (userid > 0)
{
//积分开始
TravelAgent.Model.ClubPoints points = new TravelAgent.Model.ClubPoints();
points.clubid = userid;
points.Content = "首次注册";
points.points = Master.webinfo.FristReg;
points.remark = "";
points.pType = Convert.ToInt32(TravelAgent.Tool.EnumSummary.PointsType.注册);
points.adddate = DateTime.Now;
PointsBll.Add(points);
string strsql = "update Club set currentPoints=currentPoints+" + Master.webinfo.FristReg + " where Id=" + userid;
//Access
//TravelAgent.Tool.DbHelperOleDb.ExecuteSql(strsql);
//SQL
TravelAgent.Tool.DbHelperSQL.ExecuteSql(strsql);
//积分结束
TravelAgent.Tool.CookieHelper.SetCookie("uid", userid.ToString());
TravelAgent.Tool.CookieHelper.SetCookie("username", model.clubName);
Response.Redirect("/member/Index.aspx");
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr", false);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "验证成功-" + Master.webinfo.WebName;
string strUid = TravelAgent.Tool.CookieHelper.GetCookieValue("uid");
if (string.IsNullOrEmpty(strUid))
{
Response.Redirect("/member/Login.aspx");
}
else
{
club = clubBll.GetModel(Convert.ToInt32(strUid));
}
if (!this.IsPostBack)
{
if (Request["email"] != null)
{
string strEmail = Server.UrlDecode(Request["email"]);
this.ltEmail.Text = strEmail;
string strsql = "update Club set clubEmail='" + strEmail + "',emailIsValid=1 where Id=" + club.id + ";";
try
{
//第一次验证赠送
if (club.emailIsValid == 0)
{
//积分开始
TravelAgent.Model.ClubPoints points = new TravelAgent.Model.ClubPoints();
points.clubid = club.id;
points.Content = "验证邮箱";
points.points = webinfo.EmailValidate;
points.remark = "";
points.pType = Convert.ToInt32(TravelAgent.Tool.EnumSummary.PointsType.邮箱验证);
points.adddate = DateTime.Now;
PointsBll.Add(points);
strsql += "update Club set currentPoints=currentPoints+" + webinfo.EmailValidate + " where Id=" + club.id;
//TravelAgent.Tool.DbHelperOleDb.ExecuteSql(strsql);
//积分结束
}
//Access
//TravelAgent.Tool.DbHelperOleDb.ExecuteSql(strsql);
//SQL
TravelAgent.Tool.DbHelperSQL.ExecuteSql(strsql);
}
catch
{
Response.Redirect("/Opr.aspx?t=error&msg=opr");
}
}
else
{
Response.Redirect("/Opr.aspx?t=error&msg=opr");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TravelAgent.Model.ClubPoints GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from ClubPoints ");
strSql.Append(" where id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
TravelAgent.Model.ClubPoints model = new TravelAgent.Model.ClubPoints();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["clubid"].ToString() != "")
{
model.clubid = int.Parse(ds.Tables[0].Rows[0]["clubid"].ToString());
}
model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
if (ds.Tables[0].Rows[0]["points"].ToString() != "")
{
model.points = int.Parse(ds.Tables[0].Rows[0]["points"].ToString());
}
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
if (ds.Tables[0].Rows[0]["pType"].ToString() != "")
{
model.pType = int.Parse(ds.Tables[0].Rows[0]["pType"].ToString());
}
model.adddate = DateTime.Parse(ds.Tables[0].Rows[0]["adddate"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(TravelAgent.Model.ClubPoints model)
{
dal.Add(model);
}