/// <summary>
/// 更新小程序用户信息
/// </summary>
/// <returns></returns>
public WxResponseResultModel UpdateSessionKey(WxMiniprogramUserModel model)
{
WxResponseResultModel result = new WxResponseResultModel();
bool flag = false;
try
{
string querySql = string.Format(@"UPDATE kyk_miniprogram_user SET session_key='{0}' WHERE openid='{1}'", model.Session_key, model.OpenId);
flag = Convert.ToInt32(DBCommon.MYSQLDB.ExecuteNonQuery(querySql)) > 0 ? true : false;
if (flag)
{
result.Code = "ok";
result.Message = "更新用户信息成功";
}
else
{
result.Message = "更新用户信息失败";
}
}
catch (Exception ex)
{
result.Message = ex.Message;
Logging.Error("更新用户信息出错：" + ex.Message);
}
return(result);
//return new WxResponseResultModel { Code = "", Message = "" };
}
/// <summary>
/// 新增小程序用户信息
/// </summary>
/// <returns></returns>
public WxResponseResultModel InsertMiniprogramUserInfo(WxMiniprogramUserModel model)
{
WxResponseResultModel result = new WxResponseResultModel();
bool flag = false;
try
{
string querySql = string.Format(@"INSERT INTO kyk_miniprogram_user (openid,session_key,unionid)
VALUES ('{0}', '{1}','{2}');", model.OpenId, model.Session_key, model.Unionid);
flag = Convert.ToInt32(DBCommon.MYSQLDB.ExecuteNonQuery(querySql)) > 0 ? true : false;
if (flag)
{
result.Code = "ok";
result.Message = "保存用户信息成功";
}
else
{
result.Message = "保存用户信息失败";
}
}
catch (Exception ex)
{
result.Message = ex.Message;
Logging.Error("保存用户信息出错：" + ex.Message);
}
return(result);
//return new WxResponseResultModel { Code = "", Message = "" };
}
public WxResponseResultModel Login(string code)
{
WxResponseResultModel rsEntity = new WxResponseResultModel();
StringBuilder urlStr = new StringBuilder();
urlStr.AppendFormat(@"https://api.weixin.qq.com/sns/jscode2session?appid={0}&secret={1}&js_code={2}&grant_type=authorization_code",
AppConsts.WxOpenAppId,
AppConsts.WxOpenAppSecret,
code
);
string resString = Utils.httpGetStr(urlStr.ToString());
WxAuthenticateModel model = Newtonsoft.Json.JsonConvert.DeserializeObject <WxAuthenticateModel>(resString);
if (model != null)
{
WxMiniProgramUserBLL bll = new WxMiniProgramUserBLL();
WxMiniprogramUserModel user = new WxMiniprogramUserModel();
user.OpenId = model.OpenId;
user.Unionid = model.Unionid;
user.Session_key = model.Session_key;
//先判断用户是否存在,返回true则未存在用户，需添加
if (!string.IsNullOrEmpty(user.OpenId) && !string.IsNullOrEmpty(user.Session_key))
{
if (bll.IfExistsMiniprogramUserInfo(user.OpenId))
{
//添加用户
rsEntity = bll.InsertMiniprogramUserInfo(user);
}
else
{
//存在用户，因session_key过期，需要更新
rsEntity = bll.UpdateSessionKey(user);
//rsEntity.Message = "已存在该用户信息";
}
}
}
else
{
rsEntity.Message = "转换用户数据出错！";
}
return(rsEntity);
}
/// <summary>
/// 更新小程序用户信息
/// </summary>
/// <returns></returns>
public WxResponseResultModel UpdateSessionKey(WxMiniprogramUserModel model)
{
WxMiniProgramUserDAL dal = new WxMiniProgramUserDAL();
return(dal.UpdateSessionKey(model));
}
/// <summary>
/// 新增小程序用户信息
/// </summary>
/// <param name="checkAccountID"></param>
/// <returns></returns>
public WxResponseResultModel InsertMiniprogramUserInfo(WxMiniprogramUserModel model)
{
WxMiniProgramUserDAL dal = new WxMiniProgramUserDAL();
return(dal.InsertMiniprogramUserInfo(model));
}