public int UseNMember(HQ_Member entity) { try { entity.Save(); } catch { return 0; } return 1; }
public long ImportMember(string fpath) { fpath = Server.MapPath("~/" + fpath); if (!System.IO.File.Exists(fpath)) { return 0; } var list = G.Util.Tool.ExcelHelper.Read<HQ_Member>(fpath, new string[] { "UserName","PhoneNum","MemberMedical" }, 1, (e) => { e.PhoneNum = e.PhoneNum; e.UserPsw = e.PhoneNum.Substring(5); e.UserType = (int)EnumUserType.Normal; e.CreateBy = LoginInfo.Current.UserName; e.CreateOn = DateTime.Now; }); HttpClient _httpClient = new HttpClient(); _httpClient.BaseAddress = new Uri("http://mall.chinalvju.com/"); try { using (var scope = new TransactionScope()) { foreach (var l in list) { SearchModel se = new SearchModel("uv_MemberWithAmount"); se["UserName"] = l.UserName; se.AddSearch("ID", "PhoneNum", "ShopUserID_G"); var member = se.LoadEntity<HQ_Member>(); if (member == null) { se = new SearchModel("HQ_Member"); se["PhoneNum"] = l.PhoneNum; se.AddSearch("count(id)"); var memCount = se.LoadValue<int>(); if (memCount > 0) { continue; } var dic = new Dictionary<string, string>(); dic.Add("UserName", l.PhoneNum); dic.Add("NickName", l.UserName); dic.Add("Password", l.UserPsw); dic.Add("ConfirmPassword", l.UserPsw); _httpClient.PostAsync("Account/Register", new FormUrlEncodedContent(dic)); l.UserPsw = MD5.EncryptString(l.UserPsw); l.ShopPsw = l.UserPsw; l.Save(); } else { if (!l.PhoneNum.Equals(member.PhoneNum)) { //手机号码变化时,修改商城用户手机号码 Shop_Member s_mem = new Shop_Member(); s_mem["UserID"] = member.ShopUserID_G; s_mem["UserName"] = l.PhoneNum; s_mem.Save(); } var mem = new HQ_Member(); mem["id"] = member.ID; mem.PhoneNum = l.PhoneNum; mem.MemberMedical = l.MemberMedical; mem.Save(); } } scope.Complete(); } return 1; } catch { return 0; } }
public JsonResult SaveMember(HQ_Member entity) { #region 用户名、手机号码是否重复 SearchModel sm = SearchEntity.FormSql<SearchModel>("select count(id) from hq_member where username=@uname and isnull(isdelete,0)=0 and id<>@id", new SqlParameter("uname", entity.UserName), new SqlParameter("id", entity.ID)); int count = sm.LoadValue<int>(); if (count > 0) { return ExController.JsonNet(new { ID = -1 }); } sm = SearchEntity.FormSql<SearchModel>("select count(id) from hq_member where phonenum=@pnum and isnull(isdelete,0)=0 and id<>@id", new SqlParameter("pnum", entity.PhoneNum), new SqlParameter("id", entity.ID)); count = sm.LoadValue<int>(); if (count > 0) { return ExController.JsonNet(new { ID = -2 }); } #endregion try { using (var scope = new TransactionScope()) { if (entity.ID == 0) { var password = "******"; #region 维护新增数据 entity.UserPsw = MD5.EncryptString(password); entity.ShopPsw = entity.UserPsw; entity.CreateBy = LoginInfo.Current.UserName; entity.CreateOn = DateTime.Now; if (entity.UserType == 2) { entity.OpenVipDate = DateTime.Now.Date; } #endregion entity.Save(); HttpClient _httpClient = new HttpClient(); _httpClient.BaseAddress = new Uri("http://mall.chinalvju.com/"); var dic = new Dictionary<string, string>(); dic.Add("UserName", entity.PhoneNum); dic.Add("NickName", entity.UserName); dic.Add("Password", password); dic.Add("ConfirmPassword", password); _httpClient.PostAsync("Account/Register", new FormUrlEncodedContent(dic)); } else { #region 维护修改数据 entity.EditBy = LoginInfo.Current.UserName; entity.EditOn = DateTime.Now; if (entity.UserType == 2) { entity.OpenVipDate = DateTime.Now.Date; } #endregion sm = new SearchModel("uv_MemberWithAmount"); sm["id"] = entity.ID; var oldMem = sm.LoadEntity<HQ_Member>(); if (oldMem.PhoneNum != entity.PhoneNum) { Shop_Member s_mem = new Shop_Member(); s_mem["UserID"] = oldMem.ShopUserID_G; s_mem["UserName"] = entity.PhoneNum; s_mem.Save(); } entity.Save(); } scope.Complete(); } return ExController.JsonNet(entity); } catch { return ExController.JsonNet(new { ID = 0 }); } }
public long SaveMemberHis(HQ_Member member) { return member.Save(); }
public long SaveMemberInfo(HQ_Member member) { member["id"] = LoginInfo.Current.UserID; return member.Save(); }
public int MemberLogin(string username, string userpsw, string yzm, int isrem) { var syzm = base.Session["yzm"]; if (syzm == null || !syzm.ToString().Equals(yzm, StringComparison.CurrentCultureIgnoreCase)) { return -2; } SearchModel sm = new SearchModel("HQ_Member"); sm.MemberName = username; var member = sm.LoadEntity<HQ_Member>(); if (member == null) { return -1; } if (member.UserPsw != MD5.EncryptString(userpsw)) { return 0; } LoginInfo info = new LoginInfo(username); info.SystemID = "Client"; info.UserID = member.ID; var userType = member.UserType; if (userType == 2 && member.OpenVipDate.AddYears(3) < DateTime.Now.Date) { userType = 1; HQ_Member mem = new HQ_Member(); mem["ID"] = member.ID; mem.UserType = 1; mem.Save(); } info.UserType = userType; LoginInfo.SetLoginToken(info, isrem == 1 ? true : false); return 1; }
public long MemberReg(string username, string userpsw, string phone, string msgcode) { try { lock (memRegLockObj) { var exist = IsMemberExist(username); if (exist == -1) { return -2; } if (exist == 1) { return -1; } var omcode = base.HttpContext.Cache["msg-" + phone]; if (omcode == null || omcode.ToString().Length == 0) { return -3; } if (msgcode == null || msgcode.Length == 0 || !msgcode.Equals(omcode.ToString())) { return -4; } HQ_Member member = new HQ_Member(); member.UserName = username; member.UserPsw = MD5.EncryptString(userpsw); member.ShopPsw = member.UserPsw; member.PhoneNum = phone; member.UserType = (int)EnumUserType.Normal; member.CreateOn = DateTime.Now; member.Save(); } } catch { return 0; } return 1; }
public int FindPsw(string phone, string psw, string msgcode) { if (phone == null || phone.Length == 0) { return -1; } if (psw == null || psw.Length == 0) { return 0; } var omcode = base.HttpContext.Cache["msg-" + phone]; if (omcode == null || omcode.ToString().Length == 0) { return -2; } if (msgcode == null || msgcode.Length == 0 || !msgcode.Equals(omcode.ToString())) { return -3; } SearchModel sm = new SearchModel("hq_member"); sm["phonenum"] = phone; sm.AddSearch("id"); var id = sm.LoadValue<int>(); if (id > 0) { HQ_Member member = new HQ_Member(); member["id"] = id; member.UserPsw = MD5.EncryptString(psw); if (member.Save() > 0) { return 1; } return 0; } return -4; }
public long ChangeUserPsw(string oldPsw, string newPsw) { SearchModel se = new SearchModel("hq_member"); se["ID"] = LoginInfo.Current.UserID; var user = se.LoadEntity<HQ_Member>(); if (user.UserPsw.Equals(MD5.EncryptString(oldPsw))) { user = new HQ_Member(); user["ID"] = LoginInfo.Current.UserID; user.UserPsw = MD5.EncryptString(newPsw); return user.Save(); } return 0; }
public long ChangeUserPhone(string phone, string yzm) { if (phone == null || phone.Length == 0 || !(Regex.Match(phone, @"^[1][3,5,8][0-9]{9}$", RegexOptions.Compiled).Success)) { return -1;//手机号码错误 } var omcode = base.HttpContext.Cache["msg-" + phone]; if (omcode == null || omcode.ToString().Length == 0) { return -2;//已发送的短信验证码不存在 } if (yzm == null || yzm.Length == 0 || !yzm.Equals(omcode.ToString())) { return -2;//输入的短信验证码错误 } SearchModel sm = new SearchModel("uv_MemberWithAmount"); sm["ID"] = LoginInfo.Current.UserID; sm.AddSearch("PhoneNum", "ShopUserID_G"); var mem = sm.LoadEntity<HQ_Member>(); try { using (var scope = new TransactionScope()) { if (mem.PhoneNum != phone) { Shop_Member s_mem = new Shop_Member(); s_mem["UserID"] = mem.ShopUserID_G; s_mem["UserName"] = phone; s_mem.Save(); } HQ_Member user = new HQ_Member(); user["ID"] = LoginInfo.Current.UserID; user.PhoneNum = phone; user.Save(); scope.Complete(); } } catch { return 0; } return 1; }
public JsonResult ChangeUserName(string newName) { if (newName.Length == 0) { return this.JsonNet(new CommonResult() { ResultID = 0, Message = "新用户名不能为空!" }); } if (newName == LoginInfo.Current.UserName) { return this.JsonNet(new CommonResult() { ResultID = 0, Message = "新用户名不能与旧用户名相同!" }); } try { lock (changeUNameLockObj) { SearchModel sm = new SearchModel("hq_member"); sm["username"] = newName; sm.AddSearch("count(id)"); var mcount = sm.LoadValue<int>(); if (mcount > 0) { return this.JsonNet(new CommonResult() { ResultID = 0, Message = "新用户名已被其他用户使用!" }); } using (var scope = new TransactionScope()) { sm = new SearchModel("uv_MemberWithAmount"); sm["username"] = LoginInfo.Current.UserName; sm.AddSearch("shopuserid_g"); var shopuserid = sm.LoadValue<int>(); Shop_Member smember = new Shop_Member(); smember["UserID"] = shopuserid; smember["NickName"] = newName; smember.Save(); HQ_Member mem = new HQ_Member(); mem["ID"] = LoginInfo.Current.UserID; mem.UserName = newName; mem.Save(); scope.Complete(); } } } catch { return this.JsonNet(new CommonResult() { ResultID = 0, Message = "修改用户名失败,请重试!" }); } return this.JsonNet(new { ResultID = 1 }); }
public void Register(string uname, string psw, string phone, string yzm) { try { lock (MemberController.memRegLockObj) { SearchModel sm = new SearchModel("HQ_Member"); sm.MemberName = uname; var entity = sm.LoadEntity<HQ_Member>(); if (entity != null) { OutResult(new { ResultID = -1 }); return; } var omcode = base.HttpContext.Cache["msg-" + phone]; if (omcode == null || omcode.ToString().Length == 0) { OutResult(new { ResultID = -3 }); return; } if (yzm == null || yzm.Length == 0 || !yzm.Equals(omcode.ToString())) { OutResult(new { ResultID = -4 }); return; } HQ_Member member = new HQ_Member(); member.UserName = uname; member.UserPsw = MD5.EncryptString(psw); member.ShopPsw = member.UserPsw; member.PhoneNum = phone; member.UserType = (int)EnumUserType.Normal; member.Save(); } //注册商城用户 HttpClient _httpClient = new HttpClient(); _httpClient.BaseAddress = new Uri("http://mall.chinalvju.com/"); var dic = new Dictionary<string, string>(); dic.Add("UserName", phone); dic.Add("NickName", uname); dic.Add("Password", psw); dic.Add("ConfirmPassword", psw); _httpClient.PostAsync("Account/Register", new FormUrlEncodedContent(dic)); } catch { OutResult(new { ResultID = 0 }); return; } OutResult(new { ResultID = 1 }); }