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 }