/// <summary>
/// 根据微信SiteCode获取相应的菜单
/// </summary>
/// <param name="strSiteCode"></param>
/// <returns></returns>
public List <Menu> GetWeiXinMenuBySiteCode(string strSiteCode)
{
List <Menu> res = null;
WXConfigDAL dal = new WXConfigDAL();
//WXConfig wxConfig = dal.GetWXConfigByID(strSiteCode);
WXConfig wxConfig = dal.GetWXConfigBySiteCode(strSiteCode);
if (wxConfig != null)
{
if (!string.IsNullOrEmpty(wxConfig.ID))
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("SELECT * FROM [{0}]", TABLE_NAME);
sql.AppendFormat(" WHERE WXConfigID=@WXConfigID");
sql.AppendFormat(" AND Enabled=1");
IList <System.Data.SqlClient.SqlParameter> paras = new List <System.Data.SqlClient.SqlParameter>()
{
new System.Data.SqlClient.SqlParameter("@WXConfigID", wxConfig.ID)
};
DataSet ds = DbHelperSQL.Query(sql.ToString(), paras.ToArray());
res = ds.ConvertToList <Menu>();
}
}
return(res);
}
/// <summary>
/// 同步微信用户信息
/// </summary>
public static void SyncWXUserBySiteCode(string siteCode)
{
if (!string.IsNullOrEmpty(siteCode))
{
WXConfigDAL dal = new WXConfigDAL();
WXConfig wxConfig = dal.GetWXConfigBySiteCode(siteCode);
if (wxConfig != null)
{
WeiXinCore.Models.WeiXinConfig weixinConfig = new WeiXinCore.Models.WeiXinConfig()
{
ID = wxConfig.WXID,
Name = wxConfig.WXName,
Token = wxConfig.WXToken,
AppId = wxConfig.WXAppID,
AppSecret = wxConfig.WXAppSecret
};
WeiXinCore.WeiXin weixin = new WeiXinCore.WeiXin(weixinConfig);
List <UserInfo> users = weixin.GetUserInfos();
if (users != null)
{
UserDAL dal2 = CreateInstance();
dal2.ClearUser(wxConfig.ID);
foreach (UserInfo user in users)
{
User info = new User()
{
WXConfigID = wxConfig.ID,
OpenID = user.OpenId,
Subscribe = user.Subscribe,
NickName = user.NickName,
Sex = user.Sex,
Language = user.Language,
City = user.City,
Province = user.Province,
Country = user.Country,
HeadImgUrl = user.Headimgurl,
SubscribeTime = user.Subscribe_Time,
};
dal2.Insert(info);
}
}
}
}
}