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