/// <summary>
/// 根据openid 获取 用户信息
/// </summary>
/// <param name="openId"></param>
/// <returns></returns>
public static Customer GetByopenId(string openId)
{
using (var db = new DanfossDbEntities())
{
return(db.Customer.FirstOrDefault(o => o.OpenId == openId));
}
}
public static Customer CheckNewWeAccount(UserInfo userInfo)
{
var existCustomer = GetByopenId(userInfo.OpenId);
//如果用户不存在，则在第一次检查的时候保存用户信息
if (existCustomer == null)
{
var customer = new Customer
{
OpenId = userInfo.OpenId,
NickName = userInfo.NickName,
HeadImgUrl = userInfo.HeadImgUrl,
Sex = int.Parse(userInfo.Sex),
CreatorTime = DateTime.Now,
Country = userInfo.Country,
City = userInfo.City,
Province = userInfo.Province
};
using (var db = new DanfossDbEntities())
{
db.Customer.Add(customer);
db.SaveChanges();
}
return(customer);
}
return(null);
}
/// <summary>
/// 获取分享列表
/// </summary>
/// <returns></returns>
public static List <SharesLogDto> GetSharesLog()
{
List <SharesLogDto> result = new List <SharesLogDto>();
try
{
using (var db = new DanfossDbEntities())
{
var query = from a in db.SharesLog
join b in db.Customer on a.OpenId equals b.OpenId
select new SharesLogDto
{
NickName = b.NickName,
OpenId = a.OpenId,
Shares = a.Shares
};
result = query.ToList();
}
}
catch (Exception ex)
{
Lgr.Log.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 获取所有用户资料
/// </summary>
/// <returns></returns>
public static List <Customer> GetList()
{
using (var db = new DanfossDbEntities())
{
return(db.Customer.ToList());
}
}
/// <summary>
/// 获取发送邮件列表
/// </summary>
public static List <SendEmailLogDto> GetSendEmailLog()
{
List <SendEmailLogDto> result = new List <SendEmailLogDto>();
try
{
using (var db = new DanfossDbEntities())
{
var query = from a in db.SendEmailLog
join b in db.Customer on a.OpenId equals b.OpenId
select new SendEmailLogDto
{
CreateTime = a.CreateTime,
Email = a.Email,
NickName = b.NickName,
OpenId = a.OpenId,
SendContent = a.SendContent
};
result = query.ToList();
}
}
catch (Exception ex)
{
Lgr.Log.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="model"></param>
public static void AddCustomer(Customer model)
{
using (var db = new DanfossDbEntities())
{
db.Customer.Add(model);
db.SaveChanges();
}
}
/// <summary>
/// 增加分享次数
/// </summary>
/// <param name="log"></param>
public static void AddSharesLog(SharesLog log)
{
using (var db = new DanfossDbEntities())
{
var model = db.SharesLog.FirstOrDefault(o => o.OpenId == log.OpenId);
if (model != null)
{
model.Shares += 1;
db.SharesLog.Attach(model);
db.Entry(model).State = EntityState.Modified;
}
else
{
db.SharesLog.Add(log);
}
db.SaveChanges();
}
}
/// <summary>
/// 增加邮件发送记录
/// </summary>
/// <param name="log"></param>
public static void AddSendEmailLog(SendEmailLog log)
{
try
{
using (var db = new DanfossDbEntities())
{
var model = db.Customer.FirstOrDefault(o => o.OpenId == log.OpenId);
if (model != null)
{
model.Email = log.Email;
db.Customer.Attach(model);
db.Entry(model).State = EntityState.Modified;
}
db.SendEmailLog.Add(log);
db.SaveChanges();
}
}
catch (Exception ex)
{
Lgr.Log.Error(ex.Message, ex);
}
}