/// <summary> /// 小程序用户更新手机号 /// </summary> /// <param name="reqdata"></param> /// <returns></returns> public string UpdateUserPhone(string reqdata) { string res = ""; try { ZTGJWechatModel.Applet.RequestUserInfo req = JsonConvert.DeserializeObject <ZTGJWechatModel.Applet.RequestUserInfo>(reqdata); string redisKey = RedisKeys.CAPTCHAkey + req.newphone; //key string vcode = RedisHelper.Get <string>(redisKey, (long)0); //获取redis缓存 if (!string.IsNullOrEmpty(vcode) && req.verificationcode == vcode) { if (usersdal.UpdateUserPhone(req)) { res = JsonConvert.SerializeObject(new { code = 0, msg = "ok" }); } else { res = JsonConvert.SerializeObject(new { code = 10002, msg = "系统故障" }); } } else { res = JsonConvert.SerializeObject(new { code = 10002, msg = "验证码不正确" }); } } catch (Exception ex) { res = JsonConvert.SerializeObject(new { code = 10003, msg = "服务器开小差了" }); LogHelper.ErrorLog(ex.Message + "," + ex.StackTrace); } return(res); }
/// <summary> /// 小程序用户更新公司名和用户名 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateUserCompany(ZTGJWechatModel.Applet.RequestUserInfo u) { StringBuilder strSql = new StringBuilder(); DynamicParameters dp = new DynamicParameters(); strSql.Append(" UPDATE Users SET "); strSql.Append(" nickname=@nickname, "); strSql.Append(" companyname=@companyname, "); strSql.Append(" updatetime=@updatetime "); strSql.Append(" WHERE unionid=@unionid "); dp.Add("@unionid", u.unionid, DbType.String, ParameterDirection.Input); dp.Add("@nickname", u.usaername, DbType.String, ParameterDirection.Input); dp.Add("@companyname", u.companyname, DbType.String, ParameterDirection.Input); dp.Add("@updatetime", DateTime.Now, DbType.DateTime, ParameterDirection.Input); using (IDbConnection connection = new SqlConnection(DBConnectionStringConfig.Default.WechatServerDBReadConnStr)) { bool result = connection.Execute(strSql.ToString(), dp) > 0; if (result) { RedisHelper.Remove(RedisKeys.UserEmpowerKey + u.unionid); //清空用户信息缓存 } return(result); } }
/// <summary> /// 小程序用户更新公司名和用户名 /// </summary> /// <param name="reqdata"></param> /// <returns></returns> public string UpdateUserCompany(string reqdata) { string res = ""; try { ZTGJWechatModel.Applet.RequestUserInfo req = JsonConvert.DeserializeObject <ZTGJWechatModel.Applet.RequestUserInfo>(reqdata); if (usersdal.UpdateUserCompany(req)) { res = JsonConvert.SerializeObject(new { code = 0, msg = "ok" }); } else { res = JsonConvert.SerializeObject(new { code = 10002, msg = "故障" }); } } catch (Exception ex) { res = JsonConvert.SerializeObject(new { code = 10003, msg = ex.Message }); LogHelper.ErrorLog(ex.Message + "," + ex.StackTrace); } return(res); }