public override void Executing(IJobExecutionContext context)
{
var broker = PersistBrokerFactory.GetPersistBroker();
var focusUserService = new FocusUserService();
var user = UserIdentityUtil.GetCurrentUser();
var focusUserList = focusUserService.GetFocusUserList();
Logger.Debug($"获取到{focusUserList.count}条微信公众号关注用户");
if (focusUserList.count > 0)
{
var user_list = new List <OpenId>();
focusUserList.data.openid.ForEach(item => user_list.Add(new OpenId()
{
openid = item, lang = "zh_CN"
}));
var focusUsers = focusUserService.GetFocusUsers(JsonConvert.SerializeObject(new { user_list }));
broker.ExecuteTransaction(() =>
{
var dataList = focusUsers.user_list
.Select(focusUser =>
{
var wechat_user = new wechat_user()
{
Id = focusUser.openid,
subscribe = Convert.ToInt32(focusUser.subscribe),
nickname = focusUser.nickname,
name = focusUser.nickname,
sex = focusUser.sex,
language = focusUser.language,
city = focusUser.city,
province = focusUser.province,
country = focusUser.country,
headimgurl = focusUser.headimgurl,
subscribe_time = focusUser.subscribe_time.ToDateTime(),
unionid = focusUser.unionid,
remark = focusUser.remark,
groupid = focusUser.groupid,
subscribe_scene = focusUser.subscribe_scene,
qr_scene = focusUser.qr_scene,
qr_scene_str = focusUser.qr_scene_str,
createdBy = user.Id,
createdByName = user.Name,
modifiedBy = user.Id,
modifiedByName = user.Name,
createdOn = DateTime.Now,
modifiedOn = DateTime.Now,
};
return(wechat_user);
})
.ToList();
broker.BulkCreateOrUpdate(dataList);
Logger.Debug($"创建或更新{dataList.Count}条关注用户信息");
});
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="password"></param>
public void EditPassword(string password)
{
var sql = $@"
UPDATE auth_user
SET password = @password
WHERE user_infoid = @id;
";
var user = UserIdentityUtil.GetCurrentUser();
var paramList = new Dictionary <string, object>()
{
{ "@id", user.Id }, { "@password", password }
};
Broker.Execute(sql, paramList);
}
public FriendBlogProfile()
{
CreateMap <Jobs.SyncBlogJob.BlogDetail, FriendBlog.friend_blog>()
.ForMember(dest => dest.Id, opt => opt.MapFrom(item => item.id))
.ForMember(dest => dest.name, opt => opt.MapFrom(item => item.title))
.ForMember(dest => dest.content, opt => opt.MapFrom(item => item.content))
.ForMember(dest => dest.description, opt => opt.MapFrom(item => item.description))
.ForMember(dest => dest.createdOn, opt => opt.MapFrom(item => item.createTime.ToDateTime()))
.ForMember(dest => dest.createdBy, opt => opt.MapFrom(item => UserIdentityUtil.GetCurrentUserId()))
.ForMember(dest => dest.createdByName, opt => opt.MapFrom(item => UserIdentityUtil.GetCurrentUser().Name))
.ForMember(dest => dest.modifiedOn, opt => opt.MapFrom(item => item.updateTime.ToDateTime()))
.ForMember(dest => dest.modifiedBy, opt => opt.MapFrom(item => UserIdentityUtil.GetCurrentUserId()))
.ForMember(dest => dest.modifiedByName, opt => opt.MapFrom(item => UserIdentityUtil.GetCurrentUser().Name))
.ForMember(dest => dest.first_picture, opt => opt.MapFrom(item => item.firstPicture));
}
public override void Executing(IJobExecutionContext context)
{
var broker = PersistBrokerFactory.GetPersistBroker();
Logger.Debug("开始同步微信公众号图文素材");
try
{
broker.ExecuteTransaction(() =>
{
var result = new WeChatNewsService(broker).GetDataList(1, 5000);
var user = UserIdentityUtil.GetCurrentUser() ?? UserIdentityUtil.GetSystem();
var dataList = (from item in result.item
let news = item.content.news_item.FirstOrDefault()
select new wechat_news()
{
wechat_newsId = item.media_id,
html_content = new WeChatNewsMaterialService(broker).ConvertWeChatUrlToLocalUrl(news?.content),
media_id = item.media_id,
update_time = item.update_time,
name = news?.title,
author = news?.author,
digest = news?.digest,
thumb_media_id = news?.thumb_media_id,
content_source_url = news?.content_source_url,
createdBy = user.Id,
createdByName = user.Name,
modifiedBy = user.Id,
modifiedByName = user.Name,
createdOn = DateTime.Now,
modifiedOn = DateTime.Now,
})
.ToList();
broker.BulkCreateOrUpdate(dataList);
Logger.Debug($"发现{result.item_count}篇文章需要同步");
Logger.Debug($"同步微信公众号图文素材成功，共同步：{dataList.Count()}篇文章");
});
}
catch (Exception e)
{
Logger.Error("同步微信公众号图文素材失败", e);
}
}