private string homeLogin()
{
string uEmail = Request["UserEmail"];
string uPwd = Request["Password"];
string viladCode = Request["viladCode"];
string sessionCode = Cmn.Session.Get("code");
if (!sessionCode.Equals(viladCode))
{
return("验证码输入错误");
}
DBEntity.Tab_UserCommunity ent = DBEntity.Tab_UserCommunity.Get(uEmail, uPwd);
if (ent == null)
{
return("用户名或者密码错误");
}
return("dd");
//int remeberDay = 1;
//if (ChkRemeberLogined.Checked)
//{
// remeberDay = 7;
//}
//Session["loginUser"] = ent;
//Cmn.Cookies.Set("login_UserEmail", ent.UserEmail, remeberDay);
//Cmn.Cookies.Set("login_RealName", ent.RealName, remeberDay);
//Response.Redirect("index.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
try
{
string validCode = Request["validCode"];
string strSql = "update Tab_UserCommunity set RegViladBool='yes' where RegViladCode=@validCode";
SqlHelper.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter("@validCode", validCode));
DBEntity.Tab_UserCommunity ent = new DBEntity.Tab_UserCommunity().GetByRegCode(validCode);
Session["loginUser"] = ent;
Cmn.Cookies.Set("login_UserIdx", ent.Idx.ToString(), 1);
Cmn.Cookies.Set("login_UserEmail", ent.UserEmail, 1);
Cmn.Cookies.Set("login_RealName", ent.RealName, 1);
Cmn.Cookies.Set("login_VipBool", ent.VipBool, 1);
//Cmn.Js.ShowAlert("验证成功！");
Cmn.Js.ExeScript(string.Format("location.href='{0}'", Cmn.WebConfig.getApp("app_WebsiteDomain")));
}
catch (Exception ext)
{
Cmn.Log.Write(ext.ToString());
}
}
}
public bool Update(Tab_UserCommunity model)
{
string sql = "update Tab_UserCommunity set UserEmail=@UserEmail,Password=@Password,HeadPhoto=@HeadPhoto,QqWeibo_Id=@QqWeibo_Id,KaixinWeibo_Id=@KaixinWeibo_Id,SinaWeibo_Id=@SinaWeibo_Id,UserlevelIdx_FxIdx=@UserlevelIdx_FxIdx,VipCardNo=@VipCardNo,VipBool=@VipBool,V_SignBool=@V_SignBool,SubscribeBool=@SubscribeBool,RegViladBool=@RegViladBool,RealName=@RealName,Birthday=@Birthday,MobilePhone=@MobilePhone,Province=@Province,City=@City,Address=@Address,ZipCode=@ZipCode,LastLoginIp=@LastLoginIp,CreatedDate=@CreatedDate,LastModificationDate=@LastModificationDate,RegViladCode=@RegViladCode where Idx=@Idx";
int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql
, new SqlParameter("@UserEmail", model.UserEmail)
, new SqlParameter("@Password", model.Password)
, new SqlParameter("@HeadPhoto", model.HeadPhoto)
, new SqlParameter("@QqWeibo_Id", model.QqWeibo_Id)
, new SqlParameter("@KaixinWeibo_Id", model.KaixinWeibo_Id)
, new SqlParameter("@SinaWeibo_Id", model.SinaWeibo_Id)
, new SqlParameter("@UserlevelIdx_FxIdx", model.UserlevelIdx_FxIdx)
, new SqlParameter("@VipCardNo", model.VipCardNo)
, new SqlParameter("@VipBool", model.VipBool)
, new SqlParameter("@V_SignBool", model.V_SignBool)
, new SqlParameter("@SubscribeBool", model.SubscribeBool)
, new SqlParameter("@RegViladBool", model.RegViladBool)
, new SqlParameter("@RealName", model.RealName)
, new SqlParameter("@Birthday", model.Birthday)
, new SqlParameter("@MobilePhone", model.MobilePhone)
, new SqlParameter("@Province", model.Province)
, new SqlParameter("@City", model.City)
, new SqlParameter("@Address", model.Address)
, new SqlParameter("@ZipCode", model.ZipCode)
, new SqlParameter("@LastLoginIp", model.LastLoginIp)
, new SqlParameter("@CreatedDate", model.CreatedDate)
, new SqlParameter("@LastModificationDate", model.LastModificationDate)
, new SqlParameter("@RegViladCode", model.RegViladCode)
, new SqlParameter("Idx", model.Idx)
);
return(rows > 0);
}
private static Tab_UserCommunity ToModel(DataRow row)
{
Tab_UserCommunity model = new Tab_UserCommunity();
model.Idx = row.IsNull("Idx") ? null : (System.Int32?)row["Idx"];
model.UserEmail = row.IsNull("UserEmail") ? null : (System.String)row["UserEmail"];
model.Password = row.IsNull("Password") ? null : (System.String)row["Password"];
model.HeadPhoto = row.IsNull("HeadPhoto") ? null : (System.String)row["HeadPhoto"];
model.QqWeibo_Id = row.IsNull("QqWeibo_Id") ? null : (System.String)row["QqWeibo_Id"];
model.KaixinWeibo_Id = row.IsNull("KaixinWeibo_Id") ? null : (System.String)row["KaixinWeibo_Id"];
model.SinaWeibo_Id = row.IsNull("SinaWeibo_Id") ? null : (System.String)row["SinaWeibo_Id"];
model.UserlevelIdx_FxIdx = row.IsNull("UserlevelIdx_FxIdx") ? null : (System.Int32?)row["UserlevelIdx_FxIdx"];
model.VipCardNo = row.IsNull("VipCardNo") ? null : (System.String)row["VipCardNo"];
model.VipBool = row.IsNull("VipBool") ? null : (System.String)row["VipBool"];
model.V_SignBool = row.IsNull("V_SignBool") ? null : (System.String)row["V_SignBool"];
model.SubscribeBool = row.IsNull("SubscribeBool") ? null : (System.String)row["SubscribeBool"];
model.RegViladBool = row.IsNull("RegViladBool") ? null : (System.String)row["RegViladBool"];
model.RealName = row.IsNull("RealName") ? null : (System.String)row["RealName"];
model.Birthday = row.IsNull("Birthday") ? null : (System.DateTime?)row["Birthday"];
model.MobilePhone = row.IsNull("MobilePhone") ? null : (System.String)row["MobilePhone"];
model.Province = row.IsNull("Province") ? null : (System.String)row["Province"];
model.City = row.IsNull("City") ? null : (System.String)row["City"];
model.Address = row.IsNull("Address") ? null : (System.String)row["Address"];
model.ZipCode = row.IsNull("ZipCode") ? null : (System.String)row["ZipCode"];
model.LastLoginIp = row.IsNull("LastLoginIp") ? null : (System.String)row["LastLoginIp"];
model.CreatedDate = row.IsNull("CreatedDate") ? null : (System.DateTime?)row["CreatedDate"];
model.LastModificationDate = row.IsNull("LastModificationDate") ? null : (System.DateTime?)row["LastModificationDate"];
model.RegViladCode = row.IsNull("RegViladCode") ? null : (System.String)row["RegViladCode"];
model.AvailablePoints = row.IsNull("AvailablePoints") ? null : (System.Decimal?)row["AvailablePoints"];
model.TotalPoints = row.IsNull("TotalPoints") ? null : (System.Decimal?)row["TotalPoints"];
model.RedemptionPoints = row.IsNull("RedemptionPoints") ? null : (System.Decimal?)row["RedemptionPoints"];
return(model);
}
public int AddNew(Tab_UserCommunity model)
{
string sql = "insert into Tab_UserCommunity(UserEmail,Password,HeadPhoto,QqWeibo_Id,KaixinWeibo_Id,SinaWeibo_Id,UserlevelIdx_FxIdx,VipCardNo,VipBool,V_SignBool,SubscribeBool,RegViladBool,RealName,Birthday,MobilePhone,Province,City,Address,ZipCode,LastLoginIp,CreatedDate,LastModificationDate,RegViladCode) values(@UserEmail,@Password,@HeadPhoto,@QqWeibo_Id,@KaixinWeibo_Id,@SinaWeibo_Id,@UserlevelIdx_FxIdx,@VipCardNo,@VipBool,@V_SignBool,@SubscribeBool,@RegViladBool,@RealName,@Birthday,@MobilePhone,@Province,@City,@Address,@ZipCode,@LastLoginIp,@CreatedDate,@LastModificationDate,@RegViladCode); select @@identity ;";
int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql
, new SqlParameter("@UserEmail", model.UserEmail)
, new SqlParameter("@Password", model.Password)
, new SqlParameter("@HeadPhoto", model.HeadPhoto)
, new SqlParameter("@QqWeibo_Id", model.QqWeibo_Id)
, new SqlParameter("@KaixinWeibo_Id", model.KaixinWeibo_Id)
, new SqlParameter("@SinaWeibo_Id", model.SinaWeibo_Id)
, new SqlParameter("@UserlevelIdx_FxIdx", model.UserlevelIdx_FxIdx)
, new SqlParameter("@VipCardNo", model.VipCardNo)
, new SqlParameter("@VipBool", model.VipBool)
, new SqlParameter("@V_SignBool", model.V_SignBool)
, new SqlParameter("@SubscribeBool", model.SubscribeBool)
, new SqlParameter("@RegViladBool", model.RegViladBool)
, new SqlParameter("@RealName", model.RealName)
, new SqlParameter("@Birthday", model.Birthday)
, new SqlParameter("@MobilePhone", model.MobilePhone)
, new SqlParameter("@Province", model.Province)
, new SqlParameter("@City", model.City)
, new SqlParameter("@Address", model.Address)
, new SqlParameter("@ZipCode", model.ZipCode)
, new SqlParameter("@LastLoginIp", model.LastLoginIp)
, new SqlParameter("@CreatedDate", model.CreatedDate)
, new SqlParameter("@LastModificationDate", model.LastModificationDate)
, new SqlParameter("@RegViladCode", model.RegViladCode)
));
return(Idx);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
if (string.IsNullOrEmpty(Cmn.Cookies.Get("login_UserIdx")))
{
Response.Redirect("login.aspx?from=" + Request.Url.ToString());
}
int uIdx = int.Parse(Cmn.Cookies.Get("login_UserIdx"));
ent = ent.Get(uIdx);
if (ent.VipBool == "yes")
{
strVip = "VIP 会员";
strPosion = "至臻坊会员专享";
strTopClass = "subTit vipTit";
}
this.RealName.Value = ent.RealName;
this.MobilePhone.Value = ent.MobilePhone;
this.Hidden1.Value = ent.Province;
this.City.Value = ent.City;
this.Address.Value = ent.Address;
this.ZipCode.Value = ent.ZipCode;
}
}
protected void lnkSubmit_Click(object sender, EventArgs e)
{
string sessionCode = Cmn.Session.Get("code");
if (!sessionCode.Equals(viladCode.Value))
{
Cmn.Js.ShowAlert("验证码输入错误");
return;
}
if (DBEntity.Tab_UserCommunity.HasEmail(this.UserEmail.Value) > 0)
{
Cmn.Js.ShowAlert(string.Format("邮箱账号：{0} 已经存!", this.UserEmail.Value));
return;
}
string strGuid = Guid.NewGuid().ToString();
DBEntity.Tab_UserCommunity ent = new DBEntity.Tab_UserCommunity();
ent.UserEmail = this.UserEmail.Value;
ent.Password = this.Password.Value;
ent.MobilePhone = this.MobilePhone.Value;
ent.VipBool = "no";
ent.City = "";
ent.Province = "";
ent.RegViladCode = strGuid;
ent.LastLoginIp = Request.UserHostAddress;
ent.AddNew(ent);
string SmtpServer = "mail.showone.com.cn";
string SmtpUserName = "******";
string SmtpPassword = "******";
string fromMail = "*****@*****.**";
string formName = "SisleyCommnutiy";
Cmn.Email el = new Cmn.Email(SmtpServer, SmtpUserName, SmtpPassword, fromMail, formName);
el.IsBodyHtml = true;
string subject = "来自希思黎社区网，用户注册验证码";
string validUrl = string.Format("{0}/EmailRegValid.aspx?validCode={1}", Cmn.WebConfig.getApp("app_WebsiteDomain"), strGuid);
string body = string.Format("亲爱的{0}, <br /><br /> 恭喜您成功注册。<br / > 请点击以下链接验证邮箱 <br />{1}<br/><br/> 如果链接不能点击，请复制地址到浏览器，然后直接打开 <br /><br /> 祝好! <br /><br /> 希思黎社区 <br />{2}", this.UserEmail.Value, validUrl, Cmn.Date.ToDateTimeStr(DateTime.Now));
el.Send(this.UserEmail.Value, subject, body);
Response.Redirect("register_success.aspx");
}
//获取登录者的信息
private string GetLoginerInfo()
{
string uIdx = Cmn.Cookies.Get("login_UserIdx");
if (string.IsNullOrEmpty(uIdx))
{
Cmn.Log.Write("uIdx:" + uIdx);
return("noLogin");
}
//获取课程通过了几门
string beginDate = Cmn.WebConfig.getApp("app_CourseMainTest_BeginDate");
string endDate = Cmn.WebConfig.getApp("app_CourseMainTest_EndDate");
string UserIdx_Fx = "1"; //Cmn.Cookies.Get("uIdx");
string strSql = "select myPassNum=COUNT(1) from Tab_CourseMain_TestLog where CreatedDate>='{0}' and CreatedDate<='{1}' and PassBool='yes' and UserIdx_Fx={2}";
strSql = string.Format(strSql, beginDate, endDate, UserIdx_Fx);
int myPassNum = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql));
DBEntity.Tab_UserCommunity ent = new DBEntity.Tab_UserCommunity();
ent = ent.Get(uIdx);
StringBuilder sb = new StringBuilder();
sb.AppendLine(@"<?xml version='1.0' encoding='utf-8' ?>");
sb.AppendLine(@"<Data>");
sb.AppendLine("<Item>");
sb.AppendLine(String.Format("<uIdx>{0}</uIdx>", ent.Idx));
sb.AppendLine(String.Format("<RealName>{0}</RealName>", ent.RealName));
sb.AppendLine(String.Format("<HeadPhoto>{0}/upload/userHearderImg/{1}</HeadPhoto>", Cmn.WebConfig.getApp("app_WebsiteDomain"), ent.HeadPhoto));
sb.AppendLine(String.Format("<UserEmail>{0}</UserEmail>", ent.UserEmail));
sb.AppendLine(String.Format("<VipBool>{0}</VipBool>", ent.VipBool));
sb.AppendLine(String.Format("<myPassNum>{0}</myPassNum>", myPassNum));
sb.AppendLine(String.Format("<orderUserList>{0}</orderUserList>", "108"));
sb.AppendLine("</Item>");
sb.AppendLine(@"</Data>");
return(sb.ToString());
//}
//catch
//{
// return "noLogin";
//}
}
protected void lnkLogin_Click(object sender, EventArgs e)
{
string uEmail = this.txtEmail.Text;
string uPwd = this.txtPwd.Text;
string viladCode = this.txtValidCode.Text;
//Cmn.Log.Write(string.Format("uEmail={0},uPwd={1},viladCode={2}", uEmail, uPwd, viladCode));
string sessionCode = Cmn.Session.Get("code");
if (!sessionCode.Equals(viladCode))
{
Cmn.Js.ShowAlert("验证码输入错误");
return;
}
DBEntity.Tab_UserCommunity ent = DBEntity.Tab_UserCommunity.Get(uEmail, uPwd);
if (ent == null)
{
Cmn.Js.ShowAlert("用户名或者密码错误");
return;
}
int remeberDay = 1;
if (ChkRemeberLogined.Checked)
{
remeberDay = 7;
}
Session["loginUser"] = ent;
Cmn.Cookies.Set("login_UserIdx", ent.Idx.ToString(), remeberDay);
Cmn.Log.Write("Idx=" + ent.Idx.ToString());
Cmn.Cookies.Set("login_UserEmail", ent.UserEmail, remeberDay);
Cmn.Cookies.Set("login_RealName", ent.RealName, remeberDay);
Cmn.Cookies.Set("login_VipBool", ent.VipBool, remeberDay);
Cmn.Cookies.Set("login_HeadPhoto", string.Format("{0}/upload/userHearderImg/{1}", Cmn.WebConfig.getApp("app_WebsiteDomain"), ent.HeadPhoto), remeberDay);
string url = Request["from"];
if (string.IsNullOrEmpty(url) || url.IndexOf("register") >= 0)
{
url = "index.aspx";
}
Response.Redirect(url);
}
/// <summary>
/// 根据用户名获取用户的实例
/// </summary>
/// <param name="UserEmail"></param>
/// <param name="Password"></param>
/// <returns></returns>
public static Tab_UserCommunity Get(string UserEmail, string Password)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_UserCommunity where UserEmail=@UserEmail and Password=@Password",
new SqlParameter("UserEmail", UserEmail), new SqlParameter("Password", Password)).Tables[0];
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
Tab_UserCommunity model = ToModel(row);
return(model);
}
public Tab_UserCommunity GetByRegCode(string RegViladCode)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select top 1 * from Tab_UserCommunity where RegViladCode=@RegViladCode",
new SqlParameter("RegViladCode", RegViladCode)).Tables[0];
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
Tab_UserCommunity model = ToModel(row);
return(model);
}
public Tab_UserCommunity Get(string Idx)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_UserCommunity where Idx=@Idx",
new SqlParameter("Idx", Idx)).Tables[0];
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
Tab_UserCommunity model = ToModel(row);
return(model);
}
//底部会员头像List
private void UserCotyHeaderImgList()
{
string strSql = "select top 15 * from Tab_UserCommunity Order By NewID()";
IEnumerable <DBEntity.Tab_UserCommunity> ents = new DBEntity.Tab_UserCommunity().ListAll(strSql);
StringBuilder contentStr = new StringBuilder();
string headerImg;
foreach (DBEntity.Tab_UserCommunity ent in ents)
{
headerImg = ent.HeadPhoto;
bool isExist = Cmn.FileFolder.CheckFileExist(Server.MapPath(string.Format("upload/userHearderImg/{0}", headerImg)));
if (!isExist)
{
headerImg = "defaultHeaderImg.jpg";
}
contentStr.AppendLine(string.Format("<li><img src='upload/userHearderImg/{0}' width='50' height='50' alt='' /></li>", headerImg));
}
//this.ltlHome_UserCommunityHeaderImg.Text = contentStr.ToString();
}
public static Tab_UserCommunity GetBySinaId(string SinaWeibo_Id)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_UserCommunity where SinaWeibo_Id=@SinaWeibo_Id",
new SqlParameter("SinaWeibo_Id", SinaWeibo_Id)).Tables[0];
if (dt.Rows.Count > 1)
{
Cmn.Log.Write("SinaWeibo_Id=" + SinaWeibo_Id);
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
Tab_UserCommunity model = ToModel(row);
return(model);
}
protected void GetSinaToken()
{
if (Request["code"] != null)
{
string client_id = Cmn.WebConfig.getApp("app_key_sina");
string client_secret = Cmn.WebConfig.getApp("app_secret_sina");
string redirect_uri = Cmn.WebConfig.getApp("app_redirectUri_sina");
string grant_type = "authorization_code";
string code = Request["code"].ToString();
string url = "https://api.weibo.com/oauth2/access_token";
string postData = string.Format("client_id={0}&client_secret={1}&grant_type={2}&code={3}&redirect_uri={4}", client_id, client_secret, grant_type, code, redirect_uri);
HttpData http = new HttpData();
string responseData = http.WebRequest("post", url, postData);
OathToken token = JsonHelper.ParseFormJson <OathToken>(responseData);
Cmn.Cookies.Set("access_token", token.access_token, 7);
Cmn.Cookies.Set("uid", token.uid, 7);
//============
string strUrl = string.Format("https://api.weibo.com/2/users/show.json?access_token={0}&uid={1}",
token.access_token, token.uid);
string myJson = http.WebRequest("get", strUrl, string.Empty);
var decodedJSON = JObject.Parse(myJson);
var SinaScreen_name = decodedJSON["screen_name"].ToString() + "_sina";
var SinaProfile_image_url = decodedJSON["profile_image_url"];
var sinaId = decodedJSON["id"];
//=======
//查找会员社区表中，是否已经存在
int uIdx = 0;
string SinaPhotoHeader = Cmn.Date.ToDateStr2(DateTime.Now) + "_" + sinaId + ".png";
string strSql = string.Format("select count(1) from Tab_UserCommunity where SinaWeibo_Id='{0}'", sinaId);
int iCount = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql));
Cmn.Log.Write("strSql=" + strSql + "|iCount=" + iCount);
if (iCount == 0)
{
//保存头像
using (WebClient wc = new WebClient())
{
string photoUrl = SinaProfile_image_url.ToString();
string photoSavePath = Server.MapPath("~/upload/userHearderImg/") + SinaPhotoHeader;
wc.DownloadFile(photoUrl, photoSavePath);
}
//添加到数据库
DBEntity.Tab_UserCommunity ent2 = new DBEntity.Tab_UserCommunity();
ent2.UserEmail = SinaScreen_name.ToString();
ent2.RealName = SinaScreen_name.ToString();
ent2.VipBool = "no";
ent2.Password = "******";
ent2.City = "";
ent2.HeadPhoto = SinaPhotoHeader;
ent2.SinaWeibo_Id = sinaId.ToString();
uIdx = ent2.AddNew(ent2);
}
strSql = string.Format("insert into Tab_User_LoginLog (LoginName,LoginIpAddress) values('{0}','{1}')", SinaScreen_name, Request.UserHostAddress);
SqlHelper.ExecuteNonQuery(CommandType.Text, strSql);
DBEntity.Tab_UserCommunity ent = DBEntity.Tab_UserCommunity.GetBySinaId(sinaId.ToString());
uIdx = Convert.ToInt32(ent.Idx);
int remeberDay = 7;
Cmn.Cookies.Set("login_UserIdx", uIdx.ToString(), remeberDay);
Cmn.Cookies.Set("login_UserEmail", ent.UserEmail, remeberDay);
Cmn.Cookies.Set("login_RealName", ent.RealName, remeberDay);
Cmn.Cookies.Set("login_VipBool", ent.VipBool, remeberDay);
Cmn.Cookies.Set("login_HeadPhoto", string.Format("{0}/upload/userHearderImg/{1}", Cmn.WebConfig.getApp("app_WebsiteDomain"), ent.HeadPhoto), remeberDay);
Cmn.Log.Write(Cmn.Cookies.Get("login_UserEmail"));
//========= End
Response.Redirect("index.aspx?s=" + Request["s"]);
}
}
protected void lnkSubmit_Click(object sender, EventArgs e)
{
string sessionCode = Cmn.Session.Get("code");
if (DBEntity.Tab_UserVipCardNo.ChkVipCard(this.VipCardNo.Value) <= 0)
{
Cmn.Js.ShowAlert("会员卡号不存在");
return;
}
if (DBEntity.Tab_UserVipCardNo.HasCardNo(this.VipCardNo.Value) > 0)
{
Cmn.Js.ShowAlert("会员卡已经被人激活");
return;
}
if (DBEntity.Tab_UserCommunity.HasEmail(this.UserEmail.Value) > 0)
{
Cmn.Js.ShowAlert(string.Format("邮箱账号：{0} 已经存!", this.UserEmail.Value));
return;
}
if (!sessionCode.Equals(viladCode.Value))
{
Cmn.Js.ShowAlert("验证码输入错误");
return;
}
string strGuid = Guid.NewGuid().ToString();
DBEntity.Tab_UserCommunity ent = new DBEntity.Tab_UserCommunity();
ent.UserEmail = this.UserEmail.Value;
ent.Password = this.Password.Value;
ent.VipCardNo = this.VipCardNo.Value;
ent.MobilePhone = this.MobilePhone.Value;
ent.Province = this.Province.Items[this.Province.SelectedIndex].Value;
ent.City = this.City.Value;
ent.RegViladCode = strGuid;
ent.VipBool = "yes";
ent.LastLoginIp = Request.UserHostAddress;
ent.AddNew(ent);
//修改会员卡状态
string strSql = string.Format("update Tab_UserVipCardNo set VipHasUseBool='yes',VipEditDateTime=getdate() where Idx={0}", this.VipCardNo.Value);
SqlHelper.ExecuteNonQuery(CommandType.Text, strSql);
Cmn.Log.Write(string.Format("VIP卡:{0} -- Yes", this.VipCardNo.Value));
//==========
string SmtpServer = "mail.showone.com.cn";
string SmtpUserName = "******";
string SmtpPassword = "******";
string fromMail = "*****@*****.**";
string formName = "SisleyCommnutiy";
Cmn.Email el = new Cmn.Email(SmtpServer, SmtpUserName, SmtpPassword, fromMail, formName);
el.IsBodyHtml = true;
string subject = "来自希思黎社区网，用户注册验证码";
string validUrl = string.Format("{0}/EmailRegValid.aspx?validCode={1}", Cmn.WebConfig.getApp("app_WebsiteDomain"), strGuid);
string body = string.Format("亲爱的{0}, <br /><br /> 恭喜您成功注册。<br / > 请点击以下链接验证邮箱 <br />{1}<br/><br/> 如果链接不能点击，请复制地址到浏览器，然后直接打开 <br /><br /> 祝好! <br /><br /> 希思黎社区 <br />{2}", this.UserEmail.Value, validUrl, Cmn.Date.ToDateTimeStr(DateTime.Now));
el.Send(this.UserEmail.Value, subject, body);
Response.Redirect("register_success.aspx");
}