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