public static void AddMember(Model.TD_WeiXin_Member member)
{
if (HttpRuntime.Cache[member.MemberID] == null)
{
HttpRuntime.Cache.Insert(member.MemberID, member);
}
}
public static Model.TD_WeiXin_Member GetMember()
{
Model.TD_WeiXin_Member model = null;
if (HttpContext.Current.Request.Url.Host == "localhost")
{
model = new Model.TD_WeiXin_Member();
model.NickName = "林子";
model.MemberID = "2cc0f491-cad9-4e4a-9eea-da9bfb682afb";
model.HeaderImage = "http://wx.qlogo.cn/mmopen/UmpmmQW4reL1FicWwRjSZzMWQeDibic8814LFYCxRiaAPiaQgofqFPnmb3icibf8a0qXxmwT8nFCAIN609DlWKEfkE6yrxgTpln2azt/0";
model.OpenID = "oRlgyxDK7cNDn9CSI4Sfo_SY6AUM";
return(model);
}
if (!string.IsNullOrEmpty(MemberID))
{
model = HttpRuntime.Cache[MemberID] as Model.TD_WeiXin_Member;
if (model == null)
{
model = memberBLL.GetModel(MemberID);
if (model != null)
{
SignModel(model);
}
}
}
return(model);
}
public int Update(Model.TD_WeiXin_Member model)
{
StringBuilder strSql = new StringBuilder();
List <string> fields = new List <string>();
IList <MySqlParameter> parameters = new List <MySqlParameter>();
strSql.Append("update TD_WeiXin_Member set ");
if (model.FocusTime.HasValue)
{
fields.Add("FocusTime=@FocusTime");
parameters.Add(new MySqlParameter("@FocusTime", model.FocusTime));
}
if (!string.IsNullOrEmpty(model.IsFocused))
{
fields.Add("IsFocused=@IsFocused");
parameters.Add(new MySqlParameter("@IsFocused", model.IsFocused));
}
if (model.UnFocusTime.HasValue)
{
fields.Add("UnFocusTime=@UnFocusTime");
parameters.Add(new MySqlParameter("@UnFocusTime", model.UnFocusTime));
}
strSql.Append(string.Join(",", fields));
strSql.Append(" where MemberID=@MemberID ");
parameters.Add(new MySqlParameter("@MemberID", model.MemberID));
return(MySqlHelperUtil.ExecuteNonQuery(strSql.ToString(), parameters.ToArray()));
}
public int Add(Model.TD_WeiXin_Member model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TD_WeiXin_Member(");
strSql.Append("MemberID,NickName,HeaderImage,OpenID,CreateTime,IsFocused,FocusTime,UnFocusTime,Sex,Country,Province,City,OrgID");
strSql.Append(") values (");
strSql.Append("@MemberID,@NickName,@HeaderImage,@OpenID,@CreateTime,@IsFocused,@FocusTime,@UnFocusTime,@Sex,@Country,@Province,@City,@OrgID");
strSql.Append(") ");
MySqlParameter[] parameters =
{
new MySqlParameter("@MemberID", model.MemberID),
new MySqlParameter("@NickName", model.NickName),
new MySqlParameter("@HeaderImage", model.HeaderImage),
new MySqlParameter("@OpenID", model.OpenID),
new MySqlParameter("@CreateTime", model.CreateTime),
new MySqlParameter("@IsFocused", model.IsFocused),
new MySqlParameter("@FocusTime", model.FocusTime),
new MySqlParameter("@UnFocusTime", model.UnFocusTime),
new MySqlParameter("@Sex", model.Sex),
new MySqlParameter("@Country", model.Country),
new MySqlParameter("@Province", model.Province),
new MySqlParameter("@City", model.City),
new MySqlParameter("@OrgID", model.OrgID)
};
return(MySqlHelperUtil.ExecuteNonQuery(strSql.ToString(), parameters));
}
public static void RefreshMember()
{
Model.TD_WeiXin_Member model = memberBLL.GetModel(MemberID);
if (model != null)
{
ReSignModel(model);
}
}
private string GetRegion(Model.TD_WeiXin_Member member)
{
if (member == null)
{
return(string.Empty);
}
string region = member.Province + " " + member.City;
return(region);
}
public static void ReSignModel(Model.TD_WeiXin_Member model)
{
if (HttpRuntime.Cache[model.MemberID] != null)
{
HttpRuntime.Cache[model.MemberID] = model;
}
else
{
HttpRuntime.Cache.Insert(model.MemberID, model);
}
}
private ActionResult ResponseNotifyMessage(int orgID, string bizContent)
{
ZhiFuBaoPort port = new ZhiFuBaoPort(orgID);
port.Subscribe += (openID) => {
DateTime now = DateTime.Now;
Model.TD_WeiXin_Member member = memberBLL.GetModelByOpenID(openID);
if (member == null)
{
ThirdPortUserInfo userInfo = port.GetUserInfo(openID);
member = new Model.TD_WeiXin_Member();
member.MemberID = Guid.NewGuid().ToString();
member.NickName = userInfo.nickname;
member.Sex = (short)userInfo.sex;
member.Country = userInfo.country;
member.Province = userInfo.province;
member.City = userInfo.city;
member.OpenID = userInfo.openid;
member.HeaderImage = userInfo.headimgurl;
member.CreateTime = now;
member.IsFocused = "1";
member.FocusTime = now;
member.OrgID = int.Parse(DESEncrypt.Decrypt(Request["oid"]));
memberBLL.Add(member);
}
else
{
member.IsFocused = "1";
member.FocusTime = now;
memberBLL.Update(member);
}
};
port.UnSubscribe += (openID) => {
DateTime now = DateTime.Now;
Model.TD_WeiXin_Member member = memberBLL.GetModelByOpenID(openID);
if (member != null)
{
member.IsFocused = "0";
member.UnFocusTime = now;
memberBLL.Update(member);
}
};
string response = port.ProcessMessage();
return(Content(response));
}
private static void SignIn(Model.TD_WeiXin_Member model)
{
FormsAuthenticationTicket tk = new FormsAuthenticationTicket(1,
model.MemberID,
DateTime.Now,
DateTime.MaxValue,
true,
"",
System.Web.Security.FormsAuthentication.FormsCookiePath
);
string key = System.Web.Security.FormsAuthentication.Encrypt(tk);
HttpCookie ck = new HttpCookie(System.Web.Security.FormsAuthentication.FormsCookieName, key);
//同一个域名下面的多个站点是否能共享Cookie
//ck.Domain = System.Web.Security.FormsAuthentication.CookieDomain;
HttpContext.Current.Response.Cookies.Add(ck);
}
public override void AddMember(ThirdPortUserInfo userInfo, ActionExecutingContext filterContext)
{
Model.TD_WeiXin_Member member = memberBLL.GetModelByOpenID(userInfo.openid);
if (member == null)
{
member = new Model.TD_WeiXin_Member();
member.MemberID = Guid.NewGuid().ToString();
member.NickName = userInfo.nickname;
member.Sex = (short)userInfo.sex;
member.OpenID = userInfo.openid;
member.Country = userInfo.country;
member.Province = userInfo.province;
member.City = userInfo.province;
member.HeaderImage = userInfo.headimgurl;
member.CreateTime = DateTime.Now;
member.OrgID = int.Parse(DESEncrypt.Decrypt(filterContext.Controller.ViewBag.EnOrgID));
memberBLL.Add(member);
}
MemberData.SignModel(member);
}
public static void SignModel(Model.TD_WeiXin_Member model)
{
AddMember(model);
SignIn(model);
}
public int Update(Model.TD_WeiXin_Member model)
{
return(dal.Update(model));
}
public int Add(Model.TD_WeiXin_Member model)
{
return(dal.Add(model));
}
