public void CheckNewAnswer(int uid) { SearchModel sm = new SearchModel("uv_memberask"); sm["MemberID"] = uid; sm.NewAnswerID = 0; sm.AnswerViewed = 0; sm.AddSearch("count(1)"); var newcount = sm.LoadValue<int>(); OutResult(new { ncount = newcount }); }
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 int SendMsgCode(string phone, string type) { if (type == null || type.Length == 0) { return -2;//系统错误 } if (phone != null && phone.Length > 0 && Regex.Match(phone, @"^[1][3,5,8][0-9]{9}$", RegexOptions.Compiled).Success) { var msgKey = string.Empty; if ("1".Equals(type)) { SearchModel se = new SearchModel("hq_member"); se["PhoneNum"] = phone; se.AddSearch("count(1)"); var count = se.LoadValue<int>(); if (count > 0) { return 9; } msgKey = "用户注册短信验证码:"; } if ("3".Equals(type)) { SearchModel se = new SearchModel("hq_member"); se["PhoneNum"] = phone; se.AddSearch("count(1)"); var count = se.LoadValue<int>(); if (count > 0) { return 9; } msgKey = "用户修改手机号码短信验证码:"; } if ("2".Equals(type)) { msgKey = "用户找回密码验证码:"; } var yzm = string.Empty; foreach (var i in Ran.GetRandomArray(6, 0, 9)) { yzm += i.ToString(); } SendUserInfo _U = new SendUserInfo() { isLog = 1, orgid = 555, username = phone }; if (MsgSend.DirectSend(msgKey + yzm, phone, _U)) { base.HttpContext.Cache["msg-" + phone] = yzm; return 1; } else { return 0; } } else { 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 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 }); }