/// <summary> /// 保存微信用户信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Save(TRF_WeChatUserInfo model) { bool success = false; try { DynamicParameters param = new DynamicParameters(); param.Add("openid", model.openid); string querysql = @"SELECT * FROM TRF_WeChatUserInfo WHERE openid=@openid"; TRF_WeChatUserInfo queryresult = idal.FindOne <TRF_WeChatUserInfo>(querysql, param, false); if (queryresult == null) { string insertsql = @"INSERT INTO TRF_WeChatUserInfo ( openid ,nickname ,sex ,language ,city ,province ,country ,headimgurl ,privilege ) VALUES ( @openid ,@nickname ,@sex ,@language ,@city ,@province ,@country ,@headimgurl ,@privilege ) "; success = idal.CreateEntity <TRF_WeChatUserInfo>(insertsql, model); } else { success = true; } } catch (Exception ex) { Logger.Error(string.Format("保存用户微信信息异常,异常信息:{0}", ex.ToString())); } return(success); }
public void SaveJson(wxUserInfoModel model) { try { TRF_WeChatUserInfo entity = new TRF_WeChatUserInfo(); entity.openid = model.user_openid; entity.nickname = model.user_name; idal.Add(entity); idal.Save(); } catch (Exception ex) { Logger.Error(ex); } }
/// <summary> /// 保存用户微信信息 /// </summary> /// <param name="model"></param> public void Save(wxUserInfoModel model) { try { TRF_WeChatUserInfo entity = new TRF_WeChatUserInfo(); entity.openid = model.Openid; entity.nickname = model.Nickname; entity.province = model.Province; entity.city = model.City; entity.country = model.Country; entity.headimgurl = model.Headimgurl; //entity.ID = 1; entity.sex = model.Sex; idal.Add(entity); idal.Save(); } catch (Exception ex) { Logger.Error(string.Format("保存用户信息异常,异常信息:{0}", ex.ToString())); } }
public async Task <ActionResult> Index() { //保存用户微信信息 TRF_WeChatUserInfo entity = new TRF_WeChatUserInfo { openid = "omJcruMSo_al_vHgI7dQHdixsPEM", nickname = "RandyField", sex = "1", city = "成都", province = "四川", country = "中国", headimgurl = "http://wx.qlogo.cn/mmopen/vi_32/onVkE3YIWibjd3JW8XoHppFLXJg4O2CBibOGVt0Df3vQrDS3TQm6uPfdMG85LPHo5rtn1RMibPemghpicVSfStcc3A/0" }; TRF_WeChatUserInfo_BLL.getInstance().Save(entity); //获取奖品领取信息 var model = await TRP_AwardReceive_BLL.getInstance().GetByAwardDetailId("308620"); return(View(model)); }
/// <summary> /// 更新用户信息 /// </summary> /// <param name="model"></param> public void updateUserInfo(wxUserInfoModel model) { try { TRF_WeChatUserInfo entity = new TRF_WeChatUserInfo(); Expression <Func <TRF_WeChatUserInfo, bool> > exp = a => 1 == 1; exp = a => a.openid == model.Openid; Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("nickname", model.Nickname); dic.Add("province", model.Province); dic.Add("city", model.City); dic.Add("country", model.Country); dic.Add("headimgurl", model.Headimgurl); dic.Add("sex", model.Sex); idal.update(exp, dic); idal.Save(); } catch (Exception ex) { Logger.Error(ex.ToString()); } }