public UserModel GetUser(string userName)
{
var user = new UserModel();
using (var cmd = DataCommandManager.GetDataCommand("GetUserByName"))
{
cmd.SetParameterValue("@Mobile", userName);
using (var dr = cmd.ExecuteDataReader())
{
while (dr.Read())
{
user.UserId = !Convert.IsDBNull(dr["ID"]) ? int.Parse(dr["ID"].ToString()) : 0;
user.Mobile = !Convert.IsDBNull(dr["Mobile"]) ? dr["Mobile"].ToString() : string.Empty;
user.WxOpenId = !Convert.IsDBNull(dr["WxOpenId"]) ? dr["WxOpenId"].ToString() : string.Empty;
user.WxNickName = !Convert.IsDBNull(dr["WxNickName"]) ? dr["WxNickName"].ToString() : string.Empty;
user.WxSex = !Convert.IsDBNull(dr["WxSex"]) ? int.Parse(dr["WxSex"].ToString()) : 0;
user.WxHeadUrl = !Convert.IsDBNull(dr["WxHeadUrl"]) ? dr["WxHeadUrl"].ToString() : string.Empty;
user.WxSubTime = !Convert.IsDBNull(dr["WxSubTime"]) ? Convert.ToDateTime(dr["WxSubTime"]) : DateTime.MinValue;
user.WxUnionId = !Convert.IsDBNull(dr["WxUnionId"]) ? dr["WxUnionId"].ToString() : string.Empty;
user.WxRemark = !Convert.IsDBNull(dr["WxRemark"]) ? dr["WxRemark"].ToString() : string.Empty;
user.WxGroupId = !Convert.IsDBNull(dr["WxGroupId"]) ? int.Parse(dr["WxGroupId"].ToString()) : 0;
user.Status = !Convert.IsDBNull(dr["Status"]) ? int.Parse(dr["Status"].ToString()) : 0;
user.CreateTime = !Convert.IsDBNull(dr["CreateTime"]) ? Convert.ToDateTime(dr["CreateTime"]) : DateTime.MinValue;
user.SourceId = !Convert.IsDBNull(dr["SourceId"]) ? dr["SourceId"].ToString() : string.Empty;
}
}
}
return user;
}
public int Insert(UserModel userModel)
{
return userDataAccess.Insert(userModel);
}
public bool Update(UserModel userModel)
{
throw new NotImplementedException();
}
public PagedList<UserModel> GetUserListBySourceId(string sourceId, int pageIndex, int pageSize)
{
var userList = new List<UserModel>();
var count = 0;
using (var cmd = DataCommandManager.GetDataCommand("GetUserByPageListAndSourceId"))
{
cmd.SetParameterValue("@PageIndex", pageIndex);
cmd.SetParameterValue("@PageSize", pageSize);
cmd.SetParameterValue("@SourceId", sourceId);
using (var ds = cmd.ExecuteDataSet())
{
if (ds.Tables.Count >= 2)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
var user = new UserModel();
user.UserId = !Convert.IsDBNull(dr["ID"]) ? int.Parse(dr["ID"].ToString()) : 0;
user.Mobile = !Convert.IsDBNull(dr["Mobile"]) ? dr["Mobile"].ToString() : string.Empty;
user.WxOpenId = !Convert.IsDBNull(dr["WxOpenId"]) ? dr["WxOpenId"].ToString() : string.Empty;
user.WxNickName = !Convert.IsDBNull(dr["WxNickName"]) ? dr["WxNickName"].ToString() : string.Empty;
user.WxSex = !Convert.IsDBNull(dr["WxSex"]) ? int.Parse(dr["WxSex"].ToString()) : 0;
user.WxHeadUrl = !Convert.IsDBNull(dr["WxHeadUrl"]) ? dr["WxHeadUrl"].ToString() : string.Empty;
user.WxSubTime = !Convert.IsDBNull(dr["WxSubTime"]) ? Convert.ToDateTime(dr["WxSubTime"]) : DateTime.MinValue;
user.WxUnionId = !Convert.IsDBNull(dr["WxUnionId"]) ? dr["WxUnionId"].ToString() : string.Empty;
user.WxRemark = !Convert.IsDBNull(dr["WxRemark"]) ? dr["WxRemark"].ToString() : string.Empty;
user.WxGroupId = !Convert.IsDBNull(dr["WxGroupId"]) ? int.Parse(dr["WxGroupId"].ToString()) : 0;
user.Status = !Convert.IsDBNull(dr["Status"]) ? int.Parse(dr["Status"].ToString()) : 0;
user.CreateTime = !Convert.IsDBNull(dr["CreateTime"]) ? Convert.ToDateTime(dr["CreateTime"]) : DateTime.MinValue;
user.SourceId = !Convert.IsDBNull(dr["SourceId"]) ? dr["SourceId"].ToString() : string.Empty;
userList.Add(user);
}
var countDr = ds.Tables[1].Rows[0][0];
count = !Convert.IsDBNull(countDr) ? Convert.ToInt32(countDr) : 0;
}
}
var result = new PagedList<UserModel>(userList, pageIndex, pageSize, count);
return result;
}
}
public int Insert(UserModel userModel)
{
using (var cmd = DataCommandManager.GetDataCommand("InsertUser"))
{
cmd.SetParameterValue("@Mobile", userModel.Mobile);
cmd.SetParameterValue("@WxOpenId", userModel.WxOpenId);
cmd.SetParameterValue("@WxNickName", userModel.WxNickName);
cmd.SetParameterValue("@WxSex", userModel.WxSex);
cmd.SetParameterValue("@WxHeadUrl", userModel.WxHeadUrl);
cmd.SetParameterValue("@WxSubTime", userModel.WxSubTime);
cmd.SetParameterValue("@WxUnionId", userModel.WxUnionId);
cmd.SetParameterValue("@WxRemark", userModel.WxRemark);
cmd.SetParameterValue("@WxGroupId", userModel.WxGroupId);
cmd.SetParameterValue("@Status", userModel.Status);
cmd.SetParameterValue("@CreateTime", userModel.CreateTime);
cmd.SetParameterValue("@SourceId", userModel.SourceId);
var result = cmd.ExecuteScalar();
if (result != null)
{
return Convert.ToInt32(result);
}
return 0;
}
}
public async Task<JsonResult> Login(LoginUser loginUser)
{
#if DEBUG
loginUser.WxOpenId = debugOpenId;//"oOGoot0O0nEuP4uEHdNLQyNpGnwM";//"oOGootzpwe38CkQSTj00wyHhKSMk";//
#endif
var jsonResult = new JsonResult();
try
{
//logger.Info(JsonHelper.ToJson(loginUser));
//check验证码
var user = UserService.GetUserByWxOpenId(loginUser.WxOpenId);
if (user == null||user.UserId==0)
{
//创建用户
var openId = loginUser.WxOpenId;
var accesstoken = AccessTokenContainer.TryGetToken(AppId, AppSecret);
var wxUser = CommonApi.GetUserInfo(accesstoken, openId);
if (!string.IsNullOrEmpty(wxUser.headimgurl))
{
wxUser.headimgurl = wxUser.headimgurl.Substring(0, wxUser.headimgurl.Length - 1) + "96";
}
var userModel = new UserModel()
{
CreateTime = DateTime.Now,
WxOpenId = openId,
WxHeadUrl = wxUser.headimgurl,
WxNickName = wxUser.nickname,
Status = 1
};
if (UserService.Insert(userModel) > 0)
{
user = UserService.GetUserByWxOpenId(loginUser.WxOpenId);
}
else
{
logger.Error("用户信息insert失败:"+JsonHelper.ToJson(userModel));
}
}
else
{
if (!string.IsNullOrEmpty(user.Mobile) && loginUser.Mobile != user.Mobile)
{
jsonResult.Data = new { IsSuccess = false, Msg = "一个微信账号只能绑定一个手机号。" };
return jsonResult;
}
}
//logger.Info(JsonHelper.ToJson(user));
if (UserService.CheckMobileCaptcha(user.UserId, loginUser.Mobile, loginUser.Captcha))
{
//更新验证码状态
UserService.UpdateUserCaptchaStatus(user.UserId, loginUser.Mobile);
//logger.Info(1);
//将用户的手机号与weixinid绑定
UserService.UpdateMobileUserByWxOpenId(loginUser.Mobile, loginUser.WxOpenId);
//logger.Info(2);
var result = UserManager.FindByNameAsync(loginUser.Mobile);
//logger.Info(3);
//用户禁用不让登陆
if (result != null && user.Status == 1)
{
//logger.Info(JsonHelper.ToJson(result));
await SignInAsync(result.Result, true);
//logger.Info(4);
jsonResult.Data = new { IsSuccess = true };
}
else
{
jsonResult.Data = new { IsSuccess = false, Msg = "您的用户已被禁用" };
}
}
else
{
jsonResult.Data = new { IsSuccess = false, Msg = "验证码不正确" };
}
}
catch (Exception ex)
{
logger.Error(ex);
}
return jsonResult;
}