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 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 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 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 }); }