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