public JsonResult Create(WC_UserModel model)
{
model.Id = ResultHelper.NewId;
if (model != null && ModelState.IsValid)
{
if (m_BLL.Create(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",OpenId" + model.OpenId, "成功", "创建", "WC_User");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",OpenId" + model.OpenId + "," + ErrorCol, "失败", "创建", "WC_User");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail)));
}
}
public ActionResult MoveUser(string userids, string groupid)
{
WC_OfficalAccountsModel wcmodel = account_BLL.GetCurrentAccount();
List <string> itemstr = userids.Split(',').ToList();
foreach (var item in itemstr)
{
ViewBag.Perm = GetPermission();
WC_UserModel model = m_BLL.GetById(item);
model.GroupId = groupid;
if (m_BLL.Edit(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",OpenId" + model.OpenId, "成功", "修改", "WC_User");
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",OpenId" + model.OpenId + "," + ErrorCol, "失败", "修改", "WC_User");
return(Json(JsonHandler.CreateMessage(0, Resource.EditFail + ErrorCol)));
}
}
return(Json(JsonHandler.CreateMessage(1, Resource.EditSucceed)));
}
/// <summary>
/// 校验Excel数据,这个方法一般用于重写校验逻辑
/// </summary>
public virtual bool CheckImportData(string fileName, List <WC_UserModel> list, ref ValidationErrors errors)
{
var targetFile = new FileInfo(fileName);
if (!targetFile.Exists)
{
errors.Add("导入的数据文件不存在");
return(false);
}
var excelFile = new ExcelQueryFactory(fileName);
//对应列头
excelFile.AddMapping <WC_UserModel>(x => x.OpenId, "OpenId");
excelFile.AddMapping <WC_UserModel>(x => x.NickName, "NickName");
excelFile.AddMapping <WC_UserModel>(x => x.Sex, "Sex");
excelFile.AddMapping <WC_UserModel>(x => x.Language, "Language");
excelFile.AddMapping <WC_UserModel>(x => x.City, "City");
excelFile.AddMapping <WC_UserModel>(x => x.Province, "Province");
excelFile.AddMapping <WC_UserModel>(x => x.Country, "Country");
excelFile.AddMapping <WC_UserModel>(x => x.HeadImgUrl, "HeadImgUrl");
excelFile.AddMapping <WC_UserModel>(x => x.SubscribeTime, "SubscribeTime");
excelFile.AddMapping <WC_UserModel>(x => x.UnionId, "UnionId");
excelFile.AddMapping <WC_UserModel>(x => x.Remark, "Remark");
excelFile.AddMapping <WC_UserModel>(x => x.GroupId, "GroupId");
excelFile.AddMapping <WC_UserModel>(x => x.TagidList, "TagidList");
excelFile.AddMapping <WC_UserModel>(x => x.Subscribe, "Subscribe");
excelFile.AddMapping <WC_UserModel>(x => x.OfficalAccountId, "OfficalAccountId");
//SheetName
var excelContent = excelFile.Worksheet <WC_UserModel>(0);
int rowIndex = 1;
//检查数据正确性
foreach (var row in excelContent)
{
var errorMessage = new StringBuilder();
var entity = new WC_UserModel();
entity.Id = row.Id;
entity.OpenId = row.OpenId;
entity.NickName = row.NickName;
entity.Sex = row.Sex;
entity.Language = row.Language;
entity.City = row.City;
entity.Province = row.Province;
entity.Country = row.Country;
entity.HeadImgUrl = row.HeadImgUrl;
entity.SubscribeTime = row.SubscribeTime;
entity.UnionId = row.UnionId;
entity.Remark = row.Remark;
entity.GroupId = row.GroupId;
entity.TagidList = row.TagidList;
entity.Subscribe = row.Subscribe;
entity.OfficalAccountId = row.OfficalAccountId;
//=============================================================================
if (errorMessage.Length > 0)
{
errors.Add(string.Format(
"第 {0} 列发现错误：{1}{2}",
rowIndex,
errorMessage,
"<br/>"));
}
list.Add(entity);
rowIndex += 1;
}
if (errors.Count > 0)
{
return(false);
}
return(true);
}
/// <summary>
/// 订阅（关注）事件
/// </summary>
/// <returns></returns>
public override IResponseMessageBase OnEvent_SubscribeRequest(RequestMessageEvent_Subscribe requestMessage)
{
ValidationErrors errors = new ValidationErrors();
using (DBContainer db = new DBContainer())
{
IWC_OfficalAccountsBLL account_BLL = new WC_OfficalAccountsBLL()
{
m_Rep = new WC_OfficalAccountsRepository(db)
};
//获得当前公众号
WC_OfficalAccountsModel account = account_BLL.GetById(Id);
//将用户提取到本地数据库
WC_UserModel userModel = new WC_UserModel();
IWC_UserBLL user_BLL = new WC_UserBLL()
{
m_Rep = new WC_UserRepository(db)
};
UserInfoJson userJson = UserApi.Info(account.AccessToken, requestMessage.FromUserName);
userModel.Id = ResultHelper.NewId;
userModel.OpenId = userJson.openid;
userModel.NickName = userJson.nickname;
userModel.Sex = userJson.sex;
userModel.Language = userJson.language;
userModel.City = userJson.city;
userModel.Province = userJson.province;
userModel.Country = userJson.country;
userModel.HeadImgUrl = userJson.headimgurl;
userModel.SubscribeTime = ResultHelper.GetTimeByLong(userJson.subscribe_time);
userModel.UnionId = userJson.unionid;
userModel.Remark = userJson.remark;
userModel.GroupId = userJson.groupid.ToString();
userModel.TagidList = string.Join(",", userJson.tagid_list.ToArray());
userModel.Subscribe = userJson.subscribe;
userModel.OfficalAccountId = account.Id;
user_BLL.Create(ref errors, userModel);
IWC_MessageResponseRepository m_Rep = new WC_MessageResponseRepository(db);
//订阅回复
List <WC_MessageResponse> messageList = m_Rep.GetSubscribeResponseContent(account.Id);
if (messageList.Count() > 0)
{
if (messageList[0].Category == (int)WeChatReplyCategory.Text)
{
var responseMessage = base.CreateResponseMessage <ResponseMessageText>();
responseMessage.CreateTime = ResultHelper.NowTime;
responseMessage.ToUserName = requestMessage.FromUserName;
responseMessage.FromUserName = account.OfficalId;
responseMessage.Content = messageList[0].TextContent;
return(responseMessage);
}
//图文方式
else if (messageList[0].Category == (int)WeChatReplyCategory.Image)
{
var responseMessage = CreateResponseMessage <ResponseMessageNews>();
foreach (var model in messageList)
{
responseMessage.Articles.Add(new Article()
{
Title = model.TextContent,
Description = model.ImgTextContext,
PicUrl = WebChatPara.SiteUrl + model.ImgTextUrl,
Url = model.ImgTextLink
});
}
return(responseMessage);
} //一般很少用到
else if (messageList[0].Category == (int)WeChatReplyCategory.Voice)
{
var responseMessage = base.CreateResponseMessage <ResponseMessageMusic>();
responseMessage.Music.MusicUrl = WebChatPara.SiteUrl + messageList[0].MeidaUrl;
responseMessage.Music.Title = messageList[0].TextContent;
responseMessage.Music.Description = messageList[0].Remark;
return(responseMessage);
}
}
var errorResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageText>();
return(errorResponseMessage);
}
}
