private void GetDetail()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, txtUserName.Text.Trim());
rc.AddSelect(XiHuan_UserInfoEntity.__ID);
rc.AddSelect(XiHuan_UserInfoEntity.__ORIGNALPWD);
rc.AddSelect(XiHuan_UserInfoEntity.__ISLOCKED);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
if (user.IsLocked == 0)
{
lblResult.Text = string.Format("密码为：<span class=\"highlight\">{0}</span>，<a href=\"###\" onclick=\"LockUser({1});\">锁定此账号</a>", user.OrignalPwd, user.ID);
}
if (user.IsLocked == 1)
{
lblResult.Text = string.Format("密码为：<span class=\"highlight\">{0}</span>，<a href=\"###\" onclick=\"UnLockUser({1});\">撤消锁定此账号</a>", user.OrignalPwd, user.ID);
}
}
else
{
lblResult.Text = "<span class=\"highlight\">没有找到此会员的信息！</span>";
}
}
private void LoadUserInfo()
{
int uid = CurrentUserId;
XiHuan_UserInfoEntity userinfo = new XiHuan_UserInfoEntity();
userinfo.ID = uid;
userinfo.Retrieve();
if (userinfo.IsPersistent)
{
headPic.ImageUrl = CommonMethod.FinalString(userinfo.HeadImage).Length > 0 ? userinfo.HeadImage : "images/nophoto.gif";
lblUserName.Text = userinfo.UserName;
txtEmail.Text = userinfo.Email;
rbtSex.SelectedValue = userinfo.Gender.ToString();
CommonMethod.SelectFlg(ddlProvince, userinfo.ProvinceId.ToString());
CommonMethod.BindDrop(ddlCity, ProvinceCityFacade.GetInstance().GetCityInfo(ddlProvince.SelectedValue), "city", "cityId");
CommonMethod.SelectFlg(ddlCity, userinfo.CityId.ToString());
CommonMethod.BindDrop(ddlArea, ProvinceCityFacade.GetInstance().GetAreaInfo(ddlCity.SelectedValue), "area", "areaId");
CommonMethod.SelectFlg(ddlArea, userinfo.AreaId.ToString());
CommonMethod.BindDrop(ddlSchool, ProvinceCityFacade.GetInstance().GetSchoolInfo(ddlProvince.SelectedValue, ddlCity.SelectedValue), "SchoolName", "Id");
ddlSchool.Items.Insert(0, new ListItem("选择学校", ""));
CommonMethod.SelectFlg(ddlSchool, userinfo.SchoolId.ToString());
txtQuestion.Text = userinfo.Question;
txtAnswer.Text = userinfo.Answer;
txtTel.Value = userinfo.TelePhone;
txtWangWang.Value = userinfo.WangWang;
txt_msn.Value = userinfo.Msn;
txt_qq.Value = userinfo.QQ;
txtOtherLink.Text = userinfo.OtherLink;
txtSingnNote.Text = userinfo.SignNote;
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
if (IsUserAlreadyLogin)
{
if (!XiHuan_UserFacade.IsUserValid(CurrentUserName, txtOldPassWord.Text))
{
Alert("原密码不正确");
return;
}
else
{
XiHuan_UserInfoEntity modifypwd = XiHuan_UserInfoEntityAction.RetrieveAXiHuan_UserInfoEntity(CurrentUserId);
if (modifypwd != null)
{
modifypwd.OrignalPwd = txtNewPassWord.Text.Trim();
modifypwd.Md5Pwd = CommonMethod.MD5Encrypt(txtNewPassWord.Text.Trim());
modifypwd.Save();
Alert("恭喜：您的密码已成功修改！");
}
}
}
else
{
MemberCenterPageRedirect("", "modifypwd");
}
}
public static bool IsStartUser(int id)
{
byte rs = 0;
XiHuan_UserInfoEntity user = new XiHuan_UserInfoEntity();
user.ID = id;
user.Retrieve();
if (user.IsPersistent)
{
rs = user.IsStarUser;
}
return(rs == 1);
}
public static bool IsCertNoChecked(int id)
{
byte rs = 0;
XiHuan_UserInfoEntity user = new XiHuan_UserInfoEntity();
user.ID = id;
user.Retrieve();
if (user.IsPersistent)
{
rs = user.IsCertNoChecked;
}
return(rs == 1);
}
protected void lnkUnLockUser_Click(object sender, EventArgs e)
{
int id = CommonMethod.ConvertToInt(hidId.Value, 0);
if (id > 0)
{
XiHuan_UserInfoEntity user = new XiHuan_UserInfoEntity();
user.ID = id;
user.Retrieve();
if (user.IsPersistent)
{
user.IsLocked = 0;
user.Save();
Alert("已解除锁定此账号！");
GetDetail();
}
}
}
public static int GetIdByName(string uname)
{
uname = CommonMethodFacade.FinalString(uname);
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, uname);
rc.AddSelect(XiHuan_UserInfoEntity.__ID);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
return(user.ID);
}
else
{
return(0);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, txtName.Text.Trim());
rc.AddSelect(XiHuan_UserInfoEntity.__USERNAME);
rc.AddSelect(XiHuan_UserInfoEntity.__ORIGNALPWD);
rc.AddSelect(XiHuan_UserInfoEntity.__QUESTION);
rc.AddSelect(XiHuan_UserInfoEntity.__ANSWER);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
if (user.Question == txtQuestion.Text.Trim() && user.Answer == txtAnswer.Text.Trim())
{
try
{
SendMailFacade.sendEmail(txtEmail.Text.Trim(), "喜换网-找回密码", "<strong>" + txtName.Text.Trim() + "</strong>您好，<br/>您在喜换网注册的账号密码为" + user.OrignalPwd + ",请妥善保管，此邮件为系统邮件，请勿回复！");
Alert("您的密码已成功发送到您的邮箱，请注意查收！");
ExecScript("parent.ymPrompt.close();");
}
catch
{
Alert("抱歉：邮件发送出现错误！");
return;
}
}
else
{
Alert("很抱歉：您输入的安全提问问题和答案不符合，我们不能为您提供找回密码的服务！");
return;
}
}
else
{
Alert("不存在换客名为" + txtName.Text + "的用户！");
return;
}
}
protected void btn_submitinfo_ServerClick(object sender, EventArgs e)
{
#region 务器端验证
#endregion
#region 信息保存
Transaction t = new Transaction();
int uid = CurrentUserId;
if (uid > 0)
{
XiHuan_UserInfoEntity updateRegInfo = XiHuan_UserInfoEntityAction.RetrieveAXiHuan_UserInfoEntity(uid);
if (updateRegInfo != null)
{
string savepath = string.Empty;
string filepath = string.Empty;
string filename = string.Empty;
if (headImage.HasFile)
{
if (headImage.PostedFile.ContentLength < 50 * 1024)
{
string hz = System.IO.Path.GetExtension(headImage.PostedFile.FileName);
if (CommonMethod.IsUploadImageValid("", hz))
{
filepath = "images/userupload/headimage/" + DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + DateTime.Now.Day + "/";
filename = DateTime.Now.ToString("yyyymmddhhmmssfff") + "_" + uid + hz;
if (!Directory.Exists(Server.MapPath(filepath)))
{
Directory.CreateDirectory(Server.MapPath(filepath));
}
savepath = Server.MapPath(filepath + filename);
headImage.PostedFile.SaveAs(savepath);
}
else
{
Alert("头像格式不符合要求，请重新选择头像！");
return;
}
}
else
{
Alert("头像大小超出50k,请换个小点的图片吧！");
return;
}
}
if (savepath.Length > 0)
{
if (updateRegInfo.HeadImage.Length > 0 && System.IO.File.Exists(Server.MapPath(updateRegInfo.HeadImage)))
{
if (!updateRegInfo.HeadImage.Equals("images/nophoto.gif"))
{
System.IO.File.Delete(Server.MapPath(updateRegInfo.HeadImage));
}
}
updateRegInfo.HeadImage = filepath + filename;
}
updateRegInfo.Email = txtEmail.Text.Trim();
updateRegInfo.Gender = byte.Parse(rbtSex.SelectedValue.Trim());
updateRegInfo.ProvinceId = CommonMethod.ConvertToInt(ddlProvince.SelectedValue, 0);
updateRegInfo.ProvinceName = ddlProvince.SelectedItem.Text.Trim();
updateRegInfo.CityId = CommonMethod.ConvertToInt(Request["ddlCity"], 0);
updateRegInfo.CityName = CommonMethodFacade.GetCityNameById(updateRegInfo.CityId.ToString());
updateRegInfo.AreaId = CommonMethod.ConvertToInt(Request["ddlArea"], 0);
if (updateRegInfo.AreaId > 0)
{
updateRegInfo.AreaName = CommonMethodFacade.GetAreaNameById(updateRegInfo.AreaId.ToString());
}
int schoolid = CommonMethod.ConvertToInt(Request["ddlSchool"], 0);
updateRegInfo.SchoolId = schoolid;
if (schoolid > 0)
{
updateRegInfo.SchoolName = CommonMethodFacade.GetSchoolNameById(ddlProvince.SelectedValue, Request["ddlCity"], schoolid.ToString());
}
else
{
updateRegInfo.SchoolName = "";
}
updateRegInfo.Question = txtQuestion.Text.Trim();
updateRegInfo.Answer = txtAnswer.Text.Trim();
updateRegInfo.TelePhone = txtTel.Value.Trim();
updateRegInfo.WangWang = txtWangWang.Value.Trim();
updateRegInfo.QQ = txt_qq.Value.Trim();
updateRegInfo.Msn = txt_msn.Value.Trim();
updateRegInfo.OtherLink = txtOtherLink.Text.Trim();
updateRegInfo.SignNote = CommonMethod.ClearInputText(txtSingnNote.Text, 200);
t.DoSaveObject(updateRegInfo);
//更新换品浏览人信息里的头像地址
t.DoSqlNonQueryString("update XiHuan_GoodsViewUser set VisitorHeadImage='" + updateRegInfo.HeadImage + "' where VisitorId=" + CurrentUserId, GlobalVar.DataBase_Name);
try
{
t.Commit();
headPic.ImageUrl = filepath + filename;
LoadUserInfo();
Alert("恭喜：您的注册信息已成功更改！");
DataTable dt = Query.ProcessSql("select Id,DetailUrl from XiHuan_UserGoods with(nolock) where OwnerId= " + CurrentUserId + " and IsChecked=1 ", GlobalVar.DataBase_Name);
foreach (DataRow dr in dt.Rows)
{
CommonMethod.readAspxAndWriteHtmlSoruce("showdetail.aspx?id=" + dr["Id"], dr["DetailUrl"].ToString());
}
}
catch (Exception ex)
{
Alert("抱歉：修改信息时出错，" + ex.Message + "请稍后重试！");
return;
}
}
}
else
{
Alert("登陆超时，请重新登陆再继续当前的操作！");
return;
}
#endregion
}
protected void lnkSubmit_Click(object sender, EventArgs e)
{
#region 务器端验证
int provinceid = CommonMethod.ConvertToInt(ddlProvince.SelectedValue, 0);
int cityid = CommonMethod.ConvertToInt(ddlCity.SelectedValue, 0);
int areaid = CommonMethod.ConvertToInt(ddlArea.SelectedValue, 0);
int schoolid = CommonMethod.ConvertToInt(ddlSchool.SelectedValue, 0);
if (txtUserName.Text.Trim().Length == 0)
{
Alert(" 请您填写换客名！");
Select(txtUserName);
return;
}
else if (XiHuan_UserFacade.IsUserNameAlreayUse(txtUserName.Text))
{
Alert("您填写的换客名已经被占用，请您换个换客名重试！");
Select(txtUserName);
return;
}
if (txtPassWord.Text.Trim().Length == 0)
{
Alert("请您填写密码！");
Select(txtPassWord);
return;
}
if (txtPassWord2.Text.Trim().Length == 0)
{
Alert("请您再次输入密码！");
Select(txtPassWord2);
return;
}
if (!txtPassWord.Text.Trim().Equals(txtPassWord2.Text.Trim()))
{
Alert("两次密码输入不一致，请重新输入！");
Select(txtPassWord2);
return;
}
if (txtEmail.Text.Trim().Length > 0)
{
Regex reg = new Regex(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
if (!reg.IsMatch(txtEmail.Text.Trim()))
{
Alert("您的邮箱格式填写不正确！");
Select(txtEmail);
return;
}
}
if (provinceid == 0)
{
Alert("请您选择省份！");
return;
}
if (cityid == 0)
{
Alert("请您选择城市！");
return;
}
if (txtQuestion.Text.Trim().Length == 0)
{
Alert("请您填写安全提问问题！");
Select(txtQuestion);
return;
}
if (txtAnswer.Text.Trim().Length == 0)
{
Alert("请您填写安全提问答案！");
Select(txtAnswer);
return;
}
#endregion
#region 用户基本信息
Transaction t = new Transaction();
XiHuan_UserInfoEntity NewUser = new XiHuan_UserInfoEntity();
NewUser.UserType = (int)XiHuan_UserFacade.UserType.个人注册;
NewUser.UserName = txtUserName.Text.Trim();
NewUser.OrignalPwd = txtPassWord.Text.Trim();
NewUser.Md5Pwd = CommonMethod.MD5Encrypt(txtPassWord.Text.Trim());
NewUser.Email = txtEmail.Text.Trim();
NewUser.Gender = Rad_sex_0.Checked ? (byte)1 : (byte)0;
NewUser.ProvinceId = provinceid;
NewUser.ProvinceName = ddlProvince.SelectedItem.Text;
NewUser.CityId = cityid;
if (cityid > 0)
{
NewUser.CityName = CommonMethodFacade.GetCityNameById(cityid.ToString());
}
NewUser.AreaId = areaid;
if (areaid > 0)
{
NewUser.AreaName = CommonMethodFacade.GetAreaNameById(areaid.ToString());
}
if (schoolid > 0)
{
NewUser.SchoolId = schoolid;
NewUser.SchoolName = CommonMethodFacade.GetSchoolNameById(provinceid.ToString(), cityid.ToString(), schoolid.ToString());
}
NewUser.HuanBi = SystemConfigFacade.Instance().RegisterAddHuanBi();
NewUser.Score = SystemConfigFacade.Instance().RegisterAddScore();
NewUser.RegisterDate = NewUser.LastLoginTime = DateTime.Now;
NewUser.Question = txtQuestion.Text.Trim();
NewUser.Answer = txtAnswer.Text.Trim();
NewUser.HeadImage = "images/nophoto.gif";
t.DoSaveObject(NewUser);
#endregion
#region 推荐人积分换币更新
if (txtTuiJianMember.Text.Trim().Length > 0)
{
string updateTJ = string.Format("update XiHuan_UserInfo set Score=Score+{0},HuanBi=HuanBi+{1} where UserName='******' ",
SystemConfigFacade.Instance().TuiJianAddScore(), SystemConfigFacade.Instance().TuiJianAddHuanBi(), txtTuiJianMember.Text.Trim());
t.DoSqlNonQueryString(updateTJ, GlobalVar.DataBase_Name);
}
#endregion
#region 给新注册用户发送短消息
XiHuan_MessageFacade.SendNewMessage(1, NewUser.ID, "喜换网", NewUser.UserName, "尊敬的会员" + NewUser.UserName + "," + SystemConfigFacade.Instance().RegMesContent(), t, true);
#endregion
try
{
t.Commit();
#region 注册完成后自动登陆调转到个人管理中心
Alert("恭喜：您的注册信息已成功提交！");
CommonMethod.AddLoginCookie(NewUser.ID, NewUser.UserName, DateTime.MinValue);
SendMailFacade.sendEmail(CommonMethodFacade.GetConfigValue("NoticeEmail"), "有人在喜换网注册了", "有人在喜换网注册了:" + txtUserName.Text);
Response.Redirect("membercenter.aspx?action=" + Server.UrlEncode("membermanageindex.aspx"));
#endregion
}
catch (Exception ex)
{
t.RollBack();
Alert("抱歉：注册信息提交失败," + ex.Message + "请重试！");
return;
}
}
private void InitPage()
{
if (GoodDetail == null)
{
return;
}
#region 界面显示
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__ID, GoodDetail.OwnerId);
rc.AddSelect(XiHuan_UserInfoEntity.__GENDER);
rc.AddSelect(XiHuan_UserInfoEntity.__SCORE);
rc.AddSelect(XiHuan_UserInfoEntity.__HUANBI);
rc.AddSelect(XiHuan_UserInfoEntity.__GOODFEED);
rc.AddSelect(XiHuan_UserInfoEntity.__XINYU);
rc.AddSelect(XiHuan_UserInfoEntity.__REGISTERDATE);
rc.AddSelect(XiHuan_UserInfoEntity.__LASTLOGINTIME);
rc.AddSelect(XiHuan_UserInfoEntity._TelePhone);
rc.AddSelect(XiHuan_UserInfoEntity._WangWang);
rc.AddSelect(XiHuan_UserInfoEntity.__EMAIL);
rc.AddSelect(XiHuan_UserInfoEntity.__QQ);
rc.AddSelect(XiHuan_UserInfoEntity.__MSN);
rc.AddSelect(XiHuan_UserInfoEntity.__OTHERLINK);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
lblScore.Text = user.Score.ToString();
lblHB.Text = user.HuanBi.ToString();
lblGoodFeed.Text = user.GoodFeed.ToString();
lblXY.Text = user.XinYu.ToString();
lblRegisterDate.Text = user.RegisterDate.ToString("yyyy-MM-dd");
lblLastLoginTime.Text = user.LastLoginTime.ToString("yyyy-MM-dd");
lblWW.Text = CommonMethod.FinalString(user.WangWang).Length > 0 ? " " + string.Format(GlobalVar.BIGSTRWW, Server.UrlEncode(user.WangWang)) : string.Empty;
lblQQ.Text = CommonMethod.FinalString(user.QQ).Length > 0 ? string.Format(GlobalVar.QQSTR, user.QQ) : string.Empty;
linkMethod.Text = string.Format(" 电话：{0} 邮箱：{1} 旺旺:{5} QQ:{2} MSN:{3}<br/> 其他联系方式：{4}", user.TelePhone, user.Email, user.QQ + lblQQ.Text, user.Msn, user.OtherLink, lblWW.Text);
lblGender.Text = CommonMethodFacade.FormatGender(user.Gender, SrcRootPath);
#endregion
#region 换主热门换品
RetrieveCriteria rchotgoods = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
Condition hotgoodscondition = rchotgoods.GetNewCondition();
hotgoodscondition.AddEqualTo(XiHuan_UserGoodsEntity.__OWNERID, GoodDetail.OwnerId);
hotgoodscondition.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
rchotgoods.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO);
rchotgoods.AddSelect(XiHuan_UserGoodsEntity.__NAME);
rchotgoods.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
rchotgoods.Top = 10;
rchotgoods.OrderBy(XiHuan_UserGoodsEntity.__VIEWCOUNT, false);
rptHotGoods.DataSource = rchotgoods.AsDataTable();
rptHotGoods.DataBind();
#endregion
#region 其它相关换品
DataTable dtrelateGoods = Query.ProcessSql(
@"select top 10 DefaultPhoto,Name,DetailUrl from XiHuan_UserGoods
with(nolock) where TypeId=" + GoodDetail.TypeId + " and OwnerId<>" + GoodDetail.OwnerId + " and IsChecked=1 order by newid() ",
GlobalVar.DataBase_Name);
rtpRelateGoods.DataSource = dtrelateGoods;
rtpRelateGoods.DataBind();
#endregion
#region 留言
BindNotes();
#endregion
#region 交换请求
BindRequire();
#endregion
#region 一换品下一换品链接
string sqlpre = "select top 1 Name,DetailUrl from XiHuan_UserGoods with(nolock) where Id<" + Request["id"] + " and IsChecked=1 order by Id desc;";
string sqlnext = "select top 1 Name,DetailUrl from XiHuan_UserGoods with(nolock) where Id>" + Request["id"] + " and IsChecked=1 order by Id asc;";
DataSet dt = Query.ProcessMultiSql(sqlpre + sqlnext, GlobalVar.DataBase_Name);
lblPre.Text = dt.Tables[0].Rows.Count > 0 ? string.Format("<a href=\"{0}\" title=\"{1}\">{2}</a>", SrcRootPath + (dt.Tables[0].Rows[0][1]), dt.Tables[0].Rows[0][0], CommonMethod.GetSubString(CommonMethod.FinalString(dt.Tables[0].Rows[0][0]), 20, "")) : "没有了";
lblNext.Text = dt.Tables[1].Rows.Count > 0 ? string.Format("<a href=\"{0}\" title=\"{1}\">{2}</a>", SrcRootPath + (dt.Tables[1].Rows[0][1]), dt.Tables[1].Rows[0][0], CommonMethod.GetSubString(CommonMethod.FinalString(dt.Tables[1].Rows[0][0]), 20, "")) : "没有了";
#endregion
#region 换品图片加载
if (GoodDetail.DefaultPhoto != null && GoodDetail.DefaultPhoto.Trim().Length > 0 && !GoodDetail.DefaultPhoto.Trim().Equals("images/none.jpg"))
{
RetrieveCriteria rcgoodimage = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition cg = rcgoodimage.GetNewCondition();
cg.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, GoodDetail.Id);
cg.AddEqualTo(XiHuan_GoodsImageEntity.__ISDEFAULTPHOTO, 0);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGSRC);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGDESC);
rcgoodimage.OrderBy(XiHuan_GoodsImageEntity.__CREATEDATE, false);
rptGoodsImage.DataSource = rcgoodimage.AsDataTable();
rptGoodsImage.DataBind();
}
#endregion
}
